Helius
2021-06-29 0e5c23039abc23aa2507e7d3f45e71f9fdd8aa8d
modify
2 files modified
11 ■■■■■ changed files
gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java 5 ●●●● patch | view | raw | blame | history
gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml 6 ●●●●● patch | view | raw | blame | history
gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java
@@ -18,7 +18,10 @@
    private String name;
    @ApiModelProperty(value = "积分")
    private String score;
    private Integer minScore;
    @ApiModelProperty(value = "积分")
    private Integer maxScore;
    @ApiModelProperty(value = "分类ID")
    private Long cateId;
gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml
@@ -46,6 +46,12 @@
        inner join xzx_score_goods_sku b on a.id=b.goods_id and b.del_flag=0
        <where>
            a.del_flag=0 and a.is_sale=1
            <if test="record.minScore != null" >
                and b.present_price >= #{minScore}
            </if>
            <if test="record.maxScore != null">
                and #{record.maxScore} > b.present_price
            </if>
            <if test="record.name != null and record.name != ''">
                and a.name like concat('%',#{record.name},'%')
            </if>