feat(mall): 添加年排行功能并优化积分查询性能

Administrator

2 days ago 6127f9c2f53b4e11d2ddfc5575631e5403da0410

 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(