package com.doumee.dao.business;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.doumee.dao.business.model.Shopcart;
import com.doumee.dao.web.response.goods.CartGoodsResponse;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author 江蹄蹄
 * @date 2023/03/21 15:48
 */
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  ," +
            " 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 ")
    IPage<CartGoodsResponse> cartGoodsPage(IPage page, @Param("memberId") Integer memberId);



}