From 57ec72c5046cbd35d276cdc0621aac19484c5acb Mon Sep 17 00:00:00 2001
From: 杜洪波 <1074825718@qq.com>
Date: 星期五, 13 三月 2026 10:07:54 +0800
Subject: [PATCH] 文档管理历史版本BUG提交
---
src/main/java/com/product/file/service/DocumentDirectoryService.java | 8 +++-----
1 files changed, 3 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/product/file/service/DocumentDirectoryService.java b/src/main/java/com/product/file/service/DocumentDirectoryService.java
index 500400f..c90cce3 100644
--- a/src/main/java/com/product/file/service/DocumentDirectoryService.java
+++ b/src/main/java/com/product/file/service/DocumentDirectoryService.java
@@ -3,7 +3,6 @@
import cn.hutool.core.collection.CollectionUtil;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
-import com.beust.jcommander.internal.Lists;
import com.beust.jcommander.internal.Sets;
import com.product.common.collect.ListUtils;
import com.product.core.cache.DataPoolCacheImpl;
@@ -88,11 +87,10 @@
// 鍒锋柊code
StringBuilder sql = new StringBuilder();
sql.append("update product_oa_directory ");
- sql.append("set tricode=concat(replace(substring(tricode,1,locate(?,tricode)+length(?)),?,?),substring(tricode,locate(?,tricode)+length(?)+1)), ");
- sql.append("tricode_parent=concat(replace(substring(tricode_parent,1,locate(?,tricode_parent)+length(?)),?,?),substring(tricode_parent,locate(?,tricode_parent)+length(?)+1)) ");
+ sql.append("set tricode=concat(?, SUBSTRING(tricode, LENGTH(?) + 1)), ");
+ sql.append("tricode_parent=concat(?, SUBSTRING(tricode_parent, LENGTH(?) + 1)) ");
sql.append("where tricode like ? ");
- baseDao.executeUpdate(sql.toString(), new Object[]{originTricode, originTricode, originTricode, tricode, originTricode, originTricode,
- originTricode, originTricode, originTricode, tricode, originTricode, originTricode, originTricode + "-%"});
+ baseDao.executeUpdate(sql.toString(), new Object[]{tricode, originTricode, tricode, originTricode, originTricode + "-%"});
// 鍒锋柊灞傜骇
StringBuilder sb = new StringBuilder();
sb.append("UPDATE product_oa_directory \n");
--
Gitblit v1.9.2