devAlarmData

whyclxw

2024-04-22 a18a94fa446bed4c3130a6c6f6323e2d317d0af6

devAlarmData

 src/main/java/com/whyc/dto/paramter/DevAlarmPar.java

@@ -18,6 +18,8 @@
@ToString
@JsonIgnoreProperties(ignoreUnknown = true)
public class DevAlarmPar implements Serializable {
    @ApiModelProperty(value = "机房id")
    private String stationId;
    @ApiModelProperty(value = "维护区")
    private String stationName1;
    @ApiModelProperty(value = "机房名称")

 src/main/resources/mapper/DevalarmDataMapper.xml

@@ -30,6 +30,39 @@
        FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf
        <where>
            tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId
            <if test="par.stationId!=''">
                and stationId=#{par.stationId}
            </if>
            <if test="par.almLevel!=0 and par.almLevel!=null">
                and alm_level=#{par.almLevel}
            </if>
            <if test="par.almType!=0 and par.almType!=null">
                and alm_type=#{par.almType}
            </if>

            <if test="par.almIsConfirmed!=null">
                and db_alarm.tb_devalarm_data.alm_is_confirmed=#{par.almIsConfirmed}
            </if>
            and db_alarm.tb_devalarm_data.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId
            from
            db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf
            where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId
            and
            db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id
            and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid
            and db_user.tb_user_inf.uid=#{par.uId})
        </where>
        ORDER BY alm_start_time desc ,dev_name asc
    </select>

    <select id="serchByInfo1" resultMap="devAlarmRes">
        SELECT distinct
        tb_devalarm_data.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_severity,
        db_battinf.tb_battinf.stationName,StationName1,StationName2,StationName3,StationName5,db_battinf.tb_battinf.stationId,db_battinf.tb_battinf.StationName4 as
        dev_name
        FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf
        <where>
            tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId
            <if test="par.stationName1!=''">
                and stationname1=#{par.stationName1}
            </if>