From ad86a0aa39f20e1b8bb511acd6961c7ec59f9251 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期五, 13 十二月 2024 17:15:51 +0800 Subject: [PATCH] 代码初始化 --- 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 9750228..2b4492c 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 @@ -31,6 +31,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; @@ -357,6 +358,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) ); @@ -1002,6 +1004,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; } @@ -1074,6 +1084,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 @@ -1343,15 +1393,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); @@ -1499,7 +1549,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