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