告警弹窗

whyclxw

2024-09-12 7bcb1a21458c239387100c21110b729c78cdc7a1

告警弹窗

 src/main/resources/mapper/DevalarmDataMapper.xml

@@ -55,7 +55,8 @@
    <select id="getDAlmPopUp" resultType="com.whyc.pojo.db_alarm.DevalarmData">
        select * from db_alarm.tb_devalarm_data
        <where>
            dev_id in (
            alm_is_confirmed=0
            and dev_id in (
            SELECT distinct dev_id from db_user.tb_battgroup_baojigroup,db_user.tb_battgroup_usr
            where
                tb_battgroup_baojigroup.baoji_group_id=tb_battgroup_usr.baoji_group_id