From aba4b755a3afc61a07538e4bfd8217979919907d Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期一, 08 九月 2025 11:42:05 +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