From b72f8f8d58417eb6fb29672d8ac17cfafa46775c Mon Sep 17 00:00:00 2001
From: zhitong.yu <xynz17@163.com>
Date: 星期六, 11 五月 2024 10:51:31 +0800
Subject: [PATCH] 增加:主界面选择系统页面，统计实时刷新，低电量人员数据显示
---
src/main/java/com/hxzk/mapper/WarningDao.java | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/hxzk/mapper/WarningDao.java b/src/main/java/com/hxzk/mapper/WarningDao.java
index aba91a4..b7536b8 100644
--- a/src/main/java/com/hxzk/mapper/WarningDao.java
+++ b/src/main/java/com/hxzk/mapper/WarningDao.java
@@ -10,10 +10,12 @@
@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' ")
+ //闄や簡浜哄憳鑱氶泦绫诲瀷鍏朵粬鍛婅閮借幏鍙�
+ @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();
--
Gitblit v1.9.3