| package com.jilongda.optometrist.authority.mapper; | 
|   | 
| import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
| import com.jilongda.common.basic.PageInfo; | 
| import com.jilongda.optometrist.authority.dto.SecUsersDTO; | 
| import com.jilongda.optometrist.authority.model.SecUser; | 
| import com.jilongda.optometrist.authority.query.SecUserLowerQuery; | 
| import com.jilongda.optometrist.authority.vo.SecUsersVO; | 
| import org.apache.ibatis.annotations.Mapper; | 
| import org.apache.ibatis.annotations.Param; | 
|   | 
| import java.util.List; | 
|   | 
| /** | 
|  * <p> | 
|  * Mapper 接口 | 
|  * </p> | 
|  * | 
|  * @author xiaochen | 
|  * @since 2022-06-08 | 
|  */ | 
| @Mapper | 
| public interface SecUserMapper extends BaseMapper<SecUser> { | 
|   | 
|     /** | 
|      * 后台系统用户列表 | 
|      * | 
|      * @param dto | 
|      * @param pageInfo | 
|      * @return | 
|      */ | 
|     List<SecUsersVO> getSecUserList(@Param("dto") SecUsersDTO dto, @Param("pageInfo") PageInfo<SecUsersVO> pageInfo); | 
|   | 
|     /** | 
|      * KAM查询下级 | 
|      * | 
|      * @param query | 
|      * @param pageInfo | 
|      * @return | 
|      */ | 
|     List<SecUser> queryLower(@Param("query") SecUserLowerQuery query, @Param("pageInfo") PageInfo<SecUser> pageInfo); | 
|   | 
|     void removeById(@Param("uid") Long uid); | 
|   | 
|     /** | 
|      * 通过角色id获取账号 | 
|      * | 
|      * @param id | 
|      * @return | 
|      */ | 
|     List<SecUser> getUserByRoleId(@Param("id") Long id); | 
|     /** | 
|      * 通过用户名手机号部门id获取账号 | 
|      * | 
|      * @param name | 
|      * @return | 
|      */ | 
|     List<SecUser> selectListByNamePhoneDeptId(@Param("name")String name,@Param("deptId")Long deptId); | 
|     /** | 
|      * 通过用户名手机号部门id集合获取账号 | 
|      * | 
|      * @param name | 
|      * @return | 
|      */ | 
|     List<SecUser> selectListByNamePhoneDeptIds(@Param("name")String name,@Param("deptIds")List<Long> deptIds); | 
|   | 
|     /** | 
|      * 通过用户id获取账号 | 
|      * @param orderingPersonId | 
|      * @return | 
|      */ | 
|     SecUser selectUserById(@Param("orderingPersonId") Long orderingPersonId); | 
|   | 
|   | 
|     /** | 
|      * 查询所有用户 | 
|      * @return | 
|      */ | 
|     List<SecUser> queryList(); | 
|   | 
| } |