From 0588d6be74335f41c79a8d8e32dbd1c3d3e47fa3 Mon Sep 17 00:00:00 2001 From: yujian <yujian@123.com> Date: 星期三, 29 五月 2019 17:20:50 +0800 Subject: [PATCH] 精选库商品入库及更新调整 + 9k9类商品查询取消标签查询 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java | 78 ++++++++++++++++++++++++-------------- 1 files changed, 49 insertions(+), 29 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java index eb58fe9..546521c 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java @@ -1,26 +1,17 @@ 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 { +public interface QualityFactoryMapper extends BaseMapper<QualityFactory>{ - int deleteByPrimaryKey(Long id); - - int insert(QualityFactory record); - - int insertSelective(QualityFactory record); - - QualityFactory selectByPrimaryKey(Long id); - - int updateByPrimaryKeySelective(QualityFactory record); - - int updateByPrimaryKey(QualityFactory record); /** * 鎵归噺鎻掑叆 @@ -45,6 +36,13 @@ * @return */ int deleteBatchByPrimaryKey(List<Long> list); + + + /** + * 鏍规嵁鍟嗗搧id 鎵归噺鍒犻櫎 + * @param list + */ + void deleteBatchByGoodsId(List<Long> list); /** * 缁熻鎬昏鏁� @@ -54,6 +52,15 @@ Long countTotalRows(@Param("days") Integer days); List<QualityFactory> queryByGoodsId(@Param("goodsId") Long goodsId); + + + /** + * 鏍规嵁鍟嗗搧id鏌ヨ + * @param auctionId + * @return + */ + QualityFactory getByAuctionId(@Param("auctionId") Long auctionId); + /** * 鏍规嵁澶氫釜鍟嗗搧id 鏌ヨ瀵瑰簲鐨勫晢鍝佷俊鎭� @@ -148,23 +155,7 @@ */ 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); - + /** * 瀛愮被鏌ヨ * @@ -344,5 +335,34 @@ @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); + } -- Gitblit v1.8.0