From 0a34b84b16ec0ad24a199bb4fffd21cb0430a828 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Fri, 26 Aug 2022 17:17:07 +0800 Subject: [PATCH] 20220822 --- src/main/resources/mapper/modules/MallGoodsMapper.xml | 5 ++++- src/main/java/cc/mrbird/febs/mall/dto/ApiMallGoodsCommentDto.java | 3 +++ src/main/java/cc/mrbird/febs/mall/entity/MallGoodsComment.java | 5 +++++ src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java | 1 + 4 files changed, 13 insertions(+), 1 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/dto/ApiMallGoodsCommentDto.java b/src/main/java/cc/mrbird/febs/mall/dto/ApiMallGoodsCommentDto.java index 97a254a..ba68a95 100644 --- a/src/main/java/cc/mrbird/febs/mall/dto/ApiMallGoodsCommentDto.java +++ b/src/main/java/cc/mrbird/febs/mall/dto/ApiMallGoodsCommentDto.java @@ -17,4 +17,7 @@ @ApiModelProperty(value = "商品ID", example = "1") private Long goodsId; + @ApiModelProperty(value = "评价等级", example = "1:好评2:中评3:差评") + private Integer commentType; + } diff --git a/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsComment.java b/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsComment.java index 92cdbd1..8d9df41 100644 --- a/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsComment.java +++ b/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsComment.java @@ -1,6 +1,7 @@ package cc.mrbird.febs.mall.entity; import cc.mrbird.febs.common.entity.BaseEntity; +import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; @@ -44,4 +45,8 @@ //规格名称 private String skuName; + //查询条件 :评价等级 1:好评2:中评3:差评 + @TableField(exist = false) + private Integer commentType; + } diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java index bab3a30..91b8ebc 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java @@ -81,6 +81,7 @@ Page<MallGoodsCommentVo> page = new Page<>(queryDto.getPageNow(), queryDto.getPageSize()); MallGoodsComment mallGoodsComment = new MallGoodsComment(); mallGoodsComment.setGoodsId(queryDto.getGoodsId()); + mallGoodsComment.setCommentType(queryDto.getCommentType()); return this.baseMapper.selectMallGoodsCommentListQueryInPage(page,mallGoodsComment); } diff --git a/src/main/resources/mapper/modules/MallGoodsMapper.xml b/src/main/resources/mapper/modules/MallGoodsMapper.xml index 6da2196..55dee77 100644 --- a/src/main/resources/mapper/modules/MallGoodsMapper.xml +++ b/src/main/resources/mapper/modules/MallGoodsMapper.xml @@ -66,7 +66,7 @@ select a.id, a.goods_name, - a.goods_introdution, + a.goods_introdution goodsIntroduction, a.thumb, a.original_price, a.present_price, @@ -229,6 +229,9 @@ <if test="record.goodsId != null and record.goodsId != ''"> and a.goods_id=#{record.goodsId} </if> + <if test="record.commentType != null and record.commentType != '' and record.commentType == 1"> + and a.star > 4 + </if> </if> </where> group by a.id -- Gitblit v1.9.1