From f233ba26bbf8703fcc4e86a5dbb9d6026f91e7d6 Mon Sep 17 00:00:00 2001
From: zhanzhiqin <895896009@qq.com>
Date: 星期五, 04 三月 2022 18:14:03 +0800
Subject: [PATCH] C3充电桩

---
 ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java |  443 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 441 insertions(+), 2 deletions(-)

diff --git a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
index e837d24..df13ffc 100644
--- a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
+++ b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
@@ -1,14 +1,39 @@
 package com.sandu.ximon.admin.service;
 
+import cn.hutool.core.collection.CollectionUtil;
+import cn.hutool.core.util.StrUtil;
+import com.aliyuncs.iot.model.v20180120.BatchGetDeviceStateResponse;
+import com.aliyuncs.iot.model.v20180120.QueryDeviceDetailResponse;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.github.pagehelper.PageHelper;
 import com.sandu.common.execption.BusinessException;
 import com.sandu.common.redis.RedisService;
 import com.sandu.common.service.impl.BaseServiceImpl;
+import com.sandu.ximon.admin.dto.DeviceStatus;
+import com.sandu.ximon.admin.manager.iot.frame.A1Frame;
+import com.sandu.ximon.admin.manager.iot.frame.FrameBuilder;
+import com.sandu.ximon.admin.manager.iot.frame.IRequestFrame;
+import com.sandu.ximon.admin.manager.iot.frame.inner.request.A1TernaryCodeReqInnerFrame;
+import com.sandu.ximon.admin.manager.iot.frame.inner.request.A5LightResetReqInnerFrame;
+import com.sandu.ximon.admin.manager.iot.frame.inner.request.EmptyRequestInnerFrame;
+import com.sandu.ximon.admin.manager.iot.frame.inner.response.A1DeviceMacRespInnerFrame;
+import com.sandu.ximon.admin.manager.iot.frame.inner.response.A1TernaryCodeRespInnerFrame;
+import com.sandu.ximon.admin.manager.iot.rrpc.dto.CommonFrame;
+import com.sandu.ximon.admin.manager.iot.rrpc.dto.WrapResponseCommonFrame;
+import com.sandu.ximon.admin.manager.iot.rrpc.enums.A1OrderEnum;
+import com.sandu.ximon.admin.manager.iot.rrpc.enums.A2OrderEnum;
+import com.sandu.ximon.admin.manager.iot.rrpc.enums.A5OrderEnum;
+import com.sandu.ximon.admin.manager.iot.rrpc.enums.DeviceStateEnum;
+import com.sandu.ximon.admin.manager.iot.rrpc.mainboard.MainBoardInvokeSyncService;
 import com.sandu.ximon.admin.param.PoleBindingParam;
 import com.sandu.ximon.admin.param.PoleParam;
+import com.sandu.ximon.admin.param.PoleStatesParam;
 import com.sandu.ximon.admin.redis.LightKey;
+import com.sandu.ximon.admin.security.SecurityUtils;
 import com.sandu.ximon.dao.domain.Pole;
 import com.sandu.ximon.dao.domain.PoleBinding;
-import com.sandu.ximon.dao.enums.PoleBindingEnums;
+import com.sandu.ximon.dao.domain.PoleGroupRelation;
 import com.sandu.ximon.dao.mapper.PoleMapper;
 import lombok.AllArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
@@ -16,7 +41,11 @@
 import org.springframework.stereotype.Service;
 
 import java.text.SimpleDateFormat;
+import java.util.ArrayList;
 import java.util.Date;
