From 664184af3e070dee665ee736caffa0297804975f Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Tue, 18 Mar 2025 11:46:02 +0800 Subject: [PATCH] perf(mall): 移除会员利润计算中的异步执行 --- src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java | 320 ++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 267 insertions(+), 53 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 685e20b..5cf9638 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 @@ -16,6 +16,7 @@ import cc.mrbird.febs.pay.model.BrandWCPayRequestData; import cc.mrbird.febs.pay.service.IXcxPayService; import cc.mrbird.febs.pay.util.MD5; +import cc.mrbird.febs.rabbit.producter.AgentProducer; import cc.mrbird.febs.vip.VipSettingUnAliveSettingBo; import cc.mrbird.febs.vip.entity.MallVipConfig; import cc.mrbird.febs.vip.mapper.MallVipConfigMapper; @@ -46,6 +47,7 @@ import java.io.IOException; import java.math.BigDecimal; +import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; @@ -70,7 +72,6 @@ private final MallShopApplyMapper mallShopApplyMapper; private final MallRegisterAppealMapper mallRegisterAppealMapper; private final MallTeamLeaderMapper mallTeamLeaderMapper; - private final SpringContextHolder springContextHolder; private final MallAgentRecordMapper mallAgentRecordMapper; private final IMallMoneyFlowService mallMoneyFlowService; private final IMallMemberCollectionService mallMemberCollectionService; @@ -80,6 +81,7 @@ private final MallGoodsCouponMapper mallGoodsCouponMapper; private final MallMemberCouponMapper mallMemberCouponMapper; private final MallGoodsMapper mallGoodsMapper; + private final MallChargeMapper mallChargeMapper; private final MallVipConfigMapper mallVipConfigMapper; private final RunVipMapper runVipMapper; @@ -87,6 +89,7 @@ private final MallStoreItemMapper mallStoreItemMapper; private final MallStoreMemberMapper mallStoreMemberMapper; private final MallMemberWithdrawMapper mallMemberWithdrawMapper; + private final AgentProducer agentProducer; @Value("${spring.profiles.active}") @@ -130,19 +133,31 @@ //对于邀请码的验证和上级联系人的验证 Integer count = this.baseMapper.selectCount(null); if (count != null && count != 0) { - if(!StrUtil.isEmpty(registerDto.getInviteId())){ - String inviteId = registerDto.getInviteId(); - MallMember inviteMember = this.baseMapper.selectInfoByInviteId(inviteId); - if (inviteMember == null) { - throw new FebsException("邀请码不存在"); - } - mallMember.setReferrerId(registerDto.getInviteId()); + if(StrUtil.isEmpty(registerDto.getInviteId())){ + throw new FebsException("请输入邀请码"); } + String inviteId = registerDto.getInviteId(); + MallMember inviteMember = this.baseMapper.selectInfoByInviteId(inviteId); + if (inviteMember == null) { + throw new FebsException("邀请码不存在"); + } + mallMember.setReferrerId(registerDto.getInviteId()); +// if(!StrUtil.isEmpty(registerDto.getInviteId())){ +// String inviteId = registerDto.getInviteId(); +// MallMember inviteMember = this.baseMapper.selectInfoByInviteId(inviteId); +// if (inviteMember == null) { +// throw new FebsException("邀请码不存在"); +// } +// mallMember.setReferrerId(registerDto.getInviteId()); +// } } - mallMember.setName(hidePhoneNumber(account)); + mallMember.setName(account); + mallMember.setAvatar("https://res.runstep.cc/rslogo.png"); mallMember.setAccountStatus(YesOrNoEnum.YES.getValue()); mallMember.setAccountType(MallMember.ACCOUNT_TYPE_NORMAL); mallMember.setSex("男"); + mallMember.setDirector(YesOrNoEnum.NO.getValue()); + mallMember.setDirectorTime(DateUtil.date()); mallMember.setBindPhone(account); this.baseMapper.insert(mallMember); @@ -188,15 +203,9 @@ wallet.setBalance(BigDecimal.ZERO); wallet.setMemberId(mallMember.getId()); mallMemberWalletMapper.insert(wallet); - return new FebsResponse().success().message("注册成功"); - } - public static String hidePhoneNumber(String phoneNumber) { - // 获取前3位和后4位 - String prefix = phoneNumber.substring(0, 3); - String suffix = phoneNumber.substring(phoneNumber.length() - 4); - // 生成隐藏的电话号码 - return prefix + "****" + suffix; + agentProducer.sendNodeUpMsg(mallMember.getId()); + return new FebsResponse().success().message("注册成功"); } @Override @@ -286,11 +295,73 @@ mallMemberVo.setLevelPng(runVip.getVipPng()); mallMemberVo.setChangeState(runVip.getChangeState()); mallMemberVo.setWithdrawState(runVip.getWithdrawState()); + mallMemberVo.setInsideState(runVip.getInsideState()); + mallMemberVo.setCommissionState(runVip.getCommissionState()); + mallMemberVo.setGrowState(runVip.getGrowState()); + MallMemberWallet wallet = mallMemberWalletMapper.selectWalletByMemberId(mallMemberVo.getId()); mallMemberVo.setBalance(wallet.getBalance()); mallMemberVo.setScore(wallet.getScore()); + mallMemberVo.setCommission(wallet.getCommission()); return new FebsResponse().success().data(mallMemberVo); + } + + private BigDecimal getDirectAchieve(String inviteId,Date startTime,Date endTime) { + + try { + // 获取直推成员和团队成员的ID集合 + Set<Long> memberIds = getTeamMemberIds(inviteId); + + if (CollUtil.isEmpty(memberIds)) { + return BigDecimal.ZERO; + } + + // 获取团队业绩(不包含本人业绩) + List<MallCharge> mallCharges = mallChargeMapper.selectList( + new LambdaQueryWrapper<MallCharge>() + .in(MallCharge::getMemberId, memberIds) + .eq(MallCharge::getState, YesOrNoEnum.YES.getValue()) + .ge(MallCharge::getCreatedTime, startTime) + .lt(MallCharge::getCreatedTime, endTime) + ); + + if (CollUtil.isEmpty(mallCharges)) { + return BigDecimal.ZERO; + } + + return mallCharges.stream() + .map(MallCharge::getAmount) + .reduce(BigDecimal.ZERO, BigDecimal::add); + } catch (Exception e) { + // 异常处理 + log.error("Error occurred while calculating direct achieve for member: {}", inviteId, e); + return BigDecimal.ZERO; + } + } + private Set<Long> getTeamMemberIds(String inviteId) { + Set<Long> memberIds = new HashSet<>(); + // 获取直推成员 + List<MallMember> directMembers = this.baseMapper.selectList( + new LambdaQueryWrapper<MallMember>() + .eq(MallMember::getReferrerId, inviteId) + ); + if(CollUtil.isEmpty(directMembers)){ + return memberIds; + } + memberIds.addAll(directMembers.stream().map(MallMember::getId).collect(Collectors.toSet())); + + // 获取团队成员 + List<MallMember> teamMembers = this.baseMapper.selectList( + new LambdaQueryWrapper<MallMember>() + .in(MallMember::getReferrerId, directMembers.stream().map(MallMember::getInviteId).collect(Collectors.toSet())) + ); + if(CollUtil.isEmpty(teamMembers)){ + return memberIds; + } + memberIds.addAll(teamMembers.stream().map(MallMember::getId).collect(Collectors.toSet())); + + return memberIds; } @Override @@ -359,9 +430,21 @@ * 直属三级 */ MyTeamVo myTeamVo = new MyTeamVo(); + //节点和团队业绩 + myTeamVo.setDirector(mallMember.getDirector()); + if(mallMember.getDirector() == YesOrNoEnum.YES.getValue() && mallMember.getDirectorTime() != null){ + myTeamVo.setDirectorTime(mallMember.getDirectorTime()); + BigDecimal directAchieve = getDirectAchieve(mallMember.getInviteId(), mallMember.getDirectorTime(), DateUtil.date()); + myTeamVo.setDirectorAchieve(directAchieve); + }else{ + myTeamVo.setDirectorTime(mallMember.getCreatedTime()); + BigDecimal directAchieve = getDirectAchieve(mallMember.getInviteId(), mallMember.getCreatedTime(), DateUtil.date()); + myTeamVo.setDirectorAchieve(directAchieve); + } //获取个人的碳币 MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(memberId); myTeamVo.setMyBalance(mallMemberWallet.getBalance()); + myTeamVo.setMyCommission(mallMemberWallet.getCommission()); //全部直推 List<MallMember> mallMembers = this.baseMapper.selectByRefererId(mallMember.getInviteId()); /** @@ -370,6 +453,7 @@ if(CollUtil.isEmpty(mallMembers)){ myTeamVo.setMyTeamCnt(0); myTeamVo.setMyTeamBalance(BigDecimal.ZERO); + myTeamVo.setMyTeamCommission(BigDecimal.ZERO); myTeamVo.setTeam(null); return new FebsResponse().success().data(myTeamVo); } @@ -377,20 +461,31 @@ * 如果有下级,获取所有的团队 */ myTeamVo.setMyTeamCnt(mallMembers.size()); - myTeamVo.setMyTeamBalance(getTeamBalance(mallMembers)); + myTeamVo.setMyTeamBalance(getTeamBalance(mallMembers).getMyTeamBalance()); + myTeamVo.setMyTeamCommission(getTeamBalance(mallMembers).getMyTeamCommission()); + + List<MallMember> mallMembersAll = this.baseMapper.selectAllChildAgentListByInviteId(mallMember.getInviteId()); + if(CollUtil.isNotEmpty(mallMembersAll)){ + myTeamVo.setMyTeamCntAll(mallMembersAll.size()); + myTeamVo.setMyTeamBalanceAll(getTeamBalance(mallMembersAll).getMyTeamBalance()); + myTeamVo.setMyTeamCommissionAll(getTeamBalance(mallMembersAll).getMyTeamCommission()); + } List<TeamListVo> teamListVos = MallMemberConversion.INSTANCE.entityToTeamListVos(mallMembers); teamListVos.forEach(item -> { item.setMyBalance(mallMemberWalletMapper.selectWalletByMemberId(item.getId()).getBalance()); item.setLevelName(runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode,item.getLevel())).getVipName()); - List<MallMember> mallMemberRefs = this.baseMapper.selectByRefererId(item.getInviteId()); +// List<MallMember> mallMemberRefs = this.baseMapper.selectByRefererId(item.getInviteId()); + List<MallMember> mallMemberRefs = this.baseMapper.selectAllChildAgentListByInviteId(item.getInviteId()); if(CollUtil.isEmpty(mallMemberRefs)){ item.setMyTeamCnt(0); item.setMyTeamBalance(BigDecimal.ZERO); + item.setMyTeamCommission(BigDecimal.ZERO); }else{ item.setMyTeamCnt(mallMemberRefs.size()); //获取mallMembers的所有id - item.setMyTeamBalance(getTeamBalance(mallMemberRefs)); + item.setMyTeamBalance(getTeamBalance(mallMemberRefs).getMyTeamBalance()); + item.setMyTeamCommission(getTeamBalance(mallMemberRefs).getMyTeamCommission()); } }); myTeamVo.setTeam(teamListVos); @@ -407,15 +502,17 @@ * @param mallMembers 商城成员列表,用于计算总余额 * @return 团队的总余额,表示为BigDecimal类型 */ - private BigDecimal getTeamBalance(List<MallMember> mallMembers) { + private TeamListVo getTeamBalance(List<MallMember> mallMembers) { + TeamListVo teamListVo = new TeamListVo(); // 提取所有商城成员的ID,以便进行后续的钱包信息查询 List<Long> ids = mallMembers.stream().map(MallMember::getId).collect(Collectors.toList()); // 根据成员ID列表查询所有相关成员的钱包信息 List<MallMemberWallet> mallMemberWallets = mallMemberWalletMapper.selectList(new LambdaQueryWrapper<MallMemberWallet>().in(MallMemberWallet::getMemberId, ids)); - // 计算所有成员钱包余额的总和,并返回该总和 - return mallMemberWallets.stream().map(MallMemberWallet::getBalance).reduce(BigDecimal.ZERO, BigDecimal::add); + teamListVo.setMyTeamBalance(mallMemberWallets.stream().map(MallMemberWallet::getBalance).reduce(BigDecimal.ZERO, BigDecimal::add)); + teamListVo.setMyTeamCommission(mallMemberWallets.stream().map(MallMemberWallet::getCommission).reduce(BigDecimal.ZERO, BigDecimal::add)); + return teamListVo; } @Override @@ -493,7 +590,7 @@ * 用户的等级level是否允许兑换碳币 */ RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); - if(ObjectUtil.isEmpty(runVip) || runVip.getChangeState() != YesOrNoEnum.YES.getValue()){ + if(ObjectUtil.isEmpty(runVip) || runVip.getInsideState() != YesOrNoEnum.YES.getValue()){ throw new FebsException("请先升级会员"); } @@ -509,34 +606,35 @@ throw new FebsException("资金密码错误"); } - walletService.reduceBalance(transferDto.getAmount(), loginMember.getId()); + walletService.reduceCommission(transferDto.getAmount(), loginMember.getId()); String orderNo = MallUtils.getOrderNum("HZ"); this.runVipMoneyFlowAdd( loginMember.getId(), mallMember.getId(), orderNo, - FlowTypeEnum.BALANCE.getValue(), - RunVipMoneyFlowTypeEnum.BALANCE_OUT_GIVE_FRIEND.getValue(), + FlowTypeEnum.COMMISSION.getValue(), + RunVipMoneyFlowTypeEnum.COMMISSION_OUT_GIVE_FRIEND.getValue(), transferDto.getAmount().negate(), - StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT_GIVE_FRIEND.getDescription(),mallMember.getInviteId(),transferDto.getAmount()), + StrUtil.format(RunVipMoneyFlowTypeEnum.COMMISSION_OUT_GIVE_FRIEND.getDescription(),mallMember.getInviteId(),transferDto.getAmount()), YesOrNoEnum.YES.getValue() ); - walletService.addBalance(transferDto.getAmount(), mallMember.getId()); + walletService.addCommission(transferDto.getAmount(), mallMember.getId()); this.runVipMoneyFlowAdd( mallMember.getId(), loginMember.getId(), orderNo, - FlowTypeEnum.BALANCE.getValue(), - RunVipMoneyFlowTypeEnum.BALANCE_IN_GIVE_FRIEND.getValue(), + FlowTypeEnum.COMMISSION.getValue(), + RunVipMoneyFlowTypeEnum.COMMISSION_IN_GIVE_FRIEND.getValue(), transferDto.getAmount(), - StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_IN_GIVE_FRIEND.getDescription(),loginMember.getInviteId(),transferDto.getAmount()), + StrUtil.format(RunVipMoneyFlowTypeEnum.COMMISSION_IN_GIVE_FRIEND.getDescription(),loginMember.getInviteId(),transferDto.getAmount()), YesOrNoEnum.YES.getValue() ); } @Override - public void withdrawal(WithdrawalDto withdrawalDto) { + @Transactional(rollbackFor = Exception.class) + public void withdrawal(CommissionChangeDto withdrawalDto) { Long memberId = LoginUserUtil.getLoginUser().getId(); MallMember loginMember = this.baseMapper.selectById(memberId); /** @@ -555,15 +653,11 @@ throw new FebsException("资金密码错误"); } - MallMemberPayment mallMemberPayment = mallMemberPaymentMapper.selectById(withdrawalDto.getAddressId()); - if (mallMemberPayment == null) { - throw new FebsException("无效的提现地址"); - } BigDecimal minCnt = new BigDecimal( dataDictionaryCustomMapper.selectDicDataByTypeAndCode( RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN_MIN.getType(), RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN_MIN.getCode()).getValue() - ).setScale(4, BigDecimal.ROUND_DOWN); + ).setScale(4, RoundingMode.DOWN); if(minCnt.compareTo(withdrawalDto.getAmount()) > 0){ throw new FebsException(minCnt+"碳币起提"); } @@ -572,18 +666,85 @@ dataDictionaryCustomMapper.selectDicDataByTypeAndCode( RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN.getType(), RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN.getCode()).getValue() - ).setScale(2, BigDecimal.ROUND_DOWN); + ).setScale(2, RoundingMode.DOWN); + BigDecimal withdrawalAmount = withdrawalDto.getAmount().multiply(balanceToCoin).setScale(2, RoundingMode.DOWN); + if(BigDecimal.ZERO.compareTo(withdrawalAmount) >= 0){ + throw new FebsException("转换异常"); + } + + /** + * 减少碳币 + */ + walletService.reduceBalance(withdrawalDto.getAmount(), loginMember.getId()); + String orderNo = MallUtils.getOrderNum("BU"); + this.runVipMoneyFlowAdd( + loginMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.BALANCE.getValue(), + RunVipMoneyFlowTypeEnum.BALANCE_OUT_COMMISSION.getValue(), + withdrawalDto.getAmount().negate(), + StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT_COMMISSION.getDescription(),withdrawalDto.getAmount(),withdrawalAmount), + YesOrNoEnum.YES.getValue() + ); + walletService.addCommission(withdrawalAmount, loginMember.getId()); + this.runVipMoneyFlowAdd( + loginMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.COMMISSION.getValue(), + RunVipMoneyFlowTypeEnum.BALANCE_OUT_COMMISSION_IN.getValue(), + withdrawalAmount, + StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT_COMMISSION_IN.getDescription(),withdrawalDto.getAmount(),withdrawalAmount), + YesOrNoEnum.YES.getValue() + ); + } + + @Override + @Transactional(rollbackFor = Exception.class) + public void withdrawalU(WithdrawalDto withdrawalDto) { + Long memberId = LoginUserUtil.getLoginUser().getId(); + MallMember loginMember = this.baseMapper.selectById(memberId); + /** + * 用户的等级level是否允许USDT提现 + */ + RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); + if(ObjectUtil.isEmpty(runVip) || runVip.getCommissionState() != YesOrNoEnum.YES.getValue()){ + throw new FebsException("请先升级会员"); + } + + if (StrUtil.isBlank(loginMember.getTradePassword())) { + throw new FebsException("未设置资金密码"); + } + + if (!loginMember.getTradePassword().equals(SecureUtil.md5(withdrawalDto.getTradePwd()))) { + throw new FebsException("资金密码错误"); + } + + MallMemberPayment mallMemberPayment = mallMemberPaymentMapper.selectById(withdrawalDto.getAddressId()); + if (mallMemberPayment == null) { + throw new FebsException("无效的提现地址"); + } BigDecimal balanceToCoinPercent = new BigDecimal( dataDictionaryCustomMapper.selectDicDataByTypeAndCode( RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN_PERCENT.getType(), RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN_PERCENT.getCode()).getValue() - ).setScale(4, BigDecimal.ROUND_DOWN); + ).setScale(2, RoundingMode.DOWN); + + if(balanceToCoinPercent.compareTo(withdrawalDto.getAmount()) > 0){ + throw new FebsException("手续费不足"); + } + BigDecimal fee = balanceToCoinPercent; + BigDecimal withdrawalAmountReal = withdrawalDto.getAmount().subtract(fee).setScale(2, RoundingMode.DOWN); + if(BigDecimal.ZERO.compareTo(withdrawalAmountReal) >= 0){ + throw new FebsException("手续费不足"); + } + /** * 减少碳币,增加进行中提现记录 */ - BigDecimal withdrawalAmount = withdrawalDto.getAmount().multiply(balanceToCoin).setScale(2, BigDecimal.ROUND_DOWN); - BigDecimal fee = balanceToCoinPercent.multiply(withdrawalAmount).setScale(2, BigDecimal.ROUND_DOWN); - BigDecimal withdrawalAmountReal = withdrawalAmount.subtract(fee); + walletService.reduceCommission(withdrawalDto.getAmount(), loginMember.getId()); + String orderNo = MallUtils.getOrderNum("TX"); MallMemberWithdraw withdraw = new MallMemberWithdraw(); withdraw.setWithdrawNo(orderNo); @@ -593,23 +754,24 @@ withdraw.setAmountFee(fee); withdraw.setName(mallMemberPayment.getBank()); withdraw.setType(mallMemberPayment.getBankNo()); + withdraw.setWithdrawTimes(withdrawalDto.getAmount()); mallMemberWithdrawMapper.insert(withdraw); - walletService.reduceBalance(withdrawalDto.getAmount(), loginMember.getId()); this.runVipMoneyFlowAdd( loginMember.getId(), loginMember.getId(), orderNo, - FlowTypeEnum.BALANCE.getValue(), - RunVipMoneyFlowTypeEnum.BALANCE_OUT.getValue(), + FlowTypeEnum.COMMISSION.getValue(), + RunVipMoneyFlowTypeEnum.COMMISSION_OUT.getValue(), withdrawalDto.getAmount().negate(), - StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT.getDescription(),withdrawalDto.getAmount(),withdrawalAmount,fee), + StrUtil.format(RunVipMoneyFlowTypeEnum.COMMISSION_OUT.getDescription(),withdrawalDto.getAmount(),fee), YesOrNoEnum.ING.getValue() ); } @Override + @Transactional(rollbackFor = Exception.class) public void commissionChange(CommissionChangeDto commissionChange) { Long memberId = LoginUserUtil.getLoginUser().getId(); BigDecimal minScore = new BigDecimal( @@ -634,6 +796,11 @@ RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); if(ObjectUtil.isEmpty(runVip) || runVip.getChangeState() != YesOrNoEnum.YES.getValue()){ throw new FebsException("请先升级会员"); + } + + MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(memberId); + if(minScore.compareTo(mallMemberWallet.getScore()) > 0){ + throw new FebsException("碳积分不足"); } BigDecimal scoreBalancePercent = new BigDecimal( @@ -1547,12 +1714,26 @@ return new FebsResponse().success().data(data); } + + public static String hidePhoneNumber(String phoneNumber) { + //判断字符串的长度小于4就直接返回 + if (phoneNumber.length() < 4) { + return phoneNumber; + } + // 获取前3位和后4位 + String prefix = phoneNumber.substring(0, 3); + // 生成隐藏的电话号码 + return prefix + "****"; + } + @Override public List<ApiChartVo> dayRecord(ApiRecordDto apiRecordDto) { /** * 1:日榜 2:月榜 * 获取当前日期 */ + + List<ApiChartVo> apiChartVos = new ArrayList<>(); LambdaQueryWrapper<MallMoneyFlow> mallMoneyFlowLambdaQueryWrapper = new LambdaQueryWrapper<>(); if(apiRecordDto.getType() == 1){ DateTime dateTime = DateUtil.beginOfDay(DateUtil.date()); @@ -1561,15 +1742,26 @@ DateTime dateTime = DateUtil.beginOfMonth(DateUtil.date()); mallMoneyFlowLambdaQueryWrapper.ge(MallMoneyFlow :: getCreatedTime , dateTime); } + List<MallMember> mallMembers = this.baseMapper.selectList( + new LambdaQueryWrapper<MallMember>() + .select(MallMember::getId) + ); + if(CollUtil.isEmpty(mallMembers)){ + return apiChartVos; + } + //获取mallMembers的全部id + List<Long> ids = mallMembers.stream().map(MallMember::getId).collect(Collectors.toList()); mallMoneyFlowLambdaQueryWrapper.eq(MallMoneyFlow :: getFlowType, FlowTypeEnum.SCORE.getValue()); mallMoneyFlowLambdaQueryWrapper.in( MallMoneyFlow :: getType, RunVipMoneyFlowTypeEnum.GET_SCORE.getValue(), RunVipMoneyFlowTypeEnum.SYS_SCORE.getValue() ); + mallMoneyFlowLambdaQueryWrapper.in( + MallMoneyFlow :: getMemberId, + ids + ); List<MallMoneyFlow> mallMoneyFlows = mallMoneyFlowMapper.selectList(mallMoneyFlowLambdaQueryWrapper); - - List<ApiChartVo> apiChartVos = new ArrayList<>(); if(CollUtil.isEmpty(mallMoneyFlows)){ return apiChartVos; } @@ -1587,16 +1779,38 @@ // 对 Map 按照 amount 的绝对值之和从大到小排序,并取前十个结果 List<Map.Entry<Long, BigDecimal>> sortedList = sumByMemberId.entrySet().stream() .sorted((entry1, entry2) -> entry2.getValue().compareTo(entry1.getValue())) - .limit(10) + .limit(20) .collect(Collectors.toList()); - sortedList.forEach(entry -> { + + for (Map.Entry<Long, BigDecimal> entry : sortedList){ + if(apiChartVos.size() >= 10){ + break; + } ApiChartVo apiChartVo = new ApiChartVo(); MallMember mallMember = this.baseMapper.selectById(entry.getKey()); - apiChartVo.setName(mallMember.getName()); + if(null == mallMember){ + continue; + } + + apiChartVo.setName(hidePhoneNumber(mallMember.getName())); apiChartVo.setAvatar(mallMember.getAvatar()); apiChartVo.setScore(entry.getValue()); apiChartVos.add(apiChartVo); - }); + } +// sortedList.forEach(entry -> { +// ApiChartVo apiChartVo = new ApiChartVo(); +// MallMember mallMember = this.baseMapper.selectById(entry.getKey()); +// if(null == mallMember){ +// apiChartVo.setName(hidePhoneNumber("runStep")); +// apiChartVo.setAvatar(null); +// apiChartVo.setScore(entry.getValue()); +// }else{ +// apiChartVo.setName(hidePhoneNumber(mallMember.getName())); +// apiChartVo.setAvatar(mallMember.getAvatar()); +// apiChartVo.setScore(entry.getValue()); +// } +// apiChartVos.add(apiChartVo); +// }); return apiChartVos; } -- Gitblit v1.9.1