From 70223b3ef4df02622869425fed4ba9b290e1aa74 Mon Sep 17 00:00:00 2001 From: fei.wang <wf18701153496@163.com> Date: 星期二, 16 四月 2024 14:07:59 +0800 Subject: [PATCH] V定制1.0 1:对讲功能 2:计算经纬度控制器systemcontrollen --- src/main/java/com/hxzk/mapper/WarningDao.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/hxzk/mapper/WarningDao.java b/src/main/java/com/hxzk/mapper/WarningDao.java index 9194ae8..aba91a4 100644 --- a/src/main/java/com/hxzk/mapper/WarningDao.java +++ b/src/main/java/com/hxzk/mapper/WarningDao.java @@ -11,7 +11,7 @@ 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` = '鏈鐞�'") -- Gitblit v1.9.3