修改用户管理

whyclxw

2024-11-27 dcfaad89908eb4bf62e1a1097d7e64fbe451796a

修改用户管理

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

@@ -70,5 +70,10 @@
        return service.resetSnId( uid);
    }

    @GetMapping("getUnloadUinf")
    @ApiOperation(value = "查询未被指定区域的用户")
    public Response getUnloadUinf(){
        return service.getUnloadUinf();
    }

}

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

@@ -255,4 +255,17 @@
        UserInf uinf=mapper.selectOne(wrapper);
        return uinf;
    }
    //查询未被指定区域的用户
    public Response getUnloadUinf() {
        List<AreaInf> ainfList=ainfMapper.selectList(null);
        List<String> unameList = ainfList.stream()
                .map(AreaInf::getAreaUname) // 提取名字
                .collect(Collectors.toList()); // 转换为列表
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.select("uname","uid","real_name","udownload_role","create_time");
        wrapper.notIn("uname",unameList);
        wrapper.gt("uid",100);
        List<UserInf> list=mapper.selectList(wrapper);
        return new Response().setII(1,list!=null,list,"查询未被指定区域的用户");
    }
}

 src/main/resources/mapper/UserInfMapper.xml

@@ -24,7 +24,7 @@
    <select id="getAllUser" resultType="UserInf">
        select uid,uname,udownload_role,create_time from db_user.tb_user_inf
        <where>
        1==1
        1=1
            <if test="uname!=null">
                and uname LIKE CONCAT('%',#{uname},'%')
            </if>