From 88b54772dbcf5ecab1e2316e4e4626ac901b8908 Mon Sep 17 00:00:00 2001
From: yujian <yujian>
Date: 星期二, 22 一月 2019 15:58:24 +0800
Subject: [PATCH] 邀请码添加返回状态
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/lable/QualityFactoryMapper.java | 270 +++++++++++++++++++++++------------------------------
1 files changed, 118 insertions(+), 152 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 d277dbe..49f96ec 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
@@ -6,6 +6,7 @@
import org.apache.ibatis.annotations.Param;
import com.yeshi.fanli.entity.bus.lable.QualityFactory;
+import com.yeshi.fanli.vo.quality.QualityFactoryVO;
public interface QualityFactoryMapper {
@@ -20,132 +21,84 @@
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);
-
-
+ List<QualityFactory> queryAll(@Param("start") long start, @Param("count") int count, @Param("days") Integer days);
+
// 寰呮洿鏂扮簿閫夊晢鍝乮d
List<Long> queryNeedUpdate(@Param("start") long start, @Param("count") int count, @Param("hour") int hour);
-
+
// 缁熻闇�鏇存柊鍟嗗搧鏁伴噺
long countQueryNeedUpdate();
-
-
- // 绮鹃�夊簱鏌ヨ
- List<QualityFactory> query(@Param("start") long start, @Param("count") int count, @Param("key") String key,
- // 鎺掑簭瀛楁 锛氶攢閲忋�佷环鏍笺�佷剑閲�
- @Param("totalSales") Integer totalSales, @Param("price") Integer price, @Param("tkRate") Integer tkRate,
- // 鍟嗗搧鏉ユ簮銆佸叆搴撴椂闂�
- @Param("propor")Integer propor,@Param("goodsSource") Integer goodsSource, @Param("days") Integer days,
- // 鍦ㄥ敭浠疯寖鍥�
- @Param("startZkPrice") Integer startZkPrice, @Param("endZkPrice") Integer endZkPrice,
- // 鏈堥攢閲忚寖鍥�
- @Param("startBiz30day") Integer startBiz30day, @Param("endBiz30day") Integer endBiz30day,
- // 鏉冮噸鑼冨洿
- @Param("startWeight") Integer startWeight, @Param("endWeight") Integer endWeight,
- // 浣ｉ噾姣斾緥鑼冨洿
- @Param("startTkRate") Integer startTkRate, @Param("endTkRate") Integer endTkRate,
- // 鍒搁潰棰濓細鍑忓灏�
- @Param("startAmount") Integer startAmount, @Param("endAmount") Integer endAmount,
- // 鏄惁锛� 浼樻儬鍒� 銆佸寘閭�
- @Param("hasCoupon") Integer hasCoupon, @Param("freeShipment") Integer freeShipment,
- // 鏄惁锛氭秷璐硅�呬繚闅� 銆佹垚浜よ浆鍖�
- @Param("isPrepay") Integer isPrepay,@Param("payRate30") Integer payRate30,
- // 鏄惁锛氬ソ璇勭巼銆� 閫�娆剧巼
- @Param("goodRate") Integer goodRate,@Param("rfdRate") Integer rfdRate,
- // 鍒告瘮渚嬶細 鍒搁潰鍊�/鍦ㄥ敭浠�
- @Param("startPropor") Integer startPropor, @Param("endPropor") Integer endPropor,
- // 绫荤洰id 鎼滅储姝ょ被鍨�
- @Param("gcid") Long gcid, @Param("keyType") Integer keyType);
-
-
- long queryCount( @Param("key") String key, @Param("goodsSource") Integer goodsSource, @Param("days") Integer days,
- // 鍦ㄥ敭浠疯寖鍥�
- @Param("startZkPrice") Integer startZkPrice, @Param("endZkPrice") Integer endZkPrice,
- // 鏈堥攢閲忚寖鍥�
- @Param("startBiz30day") Integer startBiz30day, @Param("endBiz30day") Integer endBiz30day,
- // 鏉冮噸鑼冨洿
- @Param("startWeight") Integer startWeight, @Param("endWeight") Integer endWeight,
- // 浣ｉ噾姣斾緥鑼冨洿
- @Param("startTkRate") Integer startTkRate, @Param("endTkRate") Integer endTkRate,
- // 鍒搁潰棰濓細鍑忓灏�
- @Param("startAmount") Integer startAmount, @Param("endAmount") Integer endAmount,
- // 鏄惁锛� 浼樻儬鍒� 銆佸寘閭�
- @Param("hasCoupon") Integer hasCoupon, @Param("freeShipment") Integer freeShipment,
- // 鏄惁锛氭秷璐硅�呬繚闅� 銆佹垚浜よ浆鍖�
- @Param("isPrepay") Integer isPrepay,@Param("payRate30") Integer payRate30,
- // 鏄惁锛氬ソ璇勭巼銆� 閫�娆剧巼
- @Param("goodRate") Integer goodRate,@Param("rfdRate") Integer rfdRate,
- // 鍒告瘮渚嬶細 鍒搁潰鍊�/鍦ㄥ敭浠�
- @Param("startPropor") Integer startPropor, @Param("endPropor") Integer endPropor,
- // 绫荤洰id
- @Param("gcid") Long gcid, @Param("keyType") Integer keyType);
-
+ // 绮鹃�夊簱鏌ヨ
+ 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
@@ -154,18 +107,18 @@
* @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銆佹爣绛緄d
-
+ @Param("systemCid") Long systemCid, @Param("labId") Long labId, @Param("cids") String cids,
+ @Param("hasQuan") Integer hasQuan);// 鍒嗙被id銆佹爣绛緄d
+
/**
* 瀵瑰簲鏌ヨ绮鹃�夊晢鍝佹暟鎹簲鐢ㄥ墠绔粺璁�
- */
- long countQuery( @Param("key") String key, @Param("systemCid") Long systemCid,
- @Param("labId") Long labId, @Param("cids") String cids, @Param("hasQuan") Integer hasQuan);
-
-
-
+ */
+ 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
@@ -175,30 +128,29 @@
* @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);
-
+ @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);
-
-
-
+ @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
@@ -207,16 +159,15 @@
* @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("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
@@ -224,25 +175,23 @@
* @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);
-
+ 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);
-
-
-
-
+ */
+ 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
@@ -252,26 +201,25 @@
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);
-
+ 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
@@ -281,13 +229,13 @@
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);
-
+ long countQueryByRebateAmount(@Param("proportion") String proportion, @Param("startAmount") Integer startAmount,
+ @Param("endAmount") Integer endAmount, @Param("tkRate") double tkRate);
+
/**
* 杩斿埄閲戦鏁版嵁鏌ヨ - 棣栭〉涓嬫柟鏁版嵁
+ *
* @param start
* @param count
* @param key
@@ -296,55 +244,73 @@
*/
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);
+ @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 鍟嗗搧鏉ユ簮
+ *
+ * @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 鍏抽敭璇�
+ * @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,
+ 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);
+ 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);
+ 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);
}
--
Gitblit v1.8.0