From 92be463c5a038062c42d758a6e18be62955007a7 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期四, 02 十一月 2023 20:35:17 +0800
Subject: [PATCH] 优化上海接口-调整视频信息等

---
 src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java
index 0bff8b7..d48f734 100644
--- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java
+++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java
@@ -5,6 +5,7 @@
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;
 
+import java.util.Date;
 import java.util.List;
 
 /**
@@ -14,6 +15,6 @@
  */
 public interface Fzzy40Sync1108Rep extends JpaRepository<Fz40Drug, String> {
 
-    @Query("from Fz40Drug where deptId=:deptId order by id")
-    List<Fz40Drug> listDrug(@Param("deptId") String deptId);
+    @Query("from Fz40Drug where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ")
+    List<Fz40Drug> listDrug(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end);
 }

--
Gitblit v1.9.3