From cbe044eba8ed473727dd0a0601d8b88ad2b6f417 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期五, 27 二月 2026 16:04:18 +0800
Subject: [PATCH] 小程序 接口开发
---
server/dmmall_service/src/main/java/com/doumee/dao/business/ShopcartMapper.java | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/server/dmmall_service/src/main/java/com/doumee/dao/business/ShopcartMapper.java b/server/dmmall_service/src/main/java/com/doumee/dao/business/ShopcartMapper.java
index ff110ae..4caf5cb 100644
--- a/server/dmmall_service/src/main/java/com/doumee/dao/business/ShopcartMapper.java
+++ b/server/dmmall_service/src/main/java/com/doumee/dao/business/ShopcartMapper.java
@@ -13,7 +13,8 @@
*/
public interface ShopcartMapper extends BaseMapper<Shopcart> {
- @Select(" select s.id as shopCartId , s.GOODS_SKU_ID as goodsSkuId , s.PRODUCT_ID as goodsId , g.name as goodsName , gs.`NAME` as skuName , s.num , gs.PRICE , ifnull(gs.STATUS,1) as status ," +
+ @Select(" select s.id as shopCartId , s.GOODS_SKU_ID as goodsSkuId , s.PRODUCT_ID as goodsId , g.name as goodsName , gs.`NAME` as skuName , s.num , gs.PRICE ," +
+ " CASE WHEN ( g.ISDELETED = 1 || g.`STATUS` = 1 || gs.ISDELETED = 1 ) THEN 1 ELSE 0 END status," +
"case when gs.IMGURL = '' then g.IMGURL when gs.IMGURL is null then g.IMGURL else gs.IMGURL end imgUrl " +
" from shopcart s left join goods g on s.PRODUCT_ID = g.ID left join goods_sku gs ON s.GOODS_SKU_ID = gs.id " +
" where 1 = 1 and s.member_id = #{memberId} order by s.CREATE_DATE desc ")
--
Gitblit v1.9.3