From 954480166aad6d24c9e9889906a0edf762f0da2a Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期一, 10 二月 2025 16:32:56 +0800
Subject: [PATCH] 优化库存同步
---
src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java | 15 +++++++++------
1 files changed, 9 insertions(+), 6 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 9fab138..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,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;
@@ -13,14 +14,16 @@
public interface Fzzy40Sync1212Rep extends JpaRepository<Fz40InoutCustomer, String> {
/**
- * 鏍规嵁淇℃伅鑾峰彇瀹㈡埛淇℃伅
+ * 鏍规嵁淇℃伅鑾峰彇瀹㈡埛鍗曚綅淇℃伅
*
- * @param start
- * @param end
* @return
*/
-// @Query("from Fz40InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ")
-// List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end);
- @Query("from Fz40InoutCustomer where deptId=:deptId order by updateTime ")
+ @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