| | |
|---|
| | | .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())")); |
|---|
| | | |
|---|
| | | //==========今天出入库完成量 |
|---|
