Administrator
2025-06-17 97c56c176af03b1f890cadf7a22c04340ffaedc1
fix(mall): 修复活动关注列表分组查询问题

- 在 HappyActivityServiceImpl 类中的活动关注列表查询中,增加了 HappyFollow::getId 列的分组
-这个改动确保了查询结果的唯一性和正确性,同时保持了按 ID 升序排序并限制结果数量为 3 条
1 files modified
2 ■■■ changed files
src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java 2 ●●● patch | view | raw | blame | history
src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java
@@ -82,7 +82,7 @@
                                .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_ACTIVITY.getCode())
                                .eq(HappyFollow::getSourceId, record.getId())
                                .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode())
                                .orderByAsc(HappyFollow::getId)
                                .groupBy(HappyFollow::getMemberId)
                                .last("limit 3")
                );
//                // 查询关注点赞转发记录,筛选出关注活动类型且未删除的关注记录,并按ID升序排序,限制结果数量为3