From 97c56c176af03b1f890cadf7a22c04340ffaedc1 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Tue, 17 Jun 2025 10:13:06 +0800 Subject: [PATCH] fix(mall): 修复活动关注列表分组查询问题 --- src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 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 b10d55f..ca9392e 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 @@ -78,13 +78,23 @@ // 查询关注点赞转发记录,筛选出关注活动类型且未删除的关注记录,并按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()) .groupBy(HappyFollow::getMemberId) - .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的集合 -- Gitblit v1.9.1