From bccb2a6b67d31fd9bb846b2bc605a8b90c228033 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期五, 24 五月 2024 18:18:41 +0800
Subject: [PATCH] 优化船运数据同步

---
 src/main/java/com/fzzy/api/view/repository/Api1202Rep.java |    8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
index f64cdcc..d1c0de7 100644
--- a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
+++ b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
@@ -44,4 +44,12 @@
 
     @Query("from Api1202 where rkjsdh=:rkjsdh ")
     List<Api1202> getDataByRkjsdh(@Param("rkjsdh") String rkjsdh);
+
+    /**
+     * 鏍规嵁璐т綅浠g爜鍜屼笟鍔℃棩鏈燂紝鍊掑簭鏌ヨ
+     * @param hwdm
+     * @return
+     */
+    @Query("from Api1202 where hwdm=:hwdm and ywrq <=:keyTime order by ywrq desc")
+    List<Api1202> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
 }

--
Gitblit v1.9.3