From bb48c066cc11f571be02eb0dc7f9ef26dd3151ca Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期三, 02 四月 2025 10:08:48 +0800 Subject: [PATCH] 代码初始化 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 1179 ++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 1,048 insertions(+), 131 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 bc83623..540c76a 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,8 +14,11 @@ 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.core.model.PageData; -import com.doumee.core.model.PageWrap; +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; +import com.doumee.service.business.third.model.request.TmsSevenArrivalDetailsRequest; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; @@ -26,18 +29,22 @@ import com.doumee.dao.business.join.PlatformWarnEventJoinMapper; import com.doumee.dao.business.join.VisitsJoinMapper; import com.doumee.dao.business.model.*; +import com.doumee.dao.business.model.Member; import com.doumee.dao.web.reqeust.CarsJobAndContractDTO; import com.doumee.dao.web.response.platformReport.*; import com.doumee.service.business.impl.PlatformJobServiceImpl; -import com.doumee.service.business.impl.VisitsServiceImpl; import com.doumee.service.business.third.BoardService; +import com.doumee.service.business.third.TmsService; import com.doumee.service.business.third.WmsService; +import com.doumee.service.business.third.model.response.*; import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import com.github.yulichang.wrapper.MPJLambdaWrapper; +import io.swagger.annotations.ApiModelProperty; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import java.math.BigDecimal; @@ -63,6 +70,8 @@ @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired + private TmsFactoryParamMapper tmsFactoryParamMapper; + @Autowired private PlatformWarnEventJoinMapper platformWarnEventJoinMapper; @Autowired private PlatformJobMapper platformJobMapper; @@ -80,6 +89,13 @@ private RetentionMapper retentionMapper; @Autowired private PlatformGroupMapper platformGroupMapper; + @Autowired + private TmsService tmsService; + @Autowired + private PlatformDeviceMapper platformDeviceMapper; + + @Value("${debug_model}") + private Boolean isDebug; /** * 鑾峰彇鍖哄煙鏍戝舰缁撴瀯鏁版嵁 * @return @@ -118,19 +134,24 @@ .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()) .apply("to_days(done_date) = to_days(now())") ); if(jobs!=null){ for(PlatformJob j :jobs){ - num =num.add(Constants.formatBigdecimal(j.getTotalNum())); + if(Objects.nonNull(j)&&Objects.nonNull(j.getTotalNum())){ + num =num.add(Constants.formatBigdecimal(j.getTotalNum())); + } + } } }else{ 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() @@ -138,7 +159,9 @@ , Constants.PlatformJobStatus.LEAVED.getKey()) ); if(jobs!=null){ for(PlatformJob j :jobs){ - num = num.add(Constants.formatBigdecimal(j.getTotalNum())); + if(Objects.nonNull(j)&&Objects.nonNull(j.getTotalNum())){ + num = num.add(Constants.formatBigdecimal(j.getTotalNum())); + } } } } @@ -471,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(); @@ -481,7 +504,6 @@ if(type == 1){ file.setFieldValue("131588");//瀹夐槻鍛婅 }else if(type == 2){ - file.setFieldValue("131593");//浜哄憳鍛婅 } request.getFiledOptions().add(file); @@ -489,28 +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()){ + 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; } @@ -521,7 +551,6 @@ BaseResponse<CamerasPreviewURLsResponse> result = HKService.cameraPreviewURLs(request); if(result!=null && StringUtils.equals(result.getCode(),HKConstants.RESPONSE_SUCCEE) && result.getData()!=null){ return result.getData().getUrl(); - } return null; } @@ -572,25 +601,46 @@ public List<AlarmEventDataVO> fightingAdminAlertList(){ List<AlarmEventDataVO> data = new ArrayList<>(); - //鏌ヨ24灏忔椂鍐呯殑 + List<FindHomeAlarmInfoPageResponse> allList = new ArrayList<>(); + boolean hasNext = true; + int curTotal = 0; + int curPage = 1; FindHomeAlarmInfoPageRequest param = new FindHomeAlarmInfoPageRequest(); param.setHour(24); - param.setPage(1); param.setUserId("admin"); + while (hasNext){ + //鍒嗛〉閬嶅巻寰幆鏌ヨ鎵�鏈夐棬绂佽澶囨暟鎹� + param.setPage(curPage); // param.setRegionIndexCodes("root000000"); - param.setAlarmStartTime(DateUtil.getPlusTime2(DateUtil.addDaysToDate(new Date(),-1))); - param.setAlarmEndTime(DateUtil.getPlusTime2(new Date())); - param.setPageSize(20); - BaseResponse<BaseListPageResponse<FindHomeAlarmInfoPageResponse>> response = HKService.findHomeAlarmInfoPage(param); - if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) - && response.getData()!=null - &&response.getData().getList()!=null) { + param.setAlarmStartTime(DateUtil.getFomartDate(new Date(),"yyyy-MM-dd") + " 00:00:00"); + param.setAlarmEndTime(DateUtil.getPlusTime2(new Date())); + param.setPageSize(50); + BaseResponse<BaseListPageResponse<FindHomeAlarmInfoPageResponse>> response = HKService.findHomeAlarmInfoPage(param); + if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE)){ + throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝娴峰悍鍚屾鏁版嵁澶辫触~"); + } for(FindHomeAlarmInfoPageResponse r : response.getData().getList()){ AlarmEventDataVO t = new AlarmEventDataVO(); BeanUtils.copyProperties(r,t); - data.add(t); + try { + if(DateUtil.getDateFromString(t.getAlarmTime()).getTime() >= Utils.Date.getStart(new Date()).getTime()){ + data.add(t); + }else{ + hasNext =false; + } + }catch (Exception e){ + } } + curTotal += 50; + if(curTotal >= response.getData().getTotal()){ + hasNext = false; + } + if(response.getData().getList() == null || response.getData().getList().size()==0){ + hasNext =false; + } + curPage++; } + return data; } @@ -605,9 +655,14 @@ MinitorDataSearchRequest param = new MinitorDataSearchRequest(); param.setResourceTypeCodes(new String[]{}); param.setRegionIndexCode("root000000"); + param.setResourceTypeCodes("60,61".split(",")); param.setIncludeDown("1"); param.setUserId("admin"); + param.setPageNo(1); + param.setPageSize(100); BaseResponse<BaseListPageResponse<MonitorDataSearchResponse>> response = HKService.minitorDataSearch(param); + String pressure = systemDictDataBiz.queryByCode(Constants.WMS_PARAM,Constants.WMS_PRESSURE_LEVEL).getCode(); + String liquid = systemDictDataBiz.queryByCode(Constants.WMS_PARAM,Constants.WMS_LIQUID_LEVEL).getCode(); if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ) { List<MonitorDataSearchResponse> r = response.getData().getList(); @@ -615,17 +670,37 @@ for(MonitorDataSearchResponse model : r){ MonitorDataVO m = new MonitorDataVO(); m.setName(model.getName()); + m.setLevel(Constants.equalsInteger(model.getType(),60)?liquid:pressure); m.setDataList(new ArrayList<>()); if(model.getValues()!=null){ + List<MonitorDataInfoVO> dataList = new ArrayList<>(); for(MonitorDataValResponse v : model.getValues()){ - MonitorDataInfoVO vm = new MonitorDataInfoVO(); - vm.setValue(v.getMonitorValue()); - vm.setCateName(v.getMonitorSpecificName()); - vm.setCateCode(v.getMonitorTypeKey()); - vm.setTypeCode(v.getMonitorTypeCode()); - vm.setTypeName(v.getMonitorTypeName()); + if(Constants.equalsInteger(model.getType(),60)){ + if(v.getMonitorTypeCode().equals("254001")){ + MonitorDataInfoVO vm = new MonitorDataInfoVO(); + vm.setValue(v.getMonitorValue()); + vm.setCateName(v.getMonitorSpecificName()); + vm.setCateCode(v.getMonitorTypeKey()); + vm.setTypeCode(v.getMonitorTypeCode()); + vm.setTypeName(v.getMonitorTypeName()); + dataList.add(vm); + } + }else{ + if(v.getMonitorTypeCode().equals("253958")){ + MonitorDataInfoVO vm = new MonitorDataInfoVO(); + vm.setValue(v.getMonitorValue()); + vm.setCateName(v.getMonitorSpecificName()); + vm.setCateCode(v.getMonitorTypeKey()); + vm.setTypeCode(v.getMonitorTypeCode()); + vm.setTypeName(v.getMonitorTypeName()); + dataList.add(vm); + } + } + } + m.setDataList(dataList); } + list.add(m); } } } @@ -671,6 +746,7 @@ .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getCreateDate,PlatformJob::getCreateDate) .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) + .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) // .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) .apply(queryType==0,"to_days(create_date) >= to_days(now()) -7") @@ -729,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>() @@ -774,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()); @@ -787,10 +895,6 @@ } } - - - return data; - } private List<PlatformWmsDetail> getDetailListByCode(String iocode, List<PlatformWmsDetail> detailList,CarsContractVO tt) { @@ -828,7 +932,7 @@ */ @Override public AlarmDataVO alarmDataSumByCate(){ - AlarmDataVO alarmDataVO = getAlertDataByStartEndTime(DateUtil.getPlusTime2(DateUtil.addDaysToDate(new Date(),-1)) + AlarmDataVO alarmDataVO = getAlertDataByStartEndTime(DateUtil.getPlusTime2(Utils.Date.getStart(new Date())) ,(DateUtil.getPlusTime2(new Date()))); return alarmDataVO; } @@ -840,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) @@ -871,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) @@ -891,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) );//涓婃湀鍑哄簱閲� @@ -907,10 +1012,13 @@ .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())")); + .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(), + Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() + ,Constants.PlatformJobStatus.CANCEL.getKey()) + .apply(" to_days(create_date) < to_days(now()) ") + ); //==========浠婂ぉ鍑哄叆搴撳畬鎴愰噺 List<PlatformJob> currentDoneNum = platformJobMapper.selectJoinList(PlatformJob.class, @@ -921,9 +1029,10 @@ .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) .eq(PlatformJob::getIsdeleted,Constants.ZERO) - .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) + .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CANCEL.getKey()) .apply(" to_days(done_date) = to_days(now())")); - //==========浠婂ぉ涓嬪彂鍑哄叆搴撲换鍔�---- + + //==========浠婂ぉ涓嬪彂鍑哄叆搴撲换鍔� 鏈畬鎴愮殑---- List<PlatformJob> currentNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) @@ -932,17 +1041,17 @@ .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) .eq(PlatformJob::getIsdeleted,Constants.ZERO) - .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) - .apply(" to_days(create_date) = to_days(now())")); + .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CANCEL.getKey()) + .apply(" to_days(create_date) = to_days(now()) and done_date is null ")); BigDecimal beforeOutNum = (getSumTotalByList(beforeJobNum,0,null));//浠婂ぉ涔嬪墠鏈畬鎴愬嚭搴撲换鍔� BigDecimal currentOutNum = (getSumTotalByList(currentNum,0,null));//浠婂ぉ涓嬪彂鍑哄簱浠诲姟 BigDecimal beforeInNum = (getSumTotalByList(beforeJobNum,1,null));//浠婂ぉ涔嬪墠鏈畬鎴愬叆搴撲换鍔� BigDecimal currentInNum = (getSumTotalByList(currentNum,1,null));//浠婂ぉ涓嬪彂鍏ュ簱浠诲姟 - data.setCurrentInNum(beforeInNum.add(currentInNum));//褰撳墠鍏ュ簱鎬讳换鍔℃垚閲� - data.setCurrentOutNum(beforeOutNum.add(currentOutNum));//褰撳墠鍑哄簱鎬讳换鍔℃垚閲� data.setCurrentInDoneNum(getSumTotalByList(currentDoneNum,1,1));//浠婃棩瀹屾垚閲� data.setCurrentOutDoneNum(getSumTotalByList(currentDoneNum,0,1));//浠婃棩瀹屾垚閲� + data.setCurrentInNum(beforeInNum.add(data.getCurrentInDoneNum()).add(currentInNum));//褰撳墠鍏ュ簱鎬讳换鍔℃垚閲� + data.setCurrentOutNum(beforeOutNum.add(data.getCurrentOutDoneNum()).add(currentOutNum));//褰撳墠鍑哄簱鎬讳换鍔℃垚閲� //------------浠婃棩鍑哄叆搴撴晥鐜�---------------- BigDecimal outHours = getTotalDoneTimes(currentDoneNum,0);// @@ -966,7 +1075,6 @@ } return data; } - private BigDecimal getDoneHoursByData(String start ,String end) { List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() @@ -1009,13 +1117,13 @@ .isNotNull(PlatformLog::getParam3) .ne(PlatformLog::getParam3,Constants.ZERO+"")); if(platformLogList!=null && platformLogList.size()>0){ - return new BigDecimal((double)(platformLogList.stream().map(m->Long.valueOf(m.getParam3())).reduce(Long.valueOf(0),Long::sum))/(double)60); + return new BigDecimal((double)(platformLogList.stream().map(m->Long.valueOf(m.getParam3())).reduce(Long.valueOf(0),Long::sum))/(double)3600); } } 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; @@ -1065,10 +1173,11 @@ //濡傛灉鏄湪绾挎垨鑰呬紤鐪狅紝鏌ヨ鍦ㄩ�旇繕鏄┖闂瞭y codes.add(model.getPlateNum()); model.setJobStatus(Constants.ZERO); - }else + }else{ model.setJobStatus(Constants.TWO); data.setOfflineNum(data.getOfflineNum()+1); } + } if(codes.size()>0){ //鐘舵�� 0寰呯‘璁� 1寰呯鍒� 2绛夊緟鍙彿 3鍏ュ洯绛夊緟 4宸插彨鍙� 5浣滀笟涓� 6浣滀笟瀹屾垚 7杞Щ涓� 8寮傚父鎸傝捣 9宸叉巿鏉冪鍥� 10宸茬鍥� 11 宸茶繃鍙� 12鍙栨秷锛圵MS锛� List<PlatformJob> busyNum = platformJobMapper.selectList(new QueryWrapper<PlatformJob>() .lambda() @@ -1139,7 +1248,6 @@ @Override public YearDeviceDataVO yearFightingAdminDeviceData(){ YearDeviceDataVO data = new YearDeviceDataVO(); - FireStatisticRequest param = new FireStatisticRequest(); param.setIndexCode("api_fire_statistic"); BaseResponse<FireStatisticResponse> response = HKService.fireStatistic(param); @@ -1147,17 +1255,15 @@ 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); if(response1 != null && StringUtils.equals(response1.getCode(), HKConstants.RESPONSE_SUCCEE) && response1.getData()!=null ) { - data.setMonthAddNum(Constants.formatIntegerNum(response1.getData().getMaintenanceNum())); + data.setMonthAddNum(Constants.formatIntegerNum(response1.getData().getMaintenanceNumMonth())); data.setMonthTotalNum(Constants.formatIntegerNum(response1.getData().getDeviceTotalNum())); } - return data; - + return data; } /** @@ -1168,7 +1274,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); @@ -1188,7 +1324,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 ) @@ -1226,7 +1362,13 @@ temperatureHumidityDataResponseList.stream().filter(i->i.getIndexCode().indexOf(code)>=Constants.ZERO).collect(Collectors.toList()); TemperatureHumidityDataVO temperatureHumidityDataVO = new TemperatureHumidityDataVO(); for (TemperatureHumidityDataResponse data:dateList) { - if(data.getSensorType().equals("temp")){ + if(StringUtils.isNotBlank(data.getName())){ + Integer index = data.getName().indexOf("-"); + if(index>=0){ + data.setName(data.getName().substring(0,index)); + } + } + if(data.getSensorType().equals("currTemperature")){ temperatureHumidityDataVO.setTemperatureData(data); }else{ temperatureHumidityDataVO.setHumidityData(data); @@ -1247,8 +1389,8 @@ */ @Override public EnergyBoardVO centerEnergyData(){ - EnergyBoardVO data = new EnergyBoardVO(); - Random random = new Random(); + EnergyBoardVO data = new EnergyBoardVO(); + Random random = new Random(); PlatformWaterGas smoke= platformWaterGasMapper.selectOne(new QueryWrapper<PlatformWaterGas>() .select("sum(num) as num") .lambda() @@ -1265,17 +1407,22 @@ BigDecimal carbonWater = new BigDecimal(0);//鏈湀鐢ㄦ按 BigDecimal carbonElec = new BigDecimal(0);//鐢ㄧ數 + data.setYesterdayElectricity(getDefaultData());//鏄ㄦ棩鐢ㄧ數 data.setTodayElectricity(getDefaultData());//浠婃棩鐢ㄧ數 data.setElectricityQuantity(getDefaultData());//涓婃湀鐢ㄧ數 - data.setWaterQuantity(getDefaultData());//涓婃湀鐢ㄦ按 - data.setGasQuantity(getDefaultData());//涓婃湀鐢ㄦ皵 data.setMonthElectricity(getDefaultData());//鏈湀鐢ㄧ數 - data.setYesterdayElectricity(getDefaultData());//鏄ㄦ棩鐢ㄧ數 + + getMonthElectricityData(data.getMonthElectricity());//閫氳繃瀹夐槻骞宠幏鍙栨湰鏈堢敤鐢甸噺鏁版嵁 carbonElec = new BigDecimal(StringUtils.defaultString(data.getMonthElectricity().getTotal(), "0")); + getLastMonthElectricityData(data.getElectricityQuantity());//閫氳繃瀹夐槻骞宠幏鍙栦笂鏈堢敤鐢甸噺鏁版嵁 - getCurrentDateElectircityData(data.getTodayElectricity(),0);//閫氳繃瀹夐槻骞宠幏鍙栦粖鏃ョ敤鐢甸噺鏁版嵁 getCurrentDateElectircityData(data.getYesterdayElectricity(),-1);//閫氳繃瀹夐槻骞宠幏鍙栨槰鏃ョ敤鐢甸噺鏁版嵁 + getCurrentDateElectircityData(data.getTodayElectricity(),0);//閫氳繃瀹夐槻骞宠幏鍙栦粖鏃ョ敤鐢甸噺鏁版嵁 + + data.setWaterQuantity(getDefaultData());//涓婃湀鐢ㄦ按 + data.setGasQuantity(getDefaultData());//涓婃湀鐢ㄦ皵 + carbonElec = new BigDecimal(StringUtils.defaultString(data.getMonthElectricity().getTotal(), "0")); String firstDate = DateUtil.getFirstDayCurrentMonth() +" 00:00:00"; Date month0 = DateUtil.getDateFromString(firstDate); Date month1 = DateUtil.increaseMonth(month0,-1);//涓婃湀 @@ -1326,8 +1473,19 @@ } if( data.getGasQuantity().getTotalNum().compareTo(new BigDecimal(0)) !=0){ //璁$畻鐢ㄦ皵鍚屾瘮鐜瘮 - data.getGasQuantity().setSameRate(Constants.formatBigdecimal4Float(data.getGasQuantity().getSameNum().divide(data.getGasQuantity().getTotalNum(),4,BigDecimal.ROUND_HALF_UP)).doubleValue()*100 +""); - data.getGasQuantity().setRingRate(Constants.formatBigdecimal4Float(data.getGasQuantity().getRingNum().divide(data.getGasQuantity().getTotalNum(),4,BigDecimal.ROUND_HALF_UP)).doubleValue()*100 +""); + if(Constants.formatBigdecimal(data.getGasQuantity().getSameNum()).compareTo(new BigDecimal(0))!=0){ + data.getGasQuantity().setSameRate( + (data.getGasQuantity().getTotalNum().subtract(data.getGasQuantity().getSameNum())).divide(data.getGasQuantity().getSameNum(),4,BigDecimal.ROUND_HALF_UP).doubleValue()*100 +"" + /*Constants.formatBigdecimal4Float(data.getGasQuantity().getSameNum() + .divide(data.getGasQuantity().getTotalNum(),4,BigDecimal.ROUND_HALF_UP)).doubleValue()*100 +""*/); + } + if(Constants.formatBigdecimal(data.getGasQuantity().getRingNum()).compareTo(new BigDecimal(0))!=0){ + data.getGasQuantity().setRingRate( + (data.getGasQuantity().getTotalNum().subtract(data.getGasQuantity().getRingNum())).divide(data.getGasQuantity().getRingNum(),4,BigDecimal.ROUND_HALF_UP).doubleValue()*100 +"" + //Constants.formatBigdecimal4Float(data.getGasQuantity().getRingNum().divide(data.getGasQuantity().getTotalNum(),4,BigDecimal.ROUND_HALF_UP)).doubleValue()*100 +"" + ); + } + } if( data.getWaterQuantity().getTotalNum().compareTo(new BigDecimal(0)) !=0){ // //璁$畻鐢ㄦ按鍚屾瘮鐜瘮 @@ -1364,36 +1522,94 @@ * @param data */ private void getLastMonthElectricityData(EnergyModelDataVO data) { - BaseResponse<LastMonthFeeByMeterTypeResponse> response = HKService.lastMonthFeeByMeterType("1"); - if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ - data.setRingRate(StringUtils.defaultString(response.getData().getRingPercent(),"0")); - data.setSameRate(StringUtils.defaultString(response.getData().getSamePercent(),"0")); - data.setTotal(StringUtils.defaultString(response.getData().getValue(),"0")); +// BaseResponse<LastMonthFeeByMeterTypeResponse> response = HKService.lastMonthFeeByMeterType("1"); +// if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ +// data.setRingRate(StringUtils.defaultString(response.getData().getRingPercent(),"0")); +// data.setSameRate(StringUtils.defaultString(response.getData().getSamePercent(),"0")); +// data.setTotal(StringUtils.defaultString(response.getData().getValue(),"0")); +// } +// String nowMonth = DateUtil.getFomartDate(new Date(),"yyyy-MM-dd"); +// //涓婃湀鏃ユ湡 +// DateUtil.getBeforMonthStr(new Date(),1); +// //涓婁笂鏈堟棩鏈� +// DateUtil.getBeforMonthStr(new Date(),2); +// //涓婂勾鏃ユ湡 +// DateUtil.getBeforMonthStr(new Date(),13); + + EnergyTotalDataRequest param = new EnergyTotalDataRequest(); + param.setPeriodType("month"); + param.setDate(DateUtil.getBeforMonthStr(new Date(),1).substring(0,7)); + BaseResponse<EnergyTotalDataResponse> beforMonthResponse = HKService.energyTotal(param); + if(beforMonthResponse != null && StringUtils.equals(beforMonthResponse.getCode(), HKConstants.RESPONSE_SUCCEE) && beforMonthResponse.getData()!=null ){ + data.setTotal(beforMonthResponse.getData().getElectricity()); + data.setTotalNum(new BigDecimal(beforMonthResponse.getData().getElectricity())); + } + param.setDate(DateUtil.getBeforMonthStr(new Date(),2).substring(0,7)); + BaseResponse<EnergyTotalDataResponse> beforBeforMonthResponse = HKService.energyTotal(param); + if(beforBeforMonthResponse != null && StringUtils.equals(beforBeforMonthResponse.getCode(), HKConstants.RESPONSE_SUCCEE) && beforBeforMonthResponse.getData()!=null ){ + if(Objects.nonNull(beforBeforMonthResponse.getData()) && StringUtils.isNotBlank(beforBeforMonthResponse.getData().getElectricity())){ + data.setRingNum(new BigDecimal(beforBeforMonthResponse.getData().getElectricity())); + }else{ + data.setRingNum(BigDecimal.ZERO); + } + if(Objects.isNull(data.getTotal()) || Objects.isNull(data.getRingNum()) + || data.getTotalNum().compareTo(BigDecimal.ZERO) ==0 || data.getRingNum().compareTo(BigDecimal.ZERO) ==0 ){ + data.setRingRate("0"); + }else{ + data.setRingRate(new BigDecimal(data.getTotal()).divide(data.getRingNum(),2,BigDecimal.ROUND_HALF_UP).toString()); + } + } + param.setDate(DateUtil.getBeforMonthStr(new Date(),13).substring(0,7)); + BaseResponse<EnergyTotalDataResponse> beforYearMonthResponse = HKService.energyTotal(param); + if(beforYearMonthResponse != null && StringUtils.equals(beforYearMonthResponse.getCode(), HKConstants.RESPONSE_SUCCEE) && beforBeforMonthResponse.getData()!=null ){ + if(Objects.nonNull(beforYearMonthResponse.getData()) && StringUtils.isNotBlank(beforYearMonthResponse.getData().getElectricity())){ + data.setSameNum(new BigDecimal(beforYearMonthResponse.getData().getElectricity())); + }else{ + data.setSameNum(BigDecimal.ZERO); + } + if(Objects.isNull(data.getTotal()) || Objects.isNull(data.getSameNum()) + || data.getTotalNum().compareTo(BigDecimal.ZERO) ==0 || data.getSameNum().compareTo(BigDecimal.ZERO) ==0 ){ + data.setSameRate("0"); + }else{ + data.setSameRate(new BigDecimal(data.getTotal()).divide(data.getSameNum(),2,BigDecimal.ROUND_HALF_UP).toString()); + } } } + + + + /** * 閫氳繃瀹夐槻骞宠幏鍙栦粖鏃ョ敤鐢甸噺 * @param data */ private void getCurrentDateElectircityData(EnergyModelDataVO data,int days) { - EnergyTrendRequest param = new EnergyTrendRequest(); - param.setDate(DateUtil.getFomartDate(DateUtil.addDaysToDate(new Date(),days),"yyyy-MM-dd"));//鏃ユ湡 - param.setMeterType(1); - param.setShowType("4"); - param.setNodeType(2); - param.setNodeId("root000000"); +// EnergyTrendRequest param = new EnergyTrendRequest(); +// param.setDate(DateUtil.getFomartDate(DateUtil.addDaysToDate(new Date(),days),"yyyy-MM-dd"));//鏃ユ湡 +// param.setMeterType(1); +// param.setShowType("4"); +// param.setNodeType(2); +// param.setNodeId("root000000"); +// param.setPeriodType("day"); +// BigDecimal total = new BigDecimal(0); +// BaseResponse<EnergyTrendResponse> response = HKService.energyTrend(param); +// if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) +// && response.getData()!=null&& response.getData().getYvalues()!=null ){ +// for (int i = 0; i < response.getData().getYvalues().get(0).getValue().length; i++) { +// total = total.add(new BigDecimal(StringUtils.defaultString( response.getData().getYvalues().get(0).getValue()[i],"0"))); +// } +// +// } +// data.setTotal(Constants.formatBigdecimal2Float(total).toString()); + EnergyTotalDataRequest param = new EnergyTotalDataRequest(); param.setPeriodType("day"); - BigDecimal total = new BigDecimal(0); - BaseResponse<EnergyTrendResponse> response = HKService.energyTrend(param); - if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) - && response.getData()!=null&& response.getData().getYvalues()!=null ){ - for (int i = 0; i < response.getData().getYvalues().get(0).getValue().length; i++) { - total = total.add(new BigDecimal(StringUtils.defaultString( response.getData().getYvalues().get(0).getValue()[i],"0"))); - } - + param.setDate(DateUtil.getFomartDate(DateUtil.addDaysToDate(new Date(),days),"yyyy-MM-dd")); + BaseResponse<EnergyTotalDataResponse> beforMonthResponse = HKService.energyTotal(param); + if(beforMonthResponse != null && StringUtils.equals(beforMonthResponse.getCode(), HKConstants.RESPONSE_SUCCEE) && beforMonthResponse.getData()!=null ){ + data.setTotal(beforMonthResponse.getData().getElectricity()); + data.setTotalNum(new BigDecimal(beforMonthResponse.getData().getElectricity())); } - data.setTotal(Constants.formatBigdecimal2Float(total).toString()); } private EnergyModelDataVO getDefaultData() { @@ -1420,7 +1636,6 @@ } if(data == null){ data = new RegionEnergyListResponse(); - data.setSecondRegionDataList(new ArrayList<>()); data.setRootValue("0"); data.setSamePercent("0"); data.setRingPercent("0"); @@ -1463,7 +1678,7 @@ .last(" group by DATE_FORMAT(TIME_INFO,'%Y-%m')") ); for (int i = 0; i < 12; i++) { - Date tempDate = DateUtil.increaseMonth(lastMonth,i); + Date tempDate = DateUtil.increaseMonth(lastMonth,i); EnergyDataVO data = new EnergyDataVO(); data.setTimeData(DateUtil.getFomartDate(tempDate,"YYYY-MM")); data.setEnergy(new BigDecimal(0)); @@ -1477,26 +1692,50 @@ energyDataVOList.add(data); } }else{ + String lastYear = null; + int lastMonths = 0,curMonths =0; + String curYear =DateUtil.getFomartDate(new Date(),"yyyy"); for (int i = 0; i < 12; i++) { Date tempDate = DateUtil.increaseMonth(lastMonth,i); + String tt =DateUtil.getFomartDate(tempDate,"yyyy"); + if(!StringUtils.equals(curYear,tt)){ + lastYear = tt; + lastMonths = i+1;//鍘诲勾鐨勬湀浠芥暟 + } EnergyDataVO data = new EnergyDataVO(); - data.setTimeData(DateUtil.getFomartDate(tempDate,(i+1)+"鏈�")); + data.setTimeData(DateUtil.getFomartDate(tempDate,"YYYY-MM")); +// data.setTimeData(DateUtil.getFomartDate(tempDate,(i+1)+"鏈�")); data.setEnergy(new BigDecimal(0)); energyDataVOList.add(data); } - //濡傛灉鏄敤鐢垫暟鎹� + curMonths = 12 - lastMonths;//浠婂勾鐨勬湀浠芥暟 EnergyTrendRequest param = new EnergyTrendRequest(); - param.setDate(DateUtil.getFomartDate(new Date(),"yyyy"));//骞翠唤 param.setMeterType(1); param.setNodeType(2); param.setNodeId("root000000"); param.setPeriodType("year"); + if(lastYear!=null){ + //濡傛灉鏄敤鐢垫暟鎹� + param.setDate(lastYear);//鏌ヨ鍘诲勾骞翠唤 + BaseResponse<EnergyTrendResponse> response = HKService.energyTrend(param); + if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null&& response.getData().getYvalues()!=null ){ + for (int i = 0; i < lastMonths; i++) { //0,11锛屽彇鍊�1-12 + if(response.getData().getYvalues().size()>0 &&response.getData().getYvalues().get(0).getValue().length>curMonths+i){ + //鍙栫浉搴旂殑鍙傛暟鍊� + energyDataVOList.get(i).setEnergy(new BigDecimal(StringUtils.defaultString(response.getData().getYvalues().get(0).getValue()[curMonths+i],"0"))); + } + } + + } + } + //濡傛灉鏄敤鐢垫暟鎹� + param.setDate(curYear);//骞翠唤 BaseResponse<EnergyTrendResponse> response = HKService.energyTrend(param); if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null&& response.getData().getYvalues()!=null ){ - for (int i = 0; i < 12; i++) { - if(response.getData().getYvalues().size()>0 &&response.getData().getYvalues().get(0).getValue().length>i){ + for (int i = lastMonths; i < 12; i++) { //12 鍙栧�� 0 + if(response.getData().getYvalues().size()>0 &&response.getData().getYvalues().get(0).getValue().length>i-lastMonths){ //鍙栫浉搴旂殑鍙傛暟鍊� - energyDataVOList.get(i).setEnergy(new BigDecimal(StringUtils.defaultString(response.getData().getYvalues().get(0).getValue()[i],"0"))); + energyDataVOList.get(i).setEnergy(new BigDecimal(StringUtils.defaultString(response.getData().getYvalues().get(0).getValue()[i-lastMonths],"0"))); } } @@ -1513,11 +1752,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 )));//宸茬绂� @@ -1565,6 +1804,7 @@ result.getVisitRetentionDataList().add(t); }); } + result.setRetentionNum(result.getVisitRetentionDataList().size()); return result; } @@ -1578,6 +1818,7 @@ .selectAll(Retention.class) .selectAs(Company::getType,Retention::getCompanyType) .leftJoin(Company.class,Company::getId,Retention::getCompanyId) + .eq(Retention::getIsdeleted,Constants.ZERO) ); //浠婃棩鍦ㄥ洯浜烘暟 @@ -1597,7 +1838,7 @@ (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)&&Objects.isNull(i.getCompanyType())).count() ); //鍦ㄥ洯杞﹁締 - data.setInternalCarTotal( + data.setInParkCarTotal( (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE)).count() ); //鍦ㄥ洯鐩稿叧鏂硅溅杈� @@ -1665,19 +1906,35 @@ if(platformList!=null && platformList.size()>0){ List<PlatformJob> jobList = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAll( PlatformJob.class) +// .selectAs(Platform::getCode,PlatformJob::getPlatformCode) .select("( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate") //.select(" ( select sum(ifnull(pl.IO_QTY , 0 )) from platform_wms_detail pl where pl.job_id = t.id and pl.isdeleted=0 )",PlatformJob::getWorkNum) .select(" ( case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end )",PlatformJob::getWorkNum) - .apply("to_days(t.create_date) = to_days(now())") +// .apply("to_days(t.create_date) = to_days(now())") .eq(Platform::getIsdeleted, Constants.ZERO) .in(PlatformJob ::getStatus,new Integer[]{Constants.PlatformJobStatus.WORKING.getKey(),Constants.PlatformJobStatus.CALLED.getKey() }) - .orderByDesc(PlatformJob::getStatus )); +// .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) + .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(); platformDurationVO.setPlatformName(model.getName()); 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)){ @@ -1685,9 +1942,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());//杞︾墝鍙� @@ -1696,7 +1957,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); //浣滀笟宸茶秴鏃� } } @@ -1734,7 +1995,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() @@ -1748,7 +2009,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); @@ -1771,6 +2032,9 @@ curtotalNum += Constants.formatIntegerNum(workEfficiencyVO.getWorkNum()) ; } workEfficiencyVO.setTotalWorkNum(curtotalNum);//绱鍊� + if((System.currentTimeMillis() + 2*60*60*1000) < curTime ){ + workEfficiencyVO.setTotalWorkNum(0); + } workEfficiencyVOList.add(workEfficiencyVO); } return workEfficiencyVOList; @@ -1830,16 +2094,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){ @@ -1876,6 +2140,7 @@ data.setReservationCar(data.getReservationCar()+Constants.formatIntegerNum(model.getCountum())); data.setCalledNum(data.getCalledNum()+Constants.formatIntegerNum(model.getCountum())); data.setWorkedNum(data.getWorkedNum()+Constants.formatIntegerNum(model.getCountum())); + data.setWorkingCar(data.getWorkingCar()+Constants.formatIntegerNum(model.getCountum())); } // 浣滀笟瀹屾垚锛堥绾﹁溅銆佺鍒版暟銆佸凡鍙彿銆佷綔涓氳溅銆佸凡瀹屾垚锛� if(Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.DONE.getKey())){ @@ -1901,7 +2166,7 @@ } // 宸茬鍥� if(Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.LEAVED.getKey())){ - data.setWorkingCar(data.getWorkingCar()+Constants.formatIntegerNum(model.getCountum())); + // data.setWorkingCar(data.getWorkingCar()+Constants.formatIntegerNum(model.getCountum())); } // 宸茶繃鍙凤紙棰勭害杞︺�佺鍒版暟銆佹帓闃熻溅锛� if(Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.OVER_NUMBER.getKey())){ @@ -1915,15 +2180,667 @@ } } + }*/ + //棰勭害鏁� + 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; + } + + /** + * 鏌ヨ鑳借�楃敤鐢典俊鎭� 1=浠婃棩锛�2=鏈湀锛�3=鏄ㄦ棩 + * @return + */ + @Override + public List<RegionDataRankingDataResponse> getRegionDataRanking(Integer type){ + RegionDataRankingDataRequest request = new RegionDataRankingDataRequest(); + request.setMeterType(1); + if(Constants.equalsInteger(type,Constants.ONE)){ + request.setDate(DateUtil.getFomartDate(new Date(),"yyyy-MM-dd")); + request.setPeriodType("day"); + }else if(Constants.equalsInteger(type,Constants.TWO)){ + request.setDate(DateUtil.getFomartDate(new Date(),"yyyy-MM")); + request.setPeriodType("month"); + }else{ + request.setDate(DateUtil.getBeforDay(new Date(),1)); + request.setPeriodType("day"); + } + BaseResponse<List<RegionDataRankingDataResponse>> response = HKService.regionDataRanking(request); + if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ + List<RegionDataRankingDataResponse> regionDataRankingDataResponseList = new ArrayList<>(); + for (RegionDataRankingDataResponse regionDataRankingDataResponse:response.getData()) { + if(StringUtils.isNotBlank(regionDataRankingDataResponse.getPercent())){ + if(Constants.equalsInteger(Integer.valueOf(new BigDecimal(regionDataRankingDataResponse.getPercent()).intValue()),Constants.ONE)){ + continue; + } + regionDataRankingDataResponseList.add(regionDataRankingDataResponse); + } + } + return regionDataRankingDataResponseList; + }else{ + return null; + } + } + /** + * 鍑哄簱鑳藉姏 + * @return + */ + @Override + public WholeProvinceZXTVO outAbilityUseRate(){ + WholeProvinceZXTVO result = new WholeProvinceZXTVO(); + result.setCurrentNum(new BigDecimal(0)); + result.setTotalNum(new BigDecimal(0)); + result.setUseRate(new BigDecimal(0)); + result.setDetailList(new ArrayList<>()); + List<TmsFactoryParam> paramList = factoryList(); + List<WholeProvinceZxtDetailVO> list = new ArrayList<>(); + TmsOutQtyAndVehicleQtyRequest param = new TmsOutQtyAndVehicleQtyRequest(); + if(paramList!=null){ + String startDate = DateUtil.formatDate(new Date(),"yyyy-MM-dd"); + String endDate = DateUtil.formatDate(new Date(),"yyyy-MM-dd"); + if(isDebug){ + startDate = "2024-12-01"; + endDate = "2024-12-05"; + } + for(TmsFactoryParam p : paramList){ + WholeProvinceZxtDetailVO t = new WholeProvinceZxtDetailVO(); + t.setFactoryName(p.getName()); + t.setCurrentNum(new BigDecimal(0)); + t.setUseRate(new BigDecimal(0)); + t.setTotalNum(Constants.formatBigdecimal(p.getParam3()));//8灏忔椂鍑哄簱鑳藉姏 + if(StringUtils.isNotBlank(p.getCode())){ + param.setFacrotyCodeList(new ArrayList<>()); + param.setDateStart(startDate); + param.setDateEnd(endDate); + param.getFacrotyCodeList().add(p.getCode()); + List<TmsOutQtyAndVehicleQtyResponse> response = tmsService.getOutQtyAndVehicleQty(param);//鏌ヨ鍑哄簱閲� + t.setCurrentNum(getCurrentOutQryByList(response)); + if(t.getTotalNum().compareTo(new BigDecimal(0)) !=0){ + t.setUseRate(t.getCurrentNum().divide(t.getTotalNum(),4,BigDecimal.ROUND_HALF_UP)); + } + 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())); + } + } + if(result.getTotalNum().compareTo(new BigDecimal(0)) !=0){ + result.setUseRate(result.getCurrentNum().divide(result.getTotalNum(),4,BigDecimal.ROUND_HALF_UP)); + } + return result; + } + /** + * 鍏ㄨ韩鍑哄簱鑳藉姏 + * @return + */ + @Override + public WholeProvinceBoardVO centerProvinceData(String factoryCode){ + WholeProvinceBoardVO data = new WholeProvinceBoardVO(); + data.setMaxAbility(new BigDecimal(0)); + 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(); + String code = null; + if(paramList!=null){ + //澶勭悊鏈�澶у嚭搴撹兘鍔涘拰8灏忔椂鍑哄簱鑳藉姏 + for(TmsFactoryParam param : paramList){ + if(StringUtils.isNotBlank(factoryCode)){ + if(StringUtils.equals(param.getCode(),factoryCode)){ + data.setHoursAbility(Constants.formatBigdecimal(param.getParam3())); + data.setMaxAbility(Constants.formatBigdecimal(param.getNum2())); + code = param.getCode(); + break; + } + }else{ + data.setHoursAbility(data.getHoursAbility().add(Constants.formatBigdecimal(param.getParam3()))); + data.setMaxAbility(data.getMaxAbility().add(Constants.formatBigdecimal(param.getNum2()))); + } + } + } + /* Date date = new Date(); + TmsOutQtyAndVehicleQtyRequest param = new TmsOutQtyAndVehicleQtyRequest(); + param.setDateEnd(DateUtil.getShortTime(date)); + param.setDateStart(DateUtil.getShortTime(date)); + if(StringUtils.isNotBlank(code)){ + param.setFacrotyCodeList(new ArrayList<>()); + param.getFacrotyCodeList().add(code);//鏌ヨ鎸囧畾鍘傚尯 + } + List<TmsOutQtyAndVehicleQtyResponse> listSame= tmsService.getOutQtyAndVehicleQty(param); + if(listSame!=null ){ + for(TmsOutQtyAndVehicleQtyResponse model : listSame){ + data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getTotalOutQty())));//浠婃棩鍑哄簱閲� + data.setCrrentOutCarNum(data.getCrrentOutCarNum()+(Constants.formatIntegerNum(model.getVehicleQty())));//浠婃棩鍑哄簱杞︽ + } + }*/ + initOutboundCapability(data,factoryCode); + return data; + + } + private void initOutboundCapability(WholeProvinceBoardVO data, String code) { + TmsFacrotyCodeListRequest param = new TmsFacrotyCodeListRequest(); + if(StringUtils.isNotBlank(code)){ + param.setFacrotyCodeList(new ArrayList<>()); + param.getFacrotyCodeList().add(code); + } + TmsOutboundCapabilityResponse result= tmsService.getOutboundCapability(param); + if(result !=null){ + String todayDate = DateUtil.getShortTime(new Date()); + List<String> planCodes = new ArrayList<>(); + List<String> todayCodes = new ArrayList<>(); + if(result.getCurrentDayOrderList()!=null && result.getCurrentDayOrderList().size()>0){ + for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayOrderList()){ + dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); + } + } + if(result.getCurrentDayAgoOrderList()!=null && result.getCurrentDayAgoOrderList().size()>0){ + for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayAgoOrderList()){ + dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); + } + } + 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()); + data.setCrrentRestCarNum(data.getCurrentPlanCarNum()); + if(data.getCrrentRestNum().compareTo(new BigDecimal(0)) <=0){ + data.setCrrentRestNum(new BigDecimal(0)); + } + if(data.getCrrentRestCarNum()<=0){ + data.setCrrentRestCarNum(0); + } + //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮 + if(Constants.UNIT_TYPE == 1) { + data.setMaxAbility(Constants.formatBigdecimal(data.getMaxAbility()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + data.setHoursAbility(Constants.formatBigdecimal(data.getHoursAbility()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + data.setCrrentRestNum(Constants.formatBigdecimal(data.getCrrentRestNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + 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()); + } } } - return data; } + private boolean notInList(String transportCode, List<String> planCodes) { + for(String s :planCodes){ + if(StringUtils.equals(transportCode,s)){ + return false; + } + } + return true; + } + + /** + * 鍑哄簱鑳藉姏鏉庢案鍒� + * @return + */ + @Override + public TotalOutQtyNumVO totalOutQtyNum(int type,String code){ + 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)); + data.setSameOutNum(new BigDecimal(0)); + + Date sameStart = DateUtil.getBeginDayOfMonth(-1); + Date sameEnd = DateUtil.getEndDayOfMonth(-1); + Date curStart = DateUtil.getBeginDayOfMonth(0); + Date curEnd = DateUtil.getEndDayOfMonth(0); + Date lastStart = DateUtil.getBeginDayOfLastMonth(); + Date lastEnd = DateUtil.getEndDayOfLastMonth(); + if(type ==1){ + //鏈懆 + sameStart= DateUtil.getBeginDayOfWeek(-1); + sameEnd= DateUtil.getEndDayOfWeek(-1); + curStart= DateUtil.getBeginDayOfWeek(0); + curEnd= DateUtil.getEndDayOfWeek(0); + lastStart = DateUtil.getBeginDayOfLastWeek(); + lastEnd= DateUtil.getEndDayOfLastWeek(); + }else if(type == 2){ + curStart= DateUtil.getBeginDayOfYear(0); + curEnd= DateUtil.getEndDayOfYear(0); + lastStart= DateUtil.getBeginDayOfYear(-1); + lastEnd= DateUtil.getEndDayOfYear(-1); + sameStart = null; + sameEnd =null; + } + TmsOutQtyAndVehicleQtyRequest param = new TmsOutQtyAndVehicleQtyRequest(); + if(StringUtils.isNotBlank(code)){ + param.setFacrotyCodeList(new ArrayList<>()); + param.getFacrotyCodeList().add(code); + } + if(type !=2){ + //鏈勾鐨勪笉闇�瑕佹煡鍘诲勾鍚屽懆鏈� + param.setDateEnd(DateUtil.getShortTime(sameEnd)); + param.setDateStart(DateUtil.getShortTime(sameStart)); + 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()))); + } + } + } + param.setDateEnd(DateUtil.getShortTime(curEnd)); + param.setDateStart(DateUtil.getShortTime(curStart)); + 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)); + param.setDateStart(DateUtil.getShortTime(lastStart)); + 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()))); + } + } + if(type == 2){//鏈勾鐨� + data.setSameOutNum(data.getLastOutNum()); + data.setSameInNum(data.getLastInNum()); + } + + //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮 + 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)); + data.setSameOutNum(Constants.formatBigdecimal(data.getSameOutNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + } + return data; + } + /** + * 鍑哄簱鑳藉姏鏉庢案鍒� + * @return + */ + @Override + public List<WholeProvinceMapVO> mapYearAndMonthOutList(String code){ + List<WholeProvinceMapVO> result = new ArrayList<>(); + TmsFacrotyCodeListRequest param = new TmsFacrotyCodeListRequest(); + if(StringUtils.isNotBlank(code)){ + param.setFacrotyCodeList(new ArrayList<>()); + param.getFacrotyCodeList().add(code); + } + List<TmsDistributionOfDeliveryLocResponse> response = tmsService.getDistributionOfDeliveryLocations(param);//鏌ヨ鍑哄簱閲� + if(response!=null &&response.size()>0){ + for(TmsDistributionOfDeliveryLocResponse model : response){ + WholeProvinceMapVO t = getFromProvinceResultList(model ,result); + if(t == null){ + t =new WholeProvinceMapVO(); + t.setMonthNum( Constants.formatBigdecimal0Float(model.getMonthOutboundQuantity())); + t.setYearNum( Constants.formatBigdecimal0Float(model.getYearOutboundQuantity())); + + if(Constants.UNIT_TYPE == 1) { + //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮 + t.setMonthNum(Constants.formatBigdecimal(t.getMonthNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + t.setYearNum(Constants.formatBigdecimal(t.getYearNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); + } + t.setProvinceCode(model.getToProvinceCode()); + t.setProvinceName(model.getToProvinceName()); + result.add(t); + } + } + } + return result; + } + + private WholeProvinceMapVO getFromProvinceResultList(TmsDistributionOfDeliveryLocResponse model, List<WholeProvinceMapVO> result) { + for(WholeProvinceMapVO t : result){ + if(StringUtils.equals(t.getProvinceCode(), model.getToProvinceCode())){ + t.setMonthNum(Constants.formatBigdecimal(t.getMonthNum()).add(Constants.formatBigdecimal0Float(model.getMonthOutboundQuantity()))); + t.setYearNum(Constants.formatBigdecimal(t.getYearNum()).add(Constants.formatBigdecimal0Float(model.getYearOutboundQuantity()))); + return t; + } + } + + return null; + } + + /** + * 鍑哄簱鑳藉姏鏉庢案鍒� + * @return + */ + @Override + public List<TmsFactoryParam> factoryList(){ + List<TmsFactoryParam> paramList = tmsFactoryParamMapper.selectList(new QueryWrapper<TmsFactoryParam>().lambda() + .eq(TmsFactoryParam::getIsdeleted,Constants.ZERO) + .orderByAsc(TmsFactoryParam::getSortnum)); + return paramList; + } + /** + * 鑾峰彇鏈畬鎴愯鍗曢泦鍚� + * @return TmsBaseResponse + */ + @Override + public TmsBasePageResponse<TmsOrderNoFinishListResponse> orderNoFinishList(TmsOrderNoFinishListRequest param){ + TmsBasePageResponse<TmsOrderNoFinishListResponse> infoList = tmsService.getNotFinishOrderList(param);//鏌ヨ鍑哄簱閲� + /* if(infoList!=null && infoList.getRows()!=null){ + for(TmsOrderNoFinishListResponse model :infoList.getRows()){ + model.setStatusDesc(TMSContants.TopStatusLevel.getNameByKey(TMSContants.ChildStatusLevel.getParentIndexByStatus(model.getStatus()))); + + } + }*/ + return infoList; + } + /** + * 杩戜竷鏃ュ埌璐ф儏鍐�-鏀规垚杩�15鏃� + * @return + */ + @Override + public List<LastSevenDaysOrderVo> arriveGoodsList(String code){ + List<LastSevenDaysOrderVo> list = new ArrayList<>(); + TmsSevenArrivalDetailsRequest param = new TmsSevenArrivalDetailsRequest(); + if(StringUtils.isNotBlank(code)){ + param.setFacrotyCodeList(new ArrayList<>()); + param.getFacrotyCodeList().add(code);//鏌ヨ鎸囧畾鍘傚尯 + } + Date date = new Date(); + 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,15); + } + param.setNcCreateDateFrom(DateUtil.getShortTime(startDate)); + param.setNcCreateDateThrough(DateUtil.getShortTime(date)); + List<TmsSevenArrivalStatusAndDetailsResponse> infoList = tmsService.getSevenArrivalStatusAndDetails(param);//鏌ヨ鍑哄簱閲� + for (int i = 0; i < 15; i++) { + LastSevenDaysOrderVo model = new LastSevenDaysOrderVo(); + Date td = DateUtil.addDaysToDate(date,-i); + model.setDateStr(DateUtil.getShortTime(td)); + dealGoodsListFromResponse(model,infoList); + list.add(model); + } + return list; + } + private void dealGoodsListFromResponse( LastSevenDaysOrderVo model, List<TmsSevenArrivalStatusAndDetailsResponse> list) { + model.setIngList(new ArrayList<>()); + model.setWaitList(new ArrayList<>()); + model.setDoneList(new ArrayList<>()); + if(list ==null || list.size()==0){ + return; + } + for(TmsSevenArrivalStatusAndDetailsResponse temp : list){ + if(StringUtils.equals(temp.getNcCreateDate(),model.getDateStr())){ + if(Constants.equalsInteger(temp.getStatus(),Constants.ZERO)){ + model.getWaitList().add(temp); + }else if(Constants.equalsInteger(temp.getStatus(),Constants.ONE)){ + model.getIngList().add(temp); + }else if(Constants.equalsInteger(temp.getStatus(),Constants.TWO)){ + model.getDoneList().add(temp); + } + } + } + model.setDoneNum(model.getDoneList().size()); + model.setIngNum(model.getIngList().size()); + model.setWaitNum(model.getWaitList().size()); + } + + /** + * 鍑哄簱鑳藉姏鏉庢案鍒� + * @return + */ + @Override + public WholeProvinceZXTVO tranportAbilityUseRate(){ + 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(); + if(paramList!=null){ + List<TmsTotalAndReportVehicleQtyResponse> response = tmsService.getTotalAndReportVehicleQty();//鏌ヨ鍑哄簱閲� + for(TmsFactoryParam p : paramList){ + 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().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) { + //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=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().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){ +// model.setTotalOutQty(Constants.formatBigdecimal(model.getTotalOutT03Qty()).add(Constants.formatBigdecimal(model.getTotalOutT01Qty()))); + r = r.add(Constants.formatBigdecimal(model.getTotalOutQty())); + } + } + return r ; + } + + /** + * 浠撳簱璧勬簮鍒╃敤鐜� + * @return + */ + @Override + public WholeProvinceZXTVO inventoryUseRate(){ + WholeProvinceZXTVO result = new WholeProvinceZXTVO(); + result.setCurrentNum(new BigDecimal(0)); + result.setTotalNum(new BigDecimal(0)); + result.setUseRate(new BigDecimal(0)); + result.setDetailList(new ArrayList<>()); + List<TmsFactoryParam> paramList = factoryList(); + List<TmsInventoryListResponse> responses = tmsService.getRealTimeInventory(); + if(paramList!=null){ + for(TmsFactoryParam p : paramList){ + WholeProvinceZxtDetailVO t = new WholeProvinceZxtDetailVO(); + t.setFactoryName(p.getName()); + t.setCurrentNum(new BigDecimal(0)); + t.setTotalNum(Constants.formatBigdecimal(p.getNum1()));//鎬诲簱瀛橀噺 + t.setCurrentNum(getFromInventoryList(p.getCode(),responses)); + 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(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())); + } + } + if(result.getTotalNum().compareTo(new BigDecimal(0)) !=0){ + result.setUseRate(result.getCurrentNum().divide(result.getTotalNum(),4,BigDecimal.ROUND_HALF_UP)); + } + return result; + } + + private BigDecimal getFromInventoryList(String code, List<TmsInventoryListResponse> responses) { + BigDecimal r = new BigDecimal(0); + if(responses!=null && responses.size()>0){ + for(TmsInventoryListResponse model: responses){ + if(StringUtils.equals(model.getFactoryCode(),code)){ + r = r.add(Constants.formatBigdecimal(model.getStockQty())); + } + } + } + return r ; + + } + + } -- Gitblit v1.9.3