From cdcc529ce5fb9aa0dd1dea5bb2a620fc09b7d25c Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期六, 08 十一月 2025 20:03:56 +0800
Subject: [PATCH] feat: 上传附件

---
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysTaskServiceImpl.java |  316 +++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 295 insertions(+), 21 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysTaskServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysTaskServiceImpl.java
index 499b06f..593f13c 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysTaskServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysTaskServiceImpl.java
@@ -1,14 +1,22 @@
 package com.ruoyi.system.service.impl;
 
 import java.math.BigDecimal;
+import java.util.Collections;
 import java.util.Date;
 import java.util.List;
 import java.util.ArrayList;
 import java.util.stream.Collectors;
 import java.io.File;
+import java.io.FileOutputStream;
 import java.io.IOException;
+import java.io.InputStream;
+import java.net.HttpURLConnection;
+import java.net.URL;
 
+import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.system.mapper.*;
 import com.ruoyi.system.utils.TaskCodeGenerator;
+import com.ruoyi.common.config.ImageUrlConfig;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -31,18 +39,17 @@
 import com.ruoyi.system.domain.vo.TaskUpdateVO;
 import com.ruoyi.system.domain.vo.TaskStatisticsVO;
 import com.ruoyi.system.domain.enums.TaskStatus;
-import com.ruoyi.system.mapper.SysTaskMapper;
-import com.ruoyi.system.mapper.SysTaskVehicleMapper;
-import com.ruoyi.system.mapper.SysTaskAttachmentMapper;
-import com.ruoyi.system.mapper.SysTaskLogMapper;
-import com.ruoyi.system.mapper.SysTaskEmergencyMapper;
-import com.ruoyi.system.mapper.SysTaskWelfareMapper;
-import com.ruoyi.system.mapper.SysTaskAssigneeMapper;
-import com.ruoyi.system.mapper.VehicleInfoMapper;
 import com.ruoyi.system.domain.VehicleInfo;
 import com.ruoyi.system.service.ISysTaskService;
 import com.ruoyi.system.service.ILegacySystemSyncService;
