From f236a24c5766fb524a4dadc44a0f7b6ae288141c Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Tue, 21 Apr 2026 13:44:43 +0800
Subject: [PATCH] fix(ai): 修正产品分类和产品的排序逻辑,排序从升序改为降序

---
 src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java |   37 ++++++++++++++++++++-----------------
 1 files changed, 20 insertions(+), 17 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java
index f59f046..8da7f81 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java
@@ -2,6 +2,7 @@
 
 import cc.mrbird.febs.ai.entity.AiMemberRole;
 import cc.mrbird.febs.ai.entity.AiProductCategory;
+import cc.mrbird.febs.ai.enumerates.AiCommonEnum;
 import cc.mrbird.febs.ai.enumerates.ProductCategoryLevelEnum;
 import cc.mrbird.febs.ai.mapper.AiProductCategoryMapper;
 import cc.mrbird.febs.ai.req.productCategory.ApiProductCategoryAllDto;
@@ -58,7 +59,8 @@
         query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_TWO.getLevel());
         query.eq(AiProductCategory::getState, 1);
         query.eq(AiProductCategory::getHotState, 1);
-        query.orderByAsc(AiProductCategory::getSort);
+//        query.orderByAsc(AiProductCategory::getSort);
+        query.orderByDesc(AiProductCategory::getSort);
         List<AiProductCategory> listByQuery = this.getListByQuery(query);
         if (CollUtil.isNotEmpty(listByQuery)){
             for (AiProductCategory aiProductCategory : listByQuery){
@@ -79,15 +81,15 @@
         List<ApiProductCategoryVo> list = new ArrayList<>();
 
         LambdaQueryWrapper<AiProductCategory> query = Wrappers.lambdaQuery(AiProductCategory.class);
-        if (StrUtil.isNotEmpty(dto.getCompanyId())){
-            query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
-        }else{
-            query.isNull(AiProductCategory::getCompanyId);
+        if (StrUtil.isEmpty(dto.getCompanyId())){
+            dto.setCompanyId(AiCommonEnum.COMPANY_ID.getPrompt());
         }
+        query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
         query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_TWO.getLevel());
         query.eq(AiProductCategory::getState, 1);
         query.eq(AiProductCategory::getHotState, 1);
-        query.orderByAsc(AiProductCategory::getSort);
+//        query.orderByAsc(AiProductCategory::getSort);
+        query.orderByDesc(AiProductCategory::getSort);
         List<AiProductCategory> listByQuery = this.getListByQuery(query);
         if (CollUtil.isNotEmpty(listByQuery)){
             for (AiProductCategory aiProductCategory : listByQuery){
@@ -108,15 +110,15 @@
         List<ApiProductCategoryVo> list = new ArrayList<>();
 
         LambdaQueryWrapper<AiProductCategory> query = Wrappers.lambdaQuery(AiProductCategory.class);
-        if (StrUtil.isNotEmpty(dto.getCompanyId())){
-            query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
-        }else{
-            query.isNull(AiProductCategory::getCompanyId);
+        if (StrUtil.isEmpty(dto.getCompanyId())){
+            dto.setCompanyId(AiCommonEnum.COMPANY_ID.getPrompt());
         }
+        query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
         query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_ONE.getLevel());
         query.eq(AiProductCategory::getState, 1);
         query.eq(AiProductCategory::getHotState, 1);
-        query.orderByAsc(AiProductCategory::getSort);
+//        query.orderByAsc(AiProductCategory::getSort);
+        query.orderByDesc(AiProductCategory::getSort);
         List<AiProductCategory> listByQuery = this.getListByQuery(query);
         if (CollUtil.isNotEmpty(listByQuery)){
             for (AiProductCategory aiProductCategory : listByQuery){
@@ -139,7 +141,8 @@
                 Wrappers.lambdaQuery(AiProductCategory.class)
                         .eq(AiProductCategory::getParentId, dto.getParentId())
                         .eq(AiProductCategory::getState, 1)
-                .orderByAsc(AiProductCategory::getSort)
+//                .orderByAsc(AiProductCategory::getSort)
+                .orderByDesc(AiProductCategory::getSort)
         );
         if (CollUtil.isNotEmpty(aiProductCategories)){
             for (AiProductCategory aiProductCategory : aiProductCategories) {
@@ -171,14 +174,14 @@
     public FebsResponse allList(ApiProductCategoryAllDto dto) {
         List<ApiProductCategoryVo> list = new ArrayList<>();
         LambdaQueryWrapper<AiProductCategory> query = Wrappers.lambdaQuery(AiProductCategory.class);
-        if (StrUtil.isNotEmpty(dto.getCompanyId())){
-            query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
-        }else{
-            query.isNull(AiProductCategory::getCompanyId);
+        if (StrUtil.isEmpty(dto.getCompanyId())){
+            dto.setCompanyId(AiCommonEnum.COMPANY_ID.getPrompt());
         }
+        query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
         query.eq(AiProductCategory::getState, 1);
         query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_ONE.getLevel());
-        query.orderByAsc(AiProductCategory::getSort);
+//        query.orderByAsc(AiProductCategory::getSort);
+        query.orderByDesc(AiProductCategory::getSort);
         List<AiProductCategory> listByQuery = this.getListByQuery(query);
         if (CollUtil.isNotEmpty(listByQuery)){
             for (AiProductCategory aiProductCategory : listByQuery){

--
Gitblit v1.9.1