| | |
| | | import com.doumee.dao.business.join.PlatformJobJoinMapper; |
| | | import com.doumee.dao.business.join.PlatformJoinMapper; |
| | | import com.doumee.dao.business.model.*; |
| | | import com.doumee.dao.web.reqeust.JobDetailDTO; |
| | | import com.doumee.dao.web.reqeust.JobOperateDTO; |
| | | import com.doumee.dao.web.reqeust.LineUpDetailDTO; |
| | | import com.doumee.dao.web.reqeust.SignInDTO; |
| | | import com.doumee.dao.openapi.request.*; |
| | | import com.doumee.dao.openapi.response.*; |
| | | import com.doumee.dao.web.reqeust.*; |
| | | import com.doumee.dao.web.response.DriverHomeVO; |
| | | import com.doumee.dao.web.response.LineUpVO; |
| | | import com.doumee.dao.web.response.PlatformWorkVO; |
| | | import com.doumee.service.business.PlatformJobService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | |
| | | @Autowired |
| | | private SystemDictDataBiz systemDictDataBiz; |
| | | |
| | | @Autowired |
| | | private PlatformWmsDetailMapper platformWmsDetailMapper; |
| | | |
| | | |
| | | @Autowired |
| | | private PlatformJoinMapper platformJoinMapper; |
| | |
| | | |
| | | @Autowired |
| | | private PlatformWmsJobMapper platformWmsJobMapper; |
| | | |
| | | @Autowired |
| | | private PlatformWmsDetailMapper platformWmsDetailMapper; |
| | | |
| | | @Autowired |
| | | private PlatformGroupMapper platformGroupMapper; |
| | |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) |
| | | .eq(pageWrap.getModel().getId() != null, PlatformJob::getId, pageWrap.getModel().getId()) |
| | | .eq(pageWrap.getModel().getCreator() != null, PlatformJob::getCreator, pageWrap.getModel().getCreator()) |
| | | .ge(pageWrap.getModel().getCreateDate() != null, PlatformJob::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())) |
| | |
| | | platformJobIPage.getRecords().forEach(i->{ |
| | | i.dealTime(); |
| | | this.getWmsJobData(i); |
| | | this.queryWaitNum(i); |
| | | }); |
| | | return PageData.from(platformJobIPage); |
| | | // PageData<PlatformJob> pageData = PageData.from(platformJobMapper.selectPage(page, queryWrapper)); |
| | | // pageData.getRecords().forEach(i->{ |
| | | // i.dealTime(); |
| | | // this.getWmsJobData(i); |
| | | // }); |
| | | // return pageData; |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | public PageData<PlatformJob> platformCallList(PageWrap<PlatformJob> pageWrap) { |
| | | IPage<PlatformJob> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<PlatformJob> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) |
| | | .eq(pageWrap.getModel().getPlatformGroupId() != null, PlatformJob::getPlatformGroupId, pageWrap.getModel().getPlatformGroupId()) |
| | | .like(pageWrap.getModel().getCarCodeFront() != null, PlatformJob::getCarCodeFront, pageWrap.getModel().getCarCodeFront()) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getCallType()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.ONE),PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey() |
| | | ) |
| | | .and(Objects.nonNull(pageWrap.getModel().getCallType()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.TWO), |
| | | i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()).or() |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()).or() |
| | | .apply(" ( t.status = "+Constants.PlatformJobStatus.TRANSFERING.getKey()+" and t.PLATFORM_ID = "+pageWrap.getModel().getPlatformId()+" ) ") |
| | | ) |
| | | .and(Objects.nonNull(pageWrap.getModel().getCallType()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.THREE), |
| | | i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()).or() |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()).or() |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()).or() |
| | | .apply(" ( t.status = "+Constants.PlatformJobStatus.TRANSFERING.getKey()+" and t.PLATFORM_GROUP_ID = "+pageWrap.getModel().getPlatformGroupId()+" ) ") |
| | | ) |
| | | .like(PlatformJob::getArriveDate,DateUtil.dateTypeToString(new Date(),"yyyy-MM-dd")) |
| | | .orderByDesc(PlatformJob::getStatus) |
| | | ; |
| | | IPage<PlatformJob> platformJobIPage = platformJobJoinMapper.selectJoinPage(page,PlatformJob.class,queryWrapper); |
| | | platformJobIPage.getRecords().forEach(i->{ |
| | | i.dealTime(); |
| | | this.getWmsJobData(i); |
| | | this.queryWaitNum(i); |
| | | }); |
| | | return PageData.from(platformJobIPage); |
| | | } |
| | | |
| | | |
| | | public void getWmsJobData(PlatformJob platformJob){ |
| | | if(Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.zycxh) |
| | | || Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.zyczh) |
| | | || Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.sgscxh)) { |
| | | || Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.zyczh) |
| | | || Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.wxcxh) |
| | | || Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.wxczh)) { |
| | | |
| | | PlatformWmsJob platformWmsJob = platformWmsJobMapper.selectOne(new QueryWrapper<PlatformWmsJob>().lambda() |
| | | .eq(PlatformWmsJob::getIsdeleted,Constants.ZERO) |
| | |
| | | ,Constants.PlatformJobStatus.TRANSFERING.getKey()) |
| | | .gt(PlatformJob::getSignDate,platformJob.getSignDate()) |
| | | .eq(PlatformJob::getPlatformGroupId,platformJob.getPlatformGroupId()) |
| | | .like(PlatformJob::getArriveDate,DateUtil.getDate(platformJob.getArriveDate(),"yyyy-MM-dd"))); |
| | | .like(PlatformJob::getArriveDate,DateUtil.dateTypeToString(platformJob.getArriveDate(),"yyyy-MM-dd"))); |
| | | platformJob.setLineUpNum(lineUpNum.size()); |
| | | BigDecimal sumWorkRate = platformJob.getTotalNum(); |
| | | for (PlatformJob linePlatformJob:lineUpNum) { |
| | | this.getWmsJobData(linePlatformJob); |
| | | sumWorkRate = sumWorkRate.add(linePlatformJob.getTotalNum()); |
| | | } |
| | | //计算预计等待时间 |
| | | List<Platform> platformList = platformJoinMapper.selectList(new QueryWrapper<Platform>().lambda().eq(Platform::getIsdeleted,Constants.ZERO).eq(Platform::getGroupId,platformJob.getPlatformGroupId())); |
| | | BigDecimal workRate = platformList.stream().map(m->m.getWorkRate()).reduce(BigDecimal.ZERO,BigDecimal::add); |
| | | if(sumWorkRate.compareTo(BigDecimal.ZERO) == Constants.ZERO|| workRate.compareTo(BigDecimal.ZERO) == Constants.ZERO ){ |
| | | BigDecimal sumMinute = sumWorkRate.divide(workRate,1, RoundingMode.HALF_DOWN).multiply(BigDecimal.valueOf(60L)); |
| | | Integer sumMinuteInteger = sumMinute.intValue(); |
| | | Integer hours = sumMinuteInteger/60; |
| | | Integer minus = sumMinuteInteger%60; |
| | | String waitTime = "预计等待:"; |
| | | if(!Constants.equalsInteger(hours,Constants.ZERO)){ |
| | | waitTime = waitTime + hours + "小时"; |
| | | if(lineUpNum.size()>Constants.ZERO){ |
| | | //计算预计等待时间 |
| | | List<Platform> platformList = platformJoinMapper.selectList(new QueryWrapper<Platform>().lambda().eq(Platform::getIsdeleted,Constants.ZERO).eq(Platform::getGroupId,platformJob.getPlatformGroupId())); |
| | | BigDecimal workRate = platformList.stream().map(m->m.getWorkRate()).reduce(BigDecimal.ZERO,BigDecimal::add); |
| | | if(sumWorkRate.compareTo(BigDecimal.ZERO) == Constants.ZERO|| workRate.compareTo(BigDecimal.ZERO) == Constants.ZERO ){ |
| | | BigDecimal sumMinute = sumWorkRate.divide(workRate,1, RoundingMode.HALF_DOWN).multiply(BigDecimal.valueOf(60L)); |
| | | Integer sumMinuteInteger = sumMinute.intValue(); |
| | | Integer hours = sumMinuteInteger/60; |
| | | Integer minus = sumMinuteInteger%60; |
| | | String waitTime = "预计等待:"; |
| | | if(!Constants.equalsInteger(hours,Constants.ZERO)){ |
| | | waitTime = waitTime + hours + "小时"; |
| | | } |
| | | if(!Constants.equalsInteger(hours,Constants.ZERO)){ |
| | | waitTime = waitTime + minus + "分钟"; |
| | | } |
| | | platformJob.setWaitTime(waitTime); |
| | | } |
| | | if(!Constants.equalsInteger(hours,Constants.ZERO)){ |
| | | waitTime = waitTime + minus + "分钟"; |
| | | } |
| | | platformJob.setWaitTime(waitTime); |
| | | }else{ |
| | | platformJob.setWaitTime("等待叫号"); |
| | | } |
| | | }else if(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())){ |
| | | //查询最后开始任务的月台记录 日志表 因为存在异常挂起 转移 等问题 |
| | |
| | | BigDecimal sumMinute = platformJob.getTotalNum().divide(platformJob.getWorkRate(),1, RoundingMode.HALF_DOWN).multiply(BigDecimal.valueOf(60L)); |
| | | platformJob.setFinishTimeStr(DateUtil.DateToStr(DateUtil.afterMinutesDate(platformLog.getCreateDate(),sumMinute.intValue()),"HH:mm")); |
| | | } |
| | | //处理作业时长 |
| | | List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getJobId,platformJob.getId()) |
| | | .isNotNull(PlatformLog::getParam3) |
| | | .ne(PlatformLog::getParam3,Constants.ZERO+"") |
| | | .orderByDesc(PlatformLog::getCreateDate)); |
| | | platformJob.setWorkTime(platformLogList.stream().map(m->Long.valueOf(m.getParam3())).reduce(Long.valueOf(0),Long::sum)); |
| | | |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | public DriverHomeVO getDriverHome(LoginUserInfo loginUserInfo){ |
| | | DriverHomeVO driverHomeVO = new DriverHomeVO(); |
| | | //TODO 轮播图 |
| | | |
| | | List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | |
| | | driverHomeVO.setReservationMap(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.PLATFORM_GUIDEMAP).getCode()); |
| | | // 预约指南 文本 |
| | | driverHomeVO.setBookingTips(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.PLATFORM_BOOKING_TIPS).getCode()); |
| | | driverHomeVO.setSignDistance(new BigDecimal(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_DISTANCE).getCode())); |
| | | |
| | | return driverHomeVO; |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | public void confirmTask(ConfirmTaskDTO confirmTaskDTO){ |
| | | if(Objects.isNull(confirmTaskDTO) |
| | | || Objects.isNull(confirmTaskDTO.getId()) |
| | | || Objects.isNull(confirmTaskDTO.getArriveDate()) |
| | | || StringUtils.isBlank(confirmTaskDTO.getCarCodeBack()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | PlatformJob platformJob = platformJobMapper.selectById(confirmTaskDTO.getId()); |
| | | if(Objects.isNull(platformJob)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | if(!Constants.equalsInteger(platformJob.getStatus(),Constants.ZERO)){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"业务状态已流转,无法进行该操作"); |
| | | } |
| | | if(confirmTaskDTO.getArriveDate().getTime()<=System.currentTimeMillis()){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"预计到厂时间必须大于当前时间"); |
| | | } |
| | | |
| | | PlatformJob oldPlatformJob = new PlatformJob(); |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | | platformJob.setArriveDate(confirmTaskDTO.getArriveDate()); |
| | | platformJob.setStatus(Constants.PlatformJobStatus.WART_SIGN_IN.getKey()); |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobLogType.CONFIRM_TASK.getKey(),oldPlatformJob,platformJob , |
| | | Constants.PlatformJobLogType.CONFIRM_TASK.getInfo()); |
| | | } |
| | | |
| | | /** |
| | | * 距离签到 |
| | |
| | | platformJob.setStatus(Constants.PlatformJobStatus.WAIT_CALL.getKey()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.WAIT_CALL.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.SIGN.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.SIGN.getInfo()); |
| | | } |
| | | |
| | | |
| | |
| | | Double lat = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LAT).getCode()); |
| | | Double lnt = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LNT).getCode()); |
| | | BigDecimal distance = new BigDecimal(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_DISTANCE).getCode()); |
| | | //获取2个点的距离X米 |
| | | //获取2个点的距离 单位:米 |
| | | Double getDistanceDouble = PositionUtil.getDistance(signInDTO.getLnt(),signInDTO.getLat(),lnt,lat); |
| | | //转换km |
| | | BigDecimal getDistance = BigDecimal.valueOf(getDistanceDouble).divide(new BigDecimal(1000),2,BigDecimal.ROUND_HALF_UP); |
| | | if(distance.compareTo(getDistance)<Constants.ZERO){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"超出可签到距离,可签到距离["+distance+"]公里]"); |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"超出可签到距离,可签到距离为["+distance+"]公里]"); |
| | | } |
| | | platformJob.setSignDistance(BigDecimal.valueOf(getDistanceDouble)); |
| | | } |
| | |
| | | List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class, |
| | | new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(Constants.equalsInteger(lineUpDetailDTO.getQueryType(),Constants.ZERO) |
| | | ,PlatformJob::getDrivierPhone,lineUpDetailDTO.getMobile()) |
| | |
| | | ); |
| | | //获取所有月台组 |
| | | List<Integer> platformIdList = platformJobList.stream().map(m->m.getPlatformGroupId()).collect(Collectors.toList()); |
| | | List<Platform> platformList = platformJoinMapper.selectList(new QueryWrapper<Platform>().lambda() |
| | | .eq(Platform::getIsdeleted,Constants.ZERO) |
| | | .in(Platform::getId,platformIdList)); |
| | | if(CollectionUtils.isEmpty(platformIdList)){ |
| | | return lineUpVO; |
| | | } |
| | | List<PlatformGroup> platformGroupList = platformGroupMapper.selectList(new QueryWrapper<PlatformGroup>().lambda() |
| | | .eq(PlatformGroup::getIsdeleted,Constants.ZERO) |
| | | .in(PlatformGroup::getId,platformIdList)); |
| | | |
| | | for (Platform platform:platformList) { |
| | | for (PlatformGroup platformGroup:platformGroupList) { |
| | | //查询本月台组下 自己的数据 最早签到的 |
| | | PlatformJob platformJob = platformJobList.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),platform.getId())).findFirst().orElse(null); |
| | | PlatformJob platformJob = platformJobList.stream().filter(i->Constants.equalsInteger(i.getPlatformGroupId(),platformGroup.getId())).findFirst().orElse(null); |
| | | //查询在当前月台组下 签到排队车辆数据 |
| | | List<PlatformJob> platformJobSignInList = platformJobJoinMapper.selectJoinList(PlatformJob.class, |
| | | new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getPlatformGroupId,platform.getGroupId()) |
| | | .ge(Objects.nonNull(platformJob),PlatformJob::getSignDate,DateUtil.getDate(platformJob.getSignDate(),"yyyy-MM-dd HH:mm:ss")) |
| | | .eq(PlatformJob::getPlatformGroupId,platformGroup.getId()) |
| | | .ge(Objects.nonNull(platformJob),PlatformJob::getSignDate,DateUtil.dateTypeToString(platformJob.getSignDate(),"yyyy-MM-dd HH:mm:ss")) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey(), |
| | | Constants.PlatformJobStatus.IN_WAIT.getKey(), |
| | | Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .orderByDesc(PlatformJob::getSignDate)); |
| | | platform.setSignJobList(platformJobSignInList); |
| | | platformGroup.setSignJobList(platformJobSignInList); |
| | | //查询当前月台组下 |
| | | List<PlatformJob> platformJobWorkList = platformJobJoinMapper.selectJoinList(PlatformJob.class, |
| | | new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getPlatformGroupId,platform.getGroupId()) |
| | | .eq(PlatformJob::getPlatformGroupId,platformGroup.getId()) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | .orderByDesc(PlatformJob::getSignDate)); |
| | | platform.setWorkJobList(platformJobWorkList); |
| | | platformGroup.setWorkJobList(platformJobWorkList); |
| | | } |
| | | lineUpVO.setPlatformList(platformList); |
| | | lineUpVO.setPlatformGroupList(platformGroupList); |
| | | return lineUpVO; |
| | | } |
| | | |
| | |
| | | * 获取已作业时间 |
| | | * @param platformJob |
| | | */ |
| | | public void getWorkTime(PlatformJob platformJob){ |
| | | public Long getWorkTime(PlatformJob platformJob){ |
| | | List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>() |
| | | .lambda().eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getJobId,platformJob.getId()) |
| | |
| | | } |
| | | } |
| | | platformJob.setWorkTime(optTime); |
| | | return optTime; |
| | | } |
| | | |
| | | /** |
| | |
| | | //TODO 下发入园权限 |
| | | |
| | | } |
| | | |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.WAIT_CALL.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.IN_WAIT.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.IN_WAIT.getInfo()); |
| | | |
| | | } |
| | | |
| | |
| | | ) ){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转!"); |
| | | } |
| | | |
| | | |
| | | Platform platform = platformJoinMapper.selectById(jobOperateDTO.getPlatformId()); |
| | | if(Objects.isNull(platform)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息"); |
| | | } |
| | | PlatformJob oldPlatformJob = new PlatformJob(); |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | | platformJob.setCallDate(new Date()); |
| | | platformJob.setCallUserId(jobOperateDTO.getLoginUserInfo().getId()); |
| | | platformJob.setStatus(Constants.PlatformJobStatus.CALLED.getKey()); |
| | | platformJob.setPlatformId(jobOperateDTO.getPlatformId()); |
| | | //判断是否需要填充进去 |
| | | if(StringUtils.isBlank(platformJob.getPlatforms())){ |
| | | platformJob.setPlatforms(jobOperateDTO.getPlatformId().toString()); |
| | | platformJob.setPlatformNames(platform.getName()); |
| | | }else{ |
| | | platformJob.setPlatforms(platformJob.getPlatforms() + "," +jobOperateDTO.getPlatformId().toString()); |
| | | platformJob.setPlatformNames(platformJob.getPlatformNames() + "," +platform.getName()); |
| | | } |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.CALLED.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.CALLED.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.CALLED.getInfo().replace("{data}",platform.getName())); |
| | | } |
| | | |
| | | |
| | |
| | | if(Constants.equalsInteger(platformJob.getPlatformId(),jobOperateDTO.getPlatformId())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"无法转移本月台"); |
| | | } |
| | | Platform oldPlatform = platformJoinMapper.selectById(platformJob.getPlatformId()); |
| | | |
| | | Platform platform = platformJoinMapper.selectById(jobOperateDTO.getPlatformId()); |
| | | if(Objects.isNull(platform)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息"); |
| | | } |
| | | |
| | | PlatformJob oldPlatformJob = new PlatformJob(); |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | | platformJob.setPlatforms(platformJob.getPlatforms() + "," +jobOperateDTO.getPlatformId().toString()); |
| | | platformJob.setPlatformNames(platformJob.getPlatformNames() + "," +platform.getName()); |
| | | |
| | | platformJob.setTransPlatformDate(new Date()); |
| | | platformJob.setTransPlatformUserId(jobOperateDTO.getLoginUserInfo().getId()); |
| | |
| | | |
| | | //TODO 调起WMS 通知月台转移 |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.TRANSFERING.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.TRANSFERING.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.TRANSFERING.getInfo().replace("{data}",oldPlatform.getName())); |
| | | } |
| | | |
| | | |
| | |
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
| | | public void platformOverNumber(JobOperateDTO jobOperateDTO){ |
| | | if(Objects.isNull(jobOperateDTO) |
| | | || Objects.isNull(jobOperateDTO.getJobId()) |
| | | || Objects.isNull(jobOperateDTO.getPlatformId())){ |
| | | || Objects.isNull(jobOperateDTO.getJobId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId()); |
| | | if(Objects.isNull(platformJob)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())){ |
| | | if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转!"); |
| | | } |
| | | |
| | | PlatformJob oldPlatformJob = new PlatformJob(); |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.WART_SIGN_IN.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.OVER_NUMBER.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.OVER_NUMBER.getInfo()); |
| | | |
| | | |
| | | } |
| | |
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
| | | public void platformErr(JobOperateDTO jobOperateDTO){ |
| | | if(Objects.isNull(jobOperateDTO) |
| | | || Objects.isNull(jobOperateDTO.getJobId()) |
| | | || Objects.isNull(jobOperateDTO.getPlatformId())){ |
| | | || Objects.isNull(jobOperateDTO.getJobId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId()); |
| | |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.EXCEPTION.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.EXCEPTION.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.EXCEPTION.getInfo()); |
| | | } |
| | | |
| | | |
| | |
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
| | | public void beginWork(JobOperateDTO jobOperateDTO){ |
| | | if(Objects.isNull(jobOperateDTO) |
| | | || Objects.isNull(jobOperateDTO.getJobId()) |
| | | || Objects.isNull(jobOperateDTO.getPlatformId())){ |
| | | || Objects.isNull(jobOperateDTO.getJobId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId()); |
| | |
| | | if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转!"); |
| | | } |
| | | platformJobMapper.update(null,new UpdateWrapper<PlatformJob>() |
| | | .lambda() |
| | | .set(Objects.isNull(platformJob.getStartDate()),PlatformJob::getStartDate,new Date()) |
| | | .set(PlatformJob::getEditDate,new Date()) |
| | | .set(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | .eq(PlatformJob::getId,jobOperateDTO.getJobId()) |
| | | ); |
| | | |
| | | Platform platform = platformJoinMapper.selectById(platformJob.getPlatformId()); |
| | | if(Objects.isNull(platform)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息"); |
| | | } |
| | | |
| | | PlatformJob oldPlatformJob = new PlatformJob(); |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | | |
| | | if(Objects.isNull(platformJob.getStartDate())){ |
| | | platformJob.setStartDate(new Date()); |
| | | } |
| | | platformJob.setStatus(Constants.PlatformJobStatus.WORKING.getKey()); |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.WORKING.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.WORKING.getKey(),oldPlatformJob,platformJob, |
| | | Constants.PlatformJobLogType.WORKING.getInfo().replace("{data}",platform.getName())); |
| | | } |
| | | |
| | | |
| | |
| | | BeanUtils.copyProperties(platformJob,oldPlatformJob); |
| | | |
| | | platformJob.setDoneDate(new Date()); |
| | | platformJob.setStatus(Constants.PlatformJobStatus.EXCEPTION.getKey()); |
| | | platformJob.setStatus(Constants.PlatformJobStatus.DONE.getKey()); |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.EXCEPTION.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.DONE.getKey(),oldPlatformJob,platformJob , |
| | | Constants.PlatformJobLogType.DONE.getInfo()); |
| | | |
| | | if(Constants.equalsInteger(platformJob.getType(),Constants.TWO)){ |
| | | //TODO 外协车装货 查询TMS 电子锁情况 |
| | |
| | | platformJob.setEditDate(new Date()); |
| | | platformJobMapper.updateById(platformJob); |
| | | //存储操作日志 |
| | | savePlatformLog(Constants.PlatformJobStatus.WORKING.getKey(),oldPlatformJob,platformJob); |
| | | savePlatformLog(Constants.PlatformJobLogType.WORKING.getKey(),oldPlatformJob,platformJob , |
| | | Constants.PlatformJobLogType.DONE.getInfo()); |
| | | } |
| | | |
| | | |
| | |
| | | * @param platformJobBefor |
| | | * @param platformJobAfter |
| | | */ |
| | | public void savePlatformLog(Integer objType,PlatformJob platformJobBefor,PlatformJob platformJobAfter){ |
| | | public void savePlatformLog(Integer objType,PlatformJob platformJobBefor,PlatformJob platformJobAfter,String content){ |
| | | PlatformLog platformLog = new PlatformLog(); |
| | | platformLog.setIsdeleted(Constants.ZERO); |
| | | platformLog.setCreateDate(new Date()); |
| | | platformLog.setJobId(platformJobAfter.getId()); |
| | | platformLog.setObjType(objType); |
| | | platformLog.setContent(content); |
| | | platformLog.setParam4(platformJobAfter.getCarCodeFront()); |
| | | platformLog.setBeforeContent(JSONObject.toJSONString(platformJobBefor)); |
| | | platformLog.setAfterContent(JSONObject.toJSONString(platformJobAfter)); |
| | | platformLog.setObjId(platformJobAfter.getId().toString()); |
| | | //查询最后一次开始作业的日志 |
| | | PlatformLog lastBeginPlatform = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getObjType,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | .eq(PlatformLog::getJobId,platformLog.getJobId()) |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | if(Objects.isNull(lastBeginPlatform)){ |
| | | return; |
| | | } |
| | | if(Constants.equalsInteger(objType,Constants.PlatformJobStatus.EXCEPTION.getKey()) |
| | | || Constants.equalsInteger(objType,Constants.PlatformJobStatus.TRANSFERING.getKey())){ |
| | | |
| | | if(Constants.equalsInteger(objType,Constants.PlatformJobLogType.EXCEPTION.getKey())){ |
| | | //查询最后一次开始作业的日志 |
| | | PlatformLog lastBeginPlatform = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getObjType,Constants.PlatformJobLogType.WORKING.getKey()) |
| | | .eq(PlatformLog::getJobId,platformLog.getJobId()) |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | //异常挂起 与转移中 记录本次 作业时间 |
| | | platformLog.setParam1(DateUtil.getDate(lastBeginPlatform.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | platformLog.setParam2(DateUtil.getDate(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | String v = Long.toString(platformJobAfter.getDoneDate().getTime() - platformJobBefor.getStartDate().getTime() / 1000) ; |
| | | platformLog.setParam1(lastBeginPlatform.getParam1()); |
| | | platformLog.setParam2(DateUtil.dateTypeToString(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | String v = Long.toString((platformLog.getCreateDate().getTime() - DateUtil.StringToDate(lastBeginPlatform.getParam1(),"yyyy-MM-dd HH:mm:ss").getTime() )/ 1000) ; |
| | | platformLog.setParam3(v); |
| | | }else if(Constants.equalsInteger(objType,Constants.PlatformJobStatus.DONE.getKey())){ |
| | | }else if(Constants.equalsInteger(objType,Constants.PlatformJobLogType.TRANSFERING.getKey())){ |
| | | //查询最后一次日志是否为异常挂起,异常挂起后可进行转移 如果进行转移那么业务就需要重新进行开始就不需要特殊处理 ,如果不是异常挂起进行数据结束 则直接查询最后一次开始的时间 |
| | | PlatformLog lastPlatformLog = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | if(Objects.nonNull(lastPlatformLog) && Constants.equalsInteger(lastPlatformLog.getObjType(),Constants.PlatformJobStatus.EXCEPTION.getKey())){ |
| | | if(!Constants.equalsInteger(lastPlatformLog.getObjType(),Constants.PlatformJobLogType.EXCEPTION.getKey())){ |
| | | //查询最后一次开始作业的日志 |
| | | PlatformLog lastBeginPlatform = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getObjType,Constants.PlatformJobLogType.WORKING.getKey()) |
| | | .eq(PlatformLog::getJobId,platformLog.getJobId()) |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | //异常挂起 与转移中 记录本次 作业时间 |
| | | platformLog.setParam1(lastBeginPlatform.getParam1()); |
| | | platformLog.setParam2(DateUtil.dateTypeToString(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | String v = Long.toString((platformLog.getCreateDate().getTime() - DateUtil.StringToDate(lastBeginPlatform.getParam1(),"yyyy-MM-dd HH:mm:ss").getTime() )/ 1000) ; |
| | | platformLog.setParam3(v); |
| | | }else{ |
| | | platformLog.setParam3("0"); |
| | | } |
| | | }else if(Constants.equalsInteger(objType,Constants.PlatformJobLogType.DONE.getKey())){ |
| | | //查询最后一次日志是否为异常挂起,异常挂起后可进行转移 如果进行转移那么业务就需要重新进行开始就不需要特殊处理 ,如果不是异常挂起进行数据结束 则直接查询最后一次开始的时间 |
| | | PlatformLog lastPlatformLog = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getJobId,platformLog.getJobId()) |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | if(Objects.nonNull(lastPlatformLog) && Constants.equalsInteger(lastPlatformLog.getObjType(),Constants.PlatformJobLogType.EXCEPTION.getKey())){ |
| | | platformLog.setParam3("0"); |
| | | }else{ |
| | | //查询最后一次开始作业的日志 |
| | | PlatformLog lastBeginPlatform = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda() |
| | | .eq(PlatformLog::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformLog::getObjType,Constants.PlatformJobLogType.WORKING.getKey()) |
| | | .eq(PlatformLog::getJobId,platformLog.getJobId()) |
| | | .orderByDesc(PlatformLog::getCreateDate) |
| | | .last(" limit 1 ") |
| | | ); |
| | | //非异常挂起 则直接过去最后一次开始作业的日志的开始时间 |
| | | platformLog.setParam1(DateUtil.getDate(lastBeginPlatform.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | platformLog.setParam2(DateUtil.getDate(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | String v = Long.toString(platformJobAfter.getDoneDate().getTime() - platformJobBefor.getStartDate().getTime() / 1000) ; |
| | | platformLog.setParam1(lastBeginPlatform.getParam1()); |
| | | platformLog.setParam2(DateUtil.dateTypeToString(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | String v = Long.toString((platformJobAfter.getDoneDate().getTime() - DateUtil.StringToDate(lastBeginPlatform.getParam1(),"yyyy-MM-dd HH:mm:ss").getTime()) / 1000) ; |
| | | platformLog.setParam3(v); |
| | | } |
| | | }else if(Constants.equalsInteger(objType,Constants.PlatformJobLogType.WORKING.getKey())){ |
| | | platformLog.setParam1(DateUtil.dateTypeToString(platformLog.getCreateDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | platformLog.setParam3("0"); |
| | | }else{ |
| | | platformLog.setParam3("0"); |
| | | } |
| | |
| | | .eq(PlatformJob::getPlatformId,platform.getId()) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getDrivierPhone,loginUserInfo.getMobile()) |
| | | .in(PlatformJob::getStatus, |
| | | Constants.PlatformJobStatus.WAIT_CALL.getKey(), |
| | | Constants.PlatformJobStatus.IN_WAIT.getKey(), |
| | | Constants.PlatformJobStatus.CALLED.getKey(), |
| | | Constants.PlatformJobStatus.WORKING.getKey(), |
| | | Constants.PlatformJobStatus.EXCEPTION.getKey(), |
| | | Constants.PlatformJobStatus.OVER_NUMBER.getKey() |
| | | ) |
| | | .like(PlatformJob::getArriveDate, DateUtil.getCurrDate()) |
| | | .orderByDesc(PlatformJob::getId) |
| | | ); |
| | |
| | | platform.setWorkJobList(platformJobList); |
| | | } |
| | | |
| | | @Override |
| | | public PlatformWorkVO getPlatformWorkVOById(Integer platformId){ |
| | | //获取月台下的所有作业数据 |
| | | List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .eq(PlatformJob::getPlatformId,platformId) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .in(PlatformJob::getStatus, |
| | | Constants.PlatformJobStatus.WAIT_CALL.getKey(), |
| | | Constants.PlatformJobStatus.IN_WAIT.getKey(), |
| | | Constants.PlatformJobStatus.CALLED.getKey(), |
| | | Constants.PlatformJobStatus.WORKING.getKey(), |
| | | Constants.PlatformJobStatus.EXCEPTION.getKey(), |
| | | Constants.PlatformJobStatus.OVER_NUMBER.getKey() |
| | | ) |
| | | .like(PlatformJob::getArriveDate, DateUtil.getCurrDate()) |
| | | .orderByDesc(PlatformJob::getId) |
| | | ); |
| | | for (PlatformJob platformJob:platformJobList) { |
| | | //处理WSM数量 |
| | | this.getWmsJobData(platformJob); |
| | | //查询前方排队数量 |
| | | this.queryWaitNum(platformJob); |
| | | } |
| | | PlatformWorkVO platformWorkVO = PlatformGroupServiceImpl.getPlatformWorkVO(platformId,platformJobList); |
| | | return platformWorkVO; |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public PlatformOrderNumByDateResponse orderNumByDate(PlatformOrderNumByDateRequest param){ |
| | | PlatformOrderNumByDateResponse platformOrderNumByDateResponse = new PlatformOrderNumByDateResponse(); |
| | | Date queryDate = (Objects.nonNull(param)&&Objects.nonNull(param.getTimeInfo()))?param.getTimeInfo():new Date(); |
| | | String queryDateStr = DateUtil.getDate(queryDate,"yyyy-MM-dd"); |
| | | //查询今日全部任务 |
| | | platformOrderNumByDateResponse.setTotalNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .and(i-> |
| | | i.like(PlatformJob::getDoneDate,queryDateStr) |
| | | .or().ne(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey()) |
| | | ) |
| | | ) |
| | | ); |
| | | //查询今日完成任务 |
| | | platformOrderNumByDateResponse.setDoneNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .like(PlatformJob::getDoneDate,queryDateStr) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey()) |
| | | ) |
| | | ); |
| | | return platformOrderNumByDateResponse; |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | public List<PlatformDataListResponse> platformWorkingDataList(PlatformDataListRequest param){ |
| | | List<PlatformDataListResponse> platformDataListResponseList = new ArrayList<>(); |
| | | List<Platform> platformList = platformJoinMapper.selectList( |
| | | new MPJLambdaWrapper<Platform>().eq(Platform::getIsdeleted,Constants.ZERO) |
| | | .eq(Platform::getStatus,Constants.ZERO) |
| | | ); |
| | | for (Platform platform:platformList) { |
| | | PlatformDataListResponse platformDataListResponse = new PlatformDataListResponse(); |
| | | platformDataListResponse.setId(platform.getId()); |
| | | platformDataListResponse.setHkId(platform.getHkId()); |
| | | platformDataListResponse.setName(platform.getName()); |
| | | platformDataListResponse.setWorkStatus(Constants.ZERO); |
| | | //查询当前作业车辆 |
| | | PlatformJob platformJob = platformJobMapper.selectOne(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | .orderByDesc(PlatformJob::getWorkTime) |
| | | .last(" limit 1") |
| | | ); |
| | | if(Objects.nonNull(platformJob)){ |
| | | platformDataListResponse.setCarCode(platformJob.getCarCodeFront()); |
| | | platformDataListResponse.setWorkType( |
| | | Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.zycxh) |
| | | ||Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.wxcxh) |
| | | ||Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.sgscxh)?Constants.ZERO:Constants.ONE |
| | | ); |
| | | platformDataListResponse.setWorkStatus(Constants.ONE); |
| | | //查询作业时长 |
| | | platformDataListResponse.setWorkTime( |
| | | this.getWorkTime(platformJob) |
| | | ); |
| | | } |
| | | } |
| | | return platformDataListResponseList; |
| | | } |
| | | |
| | | @Override |
| | | public PlatformDataInfoResponse platformWorkingDataList(PlatformDataInfoRequest param){ |
| | | if(Objects.isNull(param) |
| | | || Objects.isNull(param.getId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | PlatformDataInfoResponse response = new PlatformDataInfoResponse(); |
| | | Platform platform = platformJoinMapper.selectById(param.getId()); |
| | | if(Objects.isNull(platform)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息"); |
| | | } |
| | | response.setId(platform.getId()); |
| | | response.setHkId(platform.getHkId()); |
| | | response.setName(platform.getName()); |
| | | |
| | | PlatformJob platformJob = platformJobJoinMapper.selectJoinOne(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .selectAs(Platform::getName,PlatformJob::getPlatformName) |
| | | .selectAs(Platform::getWorkRate,PlatformJob::getWorkRate) |
| | | .selectAs(PlatformWmsJob::getId,PlatformJob::getWmsId) |
| | | .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) |
| | | .selectAs(PlatformWmsJob::getRepertotyAddress,PlatformJob::getRepertotyAddress) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | .eq(PlatformJob::getPlatformId,platform.getId()) |
| | | .orderByDesc(PlatformJob::getDoneDate) |
| | | ); |
| | | if(Objects.nonNull(platformJob)){ |
| | | response.setCarCode(platformJob.getCarCodeFront()); |
| | | response.setCarrierName(platformJob.getCarrierName()); |
| | | response.setOrderCode(platformJob.getBillCode()); |
| | | response.setRepertotyAddress(platformJob.getRepertotyAddress()); |
| | | //查询供应商信息 只有存在承运单号才有 |
| | | if(Objects.nonNull(platformJob.getWmsId())){ |
| | | List<PlatformWmsDetail> platformWmsDetailList = platformWmsDetailMapper.selectList(new QueryWrapper<PlatformWmsDetail>().lambda() |
| | | .eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformWmsDetail::getJobId,platformJob.getId())); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformWmsDetailList)){ |
| | | List<String> stringList = platformWmsDetailList.stream().map(m->m.getInRepertotyCode()).collect(Collectors.toList()); |
| | | response.setInRepertotyCode(stringList); |
| | | } |
| | | } |
| | | } |
| | | return response; |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public CarNumByStatusResponse carStatusNum(CarNumByStatusRequest param){ |
| | | CarNumByStatusResponse response = new CarNumByStatusResponse(); |
| | | response.setQueuingNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()) |
| | | ) |
| | | ); |
| | | response.setInNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .and(i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()) |
| | | .or() |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) |
| | | ) |
| | | ) |
| | | ); |
| | | response.setWorkingNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) |
| | | ) |
| | | ); |
| | | response.setDoneNum( |
| | | platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.LEAVED.getKey()) |
| | | .like(PlatformJob::getOutDate,DateUtil.getDate(new Date(),"yyyy-MM-dd")) |
| | | ) |
| | | ); |
| | | return response; |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public PlatformQueuingListResponse queueList(PlatformQueuingListRequest param){ |
| | | PlatformQueuingListResponse response = new PlatformQueuingListResponse(); |
| | | |
| | | List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformGroup.class,PlatformGroup::getId,PlatformJob::getPlatformGroupId) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .isNotNull(PlatformJob::getCarCodeFront) |
| | | .orderByDesc(PlatformJob::getCreateDate) |
| | | .eq(PlatformGroup::getType,Constants.ZERO)); |
| | | |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){ |
| | | response.setOutboundList( |
| | | platformJobList.stream().map(m->m.getCarCodeFront()).collect(Collectors.toList()) |
| | | ); |
| | | } |
| | | |
| | | platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformGroup.class,PlatformGroup::getId,PlatformJob::getPlatformGroupId) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .isNotNull(PlatformJob::getCarCodeFront) |
| | | .orderByDesc(PlatformJob::getCreateDate) |
| | | .eq(PlatformGroup::getType,Constants.ONE)); |
| | | |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){ |
| | | response.setInboundList( |
| | | platformJobList.stream().map(m->m.getCarCodeFront()).collect(Collectors.toList()) |
| | | ); |
| | | } |
| | | |
| | | platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
| | | .leftJoin(PlatformGroup.class,PlatformGroup::getId,PlatformJob::getPlatformGroupId) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()) |
| | | .in(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .isNotNull(PlatformJob::getCarCodeFront) |
| | | .orderByDesc(PlatformJob::getCreateDate) |
| | | .eq(PlatformGroup::getType,Constants.TWO)); |
| | | |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){ |
| | | response.setMunicipalComList( |
| | | platformJobList.stream().map(m->m.getCarCodeFront()).collect(Collectors.toList()) |
| | | ); |
| | | } |
| | | return response; |
| | | } |
| | | |
| | | |
| | | |
| | | } |