From e55c8b0a92eb9715edd90c31dfd4de51a47b588b Mon Sep 17 00:00:00 2001
From: liuhaonan <31457034@qq.com>
Date: 星期五, 04 十一月 2022 17:40:08 +0800
Subject: [PATCH] changes

---
 ximon-admin/src/main/java/com/sandu/ximon/admin/service/MonitorService.java |  406 ++++++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 338 insertions(+), 68 deletions(-)

diff --git a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/MonitorService.java b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/MonitorService.java
index ebca42b..4188b54 100644
--- a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/MonitorService.java
+++ b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/MonitorService.java
@@ -1,32 +1,43 @@
 package com.sandu.ximon.admin.service;
 
 
-import cn.hutool.core.collection.CollUtil;
 import cn.hutool.http.HttpUtil;
 import com.alibaba.fastjson.JSON;
-import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
-import com.github.pagehelper.PageHelper;
+import com.sandu.common.domain.CommonPage;
 import com.sandu.common.execption.BusinessException;
 import com.sandu.common.object.BaseConditionVO;
 import com.sandu.common.service.impl.BaseServiceImpl;
-import com.sandu.ximon.admin.param.MonitorParam;
-import com.sandu.ximon.admin.security.SecurityUtils;
-import com.sandu.ximon.dao.bo.AirEquipmentBo;
-import com.sandu.ximon.dao.bo.MonitorBo;
-import com.sandu.ximon.dao.domain.Monitor;
+import com.sandu.common.util.SpringContextHolder;
 import com.sandu.ximon.admin.dto.YSY_AccessTokenDto;
 import com.sandu.ximon.admin.dto.YSY_MonitorDto;
+import com.sandu.ximon.admin.param.MonitorParam;
+import com.sandu.ximon.admin.redis.DeviceRedisKey;
+import com.sandu.ximon.admin.security.SecurityUtils;
+import com.sandu.ximon.admin.utils.ListPagingUtils;
+import com.sandu.ximon.admin.utils.RedisUtils;
+import com.sandu.ximon.admin.utils.StoreOperationRecordsUtils;
+import com.sandu.ximon.admin.vo.EquipmentInfomation;
+import com.sandu.ximon.admin.vo.RedisDeviceStatus;
+import com.sandu.ximon.dao.bo.MonitorBo;
+import com.sandu.ximon.dao.domain.Monitor;
+import com.sandu.ximon.dao.domain.PoleBinding;
+import com.sandu.ximon.dao.enums.OrderByEnums;
+import com.sandu.ximon.dao.enums.PoleBindingEnums;
 import com.sandu.ximon.dao.mapper.MonitorMapper;
 import lombok.AllArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
 import org.springframework.stereotype.Service;
 
+import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.concurrent.CountDownLatch;
 
 @Service
 @AllArgsConstructor
