UsersMapper.java 1.94 KB
Newer Older
licc's avatar
licc committed
1 2
package cn.wisenergy.mapper;

3

licc's avatar
licc committed
4
import cn.wisenergy.model.app.Users;
5
import cn.wisenergy.model.dto.UserDto;
6
import cn.wisenergy.model.dto.UserSimpleInfoDto;
licc's avatar
licc committed
7 8
import cn.wisenergy.model.dto.UsersInfoDto;
import cn.wisenergy.model.vo.UserVo;
licc's avatar
licc committed
9 10 11 12
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

13 14
import java.util.List;

licc's avatar
licc committed
15 16 17 18 19 20 21 22

/**
 * @author 86187
 * @ Description:
 * @ Author     : 86187
 * @ Date       : 2021/1/6 15:32
 */
@Mapper
licc's avatar
licc committed
23
public interface UsersMapper extends BaseMapper<Users> {
licc's avatar
licc committed
24 25 26
    /**
     * 添加
     *
licc's avatar
licc committed
27
     * @param users 用户信息
licc's avatar
licc committed
28 29
     * @return 用户信息
     */
licc's avatar
licc committed
30
    int add(Users users);
licc's avatar
licc committed
31 32 33 34

    /**
     * 编辑
     *
licc's avatar
licc committed
35
     * @param users 用户信息
licc's avatar
licc committed
36 37
     * @return 修改是否成功
     */
licc's avatar
licc committed
38
    int edit(Users users);
licc's avatar
licc committed
39 40 41 42 43 44 45 46 47

    /**
     * 删除
     *
     * @param id 用户id
     * @return 删除是否成功
     */
    int delById(@Param("id") Integer id);

licc's avatar
licc committed
48 49 50 51
    Users getById(@Param("id") Long id);

    /**
     * 获取所有用户的下一级信息
52
     *
licc's avatar
licc committed
53 54 55 56 57 58
     * @param parentId 父id
     * @return
     */
    List<UserVo> getLastUser(@Param("parentId") Integer parentId);

    /**
59 60 61
     * 获取向下最深层级层级数、伞下人员总和
     *
     * @param userId 用户id
licc's avatar
licc committed
62 63
     * @return 层级数
     */
64
    UsersInfoDto getLevelAndTotal(@Param("userId") Long userId);
licc's avatar
licc committed
65 66 67

    /**
     * 伞下人员总和
68
     *
licc's avatar
licc committed
69 70 71 72 73
     * @param id 用户id
     * @return 伞下人员总和
     */
    Integer getTotal(@Param("id") Long id);

74
    List<UserDto> getAllUserData();
licc's avatar
licc committed
75

76 77 78

    /*************** chenqi****************/

79 80
    /**
     * 获取伞下有那些用户
81
     *
82
     * @param userId 用户id
83
     */
84
    List<UserSimpleInfoDto> getDownUsersById(Long userId);
85

86 87
    /**
     * 获取用户向下最深层级层级数,伞下人员总和
88
     *
89 90 91 92
     * @param userId 用户
     * @return
     */
    UsersInfoDto getDownLevelAndTotalPeopleByUserId(Long userId);
93

licc's avatar
licc committed
94
}