From 590a64af2cdd33427ed8eda2eb983b07dd60ab8b Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期五, 16 一月 2026 12:05:12 +0800
Subject: [PATCH] #
---
zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java | 35 +++++++++++++++++++++++++++++------
1 files changed, 29 insertions(+), 6 deletions(-)
diff --git a/zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java b/zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java
index ec7c2bf..c8a2c3e 100644
--- a/zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java
+++ b/zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java
@@ -5,6 +5,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.scheduling.annotation.Scheduled;
+import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
import java.util.Optional;
@@ -13,7 +14,7 @@
* Created by vincent on 5/8/2024
*/
@Slf4j
-//@Component
+@Component
@SuppressWarnings("all")
public class LogDataScheduler {
@@ -26,11 +27,13 @@
@Transactional
public void syncLog() {
Integer dataExpiredDays = Optional.ofNullable(configService.getVal("dataExpiredDays", Integer.class)).orElse(7);
- this.syncTaskLog(dataExpiredDays);
- this.syncActionLog(dataExpiredDays);
- this.syncSegmentLog(dataExpiredDays);
- this.syncJamLog(dataExpiredDays);
- this.syncTravelLog(dataExpiredDays);
+ if (dataExpiredDays > 0) {
+ this.syncTaskLog(dataExpiredDays);
+ this.syncActionLog(dataExpiredDays);
+ this.syncSegmentLog(dataExpiredDays);
+ this.syncJamLog(dataExpiredDays);
+ this.syncTravelLog(dataExpiredDays);
+ }
}
public void syncTaskLog(Integer dataExpiredDays){
@@ -129,4 +132,24 @@
}
}
+
+ public void syncStaReserveLog(Integer dataExpiredDays){
+ try {
+ String insertSql = "INSERT INTO man_sta_reserve_log " +
+ "SELECT * FROM man_sta_reserve " +
+ "WHERE create_time < NOW() - INTERVAL "+ dataExpiredDays +" DAY";
+ int rowsInserted = jdbcTemplate.update(insertSql);
+ log.info("Inserted {} rows into man_sta_reserve_log", rowsInserted);
+
+ String deleteSql = "DELETE FROM man_sta_reserve " +
+ "WHERE create_time < NOW() - INTERVAL "+ dataExpiredDays +" DAY";
+ int rowsDeleted = jdbcTemplate.update(deleteSql);
+ log.info("Deleted {} rows from man_sta_reserve", rowsDeleted);
+
+ } catch (Exception e) {
+ log.error("Error occurred while syncing sta reserve log: {}", e.getMessage());
+ throw e;
+ }
+ }
+
}
--
Gitblit v1.9.1