From 6fdbc495a0ea950a4adb4b70f2eef70138e298ec Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期四, 07 三月 2024 09:35:06 +0800 Subject: [PATCH] 优化往来单位信息同步,根据更新时间同步 --- src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1212.java | 4 ++-- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java | 5 +++++ 2 files changed, 7 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1212.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1212.java index 55d5309..ebfc1b8 100644 --- a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1212.java +++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1212.java @@ -54,7 +54,7 @@ apiLog.setStatus(99); apiLog.setId(ContextUtil.getUUID()); try { - List<Fz40InoutCustomer> list = fzzySync1212Rep.listInoutCustomer(deptId); + List<Fz40InoutCustomer> list = fzzySync1212Rep.listInoutCustomer(deptId, start, end); if (null == list || list.isEmpty()) { log.debug("-------------娌℃湁鑾峰彇鍒板鎴蜂俊鎭�------------------"); @@ -79,7 +79,7 @@ apiData.setKhlx(sysData.getKhlx()); apiData.setKhtyshxydmhsfzh(sysData.getKhbh()); apiData.setKhmc(sysData.getName()); - apiData.setFddbr(sysData.getFddbr()); + apiData.setFddbr(StringUtils.isEmpty(sysData.getFddbr()) ? "娉曚汉" :sysData.getFddbr()); apiData.setTxdz(StringUtils.isEmpty(sysData.getAddress()) ? "鍗曚綅鍦板潃" :sysData.getAddress()); apiData.setLxrxm(StringUtils.isEmpty(sysData.getContactUser()) ? sysData.getFddbr() :sysData.getContactUser()); diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java index f2042d9..0f56465 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java @@ -4,6 +4,8 @@ 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; /** @@ -19,6 +21,9 @@ @Query("from Fz40InoutCustomer where deptId=:deptId order by id ") List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId); + @Query("from Fz40InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <=:end order by id ") + List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); + @Query("from Fz40InoutCustomer where id=:id order by id ") List<Fz40InoutCustomer> getDataById(@Param("id") String id); } -- Gitblit v1.9.3