server/visits/admin_timer/src/main/java/com/doumee/api/InterfaceLogTimerController.java
@@ -1,5 +1,7 @@ package com.doumee.api; import com.doumee.dao.business.model.WmsInterfaceLog; import com.doumee.service.business.WmsInterfaceLogService; import com.doumee.service.business.third.model.ApiResponse; import com.doumee.service.business.InterfaceLogService; import com.doumee.service.business.PlatformInterfaceLogService; @@ -22,11 +24,14 @@ @Autowired private InterfaceLogService interfaceLogService; @Autowired private WmsInterfaceLogService wmsInterfaceLogService; @Autowired private PlatformInterfaceLogService platformInterfaceLogService; @ApiOperation("开启定时接口日志清理") @GetMapping("/clearThreeMonthLog") public ApiResponse clearThreeMonthLog() { interfaceLogService.clearThreeMonthLog(); wmsInterfaceLogService.clearThreeMonthLog(); platformInterfaceLogService.clearThreeMonthLog(); return ApiResponse.success("开启定时接口日志清理成功"); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java
@@ -1014,7 +1014,10 @@ .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(),Constants.PlatformJobStatus.CALLED.getKey()) .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey() ,Constants.PlatformJobStatus.LEAVED.getKey() ,Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() ,Constants.PlatformJobStatus.CALLED.getKey()) .apply(" to_days(create_date) <to_days(now())")); //==========今天出入库完成量
