From 4db8086da94d99ddce6bc7422fef9fde58dff36c Mon Sep 17 00:00:00 2001
From: Administrator <Administrator@Admin>
Date: 星期一, 03 十二月 2018 13:06:45 +0800
Subject: [PATCH] 队员排序 根据邀请时间倒序

---
 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ThreeSaleMapper.java |   95 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 95 insertions(+), 0 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..6b833fc 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
@@ -78,4 +78,99 @@
      */
     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);
+    
 }
\ No newline at end of file

--
Gitblit v1.8.0