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/resources/mapper/modules/AiProductPointMapper.xml | 2 +-
src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java | 15 ++++++++++-----
src/main/resources/mapper/modules/AiProductMapper.xml | 2 +-
3 files changed, 12 insertions(+), 7 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 54f3c5c..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
@@ -59,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){
@@ -87,7 +88,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){
@@ -115,7 +117,8 @@
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){
@@ -138,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) {
@@ -176,7 +180,8 @@
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){
diff --git a/src/main/resources/mapper/modules/AiProductMapper.xml b/src/main/resources/mapper/modules/AiProductMapper.xml
index 18500d7..990b79b 100644
--- a/src/main/resources/mapper/modules/AiProductMapper.xml
+++ b/src/main/resources/mapper/modules/AiProductMapper.xml
@@ -28,6 +28,6 @@
</if>
</if>
</where>
- order by a.sort asc
+ order by a.sort desc
</select>
</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/modules/AiProductPointMapper.xml b/src/main/resources/mapper/modules/AiProductPointMapper.xml
index 8af028c..a430bc8 100644
--- a/src/main/resources/mapper/modules/AiProductPointMapper.xml
+++ b/src/main/resources/mapper/modules/AiProductPointMapper.xml
@@ -26,6 +26,6 @@
</if>
</if>
</where>
- order by a.sort asc
+ order by a.sort desc
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1