1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
| package com.hxzk.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import com.hxzk.pojo.TbWarning;
| import org.apache.ibatis.annotations.Select;
| import org.apache.ibatis.annotations.Update;
| import org.springframework.stereotype.Repository;
|
| import java.util.List;
| @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 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();
|
| @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
| "INNER JOIN tb_person p on p.p_tagid = w.objectid where status = '未处理' order by w.time desc")
| List<com.hxzk.deo.TbWarning> findSelect();
|
|
| @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,p.p_name FROM tb_warning w INNER JOIN tb_person p on p.p_tagid = w.objectid order by w.status desc,w.time DESC")
| List<com.hxzk.deo.TbWarning> findSelectHouTai();
|
| @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
| "INNER JOIN tb_person p on p.p_tagid = w.objectid WHERE w.objectid LIKE #{objectid} and status = '未处理' OR w.type LIKE #{objectid} and status = '未处理' ORDER BY w.time DESC")
| List<com.hxzk.deo.TbWarning> findSelectsearch(String objectid);
|
|
| @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
| "INNER JOIN tb_person p on p.p_tagid = w.objectid WHERE w.objectid LIKE #{objectid} OR w.type LIKE #{objectid} ORDER BY w.status DESC")
| List<com.hxzk.deo.TbWarning> findSelectsearchHouTai(String objectid);
|
| @Update("update tb_warning set baoliu6 = '1' where DATE(time) = CURDATE() and type = #{type}")
| void UpWarningIsshow(String type);
|
| @Update("update tb_warning set status = '已处理'")
| void UpStatusAll();
|
|
| @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,p.`p_phone`,p.p_name,p.p_tagid,p.p_department FROM tb_warning w Inner join tb_person p on p.`p_tagid` = w.`objectid` WHERE w.status = '未处理' and w.type = #{types} AND w.baoliu7 = '0'")
| List<com.hxzk.deo.TbWarning> findNowAll(String types);
|
|
| @Update("update tb_warning set baoliu7 = '1' where id = #{id}")
| void updateIdWarning(Integer id);
| }
|
|
