1

zhang

17 小时以前 9830ed887f809224be07de7badaaaa0e354aa573

1

 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);



 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);
        }
    }


}

 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