Merge branch 'master' of http://192.168.0.105:10010/r/jfptManager

nnnjjj123

2021-01-11 b6ebb7d8e25fa5505494204abbc54da849ca548e

Merge branch 'master' of http://192.168.0.105:10010/r/jfptManager

 src/main/java/org/springblade/modules/Netty/controller/nettyController.java

@@ -140,7 +140,7 @@
        response.setHeader("Access-Control-Allow-Credentials","true");
        ConcurrentHashMap<String, Channel> channelHashMap = ChannelMap.getChannelHashMap();
        System.out.println(channelHashMap);
        String s = catalogService.selectCatalogEqNUmber(pid);
        String s = "";
        if (s==null){
            return R.success("暂无设备布防");
        }
@@ -167,7 +167,7 @@
        response.setHeader("Access-Control-Allow-Credentials","true");
        ConcurrentHashMap<String, Channel> channelHashMap = ChannelMap.getChannelHashMap();
        System.out.println(channelHashMap);
        String s = catalogService.selectCatalogEqNUmber(pid);
        String s = "";
        if (s==null){
            return R.success("暂无设备撤防");
        }

 src/main/java/org/springblade/modules/catalog/mapper/catalogMapper.java

@@ -39,5 +39,5 @@
    List<Map<String, Object>> selectEq();
    List<Map<String, Object>> selectWar();

    String selectCatalogEqNUmber(String pid);
    List selectCatalogEqNUmber(String pid);
}

 src/main/java/org/springblade/modules/catalog/mapper/catalogMapper.xml

@@ -15,8 +15,13 @@
        SELECT id,name,pId FROM `sys_catalog`
    </select>

    <select id="selectCatalogEqNUmber" resultType="java.lang.String">
        SELECT GROUP_CONCAT(eqid) FROM sys_catalog WHERE pId=#{pid} and eqid is NOT NULL;
    <select id="selectCatalogEqNUmber" resultType="java.util.HashMap">

        SELECT
            *
        FROM
            sys_catalog

    </select>

    <select id="selectCount" resultType="java.util.HashMap">

 src/main/java/org/springblade/modules/catalog/service/catalogService.java

@@ -34,7 +34,7 @@
 */
public interface catalogService extends IService<catalog> {
    List<Map<String, Object>> selectCatalogList();
    String selectCatalogEqNUmber(String pid);
    List<Map<String, Object>> selectCatalogEqNUmber(String pid);
    List<Map<String, Object>> selectCount();
    List<Map<String, Object>> selectAddvcd();
    List<Map<String, Object>> selectEq();

