交直流断路器测控

lxw

2023-12-14 88f9644cf27f24eedb390b6467839f6bcbe09f4e

交直流断路器测控

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

@@ -47,4 +47,10 @@
    public Response getBreakerName(){
        return service.getBreakerName();
    }

    @GetMapping("getBreakerInfByAddr")
    @ApiOperation("根据断路器位置获取断路器信息和告警状态")
    public Response getBreakerInfByAddr(@RequestParam String breakAddr){
        return service.getBreakerInfByAddr(breakAddr);
    }
}

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

@@ -13,4 +13,6 @@
    List<String> getBreakerAddr();
    //获取断路器名称
    List<String> getBreakerName();
    //根据断路器位置获取断路器信息和告警状态
    List<BreakerInf> getBreakerInfByAddr(String breakAddr);
}

 src/main/java/com/whyc/pojo/db_ckpwrdev_break_alarm/CKPowerDevBreakAlarm.java

@@ -64,6 +64,7 @@
    @ApiModelProperty(value = "告警状态[0-实时的告警  1-历史的告警  2-取消的告警]")
    private Integer almClearedType;


    @TableField(exist = false)
    private String breakerType;
    @TableField(exist = false)

 src/main/java/com/whyc/pojo/db_ckpwrdev_break_alarm/CKPowerDevBreakAlarmConfig.java

@@ -46,7 +46,7 @@
    private Integer almLevel;

    @ApiModelProperty(value = "断路器id")
    private Integer breakId;
    private Integer breakerId;

    @ApiModelProperty(value = "预警值")
    private Float almEarly;

 src/main/java/com/whyc/pojo/db_ckpwrdev_break_alarm/CKPowerDevBreakAlarmHistory.java

@@ -2,6 +2,7 @@


import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;
@@ -31,6 +32,7 @@

    private Integer almClearedType;


    @TableField(exist = false)
    private String breakerType;
    @TableField(exist = false)

 src/main/java/com/whyc/pojo/db_ckpwrdev_inf/BreakerInf.java

@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.whyc.pojo.db_ckpwrdev_break_alarm.CKPowerDevBreakAlarm;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
@@ -11,6 +12,7 @@
import lombok.experimental.Accessors;

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

/**
 * <p>
@@ -61,4 +63,7 @@
    @ApiModelProperty(value = "断路器id")
    private Integer breakerId;

    @TableField(exist = false)
    private List<CKPowerDevBreakAlarm> breakerAlmList;

}

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

@@ -48,4 +48,9 @@
        List<String> list=mapper.getBreakerName();
        return new Response().setII(1,list!=null,list,"获取断路器名称");
    }
    //根据断路器位置获取断路器信息和告警状态
    public Response getBreakerInfByAddr(String breakAddr) {
        List<BreakerInf> list=mapper.getBreakerInfByAddr(breakAddr);
        return new Response().setII(1,list!=null,list,"获取断路器开关");
    }
}

 src/main/resources/mapper/BreakerInfMapper.xml

@@ -28,4 +28,32 @@
    <select id="getBreakerName" resultType="java.lang.String">
        select distinct breaker_name from db_ckpwrdev_inf.tb_breaker_inf
    </select>
    <resultMap id="breakAndAlm" type="com.whyc.pojo.db_ckpwrdev_inf.BreakerInf">
        <id column="num" property="num"></id>
        <result column="breaker_id" property="breakerId"></result>
        <result column="breaker_name" property="breakerName"></result>
        <result column="breaker_addr" property="breakerAddr"></result>
        <result column="breaker_type" property="breakerType"></result>
        <result column="breaker_level" property="breakerLevel"></result>
        <result column="gateway_id" property="gatewayId"></result>
        <result column="node_name" property="nodeName"></result>
        <result column="node_bit" property="nodeBit"></result>
        <collection property="breakerAlmList" javaType="java.util.ArrayList" ofType="com.whyc.pojo.db_ckpwrdev_break_alarm.CKPowerDevBreakAlarm"
                    column="{almId=alm_id}" select="selectAlmById">
        </collection>
    </resultMap>
    <select id="getBreakerInfByAddr" resultMap="breakAndAlm">
        SELECT tb_breaker_inf.*,tb_ckpowerdev_break_alarm_config.alm_id
        from db_ckpwrdev_inf.tb_breaker_inf,db_ckpwrdev_break_alarm.tb_ckpowerdev_break_alarm_config
        <where>
            tb_breaker_inf.breaker_id=tb_ckpowerdev_break_alarm_config.break_id
            and tb_breaker_inf.breaker_addr=#{breakAddr}
        </where>
    </select>
    <select id="selectAlmById" resultType="com.whyc.pojo.db_ckpwrdev_break_alarm.CKPowerDevBreakAlarm">
        select * from db_ckpwrdev_break_alarm.tb_ckpowerdev_break_alarm
        <where>
            alm_id=#{almId}
        </where>
    </select>
</mapper>

 src/main/resources/mapper/CKPowerDevBreakAlarmConfigMapper.xml

@@ -12,7 +12,7 @@
        <result column="alm_name" property="almName"></result>
        <result column="alm_en" property="almEn"></result>
        <result column="alm_level" property="almLevel"></result>
        <result column="break_id" property="breakId"></result>
        <result column="breaker_id" property="breakerId"></result>
        <result column="alm_early" property="almEarly"></result>
        <result column="alm_value" property="almValue"></result>
        <association property="breakerInf">