package com.yeshi.fanli.dao.mybatis.lable;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.dao.BaseMapper;
|
import com.yeshi.fanli.entity.bus.lable.QualityFactory;
|
import com.yeshi.fanli.vo.quality.QualityFactoryVO;
|
|
public interface QualityFactoryMapper extends BaseMapper<QualityFactory>{
|
|
|
/**
|
* 批量插入
|
*
|
* @param list
|
* @return
|
*/
|
int insertBatch(List<QualityFactory> list);
|
|
/**
|
* 批量选择更新
|
*
|
* @param list
|
* @return
|
*/
|
int updateBatchSelective(List<QualityFactory> list);
|
|
/**
|
* 批量删除
|
*
|
* @param list
|
* @return
|
*/
|
int deleteBatchByPrimaryKey(List<Long> list);
|
|
|
/**
|
* 根据商品id 批量删除
|
* @param list
|
*/
|
void deleteBatchByGoodsId(List<Long> list);
|
|
/**
|
* 统计总行数
|
*
|
* @return
|
*/
|
Long countTotalRows(@Param("days") Integer days);
|
|
List<QualityFactory> queryByGoodsId(@Param("goodsId") Long goodsId);
|
|
|
/**
|
* 根据商品id查询
|
* @param auctionId
|
* @return
|
*/
|
QualityFactory getByAuctionId(@Param("auctionId") Long auctionId);
|
|
|
/**
|
* 根据多个商品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);
|
|
// 精选库查询
|
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);
|
|
|
/**
|
* 子类查询
|
*
|
* @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();
|
|
/**
|
* 限时秒杀 随机3个商品
|
* @return
|
*/
|
List<QualityFactory> listFlashSaleRandGoods();
|
|
/**
|
* 返利金额数据查询
|
*
|
* @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);
|
|
/**
|
* 按最低销量倒叙排列
|
*
|
* @param salesCount
|
* @param start
|
* @param count
|
* @return
|
*/
|
List<QualityFactory> listFreeGoods(@Param("start") long start, @Param("count") int count);
|
|
long countFreeGoods();
|
|
|
/**
|
* 根据店铺信息获取商品
|
* @param start
|
* @param count
|
* @param shopId
|
* @return
|
*/
|
List<QualityFactory> listByShopId(@Param("start") long start, @Param("count") int count,
|
@Param("shopId") Long shopId);
|
|
long countByShopId(@Param("shopId") Long shopId);
|
|
|
|
/**
|
* 9k9类
|
*
|
*/
|
List<QualityFactory> get9k9ClassGoods(@Param("start") long start, @Param("count") int count,
|
@Param("biz30day") Integer biz30day, @Param("zkPrice") BigDecimal zkPrice,
|
@Param("minQuanPrice") BigDecimal minQuanPrice, @Param("maxQuanPrice") BigDecimal maxQuanPrice,
|
@Param("cids") String cids);
|
|
long count9k9ClassGoods(@Param("biz30day") Integer biz30day, @Param("zkPrice") BigDecimal zkPrice,
|
@Param("minQuanPrice") BigDecimal minQuanPrice, @Param("maxQuanPrice") BigDecimal maxQuanPrice
|
,@Param("cids") String cids);
|
|
|
|
/**
|
* 今日必抢 - 9k9
|
*
|
*/
|
List<QualityFactory> listQueryEverydayRob(@Param("start") long start, @Param("count") int count,
|
@Param("zkPrice") BigDecimal zkPrice,
|
@Param("minQuanPrice") BigDecimal minQuanPrice, @Param("maxQuanPrice") BigDecimal maxQuanPrice);
|
|
long countQueryEverydayRob(@Param("zkPrice") BigDecimal zkPrice,
|
@Param("minQuanPrice") BigDecimal minQuanPrice, @Param("maxQuanPrice") BigDecimal maxQuanPrice);
|
|
|
}
|