 src/main/java/org/springblade/modules/catalog/service/impl/CatalogServiceImpl.java

@@ -47,7 +47,7 @@
    }

    @Override
    public String selectCatalogEqNUmber(String pid) {
    public List selectCatalogEqNUmber(String pid) {
        return baseMapper.selectCatalogEqNUmber(pid);
    }


 src/main/java/org/springblade/modules/equipment/controller/EquipmentController.java

@@ -40,10 +40,12 @@
import org.springblade.core.boot.ctrl.BladeController;
import springfox.documentation.annotations.ApiIgnore;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * 控制器
@@ -97,30 +99,26 @@
        response.setHeader("Access-Control-Allow-Origin", "*");
        response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
        response.setHeader("Access-Control-Allow-Credentials", "true");
        List<EquipmentVO> pages;

        //清空全局参数
        childMenu = new ArrayList();

        //根据查询条件得到所有设备
        List<EquipmentVO> pages = equipmentService.selectEquipmentPage(equipment.getDeviceName(), equipment.getAddvcd(), equipment.getDtype(), equipment.getDevicestate());

        List<EquipmentVO> datas = new ArrayList<>();

        if (pid == null) {
            pages = equipmentService.selectEquipmentPage(equipment.getDeviceName(), equipment.getAddvcd(), equipment.getDtype(), equipment.getDevicestate());
            for(int i=0;i<pages.size();i++){
                String expireTime = pages.get(i).getExpireTime();
                //1.获取当前时间
                Date dd=new Date();
                SimpleDateFormat sim=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                String end=sim.format(dd);
                //把string类型转换为long类型的
                long st=sim.parse(expireTime).getTime();
                long en=sim.parse(end).getTime();
                //计算天数
                int day=(int) ((st-en)/86400000);
                if (day<=30){
                   pages.get(i).setType(1);
                }
            }
            datas = pages;
        } else {
            String s = catalogService.selectCatalogEqNUmber(pid);
            if (s == null) {
                pages = equipmentService.selectEquipmentPage(equipment.getDeviceName(), equipment.getAddvcd(), equipment.getDtype(), equipment.getDevicestate());
                for(int i=0;i<pages.size();i++){
                    String expireTime = pages.get(i).getExpireTime();
            List<Map<String, Object>> treedatas = catalogService.selectCatalogEqNUmber(pid);
            //根据传入的id递归出该节点下所有的设备
            List<Map<String, Object>> childList = treeMenuList(treedatas, Integer.parseInt(pid));
            //将得到的设备与查询所得设备进行匹配
            for (int i = 0; i < childList.size(); i++) {
                for (int j = 0; j < pages.size(); j++) {

                    String expireTime = pages.get(j).getExpireTime();
                    //1.获取当前时间
                    Date dd=new Date();
                    SimpleDateFormat sim=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
@@ -131,38 +129,38 @@
                    //计算天数
                    int day=(int) ((st-en)/86400000);
                    if (day<=30){
                        pages.get(i).setType(1);
                        pages.get(j).setType(1);
                    }


                    if (childList.get(i).get("eqid") != null) {
                        if (childList.get(i).get("eqid").equals(pages.get(j).getDeviceNumber())) {
                            datas.add(pages.get(j));
                    }
                }
            } else {
                String[] split = s.split(",");
                String strArrays = "";
                for (int i = 0; i < split.length; i++) {
                    strArrays += "'" + split[i] + "',";
                }
                String substring = strArrays.substring(0, strArrays.length() - 1);
                equipment.setDeviceName(substring);
                pages = equipmentService.selectEquipmentPage(equipment.getDeviceName(), equipment.getAddvcd(), equipment.getDtype(), equipment.getDevicestate());
                for(int i=0;i<pages.size();i++){
                    String expireTime = pages.get(i).getExpireTime();
                    //1.获取当前时间
                    Date dd=new Date();
                    SimpleDateFormat sim=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                    String end=sim.format(dd);
                    //把string类型转换为long类型的
                    long st=sim.parse(expireTime).getTime();
                    long en=sim.parse(end).getTime();
                    //计算天数
                    int day=(int) ((st-en)/86400000);
                    if (day<=30){
                        pages.get(i).setType(1);
                    }
        }
        return R.data(datas);
    }

    //子节点
    private static List childMenu = new ArrayList();

    public static List treeMenuList(List<Map<String, Object>> menuList, int pid) {
        for (int i = 0; i < menuList.size(); i++) {
            //遍历出父id等于参数的id，add进子节点集合

            if (pid != 0) {
                if (menuList.get(i).get("pId").equals(pid)) {
                    //递归遍历下一级
                    treeMenuList(menuList, Integer.valueOf((Integer) menuList.get(i).get("id")));
                    childMenu.add(menuList.get(i));
                }
            }

        }

        return R.data(pages);
        return childMenu;
    }

    /**
@@ -262,6 +260,5 @@
        List<EquipmentVOS> list = equipmentService.selectList(deviceType);
        return R.data(list);
    }


}

 src/main/resources/application-dev.yml

@@ -17,13 +17,13 @@
      primary: master
      datasource:
        master:
          url: jdbc:mysql://47.110.245.84:3306/springboot?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true&useOldAliasMetadataBehavior=true
          url: jdbc:mysql://47.110.245.84:3306/springboot?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true&useOldAliasMetadataBehavior=true
          username: sa
          password: 131556
          driver-class-name: com.mysql.cj.jdbc.Driver
        slaves:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://47.110.245.84:3306/fjpt?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true&useOldAliasMetadataBehavior=true
          url: jdbc:mysql://47.110.245.84:3306/fjpt?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true&useOldAliasMetadataBehavior=true
          username: sa
          password: 131556