|  |  | 
 |  |  |                         .select(PlatformJob::getTotalNum) | 
 |  |  |                         .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .eq(PlatformJob::getOrigin,Constants.ONE) | 
 |  |  |                         .in(PlatformJob::getType,new Integer[]{0,2,4}) | 
 |  |  |                         .in(PlatformJob::getStatus, Constants.PlatformJobStatus.DONE.getKey() | 
 |  |  |                                 , Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() | 
 |  |  |                                 , Constants.PlatformJobStatus.LEAVED.getKey()) | 
 |  |  | 
 |  |  |                         .selectAll(PlatformJob.class) | 
 |  |  |                         .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .eq(PlatformJob::getCarCodeFront,param.getCarCode()) | 
 |  |  |                         .in(PlatformJob::getStatus, | 
 |  |  |                         .notIn(PlatformJob::getStatus, | 
 |  |  |                                 Constants.PlatformJobStatus.DONE.getKey(), | 
 |  |  |                                 Constants.PlatformJobStatus.LEAVED.getKey(), | 
 |  |  |                                 Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), | 
 |  |  |                                 Constants.PlatformJobStatus.CALLED.getKey()) | 
 |  |  |                                 Constants.PlatformJobStatus.CANCEL.getKey() | 
 |  |  |                         ) | 
 |  |  |                         .orderByAsc(PlatformJob::getId) | 
 |  |  |                         .last("limit 1")); | 
 |  |  |  | 
 |  |  |         dealJobDetailAndContractBiz(job,data); | 
 |  |  | 
 |  |  |                         .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) | 
 |  |  |                         .select(PlatformJob::getStatus,PlatformJob::getStatus) | 
 |  |  |                         .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .in(PlatformJob::getType,Constants.ONE,Constants.THREE) | 
 |  |  |                         .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(), | 
 |  |  |                                 Constants.PlatformJobStatus.LEAVED.getKey(), | 
 |  |  |                                 Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) | 
 |  |  | 
 |  |  |         List<PlatformJob> jobList = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() | 
 |  |  |                 .selectAll( PlatformJob.class) | 
 |  |  | //                .select("(select sum(ifnull(a.io_qty,0)) from platform_wms_detail a where a.isdeleted=0 and a.job_id =t.id )", create_date) | 
 |  |  |                 .apply("to_days(t.create_date) = to_days(now())") | 
 |  |  |                 .apply("to_days(t.done_date) = to_days(now())") | 
 |  |  |                 .eq(Platform::getIsdeleted, Constants.ZERO) | 
 |  |  |                 .in(PlatformJob::getStatus, Constants.PlatformJobStatus.DONE.getKey() | 
 |  |  |                         , Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() |