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/lang/mapper/LandMapper.java | 46 +++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 41 insertions(+), 5 deletions(-)
diff --git a/src/main/java/org/springblade/modules/lang/mapper/LandMapper.java b/src/main/java/org/springblade/modules/lang/mapper/LandMapper.java
index c16f311..8ab85b5 100644
--- a/src/main/java/org/springblade/modules/lang/mapper/LandMapper.java
+++ b/src/main/java/org/springblade/modules/lang/mapper/LandMapper.java
@@ -49,20 +49,56 @@
* @return
*/
boolean saveLandInfo(@Param("land") Land land);
+
/**
* 详情信息（自定义查询)
+ * @param land
* @return
*/
Land getLandInfo(@Param("land") LandVO land);
+
/**
* 更新地块信息
- * @param farm
+ * @param land
* @return
*/
int updateLandById(@Param("land") Land land);
+ int updateLandAr(@Param("land") Land land);
+
List selectLandList(String userid);
- List selectNum(String deptId);
- List<Map<String, Object>> selectZAre(String deptId);
- List<Map<String, Object>> selectSAre(String deptId);
- List<Map<String, Object>> selectWAre(String deptId);
+
+ List selectNum(@Param("land") LandVO land);
+
+ List<Map<String, Object>> selectZAre(@Param("land") LandVO land);
+
+ List<Map<String, Object>> selectSAre(@Param("land") LandVO land);
+
+ List<Map<String, Object>> selectWAre(@Param("land") LandVO land);
+
+ /**
+ * 地块列表（不分页）
+ * @param land
+ * @return
+ */
+ List<LandVO> getLandList(@Param("land") LandVO land);
+
+ /**
+ * 查询统计地块是否有轮廓（是否有圈出区域）
+ * @param land 地块参数
+ * @return
+ */
+ List<Integer> getLandIsAreaStatistic(@Param("land") LandVO land);
+
+ /**
+ * 根据品种查询对应地块
+ * @param strainId 品种id
+ * @return
+ */
+ List<LandVO> selectByStrainId(@Param("strainId") String strainId,@Param("farmId") String farmId);
+
+ List<Land> getByStrainIdFarmId(@Param("land")LandVO land);
+
+ List<LandVO> findPlantInLand(String ids);
+
+ List<LandVO> selectRecoveryLandList(@Param("farmId") String farmId);
}
--
Gitblit v1.9.3