From 8d738d847973e1184a704b5ca3d4f492bffdb03f Mon Sep 17 00:00:00 2001
From: rentaiming <806181062@qq.com>
Date: 星期五, 26 七月 2024 09:01:37 +0800
Subject: [PATCH] 修改bug
---
ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java | 6 +++++-
1 files changed, 5 insertions(+), 1 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 a5d8666..ce21cbe 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
@@ -386,7 +386,11 @@
wrapper3.le(GoodsSku::getYears, parseTime7)
.ge(GoodsSku::getYears, parseTime15);
}
- wrapper3.orderByAsc(GoodsSku::getSortNum);
+ if (homeGoodsSkuDTO.getSort()==1){
+ wrapper3.last(" ORDER BY IF(isnull(sort_num),1,0), sort_num ASC");
+ }else{
+ wrapper3.last(",IF(isnull(sort_num),1,0), sort_num ASC");
+ }
Page<GoodsSku> page1 = this.page(page, wrapper3);
PageDTO<HomeGoodsSkuListVO> articleCommentsVOPageDTO = PageDTO.of(page1, HomeGoodsSkuListVO.class);
return articleCommentsVOPageDTO;
--
Gitblit v1.7.1