From 72b971c98c46531064d74b68fc8fe8864ed0b544 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 08 Nov 2022 09:04:56 +0800
Subject: [PATCH] 大屏溯源统计次数sql修改
---
src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java b/src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java
index 51fb844..791b2ef 100644
--- a/src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java
+++ b/src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java
@@ -16,11 +16,13 @@
*/
package org.springblade.modules.process.mapper;
+import org.apache.ibatis.annotations.Param;
import org.springblade.modules.process.entity.Process;
import org.springblade.modules.process.vo.ProcessVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
+import java.util.Map;
/**
* 加工记录表 Mapper 接口
@@ -37,6 +39,17 @@
* @param process
* @return
*/
- List<ProcessVO> selectProcessPage(IPage page, ProcessVO process);
+ List<ProcessVO> selectProcessPage(IPage page, @Param("process") ProcessVO process);
+ boolean stockCompare(@Param("saleNum") Double saleNum, @Param("proid") String proid);
+
+ Boolean stockReduce(@Param("saleNum") Double saleNum, @Param("proid") String proid);
+
+ Double statistics(@Param("year") String year, @Param("farmId") String farmId);
+
+ List<Map<String, String>> statisticsMonth(@Param("year") String year, @Param("farmId") String farmId);
+
+ List<Map<String, String>> statisticsYear(@Param("year") String year, @Param("farmId") String farmId);
+
+ List<Map<String, String>> statisticsDay(@Param("year") String year, @Param("farmId") String farmId);
}
--
Gitblit v1.9.3