From 8bb6004ed19b69fff5b0ca70303c616bc71546e6 Mon Sep 17 00:00:00 2001 From: czt <czt18638530771@163.com> Date: 星期一, 13 十月 2025 15:46:45 +0800 Subject: [PATCH] 武汉黄陂军粮-质检报告共享接口同步及推送2 --- src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java | 17 ++++++++++++++--- 1 files changed, 14 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java index 30d012d..de37f4c 100644 --- a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java +++ b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java @@ -8,6 +8,7 @@ import org.springframework.data.repository.query.Param; import org.springframework.transaction.annotation.Transactional; +import java.util.Date; import java.util.List; public interface ApiInfoDataRep extends JpaRepository<ApiInfoData, String>, JpaSpecificationExecutor<ApiInfoData> { @@ -32,6 +33,15 @@ List<ApiInfoData> getDataByInteId(@Param("inteId") String inteId); /** + * 鏍规嵁鎺ュ彛缂栫爜鏌ヨ鏁版嵁 + * + * @param inteId + * @return + */ + @Query("from ApiInfoData where inteId=:inteId and updateTime >=:start and updateTime <:end order by updateTime") + List<ApiInfoData> getDataByInteId(@Param("inteId") String inteId, @Param("start") Date start, @Param("end") Date end); + + /** * 鏍规嵁琛ㄥ崟涓婚敭鏇存柊鎿嶄綔鏍囧織鐘舵�� * * @param id 涓婚敭ID @@ -44,11 +54,12 @@ int updateStatus(@Param("id") String id, @Param("data") String data, @Param("czbz") String czbz); /** - * 鏍规嵁鎺ュ彛缂栫爜鍜屾暟鎹唴瀹笽D鏌ヨ鏁版嵁 + * 鏍规嵁搴撳尯浠g爜銆佹帴鍙g紪鐮併�佹暟鎹甶d鏌ヨ * * @param inteId * @return */ - @Query("from ApiInfoData where inteId=:inteId and dataId=:dataId ") - List<ApiInfoData> getDataByInteAndData(@Param("inteId") String inteId, @Param("dataId") String dataId); + @Query("from ApiInfoData where inteId=:inteId and dataId=:dataId and kqdm=:kqdm") + List<ApiInfoData> getDataByInteAndData(@Param("inteId") String inteId, @Param("dataId") String dataId, @Param("kqdm") String kqdm); + } \ No newline at end of file -- Gitblit v1.9.3