#

vincentlu

2026-01-10 1bc33546a044cbc84dd9595c19dbcd9a4e309fc9

 zy-acs-manager/src/main/java/com/zy/acs/manager/core/scheduler/LogDataScheduler.java

@@ -27,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){
@@ -130,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;
        }
    }

}