From 8c04d27e5cebb7e654c208533e9567c4df2c8acc Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期四, 12 十二月 2019 14:21:44 +0800 Subject: [PATCH] 券时间限制 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java | 203 ++++++++++++++++++++++++++------------------------ 1 files changed, 105 insertions(+), 98 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java index 3822cbe..7e5d18a 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java @@ -1,99 +1,106 @@ -package com.yeshi.fanli.dao.mybatis.taobao.dataoke; - -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); - +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); } \ No newline at end of file -- Gitblit v1.8.0