package com.project.system.service.impl; import cn.hutool.core.convert.Convert; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.project.common.annotation.DataScope; import com.project.common.constant.UserConstants; import com.project.common.core.domain.entity.SysDept; import com.project.common.core.domain.entity.SysRole; import com.project.common.core.domain.entity.SysUser; import com.project.common.core.domain.model.ImportError; import com.project.common.exception.ServiceException; import com.project.common.exception.base.BaseException; import com.project.common.utils.SecurityUtils; import com.project.common.utils.StringUtils; import com.project.common.utils.bean.BeanValidators; import com.project.common.utils.spring.SpringUtils; import com.project.system.domain.*; import com.project.system.domain.bo.editBo.UserDeptBo; import com.project.system.domain.vo.SysUserResultVo; import com.project.system.domain.vo.SysUserVo; import com.project.system.mapper.*; import com.project.system.service.ISysConfigService; import com.project.system.service.ISysDeptService; import com.project.system.service.ISysUserDeptService; import com.project.system.service.ISysUserService; import lombok.RequiredArgsConstructor; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.cache.annotation.CacheEvict; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import javax.validation.Validator; import java.util.ArrayList; import java.util.List; import java.util.stream.Collectors; /** * 用户 业务层处理 * * @author project */ @Service @RequiredArgsConstructor(onConstructor_ = @Autowired) public class SysUserServiceImpl extends ServiceImpl implements ISysUserService { private static final Logger log = LoggerFactory.getLogger(SysUserServiceImpl.class); private final SysUserMapper userMapper; private final SysRoleMapper roleMapper; private final SysPostMapper postMapper; private final SysUserRoleMapper userRoleMapper; private final SysUserPostMapper userPostMapper; private final ISysConfigService configService; private final ISysUserDeptService userDeptService; private final ISysDeptService deptService; protected final Validator validator; /** * 根据条件分页查询用户列表 * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List selectUserListCommon(SysUser user) { return userMapper.selectUserListCommon(user); } /** * 根据条件分页查询用户列表 * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List selectUserList(SysUser user) { return userMapper.selectUserList(user); } /** * 根据条件分页查询已分配用户角色列表 * * @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 String 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 String 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 String 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 @CacheEvict(value = "sysUser:peerList",allEntries = true) public int insertUser(SysUser user) { // 新增用户信息 int rows = userMapper.insertUser(user); // 新增用户岗位关联 insertUserPost(user); // 新增用户与角色管理 insertUserRole(user); // 新增用户与部门管理 if (!"02".equals(user.getUserType())){ insertUserDept(user); } return rows; } /** * 注册用户信息 * * @param user 用户信息 * @return 结果 */ @Override public boolean registerUser(SysUser user) { return userMapper.insertUser(user) > 0; } /** * 修改保存用户信息 * * @param user 用户信息 * @return 结果 */ @Override @Transactional @CacheEvict(value = "sysUser:peerList",allEntries = true) public int updateUser(SysUser user) { Long userId = user.getUserId(); // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); // 新增用户与角色管理 insertUserRole(user); // 删除用户与岗位关联 userPostMapper.deleteUserPostByUserId(userId); // 新增用户与岗位管理 insertUserPost(user); SysUser old = this.selectUserById(userId); // 新增用户与部门管理 if (!"02".equals(user.getUserType()) && !old.getDeptId().equals(user.getDeptId())){ insertUserDept(user); } return userMapper.updateUser(user); } /** * 用户授权角色 * * @param userId 用户ID * @param roleIds 角色组 */ @Override @Transactional 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,String remark) { return userMapper.resetUserPwd(userName, password, remark); } /** * 新增用户角色信息 * * @param user 用户对象 */ public void insertUserRole(SysUser user) { this.insertUserRole(user.getUserId(), user.getRoleIds()); } /** * 新增用户部门 * * @param user 用户对象 */ public void insertUserDept(SysUser user) { if (deptService.getCheckDeptIdByLoginDeptId(user.getDeptId()).equals(user.getDeptId())) { //分管局内所有部门 List list = deptService.list(deptService.lq().eq(SysDept::getParentId, user.getDeptId())); List deptIds = list.stream().map(SysDept::getDeptId).collect(Collectors.toList()); deptIds.add(user.getDeptId()); UserDeptBo bo = new UserDeptBo(); bo.setUserId(user.getUserId()); bo.setDeptIds(deptIds); userDeptService.batchUserDeptSave(bo); } else { //分管单独部门 userDeptService.remove(userDeptService.lq().eq(SysUserDept::getUserId, user.getUserId())); SysUserDept userDept = new SysUserDept().setUserId(user.getUserId()).setDeptId(user.getDeptId()); userDeptService.save(userDept); } } /** * 新增用户岗位信息 * * @param user 用户对象 */ public void insertUserPost(SysUser user) { Long[] posts = user.getPostIds(); if (StringUtils.isNotEmpty(posts)) { // 新增用户与岗位管理 List list = new ArrayList(posts.length); 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(roleIds.length); 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 @CacheEvict(value = "sysUser:peerList",allEntries = true) public int deleteUserById(Long userId) { // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); // 删除用户与岗位表 userPostMapper.deleteUserPostByUserId(userId); return userMapper.deleteUserById(userId); } /** * 批量删除用户信息 * * @param userIds 需要删除的用户ID * @return 结果 */ @Override @Transactional @CacheEvict(value = "sysUser:peerList",allEntries = true) 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); this.insertUser(user); successNum++; successMsg.append("
" + successNum + "、账号 " + user.getUserName() + " 导入成功"); } else if (isUpdateSupport) { BeanValidators.validateWithException(validator, user); checkUserAllowed(user); checkUserDataScope(user.getUserId()); user.setUpdateBy(operName); this.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(); } /** * 批量删除用户信息 * * @param phone 需要删除的用户ID * @return 结果 */ @Override @Transactional public int deleteUserByCompanyPhone(String phone) { List sysUsers = userMapper.selectList(new LambdaQueryWrapper().eq(SysUser::getPhonenumber, phone)); Long[] ids = sysUsers.stream().map(SysUser::getUserId).toArray(Long[]::new); return this.deleteUserByIds(ids); } @Override public List getPhonesByRoleKey(String roleKey, Long deptId) { return userMapper.getPhonesByRoleKey(roleKey, deptId); } @Override public int resetPhone(Long userId, String phone) { return userMapper.resetPhone(userId, phone); } /** * 处理导入数据 * @param list 数据 * @param deptId 导入部门id * @return 结果 */ @Override public SysUserResultVo doImport(List list, Long deptId) { if (list==null || list.size()<1){ throw new BaseException("未获取到导入信息!"); } SysUserResultVo resultVo = new SysUserResultVo(); list.forEach(sysUserVo -> { sysUserVo.setDeptId(deptId); }); resultVo.setVoList(list); return this.checkImport(resultVo); } /** * 校验导入数据 * @param resultVo 数据 * @return 结果 */ @Override public SysUserResultVo checkImport(SysUserResultVo resultVo) { if (resultVo==null || StringUtils.isEmpty(resultVo.getVoList())){ throw new BaseException("未获取到导入信息!"); } for (SysUserVo vo : resultVo.getVoList()) { List errors = new ArrayList<>(); validEntityBeforeImport(vo, errors); vo.setErrorList(errors); } return resultVo; } /** * 验证参数 * @param entity 数据 * @param errorList 错误数据 */ private void validEntityBeforeImport(SysUserVo entity, List errorList) { if (StringUtils.isEmpty(entity.getNickName())){ errorList.add(new ImportError(0, "请填姓名!")); } if (StringUtils.isEmpty(entity.getDeptName())){ errorList.add(new ImportError(1, "请填写部门信息!")); } else { SysDept sysDept = deptService.selectDeptById(entity.getDeptId()); if (sysDept==null || !sysDept.getDeptName().equals(entity.getDeptName())){ errorList.add(new ImportError(1, "部门信息不匹配!")); } } if (StringUtils.isEmpty(entity.getPhonenumber())){ errorList.add(new ImportError(2, "请填写手机号!")); } else { SysUser user = this.selectUserByUserName(entity.getPhonenumber()); if (user!=null){ entity.setUserId(user.getUserId()); } else { SysUser check = new SysUser(); check.setPhonenumber(entity.getPhonenumber()); String s = checkPhoneUnique(check); if (UserConstants.NOT_UNIQUE.equals(s)) { errorList.add(new ImportError(2, "手机号已存在!")); } } } if (StringUtils.isNotEmpty(entity.getEmail())){ SysUser check = new SysUser(); check.setPhonenumber(entity.getPhonenumber()); String s = checkEmailUnique(check); if (UserConstants.NOT_UNIQUE.equals(s)) { errorList.add(new ImportError(3, "邮箱已存在!")); } } if (StringUtils.isNotEmpty(entity.getImportSex())){ switch (entity.getImportSex().trim()){ case "男": entity.setSex("0"); break; case "女": entity.setSex("1"); break; case "未知": entity.setSex("2"); break; } } else { entity.setSex("2"); } } /** * 保存导入结果 * @param resultVo 数据 * @return 结果 */ @Override @Transactional public Boolean saveImport(SysUserResultVo resultVo) { if (resultVo==null || StringUtils.isEmpty(resultVo.getVoList())){ throw new BaseException("未获取到导入信息!"); } resultVo.getVoList().forEach(e-> { if (StringUtils.isNotEmpty(e.getErrorList())) { throw new BaseException("还有未处理错误信息!"); } }); List users = Convert.toList(SysUser.class, resultVo.getVoList()); for (SysUser user : users) { this.insertUser(user); } return true; } @Override public String getDeptNameByUserId(Long userId) { return deptService.selectDeptById(selectUserById(userId).getDeptId()).getDeptName(); } }