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/KaoQinDao.java | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/hxzk/mapper/KaoQinDao.java b/src/main/java/com/hxzk/mapper/KaoQinDao.java
index 24e4f37..99c4b07 100644
--- a/src/main/java/com/hxzk/mapper/KaoQinDao.java
+++ b/src/main/java/com/hxzk/mapper/KaoQinDao.java
@@ -13,10 +13,9 @@
@Select("select * from tb_kaoqing_${nyr}")
public List<TbKaoqing> findAllKaoQin(String nyr);
- @Select("select * from tb_kaoqing_${name} WHERE intime >= #{intime} ${bumen} where outtime <= #{outtime}")
+ @Select("select * from tb_kaoqing_${name} where intime >= #{intime} ${bumen} where outtime <= #{outtime}")
public List<TbKaoqing> findSearchTime(TbKaoqing kaoqing);
- @Select("select * from tb_kaoqing_${name} WHERE name = #{tagid} or tagid = #{tagid} and intime >= #{intime} ${bumen} and outtime <= #{outtime}")
-// @Select("SELECT * FROM tb_kaoqing_${name} WHERE name = #{tagid} or tagid = #{tagid} and intime >= #{intime} and outtime <= #{outtime} UNION SELECT * FROM tb_kaoqing_${bumen} WHERE name = #{tagid} or tagid = #{tagid} and intime >= #{intime} and outtime <= #{outtime}")
+ @Select("SELECT * FROM tb_kaoqing_${name} WHERE name = #{tagid} or tagid = #{tagid} UNION SELECT * FROM tb_kaoqing_${bumen} WHERE name = #{tagid} or tagid = #{tagid} and intime >= #{intime} and outtime <= #{outtime}")
public List<TbKaoqing> findSearch(TbKaoqing kaoqing);
}
--
Gitblit v1.9.3