| | |
|---|
| | | */ |
|---|
| | | 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 ") |
|---|
