From dfcc9f5693c44fcc52a9b0b261ae4dce69bbdb8c Mon Sep 17 00:00:00 2001
From: 6c <420680616@qq.com>
Date: 星期五, 19 九月 2025 10:50:12 +0800
Subject: [PATCH] 请求历史特殊处理-若是多次维修导致报表库数据重复，那么按照主键取最新数据
---
product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java b/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
index 5d8e677..3ded758 100644
--- a/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
+++ b/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
@@ -43,6 +43,17 @@
@Resource
MesExternalService mesExternalService;
+
+ public void timingClearDataCenterLog(){
+// select uuid from product_sys_data_center_log a
+// where created_utc_datetime<=date(date_add(now(),interval -7 day)) and (result=1 or (deal_flag=1 and deal_result=1)) and type>1
+// union all
+// select a.uuid from product_sys_data_center_log a
+// join product_sys_data_center_log b on a.uuid=b.pre_step_uuid
+// where a.type=1 and b.type=2 and (b.result=1 or (b.deal_flag=1 and b.deal_result=1))
+// and b.created_utc_datetime<=date(date_add(now(),interval -7 day))
+ }
+
/**
* 鏃ュ織鍒楄〃
*
--
Gitblit v1.9.2