From 3734974695b65ccf63b1df9281deede91195fc11 Mon Sep 17 00:00:00 2001
From: zhitong.yu <xynz17@163.com>
Date: 星期二, 16 四月 2024 17:09:55 +0800
Subject: [PATCH] 通用版本V1.5 注：修复历史考勤时间范围查找
---
src/main/java/com/hxzk/mapper/KaoQinDao.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/hxzk/mapper/KaoQinDao.java b/src/main/java/com/hxzk/mapper/KaoQinDao.java
index 99ba89c..99c4b07 100644
--- a/src/main/java/com/hxzk/mapper/KaoQinDao.java
+++ b/src/main/java/com/hxzk/mapper/KaoQinDao.java
@@ -13,9 +13,9 @@
@Select("select * from tb_kaoqing_${nyr}")
public List<TbKaoqing> findAllKaoQin(String nyr);
- @Select("select * from tb_kaoqing_${name} where intime >= #{intime} and outtime <= #{outtime} UNION select * from tb_kaoqing_${bumen} where intime >= #{intime} and 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} 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.10.0