From ee83bd226e5eebef8124809ee42498c89ed29fb1 Mon Sep 17 00:00:00 2001
From: Cui Zhi Feng <7426394+wuxixiaocui@user.noreply.gitee.com>
Date: 星期五, 27 九月 2024 15:42:19 +0800
Subject: [PATCH] 商品销量排序
---
src/main/java/com/mzl/flower/service/flower/FlowerService.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/mzl/flower/service/flower/FlowerService.java b/src/main/java/com/mzl/flower/service/flower/FlowerService.java
index 9cc9169..f7f4821 100644
--- a/src/main/java/com/mzl/flower/service/flower/FlowerService.java
+++ b/src/main/java/com/mzl/flower/service/flower/FlowerService.java
@@ -693,9 +693,10 @@
public Page<FlowerShowListDTO> myCollect(Page page, FlowerShowQueryDTO dto) {
dto.setUserId(SecurityUtils.getUserId());
if (StringUtils.isNotEmpty(dto.getColumn())) {
- if(dto.getColumn().contains("sales")
- || dto.getColumn().contains("stock")){
+ if(dto.getColumn().contains("stock")){
dto.setColumn(dto.getColumn() + " desc");
+ } else if (dto.getColumn().contains("sales")) {
+ dto.setColumn("ifnull(sales, 0) + ifnull(real_sales, 0) desc");
}
}
--
Gitblit v1.9.3