用户权限扩大至10000

whyclxw

2024-12-21 b4f9bc4ff8d502a572cbaca925e7d4578deebd68

用户权限扩大至10000

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

@@ -19,9 +19,9 @@

    @ApiOperation(value = "查询所有用户信息",notes = "排除uid在100以内的(100以内默认是管理员)")
    @GetMapping("getAllUser")
    public Response getAllUser(@RequestParam(required = false) String uname,@RequestParam(required = false) String realName,@RequestParam(required = false) Integer role
    public Response getAllUser(@RequestParam(required = false) String uname,@RequestParam(required = false) String realName,@RequestParam(required = false) Integer urole
            ,@RequestParam int areaId ,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllUser(uname,realName,role,areaId,pageCurr,pageSize);
        return service.getAllUser(uname,realName,urole,areaId,pageCurr,pageSize);
    }

    @ApiOperation(value = "查询所有用户信息(不分页用于包机组)")

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

@@ -11,7 +11,7 @@
    //判断是否存在普通用户(uid>100)，若无,初始为1001
    int judgeUname();
    //查询所有用户信息
    List<UserInf> getAllUser(@Param("uname")String uname,@Param("realName")String realName,@Param("role")Integer role,@Param("areaId")Integer areaId);
    List<UserInf> getAllUser(@Param("uname")String uname,@Param("realName")String realName,@Param("urole")Integer urole,@Param("areaId")Integer areaId);
    //查询100~1000中最大的uid
    String getIn10000();
    //创建100~1000的id表,不存在则创建

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

@@ -51,9 +51,9 @@


    //查询所有用户信息
    public Response getAllUser(String uname, String realName, Integer role, int areaId, int pageCurr, int pageSize) {
    public Response getAllUser(String uname, String realName, Integer urole, int areaId, int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        List<UserInf> list=mapper.getAllUser(uname,realName,role,areaId);
        List<UserInf> list=mapper.getAllUser(uname,realName,urole,areaId);
        for (UserInf uinf:list) {
            QueryWrapper wrapper=new QueryWrapper();
            wrapper.eq("area_uname",uinf.getUname());

 src/main/resources/mapper/UserInfMapper.xml

@@ -36,14 +36,14 @@
            </if>

            <choose>
                <when test="role == 0">
                    and uid>100 and uid &lt;= 10000
                <when test="urole == 0">
                    and urole=0
                </when>
                <when test="role == 1">
                    and uid>10000
                <when test="urole == 1">
                    and urole=1
                </when>
                <when test="role == -1">
                    and uid>100
                <when test="urole == -1">
                    and urole!=2
                </when>
            </choose>
        </where>