From 5d34bdd3c426bb2ca5f6627424ae67984f745603 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期三, 21 十月 2026 18:28:59 +0800
Subject: [PATCH] feat: 新增资产/用车/采购模块,完善课题、会员、财务与企微功能

---
 yudao-module-research/src/main/java/cn/iocoder/yudao/module/research/service/application/ResearchApplicationServiceImpl.java |  185 ++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 185 insertions(+), 0 deletions(-)

diff --git a/yudao-module-research/src/main/java/cn/iocoder/yudao/module/research/service/application/ResearchApplicationServiceImpl.java b/yudao-module-research/src/main/java/cn/iocoder/yudao/module/research/service/application/ResearchApplicationServiceImpl.java
index 655f24a..00b1de9 100644
--- a/yudao-module-research/src/main/java/cn/iocoder/yudao/module/research/service/application/ResearchApplicationServiceImpl.java
+++ b/yudao-module-research/src/main/java/cn/iocoder/yudao/module/research/service/application/ResearchApplicationServiceImpl.java
@@ -7,6 +7,10 @@
 import cn.iocoder.yudao.framework.common.enums.CommonStatusEnum;
 import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.archive.api.document.ArchiveDocumentApi;
+import cn.iocoder.yudao.module.archive.api.document.dto.ArchiveDocumentCreateReqDTO;
+import cn.iocoder.yudao.module.archive.api.document.dto.ArchiveDocumentRespDTO;
 import cn.iocoder.yudao.module.bpm.api.task.BpmProcessInstanceApi;
 import cn.iocoder.yudao.module.bpm.api.task.dto.BpmProcessInstanceCreateReqDTO;
 import cn.iocoder.yudao.module.bpm.dal.dataobject.definition.BpmCategoryDO;
@@ -15,15 +19,21 @@
 import cn.iocoder.yudao.module.bpm.service.definition.BpmProcessDefinitionService;
 import cn.iocoder.yudao.module.research.controller.admin.application.vo.ResearchApplicationPageReqVO;
 import cn.iocoder.yudao.module.research.controller.admin.application.vo.ResearchApplicationSaveReqVO;
+import cn.iocoder.yudao.module.research.controller.admin.application.vo.member.ResearchApplicationMemberSaveReqVO;
+import cn.iocoder.yudao.module.research.controller.admin.application.vo.member.ResearchApplicationMemberStatisticsReqVO;
+import cn.iocoder.yudao.module.research.controller.admin.application.vo.member.ResearchApplicationMemberStatisticsRespVO;
 import cn.iocoder.yudao.module.research.dal.dataobject.application.ResearchApplicationDO;
+import cn.iocoder.yudao.module.research.dal.dataobject.application.ResearchApplicationMemberDO;
 import cn.iocoder.yudao.module.research.dal.dataobject.guideline.ResearchGuidelineDO;
 import cn.iocoder.yudao.module.research.dal.mysql.application.ResearchApplicationMapper;
+import cn.iocoder.yudao.module.research.dal.mysql.application.ResearchApplicationMemberMapper;
 import cn.iocoder.yudao.module.research.dal.redis.ResearchNoRedisDAO;
 import cn.iocoder.yudao.module.research.enums.ResearchApplicationStatusEnum;
 import cn.iocoder.yudao.module.research.enums.ResearchGuidelineCategoryEnum;
 import cn.iocoder.yudao.module.research.enums.ResearchGuidelineStatusEnum;
 import cn.iocoder.yudao.module.research.service.guideline.ResearchGuidelineService;
 import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
+import cn.iocoder.yudao.module.system.api.storage.dto.StorageBlobRespDTO;
 import cn.iocoder.yudao.module.system.controller.admin.notice.vo.NoticeSaveReqVO;
 import cn.iocoder.yudao.module.system.dal.dataobject.notice.NoticeDO;
 import cn.iocoder.yudao.module.system.service.notice.NoticeService;
@@ -40,6 +50,7 @@
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
 import java.util.*;
+import java.util.stream.Collectors;
 
 import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
 import static cn.iocoder.yudao.framework.common.util.date.DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND;
@@ -54,6 +65,15 @@
     private static final String APPLICATION_APPROVE_CATEGORY_CODE = "research_topic_approve";
     public static final String APPLICATION_RECORD_TYPE = "research_application";
 
