perf(mall): 移除会员利润计算中的异步执行

KKSU

2025-03-18 664184af3e070dee665ee736caffa0297804975f

 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}")
@@ -153,6 +156,8 @@
        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);
@@ -198,6 +203,8 @@
        wallet.setBalance(BigDecimal.ZERO);
        wallet.setMemberId(mallMember.getId());
        mallMemberWalletMapper.insert(wallet);

        agentProducer.sendNodeUpMsg(mallMember.getId());
        return new FebsResponse().success().message("注册成功");
    }

@@ -288,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
@@ -361,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());
        /**
@@ -372,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);
        }
@@ -379,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);
@@ -409,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
@@ -511,35 +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
    @Transactional(rollbackFor = Exception.class)
    public void withdrawal(WithdrawalDto withdrawalDto) {
    public void withdrawal(CommissionChangeDto withdrawalDto) {
        Long memberId = LoginUserUtil.getLoginUser().getId();
        MallMember loginMember = this.baseMapper.selectById(memberId);
        /**
@@ -558,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+"碳币起提");
        }
@@ -575,20 +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("手续费不足");
        }

        /**
         *  减少碳币，增加进行中提现记录
         */
        walletService.reduceBalance(withdrawalDto.getAmount(), loginMember.getId());
        walletService.reduceCommission(withdrawalDto.getAmount(), loginMember.getId());

        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);
        String orderNo = MallUtils.getOrderNum("TX");
        MallMemberWithdraw withdraw = new MallMemberWithdraw();
        withdraw.setWithdrawNo(orderNo);
@@ -605,10 +761,10 @@
                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()
        );

@@ -1576,6 +1732,8 @@
         * 1:日榜 2：月榜
         * 获取当前日期
         */

        List<ApiChartVo> apiChartVos = new ArrayList<>();
        LambdaQueryWrapper<MallMoneyFlow> mallMoneyFlowLambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(apiRecordDto.getType() == 1){
            DateTime dateTime = DateUtil.beginOfDay(DateUtil.date());
@@ -1584,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;
        }
@@ -1610,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());
            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;
    }