From 68a19b71ddb5775670e4cb125c29b4ee70d62da9 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期四, 19 十二月 2024 17:26:29 +0800 Subject: [PATCH] 代码初始化 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 417 +++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 349 insertions(+), 68 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 9750228..95aaf3c 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 @@ -5,6 +5,7 @@ import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.haikang.model.HKConstants; +import com.doumee.core.haikang.model.cars.response.CarsAlarmResultListResponse; import com.doumee.core.haikang.model.cars.response.CarsDeviceDetaisResponse; import com.doumee.core.haikang.model.param.BaseListPageRequest; import com.doumee.core.haikang.model.param.BaseListPageResponse; @@ -13,13 +14,14 @@ 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.ApiResponse; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; import com.doumee.core.wms.model.response.WmsBaseResponse; -import com.doumee.core.wms.model.response.WmsInventoryDataResponse; +import com.doumee.core.wms.model.response.WmsBaseDataResponse; import com.doumee.core.wms.model.response.WmsInventoryJsonResponse; import com.doumee.dao.business.*; import com.doumee.dao.business.join.PlatformWarnEventJoinMapper; @@ -31,13 +33,16 @@ import com.doumee.service.business.impl.VisitsServiceImpl; import com.doumee.service.business.third.BoardService; import com.doumee.service.business.third.WmsService; +import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import com.github.yulichang.wrapper.MPJLambdaWrapper; 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.stereotype.Service; +import org.springframework.web.bind.annotation.RequestBody; +import javax.servlet.http.HttpServletResponse; import java.math.BigDecimal; import java.util.*; import java.util.stream.Collectors; @@ -65,6 +70,8 @@ @Autowired private PlatformJobMapper platformJobMapper; @Autowired + private PlatformBooksMapper platformBooksMapper; + @Autowired private PlatformWmsDetailMapper platformWmsDetailMapper; @Autowired private PlatformWmsJobMapper platformWmsJobMapper; @@ -81,7 +88,75 @@ * @return */ @Override - public BoardStockListVO stockList( ){ + public List<GeneralVO> todayTotalInList(){ + /** + * 1甯傚叕鍙革細鏍规嵁棰勭害鐨勫叆鍥師鍥犱负甯傚叕鍙稿嵏璐х殑浠诲姟涓哄競鍏徃鍏ュ簱鐨勭粺璁★紱 + * 2闆嗘暎涓績锛歐MS鎺ㄩ�佺殑鍏ュ簱鍗曟嵁锛� + * 3鍔犲伐鍏ュ簱锛氶绾﹀叆鍥负閲嶅簡鍔犲伐鍏ュ簱鐨勶紙浣滀笟鏈堝彴涓哄畨娉扮墿娴佸嵏璐ф湀鍙帮級锛� + */ + String[] names = new String[]{"甯傚叕鍙�","闆嗘暎涓績","鍔犲伐鍏ュ簱"}; + String reason =systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.CITY_XH_REASON_ID).getCode(); + String platformGroupId =systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.ATWL_XH_PLATFORM_ID).getCode();; + List<GeneralVO> list = new ArrayList<>(); + for (int i = 0; i < 3; i++) { + Random random = new Random(); + GeneralVO data = new GeneralVO(); + data.setName(names[i]); + BigDecimal num =new BigDecimal(0); + if(i == 0){ + List<PlatformBooks> jobs = platformBooksMapper.selectJoinList(PlatformBooks.class, new MPJLambdaWrapper<PlatformBooks>() + .select(PlatformJob::getTotalNum) + .leftJoin(PlatformJob.class,PlatformJob::getId,PlatformBooks::getJobId) + .eq(PlatformBooks::getIsdeleted,Constants.ZERO) + .eq(PlatformBooks::getReasonId,reason) + .apply("to_days(t1.done_date) = to_days(now())") + .eq(PlatformBooks::getStatus,Constants.TWO)); + if(jobs!=null){ + for(PlatformBooks j :jobs){ + num =num.add(Constants.formatBigdecimal(j.getTotalNum())); + } + } + }else if(i ==1){ + List<PlatformJob> jobs = platformJobMapper.selectList (new MPJLambdaWrapper<PlatformJob>() + .select(PlatformJob::getTotalNum) + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .eq(PlatformJob::getOrigin,Constants.ONE) + .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())); + } + } + }else{ + List<PlatformJob> jobs = platformJobMapper.selectList (new MPJLambdaWrapper<PlatformJob>() + .select(PlatformJob::getTotalNum) + .eq(PlatformJob::getIsdeleted,Constants.ZERO) + .eq(PlatformJob::getPlatformGroupId,platformGroupId) + .apply("to_days(done_date) = to_days(now())") + .in(PlatformJob::getStatus, Constants.PlatformJobStatus.DONE.getKey() + , Constants.PlatformJobStatus.AUTHED_LEAVE.getKey() + , Constants.PlatformJobStatus.LEAVED.getKey()) ); + if(jobs!=null){ + for(PlatformJob j :jobs){ + num = num.add(Constants.formatBigdecimal(j.getTotalNum())); + } + } + } + data.setNum(num); + list.add(data); + } + return list; + + } + /** + * 鑾峰彇鍖哄煙鏍戝舰缁撴瀯鏁版嵁 + * @return + */ + @Override + public BoardStockListVO stockList(){ BoardStockListVO data = new BoardStockListVO(); double toatalNum = 1d; BigDecimal num = new BigDecimal(0); @@ -89,17 +164,16 @@ try { toatalNum =Double.parseDouble(systemDictDataBiz.queryByCode(Constants.WMS_PARAM,Constants.WMS_TOTAL_STOCK_NUM).getCode()) ; }catch (Exception e){ - } - WmsBaseResponse<WmsInventoryDataResponse> response = wmsService.getInventoryList(); - if(response!=null && response.getData()!=null && response.getData().size()>=0){ + WmsBaseResponse<WmsBaseDataResponse> response = wmsService.getInventoryList(); + if(response!=null && response.getData()!=null && response.getData().size()>0){ List<WmsInventoryJsonResponse> t= response.getData().get(0).getJson(); if(t!=null &&t.size()>0){ for(WmsInventoryJsonResponse j :t){ num = num.add (Constants.formatBigdecimal( j.getQty())); GeneralVO d = new GeneralVO(); d.setNum(Constants.formatBigdecimal(j.getQty())); - d.setName(j.getItem_name()); + d.setName(j.getItemName()); list.add(d); } } @@ -110,7 +184,7 @@ toatalNum =1; } data.setTotalNum(new BigDecimal(toatalNum)); - data.setUseRate(data.getTotalNum().divide(data.getNum(),2,BigDecimal.ROUND_UP)); + data.setUseRate(Constants.formatBigdecimal(data.getNum()).divide(data.getTotalNum(),2,BigDecimal.ROUND_HALF_UP)); return data; } @@ -357,6 +431,7 @@ public CarWorkSituationVO carWorkSituation(int limit){ CarWorkSituationVO carWorkSituationVO = new CarWorkSituationVO(); List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() + .like(PlatformLog::getCreateDate,DateUtil.getCurrDate()) .orderByDesc(PlatformLog::getCreateDate) .last(" limit "+limit) ); @@ -506,7 +581,7 @@ param.setPage(1); param.setUserId("admin"); // param.setRegionIndexCodes("root000000"); - param.setAlarmStartTime(DateUtil.getPlusTime2(DateUtil.addDaysToDate(new Date(),-1))); + 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); @@ -533,9 +608,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(); @@ -543,17 +623,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); } } } @@ -597,6 +697,7 @@ List<PlatformJob> dataList = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) + .selectAs(PlatformJob::getCreateDate,PlatformJob::getCreateDate) .selectAs(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) @@ -607,7 +708,7 @@ TransportMeasureVO data = new TransportMeasureVO(); data.setPlanDate(date); data.setPlanTimes(0); - data.setPlanTaskNum(new BigDecimal(random.nextInt(0))); + data.setPlanTaskNum(new BigDecimal( 0)); data.setFinishTaskNum(new BigDecimal(0)); for(PlatformJob job :dataList){ if(queryType == 2){ @@ -656,7 +757,11 @@ .selectAll(PlatformJob.class) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .eq(PlatformJob::getCarCodeFront,param.getCarCode()) - .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(),Constants.PlatformJobStatus.CALLED.getKey()) + .in(PlatformJob::getStatus, + Constants.PlatformJobStatus.DONE.getKey(), + Constants.PlatformJobStatus.LEAVED.getKey(), + Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), + Constants.PlatformJobStatus.CALLED.getKey()) .last("limit 1")); if(job!=null){ List<PlatformLog> logList = platformLogMapper.selectJoinList(PlatformLog.class, @@ -696,7 +801,7 @@ .orderByDesc(PlatformLog::getCreateDate)); if(detailList!=null){ for(PlatformWmsDetail d : detailList){ - if(!isNotExistIocode(d.getIocode(),data.getContractList())){ + if(isExistIocode(d.getIocode(),data.getContractList())){ continue; } tt = new CarsContractVO(); @@ -731,7 +836,7 @@ return list; } - private boolean isNotExistIocode(String iocode, List<CarsContractVO> detailList) { + private boolean isExistIocode(String iocode, List<CarsContractVO> detailList) { if(detailList!=null){ for(CarsContractVO d :detailList){ if(StringUtils.equals(d.getIoCode(),iocode)){ @@ -774,44 +879,50 @@ Date lastYear = DateUtil.addYearToDate(year,-1);//鍘诲勾 List<PlatformJob> monthNum = platformJobMapper.selectJoinList(PlatformJob.class, - new MPJLambdaWrapper<PlatformJob>() - .selectAs(PlatformJob::getId,PlatformJob::getId) - .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) + new MPJLambdaWrapper<PlatformJob>() + .selectAs(PlatformJob::getId,PlatformJob::getId) + .select(PlatformJob::getType,PlatformJob::getType) + .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) + .select(PlatformJob::getStatus,PlatformJob::getStatus) .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(create_date) = year("+DateUtil.getPlusTime2(month)+") and month(create_date) = month("+DateUtil.getPlusTime2(month)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(month))); + .apply("year(done_date) = year('"+DateUtil.getPlusTime2(month)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(month)+"') ")); List<PlatformJob> monthLastNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) + .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) + .select(PlatformJob::getType,PlatformJob::getType) + .select(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) .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(create_date) = year("+DateUtil.getPlusTime2(lastMonth)+") and month(create_date) = month("+DateUtil.getPlusTime2(lastMonth)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastMonth))); + .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) - .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) - .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum) -// .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) + .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(create_date) = year("+DateUtil.getPlusTime2(year)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(year))); + .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) + .selectAs(PlatformJob::getType,PlatformJob::getId) + .select(PlatformJob::getStatus,PlatformJob::getStatus) .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) .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(create_date) = year("+DateUtil.getPlusTime2(lastYear)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastYear))); + .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"') and done_date<= '"+DateUtil.getPlusTime2(lastYear)+"'")); data.setMonthOutTotal(getSumTotalByList(monthNum,0,null));//鏈湀鍑哄簱閲� - data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//涓婃湁鍑哄簱閲� + data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//涓婃湀鍑哄簱閲� data.setYearOutTotal(getSumTotalByList(yearNum,null,null) );//鏈勾鍑哄簱閲� data.setYearLastOutTotal(getSumTotalByList(yearLastNum,null,null) );//鍘诲勾鍑哄簱閲� data.setMonthOutTimes(monthNum!=null?monthNum.size():0); @@ -827,19 +938,30 @@ // .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(" and to_days(create_date) <to_days(now())")); + .apply(" to_days(create_date) <to_days(now())")); - //==========浠婂ぉ鍑哄叆搴撲换鍔� - List<PlatformJob> currentNum = platformJobMapper.selectJoinList(PlatformJob.class, + //==========浠婂ぉ鍑哄叆搴撳畬鎴愰噺 + List<PlatformJob> currentDoneNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) - .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) .selectAs(PlatformJob::getType,PlatformJob::getType) + .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) .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("year(create_date) = year("+DateUtil.getPlusTime2(lastYear)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastYear))); + .apply(" to_days(done_date) = to_days(now())")); + //==========浠婂ぉ涓嬪彂鍑哄叆搴撲换鍔�---- + List<PlatformJob> currentNum = platformJobMapper.selectJoinList(PlatformJob.class, + new MPJLambdaWrapper<PlatformJob>() + .selectAs(PlatformJob::getId,PlatformJob::getId) + .selectAs(PlatformJob::getType,PlatformJob::getType) + .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) + .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())")); BigDecimal beforeOutNum = (getSumTotalByList(beforeJobNum,0,null));//浠婂ぉ涔嬪墠鏈畬鎴愬嚭搴撲换鍔� BigDecimal currentOutNum = (getSumTotalByList(currentNum,0,null));//浠婂ぉ涓嬪彂鍑哄簱浠诲姟 @@ -847,12 +969,12 @@ BigDecimal currentInNum = (getSumTotalByList(currentNum,1,null));//浠婂ぉ涓嬪彂鍏ュ簱浠诲姟 data.setCurrentInNum(beforeInNum.add(currentInNum));//褰撳墠鍏ュ簱鎬讳换鍔℃垚閲� data.setCurrentOutNum(beforeOutNum.add(currentOutNum));//褰撳墠鍑哄簱鎬讳换鍔℃垚閲� - data.setCurrentInDoneNum(getSumTotalByList(currentNum,0,1));//浠婃棩瀹屾垚閲� - data.setCurrentOutDoneNum(getSumTotalByList(currentNum,1,1));//浠婃棩瀹屾垚閲� + data.setCurrentInDoneNum(getSumTotalByList(currentDoneNum,1,1));//浠婃棩瀹屾垚閲� + data.setCurrentOutDoneNum(getSumTotalByList(currentDoneNum,0,1));//浠婃棩瀹屾垚閲� //------------浠婃棩鍑哄叆搴撴晥鐜�---------------- - BigDecimal outHours = getTotalDoneTimes(currentNum,0);// - BigDecimal inHours = getTotalDoneTimes(currentNum,1);// + BigDecimal outHours = getTotalDoneTimes(currentDoneNum,0);// + BigDecimal inHours = getTotalDoneTimes(currentDoneNum,1);// if(outHours.compareTo(new BigDecimal(0))>0){ data.setTodayOutRate(data.getCurrentOutDoneNum().divide(outHours,2));//褰撳墠鍏ュ簱鎬讳换鍔℃垚閲� } @@ -860,15 +982,15 @@ data.setTodayInRate(data.getCurrentInDoneNum().divide(inHours,2));//褰撳墠鍏ュ簱鎬讳换鍔℃垚閲� } //------------鏈湀鍑哄叆搴撴晥鐜�---------------- - BigDecimal outMonthNum = getSumTotalByList(monthNum,0,null).add(data.getCurrentOutDoneNum()); +// BigDecimal outMonthNum = getSumTotalByList(monthNum,0,null).add(data.getCurrentOutDoneNum()); BigDecimal inMonthNum = getSumTotalByList(monthNum,1,null).add(data.getCurrentInDoneNum()); - BigDecimal outYearHours = getTotalDoneTimes(yearNum,0).add(outHours);// - BigDecimal inYearHours = getTotalDoneTimes(yearNum,1).add(inHours);// - if(outYearHours.compareTo(new BigDecimal(0))>0){ - data.setMonthOutRate(outMonthNum.divide(outYearHours,2));//鏈湀鍏ュ簱鏁堢巼 + BigDecimal outMonthHours = getTotalDoneTimes(monthNum,0).add(outHours);// + BigDecimal inMonthHours = getTotalDoneTimes(monthNum,1).add(inHours);// + if(outMonthHours.compareTo(new BigDecimal(0))>0){ + data.setMonthOutRate(data.getMonthOutTotal().divide(outMonthHours,0,BigDecimal.ROUND_HALF_UP));//鏈湀鍏ュ簱鏁堢巼 } - if(inYearHours.compareTo(new BigDecimal(0))>0){ - data.setMonthInRate(inMonthNum.divide(inYearHours,2));//鏈湀鍏ュ簱鏁堢巼 + if(inMonthHours.compareTo(new BigDecimal(0))>0){ + data.setMonthInRate(inMonthNum.divide(inMonthHours,0,BigDecimal.ROUND_HALF_UP));//鏈湀鍏ュ簱鏁堢巼 } return data; } @@ -942,31 +1064,43 @@ // if(Constants.formatBigdecimal(job.getIoQty()).compareTo(new BigDecimal(0)) >0){ // r.add( job.getIoQty()); // }else{ - r.add(Constants.formatBigdecimal(job.getTotalNum())); + r = r.add(Constants.formatBigdecimal(job.getTotalNum())); // } } return Constants.formatBigdecimal0Float(r); } @Override + public List<CarsAlarmResultListResponse> carsEventList(){ + + if(HKCarOpenService.HK_CARS_LIST == null){ + HKCarOpenService.HK_CARS_LIST = HKCarOpenService.getAllCarsDetais(); + } + return HKCarOpenService.getAlarmEvemtList( HKCarOpenService.HK_CARS_LIST,new Date()); + } + @Override public BoardCarsListVO platformJobCarsList(){ BoardCarsListVO data = new BoardCarsListVO(); List<CarsDeviceDetaisResponse> detaisResponses = HKCarOpenService.getAllCarsDetais(); - data.setCarsList(detaisResponses); + data.setCarsList(detaisResponses); if(data.getCarsList()!=null && data.getCarsList().size()>0){ List<String> codes = new ArrayList<>(); //璁惧鐘舵�� 0锛氱绾匡紱1锛氬湪绾匡紱2锛氫紤鐪� int online = 0; for(CarsDeviceDetaisResponse model:detaisResponses){ - if(Constants.equalsInteger(model.getStatus(),Constants.ONE) ||Constants.equalsInteger(model.getStatus(),Constants.TWO)){ - //濡傛灉鏄湪绾挎垨鑰呬紤鐪狅紝鏌ヨ鍦ㄩ�旇繕鏄┖闂� + if(Constants.equalsInteger(model.getStatus(),Constants.ONE) + ||Constants.equalsInteger(model.getStatus(),Constants.TWO)){ + //濡傛灉鏄湪绾挎垨鑰呬紤鐪狅紝鏌ヨ鍦ㄩ�旇繕鏄┖闂瞭y codes.add(model.getPlateNum()); + model.setJobStatus(Constants.ZERO); }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锛� - long busyNum = platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda() + List<PlatformJob> busyNum = platformJobMapper.selectList(new QueryWrapper<PlatformJob>() .lambda() + .select(PlatformJob::getCarCodeFront) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .in(PlatformJob::getCarCodeFront,codes) .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey() @@ -978,8 +1112,21 @@ ,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey() ,Constants.PlatformJobStatus.EXCEPTION.getKey()) .groupBy(PlatformJob::getCarCodeFront)); - data.setBusyNum((int)busyNum);//鍦ㄩ�旀湁浠诲姟鏁伴噺 + data.setBusyNum( busyNum!=null ?busyNum.size():0);//鍦ㄩ�旀湁浠诲姟鏁伴噺 data.setIdleNum(codes.size() -data.getBusyNum());//鏃犱换鍔$┖闂叉暟閲� + HKCarOpenService.HK_CARS_LIST = detaisResponses; +// data.setEventList(HKCarOpenService.getAlarmEvemtList(detaisResponses,new Date())); + if(busyNum != null){ + FLAG: for(CarsDeviceDetaisResponse model:detaisResponses){ + for(PlatformJob job : busyNum){ + if(StringUtils.equals(job.getCarCodeFront(),model.getPlateNum())){ + model.setJobStatus(Constants.ONE); + continue FLAG; + } + } + } + + } } } @@ -1000,6 +1147,14 @@ alarmDataVO.setErrNum(Constants.formatIntegerNum(response.getData().getMisReportAlarmNum())); alarmDataVO.setLiftNum(Constants.formatIntegerNum(response.getData().getHandledAlarmNum())); alarmDataVO.setProcessingNum(Constants.formatIntegerNum(response.getData().getUnHandedAlarmNum())); + alarmDataVO.setStartDate(start); + alarmDataVO.setEndDate(end); + }else{ + alarmDataVO.setTotalNum(Constants.ZERO); + alarmDataVO.setRealNum(Constants.ZERO); + alarmDataVO.setErrNum(Constants.ZERO); + alarmDataVO.setLiftNum(Constants.ZERO); + alarmDataVO.setProcessingNum(Constants.ZERO); alarmDataVO.setStartDate(start); alarmDataVO.setEndDate(end); } @@ -1074,6 +1229,46 @@ data.setDangerDealedNum(totalNum !=null?totalNum.intValue():0);//浠婃棩澶勭悊闅愭偅鏁伴噺 return data; } + + + /** + * 娑堥槻 娓╂箍搴︽暟鎹� + */ + @Override + public List<TemperatureHumidityDataVO> getTemperatureHumidityData(){ + TemperatureHumidityDataRequest request = new TemperatureHumidityDataRequest(); + List<TemperatureHumidityDataVO> temperatureHumidityDataVOList = new ArrayList<>(); + request.setPageNo(1); + request.setPageSize(100); + request.setParentIndexCode(systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.TEMPERATURE_HUMIDITY).getCode()); + BaseResponse<BaseListPageResponse<TemperatureHumidityDataResponse>> response = HKService.temperatureHumidityDataStatistic(request); + if(response != null && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) && response.getData()!=null ){ + List<TemperatureHumidityDataResponse> temperatureHumidityDataResponseList = response.getData().getList(); + + if(CollectionUtils.isNotEmpty(temperatureHumidityDataResponseList)){ + Set<String> parentIndexCode = new HashSet<String>(temperatureHumidityDataResponseList.stream().map( + i->i.getIndexCode().replace("@0","").replace("@1","") + ).collect(Collectors.toList())); + for (String code:parentIndexCode) { + List<TemperatureHumidityDataResponse> dateList = + 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")){ + temperatureHumidityDataVO.setTemperatureData(data); + }else{ + temperatureHumidityDataVO.setHumidityData(data); + } + } + temperatureHumidityDataVOList.add(temperatureHumidityDataVO); + } + } + } + return temperatureHumidityDataVOList; + } + + + /** * 鐢ㄧ數鎬昏兘鑰楀悓姣斻�佺幆姣斿拰鍖哄煙鐢ㄧ數閲忛泦鍚� * @return @@ -1098,17 +1293,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);//涓婃湀 @@ -1198,12 +1398,62 @@ */ 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")); +// 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()); + } } } + + + + /** * 閫氳繃瀹夐槻骞宠幏鍙栦粖鏃ョ敤鐢甸噺 @@ -1219,7 +1469,8 @@ 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 ){ + 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"))); } @@ -1252,7 +1503,6 @@ } if(data == null){ data = new RegionEnergyListResponse(); - data.setSecondRegionDataList(new ArrayList<>()); data.setRootValue("0"); data.setSamePercent("0"); data.setRingPercent("0"); @@ -1343,15 +1593,15 @@ VisitDataVO result = new VisitDataVO(); result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() .eq(Visits::getIsdeleted,Constants.ZERO) - .apply("to_days(create_date)=to_days(now()") + .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.pass,Constants.VisitStatus.xfSuccess )));//寰呰闂� result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() .eq(Visits::getIsdeleted,Constants.ZERO) - .apply("to_days(create_date)=to_days(now()") + .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.signout,Constants.VisitStatus.signin )));//宸茬櫥璁� result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() .eq(Visits::getIsdeleted,Constants.ZERO) - .apply("to_days(create_date)=to_days(now()") + .apply("to_days(create_date)=to_days(now())") .in(Visits::getStatus,Constants.VisitStatus.signout )));//宸茬绂� /*PageWrap<Visits> pageWrap = new PageWrap<>(); pageWrap.setCapacity(10); @@ -1497,18 +1747,21 @@ 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 a.total_num end )",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())") .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 )); //鏈堝彴鐘舵�侊細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()); PlatformJob job = getJobFromListById(model.getId(),jobList); if(job != null){ @@ -1758,4 +2011,32 @@ 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 ){ + return response.getData(); + }else{ + return null; + } + } + + + } -- Gitblit v1.9.3