From 90b950bfd7f8c8c4835edf5e8a1062d17d953032 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期二, 14 十月 2025 11:14:59 +0800
Subject: [PATCH] 宁夏轮换计划接口调整
---
src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 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 8b18944..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
@@ -43,4 +53,13 @@
@Query(value = "update ApiInfoData set czbz=:czbz ,data=:data where id=:id ")
int updateStatus(@Param("id") String id, @Param("data") String data, @Param("czbz") String czbz);
+ /**
+ * 鏍规嵁搴撳尯浠ｇ爜銆佹帴鍙ｇ紪鐮併�佹暟鎹甶d鏌ヨ
+ *
+ * @param inteId
+ * @return
+ */
+ @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