| | |
| | | import com.doumee.core.haikang.model.param.respose.*; |
| | | import com.doumee.core.haikang.service.HKCarOpenService; |
| | | import com.doumee.core.haikang.service.HKService; |
| | | import com.doumee.dao.web.reqeust.CarsJobAndContractByJobIdDTO; |
| | | import com.doumee.service.business.third.model.request.TmsFacrotyCodeListRequest; |
| | | import com.doumee.service.business.third.model.request.TmsOrderNoFinishListRequest; |
| | | import com.doumee.service.business.third.model.request.TmsOutQtyAndVehicleQtyRequest; |
| | |
| | | Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), |
| | | Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .last("limit 1")); |
| | | |
| | | dealJobDetailAndContractBiz(job,data); |
| | | |
| | | return data; |
| | | |
| | | } |
| | | /** |
| | | * 【园区物料中心调度】看板-根据车牌号查询作业信息和合同信息集合 |
| | | * |
| | | * @return |
| | | * |
| | | */ |
| | | @Override |
| | | public CarsJobAndContractVO getJobDetailsById(CarsJobAndContractByJobIdDTO param) { |
| | | CarsJobAndContractVO data = new CarsJobAndContractVO(); |
| | | if(param.getId() == null){ |
| | | return data; |
| | | } |
| | | PlatformJob job = platformJobMapper.selectJoinOne(PlatformJob.class, |
| | | new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .eq(PlatformJob::getId,param.getId()) |
| | | .last("limit 1")); |
| | | dealJobDetailAndContractBiz(job,data); |
| | | |
| | | return data; |
| | | |
| | | } |
| | | |
| | | private void dealJobDetailAndContractBiz(PlatformJob job, CarsJobAndContractVO data) { |
| | | if(job!=null){ |
| | | List<PlatformLog> logList = platformLogMapper.selectJoinList(PlatformLog.class, |
| | | new MPJLambdaWrapper<PlatformLog>() |
| | |
| | | if(detailList!=null){ |
| | | for(PlatformWmsDetail d : detailList){ |
| | | if(isExistIocode(d.getIocode(),data.getContractList())){ |
| | | continue; |
| | | continue; |
| | | } |
| | | tt = new CarsContractVO(); |
| | | tt.setIoCode(d.getIocode()); |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | return data; |
| | | |
| | | } |
| | | |
| | | private List<PlatformWmsDetail> getDetailListByCode(String iocode, List<PlatformWmsDetail> detailList,CarsContractVO tt) { |
| | |
| | | @Override |
| | | public PlatformJobRunBoardNewVO platformJobCenterData(){ |
| | | PlatformJobRunBoardNewVO data = new PlatformJobRunBoardNewVO(); |
| | | Random random = new Random(); |
| | | |
| | | data.setMonthOutTimes(random.nextInt(1000)); |
| | | data.setYearOutTimes(random.nextInt(1000) * 11); |
| | | |
| | | data.setMonthOutTimes(0); |
| | | data.setYearOutTimes(0); |
| | | Date month = Utils.Date.getStart(new Date());//本月 |
| | | Date lastMonth = DateUtil.addMonthToDate(month,-1);//上月 |
| | | Date year = Utils.Date.getStart(new Date());//今年 |
| | |
| | | .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) |
| | | .selectAs(PlatformJob::getType,PlatformJob::getType) |
| | | .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) |
| | | // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) |
| | | // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
| | | .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(),Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .apply(" to_days(create_date) <to_days(now())")); |
| | |
| | | } |
| | | return data; |
| | | } |
| | | |
| | | |
| | | private BigDecimal getDoneHoursByData(String start ,String end) { |
| | | List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() |
| | |
| | | data.setHoursAbility(new BigDecimal(0)); |
| | | data.setCurrentPlanNum(new BigDecimal(0)); |
| | | data.setCurrentOrderNum(new BigDecimal(0)); |
| | | data.setNoNeedTransportOrderNum(new BigDecimal(0)); |
| | | data.setNeedTransportOrderNum(new BigDecimal(0)); |
| | | data.setCurrentOrderNum(new BigDecimal(0)); |
| | | data.setCrrentRestNum(new BigDecimal(0)); |
| | | data.setCrrentOutNum(new BigDecimal(0)); |
| | | List<TmsFactoryParam> paramList = factoryList(); |
| | |
| | | } |
| | | TmsOutboundCapabilityResponse result= tmsService.getOutboundCapability(param); |
| | | if(result !=null){ |
| | | String todayDate = DateUtil.getShortTime(new Date()); |
| | | List<String> planCodes = new ArrayList<>(); |
| | | List<String> todayCodes = new ArrayList<>(); |
| | | String todayDate = DateUtil.getShortTime(new Date()); |
| | | if(result.getCurrentDayOrderList()!=null && result.getCurrentDayOrderList().size()>0){ |
| | | for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayOrderList()){ |
| | | data.setCurrentOrderNum(data.getCurrentOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日订单量 |
| | | /** |
| | | * DISPATCH_TYPE in(1,2) 且 TRANSPORT_CODE不为空,sum(NC_TOTALITY) + DISPATCH_TYPE not in(1,2) sum(NC_TOTALITY) |
| | | * 今日出库下达的计划任务总量 |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) |
| | | && (StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日订单量 |
| | | } |
| | | if(!(StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日计划量 |
| | | } |
| | | |
| | | /** |
| | | * 今日下达出库的计划任务对应的运输车次数 |
| | | * TRANSPORT_CODE不为空count(transport_code ) |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | /** |
| | | * 今日下达出库的计划任务对应的运输车次数 |
| | | * TRANSPORT_CODE不为空count(transport_code ) |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | /** |
| | | * out_date为当日,sum(NC_TOTALITY) 今日完成的出库作业任务总量 |
| | | * TRANSPORT_CODE不为空 且out_date为当日 count(transport_code) 今日完成的出库作业任务的运输车次数 |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getOutDate()) && model.getOutDate().length()> 10){ |
| | | String tDate = model.getOutDate().substring(0,10); |
| | | if(tDate.equals(todayDate)){ |
| | | //如果是当日 |
| | | data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日订单量 |
| | | } |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),todayCodes)){ |
| | | todayCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); |
| | | } |
| | | } |
| | | if(result.getCurrentDayAgoOrderList()!=null && result.getCurrentDayAgoOrderList().size()>0){ |
| | | for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayAgoOrderList()){ |
| | | /** |
| | | * out_date为空,sum(NC_TOTALITY) 昨天未完成出库计划任务 |
| | | * out_date为空 且TRANSPORT_CODE不为空 * count(transport_code ) 昨天未完成出库计划任务车次 |
| | | */ |
| | | if(StringUtils.isBlank(model.getOutDate())){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日计划量 |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); |
| | | } |
| | | } |
| | | data.setCurrentPlanCarNum(planCodes.size());//今日计划车次 |
| | | data.setCurrentPlanCarNum(planCodes.size());//今日任务车次 |
| | | data.setCrrentOutCarNum(todayCodes.size());//今日出库车次 |
| | | } |
| | | data.setCrrentRestNum(data.getCurrentPlanNum().subtract(data.getCrrentOutNum())); |
| | | data.setCrrentRestCarNum(data.getCurrentPlanCarNum() -data.getCrrentOutCarNum()); |
| | | // data.setCrrentRestNum(data.getCurrentPlanNum().subtract(data.getCrrentOutNum())); |
| | | // data.setCrrentRestCarNum(data.getCurrentPlanCarNum() -data.getCrrentOutCarNum()); |
| | | data.setCrrentRestNum(data.getCurrentPlanNum()); |
| | | data.setCrrentRestCarNum(data.getCurrentPlanCarNum()); |
| | | if(data.getCrrentRestNum().compareTo(new BigDecimal(0)) <=0){ |
| | | data.setCrrentRestNum(new BigDecimal(0)); |
| | | } |
| | |
| | | data.setCurrentPlanNum(Constants.formatBigdecimal(data.getCurrentPlanNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setCrrentOutNum(Constants.formatBigdecimal(data.getCrrentOutNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setCurrentOrderNum(Constants.formatBigdecimal(data.getCurrentOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setNoNeedTransportOrderNum(Constants.formatBigdecimal(data.getNoNeedTransportOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setNeedTransportOrderNum(Constants.formatBigdecimal(data.getNeedTransportOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 1、当前订单里:截止目前未配载订单量; |
| | | * 2、当前任务量:截止目前已配载未出库订单量+无需配载的未出库任务量; |
| | | * 3、当前任务量和剩余任务量统计逻辑一致; |
| | | * @param data |
| | | * @param model |
| | | */ |
| | | private void dealOutOrderBiz(WholeProvinceBoardVO data, TmsOutboundCapabilityInfoResponse model,List<String> planCodes,List<String> todayCodes, String todayDate ) { |
| | | |
| | | /** |
| | | * 当前订单量:截至目前未配载的数据 |
| | | */ |
| | | if(StringUtils.isBlank(model.getTransportCode()) |
| | | &&( StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentOrderNum(data.getCurrentOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//当前订单量 |
| | | } |
| | | /** |
| | | * 当前任务量(和剩余任务里):截至目前已配载未出库的订单 |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && StringUtils.isBlank(model.getOutDate())){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//当前任务量(累计) |
| | | data.setNeedTransportOrderNum(data.getNeedTransportOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//同城剩余任务量(累计) |
| | | if(notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | /** |
| | | * 同城单子(无需配载但是未完成) |
| | | */ |
| | | if(StringUtils.isBlank(model.getOutDate()) |
| | | && !StringUtils.equals("1",model.getDispatchType()) && !StringUtils.equals("2",model.getDispatchType())){ |
| | | data.setNoNeedTransportOrderNum(data.getNoNeedTransportOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//同城剩余任务量(累计) |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//当前任务量(累计) |
| | | } |
| | | /** |
| | | * 今日出库量,出库时间为今天的 |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getOutDate()) && model.getOutDate().length()> 10){ |
| | | String tDate = model.getOutDate().substring(0,10); |
| | | if(tDate.equals(todayDate)){ |
| | | //如果是当日 |
| | | data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getNcTotality())));//今日出库量 |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),todayCodes)){ |
| | | todayCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | private boolean notInList(String transportCode, List<String> planCodes) { |
| | | for(String s :planCodes){ |
| | | if(StringUtils.equals(transportCode,s)){ |