package com.sinata.modular.member.dao;
|
|
import com.baomidou.mybatisplus.plugins.Page;
|
import com.sinata.modular.member.model.MemUser;
|
import com.sinata.modular.member.model.MemUserRelation;
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 会员邀请关系 Mapper 接口
|
* </p>
|
*
|
* @author goku
|
* @since 2023-03-23
|
*/
|
public interface MemUserRelationMapper extends BaseMapper<MemUserRelation> {
|
|
/**
|
* 按条件查询指定人员团队人数
|
*
|
* @param memberId
|
* @param gradeId
|
* @param aboveId
|
* @return
|
*/
|
Integer countTeamMemberBy(@Param("memberId") Integer memberId, @Param("gradeId") Integer gradeId, @Param("aboveId") Integer aboveId);
|
|
/**
|
* 获取用户上级推荐人信息
|
*
|
* @param userId
|
* @return
|
*/
|
MemUser getParentUserById(@Param("userId") Integer userId);
|
|
/**
|
* 获取直推有效人数
|
*
|
* @param idArray
|
* @param memberGradeId
|
* @return
|
*/
|
List<Map<String, Object>> getListParentGradeIdCount(@Param("idArray") Object[] idArray, @Param("memberGradeId") Integer memberGradeId);
|
|
/**
|
* 获取团队用户列表
|
*/
|
List<Map<String, Object>> myTeam(@Param("userId") Integer userId, @Param("gradeList") List<Integer> gradeList, @Param("showId") String showId, @Param("beginTime") String beginTime, @Param("endTime") String endTime);
|
List<Map<String, Object>> myTeam(@Param("page") Page<Map<String, Object>> page, @Param("userId") Integer userId, @Param("gradeList") List<Integer> gradeList, @Param("showId") String showId, @Param("beginTime") String beginTime, @Param("endTime") String endTime);
|
Integer myTeamCount(@Param("userId") Integer userId, @Param("gradeList") List<Integer> gradeList, @Param("showId") String showId, @Param("beginTime") String beginTime, @Param("endTime") String endTime);
|
|
List<Map<String, Object>> getMemUserRelationByUserIds(@Param("userIds") List<Integer> userIds);
|
}
|
