From 1110e717afecf1cc78950a5f054bfa0c1b159ae1 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期五, 13 十二月 2024 17:20:31 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 54 insertions(+), 4 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 094a5fd..e261bbd 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 @@ -32,6 +32,7 @@ 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; @@ -358,6 +359,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) ); @@ -1004,6 +1006,14 @@ 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); } return alarmDataVO; } @@ -1076,6 +1086,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 @@ -1346,15 +1396,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); @@ -1502,7 +1552,7 @@ .selectAll( PlatformJob.class) .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() }) -- Gitblit v1.9.3