+import java.util.List;
+import java.util.Objects;
+import java.util.stream.Collectors;
 
 /**
  * 鐏潌鐩稿叧
@@ -30,6 +59,7 @@
 
     private final RedisService redisService;
     private final PoleBindingService poleBindingService;
+    private final PoleGroupRelationService groupRelationService;
 
     public boolean addPole(PoleParam param) {
         Pole pole = new Pole();
@@ -79,6 +109,204 @@
         return Long.parseLong(sb.toString());
     }
 
+
+    public List<Pole> queryAllStatesAndList(Integer pageNo, Integer pageSize, PoleStatesParam param) {
+        // List<LampPost> list = list(Wrappers.lambdaQuery(LampPost.class).eq(LampPost::getClientId, SecurityUtils.getUserId()));
+        //List<Pole> list = list(Wrappers.lambdaQuery(Pole.class));
+//        PageHelper.startPage(pageNo, pageSize);
+        List<Pole> list = new ArrayList<>();
+        LambdaQueryWrapper<Pole> wrapper = new LambdaQueryWrapper<>();
+        if (SecurityUtils.getClientId() == null) {
+            wrapper = Wrappers.lambdaQuery(Pole.class);
+        } else {
+            wrapper = Wrappers.lambdaQuery(Pole.class).eq(Pole::getClientId, SecurityUtils.getUserId());
+        }
+        if (!param.getKeyword().isEmpty()) {
+            wrapper.like(Pole::getPoleCode, param.getKeyword()).or(
+                    wrappers -> {
+                        wrappers.like(Pole::getPoleName, param.getKeyword());
+                    }
+            );
+        }
+
+        list = list(wrapper);
+        List<Pole> bindList = new ArrayList<>();//宸茬粦瀹氬鎴�
+        List<Pole> unbindList = new ArrayList<>();//鏈粦瀹氬鎴�
+        List<Pole> isTrue = new ArrayList<>();//瀹炰綋鐏潌
+        List<Pole> isFalse = new ArrayList<>();//铏氭嫙鐏潌
+        List<Pole> online = new ArrayList<>();//鍦ㄧ嚎
+        List<Pole> offline = new ArrayList<>();//绂荤嚎
+        if (param.getGroupid() != null) {
+            //  List<Long> poleIds = new ArrayList<>();
+            List<Pole> pole = new ArrayList<>();
+            List<PoleGroupRelation> relations = groupRelationService.list(Wrappers.lambdaQuery(PoleGroupRelation.class)
+                    .eq(PoleGroupRelation::getPoleGroupId, param.getGroupid()));
+            relations.forEach(relation -> {
+                        pole.add(getById(relation.getPoleId()));
+                    }
+            );
+            list = pole;
+        }
+
+        list.forEach(bindwarpper -> {
+//                Long clientId = bindwarpper.getClientId();
+            if (bindwarpper.getClientId() == null) {//鍒ゆ柇鏄惁缁戝畾
+                unbindList.add(bindwarpper);
+                if (bindwarpper.getDeviceCode() == null) {//鍒ゆ柇鐏潌绫诲瀷
+                    isFalse.add(bindwarpper);
+                } else {
+                    isTrue.add(bindwarpper);
+                }
+            } else {
+                bindList.add(bindwarpper);
+                if (bindwarpper.getDeviceCode() == null) {
+                    isFalse.add(bindwarpper);
+                } else {
+                    isTrue.add(bindwarpper);
+                }
+            }
+        });
+        if (param.getBingStates() == 1) { //鏈粦瀹�
+            list = unbindList;
+        } else if (param.getBingStates() == 0) {//宸茬粦瀹�
+            list = bindList;
+        }// else {//鍏ㄩ儴
+//            list = list(wrapper);
+//        }
+
+        setOnline(list);
+        if (param.getIsTrue() == 1) { //铏氭嫙鐏潌
+            list = isFalse;
+        } else if (param.getIsTrue() == 0) {//瀹炰綋鐏潌
+            list = isTrue;
+            list.forEach(onLinePole -> {
+//                System.out.println("online-----------------------"+onLinePole.getOnLineState());
+                if (("ONLINAE").equals(onLinePole.getOnLineState())) {
+                    online.add(onLinePole);
+                } else if (("OFFLINE").equals(onLinePole.getOnLineState())) {
+                    offline.add(onLinePole);
+                }
+            });
+        } else {//鍏ㄩ儴
+           // setOnline(list);
+           list.forEach(onLinePole -> {
+//               System.out.println("online-----------------------"+onLinePole.getOnLineState());
+               if (("ONLINE").equals(onLinePole.getOnLineState())) {
+                    online.add(onLinePole);
+                } else if (("OFFLINE").equals(onLinePole.getOnLineState())) {
+                    offline.add(onLinePole);
+                }
+            });
+       }
+
+        if (param.getOnLineStates() == 1) { //绂荤嚎
+            list = offline;
+        } else if (param.getOnLineStates() == 0) {//鍦ㄧ嚎
+            list = online;
+        }
+        setCount(list);
+        return list;
+    }
+
+    /**
+     * 璁剧疆缁戝畾璁惧鏁伴噺
+     * @param list
+     * @return
+     */
+    public List<Pole> setCount(List<Pole> list) {
+        for (Pole post : list) {
+            int size = poleBindingService.list(Wrappers.lambdaQuery(PoleBinding.class).eq(PoleBinding::getPoleId, post.getId())).size();
+//                    System.out.println("size:----------------------"+size);
+            post.setBindingCount(size);
+        }
+        return list;
+    }
+
+    /**
+     * 璁剧疆鍦ㄧ嚎鐘舵��
+     * @param list
+     * @return
+     */
+    public List<Pole> setOnline(List<Pole> list) {
+
+        List<String> MacCodes = new ArrayList<>();
+
+        for (Pole post : list) {
+            if (post.getDeviceCode() != null) {
+                MacCodes.add(post.getDeviceCode());
+            }
+        }
+//
+        List<BatchGetDeviceStateResponse.DeviceStatus> deviceStatuses = MainBoardInvokeSyncService.getInstance().batchGetDeviceState(MacCodes);
+        if (deviceStatuses != null) {
+            for (Pole post : list) {
+                for (BatchGetDeviceStateResponse.DeviceStatus deviceStatus : deviceStatuses) {
+//                System.out.println("DeviceCode:---------------------"+post.getDeviceCode());
+//                System.out.println("DeviceName:---------------------"+deviceStatus.getDeviceName());
+                    if (post.getDeviceCode() != null && post.getDeviceCode().equals(deviceStatus.getDeviceName())) {
+                        post.setOnLineState(deviceStatus.getStatus());
+//                        int size = poleBindingService.list(Wrappers.lambdaQuery(PoleBinding.class).eq(PoleBinding::getPoleId, post.getId())).size();
+////                    System.out.println("size:----------------------"+size);
+//                        post.setBindingCount(size);
+                    }
+                }
+                //  MacCodes.add(post.getDeviceCode());
+            }
+        }
+
+        return list;
+    }
+
+
+    /**
+     * 鏌ヨ鐏潌鐨勫湪绾跨姸鎬佸苟璧嬪��
+     *
+     * @return
+     */
+    public List<Pole> queryStatesAndList(Integer pageNo, Integer pageSize, String keyword, Long groupid) {
+        // List<LampPost> list = list(Wrappers.lambdaQuery(LampPost.class).eq(LampPost::getClientId, SecurityUtils.getUserId()));
+        //List<Pole> list = list(Wrappers.lambdaQuery(Pole.class));
+        PageHelper.startPage(pageNo, pageSize);
+        List<Pole> list = new ArrayList<>();
+        LambdaQueryWrapper<Pole> wrapper = new LambdaQueryWrapper<>();
+        if (SecurityUtils.getClientId() == null) {
+            wrapper = Wrappers.lambdaQuery(Pole.class);
+        } else {
+            wrapper = Wrappers.lambdaQuery(Pole.class).eq(Pole::getClientId, SecurityUtils.getUserId());
+        }
+        if (!keyword.isEmpty()) {
+            wrapper.like(Pole::getPoleCode, keyword).or(
+                    wrappers -> {
+                        wrappers.like(Pole::getPoleName, keyword);
+                    }
+            );
+        }
+        list = list(wrapper);
+        List<String> MacCodes = new ArrayList<>();
+
+        for (Pole post : list) {
+            MacCodes.add(post.getDeviceCode());
+        }
+        List<BatchGetDeviceStateResponse.DeviceStatus> deviceStatuses = MainBoardInvokeSyncService.getInstance().batchGetDeviceState(MacCodes);
+        for (Pole post : list) {
+            for (BatchGetDeviceStateResponse.DeviceStatus deviceStatus : deviceStatuses) {
+//                System.out.println("DeviceCode:---------------------"+post.getDeviceCode());
+//                System.out.println("DeviceName:---------------------"+deviceStatus.getDeviceName());
+                if (post.getDeviceCode() != null && post.getDeviceCode().equals(deviceStatus.getDeviceName())) {
+                    post.setOnLineState(deviceStatus.getStatus());
+                    int size = poleBindingService.list(Wrappers.lambdaQuery(PoleBinding.class).eq(PoleBinding::getPoleId, post.getId())).size();
+//                    System.out.println("size:----------------------"+size);
+                    post.setBindingCount(size);
+                }
+            }
+            //  MacCodes.add(post.getDeviceCode());
+        }
+
+
+        return list;
+    }
+
+
     /**
      * 鐏潌缁戝畾璁惧
      *
@@ -91,6 +319,217 @@
         if (pole == null) {
             throw new BusinessException("鏈壘鍒拌鐏潌");
         }
-        return poleBindingService.bindPole( poleId,  param);
+        return poleBindingService.bindPole(poleId, param);
+    }
+
+    /**
+     * 鐏潌瑙g粦缁戝畾璁惧
+     *
+     * @return 鏄惁鎴愬姛
+     */
+    public boolean unBindPole(Long poleId, String deviceCode) {
+        return poleBindingService.unBindPole(poleId, deviceCode);
+    }
+
+
+    /**
+     * 鐏潌鎭㈠鍑哄巶璁剧疆
+     *
+     * @param id
+     * @return
+     */
+    public boolean poleReset(Long id) {
+        Pole byId = getById(id);
+        String deviceName = byId.getDeviceCode();
+        if (byId == null) {
+            throw new BusinessException("鏈壘鍒拌鐏潌");
+        }
+        if (deviceName.isEmpty()) {
+            throw new BusinessException("璇ョ伅鏉哅ca涓虹┖");
+        }
+        IRequestFrame build = FrameBuilder.builderA5()
+                .orderType(A5OrderEnum.REQUEST_LIGHT_DATA.getCode())
+                .innerFrame(new A5LightResetReqInnerFrame())
+                .build();
+        CommonFrame commonFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(deviceName, build);
+        System.out.println(commonFrame.toString());
+        CommonFrame rebootFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(deviceName,
+                        FrameBuilder.builderA2().innerFrame(new EmptyRequestInnerFrame())
+                                .orderType(A2OrderEnum.REQUEST_MAIN_BOARD_RESET.getCode()).build());
+        if ("00".equals(rebootFrame.getPayload())) {
+            System.out.println("閲嶅惎鎴愬姛");
+        }
+
+        CommonFrame result = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(deviceName,
+                        FrameBuilder.builderA2().innerFrame(new EmptyRequestInnerFrame())
+                                .orderType(A2OrderEnum.REQUEST_MAIN_BOARD_RESET.getCode()).build());
+
+        boolean b = false;
+        if ("00".equals(result.getPayload())) {
+            byId.setDeviceCode(null);
+            b = updateById(byId);
+            System.out.println("閲嶅惎鎴愬姛");
+        }
+        return b;
+    }
+
+
+    /**
+     * 缁欑伅鏉嗘敞鍐屼笁鍏冪爜
+     */
+    public boolean setMac(String baseMac) {
+        // public boolean setMac() {
+        //Pole pole = getById(poleId);
+       /* if (pole == null) {
+            throw new BusinessException("鏈壘鍒拌鐏潌");
+        }*/
+
+        boolean setMac = false;
+        //String baseMac = "baseDevice";
+        A1Frame a1Frame = new A1Frame(A1OrderEnum.REQUEST_READ_DEVICE_UNIQUE_MAC.getCode(), new EmptyRequestInnerFrame());
+        CommonFrame commonFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(baseMac, a1Frame);
+        if (commonFrame == null) {
+            throw new BusinessException("璇诲彇璁惧鍞竴ID澶辫触");
+        }
+        A1DeviceMacRespInnerFrame a1DeviceMacRespInnerFrame = new A1DeviceMacRespInnerFrame().transformFrame(commonFrame.getPayload());
+        log.info(commonFrame.toString());
+        String uniqueMac = a1DeviceMacRespInnerFrame.getMac();
+        uniqueMac = uniqueMac.toLowerCase();
+
+        if (uniqueMac.isEmpty()) {
+            throw new BusinessException("璇诲彇璁惧鍞竴ID澶辫触!");
+        }
+        log.info("鍞竴鐮亄}", uniqueMac);
+
+        // 2  浠庨樋閲屾敞鍐�
+        MainBoardInvokeSyncService.getInstance().registerDevice(uniqueMac);
+
+        // 3  鑾峰彇璁惧璇︽儏
+        QueryDeviceDetailResponse.Data deviceDetail = MainBoardInvokeSyncService.getInstance().queryDeviceDetail(uniqueMac, null);
+        if (deviceDetail == null) {
+            throw new BusinessException("娉ㄥ唽澶辫触");
+        }
+        log.info(deviceDetail.toString());
+
+        // 4   閰嶇疆Mac鈶�
+        WrapResponseCommonFrame<A1TernaryCodeRespInnerFrame> productKeyResp = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(baseMac,
+                        FrameBuilder.builderA1().innerFrame(new A1TernaryCodeReqInnerFrame(MainBoardInvokeSyncService.getInstance().getProductKey()))
+                                .orderType(A1OrderEnum.REQUEST_SET_PRODUCT_KEY.getCode()).build(),
+                        A1TernaryCodeRespInnerFrame.class);
+        A1TernaryCodeRespInnerFrame responseInnerFrame = productKeyResp.getResponseInnerFrame();
+        if (!MainBoardInvokeSyncService.getInstance().getProductKey().equals(responseInnerFrame.getTernaryCode())) {
+            throw new BusinessException("璁惧閰嶇疆ProductKey澶辫触");
+        }
+
+        // 5   閰嶇疆Mac鈶�
+        WrapResponseCommonFrame<A1TernaryCodeRespInnerFrame> responseCommonFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(baseMac,
+                        FrameBuilder.builderA1().innerFrame(new A1TernaryCodeReqInnerFrame(uniqueMac))
+                                .orderType(A1OrderEnum.REQUEST_SET_DEVICE_NAME.getCode()).build(),
+                        A1TernaryCodeRespInnerFrame.class);
+        A1TernaryCodeRespInnerFrame deviceNameFrame = responseCommonFrame.getResponseInnerFrame();
+        if (!uniqueMac.equals(deviceNameFrame.getTernaryCode())) {
+            throw new BusinessException("璁惧閰嶇疆鍚嶅け璐�");
+        }
+
+        // 6  閰嶇疆Mac鈶�
+        WrapResponseCommonFrame<A1TernaryCodeRespInnerFrame> wrapResponseCommonFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(baseMac,
+                        FrameBuilder.builderA1().innerFrame(new A1TernaryCodeReqInnerFrame(deviceDetail.getDeviceSecret()))
+                                .orderType(A1OrderEnum.REQUEST_SET_DEVICE_SECRET.getCode()).build(),
+                        A1TernaryCodeRespInnerFrame.class);
+        A1TernaryCodeRespInnerFrame deviceSecretFrame = wrapResponseCommonFrame.getResponseInnerFrame();
+        if (!deviceDetail.getDeviceSecret().equals(deviceSecretFrame.getTernaryCode())) {
+            throw new BusinessException("璁惧瀵嗛挜澶辫触");
+        }
+
+
+        // 7  閲嶅惎璁惧  骞朵娇鐢ㄦ柊鐨凪ac
+        CommonFrame rebootFrame = MainBoardInvokeSyncService.getInstance()
+                .sendRRPC(baseMac,
+                        FrameBuilder.builderA2().innerFrame(new EmptyRequestInnerFrame())
+                                .orderType(A2OrderEnum.REQUEST_MAIN_BOARD_RESET.getCode()).build());
+        if ("00".equals(rebootFrame.getPayload())) {
+            //  pole.setDeviceCode(uniqueMac);
+
+            // setMac = updateById(pole);
+
+            System.out.println("閲嶅惎鎴愬姛");
+        }
+
+        Pole pole = new Pole();
+        String strh = uniqueMac.substring(uniqueMac.length() - 2, uniqueMac.length());
+        pole.setDeviceCode(strh);
+        pole.setPoleName(strh);
+        String strm = uniqueMac.substring(0, uniqueMac.length() - 2);
+        int i = Integer.parseInt(strm);
+        pole.setPoleCode(generatePoleCode());
+        pole.setDeviceType(i);
+        setMac = save(pole);
+
+        return setMac;
+    }
+
+    public List<String> listDeviceCodeByIds(List<Long> poleIdList) {
+        if (CollectionUtil.isEmpty(poleIdList)) {
+            return null;
+        }
+        List<Pole> list = list(Wrappers.lambdaQuery(Pole.class).in(Pole::getId, poleIdList).select(Pole::getDeviceCode));
+        return list
+                .stream().filter(Objects::nonNull).map(Pole::getDeviceCode).filter(StrUtil::isNotEmpty).collect(Collectors.toList());
+    }
+
+    /**
+     * 鎵归噺鑾峰彇闃块噷浜戣澶囩殑鐘舵��
+     *
+     * @param deviceCodeList 闃块噷浜戣澶囩爜
+     * @return 璁惧鐘舵�佸垪琛�
+     */
+    public List<DeviceStatus> listStatusByDeviceCode(ArrayList<String> deviceCodeList) {
+        // 鏈�澶у彧鑳芥煡50涓�
+        List<List<String>> split = CollectionUtil.split(deviceCodeList, 50);
+        List<DeviceStatus> statusList = new ArrayList<>();
+        for (List<String> list : split) {
+            List<BatchGetDeviceStateResponse.DeviceStatus> deviceStatuses = MainBoardInvokeSyncService.getInstance().batchGetDeviceState(list);
+            if (CollectionUtil.isNotEmpty(deviceStatuses)) {
+                for (BatchGetDeviceStateResponse.DeviceStatus d : deviceStatuses) {
+                    DeviceStatus deviceStatus = new DeviceStatus();
+                    deviceStatus.setDeviceCode(d.getDeviceName());
+                    deviceStatus.setStatus(DeviceStateEnum.getCode(d.getStatus()));
+                    statusList.add(deviceStatus);
+                }
+            }
+        }
+        return statusList;
+    }
+
+    /**
+     * 鐢ㄦ埛缁戝畾鐏潌
+     *
+     * @param clientId 鐢ㄦ埛ID
+     * @param poleIds  鐏潌ID
+     * @return
+     */
+    public boolean ClientBindingPole(long clientId, int[] poleIds) {
+        boolean r = false;
+        for (int poleId : poleIds) {
+            Pole pole = getById(poleId);
+            if (pole == null) {
+                throw new BusinessException("鐏潌涓嶅瓨鍦�");
+            }
+            pole.setClientId(clientId);
+            r = updateById(pole);
+
+            if (!r) {
+                throw new BusinessException("鐏潌ID涓�" + poleId + "璁剧疆澶辫触,鑷姩鍋滄");
+            }
+
+        }
+        return r;
     }
 }

--
Gitblit v1.9.3