From f4ee25ab3b8b5cc5dd9af71278521f4033d02bb8 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Mon, 28 Apr 2025 15:15:20 +0800 Subject: [PATCH] refactor(mall): 优化活动订单状态更新逻辑 --- src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java | 210 ++++++++++++++++++++++++++++++++------------------- 1 files changed, 131 insertions(+), 79 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java index 531879d..9db2eae 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java @@ -14,10 +14,7 @@ import cc.mrbird.febs.mall.service.IApiMallMemberWalletService; import cc.mrbird.febs.mall.vo.*; import cc.mrbird.febs.mall.dto.ApiOperateDoDto; -import cc.mrbird.febs.mall.vo.activity.ApiActivityOrderInfoVo; -import cc.mrbird.febs.mall.vo.activity.ApiActivityOrderListVo; -import cc.mrbird.febs.mall.vo.activity.ApiCheckOrderVo; -import cc.mrbird.febs.mall.vo.activity.ApiVoteActivityHotVo; +import cc.mrbird.febs.mall.vo.activity.*; import cc.mrbird.febs.pay.model.BrandWCPayRequestData; import cc.mrbird.febs.pay.service.IXcxPayService; import cc.mrbird.febs.rabbit.producter.AgentProducer; @@ -30,7 +27,6 @@ import cn.hutool.crypto.SecureUtil; import cn.hutool.json.JSONUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; -import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.RequiredArgsConstructor; @@ -55,6 +51,7 @@ private final HappyActivityOptionMapper happyActivityOptionMapper; private final HappyActivityConnectMapper happyActivityConnectMapper; private final HappyActivityOrderMapper happyActivityOrderMapper; + private final HappyActivityCommentMapper happyActivityCommentMapper; private final HappyActivityOrderItemMapper happyActivityOrderItemMapper; private final IXcxPayService iXcxPayService; private final IApiMallMemberWalletService iApiMallMemberWalletService; @@ -71,55 +68,33 @@ // 检查分页结果是否包含数据 if(CollUtil.isNotEmpty(happyActivityPage.getRecords())){ List<ApiActivityInfoVo> records = happyActivityPage.getRecords(); - // 使用Stream流操作records,获取所有活动的ID - List<Long> ids = records.stream().map(ApiActivityInfoVo::getId).collect(Collectors.toList()); - - // 查询关注点赞转发记录,筛选出关注活动类型且未删除的关注记录,并按ID升序排序,限制结果数量为3 - List<HappyFollow> happyFollows = happyFollowMapper.selectList( - new LambdaQueryWrapper<HappyFollow>() - .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode()) - .in(HappyFollow::getSourceId, ids) - .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode()) - .orderByAsc(HappyFollow::getId) - .last("limit 3") - ); - - // 检查关注记录是否不为空 - if(CollUtil.isNotEmpty(happyFollows)){ - // 使用Stream流操作关注记录,获取所有成员ID的集合 - Set<Long> memberIds = happyFollows.stream().collect(Collectors.mapping(HappyFollow::getMemberId, Collectors.toSet())); - - // 查询成员信息,获取成员的ID和头像 - List<MallMember> mallMembers = mallMemberMapper.selectList( - new LambdaQueryWrapper<MallMember>() - .select(MallMember::getId,MallMember::getAvatar) - .in(MallMember::getId, memberIds) + // 遍历活动记录,为每个活动添加成员头像信息 + records.forEach(record -> { + // 查询关注点赞转发记录,筛选出关注活动类型且未删除的关注记录,并按ID升序排序,限制结果数量为3 + List<HappyFollow> happyFollows = happyFollowMapper.selectList( + new LambdaQueryWrapper<HappyFollow>() + .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode()) + .eq(HappyFollow::getSourceId, record.getId()) + .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode()) + .groupBy(HappyFollow::getMemberId) + .orderByAsc(HappyFollow::getId) + .last("limit 3") ); + // 检查关注记录是否不为空 + if(CollUtil.isNotEmpty(happyFollows)){ + // 使用Stream流操作关注记录,获取所有成员ID的集合 + Set<Long> memberIds = happyFollows.stream().collect(Collectors.mapping(HappyFollow::getMemberId, Collectors.toSet())); - // 使用Stream流操作成员信息,生成一个以成员ID为键,成员信息为值的Map - Map<Long, MallMember> memberMap = mallMembers.stream() - .collect(Collectors.toMap(MallMember::getId, member -> member)); - - // 使用Stream流操作关注记录,生成一个以活动ID为键,成员ID列表为值的Map - Map<Long, List<Long>> followMap = happyFollows.stream() - .collect(Collectors.groupingBy( - HappyFollow::getSourceId, - Collectors.mapping(HappyFollow::getMemberId, Collectors.toList()) - )); - - // 遍历活动记录,为每个活动添加成员头像信息 - records.forEach(record -> { - List<Long> memberIdsForRecord = followMap.get(record.getId()); - if (CollUtil.isNotEmpty(memberIdsForRecord)) { - List<String> memberAvatars = memberIdsForRecord.stream() - .map(memberMap::get) - .filter(member -> member != null) - .map(MallMember::getAvatar) - .collect(Collectors.toList()); - record.setMemberAvatars(memberAvatars); - } - }); - } + // 查询成员信息,获取成员的ID和头像 + List<MallMember> mallMembers = mallMemberMapper.selectList( + new LambdaQueryWrapper<MallMember>() + .select(MallMember::getAvatar) + .in(MallMember::getId, memberIds) + ); + List<String> memberAvatars = mallMembers.stream().map(MallMember::getAvatar).collect(Collectors.toList()); + record.setMemberAvatars(memberAvatars); + } + }); } // 返回成功响应,包含活动分页数据 return new FebsResponse().success().data(happyActivityPage); @@ -137,6 +112,33 @@ ); if(happyActivity != null){ BeanUtil.copyProperties(happyActivity,apiActivityVo); + + Integer commentCount = happyActivityCommentMapper.selectCount( + new LambdaQueryWrapper<HappyActivityComment>() + .eq(HappyActivityComment::getActivityId, happyActivity.getId()) + .eq(HappyActivityComment::getShowState, StateUpDownEnum.UP.getCode()) + ); + apiActivityVo.setCommentCount(commentCount); + + List<HappyFollow> happyFollows = happyFollowMapper.selectList( + new LambdaQueryWrapper<HappyFollow>() + .select(HappyFollow::getId, HappyFollow::getType) + .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode()) + .eq(HappyFollow::getSourceId, happyActivity.getId()) + .in(HappyFollow::getType, Arrays.asList(StateUpDownEnum.LIKE.getCode(), StateUpDownEnum.SHARE.getCode())) + .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode()) + ); + if(CollUtil.isNotEmpty(happyFollows)){ + // 使用Stream流操作happyFollows,按照type分类,返回每一个不同type的总数量,并返回一个Map + Map<Integer, Long> typeCountMap = happyFollows.stream() + .collect(Collectors.groupingBy(HappyFollow::getType, Collectors.counting())); + Long zanCnt = ObjectUtil.defaultIfNull(typeCountMap.get(StateUpDownEnum.LIKE.getCode()), 0L); + apiActivityVo.setZanCnt(Math.toIntExact(zanCnt)); + Long sendCnt = ObjectUtil.defaultIfNull(typeCountMap.get(StateUpDownEnum.SHARE.getCode()), 0L); + apiActivityVo.setSendCnt(Math.toIntExact(sendCnt)); + } + + } return new FebsResponse().success().data(apiActivityVo); } @@ -221,16 +223,18 @@ throw new FebsException("活动不存在"); } - if (StateUpDownEnum.ACTIVITY_TYPE_VOTE.getCode() == happyActivity.getType()) { - Long sourceOptionId = dto.getSourceOptionId(); - if (sourceOptionId == null) { - throw new FebsException("选项ID不能为空"); - } - this.operateDoVote(memberId, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode(), sourceId, sourceOptionId, type); - this.addLikeCnt(sourceOptionId); - } else { - this.operateDo(memberId, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode(), sourceId, type); - } + this.operateDo(memberId, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode(), sourceId, type); + +// if (StateUpDownEnum.ACTIVITY_TYPE_VOTE.getCode() == happyActivity.getType()) { +// Long sourceOptionId = dto.getSourceOptionId(); +// if (sourceOptionId == null) { +// throw new FebsException("选项ID不能为空"); +// } +// this.operateDoVote(memberId, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode(), sourceId, sourceOptionId, type); +// this.addLikeCnt(sourceOptionId); +// } else { +// this.operateDo(memberId, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode(), sourceId, type); +// } } else if (StateUpDownEnum.SOURCE_TYPE_SOCIAL_CIRCLE.getCode() == sourceType) { // 朋友圈点赞或关注 this.operateDo(memberId, StateUpDownEnum.SOURCE_TYPE_SOCIAL_CIRCLE.getCode(), sourceId, type); @@ -491,15 +495,16 @@ throw new FebsException("活动已结束"); } - Integer joinCnt = happyActivity.getJoinCnt(); - if(joinCnt < numCnt){ - throw new FebsException("报名额度剩下"+joinCnt+",请减少报名人数"); + Integer surplusCnt = happyActivity.getSurplusCnt(); + if(surplusCnt < numCnt){ + throw new FebsException("报名额度剩下"+surplusCnt+",请减少报名人数"); } //支付总金额 BigDecimal amount = happyActivity.getPayAmount().multiply(new BigDecimal(dto.getNumCnt())).setScale(2, RoundingMode.DOWN); if(amount.compareTo(BigDecimal.ZERO) < 0){ throw new FebsException("支付金额错误"); } + DateTime failTime = DateUtil.offsetMinute(new Date(), StateUpDownEnum.ORDER_OVERTIME.getCode()); HappyActivityOrder happyActivityOrder = new HappyActivityOrder(); happyActivityOrder.setOrderNo(MallUtils.getOrderNum()); happyActivityOrder.setMemberId(memberId); @@ -508,6 +513,9 @@ happyActivityOrder.setNumCnt(dto.getNumCnt()); happyActivityOrder.setAmount(amount); happyActivityOrder.setPayState(StateUpDownEnum.PAY_STATE_NOT_PAY.getCode()); + happyActivityOrder.setPayType(StateUpDownEnum.PAY_METHOD_WECHAT.getCode()); + happyActivityOrder.setFailTime(failTime); + log.info("创建订单,订单号="+JSONUtil.parse(happyActivityOrder)); happyActivityOrderMapper.insert(happyActivityOrder); for(Long connectId : connectIds){ @@ -526,10 +534,12 @@ happyActivityOrderItemMapper.insert(happyActivityOrderItem); } - this.substructJoinCnt(activityId, happyActivityOrder.getNumCnt()); + this.baseMapper.updateHappyActivitySurplusCnt(activityId, happyActivityOrder.getNumCnt() * (-1)); + HashMap<String, Object> stringObjectHashMap = new HashMap<>(); stringObjectHashMap.put("orderId",happyActivityOrder.getId()); stringObjectHashMap.put("amount",amount); + stringObjectHashMap.put("failTime",failTime); return new FebsResponse().success().data(stringObjectHashMap); } @@ -594,8 +604,6 @@ throw new FebsException("支付失败:" + e.getMessage()); } - // todo 支付失败要把对应的人数加回来 - // 构造返回结果,包含支付相关信息 Map<String, Object> map = new HashMap<>(); map.put("orderInfo", payResultStr); @@ -613,17 +621,6 @@ happyActivityOption.setLikesCnt(happyActivityOption.getLikesCnt() + 1); happyActivityOptionMapper.updateById(happyActivityOption); } - - @Override - public void substructJoinCnt(Long activityId, Integer numCnt) { - HappyActivity happyActivity = this.baseMapper.selectById(activityId); - if(ObjectUtil.isNotEmpty(happyActivity)){ - happyActivity.setJoinCnt(happyActivity.getJoinCnt() -numCnt); - this.baseMapper.updateById(happyActivity); - } - } - - // 处理无需支付订单 private void processNoPayOrder(HappyActivityOrder order, Long orderId) { @@ -920,6 +917,61 @@ } @Override + public void overtimeJob() { + List<HappyActivityOrder> happyActivityOrders = happyActivityOrderMapper.selectList( + new LambdaQueryWrapper<HappyActivityOrder>() + .eq(HappyActivityOrder::getState, StateUpDownEnum.ORDER_STATE_WAIT_PAY.getCode()) + .lt(HappyActivityOrder::getFailTime, new Date()) + ); + if(CollUtil.isNotEmpty(happyActivityOrders)){ + happyActivityOrders.forEach(happyActivityOrder -> { + + Long activityId = happyActivityOrder.getActivityId(); + Integer numCnt = happyActivityOrder.getNumCnt(); + this.baseMapper.updateHappyActivitySurplusCnt(activityId,numCnt); + + happyActivityOrder.setState(StateUpDownEnum.ORDER_STATE_OVERTIME.getCode()); + happyActivityOrderMapper.updateById(happyActivityOrder); + }); + } + } + + @Override + public FebsResponse addComment(ApiPayOrderAddCommentDto dto) { + // 获取当前登录用户的ID + Long memberId = LoginUserUtil.getLoginUser().getId(); + Long orderId = dto.getOrderId(); + + HappyActivityOrder happyActivityOrder = happyActivityOrderMapper.selectById(orderId); + if(StateUpDownEnum.ORDER_STATE_USED.getCode() != happyActivityOrder.getState()){ + throw new FebsException("该订单状态不是已使用状态!"); + } + + happyActivityOrder.setState(StateUpDownEnum.ORDER_STATE_COMMENT.getCode()); + happyActivityOrderMapper.updateById(happyActivityOrder); + + HappyActivity happyActivity = this.baseMapper.selectById(happyActivityOrder.getActivityId()); + + HappyActivityComment happyActivityComment = new HappyActivityComment(); + happyActivityComment.setActivityId(happyActivity.getId()); + happyActivityComment.setActivityName(happyActivity.getName()); + happyActivityComment.setMemberId(memberId); + happyActivityComment.setOrderId(orderId); + happyActivityComment.setStar(dto.getStar()); + happyActivityComment.setComment(dto.getComment()); + happyActivityComment.setImages(dto.getImages()); + happyActivityCommentMapper.insert(happyActivityComment); + + return new FebsResponse().success().message("操作成功"); + } + + @Override + public List<ApiActivityCommentVo> commentByActivityId(ApiActivityCommentDto dto) { + Page<ApiActivityCommentVo> page = new Page<>(dto.getPageNow(), dto.getPageSize()); + return this.baseMapper.selectActivityCommentPage(page,dto); + } + + @Override public FebsResponse voteActivityHot(Long id) { ApiVoteActivityHotVo apiVoteActivityHotVo = new ApiVoteActivityHotVo(); -- Gitblit v1.9.1