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/ThreeSaleMapper.java | 197 ++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 162 insertions(+), 35 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java
index 2bbe0ac..79fa954 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java
@@ -26,23 +26,24 @@
int updateByPrimaryKey(ThreeSale record);
int effectThreeSale(Long workerUid);
-
+
/**
* 鏌ヨ涓�搴﹂槦鍛橀泦鍚�
+ *
* @param start
* @param count
* @param key
* @param uid
* @return
*/
- List<ThreeSale> queryMyFirstTeamList(@Param("start") int start, @Param("count") int count,
- @Param("key") String key,@Param("bossId") Long bossId);
-
- long queryCountMyFirstTeamList(@Param("key") String key,@Param("bossId") Long bossId);
-
-
- /**
+ List<ThreeSale> queryMyFirstTeamList(@Param("start") int start, @Param("count") int count, @Param("key") String key,
+ @Param("bossId") Long bossId);
+
+ long queryCountMyFirstTeamList(@Param("key") String key, @Param("bossId") Long bossId);
+
+ /**
* 鏌ヨ浜屽害闃熷憳闆嗗悎
+ *
* @param start
* @param count
* @param key
@@ -50,32 +51,158 @@
* @return
*/
List<ThreeSale> queryMySecondTeamList(@Param("start") int start, @Param("count") int count,
- @Param("key") String key,@Param("bossId") Long bossId);
+ @Param("key") String key, @Param("bossId") Long bossId);
+
+ long queryCountMySecondTeamList(@Param("key") String key, @Param("bossId") Long bossId);
+
+ /**
+ * 闀挎椂闂存湭閭�璇锋垚鍔熺敤鎴�
+ *
+ * @param daysNum
+ * @return
+ */
+ List<Long> queryLongTimeFailed(@Param("daysNum") int daysNum);
+
+ /**
+ * 闀挎椂闂� 閭�璇锋垚鍔熺敤鎴�
+ *
+ * @param daysNum
+ * @return
+ */
+ List<ThreeSale> queryLongTimeSuccess(@Param("daysNum") int daysNum);
+
+ /**
+ * 璁剧疆瀵瑰簲閭�璇疯繃鏈�
+ *
+ * @param list
+ * @return
+ */
+ int updateExpire(List<Long> list);
+
+ /**
+ * 涓�绾ф煡璇�
+ *
+ * @param start
+ * @param count
+ * @param key
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<ThreeSale> listFirstTeamQuery(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
+ @Param("state") Integer state, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ long countFirstTeamQuery(@Param("uid") Long uid, @Param("state") Integer state,
+ @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ /**
+ * 浜岀骇鏌ヨ
+ *
+ * @param start
+ * @param count
+ * @param key
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<ThreeSale> listSecondTeamQuery(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
+ @Param("state") Integer state, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ long countSecondTeamQuery(@Param("uid") Long uid, @Param("state") Integer state,
+ @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ /**
+ * 涓婄骇鏌ヨ
+ *
+ * @param start
+ * @param count
+ * @param uid
+ * @return
+ */
+ List<ThreeSale> listSuperiorQuery(@Param("start") long start, @Param("count") int count,
+ @Param("state") Integer state, @Param("uid") Long uid);
+
+ long countSuperiorQuery(@Param("state") Integer state, @Param("uid") Long uid);
+
+ /**
+ * 鏌ヨ涓�绾ч槦鍛�
+ *
+ * @param paramLong
+ * @param paramInt
+ * @param paramLong1
+ * @return
+ */
+ List<ThreeSale> listFirstTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid);
+
+ /**
+ * 缁熻涓�绾ч槦鍛�
+ *
+ * @param uid
+ * @param state
+ * @return
+ */
+ long countFirstTeam(@Param("uid") Long uid, @Param("state") Integer state);
+
+ /**
+ * 鏌ヨ浜岀骇闃熷憳
+ *
+ * @param start
+ * @param count
+ * @param uid
+ * @return
+ */
+ List<ThreeSale> listSecondTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid);
+
+ /**
+ * 缁熻浜岀骇闃熷憳
+ *
+ * @param uid
+ * @param state
+ * @return
+ */
+ long countSecondTeam(@Param("uid") Long uid, @Param("state") Integer state);
+
+ /**
+ *
+ * @param uid
+ * @return
+ */
+ ThreeSale getMyBoss(@Param("uid") Long uid);
+
+ /**
+ * 鏍规嵁id銆乽id鏌ヨ
+ *
+ * @param id
+ * @param uid
+ * @return
+ */
+ List<ThreeSale> listbyIdAndBossId(@Param("id") Long id, @Param("uid") Long uid, @Param("expire") Integer expire);
+
+ /**
+ * 鏍规嵁閭�璇疯�匢D鏌ヨ鍏崇郴
+ *
+ * @param workerId
+ * @return
+ */
+ List<ThreeSale> listByWorkerId(Long workerId);
- long queryCountMySecondTeamList(@Param("key") String key,@Param("bossId") Long bossId);
-
-
- /**
- * 闀挎椂闂存湭閭�璇锋垚鍔熺敤鎴�
- * @param daysNum
- * @return
- */
- List<Long> queryLongTimeFailed(@Param("daysNum") int daysNum);
-
-
- /**
- * 闀挎椂闂� 閭�璇锋垚鍔熺敤鎴�
- * @param daysNum
- * @return
- */
- List<ThreeSale> queryLongTimeSuccess(@Param("daysNum") int daysNum);
-
-
- /**
- * 璁剧疆瀵瑰簲閭�璇疯繃鏈�
- * @param list
- * @return
- */
- int updateExpire(List<Long> list);
-
+
+ /**
+ * 鑾峰彇鎴愬姛閭�璇峰叧绯绘暟閲�
+ *
+ * @param uid
+ * @return
+ */
+ int getSuccessRelationshipNum(@Param("uid") Long uid);
+
+
+ /**
+ * 鏍规嵁閭�璇疯�匢D銆乥ossID鏌ヨ 鏈夋晥鍏崇郴
+ *
+ * @param workerId
+ * @return
+ */
+ ThreeSale getRelationshipByBossIdAndWorkerId(@Param("bossId") Long bossId, @Param("workerId") Long workerId);
+
+
}
\ No newline at end of file
--
Gitblit v1.8.0