From 7901cb0801dff4e4b3f8dfc48179b8e8f2713ea9 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期三, 21 二月 2024 17:01:52 +0800 Subject: [PATCH] 优化库区图视频点位信息接口数据同步 --- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java index 2f2903c..630a595 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java @@ -4,6 +4,7 @@ import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; +import java.util.Date; import java.util.List; /** @@ -16,9 +17,7 @@ * * @return */ -// @Query("from Fz40SecCamera where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ") -// List<Fz40SecCamera> listCamera(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); - @Query("from Fz40SecCamera where deptId=:deptId order by ipIn") - List<Fz40SecCamera> listCamera(@Param("deptId") String deptId); + @Query("from Fz40SecCamera where deptId=:deptId and updateTime >=:start and updateTime <:end order by ipIn ") + List<Fz40SecCamera> listCamera(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); } -- Gitblit v1.9.3