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>