查询用户信息

lxw

2022-07-18 528b213a6e20609d2ff094dff45ca4f6f9af80b2

查询用户信息

 src/main/java/com/whyc/controller/DocUserController.java

@@ -21,8 +21,8 @@
    private DocUserService service;

    @ApiOperation(value = "查询所有用户信息",notes = "默认排除指定用户：sys_admin")
    @GetMapping("getAllUser")
    private Response getAllUser(@RequestBody DocUser docUser,@RequestParam int pageCurr,@RequestParam int pageSize){
    @PostMapping("getAllUser")
    private Response getAllUser(@RequestBody(required = false) DocUser docUser,@RequestParam int pageCurr,@RequestParam int pageSize){
        return service.getAllUser(docUser,pageCurr,pageSize);
    }


 src/main/java/com/whyc/mapper/DocUserMapper.java

@@ -6,5 +6,5 @@

public interface DocUserMapper extends CustomMapper<DocUser>{
    //查询所有用户信息
    List<DocUser> getAllUser();
    List<DocUser> getAllUser(DocUser docUser);
}

 src/main/java/com/whyc/service/DocUserService.java

@@ -39,9 +39,7 @@
    //查询所有用户信息
    public Response getAllUser(DocUser docUser, int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        QueryWrapper wrapper=new QueryWrapper();

        List<DocUser> list=mapper.getAllUser();
        List<DocUser> list=mapper.getAllUser(docUser);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null?true:false,pageInfo,"数据返回");
    }

 src/main/resources/mapper/DocUserMapper.xml

@@ -27,7 +27,7 @@
        </association>
    </resultMap>

    <select id="getAllUser" resultMap="getAllUser">
    <select id="getAllUser" resultMap="getAllUser" parameterType="DocUser">
        SELECT u.*
             ,r.id rid,r.role_name rrole_name,r.role_id rrole_id
             ,d.id did,d.depart_name ddepart_name,d.depart_id ddepart_id
@@ -38,6 +38,21 @@
        LEFT JOIN tb_doc_face f on u.face_id=f.face_id
        <where>
            u.name!="sys_admin"
        <if test="name!=null&amp;&amp;name!=''">
            and u.name=${name}
        </if>
        <if test="tel!=null&amp;&amp;tel!=''">
            and u.tel=${tel}
        </if>
        <if test="phone!=null&amp;&amp;phone!=''">
            u.phone=${phone}
        </if>
        <if test="departId!=null&amp;&amp;departId!=''">
            u.departId=${departId}
        </if>
        <if test="roleId!=null&amp;&amp;roleId!=''">
            u.roleId=${roleId}
        </if>
        </where>
        order by id asc
    </select>