package cn.lili.modules.goods.mapper;
|
|
import cn.lili.modules.goods.entity.dos.GoodsSku;
|
import cn.lili.modules.goods.entity.dto.GoodsSkuDTO;
|
import cn.lili.modules.goods.entity.dto.GoodsSkuStockDTO;
|
import cn.lili.modules.order.order.entity.dto.OrderExportDTO;
|
import cn.lili.modules.order.order.entity.vo.OrderSimpleVO;
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 规格项数据处理层
|
*
|
* @author pikachu
|
* @since 2020-02-18 15:18:56
|
*/
|
public interface GoodsSkuMapper extends BaseMapper<GoodsSku> {
|
|
/**
|
* 根据商品id获取全部skuId的集合
|
*
|
* @param goodsId goodsId
|
* @return 全部skuId的集合
|
*/
|
@Select("SELECT id FROM li_goods_sku WHERE goods_id = #{goodsId}")
|
List<String> getGoodsSkuIdByGoodsId(String goodsId);
|
|
|
@Insert("replace into li_goods_sku (\n" +
|
"\tid,\n" +
|
"\tgoods_id,\n" +
|
"\tspecs,\n" +
|
"\tsimple_specs,\n" +
|
"\tfreight_template_id,\n" +
|
"\tgoods_name,\n" +
|
"\tsn,\n" +
|
"\tbrand_id,\n" +
|
"\tcategory_path,\n" +
|
"\tgoods_unit,\n" +
|
"\tselling_point,\n" +
|
"\tweight,\n" +
|
"\tmarket_enable,\n" +
|
"\tintro,\n" +
|
"\tprice,\n" +
|
"\tcost,\n" +
|
"\tquantity,\n" +
|
"\tgrade,\n" +
|
"\tthumbnail,\n" +
|
"\tsmall,\n" +
|
"\tstore_category_path,\n" +
|
"\tstore_id,\n" +
|
"\tstore_name,\n" +
|
"\tauth_flag,\n" +
|
"\tself_operated,\n" +
|
"\tmobile_intro,\n" +
|
"\trecommend,\n" +
|
"\tsales_model,\n" +
|
"\tgoods_type,\n" +
|
"\tcreate_by,\n" +
|
"\tcreate_time,\n" +
|
"\tupdate_time,\n" +
|
"\tdelete_flag \n" +
|
")\n" +
|
" VALUES\n" +
|
"(\n" +
|
"\t#{goodsSku.id},\n" +
|
"\t#{goodsSku.goodsId},\n" +
|
"\t#{goodsSku.specs},\n" +
|
"\t#{goodsSku.simpleSpecs},\n" +
|
"\t#{goodsSku.freightTemplateId},\n" +
|
"\t#{goodsSku.goodsName},\n" +
|
"\t#{goodsSku.sn},\n" +
|
"\t#{goodsSku.brandId},\n" +
|
"\t#{goodsSku.categoryPath},\n" +
|
"\t#{goodsSku.goodsUnit},\n" +
|
"\t#{goodsSku.sellingPoint},\n" +
|
"\t#{goodsSku.weight},\n" +
|
"\t#{goodsSku.marketEnable},\n" +
|
"\t#{goodsSku.intro},\n" +
|
"\t#{goodsSku.price},\n" +
|
"\t#{goodsSku.cost},\n" +
|
"\t#{goodsSku.quantity},\n" +
|
"\t#{goodsSku.grade},\n" +
|
"\t#{goodsSku.thumbnail},\n" +
|
"\t#{goodsSku.small},\n" +
|
"\t#{goodsSku.storeCategoryPath},\n" +
|
"\t#{goodsSku.storeId},\n" +
|
"\t#{goodsSku.storeName},\n" +
|
"\t#{goodsSku.authFlag},\n" +
|
"\t#{goodsSku.selfOperated},\n" +
|
"\t#{goodsSku.mobileIntro},\n" +
|
"\t#{goodsSku.recommend},\n" +
|
"\t#{goodsSku.salesModel},\n" +
|
"\t#{goodsSku.goodsType},\n" +
|
"\t#{goodsSku.createBy},\n" +
|
"\t#{goodsSku.createTime},\n" +
|
"\t#{goodsSku.updateTime},\n" +
|
"\t#{goodsSku.deleteFlag}\n" +
|
")")
|
int replaceGoodsSku(@Param("goodsSku") GoodsSku goodsSku);
|
|
|
/**
|
* 分页查询商品skuDTO
|
*
|
* @param page 分页
|
* @param queryWrapper 查询条件
|
* @return 售后VO分页
|
*/
|
@Select("SELECT *,g.params as params FROM li_goods_sku gs inner join li_goods g on gs.goods_id = g.id ${ew.customSqlSegment}")
|
IPage<GoodsSkuDTO> queryByParams(IPage<GoodsSkuDTO> page, @Param(Constants.WRAPPER) Wrapper<GoodsSkuDTO> queryWrapper);
|
|
@Select("SELECT id as sku_id, quantity, goods_id,simple_specs,sn,goods_name FROM li_goods_sku ${ew.customSqlSegment}")
|
List<GoodsSkuStockDTO> queryStocks(@Param(Constants.WRAPPER) Wrapper<GoodsSku> queryWrapper);
|
|
}
|
