From e9de9ec7a9a9677100a104718ed67ab85c8ca3a7 Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Fri, 12 Jul 2024 17:06:28 +0800
Subject: [PATCH] 每日报汛昨日报汛简报修改

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

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/YwFloodReportInfoMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/YwFloodReportInfoMapper.java
index 9f0e11e..e9eb9f4 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/YwFloodReportInfoMapper.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/YwFloodReportInfoMapper.java
@@ -7,6 +7,8 @@
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Select;
 
+import java.util.Date;
+
 /**
  * @Author AIX
  * @Date 2024/7/8 12:34
@@ -14,7 +16,7 @@
  */
 public interface YwFloodReportInfoMapper extends BaseMapper<YwFloodReportInfo> {
 
-	@Select("SELECT * FROM ywxt.yw_flood_report_info ORDER BY create_time DESC LIMIT 1")
-	YwFloodReportInfo getLatestReport(@Param(Constants.WRAPPER) QueryWrapper<YwFloodReportInfo> queryWrapper);
+	@Select("SELECT * FROM ywxt.yw_flood_report_info WHERE create_time >= #{oneDayBefore} ORDER BY create_time ASC LIMIT 1")
+	YwFloodReportInfo getLatestReport(@Param("oneDayBefore") String oneDayBefore);
 
 }

--
Gitblit v1.9.3