#

zjj

4 天以前 ab0193f955b64f5ab8636c46b5d1f0f86fde8806

#

 src/main/java/com/zy/asrs/service/CommandInfoService.java

@@ -19,4 +19,5 @@

    List<CommandInfo> selectCompleteManualCommand();//查询已完成的手动命令

    void clearCommandInfo();
}

 src/main/java/com/zy/asrs/service/impl/CommandInfoServiceImpl.java

@@ -1,12 +1,15 @@
package com.zy.asrs.service.impl;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.zy.asrs.entity.CommandInfoLog;
import com.zy.asrs.entity.TaskWrk;
import com.zy.asrs.mapper.CommandInfoMapper;
import com.zy.asrs.entity.CommandInfo;
import com.zy.asrs.service.CommandInfoLogService;
import com.zy.asrs.service.CommandInfoService;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.service.TaskWrkService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -17,6 +20,10 @@

    @Autowired
    private CommandInfoLogService commandInfoLogService;
    @Autowired
    private TaskWrkService taskWrkService;
    @Autowired
    private CommandInfoService commandInfoService;

    @Override
    public List<CommandInfo> selectByTaskNoAndWrkNo(String taskNo, Integer wrkNo) {
@@ -65,4 +72,16 @@
    public List<CommandInfo> selectCompleteManualCommand() {
        return this.baseMapper.selectCompleteManualCommand();
    }

    @Override
    public void clearCommandInfo() {
        int count = taskWrkService.selectCount(new EntityWrapper<TaskWrk>());
        if (count != 0){
            return;
        }
        int count1 = commandInfoService.selectCount(new EntityWrapper<CommandInfo>());
        if (count1 != 0){
            commandInfoService.delete(new EntityWrapper<>());
        }
    }
}

 src/main/java/com/zy/asrs/task/TaskLogScheduler.java

@@ -244,7 +244,16 @@
        try {
            apiLogService.clearWeekBefore();
        } catch (Exception e) {
            log.error("第三方接口日志自动清除失败（范围：一周之前", e);
            log.error("第三方接口日志自动清除失败（范围：一月之前)", e);
        }
    }

    @Scheduled(cron = "0 0/10 * * * ? ")
    public void clearCommandInfo(){
        try {
            commandInfoService.clearCommandInfo();
        } catch (Exception e) {
            log.error("异常指令自动清除失败（范围：任务表为空时清理", e);
        }
    }


 src/main/resources/mapper/ApiLogMapper.xml

@@ -24,8 +24,7 @@
    <delete id="clearWeekBefore">
        delete from man_api_log
        where 1=1
          and datediff(week,create_time,getdate()) >= 1
          and result != 1
          and datediff(month,create_time,getdate()) >= 1
    </delete>

</mapper>