refactor(mall): 优化活动关注记录查询逻辑

Administrator

2025-06-17 eacba04de1bf9a31e1503e7c07938f1812fe86c5

refactor(mall): 优化活动关注记录查询逻辑

- 在查询关注记录时，添加了对 member_id 的 select 操作，以提高查询效率
- 注释掉了一段冗余的查询代码，以简化代码结构

 src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java

@@ -78,6 +78,7 @@
                // 查询关注点赞转发记录，筛选出关注活动类型且未删除的关注记录，并按ID升序排序，限制结果数量为3
                List<HappyFollow> happyFollows = happyFollowMapper.selectList(
                        new LambdaQueryWrapper<HappyFollow>()
                                .select(HappyFollow::getMemberId)
                                .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode())
                                .eq(HappyFollow::getSourceId, record.getId())
                                .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode())
@@ -85,6 +86,16 @@
                                .orderByAsc(HappyFollow::getId)
                                .last("limit 3")
                );
//                // 查询关注点赞转发记录，筛选出关注活动类型且未删除的关注记录，并按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的集合