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