package com.ruoyi.system.service.impl.sys; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.core.constant.UserConstants; import com.ruoyi.common.core.exception.ServiceException; import com.ruoyi.common.core.utils.DateUtils; import com.ruoyi.common.core.utils.SpringUtils; import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.utils.bean.BeanValidators; import com.ruoyi.common.datascope.annotation.DataScope; import com.ruoyi.common.security.utils.SecurityUtils; import com.ruoyi.system.api.domain.dto.AppEditUserDto; import com.ruoyi.system.api.domain.dto.MgtBaseBathDto; import com.ruoyi.system.api.domain.dto.MgtFrozenMemberDto; import com.ruoyi.system.api.domain.dto.MgtUserIdByDept; import com.ruoyi.system.api.domain.poji.sys.SysRole; import com.ruoyi.system.api.domain.poji.sys.SysUser; import com.ruoyi.system.api.domain.vo.MgtSysSimpleUserVo; import com.ruoyi.system.domain.dto.UserMenuEditDto; import com.ruoyi.system.domain.pojo.sys.SysPost; import com.ruoyi.system.domain.pojo.sys.SysUserMenu; import com.ruoyi.system.domain.pojo.sys.SysUserPost; import com.ruoyi.system.domain.pojo.sys.SysUserRole; import com.ruoyi.system.mapper.sys.*; import com.ruoyi.system.service.sys.ISysConfigService; import com.ruoyi.system.service.sys.ISysUserService; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import javax.annotation.Resource; import javax.validation.Validator; import java.util.ArrayList; import java.util.List; import java.util.stream.Collectors; /** * 用户 业务层处理 * * @author jqs */ @Service public class SysUserServiceImpl extends ServiceImpl implements ISysUserService { private static final Logger log = LoggerFactory.getLogger(SysUserServiceImpl.class); @Resource private SysUserMapper userMapper; @Resource private SysRoleMapper roleMapper; @Resource private SysPostMapper postMapper; @Resource private SysUserRoleMapper userRoleMapper; @Resource private SysUserPostMapper userPostMapper; @Resource private ISysConfigService configService; @Resource protected Validator validator; @Resource protected SysUserMenuMapper userMenuMapper; /** * 根据条件分页查询用户列表 * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List selectUserList(SysUser user) { return userMapper.selectUserList(user); } @Override public SysUser selectUserByPhoneNumber(String phoneNumber,String userType) { SysUser sysUser = new SysUser(); sysUser.setPhonenumber(phoneNumber); List userList = this.selectUserList(sysUser); SysUser queryUser = null; if(!userList.isEmpty()){ for(SysUser sysUser1 : userList){ if(sysUser1.getUserType().equals(userType)){ queryUser = sysUser1; } } } return queryUser; } /** * 根据条件分页查询已分配用户角色列表 * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List selectAllocatedList(SysUser user) { return userMapper.selectAllocatedList(user); } /** * 根据条件分页查询未分配用户角色列表 * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List selectUnallocatedList(SysUser user) { return userMapper.selectUnallocatedList(user); } /** * 通过用户名查询用户 * * @param userName 用户名 * @return 用户对象信息 */ @Override public SysUser selectUserByUserName(String userName) { return userMapper.selectUserByUserName(userName); } /** * 通过用户ID查询用户 * * @param userId 用户ID * @return 用户对象信息 */ @Override public SysUser selectUserById(Long userId) { return userMapper.selectUserById(userId); } /** * 查询用户所属角色组 * * @param userName 用户名 * @return 结果 */ @Override public String selectUserRoleGroup(String userName) { List list = roleMapper.selectRolesByUserName(userName); if (CollectionUtils.isEmpty(list)) { return StringUtils.EMPTY; } return list.stream().map(SysRole::getRoleName).collect(Collectors.joining(",")); } /** * 查询用户所属岗位组 * * @param userName 用户名 * @return 结果 */ @Override public String selectUserPostGroup(String userName) { List list = postMapper.selectPostsByUserName(userName); if (CollectionUtils.isEmpty(list)) { return StringUtils.EMPTY; } return list.stream().map(SysPost::getPostName).collect(Collectors.joining(",")); } /** * 校验用户名称是否唯一 * * @param user 用户信息 * @return 结果 */ @Override public boolean checkUserNameUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkUserNameUnique(user.getUserName()); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; } /** * 校验手机号码是否唯一 * * @param user 用户信息 * @return */ @Override public boolean checkPhoneUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkPhoneUnique(user.getPhonenumber()); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; } /** * 校验email是否唯一 * * @param user 用户信息 * @return */ @Override public boolean checkEmailUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkEmailUnique(user.getEmail()); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; } /** * 校验用户是否允许操作 * * @param user 用户信息 */ @Override public void checkUserAllowed(SysUser user) { if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) { throw new ServiceException("不允许操作超级管理员用户"); } } /** * 校验用户是否有数据权限 * * @param userId 用户id */ @Override public void checkUserDataScope(Long userId) { if (!SysUser.isAdmin(SecurityUtils.getUserId())) { SysUser user = new SysUser(); user.setUserId(userId); List users = SpringUtils.getAopProxy(this).selectUserList(user); if (StringUtils.isEmpty(users)) { throw new ServiceException("没有权限访问用户数据!"); } } } /** * 新增保存用户信息 * * @param user 用户信息 * @return 结果 */ @Override @Transactional(rollbackFor = Exception.class) public int insertUser(SysUser user) { // 新增用户信息 int rows = userMapper.insertUser(user); // 新增用户岗位关联 insertUserPost(user); // 新增用户与角色管理 insertUserRole(user); return rows; } /** * 注册用户信息 * * @param user 用户信息 * @return 结果 */ @Override public SysUser registerUser(SysUser user) { int id = userMapper.insertUser(user); log.info("user------------------"+user.toString()); return user; } /** * * @param mobile * @return */ @Override public SysUser getSysUserByMobile(String mobile){ SysUser sysUser = this.selectUserByPhoneNumber(mobile,"00"); return sysUser; } /** * 修改保存用户信息 * * @param user 用户信息 * @return 结果 */ @Override @Transactional(rollbackFor = Exception.class) public int updateUser(SysUser user) { Long userId = user.getUserId(); // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); // 新增用户与角色管理 insertUserRole(user); // 删除用户与岗位关联 userPostMapper.deleteUserPostByUserId(userId); // 新增用户与岗位管理 insertUserPost(user); return userMapper.updateUser(user); } /** * 用户授权角色 * * @param userId 用户ID * @param roleIds 角色组 */ @Override @Transactional(rollbackFor = Exception.class) public void insertUserAuth(Long userId, Long[] roleIds) { userRoleMapper.deleteUserRoleByUserId(userId); insertUserRole(userId, roleIds); } /** * 修改用户状态 * * @param user 用户信息 * @return 结果 */ @Override public int updateUserStatus(SysUser user) { return userMapper.updateUser(user); } /** * 修改用户基本信息 * * @param user 用户信息 * @return 结果 */ @Override public int updateUserProfile(SysUser user) { return userMapper.updateUser(user); } /** * 修改用户头像 * * @param userName 用户名 * @param avatar 头像地址 * @return 结果 */ @Override public boolean updateUserAvatar(String userName, String avatar) { return userMapper.updateUserAvatar(userName, avatar) > 0; } /** * 重置用户密码 * * @param user 用户信息 * @return 结果 */ @Override public int resetPwd(SysUser user) { return userMapper.updateUser(user); } /** * 重置用户密码 * * @param userName 用户名 * @param password 密码 * @return 结果 */ @Override public int resetUserPwd(String userName, String password) { return userMapper.resetUserPwd(userName, password); } /** * 新增用户角色信息 * * @param user 用户对象 */ public void insertUserRole(SysUser user) { this.insertUserRole(user.getUserId(), user.getRoleIds()); } /** * 新增用户岗位信息 * * @param user 用户对象 */ public void insertUserPost(SysUser user) { Long[] posts = user.getPostIds(); if (StringUtils.isNotEmpty(posts)) { // 新增用户与岗位管理 List list = new ArrayList(); for (Long postId : posts) { SysUserPost up = new SysUserPost(); up.setUserId(user.getUserId()); up.setPostId(postId); list.add(up); } userPostMapper.batchUserPost(list); } } /** * 新增用户角色信息 * * @param userId 用户ID * @param roleIds 角色组 */ public void insertUserRole(Long userId, Long[] roleIds) { if (StringUtils.isNotEmpty(roleIds)) { // 新增用户与角色管理 List list = new ArrayList(); for (Long roleId : roleIds) { SysUserRole ur = new SysUserRole(); ur.setUserId(userId); ur.setRoleId(roleId); list.add(ur); } userRoleMapper.batchUserRole(list); } } /** * 通过用户ID删除用户 * * @param userId 用户ID * @return 结果 */ @Override @Transactional(rollbackFor = Exception.class) public int deleteUserById(Long userId) { // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); // 删除用户与岗位表 userPostMapper.deleteUserPostByUserId(userId); return userMapper.deleteUserById(userId); } /** * 批量删除用户信息 * * @param userIds 需要删除的用户ID * @return 结果 */ @Override @Transactional(rollbackFor = Exception.class) public int deleteUserByIds(Long[] userIds) { for (Long userId : userIds) { checkUserAllowed(new SysUser(userId)); checkUserDataScope(userId); } // 删除用户与角色关联 userRoleMapper.deleteUserRole(userIds); // 删除用户与岗位关联 userPostMapper.deleteUserPost(userIds); return userMapper.deleteUserByIds(userIds); } /** * 导入用户数据 * * @param userList 用户数据列表 * @param isUpdateSupport 是否更新支持,如果已存在,则进行更新数据 * @param operName 操作用户 * @return 结果 */ @Override public String importUser(List userList, Boolean isUpdateSupport, String operName) { if (StringUtils.isNull(userList) || userList.size() == 0) { throw new ServiceException("导入用户数据不能为空!"); } int successNum = 0; int failureNum = 0; StringBuilder successMsg = new StringBuilder(); StringBuilder failureMsg = new StringBuilder(); String password = configService.selectConfigByKey("sys.user.initPassword"); for (SysUser user : userList) { try { // 验证是否存在这个用户 SysUser u = userMapper.selectUserByUserName(user.getUserName()); if (StringUtils.isNull(u)) { BeanValidators.validateWithException(validator, user); user.setPassword(SecurityUtils.encryptPassword(password)); user.setCreateBy(operName); userMapper.insertUser(user); successNum++; successMsg.append("
" + successNum + "、账号 " + user.getUserName() + " 导入成功"); } else if (isUpdateSupport) { BeanValidators.validateWithException(validator, user); checkUserAllowed(u); checkUserDataScope(u.getUserId()); user.setUserId(u.getUserId()); user.setUpdateBy(operName); userMapper.updateUser(user); successNum++; successMsg.append("
" + successNum + "、账号 " + user.getUserName() + " 更新成功"); } else { failureNum++; failureMsg.append("
" + failureNum + "、账号 " + user.getUserName() + " 已存在"); } } catch (Exception e) { failureNum++; String msg = "
" + failureNum + "、账号 " + user.getUserName() + " 导入失败:"; failureMsg.append(msg + e.getMessage()); log.error(msg, e); } } if (failureNum > 0) { failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:"); throw new ServiceException(failureMsg.toString()); } else { successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:"); } return successMsg.toString(); } /** * @description: updateUserMobile * @param: sysUser * @return: null * @author jqs34 * @date: 2023/4/30 15:43 */ @Override public void updateUserMobile(SysUser sysUser){ SysUser oldSysUser = this.selectUserById(sysUser.getUserId()); oldSysUser.setPhonenumber(sysUser.getPhonenumber()); userMapper.updateUser(oldSysUser); } /** * * @param appEditUserDto */ @Override public void editUserInfo(AppEditUserDto appEditUserDto){ SysUser sysUser = this.selectUserById(appEditUserDto.getUserId()); //修改类型1.昵称2.头像3.性别4.生日 Integer editType = appEditUserDto.getEditType(); String editValue = appEditUserDto.getEditValue(); switch (editType){ case 1: break; case 2: sysUser.setAvatar(editValue); sysUser.setUpdateTime(DateUtils.getNowDate()); sysUser.setUpdateBy(String.valueOf(appEditUserDto.getUserId())); userMapper.updateUser(sysUser); break; case 3: sysUser.setSex(editValue); sysUser.setUpdateTime(DateUtils.getNowDate()); sysUser.setUpdateBy(String.valueOf(appEditUserDto.getUserId())); userMapper.updateUser(sysUser); break; case 4: break; case 5: sysUser.setNickName(editValue); sysUser.setUpdateTime(DateUtils.getNowDate()); sysUser.setUpdateBy(String.valueOf(appEditUserDto.getUserId())); userMapper.updateUser(sysUser); break; default: break; } } /** * @description 获取部门用户 * @author jqs * @date 2023/6/21 16:00 * @param userIdByDept * @return MgtUserIdByDept */ @Override public MgtUserIdByDept getUserIdByDept(MgtUserIdByDept userIdByDept){ List userIdList = userMapper.getUserIdByDept(userIdByDept); userIdByDept.setUserIdList(userIdList); return userIdByDept; } /** * @description * @author jqs * @date 2023/6/25 14:35 * @param mgtBaseBathDto * @return List */ @Override public List listSimpleUserVo(MgtBaseBathDto mgtBaseBathDto){ return userMapper.listSimpleUserVo(mgtBaseBathDto.getIds()); } /** * @description * @author jqs * @date 2023/6/25 16:37 * @param userMenuEditDto * @return void */ @Override public void editUserMenu(UserMenuEditDto userMenuEditDto){ SysUser sysUser = this.selectUserById(userMenuEditDto.getUserId()); sysUser.setDataScope(userMenuEditDto.getDataScope()); sysUser.setDataScopeEmployee(userMenuEditDto.getDataScopeEmployee()); userMapper.updateUser(sysUser); userMenuMapper.deleteUserMenuByUserId(userMenuEditDto.getUserId()); int rows = 1; // 新增用户与角色管理 List list = new ArrayList(); for (Long menuId : userMenuEditDto.getMenuIds()) { SysUserMenu rm = new SysUserMenu(); rm.setUserId(userMenuEditDto.getUserId()); rm.setMenuId(menuId); rm.setMenuFrom(1); list.add(rm); } for(Long menuId : userMenuEditDto.getStaffMenuIds()){ SysUserMenu rm = new SysUserMenu(); rm.setUserId(userMenuEditDto.getUserId()); rm.setMenuId(menuId); rm.setMenuFrom(2); list.add(rm); } if (list.size() > 0) { rows = userMenuMapper.batchUserMenu(list); } } /** * @description * @author jqs * @date 2023/6/26 10:36 * @param sysUser * @return void */ @Override public void updateOnlyUser(SysUser sysUser){ userMapper.updateUser(sysUser); } /** * @description * @author jqs * @date 2023/7/5 21:24 * @param mgtFrozenMemberDto * @return void */ @Override public void frozenUser(MgtFrozenMemberDto mgtFrozenMemberDto){ Long userId = mgtFrozenMemberDto.getId(); SysUser sysUser = this.selectUserById(userId); if(mgtFrozenMemberDto.getFrozenFlag()==1){ sysUser.setStatus("1"); }else{ sysUser.setStatus("0"); } userMapper.updateUser(sysUser); } /** * 获取当前员工权限范围内的员工id * @return */ @Override public List getScopeOfAuthorityUserId() { List userIds = new ArrayList<>(); Long userId = SecurityUtils.getUserId(); SysUser user = this.baseMapper.selectUserById(userId); String dataScope = user.getDataScope(); //没有配置默认查询自己 if(!SecurityUtils.isAdmin(userId) && StringUtils.isEmpty(dataScope)){ userIds.add(userId); } //管理员或者全部权限 if(SecurityUtils.isAdmin(userId) || (StringUtils.isNotEmpty(dataScope) && "1".equals(dataScope))){ return null; } //部分权限 if(StringUtils.isNotEmpty(dataScope) && "3".equals(dataScope)){ SysUser user1 = new SysUser(); user1.setUserType("00"); user1.setStatus("0"); user1.setDeptId(user.getDeptId()); List list = this.baseMapper.selectUserList(user1); userIds.addAll(list.stream().map(SysUser::getUserId).collect(Collectors.toList())); } //个人权限 if(StringUtils.isNotEmpty(dataScope) && "5".equals(dataScope)){ userIds.add(userId); } return userIds; } }