package cc.mrbird.febs.mall.service.impl; import cc.mrbird.febs.common.enumerates.*; import cc.mrbird.febs.common.utils.AppContants; import cc.mrbird.febs.common.utils.MallUtils; import cc.mrbird.febs.mall.entity.*; import cc.mrbird.febs.mall.mapper.*; import cc.mrbird.febs.mall.service.*; import cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo; import cc.mrbird.febs.mall.vo.AdminTeamEqualsPerkVo; import cc.mrbird.febs.rabbit.producter.AgentProducer; import cc.mrbird.febs.system.mapper.UserMapper; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.date.DateTime; import cn.hutool.core.date.DateUtil; import cn.hutool.core.math.MathUtil; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import cn.hutool.json.JSONUtil; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.SqlSession; import org.mybatis.spring.SqlSessionTemplate; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; /** * @author wzy * @date 2021-09-26 **/ @Slf4j @Service @RequiredArgsConstructor public class AgentServiceImpl implements IAgentService { private final DataDictionaryCustomMapper dataDictionaryCustomMapper; private final MallMemberMapper memberMapper; private final MallAchieveRecordMapper mallAchieveRecordMapper; private final MallOrderInfoMapper mallOrderInfoMapper; private final IApiMallMemberWalletService iApiMallMemberWalletService; private final IMallMoneyFlowService mallMoneyFlowService; private final MallMemberWalletMapper mallMemberWalletMapper; private final SqlSessionTemplate sqlSessionTemplate; private final IApiMallMemberWalletService memberWalletService; private final MallMoneyFlowMapper mallMoneyFlowMapper; private final MallMqRecordMapper mallMqRecordMapper; private final MallGoodsMapper mallGoodsMapper; private final ICommonService commonService; private final MallProductBuyRecordMapper mallProductBuyRecordMapper; private final MallProductBuyMapper mallProductBuyMapper; private final MallProductSellMapper mallProductSellMapper; private final MallProductSellRecordMapper mallProductSellRecordMapper; private final MallProductNftMapper mallProductNftMapper; private final AgentProducer agentProducer; private final MallMemberAmountMapper mallMemberAmountMapper; @Override @Transactional(rollbackFor = Exception.class) public void autoUpAgentLevel(Long memberId) { MallMember member = memberMapper.selectById(memberId); if(StrUtil.isBlank(member.getReferrerIds())) { return; } List ids = StrUtil.split(member.getReferrerIds(), ','); List parentMembers = memberMapper.selectByInviteIds(ids); for (MallMember parent : parentMembers) { // 没有购买套餐无法升级合伙人等级 if (AgentLevelEnum.ZERO_LEVEL.name().equals(member.getLevel())) { continue; } //合伙人的下一个层级 String parentLevel = parent.getLevel(); String nextLevel = MemberLevelEnum.SECOND_LEVEL.getNextLevel(parentLevel); if (parentLevel.equals(nextLevel)) { log.info("当前层级无下一级:{}", parent.getLevel()); continue; } DataDictionaryCustom nextLevelDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode("AGENT_LEVEL_REQUIRE", nextLevel); AgentInfo agentInfo = JSONObject.parseObject(nextLevelDic.getValue(), AgentInfo.class); if (!directMemberCnt(parent, agentInfo)) { continue; } if (!agentCntFinish(parent, agentInfo)) { continue; } if (!teamIncome(parent, agentInfo)) { continue; } parent.setLevel(nextLevel); memberMapper.updateById(parent); } } /** * 判断直推人数是否达标 * * @param member * @return */ private boolean directMemberCnt(MallMember member, AgentInfo agentInfo) { List childs = memberMapper.selectByRefererId(member.getInviteId()); if (CollUtil.isEmpty(childs)) { return false; } if (childs.size() >= agentInfo.getDirectCnt()) { return true; } log.info("用户:{}直推数量未达标, 当前等级:{}, 当前数量:{}, 目标数量:{}", member.getPhone(), member.getLevel(), childs.size(), agentInfo.getDirectCnt()); return false; } /** * 判断下级代理数量是否达标 * * @return */ private boolean agentCntFinish(MallMember member, AgentInfo agentInfo) { if (agentInfo.getLastAgentCnt() == null || agentInfo.getLastAgentCnt() == 0) { return true; } // 直推用户 List directMember = memberMapper.selectByRefererId(member.getInviteId()); if (CollUtil.isEmpty(directMember)) { return false; } // 用户团队达到指定代理数量,且都不在同一条线 int i = 0; for (MallMember child : directMember) { List mallMembers = memberMapper.selectChildAgentList(child.getInviteId(), member.getLevel()); if (CollUtil.isNotEmpty(mallMembers)) { i++; } } if (i >= agentInfo.getLastAgentCnt()) { return true; } log.info("用户:{}代理数量未达标, 当前等级:{}, 当前数量:{}, 目标数量:{}", member.getPhone(), member.getLevel(), i, agentInfo.getLastAgentCnt()); return false; } /** * 团队贡献点是否达标 * * @param agentInfo * @return */ private boolean teamIncome(MallMember member, AgentInfo agentInfo) { List mallMembers = memberMapper.selectAllChildAgentListByInviteId(member.getInviteId()); List ids = mallMembers.stream().map(MallMember::getId).collect(Collectors.toList()); List mallMemberWallets = mallMemberWalletMapper.selectMemberWalletsByIds(ids); int starSum = mallMemberWallets.stream().mapToInt(MallMemberWallet::getStar).sum(); BigDecimal teamIncome = agentInfo.getTeamIncome(); if (teamIncome.compareTo(new BigDecimal(starSum)) <= 0) { return true; } log.info("用户:{}团队贡献点未达标, 当前等级:{}, 当前数量:{}, 目标数量:{}", member.getPhone(), member.getLevel(), starSum, teamIncome); return false; } @Override @Transactional(rollbackFor = Exception.class) public void returnMoneyToAgent(Long orderId) { } @Override public void rankReturnMoney(Long orderId) { } @Override @Transactional(rollbackFor = Exception.class) public void perkMoneyConsumer(long orderId) { long start = System.currentTimeMillis(); MallOrderInfo mallOrderInfo = mallOrderInfoMapper.selectById(orderId); if(ObjectUtil.isEmpty(mallOrderInfo)){ return; } // if(2 != mallOrderInfo.getStatus()){ // return; // } BigDecimal amount = BigDecimal.ZERO; List orderItems = this.mallOrderInfoMapper.getMallOrderItemByOrderId(orderId); if (CollUtil.isNotEmpty(orderItems)) { for (MallOrderItem orderItem : orderItems) { MallGoods mallGoods = mallGoodsMapper.selectById(orderItem.getGoodsId()); if (mallGoods.getIsNormal() == 2) { amount = amount.add( new BigDecimal(mallGoods.getPresentPrice()) .multiply(new BigDecimal(orderItem.getCnt())) .abs() .setScale(2,BigDecimal.ROUND_DOWN)); } } } amount = amount.subtract(mallOrderInfo.getScoreAmount()); if(BigDecimal.ZERO.compareTo(amount) >= 0){ return; } /** * 分享补贴 直推消费额10% */ Long memberId = mallOrderInfo.getMemberId(); MallMember mallMember = memberMapper.selectById(memberId); //补贴对象 直属上级 MallMember mallMemberUp = memberMapper.selectInfoByInviteId(mallMember.getReferrerId()); if(ObjectUtil.isNotEmpty(mallMemberUp)){ //分享补贴百分比 DataDictionaryCustom sharePerkDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.SHARE_PERK.getType(), DataDictionaryEnum.SHARE_PERK.getCode()); String sharePerk = ObjectUtil.isEmpty(sharePerkDic.getValue()) ? "0" : sharePerkDic.getValue(); BigDecimal sharePerkPercent = new BigDecimal(sharePerk).abs().divide(new BigDecimal(100)); //分享补贴金额 BigDecimal sharePerkAmount = amount.multiply(sharePerkPercent).setScale(2, BigDecimal.ROUND_DOWN);; //所有合伙人补贴至消费礼包的三倍额度需要复购一次。 MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(mallMemberUp.getId()); BigDecimal totalScore = mallMemberWallet.getTotalScore(); if(totalScore.compareTo(sharePerkAmount) < 0){ sharePerkAmount = totalScore; } if(BigDecimal.ZERO.compareTo(sharePerkAmount) < 0){ //减少补贴额度 mallMemberWalletMapper.reduceTotalScoreById(sharePerkAmount, mallMemberWallet.getId()); reduceStar(mallMemberUp.getId(),sharePerkAmount); mallMemberWalletMapper.addBalanceById(sharePerkAmount, mallMemberWallet.getId()); mallMoneyFlowService.addMoneyFlow( mallMemberUp.getId(), sharePerkAmount, MoneyFlowTypeEnum.DYNAMIC_ACHIEVE.getValue(), mallOrderInfo.getOrderNo(), "直推奖", "补贴额度:"+totalScore, memberId, 2, FlowTypeEnum.BALANCE.getValue(), 1); } } /** * 星级奖励 * 从最顶级级别的合伙人开始补贴 * 补贴完,把已经补贴的合伙人加入下一个级别 */ DataDictionaryCustom perkAgentAchieveTotalDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getType(), DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getCode()); BigDecimal perkAgentAchieveTotal = new BigDecimal(perkAgentAchieveTotalDic.getValue()); //星级奖励百分比等于每个级别的累计之和 List starPerkDics = dataDictionaryCustomMapper.selectDicByType( "AGENT_LEVEL_REQUIRE"); BigDecimal totalProfitProp = BigDecimal.ZERO; if(CollUtil.isNotEmpty(starPerkDics)){ for(DataDictionaryCustom starPerkDic : starPerkDics){ String starPerkStr = starPerkDic.getValue(); AgentInfo agentInfo = JSONObject.parseObject(starPerkStr, AgentInfo.class); BigDecimal profitProp = agentInfo.getProfitProp().abs().divide(new BigDecimal(100)); String code = starPerkDic.getCode(); //存在当前级别的会员,则加上这个比例的补贴 List mallMembers = memberMapper.selectByLevel(code); if(CollUtil.isNotEmpty(mallMembers)){ totalProfitProp = totalProfitProp.add(profitProp); } } } if(totalProfitProp.compareTo(BigDecimal.ZERO) > 0){ BigDecimal perkTotal = amount.multiply(totalProfitProp).setScale(2,BigDecimal.ROUND_DOWN); perkAgentAchieveTotal = perkAgentAchieveTotal.add(perkTotal); perkAgentAchieveTotalDic.setValue(perkAgentAchieveTotal.toString()); dataDictionaryCustomMapper.updateById(perkAgentAchieveTotalDic); } // List sevenLevelRecord = getStarRecord(null, MemberLevelEnum.SEVEN_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_SEVEN.getValue()); // List sixLevelRecord = getStarRecord(sevenLevelRecord, MemberLevelEnum.SIX_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_SIX.getValue()); // List fifthLevelRecord = getStarRecord(sixLevelRecord, MemberLevelEnum.FIFTH_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_FIVE.getValue()); // List fourLevelRecord = getStarRecord(fifthLevelRecord, MemberLevelEnum.FOUR_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_FOUR.getValue()); // List thirdLevelRecord = getStarRecord(fourLevelRecord, MemberLevelEnum.THIRD_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_THREE.getValue()); // List secondLevelRecord = getStarRecord(thirdLevelRecord, MemberLevelEnum.SECOND_LEVEL.name(), amount, mallOrderInfo.getOrderNo(), memberId,MoneyFlowTypeEnum.STAR_PERK_TWO.getValue()); /** * 团队补贴 */ //团队补贴百分比 DataDictionaryCustom teamPerkDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.TEAM_PERK.getType(), DataDictionaryEnum.TEAM_PERK.getCode()); String teamPerk = ObjectUtil.isEmpty(teamPerkDic.getValue()) ? "0" : teamPerkDic.getValue(); BigDecimal teamPerkPercent = new BigDecimal(teamPerk).abs().divide(new BigDecimal(100)); //分享补贴金额 BigDecimal teamPerkAmount = amount.multiply(teamPerkPercent); //团队补贴对象 List mallMemberTeamPerkList = mallMemberTeamPerkListInfo(memberId); if(CollUtil.isNotEmpty(mallMemberTeamPerkList)){ List mallMemberTeamPerkIds = mallMemberTeamPerkList.stream().map(MallMember::getId).collect(Collectors.toList()); List mallMemberWallets = mallMemberWalletMapper.selectMemberWalletsByIds(mallMemberTeamPerkIds); flowTotalScoreBalance( mallMemberWallets, teamPerkAmount, MoneyFlowTypeEnum.TEAM_PERK.getValue(), mallOrderInfo.getOrderNo(), memberId ); } long end = System.currentTimeMillis(); log.info("============订单:{},时间:{}===========",mallOrderInfo.getOrderNo(),(end - start)/1000); MallMqRecord mallMqRecord = mallMqRecordMapper.selectByOrderId(orderId); if(ObjectUtil.isNotEmpty(mallMqRecord)){ mallMqRecord.setState(1); mallMqRecordMapper.updateById(mallMqRecord); } } /** * 下单人所在团队里面的已经存在的各个等级的会员集合里面的第一个会员获取2% */ public List mallMemberTeamPerkListInfo(Long memberId){ List mallMemberTeamPerk = new ArrayList<>(); MallMember mallMember = memberMapper.selectById(memberId); List ids = StrUtil.split(mallMember.getReferrerIds(), ','); if(CollUtil.isNotEmpty(ids)){ List mallMembers = memberMapper.selectByInviteIds(ids); /** * 根据等级分组,获取对应的<级别,会员数组>map */ Map> collect = mallMembers.stream().collect(Collectors.groupingBy(MallMember::getLevel)); Set set = collect.keySet(); // 得到所有key的集合 for (String key : set) { /** * 团队补贴从二星开始 */ int compareLevel = MemberLevelEnum.SECOND_LEVEL.compareLevel(key, MemberLevelEnum.SECOND_LEVEL.getType()); if(compareLevel > 0){ List value = collect.get(key); mallMemberTeamPerk.add(value.get(0)); } } } return mallMemberTeamPerk; } /** * 递归获取对应的团队补贴对象 * 下单 * 下单人的上级集合里面每个等级的第一个会员 * @param memberId * @param mallMemberTeamPerk * @return */ public List mallMemberTeamPerkList(Long memberId,List mallMemberTeamPerk){ MallMember mallMember = memberMapper.selectById(memberId); if(ObjectUtil.isEmpty(mallMember.getReferrerId())){ return mallMemberTeamPerk; } String referrerId = mallMember.getReferrerId(); MallMember mallMemberParent = memberMapper.selectInfoByInviteId(referrerId); if(MemberLevelEnum.SECOND_LEVEL.compareLevel(mallMemberParent.getLevel(),mallMember.getLevel()) > 0){ mallMemberTeamPerk.add(mallMemberParent); } if(!referrerId.equals(mallMember.getInviteId())){ mallMemberTeamPerkList(mallMemberParent.getId(),mallMemberTeamPerk); } return mallMemberTeamPerk; } /** * 星级奖励 * @param mallMembersOlds 高一级别的用户 * @param LevelParam 当前级别 * @param amount 补贴金额的基数 * @param orderNo 订单编号 * @param memberId 会员id * @return */ public List getStarRecord(List mallMembersOlds,String LevelParam,BigDecimal amount,String orderNo,Long memberId,int starPerkType){ //实际补贴总金额 BigDecimal totalPerkAgentAmount = BigDecimal.ZERO; //根据用户的level获取用户 List mallMemberStars = memberMapper.selectMemberWithLevel(LevelParam); if(CollUtil.isNotEmpty(mallMembersOlds)){ for(MallMember mallMemberOld : mallMembersOlds){ mallMemberStars.add(mallMemberOld); } } if(CollUtil.isNotEmpty(mallMemberStars)){ List mallMemberStarIds = mallMemberStars.stream().map(MallMember::getId).collect(Collectors.toList()); //排除掉本身 mallMemberStarIds.remove(memberId); if(CollUtil.isEmpty(mallMemberStarIds)){ return mallMemberStars; } //当前等级的总贡献点 List mallMemberWallets = mallMemberWalletMapper.selectMemberWalletsByIds(mallMemberStarIds); Integer starSum = mallMemberWallets.stream().mapToInt(MallMemberWallet::getStar).sum(); if(starSum <= 0){ return mallMemberStars; } BigDecimal totalProfitProp = BigDecimal.ZERO; List agentLevelRequireDics = dataDictionaryCustomMapper.selectDicByType("AGENT_LEVEL_REQUIRE"); if(CollUtil.isNotEmpty(agentLevelRequireDics)){ for(DataDictionaryCustom dic : agentLevelRequireDics){ String starPerkStr = dic.getValue(); AgentInfo agentInfo = JSONObject.parseObject(starPerkStr, AgentInfo.class); //当前星级所占份数 BigDecimal profitProp = agentInfo.getProfitProp().abs(); List mallMembers = memberMapper.selectByLevel(dic.getCode()); if(CollUtil.isNotEmpty(mallMembers)){ totalProfitProp = profitProp.add(totalProfitProp); } } } //星级补贴比例 DataDictionaryCustom starPerkDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( "AGENT_LEVEL_REQUIRE", LevelParam); String starPerkStr = starPerkDic.getValue(); AgentInfo agentInfo = JSONObject.parseObject(starPerkStr, AgentInfo.class); // BigDecimal profitProp = agentInfo.getProfitProp().abs().divide(new BigDecimal(100)); //当前星级所占份数 BigDecimal profitProp = agentInfo.getProfitProp().abs(); //每一份多少钱 amount = amount.divide(totalProfitProp,4,BigDecimal.ROUND_DOWN); //当前等级的星级补贴 BigDecimal starPerkAmountSum = amount.multiply(profitProp); //当前等级的每一个贡献点的补贴金额 BigDecimal starPerkAmountAva = starPerkAmountSum.divide(new BigDecimal(starSum),BigDecimal.ROUND_DOWN).setScale(2, BigDecimal.ROUND_DOWN); /** * 给当前等级的每个用户发放星级奖励 * 生成星级奖励的流水 */ if(CollUtil.isNotEmpty(mallMemberWallets)){ //给当前等级的每个用户发放星级奖励 int count = 0; List> result = new ArrayList<>(); List> resultReduce = new ArrayList<>(); List mallMoneyFlows = new ArrayList<>(); for(MallMemberWallet mallMemberWallet : mallMemberWallets){ Map hashMap = new HashMap<>(); Integer starCnt = mallMemberWallet.getStar(); //当前用户的星级奖励 BigDecimal starPerkAmount = starPerkAmountAva .multiply(new BigDecimal(starCnt)).abs().setScale(2, BigDecimal.ROUND_DOWN); BigDecimal totalScorePerk = mallMemberWallet.getTotalScore(); if(totalScorePerk.compareTo(starPerkAmount) < 0){ starPerkAmount = totalScorePerk; } if(BigDecimal.ZERO.compareTo(starPerkAmount) < 0){ hashMap.put("id",mallMemberWallet.getId()); hashMap.put("starPerkAmount",starPerkAmount); result.add(hashMap); resultReduce.add(hashMap); //生成星级奖励的流水对象 MallMoneyFlow mallMoneyFlow = new MallMoneyFlow(); mallMoneyFlow.setMemberId(mallMemberWallet.getMemberId()); mallMoneyFlow.setAmount(starPerkAmount); mallMoneyFlow.setType(starPerkType); mallMoneyFlow.setOrderNo(orderNo); mallMoneyFlow.setRtMemberId(memberId); mallMoneyFlow.setStatus(2); mallMoneyFlow.setRemark("补贴额度:"+mallMemberWallet.getTotalScore()); mallMoneyFlow.setFlowType(FlowTypeEnum.BALANCE.getValue()); mallMoneyFlows.add(mallMoneyFlow); reduceStar(mallMemberWallet.getMemberId(),starPerkAmount); totalPerkAgentAmount = totalPerkAgentAmount.add(starPerkAmount); } count = count + 1; if (count % 1000 == 0 || count == mallMemberWallets.size()) { if(CollUtil.isNotEmpty(result)){ int resultCount = mallMemberWalletMapper.updateStarByList(result); if(resultCount>0){ log.info("============余额新增============第{}条数据===========",resultCount); } //每更新完一批数据,在result内进行删除操作。 result.clear(); int resultReduceCount = mallMemberWalletMapper.updateTotalScoreByList(resultReduce); if(resultReduceCount>0){ log.info("============额度减少============第{}条数据===========",resultReduceCount); } //每更新完一批数据,在result内进行删除操作。 resultReduce.clear(); } } } if(CollUtil.isNotEmpty(mallMoneyFlows)){ SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH,false); MallMoneyFlowMapper mallMoneyFlowMapper = sqlSession.getMapper(MallMoneyFlowMapper.class); for(int i = 1; i <= mallMoneyFlows.size(); i++){ mallMoneyFlowMapper.insertMoneyFlow(mallMoneyFlows.get(i-1)); if (i % 1000 == 0 || i == mallMoneyFlows.size()) { log.info("============插入流水============第{}条数据===========",mallMoneyFlows.size()); sqlSession.commit(); sqlSession.clearCache(); } } sqlSession.close(); } } } log.info("============实际补贴金额:{}",totalPerkAgentAmount.setScale(2,BigDecimal.ROUND_DOWN)); DataDictionaryCustom totalPerkAgentAmountDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getType(), DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getCode() ); totalPerkAgentAmountDic.setValue( new BigDecimal(totalPerkAgentAmountDic.getValue()).subtract(totalPerkAgentAmount).setScale(2,BigDecimal.ROUND_DOWN).toString() ); dataDictionaryCustomMapper.updateById(totalPerkAgentAmountDic); return mallMemberStars; } /** * 统一处理补贴,流水,余额 * 增加的余额是一样的 * @param mallMemberWallets * @param amount * @param flowType * @param orderNo * @param memberId */ @Override public void flowTotalScoreBalance(List mallMemberWallets,BigDecimal amount,int flowType,String orderNo,Long memberId){ //给当前等级的每个用户发放星级奖励 int count = 0; List> result = new ArrayList<>(); List> resultReduce = new ArrayList<>(); List mallMoneyFlows = new ArrayList<>(); for(MallMemberWallet mallMemberWallet : mallMemberWallets){ Map hashMap = new HashMap<>(); BigDecimal totalScorePerk = mallMemberWallet.getTotalScore(); if(totalScorePerk.compareTo(amount) < 0){ amount = totalScorePerk; } if(BigDecimal.ZERO.compareTo(amount) < 0){ hashMap.put("id",mallMemberWallet.getId()); hashMap.put("starPerkAmount",amount); result.add(hashMap); resultReduce.add(hashMap); //生成星级奖励的流水对象 MallMoneyFlow mallMoneyFlow = new MallMoneyFlow(); mallMoneyFlow.setMemberId(mallMemberWallet.getMemberId()); mallMoneyFlow.setAmount(amount); mallMoneyFlow.setType(flowType); mallMoneyFlow.setOrderNo(orderNo); mallMoneyFlow.setRtMemberId(memberId); mallMoneyFlow.setStatus(2); mallMoneyFlow.setRemark("补贴额度:"+mallMemberWallet.getTotalScore()); mallMoneyFlow.setFlowType(FlowTypeEnum.BALANCE.getValue()); mallMoneyFlows.add(mallMoneyFlow); reduceStar(mallMemberWallet.getMemberId(),amount); } count = count + 1; if (count % 1000 == 0 || count == mallMemberWallets.size()) { if(CollUtil.isNotEmpty(result)){ int resultCount = mallMemberWalletMapper.updateStarByList(result); if(resultCount>0){ log.info("============余额新增============第{}条数据===========",resultCount); } //每更新完一批数据,在result内进行删除操作。 result.clear(); int resultReduceCount = mallMemberWalletMapper.updateTotalScoreByList(resultReduce); if(resultReduceCount>0){ log.info("============额度减少============第{}条数据===========",resultReduceCount); } //每更新完一批数据,在result内进行删除操作。 resultReduce.clear(); } } } if(CollUtil.isNotEmpty(mallMoneyFlows)){ SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH,false); MallMoneyFlowMapper mallMoneyFlowMapper = sqlSession.getMapper(MallMoneyFlowMapper.class); for(int i = 1; i <= mallMoneyFlows.size(); i++){ mallMoneyFlowMapper.insertMoneyFlow(mallMoneyFlows.get(i-1)); if (i % 1000 == 0 || i == mallMoneyFlows.size()) { log.info("============插入流水============第{}条数据===========",mallMoneyFlows.size()); sqlSession.commit(); sqlSession.clearCache(); } } sqlSession.close(); } } @Override public void reduceStar(Long memberId,BigDecimal totalScore) { /** *获取用户的全部未用完的补贴额度流水 */ MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(memberId); List mallMoneyFlows = mallMoneyFlowMapper.selectMoneyFlowByMemberIdAndIsRetrun(memberId,2); //如果补贴额度全部用完则更新用户的贡献点为零 if(CollUtil.isEmpty(mallMoneyFlows)){ mallMemberWalletMapper.reduceStarByMemberId(mallMemberWallet.getStar(), memberId); return; } for(MallMoneyFlow mallMoneyFlow : mallMoneyFlows){ String remark = mallMoneyFlow.getRemark(); BigDecimal remarkNum = new BigDecimal(remark); //如果补贴额度小于记录的剩余补贴额度 if(totalScore.compareTo(remarkNum) < 0){ remarkNum = remarkNum.subtract(totalScore).setScale(2,BigDecimal.ROUND_DOWN); mallMoneyFlowMapper.updateRemarkById(remarkNum.toString(),mallMoneyFlow.getId()); break; } //如果补贴额度等于等于记录的剩余补贴额度 if(totalScore.compareTo(remarkNum) == 0){ remarkNum = remarkNum.subtract(totalScore).setScale(2,BigDecimal.ROUND_DOWN); mallMoneyFlowMapper.updateRemarkAndIsReturnById(remarkNum.toString(),mallMoneyFlow.getId()); //减少用户的贡献点 String orderNo = mallMoneyFlow.getOrderNo(); MallMoneyFlow mallMoneyFlowStar = mallMoneyFlowMapper.selectByOrderNoAndMemberId(orderNo,memberId,2); BigDecimal amount = mallMoneyFlowStar.getAmount(); mallMemberWalletMapper.reduceStarByMemberId(amount.intValue(), memberId); //更新记录的返利状态为已返利 mallMoneyFlowMapper.updateRemarkAndIsReturnById("0",mallMoneyFlowStar.getId()); break; } //如果补贴额度大于记录的剩余补贴额度 if(totalScore.compareTo(remarkNum) > 0){ mallMoneyFlowMapper.updateRemarkAndIsReturnById("0",mallMoneyFlow.getId()); //减少用户的贡献点 String orderNo = mallMoneyFlow.getOrderNo(); MallMoneyFlow mallMoneyFlowStar = mallMoneyFlowMapper.selectByOrderNoAndMemberId(orderNo,memberId,2); BigDecimal amount = mallMoneyFlowStar.getAmount(); mallMemberWalletMapper.reduceStarByMemberId(amount.intValue(), memberId); //更新记录的返利状态为已返利 mallMoneyFlowMapper.updateRemarkAndIsReturnById("0",mallMoneyFlowStar.getId()); totalScore = totalScore.subtract(remarkNum); } } } @Override public void achieveReleasePercent() { DataDictionaryCustom jobAchieveReleasePercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( GreenScoreEnum.JOB_ACHIEVE_RELEASE_PERCENT.getType(), GreenScoreEnum.JOB_ACHIEVE_RELEASE_PERCENT.getCode() ); List mallMembers = memberMapper.selectByLevel(MemberLevelEnum.SECOND_LEVEL.getType()); BigDecimal jobAchieveReleasePercent = new BigDecimal(jobAchieveReleasePercentDic.getValue()) .multiply(new BigDecimal(0.001)); BigDecimal totalAchieve = BigDecimal.ZERO; Integer totalStar = 0; if(CollUtil.isNotEmpty(mallMembers)){ for(MallMember mallMember : mallMembers){ //总业绩 BigDecimal achieve = mallAchieveRecordMapper.selectSumAchieveByMemberId(mallMember.getId()); totalAchieve = totalAchieve.add(achieve); MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(mallMember.getId()); Integer star = mallMemberWallet.getStar(); totalStar = totalStar + star; } } if(BigDecimal.ZERO.compareTo(totalAchieve) >= 0){ return; } //总释放=总业绩*一星每日业绩每日释放业绩到余额的千分比 totalAchieve = totalAchieve.multiply(jobAchieveReleasePercent); if(totalStar <= 0){ return; } //一个贡献点的价值 BigDecimal divide = totalAchieve.divide(new BigDecimal(totalStar), 2, BigDecimal.ROUND_DOWN); if(CollUtil.isNotEmpty(mallMembers)){ for(MallMember mallMember : mallMembers){ MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(mallMember.getId()); Integer star = mallMemberWallet.getStar(); //每个人贡献值数量*一个贡献点的价值=获取的收益 BigDecimal multiply = divide.multiply(new BigDecimal(star)).setScale(2,BigDecimal.ROUND_DOWN); BigDecimal totalScore = mallMemberWallet.getTotalScore(); if(BigDecimal.ZERO.compareTo(multiply) < 0){ if(BigDecimal.ZERO.compareTo(totalScore) < 0){ if(totalScore.compareTo(multiply) < 0){ multiply = totalScore; } //减少补贴额度 mallMemberWalletMapper.reduceTotalScoreById(multiply, mallMemberWallet.getId()); reduceStar(mallMember.getId(),multiply); mallMemberWalletMapper.addBalanceById(multiply, mallMemberWallet.getId()); mallMoneyFlowService.addMoneyFlow( mallMember.getId(), multiply, MoneyFlowTypeEnum.STATIC_BONUS.getValue(), MallUtils.getOrderNum(), FlowTypeEnum.BALANCE.getValue()); } } } } // if(CollUtil.isNotEmpty(mallMembers)){ // for(MallMember mallMember : mallMembers){ // //总业绩 // BigDecimal sumAchieve = mallAchieveRecordMapper.selectSumAchieveByMemberId(mallMember.getId()); // //每个人的补贴额度 // BigDecimal multiply = sumAchieve.multiply(jobAchieveReleasePercent); // MallMemberWallet mallMemberWallet = mallMemberWalletMapper.selectWalletByMemberId(mallMember.getId()); // BigDecimal totalScore = mallMemberWallet.getTotalScore(); // if(BigDecimal.ZERO.compareTo(multiply) < 0){ // if(BigDecimal.ZERO.compareTo(totalScore) < 0){ // if(totalScore.compareTo(multiply) < 0){ // multiply = totalScore; // } // //减少补贴额度 // mallMemberWalletMapper.reduceTotalScoreById(multiply, mallMemberWallet.getId()); // // reduceStar(mallMember.getId(),multiply); // // mallMemberWalletMapper.addBalanceById(multiply, mallMemberWallet.getId()); // // mallMoneyFlowService.addMoneyFlow( // mallMember.getId(), // multiply, // MoneyFlowTypeEnum.STATIC_BONUS.getValue(), // MallUtils.getOrderNum(), // FlowTypeEnum.BALANCE.getValue()); // } // } // } // } } @Override public void perkAgent() { DataDictionaryCustom totalAmountDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getType(), DataDictionaryEnum.PERK_AGENT_ACHIEVE_TOTAL.getCode() ); if(ObjectUtil.isEmpty(totalAmountDic)){ return; } //星级补贴总数 BigDecimal totalAmount = new BigDecimal(totalAmountDic.getValue()).setScale(2, BigDecimal.ROUND_DOWN); if(BigDecimal.ZERO.compareTo(totalAmount) >= 0){ return; } DataDictionaryCustom perkAgentPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.PERK_AGENT_ACHIEVE_PERCENT.getType(), DataDictionaryEnum.PERK_AGENT_ACHIEVE_PERCENT.getCode() ); if(ObjectUtil.isEmpty(perkAgentPercentDic)){ return; } //星级补贴百分比 BigDecimal perkAgentPercent = new BigDecimal(perkAgentPercentDic.getValue()).abs().divide(new BigDecimal(100)); BigDecimal amount = totalAmount.multiply(perkAgentPercent); if(BigDecimal.ZERO.compareTo(amount) >= 0){ return; } // //星级补贴总数 // totalAmountDic.setValue(totalAmount.subtract(amount).setScale(2,BigDecimal.ROUND_DOWN).toString()); // dataDictionaryCustomMapper.updateById(totalAmountDic); String orderNo = MallUtils.getOrderNum("SPA"); /** * 星级奖励 * 从最顶级级别的合伙人开始补贴 * 补贴完,把已经补贴的合伙人加入下一个级别 */ List sevenLevelRecord = getStarRecord(null, MemberLevelEnum.SEVEN_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_SEVEN.getValue()); List sixLevelRecord = getStarRecord(sevenLevelRecord, MemberLevelEnum.SIX_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_SIX.getValue()); List fifthLevelRecord = getStarRecord(sixLevelRecord, MemberLevelEnum.FIFTH_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_FIVE.getValue()); List fourLevelRecord = getStarRecord(fifthLevelRecord, MemberLevelEnum.FOUR_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_FOUR.getValue()); List thirdLevelRecord = getStarRecord(fourLevelRecord, MemberLevelEnum.THIRD_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_THREE.getValue()); List secondLevelRecord = getStarRecord(thirdLevelRecord, MemberLevelEnum.SECOND_LEVEL.name(), amount, orderNo, 0L,MoneyFlowTypeEnum.STAR_PERK_TWO.getValue()); } @Override public void BuyToSell() { /** * nft产品周期到期的已完成买单变成卖单 * 计算收益,本金 */ List mallProductNfts = mallProductNftMapper.selectList(null); if(CollUtil.isEmpty(mallProductNfts)){ return; } DateTime now = DateUtil.date(); for(MallProductNft mallProductNft : mallProductNfts){ Long nftId = mallProductNft.getId(); List mallProductBuys = mallProductBuyMapper.selectListByStateAndProductNFTId( ProductEnum.PRODUCT_BUY_SUCCESS.getValue(), nftId, ProductEnum.PRODUCT_BUY_MATE_STATE_FAIL.getValue()); if(CollUtil.isEmpty(mallProductBuys)){ continue; } //周期 int cycle = mallProductNft.getCycle(); //收益率 BigDecimal profitPercent = mallProductNft.getProfit(); for(MallProductBuy mallProductBuy : mallProductBuys){ Date payTime = mallProductBuy.getPayTime(); //偏移时间 DateTime dateTime = DateUtil.offsetDay(payTime, cycle); int compare = DateUtil.compare(now, dateTime); if(compare <= 0){ /** * 更新买单状态 * 收益生成一条卖单 * 本金生成一条卖单 */ mallProductBuy.setMateState(ProductEnum.PRODUCT_BUY_MATE_STATE_SUCCESS.getValue()); mallProductBuyMapper.updateById(mallProductBuy); BigDecimal nftTotal = mallProductBuy.getNftTotal(); insertSell(mallProductBuy.getMemberId(),nftTotal,nftTotal,BigDecimal.ZERO,BigDecimal.ZERO); BigDecimal profit = nftTotal.multiply(profitPercent.multiply(new BigDecimal(0.01))); insertSell(mallProductBuy.getMemberId(),profit,profit,BigDecimal.ZERO,BigDecimal.ZERO); } } } } @Override public void timeGetOrderBuy() { DateTime nowTime = DateUtil.parseTime(DateUtil.formatTime(DateUtil.date())); DataDictionaryCustom endTimeDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.YU_YUE_END_TIME.getType(), DataDictionaryEnum.YU_YUE_END_TIME.getCode() ); DateTime endTime = DateUtil.parseTime(endTimeDic.getValue()); /** * 当前时间比结束时间大 */ if(nowTime.compareTo(endTime) >= 0){ List mallProductBuyRecords = mallProductBuyRecordMapper.selectByState(ProductEnum.PRODUCT_MATE_STATE_WAIT_PAY.getValue()); if(CollUtil.isNotEmpty(mallProductBuyRecords)){ for(MallProductBuyRecord mallProductBuyRecord : mallProductBuyRecords){ /** * 用户有超时未支付的订单 * 1、冻结账户 * 2、更新买单主表 * 2、更新卖单主表 * 3、更新买单子表的数据 * 3、更新卖单子表的数据 */ agentProducer.sendFcmOrderBuyCancelMsg(mallProductBuyRecord.getId()); // Long buyId = mallProductBuyRecord.getBuyId(); // Long sellRecordId = mallProductBuyRecord.getSellRecordId(); // MallProductBuy mallProductBuy = mallProductBuyMapper.selectById(buyId); // Long memberIdBuy = mallProductBuy.getMemberId(); // //冻结账户 // MallMember mallMemberBuy = memberMapper.selectById(memberIdBuy); // mallMemberBuy.setIsFrozen(ProductEnum.MEMBER_FROZEN.getValue()); // memberMapper.updateById(mallMemberBuy); // //更新买单子表的数据 // mallProductBuyRecord.setState(ProductEnum.PRODUCT_MATE_STATE_FAIL.getValue()); // mallProductBuyRecordMapper.updateById(mallProductBuyRecord); // //更新买单主表 // mallProductBuy.setNftAva(mallProductBuy.getNftAva().add(mallProductBuyRecord.getPickNftCnt())); // mallProductBuyMapper.updateById(mallProductBuy); // //更新卖单子表的数据 // MallProductSellRecord mallProductSellRecord = mallProductSellRecordMapper.selectById(sellRecordId); // mallProductSellRecord.setState(ProductEnum.PRODUCT_MATE_STATE_FAIL.getValue()); // mallProductSellRecordMapper.updateById(mallProductSellRecord); // //更新卖单主表 // Long sellId = mallProductSellRecord.getSellId(); // MallProductSell mallProductSell = mallProductSellMapper.selectById(sellId); // mallProductSell.setNftCntAva(mallProductSell.getNftCntAva().add(mallProductSellRecord.getNftCnt())); // mallProductSellMapper.updateById(mallProductSell); } } } } @Override public void timeGetOrderSell() { DateTime nowTime = DateUtil.parseTime(DateUtil.formatTime(DateUtil.date())); DataDictionaryCustom endTimeDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode( DataDictionaryEnum.YU_YUE_END_TIME.getType(), DataDictionaryEnum.YU_YUE_END_TIME.getCode() ); DateTime endTime = DateUtil.parseTime(endTimeDic.getValue()); /** * 当前时间比结束时间大 */ if(nowTime.compareTo(endTime) >= 0){ List mallProductSellRecords = mallProductSellRecordMapper.selectListByState(ProductEnum.PRODUCT_MATE_STATE_PAY.getValue()); if(CollUtil.isNotEmpty(mallProductSellRecords)){ for(MallProductSellRecord mallProductSellRecord : mallProductSellRecords){ /** * 卖方 * 1:冻结账户 */ Long sellId = mallProductSellRecord.getSellId(); MallProductSell mallProductSell = mallProductSellMapper.selectById(sellId); MallMember mallMember = memberMapper.selectById(mallProductSell.getMemberId()); mallMember.setIsFrozen(ProductEnum.MEMBER_FROZEN.getValue()); memberMapper.updateById(mallMember); } } } } @Override public void timeGetOrderBuyCancel() { /** * nft产品周期到期的已完成买单变成卖单 * 计算收益,本金 */ List mallProductNfts = mallProductNftMapper.selectList(null); if(CollUtil.isEmpty(mallProductNfts)){ return; } DateTime now = DateUtil.date(); for(MallProductNft mallProductNft : mallProductNfts){ Long nftId = mallProductNft.getId(); List mallProductBuys = mallProductBuyMapper.selectListByStateAndProductNFTId( ProductEnum.PRODUCT_BUY_ON_GOING.getValue(), nftId, ProductEnum.PRODUCT_BUY_MATE_STATE_FAIL.getValue()); if(CollUtil.isEmpty(mallProductBuys)){ continue; } for(MallProductBuy mallProductBuy : mallProductBuys){ /** * 返回令牌 * 预约记录超时 */ String orderNo = mallProductBuy.getOrderNo(); mallProductBuy.setState(ProductEnum.PRODUCT_BUY_TIMEOUT.getValue()); mallProductBuyMapper.updateById(mallProductBuy); Long memberId = mallProductBuy.getMemberId(); MallMoneyFlow mallMoneyFlow = mallMoneyFlowMapper.selectByOrderAndType(orderNo, MoneyFlowTypeNewEnum.TOKEN_BUY_FROZEN.getValue(), FlowTypeNewEnum.TOKEN.getValue(), memberId); if(ObjectUtil.isEmpty(mallMoneyFlow)){ continue; } BigDecimal absAmount = mallMoneyFlow.getAmount().abs(); MallMemberAmount mallMemberAmount = mallMemberAmountMapper.selectByMemberId(memberId); mallMemberAmount.setTokenAva(mallMemberAmount.getTokenAva().add(absAmount)); mallMemberAmount.setTokenFrozen(mallMemberAmount.getTokenFrozen().subtract(absAmount)); mallMemberAmountMapper.updateTokenAvaAndTokenFrozenById(mallMemberAmount); mallMoneyFlowService.addMoneyFlow( memberId, absAmount, MoneyFlowTypeNewEnum.TOKEN_BUY_FROZEN_RETURN.getValue(), orderNo, null, FlowTypeNewEnum.TOKEN.getValue(), MoneyFlowTypeNewEnum.TOKEN_BUY_FROZEN_RETURN.getDescrition()); } } } public void insertSell(Long memberId,BigDecimal nftCnt,BigDecimal nftCntAva, BigDecimal nftFee,BigDecimal fcmFeeCnt){ String orderNo = MallUtils.getOrderNum("NFT"); MallProductSell mallProductSell = new MallProductSell(); mallProductSell.setMemberId(memberId); mallProductSell.setOrderNo(orderNo); mallProductSell.setNftTotal(nftCnt); mallProductSell.setNftCnt(nftCntAva); mallProductSell.setNftCntAva(nftCntAva); mallProductSell.setNftFee(nftFee); mallProductSell.setFcmFee(fcmFeeCnt); mallProductSell.setState(ProductEnum.PRODUCT_SELL_ON_GOING.getValue()); mallProductSellMapper.insert(mallProductSell); } }