From 861705aac85f6c8a16e91d8f9f53df57a2986422 Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期二, 02 九月 2025 17:10:59 +0800
Subject: [PATCH] 2025-09-02改 * 生产实时数据，因da_t_wip_tracking表display_group='N/A',查不出数据 * 改为查 t_wip_DETAIL表
---
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