From 92c26cea4de00349b346f71da3cf530b26c31eb0 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Tue, 10 Jun 2025 09:40:59 +0800
Subject: [PATCH] fix(mall): 修复用户重复加入标签的问题

---
 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java |  195 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 188 insertions(+), 7 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
index 0268278..978f6cd 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
@@ -1,5 +1,6 @@
 package cc.mrbird.febs.mall.service.impl;
 
+import cc.mrbird.febs.common.configure.FebsConfigure;
 import cc.mrbird.febs.common.entity.FebsResponse;
 import cc.mrbird.febs.common.enumerates.*;
 import cc.mrbird.febs.common.exception.FebsException;
@@ -9,16 +10,14 @@
 import cc.mrbird.febs.mall.conversion.MallShopApplyConversion;
 import cc.mrbird.febs.mall.conversion.MallStoreConversion;
 import cc.mrbird.febs.mall.dto.*;
-import cc.mrbird.febs.mall.dto.memberLevel.ApiMemberLabelAddDto;
-import cc.mrbird.febs.mall.dto.memberLevel.ApiMemberLabelInfoDto;
-import cc.mrbird.febs.mall.dto.memberLevel.ApiMemberLabelInsureDto;
-import cc.mrbird.febs.mall.dto.memberLevel.ApiMemberLabelItemDto;
+import cc.mrbird.febs.mall.dto.memberLevel.*;
 import cc.mrbird.febs.mall.dto.signActivity.ApiNewGiftSettingDto;
 import cc.mrbird.febs.mall.entity.*;
 import cc.mrbird.febs.mall.mapper.*;
 import cc.mrbird.febs.mall.service.*;
 import cc.mrbird.febs.mall.vo.*;
 import cc.mrbird.febs.mall.vo.memberLevel.*;
+import cc.mrbird.febs.mall.vo.sale.ApiSaleRecordInfoVo;
 import cc.mrbird.febs.pay.model.BrandWCPayRequestData;
 import cc.mrbird.febs.pay.service.IXcxPayService;
 import cc.mrbird.febs.pay.util.MD5;
@@ -27,6 +26,7 @@
 import cc.mrbird.febs.vip.mapper.MallVipConfigMapper;
 import cn.hutool.core.bean.BeanUtil;
 import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.date.DateTime;
 import cn.hutool.core.date.DateUnit;
 import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.IdUtil;
@@ -55,6 +55,7 @@
 import java.math.BigDecimal;
 import java.math.RoundingMode;
 import java.util.*;
