From 7c04452feb8b59b022e815ff8c7697905591a312 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期六, 03 二月 2024 10:27:03 +0800
Subject: [PATCH] 优化质检数据同步
---
src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1310Rep.java | 4 ++--
src/main/java/com/fzzy/api/view/repository/Api1310Rep.java | 3 +++
src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1310.java | 5 +++--
3 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/fzzy/api/view/repository/Api1310Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1310Rep.java
index 0ef3998..6e72bea 100644
--- a/src/main/java/com/fzzy/api/view/repository/Api1310Rep.java
+++ b/src/main/java/com/fzzy/api/view/repository/Api1310Rep.java
@@ -26,4 +26,7 @@
@Query("from Api1310 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ")
List<Api1310> findPushDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end);
+
+ @Query("from Api1310 where bizId=:bizId ")
+ List<Api1310> getDataByBizId(@Param("bizId") String bizId);
}
diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1310.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1310.java
index d65df04..bafac56 100644
--- a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1310.java
+++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1310.java
@@ -70,7 +70,7 @@
apiLog.setStatus(99);
apiLog.setId(ContextUtil.getUUID());
try {
- List<Fz40Quality> list = fzzySync1310Rep.findDateByTime(start, end);
+ List<Fz40Quality> list = fzzySync1310Rep.findDateByTime(deptId, start, end);
if (null == list || list.isEmpty()) {
return;
}
@@ -155,8 +155,9 @@
api1310.setYpbh(fz40Quality.getYpbh());
api1310.setQydbh(fz40Quality.getQydbh());
api1310.setZhgxsj(new Date());
+ api1310.setBizId(fz40Quality.getId());
- api1310List = api1310Rep.getDataByZjbgdh(api1310.getZjbgdh());
+ api1310List = api1310Rep.getDataByBizId(api1310.getBizId());
if (null == api1310List || api1310List.isEmpty()) {
api1310.setCzbz(Constant.CZBZ_I);
} else {
diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1310Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1310Rep.java
index 4533f23..4b0f7f9 100644
--- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1310Rep.java
+++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1310Rep.java
@@ -22,6 +22,6 @@
* @param end
* @return
*/
- @Query("from Fz40Quality where updateTime >=:start and updateTime <:end order by updateTime ")
- List<Fz40Quality> findDateByTime(@Param("start") Date start, @Param("end") Date end);
+ @Query("from Fz40Quality where deptId =:deptId and updateTime >=:start and updateTime <:end order by updateTime ")
+ List<Fz40Quality> findDateByTime(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end);
}
--
Gitblit v1.9.3