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/api/view/repository/Api1210Rep.java | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/Api1210Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1210Rep.java index 6cd45ab..7b87ed9 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1210Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1210Rep.java @@ -22,4 +22,18 @@ @Query("from Api1210 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") List<Api1210> findPushDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + + @Query("from Api1210 where lsxzzbdh=:lsxzzbdh ") + List<Api1210> getDataById(@Param("lsxzzbdh") String lsxzzbdh); + + + /** + * 鏍规嵁璐т綅浠g爜鍜屼笟鍔℃椂闂存煡璇㈡�ц川杞彉鍗曚俊鎭�(姝e簭) + * @param hwdm + * @param start + * @return + */ + @Query("from Api1210 where hwdm=:hwdm and hzrq >=:start order by zhgxsj ") + List<Api1210> findDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("start") Date start); + } -- Gitblit v1.9.3