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