Administrator
2025-05-16 4bff26f84eea567dfc65564285dc84fc46b22498
refactor(mall): 优化商品评论数量查询逻辑

- 使用 LambdaQueryWrapper 替代 QueryWrapper,提高代码可读性
-增加对评论显示状态的查询条件,仅统计显示状态为 1 的评论
1 files modified
5 ■■■■■ changed files
src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java 5 ●●●●● patch | view | raw | blame | history
src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java
@@ -145,8 +145,9 @@
        }
        mallGoodsDetailsVo.setImages(images);
        QueryWrapper<MallGoodsComment> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.eq("goods_id",id);
        LambdaQueryWrapper<MallGoodsComment> objectQueryWrapper = new LambdaQueryWrapper<>();
        objectQueryWrapper.eq(MallGoodsComment::getGoodsId,id);
        objectQueryWrapper.eq(MallGoodsComment::getShowState,1);
        Integer commentCount = mallGoodsCommentMapper.selectCount(objectQueryWrapper);
        mallGoodsDetailsVo.setCommentCount(commentCount);
        return mallGoodsDetailsVo;