增加雷达连接状态state字段

‘liusuyi’

2024-02-01 7165b6b08902b794ead1134042dad6cfa3c2c468

增加雷达连接状态state字段

 ard-work/src/main/java/com/ruoyi/device/radar/domain/ArdEquipRadar.java

@@ -107,6 +107,18 @@
     * ip
     */
    private String ip;
    /**
     * 在线状态
     */
    private String state;

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public void setId(String id) {
        this.id = id;

 ard-work/src/main/resources/mapper/device/ArdEquipRadarMapper.xml

@@ -27,6 +27,7 @@
        <result property="type" column="type"/>
        <result property="ip" column="ip"/>
        <result property="towerName" column="name"/>
        <result property="state" column="state"/>
    </resultMap>

    <sql id="selectArdEquipRadarVo">
@@ -50,7 +51,8 @@
               c.image_width,
               c.image_height,
               c.type,
               c.ip
               c.ip,
               c.state
        from ard_equip_radar c
                 left join sys_dept d on d.dept_id = c.dept_id
                 left join sys_user u on u.user_id = c.user_id
@@ -78,7 +80,8 @@
        c.image_height,
        c.type,
        c.ip,
        t.name
        t.name,
        c.state
        from ard_equip_radar c
        left join sys_dept d on d.dept_id = c.dept_id
        left join sys_user u on u.user_id = c.user_id
@@ -131,6 +134,7 @@
            <if test="imageHeight != null">image_height,</if>
            <if test="type != null">type,</if>
            <if test="ip != null">ip,</if>
            <if test="state != null">state,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
@@ -154,6 +158,7 @@
            <if test="imageHeight != null">#{imageHeight},</if>
            <if test="type != null">#{type},</if>
            <if test="ip != null">#{ip},</if>
            <if test="state != null">#{state},</if>
        </trim>
    </insert>

@@ -180,6 +185,7 @@
            <if test="imageHeight != null">image_height = #{imageHeight},</if>
            <if test="type != null">type = #{type},</if>
            <if test="ip != null">ip = #{ip},</if>
            <if test="state != null">state = #{state},</if>
        </trim>
        where id = #{id}
    </update>