From 9830ed887f809224be07de7badaaaa0e354aa573 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期二, 14 四月 2026 11:23:50 +0800
Subject: [PATCH] 1
---
zy-asc-conveyor/src/main/resources/mapper/JobMapper.xml | 8 ++++++++
zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/mapper/JobMapper.java | 2 ++
zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/scheduler/JobLogScheduler.java | 15 +++++++++++++--
3 files changed, 23 insertions(+), 2 deletions(-)
diff --git a/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/mapper/JobMapper.java b/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/mapper/JobMapper.java
index 76728a7..ee99fbb 100644
--- a/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/mapper/JobMapper.java
+++ b/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/mapper/JobMapper.java
@@ -28,6 +28,8 @@
List<Job> listJobByJobStsAndDay(@Param("jobSts") Integer jobSts, @Param("day") Integer day);
+ List<Job> listJobByDay(@Param("day") Integer day);
+
List<Job> listJobToLog(@Param("jobSts") Integer jobSts, @Param("day") Integer day);
diff --git a/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/scheduler/JobLogScheduler.java b/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/scheduler/JobLogScheduler.java
index 1f37aa8..3d764c4 100644
--- a/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/scheduler/JobLogScheduler.java
+++ b/zy-asc-conveyor/src/main/java/com/zy/acs/conveyor/scheduler/JobLogScheduler.java
@@ -29,13 +29,24 @@
private CtuServiceProperties properties;
- //@Scheduled(cron = "0 0 2 * * ?")
- @Scheduled(cron = "*/5 * * * * ?")
+ //@Scheduled(cron = "*/5 * * * * ?")
+ @Scheduled(cron = "0 0 1 * * ?")
public void autoToLog() {
List<Job> jobs = jobMapper.listJobByJobStsAndDay(ConveyorStateType.CLEARSIGNAL.getStatus(), 1);
for (Job job : jobs) {
jobService.saveJobLog(job);
}
+
}
+
+ @Scheduled(cron = "0 0 2 * * ?")
+ public void delToLog() {
+ List<Job> jobByDay = jobMapper.listJobByDay(90);
+ for (Job job :jobByDay) {
+ jobService.saveJobLog(job);
+ }
+ }
+
+
}
diff --git a/zy-asc-conveyor/src/main/resources/mapper/JobMapper.xml b/zy-asc-conveyor/src/main/resources/mapper/JobMapper.xml
index e41af27..3981183 100644
--- a/zy-asc-conveyor/src/main/resources/mapper/JobMapper.xml
+++ b/zy-asc-conveyor/src/main/resources/mapper/JobMapper.xml
@@ -79,6 +79,14 @@
</select>
+ <select id="listJobByDay" resultMap="BaseResultMap">
+ select *
+ from cv_job
+ where
+ DATEDIFF(NOW(), create_time) > #{day}
+ </select>
+
+
<select id="listJobToLog" resultMap="BaseResultMap">
select *
from cv_job
--
Gitblit v1.9.1