电源历史告警

lxw

2023-04-11 162587bafc25dd653b3a6c5565aeb4738520015d

电源历史告警

 src/main/resources/mapper/PwrdevAlarmHistoryMapper.xml

@@ -36,7 +36,6 @@
                    #{almType}
                </foreach>
            </if>

            and StationId in ( select distinct inf.StationId from
            (select StationId from db_battinf.tb_battinf union select StationId from db_pwrdev_inf.tb_pwrdev_inf ) inf,
            db_user.tb_user_battgroup_baojigroup_battgroup,
@@ -50,7 +49,7 @@
        </where>
    </select>
    <select id="serchByLevel" resultType="java.lang.Integer">
        select alarm.*,inf.StationName from db_pwrdev_alarm.tb_pwrdev_alarm_history alarm,db_pwrdev_inf.tb_pwrdev_inf
        select count(1) from db_pwrdev_alarm.tb_pwrdev_alarm_history alarm,db_pwrdev_inf.tb_pwrdev_inf
        inf
        <where>
            alarm.PowerDeviceId = inf.PowerDeviceId
@@ -69,7 +68,7 @@
            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=#{usrId} )
            and db_user.tb_user_inf.uid=#{uId} )
        </where>
    </select>