From bf7b975c7ebe94ac801d72671cefc4d6ec01d56e Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期一, 23 三月 2026 09:39:07 +0800
Subject: [PATCH] 小程序 接口开发
---
server/dmmall_service/src/main/java/com/doumee/service/business/impl/CollectServiceImpl.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/server/dmmall_service/src/main/java/com/doumee/service/business/impl/CollectServiceImpl.java b/server/dmmall_service/src/main/java/com/doumee/service/business/impl/CollectServiceImpl.java
index 18ddbf7..9a9a3de 100644
--- a/server/dmmall_service/src/main/java/com/doumee/service/business/impl/CollectServiceImpl.java
+++ b/server/dmmall_service/src/main/java/com/doumee/service/business/impl/CollectServiceImpl.java
@@ -234,7 +234,8 @@
.selectAs(Goods::getName,Collect::getName)
.selectAs(Goods::getPrice,Collect::getPrice)
.selectAs(Goods::getImgurl,Collect::getActivityImgurl)
- .select(" ifnull(( select min(gs.PRICE) from goods_sku gs where gs.GOODS_ID = t1.id ),0) ", Collect::getLinePrice)
+ .select(" ifnull(( select min(gs.PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Collect::getMinPrice)
+ .select(" ifnull(( select min(gs.SHOW_PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Collect::getLinePrice)
.leftJoin(Goods.class,Goods::getId,Collect::getObjId)
.eq(Collect::getIsdeleted,Constants.ZERO)
.eq(Collect::getMemberId,memberId)
@@ -252,6 +253,7 @@
.selectAs(Activity::getCreateDate,Collect::getReleaseDate)
.selectAs(Activity::getLooknum,Collect::getReadNum)
.selectAs(Activity::getImgurl,Collect::getActivityImgurl)
+ .selectAs(Labels::getParam,Collect::getParam)
.selectAs(Labels::getName,Collect::getLabelName)
.selectAs(Activity::getContent,Collect::getContent)
.leftJoin(Activity.class,Activity::getId,Collect::getObjId)
--
Gitblit v1.9.3