| | |
|---|
| | | @Repository |
|---|
| | | public interface WarningDao extends BaseMapper<TbWarning> { |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,w.baoliu8,w.baoliu9,p.p_name,p.p_phone as pphone,w.baoliu10 FROM `tb_warning` w INNER JOIN tb_person p on p.p_tagid = w.objectid WHERE DATE(time) = CURDATE() and w.status = '未处理' and w.baoliu6 = '0' ") |
|---|
| | | //除了人员聚集类型其他告警都获取 |
|---|
| | | @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,w.baoliu8,w.baoliu9,p.p_name,p.p_phone AS pphone,w.baoliu10 FROM `tb_warning` w INNER JOIN tb_person p ON p.p_tagid = w.objectid WHERE w.status = '未处理' AND w.baoliu6 = '0' AND w.type <> '人员聚集'") |
|---|
| | | List<com.hxzk.deo.TbWarning> findDaPingGaoJing(); |
|---|
| | | |
|---|
| | | //只获取人员聚集 |
|---|
| | | @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,w.baoliu8,w.baoliu9,p.p_name,p.p_phone AS pphone,w.baoliu10,p.baoliu38 FROM `tb_warning` w INNER JOIN tb_person p ON p.p_tagid = w.objectid WHERE w.status = '未处理' AND w.baoliu6 = '0' AND w.`type` = '人员聚集' AND p.baoliu38 >1") |
|---|
| | | List<com.hxzk.deo.TbWarning> findDaPingGaoJingRenYuanJuJi(); |
|---|
| | | @Select("SELECT count(*) FROM `tb_warning` WHERE DATE(time) = CURDATE() and `status` = '未处理'") |
|---|
| | | Integer findDaPingWeiChuLiCount(); |
|---|
| | | |
|---|
