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);
|
}
|
