From 6fdbc495a0ea950a4adb4b70f2eef70138e298ec Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期四, 07 三月 2024 09:35:06 +0800
Subject: [PATCH] 优化往来单位信息同步，根据更新时间同步
---
src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java
index f2042d9..0f56465 100644
--- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java
+++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java
@@ -4,6 +4,8 @@
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;
/**
@@ -19,6 +21,9 @@
@Query("from Fz40InoutCustomer where deptId=:deptId order by id ")
List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId);
+ @Query("from Fz40InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <=:end order by id ")
+ List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end);
+
@Query("from Fz40InoutCustomer where id=:id order by id ")
List<Fz40InoutCustomer> getDataById(@Param("id") String id);
}
--
Gitblit v1.9.3