package com.matrix.system.shopXcx.dao;

import com.matrix.system.shopXcx.pojo.SalesStatistics;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
import java.util.Set;

import com.matrix.core.pojo.PaginationVO;
import com.matrix.system.shopXcx.bean.ShopSku;

/**
 * @description 产品规格表
 * @author jyy
 * @date 2019-06-10 10:58
 */
public interface ShopSkuDao{

	public int insert(@Param("item") ShopSku shopSku);
   	
   	public int batchInsert(@Param("list") List<ShopSku> shopSkuList);
   	
	public int updateByMap(Map<String, Object> modifyMap);
	
	public int updateByModel(@Param("record") ShopSku shopSku);
	
	public int deleteByIds(@Param("list") List<String> list);
	
	public int deleteById(Integer id);

	public int deleteByModel(@Param("record") ShopSku shopSku);
	
	public List<ShopSku> selectInPage(@Param("record") ShopSku shopSku, @Param("pageVo") PaginationVO pageVo);

	public List<ShopSku> selectByModel(@Param("record") ShopSku shopSku);
	
	public int selectTotalRecord(@Param("record") ShopSku shopSku);
	
	public ShopSku  selectById(Integer id);

	
	public ShopSku  selectForUpdate(Integer id);

	List<ShopSku> selectByIds(@Param("ids") List<Integer> ids);

	public List<ShopSku> selectByPid(Integer pid);

	public List<ShopSku> selectByPidAndShopid(@Param("pid") Integer pid, @Param("shopId") Long shopId);

	/**
	 * 查询上架状态的规格列表
	 * @return
	 */
	List<ShopSku> selectSkuByInUse();

	/**
	 * 查询待配送的规格及其数量
	 * @return
	 */
	List<ShopSku> selectWaitSendSkuInfo();

	/**
	 * 批量更新库存
	 * @param list
	 * @return
	 */
	int updateBatch(@Param("list") List<ShopSku> list);


	List<SalesStatistics> salesStatistics(@Param("record")ShopSku shopSku, @Param("pageVo")PaginationVO pageVo);

	int selectTotalsalesStatistics(@Param("record")ShopSku shopSku);
}