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