2024-01-25 朱宝民 优化获取用户信息接口
| | |
| | | <!--根据用户编号获取用户信息--> |
| | | <select id="getUserInfoById" resultType="java.util.Map"> |
| | | SELECT |
| | | id AS userId, |
| | | name AS userName |
| | | FROM ba_user |
| | | us.id AS userId, |
| | | us.name AS userName, |
| | | us.phone, |
| | | IFNULL(us.blockId, 0) AS blockId, |
| | | IFNULL(blo.name, 0) AS blockName |
| | | FROM ba_user us |
| | | LEFT JOIN ba_block blo ON us.blockId = blo.id |
| | | <where> |
| | | AND disabled = 0 |
| | | AND deleted = 0 |
| | | AND us.disabled = 0 |
| | | AND us.deleted = 0 |
| | | <if test = "userId != null and userId > 0"> |
| | | AND ba_user.id = ${userId} |
| | | AND us.id = ${userId} |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | NO_ROLES(10004, "没有符合条件的角色记录"), |
| | | PLEASE_INPUT_ROLE_ID(10005, "角色编号不能为空"), |
| | | DELETE_ROLE_FAIL(10006, "删除角色失败"), |
| | | USER_NOT_EXIST(10007, "删除的用户不存在"); |
| | | USER_NOT_EXIST(10007, "删除的用户不存在"), |
| | | |
| | | /** |
| | | * 用户 |
| | | */ |
| | | THE_USER_NOT_EXIST(20001, "用户不存在"); |
| | | |
| | | private final Integer code; |
| | | private final String message; |
| | |
| | | public BaseResponse<QueryResultVo<VoUserInfo>> getUserInfos(@PathVariable("userId") Long userId) { |
| | | try { |
| | | VoUserInfo res = this.sv.getUserInfos(userId); |
| | | if(res == null) { |
| | | return BaseResponseUtils.buildException(SystemResultCode.THE_USER_NOT_EXIST.getMessage()); |
| | | } |
| | | System.out.println(" :" + res); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | |
| | | VoUserInfo voUserInfo = new VoUserInfo(); |
| | | JSONArray array_permission = new JSONArray(); |
| | | Map map = Optional.ofNullable(dao.getUserInfoById(userId)).orElse(new HashMap()); |
| | | if(map.size() > 0) { |
| | | voUserInfo.setUserId(String.valueOf(userId)); |
| | | voUserInfo.setUserName(map.get("userName").toString()); |
| | | if(map.size() == 0) { |
| | | return null; |
| | | } |
| | | voUserInfo.setUserId(String.valueOf(userId)); |
| | | voUserInfo.setUserName(map.get("userName").toString()); |
| | | voUserInfo.setPhone(map.get("phone").toString()); |
| | | voUserInfo.setBlockId(map.get("blockId").toString()); |
| | | voUserInfo.setBlockName(map.get("blockName").toString()); |
| | | |
| | | /** |
| | | * 添加角色编号列表、角色名称列表、权限列表 |
| | |
| | | voUserInfo.setRoleNames(list_roleNames); |
| | | voUserInfo.setPermissions(array_permission); |
| | | |
| | | |
| | | return voUserInfo; |
| | | } |
| | | } |
| | |
| | | * @return 修改记录条数 |
| | | */ |
| | | public Integer updateByPrimaryKey(PrDivide po) { |
| | | return prDivideMapper.updateByPrimaryKey(po); |
| | | //return prDivideMapper.updateByPrimaryKey(po); |
| | | return prDivideMapper.updateByPrimaryKeySelective(po); |
| | | } |
| | | |
| | | /** |