| | |
| | | job.setIsdeleted(Constants.ZERO); |
| | | job.setType(Constants.platformJobType.wxcxh);//默认是外协车卸货 |
| | | job.setStatus(Constants.PlatformJobStatus.WAIT_CONFIRM.getKey());//默认待确认状态 |
| | | //查询车辆是否自有车,以及jobNum表示但求作业数量(非已离园的作业数) |
| | | Cars car = carsMapper.selectOne(new QueryWrapper<Cars>() |
| | | .select("*,(select count(1) from platform_job b where b.plate_num='"+param.getPlateNumber()+"' and b.status in("+ |
| | | Constants.PlatformJobStatus.LEAVED+")) as jobNum") |
| | |
| | | job.setIsdeleted(Constants.ZERO); |
| | | job.setType(Constants.platformJobType.wxczh);//默认是外协车装好 |
| | | job.setStatus(Constants.PlatformJobStatus.WAIT_CONFIRM.getKey());//默认待确认状态 |
| | | //查询车辆是否自有车,以及jobNum表示但求作业数量(非已离园的作业数) |
| | | Cars car = carsMapper.selectOne(new QueryWrapper<Cars>() |
| | | .select("*,(select count(1) from platform_job b where b.plate_num='"+param.getPlateNumber()+"' and b.status in("+ |
| | | Constants.PlatformJobStatus.LEAVED+")) as jobNum") |