From 1faff58d2b3291a4d579c6aa6fee8c8a0b77ea47 Mon Sep 17 00:00:00 2001
From: 16639036659 <577530412@qq.com>
Date: 星期三, 12 六月 2024 10:39:39 +0800
Subject: [PATCH] 专项检查任务模板-添加时间查询条件
---
src/main/resources/mybatis/tr/TbBaseCheckTaskMapper.xml | 6 ++++++
src/main/resources/mybatis/tr/TbBaseCheckScoreMapper.xml | 6 ++++++
src/main/resources/mybatis/tr/TbBaseCheckItemMapper.xml | 6 ++++++
3 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mybatis/tr/TbBaseCheckItemMapper.xml b/src/main/resources/mybatis/tr/TbBaseCheckItemMapper.xml
index fca2240..f5bff58 100644
--- a/src/main/resources/mybatis/tr/TbBaseCheckItemMapper.xml
+++ b/src/main/resources/mybatis/tr/TbBaseCheckItemMapper.xml
@@ -35,6 +35,12 @@
<if test="checkWay != null">
and check_way like concat('%',#{checkWay},'%')
</if>
+ <if test="createDate != null">
+ and create_date >= #{createDate}
+ </if>
+ <if test="updateDate != null">
+ and #{updateDate} >= update_date
+ </if>
order by create_date desc
</where>
</select>
diff --git a/src/main/resources/mybatis/tr/TbBaseCheckScoreMapper.xml b/src/main/resources/mybatis/tr/TbBaseCheckScoreMapper.xml
index 61a4df1..d029dda 100644
--- a/src/main/resources/mybatis/tr/TbBaseCheckScoreMapper.xml
+++ b/src/main/resources/mybatis/tr/TbBaseCheckScoreMapper.xml
@@ -27,6 +27,12 @@
<if test="isReject != null">
and is_reject = #{isReject}
</if>
+ <if test="createDate != null">
+ and create_date >= #{createDate}
+ </if>
+ <if test="updateDate != null">
+ and #{updateDate} >= update_date
+ </if>
order by create_date desc
</where>
</select>
diff --git a/src/main/resources/mybatis/tr/TbBaseCheckTaskMapper.xml b/src/main/resources/mybatis/tr/TbBaseCheckTaskMapper.xml
index 0e15a78..7848c9e 100644
--- a/src/main/resources/mybatis/tr/TbBaseCheckTaskMapper.xml
+++ b/src/main/resources/mybatis/tr/TbBaseCheckTaskMapper.xml
@@ -32,6 +32,12 @@
<if test="taskContent != null">
and task_content like concat('%',#{taskContent},'%')
</if>
+ <if test="createDate != null">
+ and create_date >= #{createDate}
+ </if>
+ <if test="updateDate != null">
+ and #{updateDate} >= update_date
+ </if>
order by create_date desc
</where>
</select>
--
Gitblit v1.9.2