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 |  125 +++++++++++++++++++++++++++++++++++++++++
 1 files changed, 125 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 827d337..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,7 @@
 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;
@@ -18,9 +19,14 @@
 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;
@@ -78,6 +84,9 @@
     private ResearchApplicationMapper applicationMapper;
 
     @Resource
+    private ResearchApplicationMemberMapper memberMapper;
+
+    @Resource
     private ArchiveDocumentApi archiveDocumentApi;
 
     @Resource
@@ -125,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());
@@ -147,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());
     }
@@ -160,6 +174,7 @@
                     application.getNo(), ResearchApplicationStatusEnum.nameOf(application.getStatus()));
         }
 
+        memberMapper.deleteByApplicationId(id);
         applicationMapper.deleteById(id);
         storageAttachmentApi.deleteAttachmentsByRecord(APPLICATION_RECORD_TYPE, id);
     }
@@ -170,6 +185,116 @@
     }
 
     @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
     public PageResult<ResearchApplicationDO> getApplicationPage(ResearchApplicationPageReqVO pageReqVO) {
         return applicationMapper.selectPage(pageReqVO);
     }

--
Gitblit v1.9.3