From e609c7adf42ef6eea053ff33a8e59abaf0767df6 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期五, 17 一月 2025 08:54:52 +0800
Subject: [PATCH] 1

---
 src/main/java/com/zy/asrs/task/OrderLogScheduler.java          |    2 +-
 src/main/java/com/zy/asrs/task/OverYearLogScheduler.java       |   10 +++++++++-
 src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java |   15 +++++++++++++++
 3 files changed, 25 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
index 6311642..61c9047 100644
--- a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
+++ b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
@@ -23,7 +23,7 @@
 //    private boolean isERP;
 //
     //@Scheduled(cron = "0/10 * * * * ? ")
-    @Scheduled(fixedDelay = 10000)
+    @Scheduled(fixedDelay = 600000)
     private void execute(){
         List<Order> orders = orderService.selectToBeHistoryOrder();
         if (orders.isEmpty()) {
diff --git a/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java b/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java
index 39652b4..79e42a0 100644
--- a/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java
+++ b/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java
@@ -20,11 +20,19 @@
     private OverYearLogHandler overYearLogHandler;
 
     @Scheduled(cron = "0/1 * * * * ? ")
-    private void execute(){
+    private void execute() {
         ReturnT<String> returnT = overYearLogHandler.start();
         if (!returnT.isSuccess()) {
             log.error(returnT.getMsg());
         }
     }
 
+
+    @Scheduled(cron = "* * 1 * * ? ")
+    private void executeOrderLog() {
+        ReturnT<String> returnT = overYearLogHandler.start2();
+        if (!returnT.isSuccess()) {
+            log.error(returnT.getMsg());
+        }
+    }
 }
diff --git a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
index 62b7596..3c099df 100644
--- a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
@@ -34,4 +34,19 @@
         return SUCCESS;
     }
 
+    @Transactional
+    public ReturnT<String> start2() {
+        try {
+            // 鍒犻櫎鍗婂勾浠ヤ笂鐨勫巻鍙叉。
+            jdbcTemplate.update("delete from man_order_log where dateadd(day,366,create_time) <= getdate();");
+            jdbcTemplate.update("delete from man_order_detl_log where dateadd(day,366,create_time) <= getdate();");
+
+        } catch (Exception e) {
+            e.printStackTrace();
+            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+            return FAIL.setMsg(e.getMessage());
+        }
+        return SUCCESS;
+    }
+
 }

--
Gitblit v1.9.1