首页websocket提交

lxw

2023-06-30 e0c1fa9ec0ee6da804805f583f7b1d5f8552ef47

首页websocket提交

 src/main/java/com/whyc/controller/AirconditionerParamController.java

New file
@@ -0,0 +1,11 @@
package com.whyc.controller;

import io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "空调")
@RestController
@RequestMapping("envirState")
public class AirconditionerParamController {
}

 src/main/java/com/whyc/controller/AirconditionerStateController.java

New file
@@ -0,0 +1,11 @@
package com.whyc.controller;

import io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "空调")
@RestController
@RequestMapping("airconditionerState")
public class AirconditionerStateController {
}

 src/main/java/com/whyc/controller/EnvirStateController.java

New file
@@ -0,0 +1,12 @@
package com.whyc.controller;

import io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "环境监测")
@RestController
@RequestMapping("envirState")
public class EnvirStateController {

}

 src/main/java/com/whyc/controller/EnvironmentInfController.java

New file
@@ -0,0 +1,11 @@
package com.whyc.controller;

import io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "环境监测")
@RestController
@RequestMapping("environmentInf")
public class EnvironmentInfController {
}

 src/main/java/com/whyc/mapper/AirconditionerParamMapper.java

New file
@@ -0,0 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.AirconditionerParam;

public interface AirconditionerParamMapper extends CustomMapper<AirconditionerParam>{
}

 src/main/java/com/whyc/mapper/AirconditionerStateMapper.java

New file
@@ -0,0 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.AirconditionerState;

public interface AirconditionerStateMapper extends CustomMapper<AirconditionerState>{
}

 src/main/java/com/whyc/mapper/EnvirStateMapper.java

New file
@@ -0,0 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.EnvirState;

public interface EnvirStateMapper extends CustomMapper<EnvirState>{
}

 src/main/java/com/whyc/mapper/EnvironmentInfMapper.java

New file
@@ -0,0 +1,11 @@
package com.whyc.mapper;

import com.whyc.pojo.EnvironmentInf;

import java.util.List;

public interface EnvironmentInfMapper extends CustomMapper<EnvironmentInf>{

    //获取所有房间的实时数据
    List<EnvironmentInf> getEnvirInfSocket();
}

 src/main/java/com/whyc/pojo/AirconditionerParam.java

New file
@@ -0,0 +1,47 @@
package com.whyc.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;

