From 4276af8de8132927af9921b9fef55fef123f5ff5 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Thu, 19 Dec 2024 17:15:32 +0800 Subject: [PATCH] refactor(mall): 优化会员电话号码隐藏逻辑 --- src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java | 714 ++++++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 608 insertions(+), 106 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 fdb54ab..cc0dee0 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 @@ -7,6 +7,7 @@ import cc.mrbird.febs.common.utils.*; import cc.mrbird.febs.mall.conversion.MallMemberConversion; 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.entity.*; import cc.mrbird.febs.mall.mapper.*; @@ -14,11 +15,13 @@ import cc.mrbird.febs.mall.vo.*; 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.vip.VipSettingUnAliveSettingBo; import cc.mrbird.febs.vip.entity.MallVipConfig; 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; @@ -27,6 +30,7 @@ import cn.hutool.crypto.SecureUtil; import cn.hutool.crypto.asymmetric.KeyType; import cn.hutool.crypto.asymmetric.RSA; +import cn.hutool.json.JSONArray; import cn.hutool.json.JSONUtil; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; @@ -37,8 +41,6 @@ import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Value; -import org.springframework.boot.autoconfigure.security.SecurityProperties; -import org.springframework.http.HttpStatus; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @@ -80,6 +82,11 @@ private final MallGoodsMapper mallGoodsMapper; private final MallVipConfigMapper mallVipConfigMapper; + private final RunVipMapper runVipMapper; + private final MallStoreMapper mallStoreMapper; + private final MallStoreItemMapper mallStoreItemMapper; + private final MallStoreMemberMapper mallStoreMemberMapper; + private final MallMemberWithdrawMapper mallMemberWithdrawMapper; @Value("${spring.profiles.active}") @@ -88,20 +95,21 @@ @Transactional(rollbackFor = Exception.class) @Override public FebsResponse register(RegisterDto registerDto) { - MallMember mallMember = this.baseMapper.selectInfoByAccount(registerDto.getAccount()); - if (mallMember != null) { - throw new FebsException("该账号已被占用"); - } - - List<MallMember> mallMembers = this.baseMapper.selectMemberByName(registerDto.getName()); - if (CollUtil.isNotEmpty(mallMembers)) { - MallRegisterAppeal registerAppeal = mallRegisterAppealMapper.selectByPhoneAndName(registerDto.getName(), registerDto.getAccount()); - if (registerAppeal == null || registerAppeal.getStatus() != 1) { - return new FebsResponse().code(HttpStatus.ACCEPTED).message("用户名已存在"); - } - } - String account = registerDto.getAccount(); + MallMember mallMember = this.baseMapper.selectInfoByAccount(account); + if (mallMember != null) { + throw new FebsException("手机号已注册"); + } + /** + * 验证两次密码是否一致 + */ + String password = registerDto.getPassword(); + String passwordAgain = registerDto.getPasswordAgain(); + if(!password.equals(passwordAgain)){ + throw new FebsException("密码不一致"); + } + + //邀请码为admin的时候(后台添加用户),不需要验证验证码 if (!"admin".equals(registerDto.getRegistType())) { String code = registerDto.getCode(); boolean flags = commonService.verifyCode(account, code); @@ -119,22 +127,23 @@ } else { mallMember.setEmail(registerDto.getAccount()); } - + //对于邀请码的验证和上级联系人的验证 Integer count = this.baseMapper.selectCount(null); if (count != null && count != 0) { - MallMember inviteMember = this.baseMapper.selectInfoByInviteId(registerDto.getInviteId()); - if (inviteMember == null) { - throw new FebsException("邀请码不存在"); + 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.setReferrerId(registerDto.getInviteId()); - } - mallMember.setName(registerDto.getName()); - mallMember.setAccountStatus(MallMember.ACCOUNT_STATUS_ENABLE); + mallMember.setName(account); + mallMember.setAccountStatus(YesOrNoEnum.YES.getValue()); mallMember.setAccountType(MallMember.ACCOUNT_TYPE_NORMAL); mallMember.setSex("男"); - mallMember.setBindPhone(registerDto.getAccount()); + mallMember.setBindPhone(account); this.baseMapper.insert(mallMember); @@ -167,6 +176,12 @@ if (StrUtil.isNotBlank(ids)) { mallMember.setReferrerIds(ids); } + //会员VIP等级 + List<RunVip> runVips = runVipMapper.selectList(new LambdaQueryWrapper<RunVip>().orderByAsc(RunVip::getOrderNumber)); + if (StrUtil.isBlank(mallMember.getLevel()) && CollUtil.isNotEmpty(runVips)) { + RunVip runVip = runVips.get(0); + mallMember.setLevel(runVip.getVipCode()); + } this.baseMapper.updateById(mallMember); MallMemberWallet wallet = new MallMemberWallet(); @@ -185,8 +200,8 @@ throw new FebsException("用户不存在或账号密码错误"); } - if (MallMember.ACCOUNT_STATUS_DISABLED.equals(mallMember.getAccountStatus())) { - throw new FebsException("该账号存在异常, 暂限制登录"); + if (YesOrNoEnum.NO.getValue() == mallMember.getAccountStatus()) { + throw new FebsException("账号限制登录"); } String redisKey = AppContants.APP_LOGIN_PREFIX + mallMember.getId(); @@ -237,7 +252,7 @@ public FebsResponse logout() { Long id = LoginUserUtil.getLoginUser().getId(); - String redisKey = AppContants.XCX_LOGIN_PREFIX + id; + String redisKey = AppContants.APP_LOGIN_PREFIX + id; String existToken = redisUtils.getString(redisKey); if (StrUtil.isNotBlank(existToken)) { Object o = redisUtils.get(existToken); @@ -245,7 +260,7 @@ redisUtils.del(existToken); } } - redisUtils.del(AppContants.XCX_LOGIN_PREFIX + id); + redisUtils.del(AppContants.APP_LOGIN_PREFIX + id); redisUtils.del(AppContants.XCX_LOGIN_PHONE_PREFIX + id); return new FebsResponse().success().message("退出登录"); } @@ -254,48 +269,19 @@ public FebsResponse findMemberInfo() { Long id = LoginUserUtil.getLoginUser().getId(); MallMember mallMember = this.baseMapper.selectById(id); - MallMemberVo mallMemberVo = MallMemberConversion.INSTANCE.entityToVo(mallMember); - if(StrUtil.isNotEmpty(mallMember.getReferrerId())){ - MallMember referMember = this.baseMapper.selectInfoByInviteId(mallMember.getReferrerId()); - if (referMember != null) { - mallMemberVo.setReferrerName(referMember.getName()); - } - } - if (StrUtil.isNotBlank(mallMember.getTradePassword())) { - mallMemberVo.setHasTradePwd(1); - } + mallMemberVo.setTradeWord(StrUtil.isEmpty(mallMember.getTradePassword()) ? YesOrNoEnum.NO.getValue() : YesOrNoEnum.YES.getValue()); - MallMemberPayment payment = mallMemberPaymentMapper.selectByMemberId(id); - if (payment != null) { - mallMemberVo.setHasPayment(1); - } - - MemberCollectionListDto memberCollectionListDto = new MemberCollectionListDto(); - memberCollectionListDto.setPageNow(1); - memberCollectionListDto.setPageSize(10); - List<CollectionListVo> collectionList = mallMemberCollectionService.findMemberCollectionList(memberCollectionListDto); - mallMemberVo.setCollectionCnt(CollUtil.isNotEmpty(collectionList) ? collectionList.size() : 0); - - MemberFootprintListDto memberFootprintListDto = new MemberFootprintListDto(); - memberFootprintListDto.setPageNow(1); - memberFootprintListDto.setPageSize(10); - List<FootprintListVo> footprintList = mallMemberFootprintService.findMemberFootprintList(memberFootprintListDto); - mallMemberVo.setFootprintCnt(CollUtil.isNotEmpty(footprintList) ? footprintList.size() : 0); - - List<MallMember> mallMembers = this.baseMapper.selectByRefererId(mallMember.getInviteId()); - mallMemberVo.setChildCnt(CollUtil.isNotEmpty(mallMembers) ? mallMembers.size() : 0); + RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, mallMemberVo.getLevel())); + mallMemberVo.setLevelName(runVip.getVipName()); + mallMemberVo.setLevelPng(runVip.getVipPng()); + mallMemberVo.setChangeState(runVip.getChangeState()); + mallMemberVo.setWithdrawState(runVip.getWithdrawState()); MallMemberWallet wallet = mallMemberWalletMapper.selectWalletByMemberId(mallMemberVo.getId()); - - MallVipConfig mallVipConfig = mallVipConfigMapper.selectVipConfigByCode(mallMember.getLevel()); - - mallMemberVo.setVipInfo(mallVipConfig); mallMemberVo.setBalance(wallet.getBalance()); -// mallMemberVo.setScore(wallet.getScore()); - mallMemberVo.setPrizeScore(wallet.getPrizeScore()); -// mallMemberVo.setTotalCost(mallOrderInfoMapper.selectTotalAmount(id)); + mallMemberVo.setScore(wallet.getScore()); return new FebsResponse().success().data(mallMemberVo); } @@ -348,7 +334,7 @@ mallMember.setAvatar(modifyMemberInfoDto.getPhoto()); } - this.baseMapper.updateById(mallMember); + this.baseMapper.updateNameAndAvatar(member.getId(),modifyMemberInfoDto.getName(),modifyMemberInfoDto.getPhoto()); return new FebsResponse().success().message("修改成功"); } @@ -360,17 +346,68 @@ } else { memberId = teamListDto.getId(); } - MallMember mallMember = this.baseMapper.selectById(memberId); - - List<TeamListVo> list = this.baseMapper.selectTeamListByInviteId(mallMember.getInviteId()); - + /** + * 直属三级 + */ MyTeamVo myTeamVo = new MyTeamVo(); - myTeamVo.setTeam(list); - myTeamVo.setMyAchieve(this.mallOrderInfoMapper.selectAmountOrTeamAmount(mallMember.getInviteId(), 1)); - myTeamVo.setMyTeamAchieve(this.mallOrderInfoMapper.selectAmountOrTeamAmount(mallMember.getInviteId(), 2)); - myTeamVo.setMyTeamCnt(this.baseMapper.selectAllChildAgentListByInviteId(mallMember.getInviteId()).size()); + //获取个人的碳币 + MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(memberId); + myTeamVo.setMyBalance(mallMemberWallet.getBalance()); + //全部直推 + List<MallMember> mallMembers = this.baseMapper.selectByRefererId(mallMember.getInviteId()); + /** + * 如果没有下级,那么直接返回当前用户的信息 + */ + if(CollUtil.isEmpty(mallMembers)){ + myTeamVo.setMyTeamCnt(0); + myTeamVo.setMyTeamBalance(BigDecimal.ZERO); + myTeamVo.setTeam(null); + return new FebsResponse().success().data(myTeamVo); + } + /** + * 如果有下级,获取所有的团队 + */ + myTeamVo.setMyTeamCnt(mallMembers.size()); + myTeamVo.setMyTeamBalance(getTeamBalance(mallMembers)); + + 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()); + if(CollUtil.isEmpty(mallMemberRefs)){ + item.setMyTeamCnt(0); + item.setMyTeamBalance(BigDecimal.ZERO); + }else{ + item.setMyTeamCnt(mallMemberRefs.size()); + //获取mallMembers的所有id + item.setMyTeamBalance(getTeamBalance(mallMemberRefs)); + } + }); + myTeamVo.setTeam(teamListVos); + + return new FebsResponse().success().data(myTeamVo); + } + + /** + * 获取团队余额 + * 该方法计算一组商城成员的总余额 + * 它首先提取成员ID,然后查询这些成员的钱包信息,并计算钱包余额的总和 + * + * @param mallMembers 商城成员列表,用于计算总余额 + * @return 团队的总余额,表示为BigDecimal类型 + */ + private BigDecimal getTeamBalance(List<MallMember> mallMembers) { + // 提取所有商城成员的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); } @Override @@ -384,12 +421,6 @@ Long id = LoginUserUtil.getLoginUser().getId(); moneyFlowDto.setMemberId(id); IPage<MoneyFlowVo> pages = mallMoneyFlowMapper.selectApiMoneyFlowInPage(page, moneyFlowDto); - -// if (moneyFlowDto.getFlowType() == 3) { -// pages.getRecords().forEach(item -> { -// item.setDescription(ScoreFlowTypeEnum.getDescByValue(item.getType())); -// }); -// } return new FebsResponse().success().data(pages); } @@ -408,55 +439,269 @@ mallMoneyFlowMapper.insert(flow); } + /** + * 处理VIP资金流水添加操作 + * 此方法用于在会员进行充值或扣费活动时,记录相应的资金流水信息 + * + * @param memberId 会员ID,标识进行资金操作的会员 + * @param rtMemberId 实体会员ID,用于关联现实中的会员身份 + * @param orderNo 订单编号,用于跟踪资金流水的来源订单 + * @param flowType 流水类型,指示资金流入或流出 + * @param type 交易类型,区分不同的交易场景 + * @param amount 金额,本次操作涉及的资金量 + * @param description 描述,简述本次资金操作的原因或场景 + * @param status 状态,表示资金操作的当前状态 + */ + @Override + public void runVipMoneyFlowAdd(Long memberId, Long rtMemberId, String orderNo,Integer flowType, Integer type, BigDecimal amount, String description, Integer status) { + // 创建一个新的商城资金流水对象 + MallMoneyFlow flow = new MallMoneyFlow(); + + // 设置资金流水的各项属性 + flow.setMemberId(memberId); + flow.setRtMemberId(rtMemberId); + flow.setOrderNo(orderNo); + flow.setFlowType(flowType); + flow.setType(type); + flow.setAmount(amount); + flow.setDescription(description); + flow.setStatus(status); + + // 插入资金流水记录到数据库 + mallMoneyFlowMapper.insert(flow); + } + @Override @Transactional(rollbackFor = Exception.class) public void transfer(TransferDto transferDto) { + Long memberId = LoginUserUtil.getLoginUser().getId(); MallMember mallMember = this.baseMapper.selectInfoByAccount(transferDto.getAccount()); if (mallMember == null) { throw new FebsException("用户不存在"); } - - Long memberId = LoginUserUtil.getLoginUser().getId(); MallMember loginMember = this.baseMapper.selectById(memberId); + + /** + * 用户的等级level是否允许兑换碳币 + */ + RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); + if(ObjectUtil.isEmpty(runVip) || runVip.getChangeState() != YesOrNoEnum.YES.getValue()){ + throw new FebsException("请先升级会员"); + } if (loginMember.getPhone().equals(transferDto.getAccount()) || loginMember.getInviteId().equals(transferDto.getAccount())) { throw new FebsException("不能给自己转账"); } if (StrUtil.isBlank(loginMember.getTradePassword())) { - throw new FebsException("未设置支付密码"); + throw new FebsException("未设置资金密码"); } if (!loginMember.getTradePassword().equals(SecureUtil.md5(transferDto.getTradePwd()))) { - throw new FebsException("支付密码错误"); + throw new FebsException("资金密码错误"); } - walletService.reduceBalance(transferDto.getAmount(), memberId); - String orderNo = MallUtils.getOrderNum("T"); - this.addMoneyFlow(memberId, transferDto.getAmount().negate(), MoneyFlowTypeEnum.TRANSFER.getValue(), orderNo, null, null, mallMember.getId(), null, FlowTypeEnum.BALANCE.getValue()); - + walletService.reduceBalance(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(), + transferDto.getAmount().negate(), + StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT_GIVE_FRIEND.getDescription(),mallMember.getInviteId(),transferDto.getAmount()), + YesOrNoEnum.YES.getValue() + ); walletService.addBalance(transferDto.getAmount(), mallMember.getId()); - this.addMoneyFlow(mallMember.getId(), transferDto.getAmount(), MoneyFlowTypeEnum.TRANSFER.getValue(), orderNo, null, null, memberId, null, FlowTypeEnum.BALANCE.getValue()); + + this.runVipMoneyFlowAdd( + mallMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.BALANCE.getValue(), + RunVipMoneyFlowTypeEnum.BALANCE_IN_GIVE_FRIEND.getValue(), + transferDto.getAmount(), + StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_IN_GIVE_FRIEND.getDescription(),loginMember.getInviteId(),transferDto.getAmount()), + YesOrNoEnum.YES.getValue() + ); } @Override - public void setPayment(MallMemberPayment mallMemberPayment) { - MallMember member = LoginUserUtil.getLoginUser(); + public void withdrawal(WithdrawalDto withdrawalDto) { + Long memberId = LoginUserUtil.getLoginUser().getId(); + MallMember loginMember = this.baseMapper.selectById(memberId); + /** + * 用户的等级level是否允许兑换碳币 + */ + RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); + if(ObjectUtil.isEmpty(runVip) || runVip.getWithdrawState() != YesOrNoEnum.YES.getValue()){ + throw new FebsException("请先升级会员"); + } - MallMemberPayment exist = mallMemberPaymentMapper.selectByMemberId(member.getId()); - if (exist == null) { + 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 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); + if(minCnt.compareTo(withdrawalDto.getAmount()) > 0){ + throw new FebsException(minCnt+"碳币起提"); + } + + BigDecimal balanceToCoin = new BigDecimal( + dataDictionaryCustomMapper.selectDicDataByTypeAndCode( + RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN.getType(), + RunVipDataDictionaryEnum.RUN_VIP_BALANCE_TO_COIN.getCode()).getValue() + ).setScale(2, BigDecimal.ROUND_DOWN); + 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); + /** + * 减少碳币,增加进行中提现记录 + */ + 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); + withdraw.setMemberId(loginMember.getId()); + withdraw.setAmount(withdrawalAmountReal); + withdraw.setStatus(YesOrNoEnum.ING.getValue()); + withdraw.setAmountFee(fee); + withdraw.setName(mallMemberPayment.getBank()); + withdraw.setType(mallMemberPayment.getBankNo()); + mallMemberWithdrawMapper.insert(withdraw); + + walletService.reduceBalance(withdrawalDto.getAmount(), loginMember.getId()); + this.runVipMoneyFlowAdd( + loginMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.BALANCE.getValue(), + RunVipMoneyFlowTypeEnum.BALANCE_OUT.getValue(), + withdrawalDto.getAmount().negate(), + StrUtil.format(RunVipMoneyFlowTypeEnum.BALANCE_OUT.getDescription(),withdrawalDto.getAmount(),withdrawalAmount,fee), + YesOrNoEnum.ING.getValue() + ); + + } + + @Override + public void commissionChange(CommissionChangeDto commissionChange) { + Long memberId = LoginUserUtil.getLoginUser().getId(); + BigDecimal minScore = new BigDecimal( + dataDictionaryCustomMapper.selectDicDataByTypeAndCode( + RunVipDataDictionaryEnum.RUN_VIP_SCORE_MIN.getType(), + RunVipDataDictionaryEnum.RUN_VIP_SCORE_MIN.getCode()).getValue() + ).setScale(0, BigDecimal.ROUND_DOWN); + if(minScore.compareTo(commissionChange.getAmount()) > 0){ + throw new FebsException("碳积分不足"+minScore); + } + + MallMember loginMember = this.baseMapper.selectById(memberId); + if (StrUtil.isBlank(loginMember.getTradePassword())) { + throw new FebsException("未设置资金密码"); + } + if (!loginMember.getTradePassword().equals(SecureUtil.md5(commissionChange.getTradePwd()))) { + throw new FebsException("资金密码错误"); + } + /** + * 用户的等级level是否允许兑换碳币 + */ + RunVip runVip = runVipMapper.selectOne(new LambdaQueryWrapper<RunVip>().eq(RunVip::getVipCode, loginMember.getLevel())); + if(ObjectUtil.isEmpty(runVip) || runVip.getChangeState() != YesOrNoEnum.YES.getValue()){ + throw new FebsException("请先升级会员"); + } + + BigDecimal scoreBalancePercent = new BigDecimal( + dataDictionaryCustomMapper.selectDicDataByTypeAndCode( + RunVipDataDictionaryEnum.RUN_VIP_SCORE_TO_BALANCE.getType(), + RunVipDataDictionaryEnum.RUN_VIP_SCORE_TO_BALANCE.getCode()).getValue() + ).setScale(2, BigDecimal.ROUND_DOWN); + BigDecimal score = commissionChange.getAmount(); + BigDecimal balance = commissionChange.getAmount().multiply(scoreBalancePercent).setScale(2, BigDecimal.ROUND_DOWN); + + walletService.reduceScore(score, loginMember.getId()); + String orderNo = MallUtils.getOrderNum("DH"); + this.runVipMoneyFlowAdd( + loginMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.SCORE.getValue(), + RunVipMoneyFlowTypeEnum.SCORE_OUT_BALANCE.getValue(), + score.negate(), + StrUtil.format(RunVipMoneyFlowTypeEnum.SCORE_OUT_BALANCE.getDescription(),score,balance), + YesOrNoEnum.YES.getValue() + ); + + walletService.addBalance(balance, loginMember.getId()); + this.runVipMoneyFlowAdd( + loginMember.getId(), + loginMember.getId(), + orderNo, + FlowTypeEnum.BALANCE.getValue(), + RunVipMoneyFlowTypeEnum.SCORE_OUT_BALANCE_IN.getValue(), + balance, + StrUtil.format(RunVipMoneyFlowTypeEnum.SCORE_OUT_BALANCE_IN.getDescription(),score,balance), + YesOrNoEnum.YES.getValue() + ); + } + + @Override + public void setPayment(ApiMallMemberPaymentDto apiMallMemberPaymentDto) { + + MallMember member = LoginUserUtil.getLoginUser(); + if(null == apiMallMemberPaymentDto.getId()){//新增 + List<MallMemberPayment> mallMemberPayments = mallMemberPaymentMapper.selectList( + new LambdaQueryWrapper<MallMemberPayment>().eq(MallMemberPayment::getBank, apiMallMemberPaymentDto.getBank())); + if(CollUtil.isNotEmpty(mallMemberPayments)){ + throw new FebsException("地址已使用"); + } + MallMemberPayment mallMemberPayment = new MallMemberPayment(); mallMemberPayment.setMemberId(member.getId()); + mallMemberPayment.setBankNo(apiMallMemberPaymentDto.getBankNo()); + mallMemberPayment.setBank(apiMallMemberPaymentDto.getBank()); mallMemberPaymentMapper.insert(mallMemberPayment); - } else { - mallMemberPayment.setId(exist.getId()); + }else{ + List<MallMemberPayment> mallMemberPayments = mallMemberPaymentMapper.selectList( + new LambdaQueryWrapper<MallMemberPayment>().eq(MallMemberPayment::getBank, apiMallMemberPaymentDto.getBank())); + if(CollUtil.isNotEmpty(mallMemberPayments) && mallMemberPayments.size() > 1){ + throw new FebsException("地址已使用"); + } + MallMemberPayment mallMemberPayment = mallMemberPaymentMapper.selectById(apiMallMemberPaymentDto.getId()); + mallMemberPayment.setMemberId(member.getId()); + mallMemberPayment.setBankNo(apiMallMemberPaymentDto.getBankNo()); + mallMemberPayment.setBank(apiMallMemberPaymentDto.getBank()); mallMemberPaymentMapper.updateById(mallMemberPayment); } } @Override - public MallMemberPayment findMemberPayment() { + public List<MallMemberPayment> findMemberPayment() { MallMember member = LoginUserUtil.getLoginUser(); - return mallMemberPaymentMapper.selectByMemberId(member.getId()); + List<MallMemberPayment> mallMemberPayments = mallMemberPaymentMapper.selectList(new LambdaQueryWrapper<MallMemberPayment>().eq(MallMemberPayment::getMemberId, member.getId())); + return mallMemberPayments; + } + + @Override + public void delPayment(ApiMallMemberPaymentDto mallMemberPayment) { + MallMember member = LoginUserUtil.getLoginUser(); + mallMemberPaymentMapper.deleteById(mallMemberPayment.getId()); } @Override @@ -622,7 +867,6 @@ mallMember = new MallMember(); mallMember.setAccountStatus(MallMember.ACCOUNT_STATUS_ENABLE); mallMember.setAccountType(MallMember.ACCOUNT_TYPE_NORMAL); - mallMember.setLevel(AgentLevelEnum.ZERO_LEVEL.name()); mallMember.setOpenId(openId); mallMember.setSessionKey(sessionKey); @@ -726,7 +970,7 @@ } List<MallVipConfig> configs = mallVipConfigMapper.selectVipConfigList(); - if (CollUtil.isNotEmpty(configs)) { + if (StrUtil.isBlank(mallMember.getLevel()) && CollUtil.isNotEmpty(configs)) { MallVipConfig mallVipConfig = configs.get(0); mallMember.setLevel(mallVipConfig.getCode()); } @@ -751,7 +995,6 @@ mallMember.setPhone(phone); mallMember.setAccountStatus(MallMember.ACCOUNT_STATUS_ENABLE); mallMember.setAccountType(MallMember.ACCOUNT_TYPE_NORMAL); - mallMember.setLevel(AgentLevelEnum.ZERO_LEVEL.name()); this.baseMapper.insert(mallMember); String inviteId = ShareCodeUtil.toSerialCode(mallMember.getId()); @@ -1006,7 +1249,10 @@ Long memberId = LoginUserUtil.getLoginUser().getId(); mallMemberCouponDto.setMemberId(memberId); mallMemberCouponDto.setExpireTime(DateUtil.date()); - List<Long> couponIds = couponGoodsMapper.selectByGoodId(mallMemberCouponDto.getGoodsId()); +// List<Long> couponIds = couponGoodsMapper.selectByGoodId(mallMemberCouponDto.getGoodsId()); + List<Long> goodsIdList = mallMemberCouponDto.getGoodsIdList(); + List<Long> couponIds = couponGoodsMapper.selectByGoodIdList(goodsIdList); + List<MallMemberCouponVo> mallMemberCouponVos = new ArrayList<>(); if(CollUtil.isNotEmpty(couponIds)){ mallMemberCouponVos = mallMemberCouponMapper.selectListCreateInPage(mallMemberCouponDto,couponIds); @@ -1087,6 +1333,8 @@ MallMember member = this.baseMapper.selectById(loginUser.getId()); + this.baseMapper.updateLastLogin(member.getId(),new Date()); + DataDictionaryCustom dic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(DataDictionaryEnum.UNALIVE_COUPON.getType(), DataDictionaryEnum.UNALIVE_COUPON.getCode()); if (dic == null || StrUtil.isBlank(dic.getValue())) { return new HashMap<>(); @@ -1104,11 +1352,32 @@ List<Long> couponIds = list.stream().filter(item -> { return item.getDay() <= days && item.getCouponId() != null; }).map(VipSettingUnAliveSettingBo::getCouponId).collect(Collectors.toList()); + if (CollUtil.isEmpty(couponIds)) { + return new HashMap<>(); + } LambdaQueryWrapper<MallGoodsCoupon> query = new LambdaQueryWrapper<>(); query.in(MallGoodsCoupon::getId, couponIds) .eq(MallGoodsCoupon::getState, 2); List<MallGoodsCoupon> coupons = mallGoodsCouponMapper.selectList(query); + + LambdaQueryWrapper<MallMemberCoupon> memberCouponQuery = new LambdaQueryWrapper<>(); + memberCouponQuery.in(MallMemberCoupon::getCouponId, couponIds) + .eq(MallMemberCoupon::getMemberId, member.getId()) + .eq(MallMemberCoupon::getFromType, 3) + .ge(MallMemberCoupon::getCreatedTime, DateUtil.beginOfDay(new Date())) + .le(MallMemberCoupon::getCreatedTime, DateUtil.endOfDay(new Date())); + List<MallMemberCoupon> mallMemberCoupons = mallMemberCouponMapper.selectList(memberCouponQuery); + if (CollUtil.isNotEmpty(mallMemberCoupons)) { + Map<Long, MallMemberCoupon> map = mallMemberCoupons.stream().collect(Collectors.toMap(MallMemberCoupon::getCouponId, MallMemberCoupon -> MallMemberCoupon)); + coupons = coupons.stream().filter(item -> { + return map.get(item.getId()) == null; + }).collect(Collectors.toList()); + } + + if (CollUtil.isEmpty(coupons)) { + return new HashMap<>(); + } coupons.forEach(item -> { MallMemberCoupon memberCoupon = new MallMemberCoupon(); @@ -1117,20 +1386,253 @@ memberCoupon.setInviteId(member.getInviteId()); memberCoupon.setCouponUuid(IdUtil.simpleUUID()); memberCoupon.setState(1); + memberCoupon.setFromType(3); memberCoupon.setExpireTime(DateUtil.offsetDay(DateUtil.date(), item.getExpireDay())); memberCoupon.setMemberId(member.getId()); mallMemberCouponMapper.insert(memberCoupon); }); - MallMember mallMember = new MallMember(); - mallMember.setId(member.getId()); - mallMember.setLastLoginTime(new Date()); - this.baseMapper.updateById(mallMember); - Map<String, Object> result = new HashMap<>(); result.put("coupon", coupons); return result; } + @Override + public FebsResponse storeList(MallStoreDto mallStoreDto) { + QueryWrapper<MallStore> mallStoreQueryWrapper = new QueryWrapper<>(); + if(StrUtil.isNotEmpty(mallStoreDto.getName())){ + mallStoreQueryWrapper.like("name",mallStoreDto.getName()); + } + List<MallStore> mallStores = mallStoreMapper.selectList(mallStoreQueryWrapper); + List<MallStoreVo> mallStoreVos = MallStoreConversion.INSTANCE.entitysToVos(mallStores); + return new FebsResponse().success().data(mallStoreVos); + } + + @Override + public FebsResponse storeItemList(MallStoreItemDto mallStoreItemDto) { + QueryWrapper<MallStoreItem> mallStoreQueryWrapper = new QueryWrapper<>(); + mallStoreQueryWrapper.like("store_id",mallStoreItemDto.getStoreId()); + List<MallStoreItem> mallStores = mallStoreItemMapper.selectList(mallStoreQueryWrapper); + return new FebsResponse().success().data(mallStores); + } + + @Override + public FebsResponse bindStoreMember(BindStoreMemberDto bindStoreMemberDto) { + Long memberId = LoginUserUtil.getLoginUser().getId(); + Long storeItemId = bindStoreMemberDto.getStoreItemId(); + + QueryWrapper<MallStoreMember> objectQueryWrapper = new QueryWrapper<>(); + objectQueryWrapper.eq("member_id",memberId); + List<MallStoreMember> mallStoreMembers = mallStoreMemberMapper.selectList(objectQueryWrapper); + if(CollUtil.isNotEmpty(mallStoreMembers)){ + mallStoreMemberMapper.delete(objectQueryWrapper); + } + + MallMember mallMember = this.baseMapper.selectById(memberId); + Integer sex = "女".equals(mallMember.getSex()) ? 3 : 2; + + MallStoreItem mallStoreItem = mallStoreItemMapper.selectById(storeItemId); + HashMap<String, String> objectObjectHashMap = new HashMap<>(); + String shopAccount = mallStoreItem.getAccount(); + String shopPwd = mallStoreItem.getPassword(); + String name = bindStoreMemberDto.getName(); + String address = bindStoreMemberDto.getAddress(); + Integer age = bindStoreMemberDto.getAge(); + String phoneNumber = bindStoreMemberDto.getPhone(); + + objectObjectHashMap.put("shopAccount",shopAccount); + objectObjectHashMap.put("shopPwd",shopPwd); + objectObjectHashMap.put("name",name); + objectObjectHashMap.put("address",address); + objectObjectHashMap.put("age",age.toString()); + objectObjectHashMap.put("phoneNumber",phoneNumber); + objectObjectHashMap.put("sex",sex.toString()); + + //sign= MD5(address+age+name+phoneNumber+shopAccount+shopPwd) + StringBuffer stringBuffer = new StringBuffer(); + stringBuffer.append(address); + stringBuffer.append(age); + stringBuffer.append(name); + stringBuffer.append(phoneNumber); + stringBuffer.append(sex); + stringBuffer.append(shopAccount); + stringBuffer.append(shopPwd); + String sign = MD5.MD5Encode(stringBuffer.toString()); + objectObjectHashMap.put("sign",sign); + String url = "https://data.muchun.co/api/bindCustomer"; + String result = HttpCurlUtil.sendPost(url, objectObjectHashMap); + Integer retCode = JSONUtil.parseObj(result).getInt("retCode"); + String message = JSONUtil.parseObj(result).getStr("message"); + if(0 != retCode || !"绑定成功".equals(message)){ + return new FebsResponse().fail().message(message); + } + Long bindId = JSONUtil.parseObj(result).getJSONObject("data").getLong("userId"); + + MallStoreMember mallStoreMember = new MallStoreMember(); + mallStoreMember.setMemberId(memberId); + mallStoreMember.setBindId(bindId); + mallStoreMember.setStoreId(mallStoreItem.getStoreId()); + mallStoreMember.setStoreItemId(mallStoreItem.getId()); + + mallStoreMember.setAccount(shopAccount); + mallStoreMember.setPassword(shopPwd); + + mallStoreMember.setName(name); + mallStoreMember.setAddress(address); + mallStoreMember.setAge(age); + mallStoreMember.setPhone(phoneNumber); + mallStoreMemberMapper.insert(mallStoreMember); + return new FebsResponse().success().message("绑定成功"); + } + + @Override + public FebsResponse bindList() { + Long memberId = LoginUserUtil.getLoginUser().getId(); + QueryWrapper<MallStoreMember> objectQueryWrapper = new QueryWrapper<>(); + objectQueryWrapper.eq("member_id",memberId); + List<MallStoreMember> mallStoreMembers = mallStoreMemberMapper.selectList(objectQueryWrapper); + + ArrayList<MallStoreMemberVo> mallStoreMemberVos = new ArrayList<>(); + for(MallStoreMember mallStoreMember : mallStoreMembers){ + MallStoreMemberVo mallStoreMemberVo = new MallStoreMemberVo(); + Long storeId = mallStoreMember.getStoreId(); + Long storeItemId = mallStoreMember.getStoreItemId(); + MallStore mallStore = mallStoreMapper.selectById(storeId); + MallStoreItem mallStoreItem = mallStoreItemMapper.selectById(storeItemId); + mallStoreMemberVo.setId(mallStoreMember.getId()); + mallStoreMemberVo.setBindInfo(mallStore.getName()+"-"+mallStoreItem.getCode()); + mallStoreMemberVos.add(mallStoreMemberVo); + } + return new FebsResponse().success().data(mallStoreMemberVos); + } + + @Override + public FebsResponse bindResult(BindResultDto bindResultDto) { + Long memberId = LoginUserUtil.getLoginUser().getId(); + MallStoreMember mallStoreMember = mallStoreMemberMapper.selectById(bindResultDto.getBindId()); + Long userld = mallStoreMember.getBindId(); + String shopAccount = mallStoreMember.getAccount(); + String shopPwd = mallStoreMember.getPassword(); + + HashMap<String, String> objectObjectHashMap = new HashMap<>(); + + objectObjectHashMap.put("shopAccount",shopAccount); + objectObjectHashMap.put("shopPwd",shopPwd); + objectObjectHashMap.put("userId",userld.toString()); + + //sign= MD5(shopAccount+shopPwd+userId) + StringBuffer stringBuffer = new StringBuffer(); + stringBuffer.append(shopAccount); + stringBuffer.append(shopPwd); + stringBuffer.append(userld); + String sign = MD5.MD5Encode(stringBuffer.toString()); + objectObjectHashMap.put("sign",sign); + + String url = "https://data.muchun.co/api/getCustomerCheckRecords"; + String result = HttpCurlUtil.sendPost(url, objectObjectHashMap); + Integer retCode = JSONUtil.parseObj(result).getInt("retCode"); + String message = JSONUtil.parseObj(result).getStr("message"); + if(0 != retCode){ + return new FebsResponse().fail().message(message); + } + JSONArray data = JSONUtil.parseObj(result).getJSONArray("data"); + return new FebsResponse().success().data(data); + } + + + public static String hidePhoneNumber(String phoneNumber) { + // 获取前3位和后4位 + String prefix = phoneNumber.substring(0, 3); + // 生成隐藏的电话号码 + return prefix + "****"; + } + + @Override + public List<ApiChartVo> dayRecord(ApiRecordDto apiRecordDto) { + /** + * 1:日榜 2:月榜 + * 获取当前日期 + */ + LambdaQueryWrapper<MallMoneyFlow> mallMoneyFlowLambdaQueryWrapper = new LambdaQueryWrapper<>(); + if(apiRecordDto.getType() == 1){ + DateTime dateTime = DateUtil.beginOfDay(DateUtil.date()); + mallMoneyFlowLambdaQueryWrapper.ge(MallMoneyFlow :: getCreatedTime , dateTime); + }else{ + DateTime dateTime = DateUtil.beginOfMonth(DateUtil.date()); + mallMoneyFlowLambdaQueryWrapper.ge(MallMoneyFlow :: getCreatedTime , dateTime); + } + mallMoneyFlowLambdaQueryWrapper.eq(MallMoneyFlow :: getFlowType, FlowTypeEnum.SCORE.getValue()); + mallMoneyFlowLambdaQueryWrapper.in( + MallMoneyFlow :: getType, + RunVipMoneyFlowTypeEnum.GET_SCORE.getValue(), + RunVipMoneyFlowTypeEnum.SYS_SCORE.getValue() + ); + List<MallMoneyFlow> mallMoneyFlows = mallMoneyFlowMapper.selectList(mallMoneyFlowLambdaQueryWrapper); + + List<ApiChartVo> apiChartVos = new ArrayList<>(); + if(CollUtil.isEmpty(mallMoneyFlows)){ + return apiChartVos; + } + // 使用 Stream API 按照 memberId 分组,并计算每个 memberId 的 amount 绝对值之和 + Map<Long, BigDecimal> sumByMemberId = mallMoneyFlows.stream() + .collect(Collectors.groupingBy( + MallMoneyFlow::getMemberId, + Collectors.reducing(BigDecimal.ZERO, MallMoneyFlow::getAmount, BigDecimal::add) + )).entrySet().stream() + .collect(Collectors.toMap( + Map.Entry::getKey, + entry -> entry.getValue().abs() // 计算绝对值 + )); + + // 对 Map 按照 amount 的绝对值之和从大到小排序,并取前十个结果 + List<Map.Entry<Long, BigDecimal>> sortedList = sumByMemberId.entrySet().stream() + .sorted((entry1, entry2) -> entry2.getValue().compareTo(entry1.getValue())) + .limit(10) + .collect(Collectors.toList()); + sortedList.forEach(entry -> { + ApiChartVo apiChartVo = new ApiChartVo(); + MallMember mallMember = this.baseMapper.selectById(entry.getKey()); + apiChartVo.setName(hidePhoneNumber(mallMember.getName())); + apiChartVo.setAvatar(mallMember.getAvatar()); + apiChartVo.setScore(entry.getValue()); + apiChartVos.add(apiChartVo); + }); + return apiChartVos; + } + + public static void main(String[] args) { + Long userld = 173L; + String shopAccount = "luohu"; + String shopPwd = "123456"; + + HashMap<String, String> objectObjectHashMap = new HashMap<>(); + + objectObjectHashMap.put("shopAccount",shopAccount); + objectObjectHashMap.put("shopPwd",shopPwd); + objectObjectHashMap.put("userId",userld.toString()); + + //sign= MD5(shopAccount+shopPwd+userId) + StringBuffer stringBuffer = new StringBuffer(); + stringBuffer.append(shopAccount); + stringBuffer.append(shopPwd); + stringBuffer.append(userld); + String sign = MD5.MD5Encode(stringBuffer.toString()); + objectObjectHashMap.put("sign",sign); + + System.out.println(sign); + + System.out.println(objectObjectHashMap); + String url = "https://data.muchun.co/api/getCustomerCheckRecords"; + String result = HttpCurlUtil.sendPost(url, objectObjectHashMap); + Integer retCode = JSONUtil.parseObj(result).getInt("retCode"); + String message = JSONUtil.parseObj(result).getStr("message"); + if(0 != retCode){ + System.out.println(message); + } + + JSONArray data = JSONUtil.parseObj(result).getJSONArray("data"); + System.out.println(data); + } + } -- Gitblit v1.9.1