From 029de836702607a95ccb0a69a74efcea52ddc451 Mon Sep 17 00:00:00 2001 From: czt <czt18638530771@163.com> Date: 星期四, 25 九月 2025 19:35:38 +0800 Subject: [PATCH] 上海对农数据接口调整2 --- src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1403Rep.java | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1403Rep.java b/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1403Rep.java new file mode 100644 index 0000000..416f3b6 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy61/repository/Fzzy61Sync1403Rep.java @@ -0,0 +1,36 @@ +package com.fzzy.async.fzzy61.repository; + +import com.fzzy.async.fzzy61.entity.Fz61InoutPlan; +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; + +/** + * 鏌ヨ杞崲璁″垝璇︾粏 + * + * @author czt + * @date 2023-10-30 09:55 + */ +public interface Fzzy61Sync1403Rep extends JpaRepository<Fz61InoutPlan, String> { + + /** + * + * @param start + * @param end + * @return + */ + @Query("from Fz61InoutPlan where type =:planType and createTime >=:start and createTime <:end order by createTime ") + List<Fz61InoutPlan> findDate(@Param("planType") String planType, @Param("start") Date start, @Param("end") Date end); + + /** + * + * @param start + * @param end + * @return + */ + @Query("from Fz61InoutPlan where deptId =:deptId and createTime >=:start and createTime <:end order by createTime ") + List<Fz61InoutPlan> findDateByTime(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); +} -- Gitblit v1.9.3