xzx.git - Gitblit

			@@ -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;

			@@ -41,11 +41,17 @@
			a.*,
			sum(b.quantity) quantity,
			sum(b.stock) stock,
			max(b.present_price) maxPrice
			min(b.present_price) minPrice
			from xzx_score_goods a
			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>
			@@ -67,7 +73,7 @@
			order by quantity desc
			</if>
			<if test="record.sort == 3">
			order by maxPrice desc
			order by minPrice desc
			</if>
			</select>

	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	10 ●●●●● patch \| view \| raw \| blame \| history