From 96f7af2f3bf9a36dd48e0e6bf4f8a8ca1e31ed7d Mon Sep 17 00:00:00 2001 From: vince <757871790@qq.com> Date: 星期三, 08 十一月 2023 17:49:56 +0800 Subject: [PATCH] Merge remote-tracking branch 'orgin/igds-api-gateway' into igds-api-gateway --- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1202Rep.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1202Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1202Rep.java index 95446b6..1c579e2 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1202Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1202Rep.java @@ -50,4 +50,8 @@ List<Fz40InoutRecord> listInoutRecord(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); + @Query("from Fz40InoutRecord where deptId=:deptId and (type=:type1 or type=:type2) and updateTime >=:start and updateTime <=:end order by id ") + List<Fz40InoutRecord> listInAndOutRecord(@Param("deptId") String deptId, @Param("type1") String type1, @Param("type2") String type2, @Param("start") Date start, @Param("end") Date end); + + } -- Gitblit v1.9.3