设备实时告警sql调整

whyczh

2022-04-23 3d4d4ba6282b68a5d25e140e9dbc85c8e050d00d

设备实时告警sql调整

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

@@ -3,13 +3,14 @@
import com.whyc.dto.paramter.AlarmPar;
import com.whyc.dto.paramter.DevAlarmPar;
import com.whyc.pojo.DevalarmData;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface DevalarmDataMapper extends CustomMapper<DevalarmData>{
    //设备告警实时查询
    List serchByInfo(DevAlarmPar par);
    List serchByInfo(@Param("par") DevAlarmPar par);

    //设备告警数查询
    int searchNums(int intValue);

 src/main/resources/mapper/DevalarmDataMapper.xml

@@ -1,7 +1,7 @@
<?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.DevalarmDataMapper" >
    <resultMap id="devAlarmRes" type="DevalarmData">
    <resultMap id="devAlarmRes" type="com.whyc.pojo.DevalarmData">
        <result property="num" column="num"></result>
        <result property="devId" column="dev_id"></result>
        <result property="devIp" column="dev_ip"></result>
@@ -18,39 +18,33 @@

    </resultMap>

    <select id="serchByInfo" resultMap="devAlarmRes">
    <select id="serchByInfo" 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,
        db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.FbsDeviceName  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="stationName1!=''">
                and stationname1=#{stationName1}
            <if test="par.stationName1!=''">
                and stationname1=#{par.stationName1}
            </if>
            <if test="stationName1=''">
            and stationname1!=#{stationName1}

            <if test="par.stationName!=''">
                and stationname=#{par.stationName}
            </if>
            <if test="stationName!=''">
                and stationname=#{stationName}

            <if test="par.almType!=0 and par.almType!=null">
                and alm_type=#{par.almType}
            </if>
            <if test="stationName=''">
                and stationname!=#{stationName}
            </if>
            <if test="almType!=0  and almType!=null">
                and alm_type=#{almType}
            </if>
            <if test="almType==0">
                and alm_type!=#{almType}
            </if>
            <if test="almIsConfirmed!=null">
                and db_alarm.tb_devalarm_data.alm_is_confirmed=#{almIsConfirmed}

            <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=#{uId})
            and db_user.tb_user_inf.uid=#{par.uId})
        </where>
        ORDER BY alm_start_time desc ,dev_name asc
    </select>