package com.yeshi.fanli.dao.mybatis;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.entity.bus.user.ThreeSale;
|
import com.yeshi.fanli.entity.bus.user.UserInfo;
|
|
public interface ThreeSaleMapper {
|
|
int deleteByPrimaryKey(Long id);
|
|
int insert(ThreeSale record);
|
|
int insertSelective(ThreeSale record);
|
|
int updateByPrimaryKey(ThreeSale record);
|
|
int updateByPrimaryKeySelective(ThreeSale record);
|
|
ThreeSale selectByPrimaryKey(Long id);
|
|
|
UserInfo selectBoss(Long uid);
|
|
/**
|
* 根据被邀请者ID查询
|
*
|
* @param workerId
|
* @return
|
*/
|
ThreeSale getByWorkerId(Long workerId);
|
|
|
/**
|
*
|
* @param uid
|
* @return
|
*/
|
ThreeSale getMyBoss(@Param("uid") Long uid);
|
|
|
/**
|
* 根据下级查询成功的邀请关系
|
* @param workerId
|
* @return
|
*/
|
ThreeSale selectSuccessByWorkerId(Long workerId);
|
|
|
/**
|
* 根据邀请者ID查询关系
|
*
|
* @param workerId
|
* @return
|
*/
|
List<ThreeSale> listByWorkerId(Long workerId);
|
|
|
|
/**
|
* 一级查询-后台查询
|
*
|
* @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,
|
@Param("validState") Integer validState);
|
|
long countFirstTeamQuery(@Param("uid") Long uid, @Param("state") Integer state, @Param("startTime") String startTime,
|
@Param("endTime") String endTime, @Param("validState") Integer validState);
|
|
/**
|
* 二级查询 -后台查询
|
*
|
* @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
|
,@Param("validState") Integer validState);
|
|
long countSecondTeamQuery(@Param("uid") Long uid, @Param("state") Integer state,
|
@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("validState") Integer validState);
|
|
/**
|
* 上级查询 -后台查询
|
*
|
* @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 start
|
* @param count
|
* @param uid
|
* @return
|
*/
|
List<ThreeSale> listFirstTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
|
@Param("listId")List<Long> listId);
|
|
/**
|
* 查询二级队员
|
* @param start
|
* @param count
|
* @param uid
|
* @return
|
*/
|
List<ThreeSale> listSecondTeam(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
|
@Param("listId")List<Long> listId);
|
|
/**
|
* 统计一级队员
|
* @param uid
|
* @return
|
*/
|
long countFirstTeam(@Param("uid") Long uid, @Param("listId")List<Long> listId);
|
|
/**
|
* 统计二级队员
|
* @param uid
|
* @return
|
*/
|
long countSecondTeam(@Param("uid") Long uid, @Param("listId")List<Long> listId);
|
|
|
/**
|
* 根据id、uid查询
|
*
|
* @param id
|
* @param uid
|
* @return
|
*/
|
List<ThreeSale> listbyIdAndBossId(@Param("id") Long id, @Param("uid") Long uid, @Param("expire") Integer expire);
|
|
|
/**
|
* 获取成功邀请关系数量
|
*
|
* @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 bossId
|
* @param workerId
|
* @return
|
*/
|
ThreeSale getNearRelationByBossIdAndWorkerId(@Param("bossId") Long bossId, @Param("workerId") Long workerId);
|
|
|
|
/**
|
* 查询时间段邀请成功人信息
|
* @param bossId
|
* @param minTime
|
* @param maxTime
|
* @return
|
*/
|
List<ThreeSale> getSuccessByDate(@Param("bossId")Long bossId,@Param("minTime")Long minTime, @Param("maxTime")Long maxTime);
|
|
/**
|
* 查询最近的信息（根据下级ID与状态）
|
* @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);
|
|
/**
|
* 有效粉丝uid
|
* @param bossId
|
* @param limitTime
|
* @return
|
*/
|
List<ThreeSale> getValidWorkerIdsByTime(@Param("uid") Long uid,@Param("limitTime") long limitTime);
|
|
|
}
|
