| | |
|---|
| | | 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' ") |
|---|
| | | List<com.hxzk.deo.TbWarning> findDaPingGaoJing(); |
|---|
| | | |
|---|
| | | @Select("SELECT count(*) FROM `tb_warning` WHERE DATE(time) = CURDATE() and `status` = '未处理'") |
|---|
