From 43c7cf553e5c78d81b8f23a043901926c45eb0cf Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期一, 30 十二月 2024 18:46:00 +0800 Subject: [PATCH] 最新版本541200007 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 154 +++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 129 insertions(+), 25 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 52993fb..23fe63a 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 @@ -1,7 +1,5 @@ package com.doumee.service.business.impl.thrid; -import com.alibaba.fastjson.JSONObject; -import com.alibaba.fastjson.TypeReference; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.constants.ResponseStatus; @@ -16,7 +14,6 @@ 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.TMSContants; import com.doumee.core.tms.model.request.TmsFacrotyCodeListRequest; import com.doumee.core.tms.model.request.TmsOrderNoFinishListRequest; import com.doumee.core.tms.model.request.TmsOutQtyAndVehicleQtyRequest; @@ -32,6 +29,7 @@ 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; @@ -1109,10 +1107,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() @@ -1197,10 +1196,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; } @@ -1270,7 +1269,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); @@ -1782,11 +1787,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(); @@ -2137,6 +2144,10 @@ 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.setCrrentRestNum(new BigDecimal(0)); + data.setCrrentOutNum(new BigDecimal(0)); List<TmsFactoryParam> paramList = factoryList(); String code = null; if(paramList!=null){ @@ -2144,8 +2155,8 @@ for(TmsFactoryParam param : paramList){ if(StringUtils.isNotBlank(factoryCode)){ if(StringUtils.equals(param.getCode(),factoryCode)){ - data.setHoursAbility(data.getHoursAbility().add(Constants.formatBigdecimal(param.getParam3()))); - data.setMaxAbility(data.getMaxAbility().add(Constants.formatBigdecimal(param.getNum2()))); + data.setHoursAbility(Constants.formatBigdecimal(param.getParam3())); + data.setMaxAbility(Constants.formatBigdecimal(param.getNum2())); code = param.getCode(); break; } @@ -2155,13 +2166,7 @@ } } } - if(isDebug){ - data.setCurrentPlanNum(new BigDecimal(1220)); - data.setCurrentOrderNum(new BigDecimal(32340)); - data.setCrrentOutNum(new BigDecimal(3450)); - data.setCrrentRestNum(new BigDecimal(456450)); - } - Date date = new Date(); + /* Date date = new Date(); TmsOutQtyAndVehicleQtyRequest param = new TmsOutQtyAndVehicleQtyRequest(); param.setDateEnd(DateUtil.getShortTime(date)); param.setDateStart(DateUtil.getShortTime(date)); @@ -2169,16 +2174,109 @@ param.setFacrotyCodeList(new ArrayList<>()); param.getFacrotyCodeList().add(code);//鏌ヨ鎸囧畾鍘傚尯 } - List<TmsOutQtyAndVehicleQtyResponse> listSame= tmsService.getOutQtyAndVehicleQty(param);//鍘诲勾鍚屾湡 + 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){ + List<String> planCodes = new ArrayList<>(); + List<String> todayCodes = new ArrayList<>(); + String todayDate = DateUtil.getShortTime(new Date()); + if(result.getCurrentDayOrderList()!=null && result.getCurrentDayOrderList().size()>0){ + for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayOrderList()){ + data.setCurrentOrderNum(data.getCurrentOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//浠婃棩璁㈠崟閲� + /** + * DISPATCH_TYPE in(1,2) 涓� TRANSPORT_CODE涓嶄负绌猴紝sum(NC_TOTALITY) + DISPATCH_TYPE not in(1,2) sum(NC_TOTALITY) + * 浠婃棩鍑哄簱涓嬭揪鐨勮鍒掍换鍔℃�婚噺 + */ + if(StringUtils.isNotBlank(model.getTransportCode()) + && (StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ + data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//浠婃棩璁㈠崟閲� + } + if(!(StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ + data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//浠婃棩璁″垝閲� + } + + /** + * 浠婃棩涓嬭揪鍑哄簱鐨勮鍒掍换鍔″搴旂殑杩愯緭杞︽鏁� + * TRANSPORT_CODE涓嶄负绌篶ount(transport_code ) + */ + if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ + planCodes.add(model.getTransportCode()); + } + /** + * 浠婃棩涓嬭揪鍑哄簱鐨勮鍒掍换鍔″搴旂殑杩愯緭杞︽鏁� + * TRANSPORT_CODE涓嶄负绌篶ount(transport_code ) + */ + if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ + planCodes.add(model.getTransportCode()); + } + /** + * out_date涓哄綋鏃�,sum(NC_TOTALITY) 浠婃棩瀹屾垚鐨勫嚭搴撲綔涓氫换鍔℃�婚噺 + * TRANSPORT_CODE涓嶄负绌� 涓攐ut_date涓哄綋鏃� count(transport_code) 浠婃棩瀹屾垚鐨勫嚭搴撲綔涓氫换鍔$殑杩愯緭杞︽鏁� + */ + if(StringUtils.isNotBlank(model.getOutDate()) && model.getOutDate().length()> 10){ + String tDate = model.getOutDate().substring(0,10); + if(tDate.equals(todayDate)){ + //濡傛灉鏄綋鏃� + data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getNcTotality())));//浠婃棩璁㈠崟閲� + } + if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),todayCodes)){ + todayCodes.add(model.getTransportCode()); + } + } + } + } + if(result.getCurrentDayAgoOrderList()!=null && result.getCurrentDayAgoOrderList().size()>0){ + for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayAgoOrderList()){ + /** + * out_date涓虹┖锛宻um(NC_TOTALITY) 鏄ㄥぉ鏈畬鎴愬嚭搴撹鍒掍换鍔� + * out_date涓虹┖ 涓擳RANSPORT_CODE涓嶄负绌� * count(transport_code ) 鏄ㄥぉ鏈畬鎴愬嚭搴撹鍒掍换鍔¤溅娆� + */ + if(StringUtils.isBlank(model.getOutDate())){ + data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//浠婃棩璁″垝閲� + if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ + planCodes.add(model.getTransportCode()); + } + } + } + } + data.setCurrentPlanCarNum(planCodes.size());//浠婃棩璁″垝杞︽ + data.setCrrentOutCarNum(todayCodes.size());//浠婃棩鍑哄簱杞︽ + } + data.setCrrentRestNum(data.getCurrentPlanNum().subtract(data.getCrrentOutNum())); + data.setCrrentRestCarNum(data.getCurrentPlanCarNum() -data.getCrrentOutCarNum()); + if(data.getCrrentRestNum().compareTo(new BigDecimal(0)) <=0){ + data.setCrrentRestNum(new BigDecimal(0)); + } + if(data.getCrrentRestCarNum()<=0){ + data.setCrrentRestCarNum(0); + } + } + + private boolean notInList(String transportCode, List<String> planCodes) { + for(String s :planCodes){ + if(StringUtils.equals(transportCode,s)){ + return false; + } + } + return true; + } + /** * 鍑哄簱鑳藉姏鏉庢案鍒� * @return @@ -2278,8 +2376,8 @@ tt =new WholeProvinceMapVO(); tt.setMonthNum( Constants.formatBigdecimal0Float(model.getMonthOutboundQuantity())); tt.setYearNum( Constants.formatBigdecimal0Float(model.getYearOutboundQuantity())); - tt.setProvinceCode(model.getFromProvinceCode()); - tt.setProvinceName(model.getFromProvinceName()); + tt.setProvinceCode(model.getToProvinceCode()); + tt.setProvinceName(model.getToProvinceName()); result.add(tt); } } @@ -2289,7 +2387,7 @@ 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; @@ -2317,12 +2415,12 @@ @Override public TmsBasePageResponse<TmsOrderNoFinishListResponse> orderNoFinishList(TmsOrderNoFinishListRequest param){ TmsBasePageResponse<TmsOrderNoFinishListResponse> infoList = tmsService.getNotFinishOrderList(param);//鏌ヨ鍑哄簱閲� - if(infoList!=null && infoList.getRows()!=null){ + /* if(infoList!=null && infoList.getRows()!=null){ for(TmsOrderNoFinishListResponse model :infoList.getRows()){ model.setStatusDesc(TMSContants.TopStatusLevel.getNameByKey(TMSContants.ChildStatusLevel.getParentIndexByStatus(model.getStatus()))); } - } + }*/ return infoList; } /** @@ -2339,6 +2437,12 @@ } 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);//鏌ヨ鍑哄簱閲� -- Gitblit v1.9.3