From 595b66ae8800511fab34e503f94d173613088c08 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期六, 01 三月 2025 09:57:38 +0800
Subject: [PATCH] 1、表阀一体机新协议开阀报关阀报数据处理逻辑修改； 2、农户月用水统计查询中，缺少农户姓名，进行SQL修改。
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java | 55 +++++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 43 insertions(+), 12 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java
index e60a3b0..1af5eda 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java
@@ -1,20 +1,23 @@
package com.dy.pipIrrGlobal.daoSt;
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoSt.StClientAmountYear;
-import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear;
+import com.dy.pipIrrGlobal.voSt.VoStClientAmountYearRecord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import java.util.List;
+import java.util.Map;
+
/**
* @Author: liurunyu
- * @Date: 2024/7/24 17:03
+ * @Date: 2024/12/30 9:21
* @Description
*/
@Mapper
-public interface StClientAmountYearMapper extends BaseMapper<StClientAmountYear> {
+public interface StClientAmountYearMapper {
/**
* delete by primary key
+ *
* @param id primaryKey
* @return deleteCount
*/
@@ -22,6 +25,7 @@
/**
* insert record to table
+ *
* @param record the record
* @return insert count
*/
@@ -29,6 +33,7 @@
/**
* insert record to table selective
+ *
* @param record the record
* @return insert count
*/
@@ -36,21 +41,15 @@
/**
* select by primary key
+ *
* @param id primary key
* @return object by primary key
*/
StClientAmountYear selectByPrimaryKey(Long id);
/**
- * 鏌ヨ鏌愬勾鏌愬彇姘村彛鐨勫勾鏌愰噺鍊�
- * @param clientId 鍐滄埛ID
- * @param year 鏌愬勾
- * @return
- */
- StClientAmountYear selectByClientIdAndYear(@Param("clientId")Long clientId, @Param("year")Integer year) ;
-
- /**
* update record selective
+ *
* @param record the updated record
* @return update count
*/
@@ -58,8 +57,40 @@
/**
* update record
+ *
* @param record the updated record
* @return update count
*/
int updateByPrimaryKey(StClientAmountYear record);
+
+
+
+ //////////////////////////////////////
+ //鏌ヨ缁熻缁撴灉
+ /**
+ * 鏌ヨ鎬绘暟閲�
+ * @param params
+ * @return
+ */
+ Long selectCountYearStatistics(Map<?, ?> params) ;
+ /**
+ * 鏌ヨ鍒嗛〉鏁版嵁
+ * @param params
+ * @return
+ */
+ List<VoStClientAmountYearRecord> selectYearStatistics(Map<?, ?> params) ;
+
+ //////////////////////////////////////
+ //缁熻鐩稿叧
+ /**
+ * 鏌ヨ鏌愬勾 鏌愰噺鍊�
+ *
+ * @param year 鏌愬勾
+ * @return
+ */
+ List<StClientAmountYear> selectByYear(@Param("year") Integer year);
+
+ /////////////////////////////////////
+ //涓存椂浠诲姟
+ int deleteAll() ;
}
\ No newline at end of file
--
Gitblit v1.8.0