From c4c815aa52043ce5a3cac1987dda6fefd1d521b7 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期三, 18 十二月 2019 14:54:32 +0800
Subject: [PATCH] 排序修改
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java | 88 +++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 86 insertions(+), 2 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 79fa954..ee23ea8 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,6 +26,23 @@
int updateByPrimaryKey(ThreeSale record);
int effectThreeSale(Long workerUid);
+
+ /**
+ * 鍒犻櫎澶辨晥
+ * @param bossId
+ * @param workerId
+ * @return
+ */
+ int deleteExpireRecord(@Param("bossId")Long bossId, @Param("workerId")Long workerId);
+
+ /**
+ * 澶辨晥
+ * @param bossId
+ * @param workerId
+ * @return
+ */
+ List<ThreeSale> getExpireRecord(@Param("bossId")Long bossId, @Param("workerId")Long workerId);
+
/**
* 鏌ヨ涓�搴﹂槦鍛橀泦鍚�
@@ -132,7 +149,8 @@
* @param paramLong1
* @return
*/
- List<ThreeSale> listFirstTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid);
+ List<ThreeSale> listFirstTeam(@Param("start") long start, @Param("count") int count,
+ @Param("uid") Long uid, @Param("state") Integer state);
/**
* 缁熻涓�绾ч槦鍛�
@@ -151,7 +169,8 @@
* @param uid
* @return
*/
- List<ThreeSale> listSecondTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid);
+ List<ThreeSale> listSecondTeam(@Param("start") long start, @Param("count") int count,
+ @Param("uid") Long uid,@Param("state") Integer state);
/**
* 缁熻浜岀骇闃熷憳
@@ -204,5 +223,70 @@
*/
ThreeSale getRelationshipByBossIdAndWorkerId(@Param("bossId") Long bossId, @Param("workerId") Long workerId);
+
+ /**
+ * 鏈�鍚庝竴娆″叧绯昏褰� -鏃犺
+ * @param bossId
+ * @param workerId
+ * @return
+ */
+ ThreeSale getNearRelationByBossIdAndWorkerId(@Param("bossId") Long bossId, @Param("workerId") Long workerId);
+
+
+
+ /**
+ * 鏍规嵁涓嬬骇鏌ヨ鎴愬姛鐨勯個璇峰叧绯�
+ * @param workerId
+ * @return
+ */
+ ThreeSale selectSuccessByWorkerId(Long workerId);
+
+ /**
+ * 鏍规嵁閭�璇疯�匢D鏌ヨ鏈け鏁堝叧绯�
+ *
+ * @param workerId
+ * @return
+ */
+ ThreeSale getByWorkerId(Long workerId);
+
+
+ /**
+ * 鏌ヨ鏃堕棿娈甸個璇锋垚鍔熶汉淇℃伅
+ * @param bossId
+ * @param minTime
+ * @param maxTime
+ * @return
+ */
+ List<ThreeSale> getSuccessByDate(@Param("bossId")Long bossId,@Param("minTime")Long minTime, @Param("maxTime")Long maxTime);
+
+ /**
+ * 鏌ヨ鏈�杩戠殑淇℃伅锛堟牴鎹笅绾D涓庣姸鎬侊級
+ * @param workerId
+ * @param state
+ * @return
+ */
+ ThreeSale selectLatestByWorkerIdAndState(@Param("workerId") Long workerId,@Param("state") int state);
+
+ /**
+ * 鏍规嵁鏃堕棿鏌ヨ閭�璇峰叧绯�
+ * @param uid
+ * @param time
+ * @return
+ */
+ ThreeSale getByWorkerIdAndTime(@Param("workerId") Long workerId, @Param("time") long time);
+
+ /**
+ * 閭�璇峰叧绯昏劚绂�
+ * @param bossId
+ * @param workerId
+ */
+ void inviteSeparate(@Param("workerId") Long workerId, @Param("bossId")Long bossId);
+
+ /**
+ * 闃熷憳鍦ㄨboss 涓嬬鍑犱釜闃熷憳搴忓彿
+ * @param workerId
+ * @return
+ */
+ long getTeamOrderNumByWorkerId(@Param("workerId") Long workerId);
}
\ No newline at end of file
--
Gitblit v1.8.0