商品排序

xiaoyong931011

2023-02-22 b962aac0451d33455bd4a9e55eccf7ca0b0ab789

商品排序

 src/main/resources/mapper/modules/MallGoodsMapper.xml

@@ -118,8 +118,11 @@
            order by a.order_number ASC
        ) a
        <if test="record.sortType != null">
<!--            <if test="record.sortType == 1">-->
<!--                order by a.is_hot, a.saleVolume desc, a.id-->
<!--            </if>-->
            <if test="record.sortType == 1">
                order by a.is_hot, a.saleVolume desc, a.id
                order by a.order_number ASC
            </if>
            <if test="record.sortType == 2">
                order by a.saleVolume desc