From f63d3a3be83fea258e7920efccd2567b6a511bb3 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 16 一月 2025 16:52:46 +0800 Subject: [PATCH] 最新版本541200007 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 682 +++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 572 insertions(+), 110 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 ac195f5..5a06a00 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,12 +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.tms.model.request.TmsFacrotyCodeListRequest; -import com.doumee.core.tms.model.request.TmsOutQtyAndVehicleQtyRequest; -import com.doumee.core.tms.model.response.TmsDistributionOfDeliveryLocResponse; -import com.doumee.core.tms.model.response.TmsInventoryListResponse; -import com.doumee.core.tms.model.response.TmsOutQtyAndVehicleQtyResponse; -import com.doumee.core.tms.model.response.TmsTotalAndReportVehicleQtyResponse; +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; @@ -30,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.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; @@ -88,6 +91,9 @@ private PlatformGroupMapper platformGroupMapper; @Autowired private TmsService tmsService; + + @Value("${debug_model}") + private Boolean isDebug; /** * 鑾峰彇鍖哄煙鏍戝舰缁撴瀯鏁版嵁 * @return @@ -132,7 +138,10 @@ .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{ @@ -146,7 +155,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())); + } } } } @@ -479,7 +490,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(); @@ -489,7 +500,6 @@ if(type == 1){ file.setFieldValue("131588");//瀹夐槻鍛婅 }else if(type == 2){ - file.setFieldValue("131593");//浜哄憳鍛婅 } request.getFiledOptions().add(file); @@ -497,28 +507,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; } @@ -529,7 +547,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; } @@ -580,25 +597,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.getFomartDate(new Date(),"yyyy-MM-dd") + " 00:00:00"); - 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; } @@ -704,6 +742,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") @@ -768,6 +807,36 @@ Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), Constants.PlatformJobStatus.CALLED.getKey()) .last("limit 1")); + + dealJobDetailAndContractBiz(job,data); + + return data; + + } + /** + * 銆愬洯鍖虹墿鏂欎腑蹇冭皟搴︺�戠湅鏉�-鏍规嵁杞︾墝鍙锋煡璇綔涓氫俊鎭拰鍚堝悓淇℃伅闆嗗悎 + * + * @return + * + */ + @Override + public CarsJobAndContractVO getJobDetailsById(CarsJobAndContractByJobIdDTO param) { + CarsJobAndContractVO data = new CarsJobAndContractVO(); + if(param.getId() == null){ + return data; + } + PlatformJob job = platformJobMapper.selectJoinOne(PlatformJob.class, + new MPJLambdaWrapper<PlatformJob>() + .selectAll(PlatformJob.class) + .eq(PlatformJob::getId,param.getId()) + .last("limit 1")); + dealJobDetailAndContractBiz(job,data); + + return data; + + } + + private void dealJobDetailAndContractBiz(PlatformJob job, CarsJobAndContractVO data) { if(job!=null){ List<PlatformLog> logList = platformLogMapper.selectJoinList(PlatformLog.class, new MPJLambdaWrapper<PlatformLog>() @@ -807,7 +876,7 @@ if(detailList!=null){ for(PlatformWmsDetail d : detailList){ if(isExistIocode(d.getIocode(),data.getContractList())){ - continue; + continue; } tt = new CarsContractVO(); tt.setIoCode(d.getIocode()); @@ -820,10 +889,6 @@ } } - - - return data; - } private List<PlatformWmsDetail> getDetailListByCode(String iocode, List<PlatformWmsDetail> detailList,CarsContractVO tt) { @@ -873,11 +938,8 @@ @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());//浠婂勾 @@ -940,7 +1002,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())")); @@ -1000,7 +1062,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+"'") @@ -1042,7 +1103,7 @@ .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; @@ -1098,10 +1159,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() @@ -1186,10 +1248,10 @@ 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; } @@ -1259,7 +1321,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); @@ -1280,8 +1348,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() @@ -1364,8 +1432,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){ // //璁$畻鐢ㄦ按鍚屾瘮鐜瘮 @@ -1402,7 +1481,7 @@ * @param data */ private void getLastMonthElectricityData(EnergyModelDataVO data) { - BaseResponse<LastMonthFeeByMeterTypeResponse> response = HKService.lastMonthFeeByMeterType("1"); +// 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")); @@ -1465,23 +1544,31 @@ * @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() { @@ -1550,7 +1637,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)); @@ -1564,26 +1651,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"))); } } @@ -1684,7 +1795,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() ); //鍦ㄥ洯鐩稿叧鏂硅溅杈� @@ -1756,11 +1867,13 @@ .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() }) // .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) - .orderByDesc(PlatformJob::getStatus )); + .orderByDesc(PlatformJob::getStatus ) + .orderByAsc(PlatformJob::getId ) + ); //鏈堝彴鐘舵�侊細0=浣滀笟涓紱1=绌洪棽涓紱2=浣滀笟瓒呮椂;3=鍙彿 for(Platform model : platformList){ PlatformWorkDataVO platformDurationVO = new PlatformWorkDataVO(); @@ -1861,6 +1974,9 @@ curtotalNum += Constants.formatIntegerNum(workEfficiencyVO.getWorkNum()) ; } workEfficiencyVO.setTotalWorkNum(curtotalNum);//绱鍊� + if(System.currentTimeMillis() < curTime){ + workEfficiencyVO.setTotalWorkNum(0); + } workEfficiencyVOList.add(workEfficiencyVO); } return workEfficiencyVOList; @@ -1966,6 +2082,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())){ @@ -1991,7 +2108,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())){ @@ -2036,13 +2153,22 @@ } BaseResponse<List<RegionDataRankingDataResponse>> response = HKService.regionDataRanking(request); if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ - return response.getData(); + 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 @@ -2058,13 +2184,17 @@ 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.getNum2()));//鎬诲嚭搴撹兘鍔� - if(StringUtils.isBlank(p.getCode())){ + t.setTotalNum(Constants.formatBigdecimal(p.getParam3()));//8灏忔椂鍑哄簱鑳藉姏 + if(StringUtils.isNotBlank(p.getCode())){ param.setFacrotyCodeList(new ArrayList<>()); param.setDateStart(startDate); param.setDateEnd(endDate); @@ -2073,6 +2203,11 @@ 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); @@ -2086,20 +2221,264 @@ 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()); + } + } + } + + } + + 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 queryType){ + 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(model.getOutSideProvinceOutQty()).add(model.getInSideProvinceOutT01Qty()));//鐪佸唴鐪佸閿�鍞噺 + data.setCurrentOtherNum(data.getCurrentOtherNum().add(model.getOutSideProvinceOutT03Qty()).add(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; } /** @@ -2107,43 +2486,39 @@ * @return */ @Override - public List<WholeProvinceMapVO> mapYearAndMonthOutList(){ + public List<WholeProvinceMapVO> mapYearAndMonthOutList(String code){ List<WholeProvinceMapVO> result = new ArrayList<>(); - List<TmsFactoryParam> paramList =factoryList(); - if(paramList!=null && paramList.size()>0){ - List<String> codes = new ArrayList<>(); - for(TmsFactoryParam p : paramList){ - if(StringUtils.isBlank(p.getCode())){ - continue; - } - codes.add(p.getCode()); - } - if(codes.size()>0){ - TmsFacrotyCodeListRequest param = new TmsFacrotyCodeListRequest(); - param.setFacrotyCodeList(codes); - List<TmsDistributionOfDeliveryLocResponse> response = tmsService.getDistributionOfDeliveryLocations(param);//鏌ヨ鍑哄簱閲� - if(response!=null &&response.size()>0){ - for(TmsDistributionOfDeliveryLocResponse model : response){ - WholeProvinceMapVO tt = getFromProvinceResultList(model ,result); - if(tt == null){ - tt =new WholeProvinceMapVO(); - tt.setMonthNum( Constants.formatBigdecimal0Float(model.getMonthOutboundQuantity())); - tt.setYearNum( Constants.formatBigdecimal0Float(model.getYearOutboundQuantity())); - tt.setProvinceCode(model.getFromProvinceCode()); - tt.setProvinceName(model.getFromProvinceName()); - result.add(tt); - } - } - } - } + 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.getFromProvinceCode())){ + 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; @@ -2165,6 +2540,76 @@ 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; + } + /** + * 杩戜竷鏃ュ埌璐ф儏鍐� + * @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,-7); + //鐪嬫澘澶у睆杩�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); + } + param.setNcCreateDateFrom(DateUtil.getShortTime(startDate)); + param.setNcCreateDateThrough(DateUtil.getShortTime(date)); + List<TmsSevenArrivalStatusAndDetailsResponse> infoList = tmsService.getSevenArrivalStatusAndDetails(param);//鏌ヨ鍑哄簱閲� + for (int i = 0; i < 7; 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 */ @@ -2173,6 +2618,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(); @@ -2182,41 +2628,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) { + //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=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 ; @@ -2246,6 +2703,11 @@ 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())); -- Gitblit v1.9.3