From f5cd5b650fd97026a2bab66ca6ec3ef04801e455 Mon Sep 17 00:00:00 2001 From: rentaiming <806181062@qq.com> Date: 星期二, 30 七月 2024 11:30:13 +0800 Subject: [PATCH] 修改bug --- ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java index 06ffee2..9fc7511 100644 --- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java +++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java @@ -394,8 +394,11 @@ wrapper3.le(GoodsSku::getYears, parseTime7) .ge(GoodsSku::getYears, parseTime15); } - wrapper3.orderByDesc(GoodsSku::getCreateTime); - wrapper3.last(",IF(isnull(sort_num),1,0), sort_num DESC"); + if (homeGoodsSkuDTO.getSort()==1){ + wrapper3.last(" ORDER BY IF(isnull(sort_num),1,0), sort_num DESC,create_time DESC"); + }else{ + wrapper3.last(",IF(isnull(sort_num),1,0), sort_num DESC,create_time DESC"); + } Page<GoodsSku> page1 = this.page(page, wrapper3); -- Gitblit v1.7.1