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