From dd6e29aba4f614f236cf60aca4aa972a51a8dfb5 Mon Sep 17 00:00:00 2001 From: wuzeyu <1223318623@qq.com> Date: 星期一, 30 十二月 2024 11:54:43 +0800 Subject: [PATCH] Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV --- pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmountSv.java | 345 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 345 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmountSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmountSv.java new file mode 100644 index 0000000..52f52f4 --- /dev/null +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmountSv.java @@ -0,0 +1,345 @@ +package com.dy.pipIrrStatistics.statistics; + +import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayMapper; +import com.dy.pipIrrGlobal.daoSt.StClientAmountDayMapper; +import com.dy.pipIrrGlobal.daoSt.StClientAmountMonthMapper; +import com.dy.pipIrrGlobal.daoSt.StClientAmountYearMapper; +import com.dy.pipIrrGlobal.pojoSt.*; +import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics; +import com.dy.pipIrrGlobal.voSt.VoClientConsumeStatistics; +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 16:28 + * @Description + */ +@Component +public class StClientAmountSv { + + @Autowired + protected RmClientAmountDayMapper rmClientAmountDayDao; + + @Autowired + protected StClientAmountDayMapper stClientAmountDayDao; + + @Autowired + protected StClientAmountMonthMapper stClientAmountMonthDao ; + + @Autowired + protected StClientAmountYearMapper stClientAmountYearDao ; + + /** + * 鏃ョ粺璁�---鍐滄埛鐢ㄦ按閲忓強閲戦锛岀敱绾靛瀷鏁版嵁鏀规垚琛屽瀷鏁版嵁 + */ + @Transactional + protected void statisticsDay(Integer statisticsYear, Integer statisticsMonth, Integer statisticsDay, Long statisticsStartId, Long statisticsEndId){ + List<VoClientAmountStatistics> list = rmClientAmountDayDao.statisticsByClient(statisticsStartId, statisticsEndId) ; + if(list != null && list.size() > 0){ + for(VoClientAmountStatistics vo : list){ + List<StClientAmountDay> listOfDay = stClientAmountDayDao.selectByClientIdAndYearAndMonthAndDay(vo.clientId, statisticsYear, statisticsMonth) ; + StClientAmountDay po = null ; + if(listOfDay != null && listOfDay.size() > 0){ + //绋嬪簭閫昏緫鎺у埗涓婏紝闆嗗悎涓彧鏈変竴涓璞� + po = listOfDay.get(0) ; + } + if(po == null){ + po = new StClientAmountDay() ; + po.clientId = vo.clientId ; + po.year = statisticsYear ; + po.month = statisticsMonth ; + } + this.setValueOfDayOfMonth(statisticsDay, vo, po); + if(po.id == null) { + stClientAmountDayDao.insert(po); + }else{ + stClientAmountDayDao.updateByPrimaryKeySelective(po) ; + } + } + } + } + + /** + * 鏈堢粺璁�---鍐滄埛鐢ㄦ按閲忓強閲戦 + */ + @Transactional + protected void statisticsMonth(Integer statisticsYear, Integer statisticsMonth, Long statisticsStartId, Long statisticsEndId){ + List<VoClientAmountStatistics> list = rmClientAmountDayDao.statisticsByClient(statisticsStartId, statisticsEndId) ; + if(list != null && list.size() > 0){ + for(VoClientAmountStatistics vo : list){ + List<StClientAmountMonth> listOfMonth = stClientAmountMonthDao.selectByClientIdAndYearAndMonth(vo.clientId, statisticsYear, statisticsMonth) ; + StClientAmountMonth po = null ; + if(listOfMonth != null && listOfMonth.size() > 0){ + //绋嬪簭閫昏緫鎺у埗涓婏紝闆嗗悎涓彧鏈変竴涓璞� + po = listOfMonth.get(0) ; + } + if(po == null) { + po = new StClientAmountMonth(); + } + po.clientId = vo.clientId ; + po.year = statisticsYear ; + po.month = statisticsMonth ; + po.amount = vo.amount; + po.money = vo.money ; + if(po.id == null) { + stClientAmountMonthDao.insert(po); + }else{ + stClientAmountMonthDao.updateByPrimaryKey(po) ; + } + } + } + } + + /** + * 骞寸粺璁�---鍐滄埛鐢ㄦ按閲忓強閲戦 + */ + @Transactional + protected void statisticsYear(Integer statisticsYear){ + List<VoClientAmountStatistics> list = stClientAmountMonthDao.statisticsByClient(statisticsYear) ; + if(list != null && list.size() > 0){ + for(VoClientAmountStatistics vo : list){ + List<StClientAmountYear> listOfYear = stClientAmountYearDao.selectByClientIdAndYear(vo.clientId, statisticsYear) ; + StClientAmountYear po = null ; + if(listOfYear != null && listOfYear.size() > 0){ + //绋嬪簭閫昏緫鎺у埗涓婏紝闆嗗悎涓彧鏈変竴涓璞� + po = listOfYear.get(0) ; + } + if(po == null) { + po = new StClientAmountYear(); + } + po.clientId = vo.clientId ; + po.year = statisticsYear ; + po.amount = vo.amount; + po.money = vo.money ; + if(po.id == null) { + stClientAmountYearDao.insert(po); + }else{ + stClientAmountYearDao.updateByPrimaryKey(po) ; + } + } + } + } + + + private void setValueOfDayOfMonth(Integer statisticsDay, VoClientAmountStatistics vo, StClientAmountDay po){ + switch (statisticsDay) { + case 1: + po.amount1 = vo.amount; + po.money1 = vo.money; + po.times1 = vo.times; + break; + case 2: + po.amount2 = vo.amount; + po.money2 = vo.money; + po.times2 = vo.times; + break; + case 3: + po.amount3 = vo.amount; + po.money3 = vo.money; + po.times3 = vo.times; + break; + case 4: + po.amount4 = vo.amount; + po.money4 = vo.money; + po.times4 = vo.times; + break; + case 5: + po.amount5 = vo.amount; + po.money5 = vo.money; + po.times5 = vo.times; + break; + case 6: + po.amount6 = vo.amount; + po.money6 = vo.money; + po.times6 = vo.times; + break; + case 7: + po.amount7 = vo.amount; + po.money7 = vo.money; + po.times7 = vo.times; + break; + case 8: + po.amount8 = vo.amount; + po.money8 = vo.money; + po.times8 = vo.times; + break; + case 9: + po.amount9 = vo.amount; + po.money9 = vo.money; + po.times9 = vo.times; + break; + case 10: + po.amount10 = vo.amount; + po.money10 = vo.money; + po.times10 = vo.times; + break; + case 11: + po.amount11 = vo.amount; + po.money11 = vo.money; + po.times11 = vo.times; + break; + case 12: + po.amount12 = vo.amount; + po.money12 = vo.money; + po.times12 = vo.times; + break; + case 13: + po.amount13 = vo.amount; + po.money13 = vo.money; + po.times13 = vo.times; + break; + case 14: + po.amount14 = vo.amount; + po.money14 = vo.money; + po.times14 = vo.times; + break; + case 15: + po.amount15 = vo.amount; + po.money15 = vo.money; + po.times15 = vo.times; + break; + case 16: + po.amount16 = vo.amount; + po.money16 = vo.money; + po.times16 = vo.times; + break; + case 17: + po.amount17 = vo.amount; + po.money17 = vo.money; + po.times17 = vo.times; + break; + case 18: + po.amount18 = vo.amount; + po.money18 = vo.money; + po.times18 = vo.times; + break; + case 19: + po.amount19 = vo.amount; + po.money19 = vo.money; + po.times19 = vo.times; + break; + case 20: + po.amount20 = vo.amount; + po.money20 = vo.money; + po.times20 = vo.times; + break; + case 21: + po.amount21 = vo.amount; + po.money21 = vo.money; + po.times21 = vo.times; + break; + case 22: + po.amount22 = vo.amount; + po.money22 = vo.money; + po.times22 = vo.times; + break; + case 23: + po.amount23 = vo.amount; + po.money23 = vo.money; + po.times23 = vo.times; + break; + case 24: + po.amount24 = vo.amount; + po.money24 = vo.money; + po.times24 = vo.times; + break; + case 25: + po.amount25 = vo.amount; + po.money25 = vo.money; + po.times25 = vo.times; + break; + case 26: + po.amount26 = vo.amount; + po.money26 = vo.money; + po.times26 = vo.times; + break; + case 27: + po.amount27 = vo.amount; + po.money27 = vo.money; + po.times27 = vo.times; + break; + case 28: + po.amount28 = vo.amount; + po.money28 = vo.money; + po.times28 = vo.times; + break; + case 29: + po.amount29 = vo.amount; + po.money29 = vo.money; + po.times29 = vo.times; + break; + case 30: + po.amount30 = vo.amount; + po.money30 = vo.money; + po.times30 = vo.times; + break; + case 31: + po.amount31 = vo.amount; + po.money31 = vo.money; + po.times31 = vo.times; + break; + } + } + + private void setValueOfMonthOfYear(Integer statisticsMonth, VoClientConsumeStatistics vo, StConsumeClientMonth po){ + switch (statisticsMonth) { + case 1: + po.amount1 = vo.money; + po.times1 = vo.times; + break; + case 2: + po.amount2 = vo.money; + po.times2 = vo.times; + break; + case 3: + po.amount3 = vo.money; + po.times3 = vo.times; + break; + case 4: + po.amount4 = vo.money; + po.times4 = vo.times; + break; + case 5: + po.amount5 = vo.money; + po.times5 = vo.times; + break; + case 6: + po.amount6 = vo.money; + po.times6 = vo.times; + break; + case 7: + po.amount7 = vo.money; + po.times7 = vo.times; + break; + case 8: + po.amount8 = vo.money; + po.times8 = vo.times; + break; + case 9: + po.amount9 = vo.money; + po.times9 = vo.times; + break; + case 10: + po.amount10 = vo.money; + po.times10 = vo.times; + break; + case 11: + po.amount11 = vo.money; + po.times11 = vo.times; + break; + case 12: + po.amount12 = vo.money; + po.times12 = vo.times; + break; + } + } + + private void setValueOfYear(VoClientConsumeStatistics vo, StConsumeClientYear po){ + po.amount = vo.money; + po.times = vo.times; + } +} -- Gitblit v1.8.0