From aa6debfa64d54cb68704a784e928d923e66f0eb8 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期六, 28 十二月 2024 13:59:59 +0800 Subject: [PATCH] 临时任务完善 --- pipIrr-platform/pipIrr-web/pipIrr-web-temp/说明.txt | 15 +++++++++------ pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java | 10 +++++++++- pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java | 4 ++++ pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java | 1 + pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml | 10 ++++++++++ 5 files changed, 33 insertions(+), 7 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java index ab8c0f6..a6aba5e 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java @@ -64,7 +64,6 @@ ////////////////////////////////////// //缁熻鐩稿叧 - /** * 鏌ヨ鐢ㄦ按鎴蜂竴涓湀鎵�鏈夋棩鐨勭敤姘撮噺 * @param clientId @@ -75,4 +74,13 @@ List<StClientAmountDay> selectByClientIdAndYearAndMonthAndDay(@Param("clientId")Long clientId, @Param("year")Integer year, @Param("month")Integer month) ; + + ////////////////////////////////////// + //涓存椂浠诲姟鐩稿叧 + + /** + * 鍒犻櫎鍏ㄩ儴 + * @return + */ + int deleteAll() ; } \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml index 0afb8e5..cd1e7c5 100644 --- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml +++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml @@ -1184,6 +1184,9 @@ where id = #{id,jdbcType=BIGINT} </update> + <!-- ////////////////////////////////// --> + <!-- 缁熻鐩稿叧 --> + <!-- ////////////////////////////////// --> <select id="selectByClientIdAndYearAndMonthAndDay" resultType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay"> select <include refid="Base_Column_List" /> @@ -1192,4 +1195,11 @@ and year = #{year,jdbcType=INTEGER} and month = #{month,jdbcType=INTEGER} </select> + + <!-- ////////////////////////////////// --> + <!-- 涓存椂浠诲姟鐩稿叧 --> + <!-- ////////////////////////////////// --> + <delete id="deleteAll"> + delete from st_client_amount_day + </delete> </mapper> \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java index c4b98e4..34ca128 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java @@ -44,6 +44,10 @@ private static final int[][] yearMonthGrp = {{2024, 9}, {2024, 10}, {2024, 11}, {2024, 12}, {2025, 1}, {2025, 2}, {2025, 3}, {2025, 4}}; + public void deleteAllStClientAmountDay() throws Exception { + stClientAmountDayDao.deleteAll() ; + } + /** * 杞瓨鍐滄埛鏃ュ彇姘撮噺锛岀敱绾靛瀷鏀逛负妯瀷 * diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java index 1553574..bbc02b7 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java @@ -38,6 +38,7 @@ @GetMapping(path = "transSaveClientAmountDay") @SsoAop() public BaseResponse<Boolean> transSaveClientAmountDay() throws Exception{ + this.stSomeClientAmountSv.deleteAllStClientAmountDay(); this.stSomeClientAmountSv.transSaveClientAmountDay(); return BaseResponseUtils.buildSuccess(true); } diff --git "a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/\350\257\264\346\230\216.txt" "b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/\350\257\264\346\230\216.txt" index 5d6ecb1..1c6f708 100644 --- "a/pipIrr-platform/pipIrr-web/pipIrr-web-temp/\350\257\264\346\230\216.txt" +++ "b/pipIrr-platform/pipIrr-web/pipIrr-web-temp/\350\257\264\346\230\216.txt" @@ -4,23 +4,26 @@ 鎵ц鍔熻兘锛� 0銆佹祴璇� /temp/test/doSome -1銆佸垹闄や竴浜涙紡鎹熺粺璁�---閲嶅鏁版嵁 +1銆佸垹闄や竴浜涙紡鎹熺粺璁�---閲嶅鏁版嵁锛堟墽琛屼竴娆★級 /temp/delSome/deleteSomeStatisticLossAmount -2銆佸垹闄や竴浜涘彇姘村彛缁熻---閲嶅鏁版嵁 +2銆佸垹闄や竴浜涘彇姘村彛缁熻---閲嶅鏁版嵁锛堟墽琛屼竴娆★級 /temp/delSome/deleteSomeStatisticIntakeAmount -3銆佸垹闄や竴浜涘啘鎴风粺璁�---閲嶅鏁版嵁 +3銆佸垹闄や竴浜涘啘鎴风粺璁�---閲嶅鏁版嵁锛堟墽琛屼竴娆★級 /temp/delSome/deleteSomeStatisticClientAmount -4銆佷慨鏀逛竴浜涘彇姘村彛鏃ュ彇姘撮噺缁熻---鍥燫TU涓�澶╁唴鏁寸偣鎶ヤ腑绱娴侀噺闂存瓏鍑虹幇0鍊硷紝涓ゆ涓婃姤绱娴侀噺宸�间細浜х敓澶у�� +4銆佷慨鏀逛竴浜涘彇姘村彛鏃ュ彇姘撮噺缁熻---鍥燫TU涓�澶╁唴鏁寸偣鎶ヤ腑绱娴侀噺闂存瓏鍑虹幇0鍊硷紝涓ゆ涓婃姤绱娴侀噺宸�间細浜х敓澶у�硷紙鎵ц涓�娆★級 /temp/chSome/changeSomeIntakeDayAmount 5銆侀噸鏂扮粺璁″彇姘村彛鏈堝彇姘撮噺 /temp/chSome/reStatisticsAllIntakeMonthAmount 6銆侀噸鏂扮粺璁″彇姘村彛骞村彇姘撮噺 /temp/chSome/reStatisticsAllIntakeYearAmount -7銆佷慨鏀逛竴浜涘彇姘村彛鏃ユ紡鎹熼噺缁熻---鍥犱负鏂板畨瑁呮按閲忥紝琛ㄥ簳鍊兼瘮杈冨ぇ +7銆佷慨鏀逛竴浜涘彇姘村彛鏃ユ紡鎹熼噺缁熻---鍥犱负鏂板畨瑁呮按閲忥紝琛ㄥ簳鍊兼瘮杈冨ぇ锛堟墽琛屼竴娆★級 /temp/chSome/changeSomeIntakeDayLoss 8銆侀噸鏂扮粺璁″彇姘村彛鏈堟紡鎹熼噺 /temp/chSome/reStatisticsAllIntakeMonthLoss 9銆侀噸鏂扮粺璁″彇姘村彛骞存紡鎹熼噺 -/temp/chSome/reStatisticsAllIntakeYearLoss \ No newline at end of file +/temp/chSome/reStatisticsAllIntakeYearLoss + + +10 \ No newline at end of file -- Gitblit v1.8.0