|  |  |  | 
|---|
|  |  |  | .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc  limit 1  ) as newStartDate  ") | 
|---|
|  |  |  | .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc  limit 1  ) as newCallDate  ") | 
|---|
|  |  |  | .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) | 
|---|
|  |  |  | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) | 
|---|
|  |  |  | .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) | 
|---|
|  |  |  | .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .apply(" ( t1.isdeleted = 0 or t.PLATFORM_ID is null  ) ") | 
|---|
|  |  |  | .in(PlatformJob::getStatus, | 
|---|
|  |  |  | Constants.PlatformJobStatus.WAIT_CALL.getKey(), | 
|---|
|  |  |  | Constants.PlatformJobStatus.IN_WAIT.getKey(), | 
|---|
|  |  |  | 
|---|
|  |  |  | PlatformWorkVO platformWorkVO = PlatformGroupServiceImpl.getPlatformWorkVO(platform,platformJobList); | 
|---|
|  |  |  | platform.setPlatformWorkVO(platformWorkVO); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | for (PlatformGroup platformGroup:platformGroups) { | 
|---|
|  |  |  | platformGroup.setPlatformList(allPlatformList.stream().filter(m->Constants.equalsInteger(m.getGroupId(),platformGroup.getId())).collect(Collectors.toList())); | 
|---|
|  |  |  | for (PlatformGroup platformGroup:platformGroups) { | 
|---|
|  |  |  | platformGroup.setPlatformList(allPlatformList.stream().filter(m->m.getShowConfig()&&Constants.equalsInteger(m.getGroupId(),platformGroup.getId())).collect(Collectors.toList())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | }else{ | 
|---|
|  |  |  | for (PlatformGroup platformGroup:platformGroups) { | 
|---|
|  |  |  | platformGroup.setPlatformList(allPlatformList.stream().filter(m->Constants.equalsInteger(m.getGroupId(),platformGroup.getId())).collect(Collectors.toList())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | return platformGroups; | 
|---|
|  |  |  | } | 
|---|
|  |  |  | 
|---|
|  |  |  | public static PlatformWorkVO getPlatformWorkVO(Platform platform,List<PlatformJob> platformJobList){ | 
|---|
|  |  |  | PlatformWorkVO platformWorkVO = new PlatformWorkVO(); | 
|---|
|  |  |  | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){ | 
|---|
|  |  |  | //获取月台下的所有作业数据 | 
|---|
|  |  |  | //获取月台组下的所有作业数据 | 
|---|
|  |  |  | List<PlatformJob> platformJobs = platformJobList.stream().filter( | 
|---|
|  |  |  | i->Constants.equalsInteger(i.getPlatformId(),platform.getId()) | 
|---|
|  |  |  | || Constants.equalsInteger(i.getPlatformGroupId(),platform.getGroupId()) | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | platformWorkVO.setWaitNum( | 
|---|
|  |  |  | platformJobs.stream().filter(i-> | 
|---|
|  |  |  | Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.TRANSFERING.getKey()) | 
|---|
|  |  |  | ||  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey()) | 
|---|
|  |  |  | Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey()) | 
|---|
|  |  |  | ).collect(Collectors.toList()).size() | 
|---|
|  |  |  | + | 
|---|
|  |  |  | platformJobList.stream().filter(i->Constants.equalsInteger(platform.getId(),i.getPlatformId()) | 
|---|
|  |  |  | && (Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) | 
|---|
|  |  |  | && (Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) ||  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.TRANSFERING.getKey()) | 
|---|
|  |  |  | ) | 
|---|
|  |  |  | ).collect(Collectors.toList()).size() | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | platformWorkVO.setExceptionNum( | 
|---|
|  |  |  | platformJobs.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.EXCEPTION.getKey())).collect(Collectors.toList()).size() | 
|---|
|  |  |  | platformJobs.stream().filter(i->Constants.equalsInteger(platform.getId(),i.getPlatformId()) | 
|---|
|  |  |  | && Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.EXCEPTION.getKey())).collect(Collectors.toList()).size() | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | platformWorkVO.setPlatformJobList(platformJobs.stream().filter( | 
|---|
|  |  |  | i->Constants.equalsInteger(platform.getId(),i.getPlatformId()) && !Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey()) | 
|---|
|  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public PlatformGroupWorkVO getPlatformGroupWork(Integer platformGroupId){ | 
|---|
|  |  |  | PlatformGroupWorkVO platformGroupWorkVO = new PlatformGroupWorkVO(); | 
|---|
|  |  |  | platformGroupWorkVO.setExceptionNum(platformJobJoinMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() | 
|---|
|  |  |  | platformGroupWorkVO.setExceptionNum(platformJobJoinMapper.selectJoinCount(new MPJLambdaWrapper<PlatformJob>() | 
|---|
|  |  |  | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) | 
|---|
|  |  |  | .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(Platform::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(PlatformJob::getPlatformGroupId,platformGroupId) | 
|---|
|  |  |  | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.EXCEPTION.getKey()) | 
|---|
|  |  |  | ) | 
|---|
|  |  |  | ); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | platformGroupWorkVO.setWaitNum(platformJobJoinMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() | 
|---|
|  |  |  | platformGroupWorkVO.setWaitNum(platformJobJoinMapper.selectJoinCount(new MPJLambdaWrapper<PlatformJob>() | 
|---|
|  |  |  | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) | 
|---|
|  |  |  | .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .apply(" ( t1.isdeleted = 0 or t.PLATFORM_ID is null  ) ") | 
|---|
|  |  |  | .eq(PlatformJob::getPlatformGroupId,platformGroupId) | 
|---|
|  |  |  | .and( i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()).or() | 
|---|
|  |  |  | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()).or() | 
|---|
|  |  |  | .apply(" ( status = "+Constants.PlatformJobStatus.TRANSFERING.getKey()+" and PLATFORM_GROUP_ID = "+platformGroupId+" ) ") | 
|---|
|  |  |  | .apply(" ( t.status = "+Constants.PlatformJobStatus.TRANSFERING.getKey()+" and t.PLATFORM_GROUP_ID = "+platformGroupId+" ) ") | 
|---|
|  |  |  | ) | 
|---|
|  |  |  | ) | 
|---|
|  |  |  | ); | 
|---|