From cbe116e3cdd3ba28d13cde9d203f542d651e8ee3 Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Thu, 01 Aug 2024 14:13:44 +0800
Subject: [PATCH] 人工上报时间筛选

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
index 1e948bb..945ce67 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
@@ -104,10 +104,10 @@
             AND r.reservoir_id = #{reportFloodRecord.reservoirId}
         </if>
         <if test="reportFloodRecord.startTime !=null and reportFloodRecord.startTime !=''">
-            AND DATE_FORMAT(r.report_time,'%Y-%m-%d') &gt;= #{reportFloodRecord.startTime}
+            AND r.report_time &gt;= #{reportFloodRecord.startTime}
         </if>
         <if test="reportFloodRecord.endTime !=null and reportFloodRecord.endTime !=''">
-            AND DATE_FORMAT(r.report_time,'%Y-%m-%d') &lt;= #{reportFloodRecord.endTime}
+            AND r.report_time &lt;= #{reportFloodRecord.endTime}
         </if>
         <if test="reportFloodRecord.createUser !=null and reportFloodRecord.createUser !=''">
             AND r.create_user = #{reportFloodRecord.createUser}

--
Gitblit v1.9.3