diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml index ec384b1..cbcdce2 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml @@ -157,7 +157,7 @@ alarm_records dd LEFT JOIN device_view dv ON dd.`DEVCODE` = dv.`DEVCODE` - where dv.VALID = '1' and dd.alarm_type = '1' + where dv.VALID = '1' and dd.alarm_content like '%报警%' AND dd.`ALARM_TIME`= ]]> #{startTime} @@ -177,7 +177,7 @@ alarm_records dd LEFT JOIN device_view dv ON dd.`DEVCODE` = dv.`DEVCODE` - where dv.VALID = '1' and dd.alarm_type = '3' + where dv.VALID = '1' and dd.alarm_content like '%预警%' AND dd.`ALARM_TIME`= ]]> #{startTime}