From d1b7f2eb67cd87edc4b5eb11def5acba07c75698 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期四, 21 十二月 2023 15:09:27 +0800 Subject: [PATCH] 根据上海新接口规则进行调整 --- src/main/java/com/fzzy/api/view/repository/Api1402Rep.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/Api1402Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1402Rep.java index bce906e..fce9bc7 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1402Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1402Rep.java @@ -1,10 +1,19 @@ package com.fzzy.api.view.repository; +import com.fzzy.api.entity.Api1401; import com.fzzy.api.entity.Api1402; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.JpaSpecificationExecutor; +import org.springframework.data.jpa.repository.Query; +import org.springframework.data.repository.query.Param; + +import java.util.Date; +import java.util.List; public interface Api1402Rep extends JpaRepository<Api1402, String>, JpaSpecificationExecutor<Api1402> { + @Query("from Api1402 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") + List<Api1402> findPushDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + } -- Gitblit v1.9.3