From 13337ce8ed144c11dd004c97c28f5b86f95543d2 Mon Sep 17 00:00:00 2001 From: Administrator <1144154118@qq.com> Date: 星期六, 19 八月 2023 11:53:51 +0800 Subject: [PATCH] 巡检日历 --- ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml b/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml index 3f28c2a..6298d2d 100644 --- a/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml +++ b/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml @@ -148,7 +148,7 @@ <select id="oncePlan" parameterType="recordMonthExParam" resultMap="ArdAppPatrolplanResult"> select plan.* from ard_app_patrolplan plan LEFT JOIN ard_app_patroluser users on users.patrolplan_id = plan."id" - where users.app_user_id = #{userId} and cycle = 'once' and patro_begin_time like #{begin} and plan.del_name is null and plan.del_time is null ; + where users.app_user_id = #{userId} and cycle = 'once' and patro_begin_time >= #{begin} and plan.del_name is null and plan.del_time is null ; </select> <select id="dayPlan" parameterType="recordMonthExParam" resultMap="ArdAppPatrolplanResult"> -- Gitblit v1.9.3