From 7c54e8233ccad83697a84317a4b8194d85d7fd42 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 14 十一月 2024 18:19:16 +0800 Subject: [PATCH] 最新版本541200007 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 213 ++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 177 insertions(+), 36 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 0be4d8b..2feae0f 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 @@ -2,31 +2,35 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.doumee.biz.system.SystemDictDataBiz; 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.param.BaseListPageResponse; import com.doumee.core.haikang.model.param.BaseResponse; import com.doumee.core.haikang.model.param.BaseListPageRequest; -import com.doumee.core.haikang.model.param.request.RuleEventFiledOptionsRequest; -import com.doumee.core.haikang.model.param.request.RuleEventSearchRequest; -import com.doumee.core.haikang.model.param.request.SecureDevStatusTotalRequest; -import com.doumee.core.haikang.model.param.request.SensorStatusListRequest; +import com.doumee.core.haikang.model.param.request.*; import com.doumee.core.haikang.model.param.respose.*; 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.dao.business.*; +import com.doumee.dao.business.join.VisitsJoinMapper; import com.doumee.dao.business.model.*; +import com.doumee.dao.system.model.SystemDictData; import com.doumee.dao.web.reqeust.SavePlatformWarnEventDTO; import com.doumee.dao.web.response.platformReport.*; import com.doumee.service.business.impl.PlatformJobServiceImpl; +import com.doumee.service.business.impl.VisitsServiceImpl; import com.doumee.service.business.third.BoardService; import com.github.yulichang.wrapper.MPJLambdaWrapper; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; +import org.checkerframework.checker.units.qual.C; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -45,6 +49,8 @@ @Autowired private PlatformLogMapper platformLogMapper; @Autowired + private SystemDictDataBiz systemDictDataBiz; + @Autowired private PlatformWarnEventMapper platformWarnEventMapper; @Autowired private PlatformJobMapper platformJobMapper; @@ -52,6 +58,10 @@ private PlatformWmsDetailMapper platformWmsDetailMapper; @Autowired private PlatformMapper platformMapper; + @Autowired + private VisitsJoinMapper visitsJoinMapper; + @Autowired + private RetentionMapper retentionMapper; @Autowired private PlatformGroupMapper platformGroupMapper; /** @@ -93,7 +103,9 @@ return data; } private void initReginCameralList(List<PageRegionInfoResponse> allList,String name) { - List<CarmeraListVO> carmeraListVOList = cameraList(null); + CarmeraListVO re = new CarmeraListVO(); + re.setName(name); + List<CarmeraListVO> carmeraListVOList = cameraList(re); if(carmeraListVOList!=null && carmeraListVOList.size()>0){ for(PageRegionInfoResponse p : allList){ for(CarmeraListVO c : carmeraListVOList){ @@ -176,13 +188,15 @@ List<CarmeraListVO> data = new ArrayList<>(); for(PageCameraInfoResponse p : allList){ - CarmeraListVO t = new CarmeraListVO(); - t.setIndexCode(p.getCameraIndexCode()); - t.setReginCode(p.getRegionIndexCode()); - t.setName(p.getCameraName()); - t.setStatus(p.getStatus()); - t.setStatusName(p.getStatusName()); - data.add(t); + if(StringUtils.isBlank(req.getName()) ||StringUtils.contains(p.getCameraName(),req.getName())){ + CarmeraListVO t = new CarmeraListVO(); + t.setIndexCode(p.getCameraIndexCode()); + t.setReginCode(p.getRegionIndexCode()); + t.setName(p.getCameraName()); + t.setStatus(p.getStatus()); + t.setStatusName(p.getStatusName()); + data.add(t); + } } return data; } @@ -299,7 +313,10 @@ @Override public List<SecurityDeviceDataVO> securityDeviceData(){ List<SecurityDeviceDataVO> list = new ArrayList<>(); - BaseResponse<List<SecureDevStatusListResponse>> result = HKService.getSecureDevStatusList(new SecureDevStatusTotalRequest()) ; + SecureDevStatusTotalRequest request =new SecureDevStatusTotalRequest(); + request.setIncludeBool(""); + request.setRegionIds(new String[]{}); + BaseResponse<List<SecureDevStatusListResponse>> result = HKService.getSecureDevStatusList(request) ; if(result!=null && StringUtils.equals(result.getCode(),HKConstants.RESPONSE_SUCCEE) && result.getData()!=null){ List<SecureDevStatusListResponse> rlist = result.getData(); for(SecureDevStatusListResponse r :rlist){ @@ -324,32 +341,172 @@ return list; } @Override - public List<WaningEventDataVO> warningEventData(Integer type){ - List<WaningEventDataVO> list = new ArrayList<>(); + public WaningEventDataVO warningEventData(Integer type){ + WaningEventDataVO lastResult = new WaningEventDataVO(); + List<WaningEventDataListVO> list = new ArrayList<>(); RuleEventSearchRequest request = new RuleEventSearchRequest(); + request.setPageNo(1); + request.setPageSize(10); request.setFiledOptions(new ArrayList<>()); + request.setSorts(new ArrayList<>()); RuleEventFiledOptionsRequest file = new RuleEventFiledOptionsRequest(); file.setFieldName("event_type"); file.setFieldValue("131588");//瀹夐槻鍛婅 - file.setType("eq"); + file.setType("in"); request.getFiledOptions().add(file); - BaseResponse< RuleEventSearchResponse> result = HKService.ruleEventSearch(request); + SortRequest sort = new SortRequest(); + sort.setSortField("happen_time"); + sort.setSortType("desc"); + request.getSorts().add(sort); + 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){ - WaningEventDataVO data = new WaningEventDataVO(); + WaningEventDataListVO data = new WaningEventDataListVO(); 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(r.getCreate_time()); + data.setCreateDate(DateUtil.getPlusTime(DateUtil.getISO8601DateByStr(r.getHappen_time()))); // data.setContent(r.get); list.add(data); } } } - return list; + lastResult.setList(list); + return lastResult; + } + @Override + public String getCarmeraPreviemUrl(CarmeraListVO param){ + CameraPreviewURLsRequest request = new CameraPreviewURLsRequest(); + request.setCameraIndexCode(param.getIndexCode()); + 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; + } + @Override + public VisitDataVO visitSecurityData(){ + //寰呰闂�佸凡鐧昏銆佸凡绂诲紑 + + VisitDataVO result = new VisitDataVO(); + result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() + .eq(Visits::getIsdeleted,Constants.ZERO) + .in(Visits::getStatus,Constants.VisitStatus.pass,Constants.VisitStatus.xfSuccess )));//寰呰闂� + result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() + .eq(Visits::getIsdeleted,Constants.ZERO) + .in(Visits::getStatus,Constants.VisitStatus.signout,Constants.VisitStatus.signin )));//宸茬櫥璁� + result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() + .eq(Visits::getIsdeleted,Constants.ZERO) + .in(Visits::getStatus,Constants.VisitStatus.signout )));//宸茬绂� + PageWrap<Visits> pageWrap = new PageWrap<>(); + pageWrap.setCapacity(10); + pageWrap.setPage(1); + pageWrap.setModel(new Visits()); + pageWrap.getModel().setLevelStatus(Constants.ZERO); + pageWrap.getModel().setStatus(Constants.TWO); + PageData<Visits> visitsPageData = VisitsServiceImpl.retentionPageBiz(pageWrap,visitsJoinMapper,systemDictDataBiz); + List<VisitRetentionDataVO> list = new ArrayList<>(); + if(visitsPageData !=null && visitsPageData.getRecords() !=null && visitsPageData.getRecords().size()>0){ + for (Visits model : visitsPageData.getRecords()) { + VisitRetentionDataVO data = new VisitRetentionDataVO(); + data.setName(model.getName()); + data.setCompanyName(model.getCompanyName()); + data.setTimeOutMinute(Constants.formatIntegerNum(model.getTimeOut())); + list.add(data); + } + result.setRetentionNum(visitsPageData.getTotal()); + } + result.setVisitRetentionDataList(list);//璁垮婊炵暀鏁版嵁闆嗗悎 + return result; + + } + @Override + public SecurityBoardVO centerSecurityData(){ + + + SecurityBoardVO data = new SecurityBoardVO(); + getParkingCarsNum(data);//鑾峰彇杞︿綅鏁版嵁 + Random random = new Random(); + + List<Retention> retentionList = retentionMapper.selectJoinList(Retention.class, + new MPJLambdaWrapper<Retention>() + .selectAll(Retention.class) + .selectAs(Company::getType,Retention::getCompanyType) + .leftJoin(Company.class,Company::getId,Retention::getCompanyId) + ); + + //浠婃棩鍦ㄥ洯浜烘暟 + data.setInParkTotal( + (int) retentionList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.THREE)).count() + ); + //鍦ㄥ洯闀挎湡鐩稿叧鏂逛汉鏁� + data.setInternalTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO) && Constants.equalsInteger(i.getCompanyType(),Constants.ZERO)).count() + ); + //鍦ㄥ洯璁垮鏁伴噺 + data.setVisitTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)&&Objects.isNull(i.getCompanyType())).count() + ); + //鍦ㄥ洯杞﹁締 + data.setInternalCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE)).count() + ); + //鍦ㄥ洯鐩稿叧鏂硅溅杈� + data.setRelatedCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.relation)).count() + ); + //鍐呴儴杞﹁締 + data.setInternalCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.internal)).count() + ); + //鏉ヨ杞﹁締 + data.setVisitCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.visitor)).count() + ); + //鑷敱鐗╂祦杞︽暟閲� + data.setVisitCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.selfTruck)).count() + ); + //甯傚叕鍙稿嵏璐ц溅鏁伴噺 + data.setInternalJobCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.cityComTruck)).count() + ); + //澶栧崗杞︽暟閲� + data.setRelatedJobCarTotal( + (int) retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE) + &&Constants.equalsInteger(i.getCarType(),Constants.RetentionCarType.outTruck)).count() + ); + return data; + } + + private void getParkingCarsNum(SecurityBoardVO data) { + try { + BaseResponse<ParkingStatisticResponse> response = HKService.getParkingStatistics(); + if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) || response.getData()==null + ||response.getData().getTodayParkingDataDto() == null){ + return; + } + data.setParkingLotTotal(Constants.formatIntegerNum(response.getData().getTodayParkingDataDto().getTotalPlace()));//鎬昏溅浣� + data.setFreeParkingLot(Constants.formatIntegerNum(response.getData().getTodayParkingDataDto().getLeftPlace()));//鍓╀綑杞︿綅 + data.setParkingUseRate(Constants.formatBigdecimal(response.getData().getTodayParkingDataDto().getUseRate()));//杞︿綅浣跨敤鐜� + }catch (Exception e){ + + } } @Override @@ -361,22 +518,6 @@ .eq(Platform::getIsdeleted, Constants.ZERO) .orderByAsc(Platform::getSortnum) ); - /** - * WAIT_CONFIRM(0, "寰呯‘璁�","寰呯‘璁�" ), - * WART_SIGN_IN(1, "寰呯鍒�","寰呯鍒�" ), - * WAIT_CALL(2, "宸茬鍒�","宸茬鍒�"), - * IN_WAIT(3, "鍏ュ洯绛夊緟","鍏ュ洯绛夊緟" ), - * CALLED(4, "宸插彨鍙�","宸插彨鍙�" ), - * WORKING(5, "浣滀笟涓�","浣滀笟涓�" ), - * DONE(6, "浣滀笟瀹屾垚 ","浣滀笟瀹屾垚" ), - * TRANSFERING(7, "杞Щ涓�","杞Щ涓�" ), - * EXCEPTION(8, "寮傚父鎸傝捣","寮傚父鎸傝捣" ), - * AUTHED_LEAVE(9, "宸叉巿鏉冪鍥�","宸叉巿鏉冪鍥�" ), - * LEAVED(10, "宸茬鍥� ","宸茬鍥� " ), - * OVER_NUMBER(11, "宸茶繃鍙�","宸茶繃鍙�" ), - * CANCEL(12, "宸插彇娑�","宸插彇娑�" ), - */ - if(platformList!=null && platformList.size()>0){ List<PlatformJob> jobList = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAll( PlatformJob.class) -- Gitblit v1.9.3