From 30c3d4510aa688dbcaa8797517b6bcd06c61aaaa Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 19 May 2022 17:47:36 +0800
Subject: [PATCH] 新增农事查询统计接口
---
src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java | 9 +++++++++
src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml | 7 +++++++
src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java | 6 ++++++
src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java | 6 ++++++
src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java | 10 ++++++++++
5 files changed, 38 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java b/src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java
index abb4766..8a7e725 100644
--- a/src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java
+++ b/src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java
@@ -122,4 +122,13 @@
return R.status(farmService.removeByIds(Func.toLongList(ids)));
}
+ /**
+ * 查询统计本年农事记录操作总数
+ * @return
+ */
+ @GetMapping("/getFarmingCount")
+ public R getFarmingCount(){
+ return R.data(farmService.getFarmingCount());
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java b/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java
index dd20fb3..7446acf 100644
--- a/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java
+++ b/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java
@@ -39,4 +39,10 @@
* @return
*/
List<FarmingRecordVO> selectFarmingRecordPage(@Param("page") IPage page,@Param("farmingRecord") FarmingRecordVO farm);
+
+ /**
+ * 查询统计本年农事记录操作总数
+ * @return
+ */
+ Integer getFarmingCount();
}
diff --git a/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml b/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml
index e7bd370..3ae5804 100644
--- a/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml
+++ b/src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml
@@ -23,4 +23,11 @@
and sfr.operator = #{farmingRecord.operator}
</if>
</select>
+
+ <!--查询统计本年农事记录操作总数-->
+ <select id="getFarmingCount" resultType="java.lang.Integer">
+ select ifnull(count(*),0) count from sys_farming_record
+ where 1=1
+ and YEAR(time)=YEAR(NOW())
+ </select>
</mapper>
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 649b669..44f938c 100644
--- a/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java
+++ b/src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java
@@ -21,4 +21,10 @@
* @return
*/
IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm);
+
+ /**
+ * 查询统计本年农事记录操作总数
+ * @return
+ */
+ Object getFarmingCount();
}
diff --git a/src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java b/src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java
index ecdbb73..a1d4051 100644
--- a/src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java
+++ b/src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java
@@ -25,4 +25,14 @@
public IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm) {
return page.setRecords(baseMapper.selectFarmingRecordPage(page, farm));
}
+
+
+ /**
+ * 查询统计本年农事记录操作总数
+ * @return
+ */
+ @Override
+ public Object getFarmingCount() {
+ return baseMapper.getFarmingCount();
+ }
}
--
Gitblit v1.9.3