From 11430ae628f098654579811131abc522d679e870 Mon Sep 17 00:00:00 2001 From: czt <czt18638530771@163.com> Date: 星期一, 22 九月 2025 17:04:42 +0800 Subject: [PATCH] 上海对农接口调整-增加自动上传 --- src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1212Rep.java | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1212Rep.java b/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1212Rep.java new file mode 100644 index 0000000..56e7ff4 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1212Rep.java @@ -0,0 +1,29 @@ +package com.fzzy.async.fzzy61.repository; + +import com.fzzy.async.fzzy61.entity.Fz61InoutCustomer; +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; + +/** + * 绮璐攢-瀹㈡埛淇℃伅鏁版嵁鎺ュ彛鏁版嵁鑾峰彇 + */ +public interface Fzzy61Sync1212Rep extends JpaRepository<Fz61InoutCustomer, String> { + + /** + * 鏍规嵁淇℃伅鑾峰彇瀹㈡埛鍗曚綅淇℃伅 + * + * @return + */ + @Query("from Fz61InoutCustomer where deptId=:deptId order by id ") + List<Fz61InoutCustomer> listInoutCustomer(@Param("deptId") String deptId); + + @Query("from Fz61InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <=:end order by id ") + List<Fz61InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); + + @Query("from Fz61InoutCustomer where id=:id order by id ") + List<Fz61InoutCustomer> getDataById(@Param("id") String id); +} -- Gitblit v1.9.3