package com.doumee.dao.business;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.doumee.dao.business.model.GoodsSku;
|
import com.doumee.dao.web.response.goods.GoodsSkuAttrResponse;
|
import com.doumee.dao.web.response.goods.GoodsSkuResponse;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* @author 江蹄蹄
|
* @date 2023/03/21 15:48
|
*/
|
public interface GoodsSkuMapper extends BaseMapper<GoodsSku> {
|
|
/**
|
* 商品SKU规格组明细列表
|
* @param goodsId
|
* @return
|
*/
|
@Select(" select s.* , g.IMGURL as goodsImgUrl from goods_sku s left join goods g on s.GOODS_ID = g.id where s.goods_Id = #{goodsId} ")
|
List<GoodsSkuResponse> getSkuResponseList(@Param("goodsId") Integer goodsId);
|
|
}
|
