From 9e560392543d3db3f269bbc0cb1f2c75e8f7f436 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Tue, 29 Jun 2021 16:23:47 +0800 Subject: [PATCH] modify --- gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml | 10 +++++++++- gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java | 3 +++ 2 files changed, 12 insertions(+), 1 deletions(-) diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java index d3be1d6..94f72da 100644 --- a/gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java +++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/XcxGoodsListDto.java @@ -32,4 +32,7 @@ @ApiModelProperty(value="每页显示记录数") private int pageSize=10; + @ApiModelProperty(value = "排序 1-综合 2-销量 3-价格") + private int sort = 1; + } diff --git a/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml index 9edd117..ba01ed8 100644 --- a/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml +++ b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml @@ -59,7 +59,15 @@ </if> </where> group by a.id - order by a.id desc + <if test="record.sort == 1"> + order by a.id desc + </if> + <if test="record.sort == 2"> + order by quantity desc + </if> + <if test="record.sort == 3"> + order by a.present_price desc + </if> </select> <resultMap id="goodsDetailsMap" type="com.xzx.gc.shop.vo.XcxGoodsDetailVo"> -- Gitblit v1.9.1