+@Slf4j
 public class MonitorService extends BaseServiceImpl<MonitorMapper, Monitor> {
     private final MonitorMapper monitorMapper;
     //钀ょ煶浜慉ppKey
@@ -50,43 +61,154 @@
 
     private final PoleBindingService poleBindingService;
 
+    private final RedisUtils redisUtils;
+
     /**
-     * 妯$硦鏌ヨ
+     * 鎽勫儚澶村垪琛ㄦā绯婃煡璇�
      */
-    public List<MonitorBo> listMonitorByKeyword(BaseConditionVO baseConditionVO, MonitorParam monitorParam) {
-        Long clientId = SecurityUtils.getClientId();
-        PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
-        List<MonitorBo> monitorList;
+    public CommonPage listMonitorByKeyword(BaseConditionVO baseConditionVO, Integer order, Integer seq, MonitorParam monitorParam) {
         //缁戝畾鐘舵�侊細宸茬粦瀹�/鏈粦瀹�/鍏ㄩ儴
         if (monitorParam.getBindingState() == null) {
             //鍏ㄩ儴
             monitorParam.setBindingState(2);
+        }
+        //鎺掑簭瀛楁
+        String orderByResult = "id";
+        //姝e簭銆佸�掑彊
+        String orderBySeq = OrderByEnums.ASC.getCode();
+        if (order != null) {
+            switch (order) {
+                case 1:
+                    orderByResult = OrderByEnums.MONITOR_POLE_NAME.getCode();
+                    break;
+                case 2:
+                    orderByResult = OrderByEnums.MONITOR_CREATE_TIME.getCode();
+                    break;
+                default:
+            }
+        }
+        if (seq != null) {
+            switch (seq) {
+                case 1:
+                    orderBySeq = " ASC";
+                    break;
+                case 2:
+                    orderBySeq = " DESC";
+                    break;
+                default:
+                    break;
+            }
+        }
+        //鎺掑簭鏂瑰紡
+        String orderBy = orderByResult + " " + orderBySeq;
+
+        List<MonitorBo> list;
+        if (SecurityUtils.getClientId() == null) {
+            list = monitorMapper.listMonitorDeviceSerial1(null, monitorParam.getKeyword(), monitorParam.getBindingState(), orderBy);
+        } else {
+            list = monitorMapper.listMonitorDeviceSerial1(SecurityUtils.getUserId(), monitorParam.getKeyword(), monitorParam.getBindingState(), orderBy);
+        }
+
+        //娌℃湁鏁版嵁鏃跺�欑洿鎺ヨ繑鍥炵┖鏁扮粍
+        if (list.size() == 0 || list == null) {
+            return new CommonPage();
+        }
+        List<String> device_serialList = new ArrayList<>(list.size());
+        CountDownLatch latch = new CountDownLatch(list.size());
+        for (Monitor demo : list) {
+            device_serialList.add(demo.getDeviceSerial());
+            getMonitorInfo_Async(demo, latch);
+        }
+        try {
+            latch.await();
+        } catch (InterruptedException e) {
+            e.printStackTrace();
         }
         if (monitorParam.getEquipmentState() == null) {
             //鍏ㄩ儴
             monitorParam.setEquipmentState(2);
         }
 
-        monitorList = monitorMapper.listMonitorByIds(monitorParam.getKeyword(), clientId, monitorParam.getBindingState(), monitorParam.getEquipmentState());
+        List<MonitorBo> temp = new ArrayList<>();
+        if (monitorParam.getEquipmentState() == 2) {
+            temp.addAll(list);
+        } else {
+            for (MonitorBo monitorBo : list) {
+                //绛涢�夌姸鎬佹暟鎹�
+                if (monitorBo.getEquipmentState().equals(monitorParam.getEquipmentState())) {
+                    temp.add(monitorBo);
+                }
+            }
+        }
 
-        return monitorList;
+        if (baseConditionVO == null) {
+            baseConditionVO = new BaseConditionVO();
+            baseConditionVO.setPageSize(null);
+            baseConditionVO.setPageNo(null);
+        }
+        CommonPage commonPage = ListPagingUtils.pages(temp, baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
+        return commonPage;
+    }
+
+    /**
+     * 鎽勫儚澶村垪琛ㄥ湴锛堢敤浜庨椤垫暟鎹粺璁★級
+     *
+     * @return
+     */
+    public List<MonitorBo> listMonitorOnHome() {
+
+        List<MonitorBo> list;
+        if (SecurityUtils.getClientId() == null) {
+            list = monitorMapper.listMonitorDeviceSerial1(null, null, 2, null);
+        } else {
+            list = monitorMapper.listMonitorDeviceSerial1(SecurityUtils.getUserId(), null, 2, null);
+        }
+
+        //娌℃湁鏁版嵁鏃跺�欑洿鎺ヨ繑鍥炵┖鏁扮粍
+        if (list == null) {
+            return new ArrayList<>();
+        }
+
+        return list;
     }
 
     /**
      * 鍒犻櫎鎽勫儚澶�
      *
-     * @param Id
+     * @param
      * @return
      */
-    public boolean deleteMonitor(Long Id) {
-        Monitor monitor = getById(Id);
-        if (monitor == null) {
-            throw new BusinessException("鎵句笉鍒版憚鍍忓ご");
+    public boolean deleteMonitor(List<Long> ids) {
+        List<Long> idList = new ArrayList<Long>();
+        List<Monitor> monitors = listByIds(ids);
+        if (!monitors.isEmpty()) {
+            monitors.forEach(
+                    monitor -> {
+                        if (monitor == null) {
+                            throw new BusinessException("鎵句笉鍒版憚鍍忓ご");
+                        }
+                        PoleBinding one = poleBindingService.getOne(Wrappers.lambdaQuery(PoleBinding.class).eq(PoleBinding::getDeviceCode, monitor.getDeviceSerial()));
+                        if (one != null) {
+                            //鍒犻櫎鎽勫儚澶磋澶囧墠闇�瑕佸厛瑙g粦
+                            poleBindingService.unBindPole(null, monitor.getDeviceSerial());
+                        }
+                        /**
+                         * 鍒犻櫎鎽勫儚澶存棩蹇楄褰曞紑濮�
+                         */
+                        String content = "{鎽勫儚澶碈ode锛�" + monitor.getDeviceSerial() + "锛� 鎽勫儚澶村悕绉帮細" + monitor.getDeviceName() + " }";
+                        List<String> listCode = new ArrayList<>();
+                        listCode.add(monitor.getDeviceSerial());
+                        StoreOperationRecordsUtils.storeOperationData(listCode, null, "鍒犻櫎鎽勫儚澶�", content);
+                        /**
+                         * 鍒犻櫎鎽勫儚澶存棩蹇楄褰曠粨鏉�
+                         */
+                        idList.add(monitor.getId());
+                    }
+            );
         }
+        //鍏ㄩ儴鍒犻櫎鎴愬姛
+        return removeByIds(idList);
 
-        //鍒犻櫎鎽勫儚澶磋澶囧墠闇�瑕佸厛瑙g粦
-        poleBindingService.unBindPole(null, monitor.getDeviceSerial());
-        return removeById(Id);
     }
 
     /**
@@ -98,46 +220,151 @@
         paramMap.put("appKey", AppKey);
         paramMap.put("appSecret", Secret);
         String s = HttpUtil.post(YSY_URL + ACCESSTOKEN_URL, paramMap);
+        if (!s.startsWith("{") || !s.endsWith("}")) {
+            log.error("鑾峰彇鎽勫儚澶磘oken澶辫触,鏍煎紡鏈夎!");
+        }
         YSY_AccessTokenDto accessTokenDto = JSON.parseObject(s, YSY_AccessTokenDto.class);
+
+        //浜屾鑾峰彇
+        if (accessTokenDto == null) {
+            log.error("鑾峰彇鎽勫儚澶磘oken澶辫触,鏍煎紡鏈夎!");
+            s = HttpUtil.post(YSY_URL + ACCESSTOKEN_URL, paramMap);
+            accessTokenDto = JSON.parseObject(s, YSY_AccessTokenDto.class);
+        }
         return accessTokenDto.getData().getAccessToken();
+    }
+
+
+    /**
+     * 鑾峰彇钀ょ煶浜戞憚鍍忓ご淇℃伅(寮傛)
+     *
+     * @return
+     */
+    public void getMonitorInfo_Async(Monitor monitor, CountDownLatch countDownLatch) {
+        Thread t = new Thread() {
+            @Override
+            public void run() {
+                String token = getAccessToken();
+                Map<String, Object> paramMap = new HashMap<>();
+                paramMap.put("accessToken", token);
+                paramMap.put("deviceSerial", monitor.getDeviceSerial());
+                String s = HttpUtil.post(YSY_URL + GET_DEVICE_URL, paramMap);
+                YSY_MonitorDto monitorDto = null;
+                try {
+                    monitorDto = JSON.parseObject(s, YSY_MonitorDto.class);
+                    System.out.println(s + "       ----------");
+                    monitor.setEquipmentState(monitorDto.getData().getStatus());
+                    countDownLatch.countDown();
+                } catch (Exception e) {
+                    monitor.setEquipmentState(0);
+                    countDownLatch.countDown();
+                }
+            }
+        };
+        t.start();
+
+    }
+
+    /**
+     * 鑾峰彇钀ょ煶浜戞憚鍍忓ご淇℃伅  鏃犻渶楠岃瘉accessToken
+     *
+     * @return
+     */
+    public EquipmentInfomation getMonitorInfo(String deviceSerial) {
+        EquipmentInfomation equipmentInfo = new EquipmentInfomation();
+        equipmentInfo.setEquipmentType("鎽勫儚澶�");
+        if (deviceSerial == null || deviceSerial.trim().length() == 0) {
+            return equipmentInfo;
+        }
+
+        Monitor one = getOne(Wrappers.lambdaQuery(Monitor.class).eq(Monitor::getDeviceSerial, deviceSerial));
+        if (one != null) {
+            equipmentInfo.setEquipmentCreateTime(one.getAddTime());
+            equipmentInfo.setEquipmentMac(one.getDeviceSerial());
+            equipmentInfo.setEquipmentName(one.getDeviceName());
+        }
+
+        String token = getAccessToken();
+        Map<String, Object> paramMap = new HashMap<>();
+        paramMap.put("accessToken", token);
+        paramMap.put("deviceSerial", deviceSerial);
+        String s = HttpUtil.post(YSY_URL + GET_DEVICE_URL, paramMap);
+
+        try {
+            YSY_MonitorDto monitorDto = JSON.parseObject(s, YSY_MonitorDto.class);
+            if (monitorDto != null) {
+                //鍦ㄧ嚎鐘舵�侊細0-涓嶅湪绾匡紝1-鍦ㄧ嚎
+                if (monitorDto.getData().getStatus() == 1) {
+                    equipmentInfo.setEquipmentState("鍦ㄧ嚎");
+                } else {
+                    equipmentInfo.setEquipmentState("绂荤嚎");
+                }
+            }
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+        return equipmentInfo;
     }
 
     /**
      * 娣诲姞钀ょ煶浜戞憚鍍忓ご
      *
-     * @param accessToken  鎺堟潈杩囩▼鑾峰彇鐨刟ccess_token
      * @param deviceSerial 璁惧搴忓垪鍙�,瀛樺湪鑻辨枃瀛楁瘝鐨勮澶囧簭鍒楀彿锛屽瓧姣嶉渶涓哄ぇ鍐�
      *                     //     * @param validateCode 璁惧楠岃瘉鐮侊紝璁惧鏈鸿韩涓婄殑鍏綅澶у啓瀛楁瘝
      */
-//    public YSY_MonitorDto addYSYMonitor(String accessToken, String deviceSerial, String validateCode) {
-    public YSY_MonitorDto addYSYMonitor(String accessToken, String deviceSerial) {
+    public boolean addYSYMonitor(String deviceSerial, String validateCode) {
+        List<Monitor> list = list(Wrappers.lambdaQuery(Monitor.class).eq(Monitor::getDeviceSerial, deviceSerial));
+        if (list.size() != 0) {
+            throw new BusinessException("璇ユ憚鍍忓ご宸插瓨鍦紝鏃犳硶閲嶅娣诲姞锛�");
+        }
 
         Map<String, Object> paramMap = new HashMap<>();
-        paramMap.put("accessToken", accessToken);
+        paramMap.put("accessToken", getAccessToken());
         paramMap.put("deviceSerial", deviceSerial);
-//        paramMap.put("validateCode", validateCode);
+        if (validateCode != null && validateCode.trim().length() != 0) {
+            paramMap.put("validateCode", validateCode);
+        }
         String s = HttpUtil.post(YSY_URL + ADD_DEVICE_URL, paramMap);
-        System.out.println(s);
+        if (!s.startsWith("{") && !s.endsWith("}")) {
+            throw new BusinessException("钀ょ煶浜戞暟鎹紓甯�");
+        }
+
         YSY_MonitorDto monitorDto = JSON.parseObject(s, YSY_MonitorDto.class);
-        return monitorDto;
-    }
 
+        boolean result;
+        if ("20017".equals(monitorDto.getCode())) {
+            //褰撳墠鎽勫儚澶村凡缁忚钀ょ煶浜戝畼缃戞坊鍔犺繃,Code:20017
+            monitorDto = getYSYMonitorInfo(getAccessToken(), deviceSerial);
 
-    /**
-     * 鍒犻櫎钀ょ煶浜戞憚鍍忓ご
-     *
-     * @param accessToken  鎺堟潈杩囩▼鑾峰彇鐨刟ccess_token
-     * @param deviceSerial 璁惧搴忓垪鍙�,瀛樺湪鑻辨枃瀛楁瘝鐨勮澶囧簭鍒楀彿锛屽瓧姣嶉渶涓哄ぇ鍐�
-     */
-    public YSY_MonitorDto deleteYSYMonitor(String accessToken, String deviceSerial) {
+        } else if (!"200".equals(monitorDto.getCode())) {
+            //褰撳墠鎽勫儚澶存垚鍔熻钀ょ煶浜戝畼缃戞坊鍔�,Code:200
+            throw new BusinessException(monitorDto.getMsg());
+        }
 
-        Map<String, Object> paramMap = new HashMap<>();
-        paramMap.put("accessToken", accessToken);
-        paramMap.put("deviceSerial", deviceSerial);
-        String s = HttpUtil.post(YSY_URL + DELETE_DEVICE_URL, paramMap);
-        System.out.println(s);
-        YSY_MonitorDto monitorDto = JSON.parseObject(s, YSY_MonitorDto.class);
-        return monitorDto;
+        if (monitorDto.getData() == null) {
+            throw new BusinessException("钀ょ煶浜戞暟鎹紓甯革紒");
+        }
+        Monitor monitor = new Monitor();
+        monitor.setDeviceSerial(monitorDto.getData().getDeviceSerial());
+        monitor.setDevicesCode(validateCode);
+        monitor.setDeviceName(monitorDto.getData().getDeviceName());
+        monitor.setEquipmentState(monitorDto.getData().getStatus());
+        monitor.setIsEncrypt(monitorDto.getData().getIsEncrypt());
+        monitor.setDeviceType(monitorDto.getData().getModel());
+        monitor.setNetAddress(monitorDto.getData().getNetAddress());
+        result = addMonitorInfoToTable(monitor);
+
+        /**
+         * 鏂板鎽勫儚澶村紑濮�
+         */
+        String content = "{鎽勫儚澶碈ode锛�" + monitor.getDeviceSerial() + "锛� 鎽勫儚澶村悕绉帮細" + monitor.getDeviceName() + " }";
+        List<String> listCode = new ArrayList<>();
+        listCode.add(monitor.getDeviceSerial());
+        StoreOperationRecordsUtils.storeOperationData(listCode, null, "鏂板鎽勫儚澶�", content);
+        /**
+         * 鏂板鎽勫儚澶寸粨鏉�
+         */
+        return result;
     }
 
     /**
@@ -171,29 +398,6 @@
             monitor.setId(one.getId());
             return updateById(monitor);
         }
-    }
-
-    /**
-     * 灏嗘憚鍍忓ご璁惧鐩稿叧淇℃伅鏇存柊鍒版暟鎹簱
-     *
-     * @param monitor 鎽勫儚澶村璞�
-     * @return
-     */
-    public boolean upDateMonitorInfo(Monitor monitor) {
-        if (monitor.getId() == null) {
-            throw new BusinessException("缂哄皯鎽勫儚澶寸浉鍏矷D鍙傛暟");
-        }
-
-        Monitor info = getById(monitor.getId());
-
-        if (info == null) {
-            throw new BusinessException("鎵句笉鍒扮浉鍏虫憚鍍忓ご");
-        }
-        if (!monitor.getDevicesCode().equals(info.getDevicesCode()) || !monitor.getDeviceSerial().equals(info.getDeviceSerial())) {
-            throw new BusinessException("鐩戞帶搴忓垪鍙锋垨鐩戞帶楠岃瘉鐮佷笉姝g‘");
-        }
-
-        return updateById(monitor);
     }
 
     /**
@@ -246,4 +450,70 @@
     }
 
 
+    /**
+     * 淇敼note
+     *
+     * @param deviceSerial
+     * @param notes
+     * @return
+     */
+    public boolean updateNotes(String deviceSerial, String notes) {
+        if (deviceSerial == null || deviceSerial.trim().length() == 0 || notes == null) {
+            throw new BusinessException("淇敼澶囨敞鍙傛暟鏈夎锛�");
+        }
+        Monitor one = getOne(Wrappers.lambdaQuery(Monitor.class).eq(Monitor::getDeviceSerial, deviceSerial));
+
+        boolean belong = SpringContextHolder.getBean(PoleBindingService.class).isBelong(one.getDeviceSerial(), PoleBindingEnums.MONITOR);
+        if (!belong) {
+            throw new BusinessException("璇ヨ澶囦笉灞炰簬鎮�,涓嶈兘淇敼璁惧淇℃伅");
+        }
+        if (one != null) {
+            one.setNote(notes);
+
+            /**
+             * 娣诲姞鎽勫儚澶村娉ㄦ棩蹇楄褰曞紑濮�
+             */
+            String content = "缂栬緫鎽勫儚澶达細" + deviceSerial + "缂栬緫鍐呭锛�" + notes;
+            List<String> list = new ArrayList<>();
+            list.add(deviceSerial);
+            StoreOperationRecordsUtils.storeOperationData(list, null, "缂栬緫鎽勫儚澶�", content);
+            /**
+             * 娣诲姞鎽勫儚澶村娉ㄦ棩蹇楄褰曠粨鏉�
+             */
+            return updateById(one);
+        } else {
+            throw new BusinessException("鎽勫儚澶磋澶囦笉瀛樺湪锛�");
+        }
+    }
+
+
+    /**
+     * 鍚慠edis涓瓨鍏ヨ澶囩姸鎬�
+     */
+    public void setCacheData() {
+        list().forEach(
+                device -> {
+                    RedisDeviceStatus deviceStatus = new RedisDeviceStatus();
+                    deviceStatus.setDeviceId(device.getDeviceSerial());
+                    if (device != null) {
+                        EquipmentInfomation monitorInfo = getMonitorInfo(device.getDeviceSerial());
+                        if (monitorInfo != null) {
+                            if ("鍦ㄧ嚎".equals(monitorInfo.getEquipmentState())) {
+                                deviceStatus.setStatus(0);
+                            } else {
+                                deviceStatus.setStatus(1);
+                            }
+
+                        } else {
+                            deviceStatus.setStatus(1);
+                        }
+                    }
+                    redisUtils.set(DeviceRedisKey.MONITOR + device.getDeviceSerial(), JSON.toJSONString(deviceStatus));
+//                    redisUtils.delete(DeviceRedisKey.MONITOR + device.getDeviceSerial());
+                }
+        );
+
+    }
+
+
 }

--
Gitblit v1.9.3