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 +++----
src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1111.java | 2 +-
2 files changed, 4 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1111.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1111.java
index 1f760c0..0159564 100644
--- a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1111.java
+++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1111.java
@@ -57,7 +57,7 @@
apiLog.setStatus(99);
apiLog.setId(ContextUtil.getUUID());
try {
- List<Fz40SecCamera> list = fzzy40Sync1111Rep.listCamera(deptId);
+ List<Fz40SecCamera> list = fzzy40Sync1111Rep.listCamera(deptId, start, end);
if (null == list || list.isEmpty()) {
log.info("-------------娌℃湁鑾峰彇鍒扮洃鎺т俊鎭�------------------");
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