From 5652acfd578f66353f59f398f42c88da901e245e Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期五, 24 四月 2026 15:55:23 +0800
Subject: [PATCH] fix: 附件上传路径link,设备巡检附件去重

---
 src/main/java/com/ruoyi/sales/service/impl/CommonFileServiceImpl.java |   39 ++++++++++++++++++++++++++++++++++++++-
 1 files changed, 38 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/ruoyi/sales/service/impl/CommonFileServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/CommonFileServiceImpl.java
index 06bd40e..dfc054f 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/CommonFileServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/CommonFileServiceImpl.java
@@ -1,7 +1,11 @@
 package com.ruoyi.sales.service.impl;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.constant.Constants;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.framework.config.RuoYiConfig;
 import com.ruoyi.other.mapper.TempFileMapper;
 import com.ruoyi.other.pojo.TempFile;
 import com.ruoyi.sales.mapper.CommonFileMapper;
@@ -39,6 +43,21 @@
     @Value("${file.upload-dir}")
     private String uploadDir;
 
+    public List<CommonFile> getFileListByBusinessId(Long businessId,Integer type) {
+        return commonFileMapper.selectList(new LambdaQueryWrapper<CommonFile>().eq(CommonFile::getCommonId, businessId)
+                .eq(CommonFile::getType, type));
+    }
+
+    public void deleteByBusinessId(Long businessId,Integer type) {
+        commonFileMapper.delete(new LambdaQueryWrapper<CommonFile>().eq(CommonFile::getCommonId, businessId)
+                .eq(CommonFile::getType, type));
+    }
+
+    public void deleteByBusinessIds(List<Long> businessId,Integer type) {
+        commonFileMapper.delete(new LambdaQueryWrapper<CommonFile>().in(CommonFile::getCommonId, businessId)
+                .eq(CommonFile::getType, type));
+    }
+
 
     @Override
     public int deleteSalesLedgerByIds(Long[] ids) {
@@ -70,6 +89,7 @@
         commonFile.setCommonId(id);
         commonFile.setName(file.getOriginalFilename());
         commonFile.setUrl(tempFilePath.toString());
+        commonFile.setLink(buildAccessLink(tempFilePath));
         commonFile.setType(type);
         commonFileMapper.insert(commonFile);
         return commonFile;
@@ -117,7 +137,7 @@
             String formalFilename = businessId + "_" +
                     System.currentTimeMillis() + "_" +
                     UUID.randomUUID().toString().substring(0, 8) +
-                    (com.ruoyi.common.utils.StringUtils.hasText(fileExtension) ? "." + fileExtension : "");
+                    (StringUtils.hasText(fileExtension) ? "." + fileExtension : "");
 
             Path formalFilePath = formalDirPath.resolve(formalFilename);
 
@@ -139,6 +159,7 @@
                 fileRecord.setCommonId(businessId);
                 fileRecord.setName(originalFilename);
                 fileRecord.setUrl(formalFilePath.toString());
+                fileRecord.setLink(buildAccessLink(formalFilePath));
                 fileRecord.setCreateTime(LocalDateTime.now());
                 fileRecord.setType(tempFile.getType());
                 commonFileMapper.insert(fileRecord);
@@ -151,4 +172,20 @@
             }
         }
     }
+
+    private String buildAccessLink(Path formalFilePath) {
+        String normalizedPath = formalFilePath.toString().replace("\\", "/");
+        String profile = RuoYiConfig.getProfile();
+        String normalizedProfile = profile == null ? "" : profile.replace("\\", "/");
+
+        String relativePath = normalizedPath;
+        if (StringUtils.hasText(normalizedProfile) && normalizedPath.startsWith(normalizedProfile)) {
+            relativePath = normalizedPath.substring(normalizedProfile.length());
+        }
+        if (!relativePath.startsWith("/")) {
+            relativePath = "/" + relativePath;
+        }
+
+        return Constants.RESOURCE_PREFIX + relativePath;
+    }
 }

--
Gitblit v1.9.3