|  |  | 
 |  |  |  | 
 |  |  | import com.doumee.core.constants.ResponseStatus; | 
 |  |  | import com.doumee.core.exception.BusinessException; | 
 |  |  | import com.doumee.core.model.LoginUserInfo; | 
 |  |  | import com.doumee.core.model.PageData; | 
 |  |  | import com.doumee.core.model.PageWrap; | 
 |  |  | import com.doumee.core.wx.wxPlat.WxPlatConstants; | 
 |  |  | import com.doumee.core.wx.wxPlat.WxPlatNotice; | 
 |  |  | import com.doumee.dao.system.SystemUserMapper; | 
 |  |  | import com.doumee.dao.system.model.SystemUser; | 
 |  |  | import com.doumee.service.business.third.model.LoginUserInfo; | 
 |  |  | import com.doumee.service.business.third.model.PageData; | 
 |  |  | import com.doumee.service.business.third.model.PageWrap; | 
 |  |  | import com.doumee.core.utils.Constants; | 
 |  |  | import com.doumee.core.utils.DateUtil; | 
 |  |  | import com.doumee.core.utils.Utils; | 
 |  |  | import com.doumee.dao.business.PlatformGroupMapper; | 
 |  |  | import com.doumee.dao.business.PlatformShowParamMapper; | 
 |  |  | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.metadata.IPage; | 
 |  |  | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; | 
 |  |  | import com.doumee.service.business.PlatformJobService; | 
 |  |  | import com.github.yulichang.wrapper.MPJLambdaWrapper; | 
 |  |  | import lombok.extern.java.Log; | 
 |  |  | import org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.apache.shiro.SecurityUtils; | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | import org.springframework.stereotype.Service; | 
 |  |  | import org.springframework.util.CollectionUtils; | 
 |  |  |  | 
 |  |  | import java.util.Date; | 
 |  |  | import java.util.List; | 
 |  |  | import java.util.Objects; | 
 |  |  | import java.util.*; | 
 |  |  | import java.util.stream.Collectors; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private PlatformGroupMapper platformGroupMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private SystemUserMapper systemUserMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private PlatformJoinMapper platformJoinMapper; | 
 |  |  | 
 |  |  |                 || platformGroup.getType()<0){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         platformGroup.setAutoCall(Constants.formatIntegerNum(platformGroup.getAutoCall())); | 
 |  |  |         platformGroup.setIsVirtual(Constants.formatIntegerNum(platformGroup.getIsVirtual())); | 
 |  |  |         if(platformGroupMapper.selectCount(new QueryWrapper<PlatformGroup>().lambda() | 
 |  |  |                 .eq(PlatformGroup::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(PlatformGroup::getType,platformGroup.getType()) | 
 |  |  |                 .eq(PlatformGroup::getIsVirtual,platformGroup.getIsVirtual()) | 
 |  |  |         )>0){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,该类型分组已经创建,请返回刷新页面查看!"); | 
 |  |  |         } | 
 |  |  | 
 |  |  |             deleteById(id,user); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |     @Override | 
 |  |  |     public void updateAutoCallById(PlatformGroup platform) { | 
 |  |  |         PlatformGroup model  =platformGroupMapper.selectById(platform.getId()); | 
 |  |  |         if(model ==null) { | 
 |  |  |             throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,该记录信息不存在!"); | 
 |  |  |         } | 
 |  |  |         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); | 
 |  |  |         if(loginUserInfo == null){ | 
 |  |  |             loginUserInfo = platform.getLoginUserInfo(); | 
 |  |  |         } | 
 |  |  |         PlatformGroup update = new PlatformGroup(); | 
 |  |  |         update.setId(model.getId()); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  |         update.setEditor(loginUserInfo.getId()); | 
 |  |  |         update.setAutoCall(platform.getAutoCall()); | 
 |  |  |         platformGroupMapper.updateById(update); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void updateById(PlatformGroup platformGroup) { | 
 |  |  | 
 |  |  |                 || platformGroup.getType()<0){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         platformGroup.setAutoCall(Constants.formatIntegerNum(platformGroup.getAutoCall())); | 
 |  |  |         platformGroup.setIsVirtual(Constants.formatIntegerNum(platformGroup.getIsVirtual())); | 
 |  |  |         if(platformGroupMapper.selectCount(new QueryWrapper<PlatformGroup>().lambda() | 
 |  |  |                 .eq(PlatformGroup::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(PlatformGroup::getType,platformGroup.getType()) | 
 |  |  |                 .eq(PlatformGroup::getIsVirtual,platformGroup.getIsVirtual()) | 
 |  |  |                 .ne(PlatformGroup::getId,platformGroup.getId()) | 
 |  |  |         )>0){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,该类型分组已经创建,请返回刷新页面查看!"); | 
 |  |  | 
 |  |  |                 queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         return PageData.from(platformGroupMapper.selectPage(page, queryWrapper)); | 
 |  |  |         PageData<PlatformGroup> result =PageData.from(platformGroupMapper.selectPage(page, queryWrapper)); | 
 |  |  |         if(result !=null && result.getRecords()!=null){ | 
 |  |  |             List<String > ids0 = new ArrayList<>(); | 
 |  |  |             List<SystemUser> systemUserList ; | 
 |  |  |             for(PlatformGroup platformGroup : result.getRecords()){ | 
 |  |  |                 if( StringUtils.isNotBlank(platformGroup.getSignInNoticeUsers()) || StringUtils.isNotBlank(platformGroup.getUnFinishNoticeUsers())) { | 
 |  |  |                     if( StringUtils.isNotBlank(platformGroup.getSignInNoticeUsers()) ){ | 
 |  |  |                         ids0.addAll(Arrays.asList(platformGroup.getSignInNoticeUsers().split(","))); | 
 |  |  |                     } | 
 |  |  |                     if( StringUtils.isNotBlank(platformGroup.getUnFinishNoticeUsers()) ){ | 
 |  |  |                         ids0.addAll(Arrays.asList(platformGroup.getUnFinishNoticeUsers().split(","))); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda() | 
 |  |  |                     .eq(SystemUser::getDeleted, Constants.ZERO) | 
 |  |  |                     .in(SystemUser::getMemberId,ids0)  ); | 
 |  |  |             if (systemUserList!=null) { | 
 |  |  |                 for(PlatformGroup platformGroup : result.getRecords()){ | 
 |  |  |                     platformGroup.setSignInNoticeUserNames(getUserNameFromList(0,platformGroup,systemUserList)); | 
 |  |  |                     platformGroup.setUnFinishNoticeUserNames(getUserNameFromList(1,platformGroup,systemUserList)); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         return result; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     private String getUserNameFromList(int i, PlatformGroup platformGroup, List<SystemUser> systemUserList) { | 
 |  |  |            String ids = i ==0?platformGroup.getSignInNoticeUsers():platformGroup.getUnFinishNoticeUsers(); | 
 |  |  |            String name = ""; | 
 |  |  |             if( StringUtils.isNotBlank(ids)) { | 
 |  |  |                 List<String > ids0 = Arrays.asList(ids.split(",")); | 
 |  |  |                 if (systemUserList!=null) { | 
 |  |  |                     for(SystemUser user :systemUserList){ | 
 |  |  |                         for(String s : ids0){ | 
 |  |  |                             if(StringUtils.equals(user.getMemberId().toString(),s)){ | 
 |  |  |                                 if(StringUtils.isNotBlank(name)){ | 
 |  |  |                                     name += ","; | 
 |  |  |                                 } | 
 |  |  |                                 name += StringUtils.defaultString(user.getRealname(),user.getUsername()); | 
 |  |  |                             } | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             return  name; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |                         .eq(Platform::getIsdeleted, Constants.ZERO) | 
 |  |  |                         .eq(Objects.nonNull(platformDataDTO.getQueryType())&&!Constants.equalsInteger(platformDataDTO.getQueryType(),Constants.ZERO), | 
 |  |  |                                 Platform::getStatus,Constants.ZERO) | 
 |  |  |                         .orderByAsc(Platform::getSortnum) | 
 |  |  |         ); | 
 |  |  |         //处理我的月台信息 是否配置隐藏 | 
 |  |  |         if(Constants.equalsInteger(platformDataDTO.getQueryType(),Constants.ONE)){ | 
 |  |  | 
 |  |  |             //查询今天所有的任务数据 | 
 |  |  |             List<PlatformJob> platformJobList =  platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() | 
 |  |  |                             .selectAll(PlatformJob.class) | 
 |  |  |                             .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  ") | 
 |  |  |                             .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+"  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 = "+Constants.PlatformJobLogType.CALLED.getKey()+" order by pl.CREATE_DATE desc  limit 1  ) as newCallDate  ") | 
 |  |  |                             .select(" case when t.total_num is null  then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id  ) else t.total_num end ioQty ") | 
 |  |  |                             .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) | 
 |  |  |                             .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) | 
 |  |  |                             .selectAs(PlatformBooks::getId,PlatformJob::getBookId) | 
 |  |  |                             .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) | 
 |  |  |                             .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) | 
 |  |  |                             .leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId) | 
 |  |  |                             .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
 |  |  |                             .eq(Platform::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(), | 
 |  |  | 
 |  |  |  | 
 |  |  |     public static PlatformWorkVO getPlatformWorkVO(Platform platform,List<PlatformJob> platformJobList){ | 
 |  |  |         PlatformWorkVO platformWorkVO = new PlatformWorkVO(); | 
 |  |  |         platformWorkVO.setCurrentDate(new Date()); | 
 |  |  |         if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){ | 
 |  |  |             //获取月台组下的所有作业数据 | 
 |  |  |             List<PlatformJob> platformJobs = platformJobList.stream().filter( | 
 |  |  | 
 |  |  |                     || Constants.equalsInteger(i.getPlatformGroupId(),platform.getGroupId()) | 
 |  |  |             ).collect(Collectors.toList()); | 
 |  |  |             if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobs)){ | 
 |  |  |                 for(PlatformJob i :platformJobList){ | 
 |  |  |                     if(Constants.equalsInteger(i.getOrigin(),Constants.ZERO)){ | 
 |  |  |                         i.setWmsContractNum(i.getContractNum()); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |                 platformWorkVO.setWorkNum( | 
 |  |  |                         platformJobs.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),platform.getId())  && Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())).collect(Collectors.toList()).size() | 
 |  |  |                 ); | 
 |  |  |                 platformWorkVO.setCallNum( | 
 |  |  |                         platformJobs.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),platform.getId())  && Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())).collect(Collectors.toList()).size() | 
 |  |  |                 ); | 
 |  |  |  | 
 |  |  |                 platformWorkVO.setWaitNum( | 
 |  |  |  | 
 |  |  |                         platformJobs.stream().filter(i-> | 
 |  |  |                                  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.TRANSFERING.getKey()) | 
 |  |  |                         platformJobList.stream().filter(i-> | 
 |  |  |                                  (  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) && Constants.equalsInteger(i.getPlatformGroupId(),platform.getGroupId()) )|| | 
 |  |  |                                  ( Constants.equalsInteger(platform.getId(),i.getPlatformId()) && | 
 |  |  |                                  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()) | 
 |  |  | 
 |  |  |                 .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.EXCEPTION.getKey()) | 
 |  |  |             ) | 
 |  |  |         ); | 
 |  |  |  | 
 |  |  |         platformGroupWorkVO.setWaitNum(platformJobJoinMapper.selectJoinCount(new MPJLambdaWrapper<PlatformJob>() | 
 |  |  |                         .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) | 
 |  |  |                         .eq(PlatformJob::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .eq(Platform::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() |