/**
 * <p>
 * 空调参数控制表
 * </p>
 *
 * @author lxw
 * @since 2023-06-30
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_environment_rt",value = "tb_airconditioner_param")
@ApiModel(value="AirconditionerParam对象", description="空调参数控制表")
public class AirconditionerParam implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    @ApiModelProperty(value = "设备id")
    private Integer devId;

    @ApiModelProperty(value = "控制命令")
    private Integer opCmd;

    @ApiModelProperty(value = "温度")
    private Integer stTemp;

    @ApiModelProperty(value = "湿度")
    private Integer stHumid;


}

 src/main/java/com/whyc/pojo/AirconditionerState.java

New file
@@ -0,0 +1,70 @@
package com.whyc.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.Date;

/**
 * <p>
 * 空调实时状态信息表
 * </p>
 *
 * @author lxw
 * @since 2023-06-30
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_environment_rt",value = "tb_airconditioner_state")
@ApiModel(value="AirconditionerState对象", description="空调实时状态信息表")
public class AirconditionerState implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "自增主键")
    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    @ApiModelProperty(value = "设备id")
    private Integer devId;

    @ApiModelProperty(value = "更新时间")
    private Date recordTime;

    @ApiModelProperty(value = "空调温度")
    private Float airTemp;

    @ApiModelProperty(value = "空调湿度")
    private Float airHumid;

    @ApiModelProperty(value = "空调运行状态[1:运行  0:停止]")
    private Integer airSysstate;

    @ApiModelProperty(value = "值班运行状态[1-运行  0-停止]")
    private Integer airOnduty;

    @ApiModelProperty(value = "系统故障[1-报警  0-不报警]")
    private Integer airSysAlm;

    @ApiModelProperty(value = "负压/排浊[1-运行 0-不允许]")
    private Integer airPressturbid;

    @ApiModelProperty(value = "过滤报警[1-报警  0-不报警]")
    private Integer airFiltrationAlm;

    @ApiModelProperty(value = "通信计数")
    private Integer commCount;

    @ApiModelProperty(value = "错误计数")
    private Integer commErrCount;


}

 src/main/java/com/whyc/pojo/EnvirState.java

New file
@@ -0,0 +1,57 @@
package com.whyc.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.Date;

/**
 * <p>
 * 环境检测状态表
 * </p>
 *
 * @author lxw
 * @since 2023-06-30
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_environment_rt",value = "tb_envir_state")
@ApiModel(value="EnvirState对象", description="环境检测状态表")
public class EnvirState implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    @ApiModelProperty(value = "设备id号")
    private Integer devId;

    @ApiModelProperty(value = "记录时间")
    private Date recordTime;

    @ApiModelProperty(value = "温度[℃]")
    private Float devTemp;

    @ApiModelProperty(value = "湿度[%RH]")
    private Float devHumid;

    @ApiModelProperty(value = "压差[Pa]")
    private Float devPresss;

    @ApiModelProperty(value = "通信计数")
    private Integer commCount;

    @ApiModelProperty(value = "错误计数")
    private Integer commErrCount;


}

 src/main/java/com/whyc/pojo/EnvironmentInf.java

New file
@@ -0,0 +1,62 @@
package com.whyc.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.List;

/**
 * <p>
 * 环境监控系统资产信息表
 * </p>
 *
 * @author lxw
 * @since 2023-06-30
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_environment_inf",value = "tb_environment_inf")
@ApiModel(value="EnvironmentInf对象", description="环境监控系统资产信息表")
public class EnvironmentInf implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "自增主键")
    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    @ApiModelProperty(value = "房间id")
    private Integer roomId;

    @ApiModelProperty(value = "房间名称")
    private String roomName;

    @ApiModelProperty(value = "设备id")
    private Integer devId;

    @ApiModelProperty(value = "设备名称")
    private String devName;

    @ApiModelProperty(value = "设备ip地址")
    private String devIp;

    @ApiModelProperty(value = "视频序列号")
    private String videoUrl;

    @TableField(exist = false)
    @ApiModelProperty(value = "房间内设备状态")
    private EnvirState envirState;

    @TableField(exist = false)
    @ApiModelProperty(value = "房间内空调状态")
    private AirconditionerState envirAirState;
}

 src/main/java/com/whyc/service/AirconditionerParamService.java

New file
@@ -0,0 +1,7 @@
package com.whyc.service;

import org.springframework.stereotype.Service;

@Service
public class AirconditionerParamService {
}

 src/main/java/com/whyc/service/AirconditionerStateService.java

New file
@@ -0,0 +1,7 @@
package com.whyc.service;

import org.springframework.stereotype.Service;

@Service
public class AirconditionerStateService {
}

 src/main/java/com/whyc/service/EnvirStateService.java

New file
@@ -0,0 +1,7 @@
package com.whyc.service;

import org.springframework.stereotype.Service;

@Service
public class EnvirStateService {
}

 src/main/java/com/whyc/service/EnvironmentInfService.java

New file
@@ -0,0 +1,49 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.mapper.AirconditionerStateMapper;
import com.whyc.mapper.EnvirStateMapper;
import com.whyc.mapper.EnvironmentInfMapper;
import com.whyc.pojo.AirconditionerState;
import com.whyc.pojo.EnvirState;
import com.whyc.pojo.EnvironmentInf;
import com.whyc.pojo.Response;
import com.whyc.util.DevTypeUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class EnvironmentInfService {
    @Autowired(required = false)
    private EnvironmentInfMapper mapper;

    @Autowired(required = false)
    private EnvirStateMapper eStateMapper;

    @Autowired(required = false)
    private AirconditionerStateMapper aStateMapper;

    //获取所有房间的实时数据
    public Response getEnvirInfSocket() {
        QueryWrapper wrapper= Wrappers.query();
        wrapper.orderByAsc("room_id");
        List<EnvironmentInf> list=mapper.selectList(wrapper);
        list.stream().forEach(einf -> {
            int devId=einf.getDevId();
            QueryWrapper wrapperDev= Wrappers.query();
            wrapperDev.eq("dev_id",devId);
            wrapperDev.last("limit 1");
            if(devId/10000000== DevTypeUtil.eState){
                EnvirState eState=eStateMapper.selectOne(wrapperDev);
                einf.setEnvirState(eState);
            }else if(devId/10000000== DevTypeUtil.aState){
                AirconditionerState aState=aStateMapper.selectOne(wrapperDev);
                einf.setEnvirAirState(aState);
            }
        });
        return new Response().setII(1,true,list,"获取所有房间的实时数据");
    }
}

 src/main/java/com/whyc/util/DevTypeUtil.java

New file
@@ -0,0 +1,8 @@
package com.whyc.util;

public class DevTypeUtil {
    public static int eState=22;//其他设备
    public static int aState=21;//空调


}

 src/main/java/com/whyc/util/WebSocketEncoderUtil.java

New file
@@ -0,0 +1,30 @@
package com.whyc.util;

import com.google.gson.GsonBuilder;
import com.whyc.pojo.Response;

import javax.websocket.EncodeException;
import javax.websocket.Encoder;
import javax.websocket.EndpointConfig;

/**
 * 编译器
 */
