| | |
| | | package com.yeshi.fanli.dao.mybatis.taobao.dataoke; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.taobao.dataoke.DaTaoKeDetail; |
| | | |
| | | public interface DaTaoKeDetailMapper extends BaseMapper<DaTaoKeDetail> { |
| | | |
| | | /** |
| | | * 根据ID批量删除 |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | int deleteByIdList(@Param("ids") List<Long> ids); |
| | | |
| | | /** |
| | | * 批量插入 |
| | | * |
| | | * @param detailList |
| | | * @return |
| | | */ |
| | | int insertByBatch(@Param("detailList") List<DaTaoKeDetail> detailList); |
| | | |
| | | /** |
| | | * 通过最小更新时间做删除 |
| | | * |
| | | * @return |
| | | */ |
| | | int deleteByMinUpdateTime(Long minTime); |
| | | |
| | | /** |
| | | * 根据商品ID列表查询 |
| | | * |
| | | * @param goodsIdList |
| | | * @return |
| | | */ |
| | | List<DaTaoKeDetail> listByGoodsIds(@Param("goodsIdList") List<Long> goodsIdList); |
| | | |
| | | /** |
| | | * 根据主键ID查询 |
| | | * |
| | | * @param idList |
| | | * @return |
| | | */ |
| | | List<DaTaoKeDetail> listByIds(@Param("idList") List<Long> idList); |
| | | |
| | | /** |
| | | * 取出最新的id |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | List<DaTaoKeDetail> getGoodsNotInList(@Param("cid") Long cid, @Param("list") List<Long> list, |
| | | @Param("count") int count); |
| | | |
| | | /** |
| | | * 根据标题查询 |
| | | * |
| | | * @param dtitle |
| | | * @return |
| | | */ |
| | | List<DaTaoKeDetail> listByDtitle(String dtitle); |
| | | |
| | | /** |
| | | * 根据标题与分类搜索列表 |
| | | * |
| | | * @param title |
| | | * @param cid |
| | | * @param start |
| | | * @param count |
| | | * @return |
| | | */ |
| | | List<DaTaoKeDetail> listSearchByTitleWithCid(@Param("title") String key, @Param("cid") Long cid, |
| | | @Param("start") long start, @Param("count") int count); |
| | | |
| | | /** |
| | | * 根据标题与分类获取搜索列表数量 |
| | | * |
| | | * @param title |
| | | * @param cid |
| | | * @return |
| | | */ |
| | | Long countSearchByTitleWithCid(@Param("title") String key, @Param("cid") Long cid); |
| | | |
| | | /** |
| | | * 根据店铺id查询 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @param sellerId |
| | | * @return |
| | | */ |
| | | public List<DaTaoKeDetail> listBySellerId(@Param("start") long start, @Param("count") int count, |
| | | @Param("sellerId") Long sellerId); |
| | | |
| | | List<DaTaoKeDetail> listByCidAndMaxMinPrice(@Param("cid") Integer cid, @Param("maxPrice") BigDecimal maxPrice, |
| | | @Param("minPrice") BigDecimal minPrice, @Param("start") long start, @Param("count") int count); |
| | | |
| | | Long countByCidAndMaxMinPrice(@Param("cid") Integer cid, @Param("maxPrice") BigDecimal maxPrice, |
| | | @Param("minPrice") BigDecimal minPrice); |
| | | } |