20220822

xiaoyong931011

2022-09-02 334084c475709cd704649d25b65bf459f701fd2e

20220822

 src/main/java/cc/mrbird/febs/mall/controller/ApiMallGoodsController.java

@@ -57,6 +57,15 @@
        return new FebsResponse().success().data(mallGoodsService.findMallGoodsCommentByGoodsId(queryDto));
    }

    @ApiOperation(value = "获取商品评价等级数量", notes = "获取商品评价等级数量")
    @ApiResponses({
            @ApiResponse(code = 200, message = "success", response = MallGoodsCommentVo.class)
    })
    @GetMapping(value = "/commentLevelByGoodsId/{id}")
    public FebsResponse commentLevelByGoodsId(@PathVariable("id") Long id) {
        return new FebsResponse().success().data(mallGoodsService.findMallGoodsCommentLevelByGoodsId(id));
    }

    @ApiOperation(value = "配送设置", notes = "配送设置")
    @ApiResponses({
            @ApiResponse(code = 200, message = "success", response = ApiMallGoodsDeliveryVo.class)

 src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java

@@ -46,4 +46,6 @@
    IPage<MallGoodsCommentVo> selectMallGoodsCommentListQueryInPage(Page<MallGoodsCommentVo> page,  @Param("record")MallGoodsComment mallGoodsComment);

    IPage<DataDictionaryCustom> getDeliveryHomeListInPage(Page<DataDictionaryCustom> page, @Param("record")AdminHomeDeliverySettingVo adminHomeDeliverySettingVo);

    MallGoodsCommentVo findMallGoodsCommentLevelByGoodsId(@Param("id")Long id);
}

 src/main/java/cc/mrbird/febs/mall/service/IApiMallGoodsService.java

@@ -20,4 +20,6 @@
    IPage<MallGoodsCommentVo> findMallGoodsCommentByGoodsId(ApiMallGoodsCommentDto queryDto);

    ApiMallGoodsDeliveryVo findDeliverySetting();

    MallGoodsCommentVo findMallGoodsCommentLevelByGoodsId(Long id);
}

 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java

@@ -104,4 +104,9 @@
        }
        return apiMallGoodsDeliveryVo;
    }

    @Override
    public MallGoodsCommentVo findMallGoodsCommentLevelByGoodsId(Long id) {
        return this.baseMapper.findMallGoodsCommentLevelByGoodsId(id);
    }
}

 src/main/resources/mapper/modules/MallGoodsMapper.xml

@@ -220,10 +220,6 @@
    <select id="selectMallGoodsCommentListQueryInPage" resultType="cc.mrbird.febs.mall.vo.MallGoodsCommentVo">
        select
        a.*,
        (select count(z.id) from mall_goods_comment z where z.goods_id=#{record.goodsId} and a.star <![CDATA[ > ]]> 4) greatNum,
        (select count(z.id) from mall_goods_comment z where z.goods_id=#{record.goodsId}
                                                        and (a.star <![CDATA[ >= ]]> 3 and a.star <![CDATA[ <= ]]> 4)) goodNum,
        (select count(z.id) from mall_goods_comment z where z.goods_id=#{record.goodsId} and (a.star <![CDATA[ < ]]> 3 )) badNum,
        b.name name,
        b.avatar avatar
        from mall_goods_comment a
@@ -259,4 +255,14 @@
            a.CREATED_TIME asc
    </select>


    <select id="findMallGoodsCommentLevelByGoodsId" resultType="cc.mrbird.febs.mall.vo.MallGoodsCommentVo">
        select
            (select count(z.id) from mall_goods_comment z where z.goods_id = #{id} and z.star <![CDATA[ > ]]> 4) greatNum,
            (select count(z.id) from mall_goods_comment z where z.goods_id = #{id}
                                                            and (z.star <![CDATA[ >= ]]> 3 and z.star <![CDATA[ <= ]]> 4)) goodNum,
            (select count(z.id) from mall_goods_comment z where z.goods_id = #{id} and (z.star <![CDATA[ < ]]> 3 )) badNum
        from mall_goods_comment a where a.goods_id = #{id}
    </select>

</mapper>