+import java.util.concurrent.CompletableFuture;
 import java.util.stream.Collectors;
 
 /**
@@ -98,6 +99,7 @@
     private final IApiMallMemberWalletService mallMemberWalletService;
     private final HappyMemberLabelRecordMapper happyMemberLabelRecordMapper;
     private final HappyMemberLabelMapper happyMemberLabelMapper;
+    private final FebsConfigure febsConfigure;
 
 
     @Value("${spring.profiles.active}")
@@ -1741,6 +1743,7 @@
                     new LambdaQueryWrapper<HappyMemberLabel>()
                             .select( HappyMemberLabel::getId, HappyMemberLabel::getCode,HappyMemberLabel::getIconPng, HappyMemberLabel::getName, HappyMemberLabel::getContent, HappyMemberLabel::getHeaderPng)
                             .in(HappyMemberLabel::getId, collect)
+                    .orderByDesc(HappyMemberLabel::getCode)
             );
             if(CollUtil.isNotEmpty(happyMemberLabels)){
                 for (HappyMemberLabel happyMemberLabel : happyMemberLabels) {
@@ -1800,6 +1803,158 @@
     }
 
     @Override
+    public FebsResponse scoreRecord(ApiScoreRecordInfoDto dto) {
+        // 初始化结果列表
+        List<ApiScoreRecordInfoVo> apiSaleRecordInfoVos = new ArrayList<>();
+
+        List<HappyMemberLabel> happyMemberLabels = happyMemberLabelMapper.selectList(
+                Wrappers.lambdaQuery(HappyMemberLabel.class)
+                        .eq(HappyMemberLabel::getCode, 1)
+                        .eq(HappyMemberLabel::getParentId, 0)
+        );
+        if(CollUtil.isEmpty(happyMemberLabels)){
+            return new FebsResponse().success().data(apiSaleRecordInfoVos);
+        }
+
+        // 获取类型参数
+        Integer type = dto.getType();
+        // 校验类型参数,确保其为1(月)或2(周)
+        if (type == null || (type != 1 && type != 2 && type != 3)) {
+            return new FebsResponse().fail().message("非法的类型参数");
+        }
+        DateTime startTime = DateUtil.beginOfMonth(new Date());
+        if(1 == type){
+            startTime = DateUtil.beginOfMonth(new Date());
+        }
+        if(2 == type){
+            startTime = DateUtil.beginOfWeek(new Date());
+        }
+        if(3 == type){
+            startTime = DateUtil.beginOfYear(new Date());
+        }
+
+        // 合并查询所有子标签
+        Set<Long> parentIds = happyMemberLabels.stream()
+                .map(HappyMemberLabel::getId)
+                .collect(Collectors.toSet());
+
+        List<HappyMemberLabel> allChildLabels = happyMemberLabelMapper.selectList(
+                Wrappers.lambdaQuery(HappyMemberLabel.class)
+                        .in(HappyMemberLabel::getParentId, parentIds)
+        );
+
+        Map<Long, List<HappyMemberLabel>> childLabelMap = new HashMap<>();
+        if (CollUtil.isNotEmpty(allChildLabels)) {
+            childLabelMap = allChildLabels.stream()
+                    .collect(Collectors.groupingBy(HappyMemberLabel::getParentId));
+        }
+
+        // 提取所有子标签 ID
+        Set<Long> labelIds = allChildLabels.stream()
+                .map(HappyMemberLabel::getId)
+                .collect(Collectors.toSet());
+
+        // 获取所有绑定关系
+        List<HappyMemberLabelRecord> labelRecords = CollUtil.isEmpty(labelIds) ? Collections.emptyList() :
+                happyMemberLabelRecordMapper.selectList(
+                        Wrappers.lambdaQuery(HappyMemberLabelRecord.class)
+                                .in(HappyMemberLabelRecord::getLabelId, labelIds)
+                );
+
+        Map<Long, Set<Long>> labelToMembersMap = new HashMap<>();
+        if (CollUtil.isNotEmpty(labelRecords)) {
+            labelToMembersMap = labelRecords.stream()
+                    .collect(Collectors.groupingBy(
+                            HappyMemberLabelRecord::getLabelId,
+                            Collectors.mapping(HappyMemberLabelRecord::getMemberId, Collectors.toSet())
+                    ));
+        }
+
+        Set<Long> memberIds = labelToMembersMap.values().stream()
+                .flatMap(Set::stream)
+                .collect(Collectors.toSet());
+
+        // 获取资金流
+        List<MallMoneyFlow> moneyFlows = CollUtil.isEmpty(memberIds) ? Collections.emptyList() :
+                mallMoneyFlowMapper.selectList(
+                        Wrappers.lambdaQuery(MallMoneyFlow.class)
+                                .select(MallMoneyFlow::getAmount, MallMoneyFlow::getMemberId)
+                                .in(MallMoneyFlow::getMemberId, memberIds)
+                                .eq(MallMoneyFlow::getFlowType, FlowTypeEnum.PRIZE_SCORE.getValue())
+                                .gt(MallMoneyFlow::getAmount, BigDecimal.ZERO)
+                                .ge(MallMoneyFlow::getCreatedTime, startTime)
+                );
+
+        Map<Long, BigDecimal> memberScoreMap = new HashMap<>();
+        if (CollUtil.isNotEmpty(moneyFlows)) {
+            memberScoreMap = moneyFlows.stream()
+                    .collect(Collectors.groupingBy(
+                            MallMoneyFlow::getMemberId,
+                            Collectors.mapping(MallMoneyFlow::getAmount, Collectors.reducing(BigDecimal.ZERO, BigDecimal::add))
+                    ));
+        }
+
+        List<CompletableFuture<ApiScoreRecordInfoVo>> futures = new ArrayList<>();
+
+        Map<Long, List<HappyMemberLabel>> finalChildLabelMap = childLabelMap;
+        Map<Long, Set<Long>> finalLabelToMembersMap = labelToMembersMap;
+        Map<Long, BigDecimal> finalMemberScoreMap = memberScoreMap;
+        happyMemberLabels.forEach(item -> {
+            CompletableFuture<ApiScoreRecordInfoVo> uCompletableFuture = CompletableFuture.supplyAsync(() -> {
+                ApiScoreRecordInfoVo vo = new ApiScoreRecordInfoVo();
+                vo.setName(item.getName());
+                vo.setAvatar(item.getIconPng());
+                vo.setScore(BigDecimal.ZERO);
+
+                List<HappyMemberLabel> children = finalChildLabelMap.getOrDefault(item.getId(), Collections.emptyList());
+                if (CollUtil.isEmpty(children)) {
+                    return vo;
+                }
+
+                Set<Long> childIds = children.stream().map(HappyMemberLabel::getId).collect(Collectors.toSet());
+                Set<Long> members = new HashSet<>();
+                for (Long childId : childIds) {
+                    Set<Long> ids = finalLabelToMembersMap.getOrDefault(childId, Collections.emptySet());
+                    members.addAll(ids);
+                }
+
+                if (CollUtil.isEmpty(members)) {
+                    return vo;
+                }
+
+                BigDecimal total = BigDecimal.ZERO;
+                for (Long memberId : members) {
+                    total = total.add(finalMemberScoreMap.getOrDefault(memberId, BigDecimal.ZERO));
+                }
+                vo.setScore(total.setScale(0, RoundingMode.DOWN));
+                return vo;
+            }, febsConfigure.asyncThreadPoolTaskExecutor()).exceptionally(ex -> {
+                // 异常兜底返回默认值
+                ApiScoreRecordInfoVo vo = new ApiScoreRecordInfoVo();
+                vo.setName(item.getName());
+                vo.setAvatar(item.getIconPng());
+                vo.setScore(BigDecimal.ZERO);
+                return vo;
+            });
+
+            futures.add(uCompletableFuture);
+        });
+        // 等待所有任务完成
+        CompletableFuture<Void> allOf = CompletableFuture.allOf(futures.toArray(new CompletableFuture[0]));
+        allOf.join(); // 阻塞直到所有任务完成
+
+        //等任务结束,获取返回结果
+        apiSaleRecordInfoVos = futures.stream()
+                .map(CompletableFuture::join)
+                .sorted(Comparator.comparing(ApiScoreRecordInfoVo::getScore).reversed())
+                .collect(Collectors.toList());
+
+
+        // 返回成功响应,包含销售记录信息
+        return new FebsResponse().success().data(apiSaleRecordInfoVos);
+    }
+
+    @Override
     public FebsResponse getMemberLabelListById(ApiMemberLabelItemDto dto) {
 
         // 获取当前登录用户的ID
@@ -1822,11 +1977,30 @@
                             .in(MallMember::getId, memberIdSet)
                     .eq(MallMember::getAccountStatus, MallMember.ACCOUNT_STATUS_ENABLE)
             );
+
+            List<MallMoneyFlow> mallMoneyFlows = mallMoneyFlowMapper.selectList(
+                    Wrappers.lambdaQuery(MallMoneyFlow.class)
+                            .select(MallMoneyFlow::getAmount,  MallMoneyFlow::getMemberId)
+                            .in(MallMoneyFlow::getMemberId, memberIdSet)
+                            .eq(MallMoneyFlow::getFlowType, FlowTypeEnum.PRIZE_SCORE.getValue())
+                            .gt(MallMoneyFlow::getAmount, BigDecimal.ZERO)
+            );
+            //stream流操作mallMoneyFlows,返回一个map<Long,BigDecimal>,其中key为memberId,value为mallMoneyFlow的memberId等于key的amount的总和
+            Map<Long, BigDecimal> prizeScoreMap = mallMoneyFlows.stream()
+                    .filter(Objects::nonNull) // 防止 MallMoneyFlow 为 null
+                    .collect(Collectors.groupingBy(
+                            MallMoneyFlow::getMemberId,
+                            Collectors.mapping(
+                                    MallMoneyFlow::getAmount,
+                                    Collectors.reducing(BigDecimal.ZERO, BigDecimal::add)
+                            )
+                    ));
             for (MallMember mallMember : mallMembers){
                 ApiMemberLabelItemVo apiMemberLabelItemVo = new ApiMemberLabelItemVo();
                 apiMemberLabelItemVo.setName(mallMember.getName());
                 apiMemberLabelItemVo.setAvatar(mallMember.getAvatar());
                 apiMemberLabelItemVo.setPhone(mallMember.getPhone());
+                apiMemberLabelItemVo.setScore(prizeScoreMap.get(mallMember.getId()).setScale(0,RoundingMode.DOWN));
                 apiMemberLabelItemVos.add(apiMemberLabelItemVo);
             }
         }
@@ -1858,9 +2032,9 @@
         apiMemberLabelAddVo.setName(mallMember.getName());
         apiMemberLabelAddVo.setPhone(mallMember.getPhone());
 
-        HappyMemberLevel happyMemberLevel = happyMemberLevelMapper.selectById(labelId);
-        apiMemberLabelAddVo.setLabelId(happyMemberLevel.getId());
-        apiMemberLabelAddVo.setLabelName(happyMemberLevel.getName());
+        HappyMemberLabel happyMemberLabel = happyMemberLabelMapper.selectById(labelId);
+        apiMemberLabelAddVo.setLabelId(happyMemberLabel.getId());
+        apiMemberLabelAddVo.setLabelName(happyMemberLabel.getName());
 
         //获取会员标签
         Integer integer = happyMemberLabelRecordMapper.selectCount(
@@ -1884,6 +2058,13 @@
         Long labelId = dto.getLabelId();
         Long insureMemberId = dto.getMemberId();
 
+        List<HappyMemberLabelRecord> happyMemberLabelRecords1 = happyMemberLabelRecordMapper.selectList(Wrappers.lambdaQuery(HappyMemberLabelRecord.class)
+                .eq(HappyMemberLabelRecord::getMemberId, insureMemberId)
+        );
+        if(CollUtil.isNotEmpty(happyMemberLabelRecords1)){
+            throw new FebsException("该用户不能重复加入");
+        }
+
         HappyMemberLabel happyMemberLabel = happyMemberLabelMapper.selectById(labelId);
         if(ObjectUtil.isEmpty(happyMemberLabel)){
             throw new FebsException("会员标签不存在");

--
Gitblit v1.9.1