设备实时告警加参数

lxw

2022-12-23 b37e873d06ef845f8d0eb3a8a9f1c26cc8db00ba

设备实时告警加参数

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

@@ -1,9 +1,7 @@
package com.whyc.dto.paramter;

import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.whyc.dto.Page;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
@@ -36,5 +34,7 @@
    @ApiModelProperty(value = "操作时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date almStartTime1;
    @ApiModelProperty(value = "告警等级")
    private Date almLevel;

}

 src/main/resources/mapper/DevalarmDataMapper.xml

@@ -32,7 +32,9 @@
            <if test="par.stationName!=''">
                and stationname=#{par.stationName}
            </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>
@@ -41,9 +43,11 @@
                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
            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_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>