package com.yeshi.fanli.dao.mybatis.lable;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.yeshi.fanli.entity.bus.lable.QualityFactory;
import com.yeshi.fanli.vo.quality.QualityFactoryVO;

public interface QualityFactoryMapper {

	int deleteByPrimaryKey(Long id);

	int insert(QualityFactory record);

	int insertSelective(QualityFactory record);

	QualityFactory selectByPrimaryKey(Long id);

	int updateByPrimaryKeySelective(QualityFactory record);

	int updateByPrimaryKey(QualityFactory record);

	/**
	 * 批量插入
	 * 
	 * @param list
	 * @return
	 */
	int insertBatch(List<QualityFactory> list);

	/**
	 * 批量选择更新
	 * 
	 * @param list
	 * @return
	 */
	int updateBatchSelective(List<QualityFactory> list);

	/**
	 * 批量删除
	 * 
	 * @param list
	 * @return
	 */
	int deleteBatchByPrimaryKey(List<Long> list);

	/**
	 * 统计总行数
	 * 
	 * @return
	 */
	Long countTotalRows(@Param("days") Integer days);

	List<QualityFactory> queryByGoodsId(@Param("goodsId") Long goodsId);

	/**
	 * 根据多个商品id 查询对应的商品信息
	 * 
	 * @param list
	 * @return
	 */
	List<QualityFactory> listQueryGoodsByGoodsId(List<Long> list);

	Long queryCountByGoodsId(@Param("goodsId") Long goodsId);

	List<QualityFactory> listQueryByAuctionId(List<Long> list);

	// 精选库查询 -- 查询所有
	List<QualityFactory> queryAll(@Param("start") long start, @Param("count") int count, @Param("days") Integer days);

	// 待更新精选商品id
	List<Long> queryNeedUpdate(@Param("start") long start, @Param("count") int count, @Param("hour") int hour);

	// 统计需更新商品数量
	long countQueryNeedUpdate();

	// 精选库查询
	List<QualityFactory> query(QualityFactoryVO qualityFactoryVO);

	long queryCount(QualityFactoryVO qualityFactoryVO);

	/**
	 * 统计商品数量
	 * 
	 * @return
	 */
	Map<String, Object> getCountAll();

	/**
	 * 根据商品id移除精选库
	 * 
	 * @param goodsId
	 * @return
	 */
	int deleteByGoodsId(Long goodsId);

	/**
	 * 查询精选商品数据应用前端
	 * 
	 * @param start
	 * @param count
	 * @param key
	 * @param classId
	 * @param labId
	 * @return
	 */
	List<QualityFactory> listQuery(@Param("start") long start, @Param("count") int count, @Param("key") String key,
			@Param("systemCid") Long systemCid, @Param("labId") Long labId, @Param("cids") String cids,
			@Param("hasQuan") Integer hasQuan);// 分类id、标签id

	/**
	 * 对应查询精选商品数据应用前端统计
	 */
	long countQuery(@Param("key") String key, @Param("systemCid") Long systemCid, @Param("labId") Long labId,
			@Param("cids") String cids, @Param("hasQuan") Integer hasQuan);

	/**
	 * 根据关键词 搜索商品标题和标签
	 * 
	 * @param start
	 * @param count
	 * @param systemCid
	 * @param key
	 * @param list
	 * @param sort
	 * @return
	 */
	List<QualityFactory> listQueryByKeyAndlabIDs(@Param("start") long start, @Param("count") int count,
			@Param("key") String key, @Param("list") List<Long> list, @Param("sort") Integer sort,
			@Param("systemCid") Long systemCid, @Param("hasQuan") Integer hasQuan, @Param("userType") Integer userType,
			@Param("biz30day") Integer biz30day,
			// 在售价范围
			@Param("startprice") Integer startprice, @Param("endprice") Integer endprice);

	long countQueryKeyAndlabIDs(@Param("key") String key, @Param("list") List<Long> list, Long systemCid,
			@Param("hasQuan") Integer hasQuan, @Param("userType") Integer userType, @Param("biz30day") Integer biz30day,
			// 在售价范围
			@Param("startprice") Integer startprice, @Param("endprice") Integer endprice);

	/**
	 * 根据类目id删除商品
	 * 
	 * @param doTime
	 * @param gcids
	 * @return
	 */
	int removeStorageGoods(String doTime, Long gcids);

	/**
	 * 今日必抢 - 9k9
	 * 
	 * @param start
	 * @param count
	 * @param systemCid
	 * @param labId
	 * @param sortField
	 * @return
	 */
	List<QualityFactory> listQueryEverydayRob(@Param("start") long start, @Param("count") int count,
			@Param("systemCid") Long systemCid, @Param("labId") Long labId, @Param("sortField") Integer sortField,
			@Param("startCouponAmount") Double startCouponAmount, @Param("endCouponAmount") Double endCouponAmount);

	long countQueryEverydayRob(@Param("systemCid") Long systemCid, @Param("labId") Long labId,
			@Param("startCouponAmount") Double startCouponAmount, @Param("endCouponAmount") Double endCouponAmount);