public class WebSocketEncoderUtil implements Encoder.Text<Response> {


    @Override
    public String encode(Response o) throws EncodeException {
        return new GsonBuilder().setDateFormat("yyyy-MM-dd HH:mm:ss").create().toJson(o);
    }

    @Override
    public void init(EndpointConfig endpointConfig) {

    }

    @Override
    public void destroy() {

    }
}

 src/main/java/com/whyc/webSocket/HomePageWebSocket.java

New file
@@ -0,0 +1,101 @@
package com.whyc.webSocket;

import com.whyc.pojo.UserInf;
import com.whyc.service.EnvironmentInfService;
import com.whyc.util.WebSocketEncoderUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import javax.servlet.http.HttpSession;
import javax.websocket.*;
import javax.websocket.server.ServerEndpoint;
import java.util.HashMap;
import java.util.Map;

@Component
@ServerEndpoint(value = "/homePageSocket",encoders = WebSocketEncoderUtil.class)
public class HomePageWebSocket {
    private volatile Thread thread;

    private static final int executeTime = 5000;

    private volatile boolean runFlag=true;

    private volatile Map<String,Thread> threadMap = new HashMap<>();

    private volatile Map<Long,Boolean> threadFlagMap = new HashMap<>();

    private static EnvironmentInfService service;

    private Session session;

    @Autowired
    public void setService(EnvironmentInfService service){
        HomePageWebSocket.service = service;
    }

    @OnOpen
    public void onOpen(Session session){
        this.session=session;
        /*HttpSession httpSession = (HttpSession) config.getUserProperties().get("httpSession");
        UserInf user = (UserInf) httpSession.getAttribute("user");
        final int userId = user.getUId().intValue();
        final int userId = 1001;*/
        thread = new Thread("Thread_homePageSocket") {
            @Override
            public void run() {
                while (runFlag && !isInterrupted()) {
                    Thread thread = currentThread();
                    threadFlagMap.put(thread.getId(), true);
                    try {
                        if (session.isOpen()) {
                            //推送信息
                            synchronized (session) {
                                session.getBasicRemote().sendObject(service.getEnvirInfSocket());
                            }
                            threadFlagMap.put(thread.getId(), false);
                        }
                        sleep(executeTime);
                        //} catch (IOException | InterruptedException | EncodeException e) {
                    } catch (Exception e) {
                        interrupt();
                    }
                }
            }
        };
        thread.start();
        threadFlagMap.put(thread.getId(), true);
        //停止老的socket线程
        Thread threadBefore = threadMap.get(session.getId());
        if (threadBefore != null && threadBefore.isAlive()) {
            while (threadFlagMap.get(threadBefore.getId())) {
            }
            threadBefore.interrupt();
        }
        //将线程存储,便于调用定位
        threadMap.put(session.getId(), this.thread);
    }

    @OnMessage
    public void onMessage(Session session, String uId){
    }

    @OnClose
    public void onClose(CloseReason closeReason){
        System.err.println("closeReason = " + closeReason);
        runFlag = false;
        if (thread != null && thread.isAlive()) {
            thread.interrupt();
        }
        threadMap.remove(session.getId());
    }

    @OnError
    public void onError(Throwable error) {
        error.printStackTrace();
        if (thread != null && thread.isAlive()) {
            thread.interrupt();
        }
        threadMap.remove(session.getId());
    }
}

 src/main/resources/config/application-dev.yml

@@ -18,7 +18,7 @@
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.10.79:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    url: jdbc:mysql://192.168.10.79:3360/db_environment_inf?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://192.168.10.80:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://118.89.139.230:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    username: root

 src/main/resources/config/application-prod.yml

@@ -16,7 +16,7 @@
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.10.79:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    url: jdbc:mysql://192.168.10.79:3360/db_environment_inf?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://192.168.10.80:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://118.89.139.230:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    username: root

 src/main/resources/mapper/EnvironmentInfMapper.xml

New file
@@ -0,0 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.EnvironmentInfMapper">

</mapper>