Administrator
23 hours ago c39f4892149b2335e44525e527fc11eb175f4333
refactor(mall): 优化投票人数统计查询逻辑

- 移除不必要的 groupBy 操作以提高查询性能
- 简化 HappyFollow 查询条件
- 保持投票计数功能的完整性
- 清理注释代码块以改善代码可读性
1 files modified
10 ■■■■■ changed files
src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java 10 ●●●●● patch | view | raw | blame | history
src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java
@@ -185,13 +185,21 @@
        }
        //投票人数
//        List<HappyFollow> happyFollows = happyFollowMapper.selectList(
//                new LambdaQueryWrapper<HappyFollow>()
//                        .select(HappyFollow::getId)
//                        .eq(HappyFollow::getSourceOptionId, id)
//                        .eq(HappyFollow::getType, StateUpDownEnum.VOTE.getCode())
//                        .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode())
//                        .groupBy(HappyFollow::getMemberId)
//        );
        //投票人数
        List<HappyFollow> happyFollows = happyFollowMapper.selectList(
                new LambdaQueryWrapper<HappyFollow>()
                        .select(HappyFollow::getId)
                        .eq(HappyFollow::getSourceOptionId, id)
                        .eq(HappyFollow::getType, StateUpDownEnum.VOTE.getCode())
                        .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode())
                        .groupBy(HappyFollow::getMemberId)
        );
        apiActivityOptionVo.setVoteCnt(CollUtil.isNotEmpty(happyFollows) ? happyFollows.size() : 0);