+    /** 褰掓。鏉ユ簮绫诲瀷锛�2-璇鹃锛堝搴� archive 妯″潡 source_type锛� */
+    private static final Integer ARCHIVE_SOURCE_TYPE_RESEARCH = 2;
+
+    /** 褰掓。瀵嗙骇锛�2-鍐呴儴 */
+    private static final Integer ARCHIVE_SECRET_LEVEL_INTERNAL = 2;
+
+    /** 璇鹃妗f鍒嗙被缂栫爜锛堝搴� archive_category.code锛� */
+    private static final String ARCHIVE_CATEGORY_CODE_RESEARCH = "research";
+
     /** 绔嬮」閫氱煡浣跨敤銆屽叕鍛娿�嶇被鍨嬶紙system_notice_type: 1-閫氱煡 2-鍏憡锛� */
     private static final Integer NOTICE_TYPE_ANNOUNCEMENT = 2;
 
@@ -62,6 +82,12 @@
 
     @Resource
     private ResearchApplicationMapper applicationMapper;
+
+    @Resource
+    private ResearchApplicationMemberMapper memberMapper;
+
+    @Resource
+    private ArchiveDocumentApi archiveDocumentApi;
 
     @Resource
     private ResearchNoRedisDAO noRedisDAO;
@@ -108,6 +134,7 @@
                 .setStatus(ResearchApplicationStatusEnum.DRAFT.getStatus())
                 .setBudgetAmount(in.getBudgetAmount() == null ? BigDecimal.ZERO : in.getBudgetAmount()));
         applicationMapper.insert(application);
+        saveMembers(application.getId(), createReqVO.getMembers());
 
         storageAttachmentApi.bindAttachments("file", APPLICATION_RECORD_TYPE,
                 application.getId(), createReqVO.getBlobIds());
@@ -130,6 +157,10 @@
         updateObj.setCategory(guideline.getCategory());
         applicationMapper.updateById(updateObj);
 
+        // 鎴愬憳瀛愯〃锛氬厛鍒犲悗澧烇紝鍏ㄩ噺瑕嗙洊
+        memberMapper.deleteByApplicationId(updateReqVO.getId());
+        saveMembers(updateReqVO.getId(), updateReqVO.getMembers());
+
         storageAttachmentApi.updateAttachments("file", APPLICATION_RECORD_TYPE,
                 updateReqVO.getId(), updateReqVO.getBlobIds());
     }
@@ -143,6 +174,7 @@
                     application.getNo(), ResearchApplicationStatusEnum.nameOf(application.getStatus()));
         }
 
+        memberMapper.deleteByApplicationId(id);
         applicationMapper.deleteById(id);
         storageAttachmentApi.deleteAttachmentsByRecord(APPLICATION_RECORD_TYPE, id);
     }
