package com.yeshi.fanli.dao.mybatis.taobao;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.dao.BaseMapper;
|
import com.yeshi.fanli.entity.taobao.TaoBaoGoodsBrief;
|
|
public interface TaoBaoGoodsBriefMapper extends BaseMapper<TaoBaoGoodsBrief>{
|
|
|
int deleteByAuctionId(Long auctionId);
|
|
/*
|
* 根据商品id 批量删除
|
* @param list
|
*/
|
void deleteBatchByGoodsId(List<Long> list);
|
|
|
/**
|
* 根据auctionId 查询商品信息
|
*
|
* @param auctionId
|
* @return
|
*/
|
List<TaoBaoGoodsBrief> queryByAuctionId(@Param("auctionId") Long auctionId);
|
|
/**
|
* 批量插入
|
*
|
* @param list
|
* @return
|
*/
|
int insertBatch(List<TaoBaoGoodsBrief> list);
|
|
/**
|
* 根据多个auctionId 查询对应的商品信息
|
*
|
* @param list
|
* @return
|
*/
|
List<TaoBaoGoodsBrief> queryGoodsByAuctionId(List<Long> list);
|
|
|
/**
|
* 根据多个auctionId是否已存在
|
*
|
* @param list
|
* @return
|
*/
|
List<Long> listExistById(List<Long> list);
|
|
/**
|
* 批量更新
|
*
|
* @param list
|
*/
|
void updateBatchSelective(@Param("list") List<TaoBaoGoodsBrief> list);
|
|
/**
|
* 获取创建时间在某个时间点之前的商品
|
*
|
* @param maxTime
|
* @param start
|
* @param count
|
* @return
|
*/
|
List<TaoBaoGoodsBrief> queryGoodsByMaxCreateTime(@Param("maxTime") Date maxTime, @Param("start") int start,
|
@Param("count") int count);
|
|
List<TaoBaoGoodsBrief> queryGoodsByMaxUpdateTime(@Param("maxTime") Date maxTime, @Param("start") int start,
|
@Param("count") int count);
|
|
List<Long> queryCanDeleteGoods(@Param("maxTime") Date maxTime,@Param("start")int start,@Param("count")int count);
|
|
Long queryCanDeleteGoodsCount(@Param("maxTime") Date maxTime);
|
|
|
/**
|
* 根据店铺信息获取商品
|
* @param start
|
* @param count
|
* @param shopId
|
* @return
|
*/
|
List<TaoBaoGoodsBrief> listByShopId(@Param("start") long start, @Param("count") int count,
|
@Param("shopId") Long shopId);
|
|
long countByShopId(@Param("shopId") Long shopId);
|
|
}
|