+import com.ruoyi.system.service.ITaskAttachmentSyncService;
+import com.ruoyi.system.event.TaskCreatedEvent;
+import com.ruoyi.system.event.TaskAssignedEvent;
+import com.ruoyi.system.event.TaskStatusChangedEvent;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.ApplicationEventPublisher;
 
 /**
  * 浠诲姟绠$悊Service涓氬姟灞傚鐞�
@@ -52,6 +59,8 @@
  */
 @Service
 public class SysTaskServiceImpl implements ISysTaskService {
+    
+    private static final Logger log = LoggerFactory.getLogger(SysTaskServiceImpl.class);
     
     @Autowired
     private SysTaskMapper sysTaskMapper;
@@ -79,6 +88,18 @@
 
     @Autowired(required = false)
     private ILegacySystemSyncService legacySystemSyncService;
+    
+    @Autowired
+    private ApplicationEventPublisher eventPublisher;
+    
+    @Autowired
+    private ImageUrlConfig imageUrlConfig;
+    
+    @Autowired(required = false)
+    private ITaskAttachmentSyncService taskAttachmentSyncService;
+
+    @Autowired
+    private SysUserMapper sysUserMapper;
 
     /**
      * 鏌ヨ浠诲姟绠$悊
@@ -229,6 +250,38 @@
                          "浠诲姟绫诲瀷锛�" + createVO.getTaskType(), SecurityUtils.getUserId(), SecurityUtils.getUsername());
         }
         
+        // 鍙戝竷浠诲姟鍒涘缓浜嬩欢
+        if (result > 0) {
+            eventPublisher.publishEvent(new TaskCreatedEvent(
+                this,
+                task.getTaskId(),
+                task.getTaskCode(),
+                task.getTaskType(),
+                task.getCreatorId(),
+                SecurityUtils.getUsername()
+            ));
+        }
+        
+        // 鍙戝竷浠诲姟鍒嗛厤浜嬩欢
+        if (result > 0 && createVO.getAssignees() != null && !createVO.getAssignees().isEmpty()) {
+            List<Long> assigneeIds = createVO.getAssignees().stream()
+                .map(assignee -> assignee.getUserId())
+                .collect(Collectors.toList());
+            List<String> assigneeNames = createVO.getAssignees().stream()
+                .map(assignee -> assignee.getUserName())
+                .collect(Collectors.toList());
+            
+            eventPublisher.publishEvent(new TaskAssignedEvent(
+                this,
+                task.getTaskId(),
+                task.getTaskCode(),
+                assigneeIds,
+                assigneeNames,
+                SecurityUtils.getUserId(),
+                SecurityUtils.getUsername()
+            ));
+        }
+        
         // 寮傛鍚屾鎬ユ晳杞繍浠诲姟鍒版棫绯荤粺
         if (result > 0 && "EMERGENCY_TRANSFER".equals(createVO.getTaskType()) && legacySystemSyncService != null) {
             final Long finalTaskId = task.getTaskId();
@@ -320,19 +373,40 @@
     @Override
     @Transactional
     public int assignTask(Long taskId, Long assigneeId, String remark) {
-        SysTask task = new SysTask();
-        task.setTaskId(taskId);
-        task.setAssigneeId(assigneeId);
-        task.setUpdateBy(SecurityUtils.getUsername());
-        task.setUpdateTime(DateUtils.getNowDate());
+        SysTask task = sysTaskMapper.selectSysTaskByTaskId(taskId);
+        if (task == null) {
+            throw new RuntimeException("浠诲姟涓嶅瓨鍦�");
+        }
         
-        int result = sysTaskMapper.assignTask(task);
+        SysTask updateTask = new SysTask();
+        updateTask.setTaskId(taskId);
+        updateTask.setAssigneeId(assigneeId);
+        updateTask.setUpdateBy(SecurityUtils.getUsername());
+        updateTask.setUpdateTime(DateUtils.getNowDate());
+        
+        int result = sysTaskMapper.assignTask(updateTask);
         
         // 璁板綍鎿嶄綔鏃ュ織
         if (result > 0) {
             recordTaskLog(taskId, "ASSIGN", "鍒嗛厤浠诲姟", null, 
                          "鍒嗛厤缁欑敤鎴稩D锛�" + assigneeId + "锛屽娉細" + remark, 
                          SecurityUtils.getUserId(), SecurityUtils.getUsername());
+        }
+        
+        // 鍙戝竷浠诲姟鍒嗛厤浜嬩欢
+        if (result > 0) {
+            List<Long> assigneeIds = new ArrayList<>();
+            assigneeIds.add(assigneeId);
+            
+            eventPublisher.publishEvent(new TaskAssignedEvent(
+                this,
+                task.getTaskId(),
+                task.getTaskCode(),
+                assigneeIds,
+                null, // 濮撳悕鍒楄〃鍦ㄧ洃鍚櫒涓煡璇�
+                SecurityUtils.getUserId(),
+                SecurityUtils.getUsername()
+            ));
         }
         
         return result;
@@ -404,6 +478,30 @@
                          locationLog);
         }
         
+        // 鍙戝竷浠诲姟鐘舵�佸彉鏇翠簨浠�
+        if (result > 0) {
+            // 鏌ヨ浠诲姟鐨勬墍鏈夋墽琛屼汉
+            List<SysTaskAssignee> assignees = sysTaskAssigneeMapper.selectSysTaskAssigneeByTaskId(taskId);
+            List<Long> assigneeIds = null;
+            if (assignees != null && !assignees.isEmpty()) {
+                assigneeIds = assignees.stream()
+                    .map(SysTaskAssignee::getUserId)
+                    .collect(Collectors.toList());
+            }
+            
+            eventPublisher.publishEvent(new TaskStatusChangedEvent(
+                this,
+                oldTask.getTaskId(),
+                oldTask.getTaskCode(),
+                oldTaskStatus.getCode(),
+                newStatus.getCode(),
+                oldTaskStatus.getInfo(),
+                newStatus.getInfo(),
+                assigneeIds,
+                oldTask.getCreatorId()
+            ));
+        }
+        
         return result;
     }
 
@@ -412,37 +510,145 @@
      * 
      * @param taskId 浠诲姟ID
      * @param file 鏂囦欢
+     * @param category 闄勪欢鍒嗙被
      * @return 缁撴灉
      */
     @Override
     @Transactional
-    public int uploadAttachment(Long taskId, MultipartFile file) {
+    public Long uploadAttachment(Long taskId, MultipartFile file, String category) {
         try {
-            // 涓婁紶鏂囦欢
+            // 涓婁紶鏂囦欢锛岃繑鍥炵浉瀵硅矾寰勶紙濡傦細/task/2025/01/15/xxx.jpg锛�
             String fileName = FileUploadUtils.upload("/task", file);
-            String filePath = FileUploadUtils.getDefaultBaseDir() + fileName;
             
             SysTaskAttachment attachment = new SysTaskAttachment();
             attachment.setTaskId(taskId);
             attachment.setFileName(file.getOriginalFilename());
-            attachment.setFilePath(filePath);
+            // 淇濆瓨鐩稿璺緞锛屼笉鍖呭惈 baseDir
+            attachment.setFilePath(fileName);
             attachment.setFileSize(file.getSize());
             attachment.setFileType(getFileType(file.getOriginalFilename()));
+            attachment.setAttachmentCategory(category);
             attachment.setUploadTime(DateUtils.getNowDate());
             attachment.setUploadBy(SecurityUtils.getUsername());
             
-            int result = sysTaskAttachmentMapper.insertSysTaskAttachment(attachment);
+            Long result = sysTaskAttachmentMapper.insertSysTaskAttachment(attachment);
             
             // 璁板綍鎿嶄綔鏃ュ織
             if (result > 0) {
+                String categoryDesc = getCategoryDesc(category);
                 recordTaskLog(taskId, "UPDATE", "涓婁紶闄勪欢", null, 
-                             "涓婁紶鏂囦欢锛�" + file.getOriginalFilename(), 
+                             "涓婁紶鏂囦欢锛�" + file.getOriginalFilename() + "(鍒嗙被锛�" + categoryDesc + ")", 
                              SecurityUtils.getUserId(), SecurityUtils.getUsername());
+                
+
             }
             
             return result;
         } catch (IOException e) {
             throw new RuntimeException("鏂囦欢涓婁紶澶辫触锛�" + e.getMessage());
+        }
+    }
+    
+    /**
+     * 浠庡井淇ediaId涓婁紶浠诲姟闄勪欢
+     * 
+     * @param taskId 浠诲姟ID
+     * @param accessToken 寰俊AccessToken
+     * @param mediaId 寰俊mediaId
+     * @param category 闄勪欢鍒嗙被
+     * @return 杩斿洖闄勪欢ID
+     */
+    @Override
+    @Transactional
+    public Long uploadAttachmentFromWechat(Long taskId, String accessToken, String mediaId, String category) {
+        try {
+            // 浠庡井淇℃湇鍔″櫒涓嬭浇鏂囦欢
+            String wechatUrl = String.format(
+                "https://api.weixin.qq.com/cgi-bin/media/get?access_token=%s&media_id=%s",
+                accessToken, mediaId
+            );
+            
+            byte[] fileBytes = downloadFromUrl(wechatUrl);
+            if (fileBytes == null || fileBytes.length == 0) {
+                throw new RuntimeException("浠庡井淇′笅杞芥枃浠跺け璐�");
+            }
+            
+            // 鐢熸垚鏂囦欢鍚嶏紙浣跨敤mediaId浣滀负鏂囦欢鍚嶇殑涓�閮ㄥ垎锛�
+            String fileName = "wx_" + mediaId.substring(0, Math.min(20, mediaId.length())) + "_" + System.currentTimeMillis() + ".jpg";
+            
+            // 淇濆瓨鍒版湰鍦�
+            String baseDir = FileUploadUtils.getDefaultBaseDir();
+            String datePath = DateUtils.datePath();
+            String uploadDir = baseDir + "/task/" + datePath;
+            
+            // 鍒涘缓鐩綍
+            File uploadPath = new File(uploadDir);
+            if (!uploadPath.exists()) {
+                uploadPath.mkdirs();
+            }
+            
+            // 淇濆瓨鏂囦欢
+            String filePath = uploadDir + "/" + fileName;
+            File file = new File(filePath);
+            try (FileOutputStream fos = new FileOutputStream(file)) {
+                fos.write(fileBytes);
+            }
+            
+            // 鐢熸垚鐩稿璺緞锛堜笉鍖呭惈baseDir锛�
+            String relativeFilePath = "/task/" + datePath + "/" + fileName;
+            
+            // 淇濆瓨闄勪欢璁板綍
+            SysTaskAttachment attachment = new SysTaskAttachment();
+            attachment.setTaskId(taskId);
+            attachment.setFileName(fileName);
+            // 淇濆瓨鐩稿璺緞
+            attachment.setFilePath(relativeFilePath);
+            attachment.setFileSize((long) fileBytes.length);
+            attachment.setFileType("jpg");
+            attachment.setAttachmentCategory(category);
+            attachment.setUploadTime(DateUtils.getNowDate());
+            attachment.setUploadBy(SecurityUtils.getUsername());
+            
+            Long result = sysTaskAttachmentMapper.insertSysTaskAttachment(attachment);
+            
+            // 璁板綍鎿嶄綔鏃ュ織
+            if (result > 0) {
+                String categoryDesc = getCategoryDesc(category);
+                recordTaskLog(taskId, "UPDATE", "涓婁紶闄勪欢", null, 
+                             "閫氳繃寰俊涓婁紶鏂囦欢锛�" + fileName + "(鍒嗙被锛�" + categoryDesc + ")", 
+                             SecurityUtils.getUserId(), SecurityUtils.getUsername());
+                
+
+            }
+            
+            return attachment.getAttachmentId();
+        } catch (Exception e) {
+            throw new RuntimeException("浠庡井淇′笂浼犳枃浠跺け璐ワ細" + e.getMessage());
+        }
+    }
+    
+    /**
+     * 浠� URL 涓嬭浇鏂囦欢
+     */
+    private byte[] downloadFromUrl(String fileUrl) throws IOException {
+        URL url = new URL(fileUrl);
+        HttpURLConnection connection = (HttpURLConnection) url.openConnection();
+        connection.setRequestMethod("GET");
+        connection.setConnectTimeout(10000);
+        connection.setReadTimeout(30000);
+        
+        try (InputStream inputStream = connection.getInputStream()) {
+            byte[] buffer = new byte[4096];
+            int bytesRead;
+            java.io.ByteArrayOutputStream outputStream = new java.io.ByteArrayOutputStream();
+            
+            while ((bytesRead = inputStream.read(buffer)) != -1) {
+                outputStream.write(buffer, 0, bytesRead);
+            }
+            
+            return outputStream.toByteArray();
+        } finally {
+            connection.disconnect();
         }
     }
 
@@ -477,6 +683,27 @@
         }
         
         return result;
+    }
+    
+    /**
+     * 鏍规嵁ID鑾峰彇闄勪欢璇︽儏
+     * 
+     * @param attachmentId 闄勪欢ID
+     * @return 闄勪欢璇︽儏
+     */
+    @Override
+    public SysTaskAttachment getAttachmentById(Long attachmentId) {
+        SysTaskAttachment attachment = sysTaskAttachmentMapper.selectSysTaskAttachmentByAttachmentId(attachmentId);
+        if (attachment != null) {
+            // 鎷兼帴瀹屾暣URL
+            buildAttachmentUrl(attachment);
+        }
+        return attachment;
+    }
+
+    @Override
+    public List<SysTaskAttachment> getAttachmentsByTaskId(Long taskId) {
+        return sysTaskAttachmentMapper.selectSysTaskAttachmentByTaskId(taskId);
     }
 
     /**
@@ -610,6 +837,7 @@
             VehicleInfo queryParam = new VehicleInfo();
             queryParam.setStatus("0"); // 0琛ㄧず姝e父鐘舵��
             // 涓嶈缃甦eptId锛屾煡璇㈡墍鏈夐儴闂ㄧ殑杞﹁締
+            queryParam.setDeptId(deptId);
             
             List<VehicleInfo> vehicles = vehicleInfoMapper.selectVehicleInfoList(queryParam);
             
@@ -676,7 +904,12 @@
             // 鏌ヨ鍏宠仈杞﹁締
             task.setAssignedVehicles(sysTaskVehicleMapper.selectSysTaskVehicleByTaskId(taskId));
             // 鏌ヨ闄勪欢
-            task.setAttachments(sysTaskAttachmentMapper.selectSysTaskAttachmentByTaskId(taskId));
+            List<SysTaskAttachment> attachments = sysTaskAttachmentMapper.selectSysTaskAttachmentByTaskId(taskId);
+            // 涓烘瘡涓檮浠舵嫾鎺ュ畬鏁碪RL
+            if (attachments != null && !attachments.isEmpty()) {
+                attachments.forEach(this::buildAttachmentUrl);
+            }
+            task.setAttachments(attachments);
             // 鏌ヨ鎿嶄綔鏃ュ織
             task.setOperationLogs(sysTaskLogMapper.selectSysTaskLogByTaskId(taskId));
             // 鍔犺浇鎬ユ晳杞繍鎵╁睍淇℃伅
@@ -970,4 +1203,45 @@
         
         sysTaskWelfareMapper.insertSysTaskWelfare(welfareInfo);
     }
+    
+    /**
+     * 鑾峰彇闄勪欢鍒嗙被鎻忚堪
+     * 
+     * @param category 闄勪欢鍒嗙被浠g爜
+     * @return 鍒嗙被鎻忚堪
+     */
+    private String getCategoryDesc(String category) {
+        if (category == null || category.isEmpty()) {
+            return "鏈垎绫�";
+        }
+        switch (category) {
+            case "1": return "鐭ユ儏鍚屾剰涔�";
+            case "2": return "鐥呬汉璧勬枡";
+            case "3": return "鎿嶄綔璁板綍";
+            case "4": return "鍑鸿溅鍓�";
+            case "5": return "鍑鸿溅鍚�";
+            case "6": return "绯诲畨鍏ㄥ甫";
+            default: return "鍏朵粬";
+        }
+    }
+    
+    /**
+     * 鏋勫缓闄勪欢鐨勫畬鏁碪RL
+     * 
+     * @param attachment 闄勪欢瀵硅薄
+     */
+    private void buildAttachmentUrl(SysTaskAttachment attachment) {
+        if (attachment != null && StringUtils.isNotEmpty(attachment.getFilePath())) {
+            String imageUrl = imageUrlConfig.getImageUrl();
+            if (StringUtils.isNotEmpty(imageUrl)) {
+                // 鎷兼帴瀹屾暣URL锛氬煙鍚� + 鐩稿璺緞
+                attachment.setFileUrl(imageUrl + attachment.getFilePath());
+            } else {
+                // 濡傛灉鏈厤缃煙鍚嶏紝鐩存帴浣跨敤鐩稿璺緞
+                attachment.setFileUrl(attachment.getFilePath());
+            }
+        }
+    }
+    
+   
 }

--
Gitblit v1.9.1