From 7b51c9e1abc198a501f7858599da9c116130fd6f Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 27 三月 2025 16:47:51 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 407 ++++++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 282 insertions(+), 125 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java index f7245ee..afa0558 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java @@ -14,6 +14,7 @@ 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; @@ -90,6 +91,8 @@ private PlatformGroupMapper platformGroupMapper; @Autowired private TmsService tmsService; + @Autowired + private PlatformDeviceMapper platformDeviceMapper; @Value("${debug_model}") private Boolean isDebug; @@ -131,6 +134,7 @@ .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()) @@ -147,6 +151,7 @@ List<PlatformJob> jobs = platformJobMapper.selectList (new MPJLambdaWrapper<PlatformJob>() .select(PlatformJob::getTotalNum) .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .apply(" ( origin = 0 or origin is null) ") .eq(PlatformJob::getPlatformGroupId,platformGroupId) .apply("to_days(done_date) = to_days(now())") .in(PlatformJob::getStatus, Constants.PlatformJobStatus.DONE.getKey() @@ -489,7 +494,7 @@ List<WaningEventDataListVO> list = new ArrayList<>(); RuleEventSearchRequest request = new RuleEventSearchRequest(); request.setPageNo(1); - request.setPageSize(10); + request.setPageSize(1000); request.setFiledOptions(new ArrayList<>()); request.setSorts(new ArrayList<>()); RuleEventFiledOptionsRequest file = new RuleEventFiledOptionsRequest(); @@ -499,7 +504,6 @@ if(type == 1){ file.setFieldValue("131588");//瀹夐槻鍛婅 }else if(type == 2){ - file.setFieldValue("131593");//浜哄憳鍛婅 } request.getFiledOptions().add(file); @@ -507,34 +511,36 @@ sort.setSortField("happen_time"); sort.setSortType("desc"); request.getSorts().add(sort); + int total =0; BaseResponse<BaseListPageResponse< RuleEventSearchDataResponse>> result = HKService.ruleEventSearch(request); if(result!=null && StringUtils.equals(result.getCode(),HKConstants.RESPONSE_SUCCEE) && result.getData()!=null){ List<RuleEventSearchDataResponse> rlist = result.getData().getList(); - lastResult.setTotal(result.getData().getTotal()); if(rlist!=null){ String privateIp =systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.EVENT_FILES_PRIVATE_DOMAIN).getCode(); String publicIp =systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.EVENT_FILES_PUBLIC_DOMAIN).getCode(); for(RuleEventSearchDataResponse r :rlist){ try { - if(DateUtil.getISO8601DateByStr(r.getHappen_time()).getTime() >= Utils.Date.getStart(new Date()).getTime()){ + if(DateUtil.getISO8601DateByStr(r.getHappen_time()).getTime() < Utils.Date.getStart(new Date()).getTime()){ continue; } }catch (Exception e){ } + total ++; WaningEventDataListVO data = new WaningEventDataListVO(); + data.setCreateDate(DateUtil.getPlusTime(DateUtil.getISO8601DateByStr(r.getHappen_time()))); data.setAddr(r.getSrc_name()); data.setImg(r.getImage_url()); if(data.getImg()!=null){ data.setImg(data.getImg().replace(privateIp,publicIp)); } data.setTitle(r.getEvent_type_name()); - data.setCreateDate(DateUtil.getPlusTime(DateUtil.getISO8601DateByStr(r.getHappen_time()))); // data.setContent(r.get); list.add(data); } } } + lastResult.setTotal(total); lastResult.setList(list); return lastResult; } @@ -799,12 +805,44 @@ .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); + + 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>() @@ -844,7 +882,7 @@ if(detailList!=null){ for(PlatformWmsDetail d : detailList){ if(isExistIocode(d.getIocode(),data.getContractList())){ - continue; + continue; } tt = new CarsContractVO(); tt.setIoCode(d.getIocode()); @@ -857,10 +895,6 @@ } } - - - return data; - } private List<PlatformWmsDetail> getDetailListByCode(String iocode, List<PlatformWmsDetail> detailList,CarsContractVO tt) { @@ -910,25 +944,36 @@ @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());//浠婂勾 Date lastYear = DateUtil.addYearToDate(year,-1);//鍘诲勾 - List<PlatformJob> monthNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) - .select(PlatformJob::getType,PlatformJob::getType) + .select(PlatformJob::getType,PlatformJob::getType) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) .select(PlatformJob::getStatus,PlatformJob::getStatus) .eq(PlatformJob::getIsdeleted,Constants.ZERO) - .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) + .in(PlatformJob::getType,Constants.ONE,Constants.THREE) + .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(), + Constants.PlatformJobStatus.LEAVED.getKey(), + Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(done_date) = year('"+DateUtil.getPlusTime2(month)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(month)+"') ")); + + List<PlatformJob> yearNum = platformJobMapper.selectJoinList(PlatformJob.class, + new MPJLambdaWrapper<PlatformJob>() + .selectAs(PlatformJob::getId,PlatformJob::getId) + .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) + .select(PlatformJob::getStatus,PlatformJob::getStatus) + .select(PlatformJob::getType,PlatformJob::getType) +// .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum) + .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()) + .apply("year(done_date) = year('"+DateUtil.getPlusTime2(year)+"') and done_date<= now() ")); List<PlatformJob> monthLastNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) @@ -941,17 +986,7 @@ .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastMonth)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(lastMonth)+"') and done_date<= '" +DateUtil.getPlusTime2(lastMonth)+"'")); - List<PlatformJob> yearNum = platformJobMapper.selectJoinList(PlatformJob.class, - new MPJLambdaWrapper<PlatformJob>() - .selectAs(PlatformJob::getId,PlatformJob::getId) - .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) - .select(PlatformJob::getStatus,PlatformJob::getStatus) - .select(PlatformJob::getType,PlatformJob::getType) -// .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum) - .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()) - .apply("year(done_date) = year('"+DateUtil.getPlusTime2(year)+"') and done_date<= '"+DateUtil.getPlusTime2(year)+"'")); + List<PlatformJob> yearLastNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) @@ -961,7 +996,7 @@ .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()) - .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"') and done_date<= '"+DateUtil.getPlusTime2(lastYear)+"'")); + .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"') and done_date<= now() ")); data.setMonthOutTotal(getSumTotalByList(monthNum,0,null));//鏈湀鍑哄簱閲� data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//涓婃湀鍑哄簱閲� @@ -977,7 +1012,7 @@ .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())")); @@ -1037,7 +1072,6 @@ return data; } - private BigDecimal getDoneHoursByData(String start ,String end) { List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() .apply("create_date >= '"+start+"' and create_date <= '"+end+"'") @@ -1085,7 +1119,7 @@ return r; } - private BigDecimal getSumTotalByList(List<PlatformJob> list,Integer type,Integer status) { + private BigDecimal getSumTotalByList(List<PlatformJob> list,Integer type,Integer status) { BigDecimal r = new BigDecimal(0); if(list==null || list.size() == 0){ return r; @@ -1210,7 +1244,6 @@ @Override public YearDeviceDataVO yearFightingAdminDeviceData(){ YearDeviceDataVO data = new YearDeviceDataVO(); - FireStatisticRequest param = new FireStatisticRequest(); param.setIndexCode("api_fire_statistic"); BaseResponse<FireStatisticResponse> response = HKService.fireStatistic(param); @@ -1218,7 +1251,6 @@ data.setProtectNum(Constants.formatIntegerNum(response.getData().getMaintenanceNum())); data.setPlanProtectTotal(Constants.formatIntegerNum(response.getData().getDeviceTotalNum())); } - param = new FireStatisticRequest(); param.setIndexCode("api_fire_statistic_month"); BaseResponse<FireStatisticResponse> response1 = HKService.fireStatisticMonth(param); @@ -1228,7 +1260,6 @@ data.setMonthTotalNum(Constants.formatIntegerNum(response1.getData().getDeviceTotalNum())); } return data; - } /** @@ -1239,7 +1270,37 @@ public FightingAdminCenterDataVO centerFightingAdminData(){ FightingAdminCenterDataVO data = new FightingAdminCenterDataVO(); List<DeviceNumByTypeVO> list = new ArrayList<>(); - FireDevStatusTotalRequest param = new FireDevStatusTotalRequest(); + FindDeviceStatisticsRequest param1 = new FindDeviceStatisticsRequest(); + param1.setRegionIndexCode("root000000"); + BaseResponse<List<FindDeviceStatisticsResponse>> response = HKService.findDeviceStatistics(param1); + if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ + for(FindDeviceStatisticsResponse r :response.getData()){ + if(r.getDevices()!=null){ + for(FindDeviceStatisticsInfoResponse td : r.getDevices()){ + DeviceNumByTypeVO t = new DeviceNumByTypeVO(); + t.setTypeName(td.getDeviceName()); + //灞忚斀鏁� + t.setShieldDeviceNum(Constants.formatIntegerNum(t.getShieldDeviceNum() )+ Constants.formatIntegerNum(td.getShieldSensorCount())); + //鎶ヨ鏁� + t.setAlarmDeviceNum(Constants.formatIntegerNum(t.getAlarmDeviceNum())+ Constants.formatIntegerNum(td.getAlarmSensorCount())); + //姝e父鏁� + t.setOnlineDeviceNum(Constants.formatIntegerNum(t.getOnlineDeviceNum())+Constants.formatIntegerNum(td.getNormalSensorCount())); + //鏁呴殰鏁� + t.setErrDeviceNum(Constants.formatIntegerNum(t.getErrDeviceNum())+ Constants.formatIntegerNum(td.getFaultSensorCount())); + //鎬昏澶囨暟 + t.setTotalDeviceNum(Constants.formatIntegerNum(t.getTotalDeviceNum())+ Constants.formatIntegerNum(td.getTotalSensorCount())); + list.add(t); +// data.setOfflineDeviceNum(Constants.formatIntegerNum( data.getOfflineDeviceNum())+Constants.formatIntegerNum(t.getOfflineDeviceNum())); + data.setShieldDeviceNum(Constants.formatIntegerNum( data.getShieldDeviceNum())+Constants.formatIntegerNum(t.getShieldDeviceNum())); + data.setAlarmDeviceNum(Constants.formatIntegerNum( data.getAlarmDeviceNum())+Constants.formatIntegerNum(t.getAlarmDeviceNum())); + data.setOnlineDeviceNum(Constants.formatIntegerNum( data.getOnlineDeviceNum())+Constants.formatIntegerNum(t.getOnlineDeviceNum())); + data.setErrDeviceNum(Constants.formatIntegerNum( data.getErrDeviceNum())+Constants.formatIntegerNum(t.getErrDeviceNum())); + data.setTotalDeviceNum(Constants.formatIntegerNum( data.getTotalDeviceNum())+Constants.formatIntegerNum(t.getTotalDeviceNum())); + } + } + } + } + /* FireDevStatusTotalRequest param = new FireDevStatusTotalRequest(); param.setIncludeBool(1); param.setRegionIds(new String[]{"root000000"}); BaseResponse<List<FireDevStatusListResponse>> response = HKService.getFireDevStatusList(param); @@ -1259,7 +1320,7 @@ data.setErrDeviceNum(Constants.formatIntegerNum( data.getErrDeviceNum())+Constants.formatIntegerNum(r.getFaultFireDevCount())); data.setTotalDeviceNum(Constants.formatIntegerNum( data.getTotalDeviceNum())+Constants.formatIntegerNum(r.getTotalFireDevCount())); } - } + }*/ data.setDeviceTypeList(list); Long totalNum =hiddenDangerMapper.selectCount(new QueryWrapper<HiddenDanger>().lambda() .eq(HiddenDanger::getIsdeleted,Constants.ZERO ) @@ -1687,11 +1748,11 @@ .eq(Visits::getIsdeleted,Constants.ZERO) .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.pass,Constants.VisitStatus.xfSuccess )));//寰呰闂� - result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() + result.setRegisterVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() .eq(Visits::getIsdeleted,Constants.ZERO) .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.signout,Constants.VisitStatus.signin )));//宸茬櫥璁� - result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() + result.setLevelNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() .eq(Visits::getIsdeleted,Constants.ZERO) .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.signout )));//宸茬绂� @@ -1739,6 +1800,7 @@ result.getVisitRetentionDataList().add(t); }); } + result.setRetentionNum(result.getVisitRetentionDataList().size()); return result; } @@ -1752,6 +1814,7 @@ .selectAll(Retention.class) .selectAs(Company::getType,Retention::getCompanyType) .leftJoin(Company.class,Company::getId,Retention::getCompanyId) + .eq(Retention::getIsdeleted,Constants.ZERO) ); //浠婃棩鍦ㄥ洯浜烘暟 @@ -1850,6 +1913,10 @@ .orderByDesc(PlatformJob::getStatus ) .orderByAsc(PlatformJob::getId ) ); + List<PlatformDevice> platformDevices = platformDeviceMapper.selectList(new QueryWrapper<PlatformDevice>().lambda().eq(PlatformDevice::getType,Constants.ONE) + .eq(PlatformDevice::getIsdeleted,Constants.ZERO).isNotNull(PlatformDevice::getDeviceId)); + + String videoUrl = getVideoUrl(); //鏈堝彴鐘舵�侊細0=浣滀笟涓紱1=绌洪棽涓紱2=浣滀笟瓒呮椂;3=鍙彿 for(Platform model : platformList){ PlatformWorkDataVO platformDurationVO = new PlatformWorkDataVO(); @@ -1857,6 +1924,13 @@ platformDurationVO.setPlatformId(model.getId()); platformDurationVO.setPlatformCode(model.getCode()); platformDurationVO.setPlatformSort(model.getSortnum()); + if(CollectionUtils.isNotEmpty(platformDevices)){ + List<PlatformDevice> deviceList = platformDevices.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),model.getId())).collect(Collectors.toList()); + if (CollectionUtils.isNotEmpty(deviceList)) { + platformDurationVO.setDeviceId(deviceList.get(Constants.ZERO).getDeviceId()); + platformDurationVO.setVideoPluginUrl(videoUrl); + } + } PlatformJob job = getJobFromListById(model.getId(),jobList); if(job != null){ if(Constants.equalsInteger(job.getType(),Constants.ONE) || Constants.equalsInteger(job.getType(),Constants.THREE)){ @@ -1864,9 +1938,13 @@ }else{ platformDurationVO.setWorkType(Constants.ZERO);//濡傛灉鏄嵏璐� } - Integer workMinute = Constants.formatBigdecimal(job.getWorkNum()).multiply(new BigDecimal(60)).divide(model.getWorkRate(),0,BigDecimal.ROUND_HALF_UP).intValue(); - Date overDate = DateUtil.getXMinuteAfterDate(job.getNewStartDate(),workMinute + model.getWorkTimeoutAlarmTime());//棰勮瀹屾垚鏃堕棿 - platformDurationVO.setFinishTimeStr(DateUtil.DateToStr(overDate,"HH:mm")); + Integer workMinute = 0; + Date overDate =null; + if(model.getWorkRate()!=null && model.getWorkRate().compareTo(new BigDecimal(0)) !=0){ + workMinute = Constants.formatBigdecimal(job.getWorkNum()).multiply(new BigDecimal(60)).divide(model.getWorkRate(),0,BigDecimal.ROUND_HALF_UP).intValue(); + overDate = DateUtil.getXMinuteAfterDate(job.getNewStartDate(),workMinute + model.getWorkTimeoutAlarmTime());//棰勮瀹屾垚鏃堕棿 + platformDurationVO.setFinishTimeStr(DateUtil.DateToStr(overDate,"HH:mm")); + } platformDurationVO.setWorkNum(Constants.formatBigdecimal(job.getWorkNum()).intValue()); platformDurationVO.setCarNo(job.getCarCodeFront());//杞︾墝鍙� @@ -1875,7 +1953,7 @@ }else{ platformDurationVO.setStatus(Constants.ZERO); //浣滀笟涓� platformDurationVO.setWorkTime(PlatformJobServiceImpl.getWorkTime(job,platformLogMapper));//宸插伐浣滄椂闂� - if(overDate.getTime() < System.currentTimeMillis() ){ + if(overDate!=null && overDate.getTime() < System.currentTimeMillis() ){ model.setStatus(Constants.TWO); //浣滀笟宸茶秴鏃� } } @@ -1913,7 +1991,7 @@ 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() @@ -1927,7 +2005,7 @@ } int curtotalNum = 0; Date today = Utils.Date.getStart(new Date()); - long curTime=0, lastTime=0; + long curTime=0, lastTime=0 ; for (int i = 0; i < 8; i++) { lastTime = curTime;//涓婃鐨勬椂闂� int curHour = 8+(i*2); @@ -1950,7 +2028,7 @@ curtotalNum += Constants.formatIntegerNum(workEfficiencyVO.getWorkNum()) ; } workEfficiencyVO.setTotalWorkNum(curtotalNum);//绱鍊� - if(System.currentTimeMillis() < curTime){ + if((System.currentTimeMillis() + 2*60*60*1000) < curTime ){ workEfficiencyVO.setTotalWorkNum(0); } workEfficiencyVOList.add(workEfficiencyVO); @@ -2012,16 +2090,16 @@ data.setFreePlatform( list.stream().filter(i->Constants.formatIntegerNum(i.getWorkStatus())<=Constants.ZERO).collect(Collectors.toList()).size() ); - //鏌ヨ浠婃棩鏈堝彴涓姸鎬佷綔涓氭暟閲� + /* //鏌ヨ浠婃棩鏈堝彴涓姸鎬佷綔涓氭暟閲� List<PlatformJob> jobList = platformJobMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>() .selectAll(PlatformJob.class) .select("count(id)" ,PlatformJob::getCountum) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .apply("to_days(create_date) = to_days(now())" ) - .groupBy(PlatformJob::getStatus ) + .groupBy(PlatformJob::getStatus) ); - if(jobList!=null){ + if(jobList!=null){ //-------------TODO----------銆愮湅鏉裤�戠埍纭闇�姹�-------------- // * 0寰呯‘璁� 1寰呯鍒� 2绛夊緟鍙彿 3鍏ュ洯绛夊緟 4宸插彨鍙� 5浣滀笟涓� 6浣滀笟瀹屾垚 7杞Щ涓� 8寮傚父鎸傝捣 9宸叉巿鏉冪鍥� 10宸茬鍥� 11 宸茶繃鍙� 12宸插彇娑� for(PlatformJob model : jobList){ @@ -2098,14 +2176,64 @@ } } + }*/ + //棰勭害鏁� + data.setReservationCar(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .apply("to_days(create_date) = to_days(now())" )).intValue()); + //浣滀笟涓� + data.setWorkingCar(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) + ).intValue()); + //鎺掗槦杞� + data.setLineUpCar(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .in(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey(), + Constants.PlatformJobStatus.WAIT_CALL.getKey(), + Constants.PlatformJobStatus.IN_WAIT.getKey())).intValue()); + //宸插彨鍙� + data.setCalledNum(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .apply("to_days(call_date) = to_days(now())" )).intValue()); + //绛惧埌鏁� + data.setSignedNum(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .apply("to_days(sign_date) = to_days(now())" )).intValue()); + //浠婃棩瀹屾垚鏁� + data.setDoneNum(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .in(PlatformJob::getStatus,Constants.PlatformJobStatus.LEAVED.getKey(), + Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), + Constants.PlatformJobStatus.DONE.getKey()) + .apply("to_days(done_date) = to_days(now())" )).intValue()); - data.setVideoPluginUrl(getVideoUrl()); - String indexCodes = systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_CHANGNEI_SCREEN_INDEXCODES).getCode(); - if(StringUtils.isNotBlank(indexCodes)){ - data.setVideoIndexCodes(indexCodes.split(",")); - } + //宸蹭綔涓氭暟 + data.setWorkedNum(platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>() + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .and(w-> w.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey()) + .or().in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey() + ,Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() + ,Constants.PlatformJobStatus.LEAVED.getKey()).apply("to_days(done_date) = to_days(now())") + .or().eq(PlatformJob::getStatus,Constants.PlatformJobStatus.EXCEPTION.getKey()).apply("to_days(done_date) = to_days(now())") + .or().eq(PlatformJob::getStatus,Constants.PlatformJobStatus.TRANSFERING.getKey()).apply("to_days(trans_platform_date) = to_days(now())") + ) +// .and(w->{w.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey());}) +// .and(w->{w.in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey() +// ,Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() +// ,Constants.PlatformJobStatus.LEAVED.getKey()) +// .apply("to_days(done_date) = to_days(now())");}) +// .and(w->{w.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.EXCEPTION.getKey()) +// .apply("to_days(error_date) = to_days(now())");}) +// .and(w->{w.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.TRANSFERING.getKey()) +// .apply("to_days(trans_platform_date) = to_days(now())");}) + ).intValue()); + + data.setVideoPluginUrl(getVideoUrl()); + String indexCodes = systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_CHANGNEI_SCREEN_INDEXCODES).getCode(); + if(StringUtils.isNotBlank(indexCodes)){ + data.setVideoIndexCodes(indexCodes.split(",")); } - return data; } @@ -2207,6 +2335,9 @@ 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(); @@ -2254,73 +2385,26 @@ } 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涓嶄负绌篶ount(transport_code ) - */ - if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ - planCodes.add(model.getTransportCode()); - } - /** - * 浠婃棩涓嬭揪鍑哄簱鐨勮鍒掍换鍔″搴旂殑杩愯緭杞︽鏁� - * TRANSPORT_CODE涓嶄负绌篶ount(transport_code ) - */ - if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ - planCodes.add(model.getTransportCode()); - } - /** - * out_date涓哄綋鏃�,sum(NC_TOTALITY) 浠婃棩瀹屾垚鐨勫嚭搴撲綔涓氫换鍔℃�婚噺 - * TRANSPORT_CODE涓嶄负绌� 涓攐ut_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涓虹┖锛宻um(NC_TOTALITY) 鏄ㄥぉ鏈畬鎴愬嚭搴撹鍒掍换鍔� - * out_date涓虹┖ 涓擳RANSPORT_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)); } @@ -2335,7 +2419,59 @@ 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) { @@ -2356,7 +2492,10 @@ TotalOutQtyNumVO data = new TotalOutQtyNumVO(); data.setCurrentInNum(new BigDecimal(0)); data.setLastInNum(new BigDecimal(0)); + data.setCurrentProvinceNum(new BigDecimal(0)); + data.setCurrentOtherNum(new BigDecimal(0)); data.setSameInNum(new BigDecimal(0)); + //---------鐪佸---------------- data.setCurrentOutNum(new BigDecimal(0)); data.setLastOutNum(new BigDecimal(0)); @@ -2396,6 +2535,8 @@ List<TmsOutQtyAndVehicleQtyResponse> listSame= tmsService.getOutQtyAndVehicleQty(param);//鍘诲勾鍚屾湡 if(listSame!=null ){ for(TmsOutQtyAndVehicleQtyResponse model : listSame){ + model.setOutSideProvinceOutQty(Constants.formatBigdecimal(model.getOutSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getOutSideProvinceOutT01Qty())));//鐪佸绱 + model.setInSideProvinceOutQty(Constants.formatBigdecimal(model.getInSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getInSideProvinceOutT01Qty())));//鐪佸唴绱 data.setSameOutNum(data.getSameOutNum().add(Constants.formatBigdecimal(model.getOutSideProvinceOutQty()))); data.setSameInNum(data.getSameInNum().add(Constants.formatBigdecimal(model.getInSideProvinceOutQty()))); } @@ -2406,9 +2547,15 @@ List<TmsOutQtyAndVehicleQtyResponse> listCur = tmsService.getOutQtyAndVehicleQty(param);//鏈懆鏈� if(listCur!=null ){ for(TmsOutQtyAndVehicleQtyResponse model : listCur){ + model.setOutSideProvinceOutQty(Constants.formatBigdecimal(model.getOutSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getOutSideProvinceOutT01Qty())));//鐪佸绱 + model.setInSideProvinceOutQty(Constants.formatBigdecimal(model.getInSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getInSideProvinceOutT01Qty())));//鐪佸唴绱 data.setCurrentOutNum(data.getCurrentOutNum().add(Constants.formatBigdecimal(model.getOutSideProvinceOutQty()))); data.setCurrentInNum(data.getCurrentInNum().add(Constants.formatBigdecimal(model.getInSideProvinceOutQty()))); data.setTotalCarNum(data.getTotalCarNum()+Constants.formatIntegerNum(model.getVehicleQty()));//绱杞︽ + data.setCurrentProvinceNum(data.getCurrentProvinceNum().add(Constants.formatBigdecimal(model.getOutSideProvinceOutT01Qty())) + .add(Constants.formatBigdecimal(model.getInSideProvinceOutT01Qty())));//鐪佸唴鐪佸閿�鍞噺 + data.setCurrentOtherNum(data.getCurrentOtherNum().add(Constants.formatBigdecimal(model.getOutSideProvinceOutT03Qty())) + .add(Constants.formatBigdecimal(model.getInSideProvinceOutT03Qty())));//鐪佸唴鐪佸鍏朵粬鍑哄簱閲� } } param.setDateEnd(DateUtil.getShortTime(lastEnd)); @@ -2416,6 +2563,8 @@ List<TmsOutQtyAndVehicleQtyResponse> listLast = tmsService.getOutQtyAndVehicleQty(param);//涓婂懆鏈� if(listCur!=null ){ for(TmsOutQtyAndVehicleQtyResponse model : listLast){ + model.setOutSideProvinceOutQty(Constants.formatBigdecimal(model.getOutSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getOutSideProvinceOutT01Qty())));//鐪佸绱 + model.setInSideProvinceOutQty(Constants.formatBigdecimal(model.getInSideProvinceOutT03Qty()).add(Constants.formatBigdecimal(model.getInSideProvinceOutT01Qty())));//鐪佸唴绱 data.setLastOutNum(data.getLastOutNum().add(Constants.formatBigdecimal(model.getOutSideProvinceOutQty()))); data.setLastInNum(data.getLastInNum().add(Constants.formatBigdecimal(model.getInSideProvinceOutQty()))); } @@ -2429,6 +2578,8 @@ if(Constants.UNIT_TYPE == 1) { data.setCurrentInNum(Constants.formatBigdecimal(data.getCurrentInNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); data.setCurrentOutNum(Constants.formatBigdecimal(data.getCurrentOutNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + data.setCurrentOtherNum(Constants.formatBigdecimal(data.getCurrentOtherNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + data.setCurrentProvinceNum(Constants.formatBigdecimal(data.getCurrentProvinceNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); data.setLastInNum(Constants.formatBigdecimal(data.getLastInNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); data.setLastOutNum(Constants.formatBigdecimal(data.getLastOutNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); data.setSameInNum(Constants.formatBigdecimal(data.getSameInNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); @@ -2510,7 +2661,7 @@ return infoList; } /** - * 杩戜竷鏃ュ埌璐ф儏鍐� + * 杩戜竷鏃ュ埌璐ф儏鍐�-鏀规垚杩�15鏃� * @return */ @Override @@ -2522,17 +2673,17 @@ param.getFacrotyCodeList().add(code);//鏌ヨ鎸囧畾鍘傚尯 } Date date = new Date(); - Date startDate = DateUtil.addDaysToDate(date,-7); + Date startDate = DateUtil.addDaysToDate(date,-15); //鐪嬫澘澶у睆杩�7鏃ュ埌璐ф儏鍐垫棩鏈� 0琛ㄧず褰撳ぉ褰撳墠鎺�7澶╋紝-1琛ㄧず鏈湀鍒�1鍙�-7鍙� String flag = systemDictDataBiz.queryByCode(Constants.TSM_PARAM,Constants.SCREEN_SEVENT_ARRIVAL_STARTDATE).getCode(); if(StringUtils.equals(flag,"-1")){ startDate =DateUtil.getBeginDayOfMonth(0); - date = DateUtil.addDaysToDate(startDate,7); + date = DateUtil.addDaysToDate(startDate,15); } param.setNcCreateDateFrom(DateUtil.getShortTime(startDate)); param.setNcCreateDateThrough(DateUtil.getShortTime(date)); List<TmsSevenArrivalStatusAndDetailsResponse> infoList = tmsService.getSevenArrivalStatusAndDetails(param);//鏌ヨ鍑哄簱閲� - for (int i = 0; i < 7; i++) { + for (int i = 0; i < 15; i++) { LastSevenDaysOrderVo model = new LastSevenDaysOrderVo(); Date td = DateUtil.addDaysToDate(date,-i); model.setDateStr(DateUtil.getShortTime(td)); @@ -2573,6 +2724,7 @@ WholeProvinceZXTVO result = new WholeProvinceZXTVO(); result.setCurrentNum(new BigDecimal(0)); result.setTotalNum(new BigDecimal(0)); + result.setZtNum(new BigDecimal(0)); result.setUseRate(new BigDecimal(0)); result.setDetailList(new ArrayList<>()); List<TmsFactoryParam> paramList =factoryList(); @@ -2582,47 +2734,52 @@ WholeProvinceZxtDetailVO t = new WholeProvinceZxtDetailVO(); t.setFactoryName(p.getName()); t.setCurrentNum(new BigDecimal(0)); + t.setZaituNum(new BigDecimal(0)); t.setTotalNum(Constants.formatBigdecimal(p.getNum1()));//鎬诲簱瀛橀噺 getFromReportVehicleQtyList(p.getCode(),t,response);//澶勭悊鎻愭姤杩愬姏鍜屾�昏繍鍔涙暟鎹� t.setUseRate(new BigDecimal(0)); - if(t.getTotalNum().compareTo(new BigDecimal(0)) !=0){ - t.setUseRate(t.getCurrentNum().divide(t.getTotalNum(),4,BigDecimal.ROUND_HALF_UP)); + if((t.getTotalNum().subtract(t.getZaituNum())).compareTo(new BigDecimal(0)) !=0){ + t.setUseRate(t.getCurrentNum().divide(t.getTotalNum().subtract(t.getZaituNum()),4,BigDecimal.ROUND_HALF_UP)); } - if(Constants.UNIT_TYPE == 1) { + /*if(Constants.UNIT_TYPE == 1) { //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮 t.setCurrentNum(Constants.formatBigdecimal(t.getCurrentNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); t.setTotalNum(Constants.formatBigdecimal(t.getTotalNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); - - } + }*/ result.getDetailList().add(t); result.setCurrentNum(result.getCurrentNum().add(t.getCurrentNum())); result.setTotalNum(result.getTotalNum().add(t.getTotalNum())); + result.setZtNum(result.getZtNum().add(t.getZaituNum())); } } - if(result.getTotalNum().compareTo(new BigDecimal(0)) !=0){ - result.setUseRate(result.getCurrentNum().divide(result.getTotalNum(),4,BigDecimal.ROUND_HALF_UP)); + if((result.getTotalNum().subtract(result.getZtNum())).compareTo(new BigDecimal(0)) !=0){ + result.setUseRate(result.getCurrentNum().divide(result.getTotalNum().subtract(result.getZtNum()),4,BigDecimal.ROUND_HALF_UP)); } return result; } private void getFromReportVehicleQtyList(String code,WholeProvinceZxtDetailVO t, List<TmsTotalAndReportVehicleQtyResponse> responses) { BigDecimal current = new BigDecimal(0); BigDecimal total= new BigDecimal(0); + BigDecimal ztTotal= new BigDecimal(0); if(responses!=null && responses.size()>0){ for(TmsTotalAndReportVehicleQtyResponse model: responses){ if(StringUtils.equals(model.getFactoryCode(),code)){ + ztTotal = ztTotal.add(Constants.formatBigdecimal(model.getInTransitQty())); total = total.add(Constants.formatBigdecimal(model.getTotalQty())); current = current.add(Constants.formatBigdecimal(model.getReportQty())); } } } t.setCurrentNum(current); + t.setZaituNum(ztTotal); t.setTotalNum(total); } private BigDecimal getCurrentOutQryByList(List<TmsOutQtyAndVehicleQtyResponse> response) { BigDecimal r = new BigDecimal(0); if(response!=null && response.size()>0){ for(TmsOutQtyAndVehicleQtyResponse model: response){ - r = r.add(Constants.formatBigdecimal(model.getTotalOutQty())); +// model.setTotalOutQty(Constants.formatBigdecimal(model.getTotalOutT03Qty()).add(Constants.formatBigdecimal(model.getTotalOutT01Qty()))); + r = r.add(Constants.formatBigdecimal(model.getTotalOutQty())); } } return r ; -- Gitblit v1.9.3