From a0a9fc7a58a39626a395d2760194641726e1cd35 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 25 四月 2025 10:48:15 +0800
Subject: [PATCH] 1、微信小程序后端轮灌迟延时长改为可配置的; 2、微信小程序查询取水口接口实现修改,改为后端模糊查询;

---
 pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StLossAmountSv.java |   90 +++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 90 insertions(+), 0 deletions(-)

diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StLossAmountSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StLossAmountSv.java
new file mode 100644
index 0000000..5e83be1
--- /dev/null
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StLossAmountSv.java
@@ -0,0 +1,90 @@
+package com.dy.pipIrrStatistics.statistics;
+
+import com.dy.pipIrrGlobal.daoRm.RmLossDayMapper;
+import com.dy.pipIrrGlobal.daoSt.StLossMonthMapper;
+import com.dy.pipIrrGlobal.daoSt.StLossYearMapper;
+import com.dy.pipIrrGlobal.pojoSt.StLossMonth;
+import com.dy.pipIrrGlobal.pojoSt.StLossYear;
+import com.dy.pipIrrGlobal.voSt.VoIntakeLossStatistics;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Component;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @Author: liurunyu
+ * @Date: 2024/7/24 11:24
+ * @Description
+ */
+@Component
+public class StLossAmountSv {
+
+    @Autowired
+    protected RmLossDayMapper rmLossDayDao;
+
+    @Autowired
+    protected StLossMonthMapper stLossMonthDao ;
+
+    @Autowired
+    protected StLossYearMapper stLossYearDao ;
+
+    /**
+     * 鏈堢粺璁�---婕忔崯
+     */
+    @Transactional
+    protected void statisticsMonth(Integer statisticsYear, Integer statisticsMonth, Long statisticsStartId, Long statisticsEndId){
+        List<VoIntakeLossStatistics> list = rmLossDayDao.statisticsByIntake(statisticsStartId, statisticsEndId) ;
+        if(list != null && list.size() > 0){
+            for(VoIntakeLossStatistics vo : list){
+                List<StLossMonth> listOfMonth = this.stLossMonthDao.selectByIntakeIdAndYearAndMonth(vo.intakeId, statisticsYear, statisticsMonth) ;
+                StLossMonth po = null ;
+                if (listOfMonth != null && listOfMonth.size() > 0){
+                    //绋嬪簭閫昏緫鎺у埗涓婏紝闆嗗悎涓彧鏈変竴涓璞�
+                    po = listOfMonth.get(0) ;
+                }
+                if(po == null){
+                    po = new StLossMonth() ;
+                }
+                po.intakeId = vo.intakeId ;
+                po.year = statisticsYear ;
+                po.month = statisticsMonth ;
+                po.amount = vo.amount;
+                if(po.id == null) {
+                    stLossMonthDao.insert(po);
+                }else{
+                    stLossMonthDao.updateByPrimaryKey(po) ;
+                }
+            }
+        }
+    }
+
+    /**
+     * 骞寸粺璁�---婕忔崯
+     */
+    @Transactional
+    protected void statisticsYear(Integer statisticsYear){
+        List<VoIntakeLossStatistics> list = stLossMonthDao.statisticsByIntake(statisticsYear) ;
+        if(list != null && list.size() > 0){
+            for(VoIntakeLossStatistics vo : list){
+                List<StLossYear> listOfYear = this.stLossYearDao.selectByIntakeIdAndYear(vo.intakeId, statisticsYear) ;
+                StLossYear po = null ;
+                if(listOfYear != null && listOfYear.size() > 0){
+                    //绋嬪簭閫昏緫鎺у埗涓婏紝闆嗗悎涓彧鏈変竴涓璞�
+                    po = listOfYear.get(0) ;
+                }
+                if(po == null) {
+                    po = new StLossYear();
+                }
+                po.intakeId = vo.intakeId ;
+                po.year = statisticsYear ;
+                po.amount = vo.amount;
+                if(po.id == null) {
+                    stLossYearDao.insert(po);
+                }else{
+                    stLossYearDao.updateByPrimaryKey(po) ;
+                }
+            }
+        }
+    }
+}

--
Gitblit v1.8.0