	/**
	 * 子类查询
	 * 
	 * @param start
	 * @param count
	 * @param key
	 * @param classId
	 * @param labId
	 * @return
	 */
	List<QualityFactory> listQueryByKey(@Param("start") long start, @Param("count") int count, @Param("key") String key,
			@Param("sort") Integer sort, @Param("systemCid") Long systemCid, @Param("hasQuan") Integer hasQuan,
			@Param("userType") Integer userType, @Param("biz30day") Integer biz30day,
			// 在售价范围
			@Param("startprice") Integer startprice, @Param("endprice") Integer endprice);

	/**
	 * 子类查询
	 */
	long countQueryByKey(@Param("key") String key, @Param("systemCid") Long systemCid,
			@Param("hasQuan") Integer hasQuan, @Param("userType") Integer userType, @Param("biz30day") Integer biz30day,
			// 在售价范围
			@Param("startprice") Integer startprice, @Param("endprice") Integer endprice);

	/**
	 * 券面额数据查询
	 * 
	 * @param start
	 * @param count
	 * @param key
	 * @param systemCid
	 * @return
	 */
	List<QualityFactory> listQueryByCouponAmount(@Param("start") long start, @Param("count") int count,
			@Param("startAmount") Integer startAmount, @Param("endAmount") Integer endAmount,
			@Param("startPropor") Integer startPropor);

	long countQueryByCouponAmount(@Param("startAmount") Integer startAmount, @Param("endAmount") Integer endAmount,
			@Param("startPropor") Integer startPropor);

	/**
	 * 限时抢购商品
	 * 
	 * @param start
	 * @param count
	 * @param periodtime
	 * @return
	 */
	List<QualityFactory> listQueryByFlashSale(@Param("start") long start, @Param("count") int count);

	long countQueryByFlashSale();

	/**
	 * 返利金额数据查询
	 * 
	 * @param start
	 * @param count
	 * @param key
	 * @param systemCid
	 * @return
	 */
	List<QualityFactory> listQueryByRebateAmount(@Param("start") long start, @Param("count") int count,
			@Param("proportion") String proportion, @Param("startAmount") Integer startAmount,
			@Param("endAmount") Integer endAmount, @Param("tkRate") double tkRate);

	long countQueryByRebateAmount(@Param("proportion") String proportion, @Param("startAmount") Integer startAmount,
			@Param("endAmount") Integer endAmount, @Param("tkRate") double tkRate);

	/**
	 * 返利金额数据查询 - 首页下方数据
	 * 
	 * @param start
	 * @param count
	 * @param key
	 * @param systemCid
	 * @return
	 */
	List<QualityFactory> listRecommendToIndex(@Param("start") long start, @Param("count") int count,
			@Param("proportion") Double proportion, @Param("commision") Integer commision,
			@Param("couponAmount") Integer couponAmount, @Param("tkRate") double tkRate,
			@Param("couponRatio") Double couponRatio);

	long countRecommendToIndex(@Param("proportion") Double proportion, @Param("commision") Integer commision,
			@Param("couponAmount") Integer couponAmount, @Param("tkRate") double tkRate,
			@Param("couponRatio") Double couponRatio);

	/**
	 * 根据时间 获取dateTime时间之前创建的商品信息
	 * 
	 * @param systemCid
	 *            系统分类id
	 * @param dateTime
	 *            筛选时间
	 * @param goodsSource
	 *            商品来源
	 * @return
	 */
	List<Long> getAuctionIdbyClassId(@Param("systemCid") Long systemCid, @Param("goodsSource") Integer goodsSource,
			@Param("beforeTime") String beforeTime);

	/**
	 * 更新权重
	 * 
	 * @param weight
	 * @param time
	 * @return
	 */
	void updateWeight(@Param("weight") Integer weight, @Param("time") Integer time);

	// 查询优惠券-当日
	List<QualityFactory> queryToCouponColumn(@Param("start") long start, @Param("count") int count);

	long countQueryToCouponColumn();

	/**
	 * 搜索-推荐商品
	 * 
	 * @param start
	 * @param count
	 * @param key
	 *            关键词
	 * @return
	 */
	List<QualityFactory> listRecommendBykey(@Param("start") long start, @Param("count") int count,
			@Param("key") String key, @Param("hasQuan") Integer hasQuan, @Param("userType") Integer userType,
			@Param("startprice") Double startprice, @Param("endprice") Double endprice,
			@Param("startTkRate") Double startTkRate, @Param("endTkRate") Double endTkRate,
			@Param("sort") Integer sort);

	long countRecommendBykey(@Param("key") String key, @Param("hasQuan") Integer hasQuan,
			@Param("userType") Integer userType, @Param("startprice") Double startprice,
			@Param("endprice") Double endprice, @Param("startTkRate") Double startTkRate,
			@Param("endTkRate") Double endTkRate);

	List<QualityFactory> listQueryBylabIDs(@Param("start") long start, @Param("count") int count,
			@Param("list") List<Long> list, @Param("gid") Long gid, @Param("systemCid") Long systemCid);

	/**
	 * 按最低销量倒叙排列
	 * 
	 * @param salesCount
	 * @param start
	 * @param count
	 * @return
	 */
	List<QualityFactory> listByMinSalesCountOrderByCreateTimeDesc(@Param("salesCount") int salesCount,
			@Param("start") long start, @Param("count") int count);

}