package org.fanli.service.user.dao.invite;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.fanli.facade.user.entity.invite.ThreeSale;
|
|
import com.yeshi.fanli.base.entity.user.UserInfo;
|
|
public interface ThreeSaleMapper {
|
|
int deleteByPrimaryKey(Long id);
|
|
int insert(ThreeSale record);
|
|
int insertSelective(ThreeSale record);
|
|
ThreeSale selectByPrimaryKey(Long id);
|
|
UserInfo selectBoss(Long uid);
|
|
List<ThreeSale> selectByUid(Long uid);
|
|
int updateByPrimaryKeySelective(ThreeSale record);
|
|
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);
|
|
/**
|
* 查询一度队员集合
|
*
|
* @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);
|
|
/**
|
* 查询二度队员集合
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @param uid
|
* @return
|
*/
|
List<ThreeSale> queryMySecondTeamList(@Param("start") int start, @Param("count") int count,
|
@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、uid查询
|
*
|
* @param id
|
* @param uid
|
* @return
|
*/
|
List<ThreeSale> listbyIdAndBossId(@Param("id") Long id, @Param("uid") Long uid, @Param("expire") Integer expire);
|
|
/**
|
* 根据邀请者ID查询关系
|
*
|
* @param workerId
|
* @return
|
*/
|
List<ThreeSale> listByWorkerId(Long workerId);
|
|
/**
|
* 获取成功邀请关系数量
|
*
|
* @param uid
|
* @return
|
*/
|
int getSuccessRelationshipNum(@Param("uid") Long uid);
|
|
/**
|
* 根据邀请者ID、bossID查询 有效关系
|
*
|
* @param workerId
|
* @return
|
*/
|
ThreeSale getRelationshipByBossIdAndWorkerId(@Param("bossId") Long bossId, @Param("workerId") Long workerId);
|
|
/**
|
* 根据邀请者，邀请状态，过期状态查询列表
|
*
|
* @param workerId
|
* @param state
|
* @param expire
|
* @return
|
*/
|
List<ThreeSale> listByWorkerAndStateAndExpire(@Param("workerId") Long workerId, @Param("state") boolean state,
|
@Param("expire") int expire);
|
|
/**
|
* 根据关键字模糊查询
|
*
|
* @param key
|
* @param start
|
* @param count
|
* @return
|
*/
|
List<ThreeSale> listByBossOrWorker(@Param("key") String key, @Param("start") long start, @Param("count") int count);
|
|
/**
|
* 根据关键字模糊查询数量
|
* @param key
|
* @return
|
*/
|
Long countByBossOrWorker(@Param("key") String key);
|
|
}
|