@@ -150,6 +182,116 @@
     @Override
     public ResearchApplicationDO getApplication(Long id) {
         return applicationMapper.selectById(id);
+    }
+
+    @Override
+    public List<ResearchApplicationMemberDO> getMemberListByApplicationId(Long applicationId) {
+        return memberMapper.selectListByApplicationId(applicationId);
+    }
+
+    @Override
+    public List<ResearchApplicationMemberStatisticsRespVO> getMemberStatistics(ResearchApplicationMemberStatisticsReqVO reqVO) {
+        // 1. 鎸夌姸鎬佽繃婊ょ敵鎶ュ崟
+        List<ResearchApplicationDO> applications = applicationMapper.selectList(
+                new LambdaQueryWrapperX<ResearchApplicationDO>()
+                        .eqIfPresent(ResearchApplicationDO::getStatus, reqVO.getStatus()));
+        if (CollUtil.isEmpty(applications)) {
+            return Collections.emptyList();
+        }
+        Map<Long, ResearchApplicationDO> applicationMap = applications.stream()
+                .collect(Collectors.toMap(ResearchApplicationDO::getId, application -> application, (a, b) -> a));
+
+        // 2. 鎴愬憳瀛愯〃鑱氬悎锛氬鍚� + 鐢佃瘽 + 鍗曚綅 鐩稿悓瑙嗕负鍚屼竴鎴愬憳
+        String keyword = StrUtil.trimToNull(reqVO.getKeyword());
+        Map<String, ResearchApplicationMemberStatisticsRespVO> resultMap = new LinkedHashMap<>();
+        Map<String, Set<String>> roleMap = new HashMap<>();
+        Map<String, Set<Long>> projectIdMap = new HashMap<>();
+        Map<String, Set<String>> projectTitleMap = new HashMap<>();
+        for (ResearchApplicationMemberDO member : memberMapper.selectList()) {
+            ResearchApplicationDO application = applicationMap.get(member.getApplicationId());
+            if (application == null || !matchesMemberKeyword(member, keyword)) {
+                continue;
+            }
+            String key = buildMemberKey(member);
+            ResearchApplicationMemberStatisticsRespVO vo = resultMap.computeIfAbsent(key, k -> {
+                ResearchApplicationMemberStatisticsRespVO item = new ResearchApplicationMemberStatisticsRespVO();
+                item.setName(StrUtil.trim(member.getName()));
+                item.setContactPhone(StrUtil.trim(member.getContactPhone()));
+                item.setWorkUnit(StrUtil.trim(member.getWorkUnit()));
+                item.setJobTitle(StrUtil.trim(member.getJobTitle()));
+                return item;
+            });
+            if (StrUtil.isBlank(vo.getJobTitle()) && StrUtil.isNotBlank(member.getJobTitle())) {
+                vo.setJobTitle(StrUtil.trim(member.getJobTitle()));
+            }
+            if (StrUtil.isNotBlank(member.getMemberRole())) {
+                roleMap.computeIfAbsent(key, k -> new LinkedHashSet<>()).add(StrUtil.trim(member.getMemberRole()));
+            }
+            projectIdMap.computeIfAbsent(key, k -> new LinkedHashSet<>()).add(member.getApplicationId());
+            if (StrUtil.isNotBlank(application.getTitle())) {
+                projectTitleMap.computeIfAbsent(key, k -> new LinkedHashSet<>()).add(application.getTitle());
+            }
+        }
+
+        // 3. 姹囨�绘垚鍛樼淮搴︾粨鏋�
+        List<ResearchApplicationMemberStatisticsRespVO> result = new ArrayList<>(resultMap.size());
+        for (Map.Entry<String, ResearchApplicationMemberStatisticsRespVO> entry : resultMap.entrySet()) {
+            String key = entry.getKey();
+            ResearchApplicationMemberStatisticsRespVO vo = entry.getValue();
+            vo.setMemberRoles(String.join("銆�", roleMap.getOrDefault(key, Collections.emptySet())));
+            vo.setProjectCount(projectIdMap.getOrDefault(key, Collections.emptySet()).size());
+            vo.setProjectTitles(String.join("锛�", projectTitleMap.getOrDefault(key, Collections.emptySet())));
+            result.add(vo);
+        }
+        result.sort((a, b) -> {
+            int compare = Integer.compare(
+                    b.getProjectCount() == null ? 0 : b.getProjectCount(),
+                    a.getProjectCount() == null ? 0 : a.getProjectCount());
+            return compare != 0 ? compare : StrUtil.compare(a.getName(), b.getName(), true);
+        });
+        return result;
+    }
+
+    /** 淇濆瓨鐢虫姤涔︽垚鍛樺瓙琛紙璋冪敤鏂归渶鑷淇濊瘉 update 鍦烘櫙宸插厛鍒犻櫎鏃ф暟鎹級 */
+    private void saveMembers(Long applicationId, List<ResearchApplicationMemberSaveReqVO> members) {
+        if (CollUtil.isEmpty(members)) {
+            return;
+        }
+        List<ResearchApplicationMemberDO> list = new ArrayList<>(members.size());
+        int index = 1;
+        for (ResearchApplicationMemberSaveReqVO member : members) {
+            if (member == null || StrUtil.isBlank(member.getName())) {
+                continue;
+            }
+            list.add(ResearchApplicationMemberDO.builder()
+                    .applicationId(applicationId)
+                    .name(StrUtil.trim(member.getName()))
+                    .contactPhone(StrUtil.trim(member.getContactPhone()))
+                    .workUnit(StrUtil.trim(member.getWorkUnit()))
+                    .jobTitle(StrUtil.trim(member.getJobTitle()))
+                    .memberRole(StrUtil.trim(member.getMemberRole()))
+                    .sortNo(member.getSortNo() != null ? member.getSortNo() : index)
+                    .build());
+            index++;
+        }
+        if (CollUtil.isNotEmpty(list)) {
+            memberMapper.insertBatch(list);
+        }
+    }
+
+    private String buildMemberKey(ResearchApplicationMemberDO member) {
+        return StrUtil.join("|", StrUtil.nullToEmpty(member.getName()).trim(),
+                StrUtil.nullToEmpty(member.getContactPhone()).trim(),
+                StrUtil.nullToEmpty(member.getWorkUnit()).trim());
+    }
+
+    private boolean matchesMemberKeyword(ResearchApplicationMemberDO member, String keyword) {
+        if (StrUtil.isBlank(keyword)) {
+            return true;
+        }
+        return StrUtil.containsIgnoreCase(member.getName(), keyword)
+                || StrUtil.containsIgnoreCase(member.getContactPhone(), keyword)
+                || StrUtil.containsIgnoreCase(member.getWorkUnit(), keyword);
     }
 
     @Override
