xiaoyong931011
2023-03-22 49090447988eb021f7cda6969bfc6fada41e3837
后台修改
1 files modified
3 ■■■■ changed files
src/main/resources/mapper/modules/MallGoodsMapper.xml 3 ●●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/MallGoodsMapper.xml
@@ -74,6 +74,7 @@
                a.present_price,
                a.score,
                a.is_hot,
                a.sort_cnt,
                min(b.present_price) price,
                sum(b.sku_volume) saleVolume
            from mall_goods a
@@ -110,7 +111,7 @@
<!--                order by a.is_hot, a.saleVolume desc, a.id-->
<!--            </if>-->
            <if test="record.sortType == 1">
                order by a.is_normal, a.sort_cnt asc
                order by a.sort_cnt asc
            </if>
            <if test="record.sortType == 2">
                order by a.saleVolume desc