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/farmplant/mapper/FarmPlantMapper.java | 45 ++++++++++++++++++++++++++++++++++++++-------
1 files changed, 38 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.java b/src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.java
index a893ac1..33d4b17 100644
--- a/src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.java
+++ b/src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.java
@@ -9,11 +9,13 @@
import org.springblade.modules.farmplant.vo.StrainVO;
import java.util.List;
+import java.util.Map;
/**
- * 农产品种植记录表Mapper 接口
- * @since 2022-05-12
+ * 农产品种植记录表Mapper 接口
+ *
* @author zhongrj
+ * @since 2022-05-12
*/
public interface FarmPlantMapper extends BaseMapper<FarmPlant> {
@@ -24,28 +26,57 @@
* @param farm
* @return
*/
- List<FarmPlantVO> selectFarmPlantPage(@Param("page") IPage page,@Param("farmPlant") FarmPlantVO farm);
+ List<FarmPlantVO> selectFarmPlantPage(@Param("page") IPage page, @Param("farmPlant") FarmPlantVO farm);
+ IPage<FarmPlantVO> selectFarmPlantPageCount(IPage<Object> page, FarmPlantVO farmPlant);
+ IPage<FarmPlantVO> selectFarmPlantPageCountYM(IPage<Object> page, FarmPlantVO farmPlant);
+ List<FarmPlantVO> getFarmPlantStatisticsCountz(@Param("page") IPage page, @Param("farmPlant") FarmPlantVO farm);
/**
- *
* @param page
* @param farm
* @return
*/
- List<FarmPlantVO> getFarmPlantStatistics(@Param("page") IPage<FarmPlantVO> page,@Param("farmPlant") FarmPlantVO farm);
+ List<FarmPlantVO> getFarmPlantStatistics(@Param("page") IPage<FarmPlantVO> page, @Param("farmPlant") FarmPlantVO farm);
/**
* 农产品列表
+ *
* @param farm 农产品对象
* @return
*/
- List<Strain> strainTree(@Param("farm") FarmPlantVO farm);
+ List<Strain> strainTree(@Param("farm") FarmPlantVO farm);
/**
* 统计查询种植面积
- * @param farm
+ *
+ * @param farm
* @return
*/
List<FarmPlantVO> getFarmPlantStatisticsCount(@Param("farmPlant") FarmPlantVO farm);
+
+ int selectCount(@Param("farmPlant") FarmPlantVO farm);
+
+ Map selectPlant(String code, String time);
+
+ Map selectPlantl(String code, String time);
+
+ Map selectPlantw(String code, String time);
+
+ Map selectPlantp(String code, String time);
+
+ Map selectProduct(String code, String time);
+ Map selectProducty(String code, String time);
+ Map selectProductr(String code, String time);
+ Map selectProducts(String code, String time);
+ Map selectProductf(String code, String time);
+
+ /**
+ * 查询种养记录列表（不分页）
+ * @param farmPlant
+ * @return
+ */
+ List<FarmPlantVO> getFarmPlantList(@Param("farmPlant") FarmPlantVO farmPlant);
+
+ List<FarmPlantVO> getFarmPlantYMList(@Param("farmPlant") FarmPlantVO farmPlant);
}
--
Gitblit v1.9.3