@@ -275,6 +417,42 @@
 
     @Override
     @Transactional(rollbackFor = Exception.class)
+    public String archiveApplication(Long id) {
+        // 1.1 鏍¢獙瀛樺湪
+        ResearchApplicationDO application = validateApplicationExists(id);
+        // 1.2 鍙湁銆屽凡绔嬮」銆嶇殑璇鹃鎵嶈兘褰掓。
+        if (!ResearchApplicationStatusEnum.APPROVED.getStatus().equals(application.getStatus())) {
+            throw exception(APPLICATION_ARCHIVE_FAIL_STATUS,
+                    application.getNo(), ResearchApplicationStatusEnum.nameOf(application.getStatus()));
+        }
+        // 1.3 閲嶅褰掓。鏍¢獙
+        if (application.getArchiveDocumentId() != null) {
+            throw exception(APPLICATION_ALREADY_ARCHIVED, application.getNo(),
+                    StrUtil.blankToDefault(archiveNo(id), "鏈煡"));
+        }
+
+        // 2. 甯﹀叆鐢虫姤涔﹂檮浠讹紝鎸夋潵婧愬崟鎹綊妗o紙鏉ユ簮鍗曞彿鍙栫珛椤圭紪鍙凤紝鏈敓鎴愭椂鍥為��鐢虫姤缂栧彿锛�
+        String sourceNo = StrUtil.blankToDefault(application.getResearchNo(), application.getNo());
+        List<Long> blobIds = storageAttachmentApi.listAttachments(APPLICATION_RECORD_TYPE, id).stream()
+                .map(StorageBlobRespDTO::getId).collect(Collectors.toList());
+        Long archiveDocumentId = archiveDocumentApi.archiveBySource(new ArchiveDocumentCreateReqDTO()
+                .setSourceType(ARCHIVE_SOURCE_TYPE_RESEARCH)
+                .setSourceId(id)
+                .setSourceNo(sourceNo)
+                .setSourceTitle(application.getTitle())
+                .setCategoryCode(ARCHIVE_CATEGORY_CODE_RESEARCH)
+                .setSecretLevel(ARCHIVE_SECRET_LEVEL_INTERNAL)
+                .setSummary("璇鹃鐢虫姤涔﹀綊妗�")
+                .setBlobIds(blobIds)).getCheckedData();
+
+        // 3. 鍥炲啓褰掓。妗f ID锛堜綔涓哄凡褰掓。纭爣璁帮級
+        applicationMapper.updateById(new ResearchApplicationDO()
+                .setId(id).setArchiveDocumentId(archiveDocumentId));
+        return StrUtil.blankToDefault(archiveNo(id), "鏈煡");
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
     public void updateReviewSummary(Long id, BigDecimal reviewAvgScore, Integer reviewPass) {
         // 鐢� UpdateWrapper 鏄惧紡 set锛屼繚璇併�岃瘎瀹℃槑缁嗚鍒犵┖銆嶆椂鑳芥妸姹囨�诲�兼竻鎴� null
         applicationMapper.update(null, new LambdaUpdateWrapper<ResearchApplicationDO>()
@@ -293,6 +471,13 @@
         return application;
     }
 
+    /** 鏌ヨ鏉ユ簮鍗曟嵁宸茬敓鎴愮殑妗f缂栧彿锛堟湭褰掓。鏃惰繑鍥� null锛� */
+    private String archiveNo(Long applicationId) {
+        ArchiveDocumentRespDTO archive = archiveDocumentApi
+                .getBySource(ARCHIVE_SOURCE_TYPE_RESEARCH, applicationId).getCheckedData();
+        return archive != null ? archive.getNo() : null;
+    }
+
     /** 淇濆瓨锛堣崏绋匡級闃舵鏍¢獙鎸囧崡锛氬繀椤诲瓨鍦ㄤ笖宸插彂甯� */
     private ResearchGuidelineDO validateGuidelineForSave(Long guidelineId) {
         ResearchGuidelineDO guideline = guidelineService.getGuideline(guidelineId);

--
Gitblit v1.9.3