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/farm/service/FarmingRecordService.java |   28 ++++++++++++++++++++++++++--
 1 files changed, 26 insertions(+), 2 deletions(-)

diff --git a/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java b/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java
index cc260e7..205c252 100644
--- a/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java
+++ b/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java
@@ -6,6 +6,8 @@
 import org.apache.ibatis.annotations.Param;
 import org.springblade.modules.farm.entity.FarmingRecord;
 import org.springblade.modules.farm.vo.FarmingRecordVO;
+import org.springblade.modules.recovery.vo.RecoveryVO;
+import org.springblade.modules.traceability.entity.Traceability;
 
 import java.util.List;
 
@@ -24,17 +26,39 @@
 	 * @return
 	 */
 	IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm);
+	IPage<FarmingRecordVO> selectFarmingRecordPageByNz(IPage<FarmingRecordVO> page, FarmingRecordVO farm);
 	List<FarmingRecordVO> selectFarmingRecordPages(FarmingRecordVO farm);
 	/**
 	 * 查询统计本年农事记录操作总数
 	 * @return
 	 */
-	Object getFarmingCount();
+	Object getFarmingCount(String farmId);
 
 	/**
 	 * 查询统计本年农事记录操作,按分类统计
 	 * @return
 	 */
-    Object getFarmingStatis();
+    Object getFarmingStatis(String farmId);
+	//今年农资使用量
+	Double selectJyCount(String deptId);
+	//去年农资使用量
+	Double selectQyCount(String deptId);
+	//本月农资使用量
+	Double selectByCount(String deptId);
 
+	/**
+	 * 查询农事记录信息(种植开始起)
+	 * @param recoveryVO 采收信息
+	 * @return
+	 */
+    List<FarmingRecordVO> getFarmingRecordByFarmPlantId(RecoveryVO recoveryVO);
+
+	/**
+	 * 查询农事操作记录（不分页）
+	 * @param farm
+	 * @return
+	 */
+	List<FarmingRecordVO> getFarmingRecordListfarm(FarmingRecordVO farm);
+
+	FarmingRecordVO getDetails(FarmingRecordVO farmingRecordVO);
 }

--
Gitblit v1.9.3