SysUserServiceImpl.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615
  1. package com.ruoyi.system.service.impl;
  2. import cn.hutool.core.util.ObjectUtil;
  3. import com.baomidou.dynamic.datasource.annotation.DS;
  4. import com.baomidou.dynamic.datasource.toolkit.DynamicDataSourceContextHolder;
  5. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  6. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  7. import com.ruoyi.common.annotation.DataScope;
  8. import com.ruoyi.common.annotation.TenantIgnore;
  9. import com.ruoyi.common.constant.BaseSourceConstant;
  10. import com.ruoyi.common.constant.UserConstants;
  11. import com.ruoyi.common.core.domain.entity.SysDept;
  12. import com.ruoyi.common.core.domain.entity.SysRole;
  13. import com.ruoyi.common.core.domain.entity.SysUser;
  14. import com.ruoyi.common.exception.ServiceException;
  15. import com.ruoyi.common.utils.SecurityUtils;
  16. import com.ruoyi.common.utils.StringUtils;
  17. import com.ruoyi.common.utils.bean.BeanValidators;
  18. import com.ruoyi.common.utils.spring.SpringUtils;
  19. import com.ruoyi.system.domain.SysPost;
  20. import com.ruoyi.system.domain.SysUserPost;
  21. import com.ruoyi.system.domain.SysUserRole;
  22. import com.ruoyi.system.mapper.*;
  23. import com.ruoyi.system.service.ISysConfigService;
  24. import com.ruoyi.system.service.ISysDeptService;
  25. import com.ruoyi.system.service.ISysUserService;
  26. import org.slf4j.Logger;
  27. import org.slf4j.LoggerFactory;
  28. import org.springframework.beans.factory.annotation.Autowired;
  29. import org.springframework.stereotype.Service;
  30. import org.springframework.transaction.annotation.Propagation;
  31. import org.springframework.transaction.annotation.Transactional;
  32. import org.springframework.util.CollectionUtils;
  33. import javax.validation.Validator;
  34. import java.util.*;
  35. import java.util.stream.Collectors;
  36. /**
  37. * 用户 业务层处理
  38. *
  39. * @author ruoyi
  40. */
  41. @Service
  42. public class SysUserServiceImpl extends ServiceImpl<SysUserMapper, SysUser> implements ISysUserService {
  43. private static final Logger log = LoggerFactory.getLogger(SysUserServiceImpl.class);
  44. @Autowired
  45. protected Validator validator;
  46. @Autowired
  47. private SysUserMapper userMapper;
  48. @Autowired
  49. private SysRoleMapper roleMapper;
  50. @Autowired
  51. private SysPostMapper postMapper;
  52. @Autowired
  53. private SysUserRoleMapper userRoleMapper;
  54. @Autowired
  55. private SysUserPostMapper userPostMapper;
  56. @Autowired
  57. private ISysConfigService configService;
  58. @Autowired
  59. private ISysDeptService sysDeptService;
  60. /**
  61. * 根据条件分页查询用户列表
  62. *
  63. * @param user 用户信息
  64. * @return 用户信息集合信息
  65. */
  66. @Override
  67. @DataScope(deptAlias = "d", userAlias = "u")
  68. public List<SysUser> selectUserList(SysUser user) {
  69. List<SysUser> sysUserList = userMapper.selectUserList(user);
  70. // 赋值角色
  71. if (sysUserList.size() == 0) {
  72. return sysUserList;
  73. }
  74. List<Long> userIdList = sysUserList.stream().map(SysUser::getUserId).collect(Collectors.toList());
  75. List<SysRole> roleList = baseMapper.getRoleByUserIdList(userIdList);
  76. Map<Long, List<SysRole>> map = roleList.stream().collect(Collectors.groupingBy(SysRole::getUserId));
  77. for (SysUser sysUser : sysUserList) {
  78. List<SysRole> sysRoleList = map.getOrDefault(sysUser.getUserId(), Collections.emptyList());
  79. sysUser.setSysRoleList(sysRoleList);
  80. }
  81. return sysUserList;
  82. }
  83. /**
  84. * 根据条件分页查询已分配用户角色列表
  85. *
  86. * @param user 用户信息
  87. * @return 用户信息集合信息
  88. */
  89. @Override
  90. @DataScope(deptAlias = "d", userAlias = "u")
  91. public List<SysUser> selectAllocatedList(SysUser user) {
  92. return userMapper.selectAllocatedList(user);
  93. }
  94. /**
  95. * 根据条件分页查询未分配用户角色列表
  96. *
  97. * @param user 用户信息
  98. * @return 用户信息集合信息
  99. */
  100. @Override
  101. @DataScope(deptAlias = "d", userAlias = "u")
  102. public List<SysUser> selectUnallocatedList(SysUser user) {
  103. return userMapper.selectUnallocatedList(user);
  104. }
  105. /**
  106. * 通过用户名查询用户
  107. *
  108. * @param userName 用户名
  109. * @return 用户对象信息
  110. */
  111. @Override
  112. public SysUser selectUserByUserName(String tenantId, String userName) {
  113. return userMapper.selectUserByUserName(tenantId, userName);
  114. }
  115. /**
  116. * 通过用户ID查询用户
  117. *
  118. * @param userId 用户ID
  119. * @return 用户对象信息
  120. */
  121. @Override
  122. public SysUser selectUserById(Long userId) {
  123. return userMapper.selectUserById(userId);
  124. }
  125. /**
  126. * 查询用户所属角色组
  127. *
  128. * @param userName 用户名
  129. * @return 结果
  130. */
  131. @Override
  132. public String selectUserRoleGroup(String userName) {
  133. List<SysRole> list = roleMapper.selectRolesByUserName(userName);
  134. if (CollectionUtils.isEmpty(list)) {
  135. return StringUtils.EMPTY;
  136. }
  137. return list.stream().map(SysRole::getRoleName).collect(Collectors.joining(","));
  138. }
  139. /**
  140. * 查询用户所属岗位组
  141. *
  142. * @param userName 用户名
  143. * @return 结果
  144. */
  145. @Override
  146. public String selectUserPostGroup(String userName) {
  147. List<SysPost> list = postMapper.selectPostsByUserName(userName);
  148. if (CollectionUtils.isEmpty(list)) {
  149. return StringUtils.EMPTY;
  150. }
  151. return list.stream().map(SysPost::getPostName).collect(Collectors.joining(","));
  152. }
  153. /**
  154. * 校验用户名称是否唯一
  155. *
  156. * @param user 用户信息
  157. * @return 结果
  158. */
  159. @Override
  160. public boolean checkUserNameUnique(SysUser user) {
  161. Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  162. SysUser info = userMapper.checkUserNameUnique(user);
  163. if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) {
  164. return UserConstants.NOT_UNIQUE;
  165. }
  166. return UserConstants.UNIQUE;
  167. }
  168. /**
  169. * 校验手机号码是否唯一
  170. *
  171. * @param user 用户信息
  172. * @return
  173. */
  174. @Override
  175. public boolean checkPhoneUnique(SysUser user) {
  176. Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  177. SysUser info = userMapper.checkPhoneUnique(user.getPhonenumber());
  178. if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) {
  179. return UserConstants.NOT_UNIQUE;
  180. }
  181. return UserConstants.UNIQUE;
  182. }
  183. /**
  184. * 校验email是否唯一
  185. *
  186. * @param user 用户信息
  187. * @return
  188. */
  189. @Override
  190. public boolean checkEmailUnique(SysUser user) {
  191. Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  192. SysUser info = userMapper.checkEmailUnique(user.getEmail());
  193. if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) {
  194. return UserConstants.NOT_UNIQUE;
  195. }
  196. return UserConstants.UNIQUE;
  197. }
  198. /**
  199. * 校验用户是否允许操作
  200. *
  201. * @param user 用户信息
  202. */
  203. @Override
  204. public void checkUserAllowed(SysUser user) {
  205. if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) {
  206. throw new ServiceException("不允许操作超级管理员用户");
  207. }
  208. }
  209. /**
  210. * 校验用户是否有数据权限
  211. *
  212. * @param userId 用户id
  213. */
  214. @Override
  215. public void checkUserDataScope(Long userId) {
  216. if (!SysUser.isAdmin(SecurityUtils.getUserId())) {
  217. SysUser user = new SysUser();
  218. user.setUserId(userId);
  219. List<SysUser> users = SpringUtils.getAopProxy(this).selectUserList(user);
  220. if (StringUtils.isEmpty(users)) {
  221. throw new ServiceException("没有权限访问用户数据!");
  222. }
  223. // //检查登录用户角色 是否是管理员
  224. // List<SysRole> roleByUserIdList = userMapper.getRoleByUserIdList(Arrays.asList(SecurityUtils.getUserId()));
  225. // List<String> roleKeyList = roleByUserIdList.stream().map(SysRole::getRoleKey).collect(Collectors.toList());
  226. // if (!roleKeyList.contains("admin")) {
  227. // throw new ServiceException("没有权限访问用户数据!");
  228. // }
  229. }
  230. }
  231. /**
  232. * 新增保存用户信息
  233. *
  234. * @param user 用户信息
  235. * @return 结果
  236. */
  237. @Override
  238. @Transactional
  239. public int insertUser(SysUser user) {
  240. // 新增用户信息
  241. int rows = userMapper.insertUser(user);
  242. // 新增用户岗位关联
  243. insertUserPost(user);
  244. // 新增用户与角色管理
  245. insertUserRole(user);
  246. return rows;
  247. }
  248. /**
  249. * 注册用户信息
  250. *
  251. * @param user 用户信息
  252. * @return 结果
  253. */
  254. @Override
  255. public boolean registerUser(SysUser user) {
  256. return userMapper.insertUser(user) > 0;
  257. }
  258. /**
  259. * 修改保存用户信息
  260. *
  261. * @param user 用户信息
  262. * @return 结果
  263. */
  264. @Override
  265. @Transactional
  266. public int updateUser(SysUser user) {
  267. Long userId = user.getUserId();
  268. // 删除用户与角色关联
  269. userRoleMapper.deleteUserRoleByUserId(userId);
  270. // 新增用户与角色管理
  271. insertUserRole(user);
  272. // 删除用户与岗位关联
  273. userPostMapper.deleteUserPostByUserId(userId);
  274. // 新增用户与岗位管理
  275. insertUserPost(user);
  276. return userMapper.updateUser(user);
  277. }
  278. /**
  279. * 用户授权角色
  280. *
  281. * @param userId 用户ID
  282. * @param roleIds 角色组
  283. */
  284. @Override
  285. @Transactional
  286. public void insertUserAuth(Long userId, Long[] roleIds) {
  287. userRoleMapper.deleteUserRoleByUserId(userId);
  288. insertUserRole(userId, roleIds);
  289. }
  290. /**
  291. * 修改用户状态
  292. *
  293. * @param user 用户信息
  294. * @return 结果
  295. */
  296. @Override
  297. public int updateUserStatus(SysUser user) {
  298. return userMapper.updateUser(user);
  299. }
  300. /**
  301. * 修改用户基本信息
  302. *
  303. * @param user 用户信息
  304. * @return 结果
  305. */
  306. @TenantIgnore
  307. @Override
  308. public int updateUserProfile(SysUser user) {
  309. return userMapper.updateUser(user);
  310. }
  311. /**
  312. * 修改用户头像
  313. *
  314. * @param userName 用户名
  315. * @param avatar 头像地址
  316. * @return 结果
  317. */
  318. @Override
  319. public boolean updateUserAvatar(String userName, String avatar) {
  320. return userMapper.updateUserAvatar(userName, avatar) > 0;
  321. }
  322. /**
  323. * 重置用户密码
  324. *
  325. * @param user 用户信息
  326. * @return 结果
  327. */
  328. @Override
  329. public int resetPwd(SysUser user) {
  330. // return userMapper.updateUser(user);
  331. return resetUserPwdById(user.getUserId(), user.getPassword());
  332. }
  333. /**
  334. * 根据用户id修改用户密码
  335. */
  336. @Override
  337. public int resetUserPwdById(Long userId, String password) {
  338. return userMapper.updateUserPwdById(userId, password);
  339. }
  340. /**
  341. * 重置用户密码
  342. *
  343. * @param userName 用户名
  344. * @param password 密码
  345. * @return 结果
  346. */
  347. @Override
  348. public int resetUserPwd(String userName, String password) {
  349. return userMapper.resetUserPwd(userName, password);
  350. }
  351. /**
  352. * 新增用户角色信息
  353. *
  354. * @param user 用户对象
  355. */
  356. public void insertUserRole(SysUser user) {
  357. this.insertUserRole(user.getUserId(), user.getRoleIds());
  358. }
  359. /**
  360. * 新增用户岗位信息
  361. *
  362. * @param user 用户对象
  363. */
  364. public void insertUserPost(SysUser user) {
  365. Long[] posts = user.getPostIds();
  366. if (StringUtils.isNotEmpty(posts)) {
  367. // 新增用户与岗位管理
  368. List<SysUserPost> list = new ArrayList<SysUserPost>(posts.length);
  369. for (Long postId : posts) {
  370. SysUserPost up = new SysUserPost();
  371. up.setUserId(user.getUserId());
  372. up.setPostId(postId);
  373. list.add(up);
  374. }
  375. userPostMapper.batchUserPost(list);
  376. }
  377. }
  378. /**
  379. * 新增用户角色信息
  380. *
  381. * @param userId 用户ID
  382. * @param roleIds 角色组
  383. */
  384. public void insertUserRole(Long userId, Long[] roleIds) {
  385. if (StringUtils.isNotEmpty(roleIds)) {
  386. // 新增用户与角色管理
  387. List<SysUserRole> list = new ArrayList<SysUserRole>(roleIds.length);
  388. for (Long roleId : roleIds) {
  389. SysUserRole ur = new SysUserRole();
  390. ur.setUserId(userId);
  391. ur.setRoleId(roleId);
  392. list.add(ur);
  393. }
  394. userRoleMapper.batchUserRole(list);
  395. }
  396. }
  397. /**
  398. * 通过用户ID删除用户
  399. *
  400. * @param userId 用户ID
  401. * @return 结果
  402. */
  403. @Override
  404. @Transactional
  405. public int deleteUserById(Long userId) {
  406. // 删除用户与角色关联
  407. userRoleMapper.deleteUserRoleByUserId(userId);
  408. // 删除用户与岗位表
  409. userPostMapper.deleteUserPostByUserId(userId);
  410. return userMapper.deleteUserById(userId);
  411. }
  412. /**
  413. * 批量删除用户信息
  414. *
  415. * @param userIds 需要删除的用户ID
  416. * @return 结果
  417. */
  418. @Override
  419. @Transactional
  420. public int deleteUserByIds(Long[] userIds) {
  421. for (Long userId : userIds) {
  422. checkUserAllowed(new SysUser(userId));
  423. checkUserDataScope(userId);
  424. }
  425. // 删除用户与角色关联
  426. userRoleMapper.deleteUserRole(userIds);
  427. // 删除用户与岗位关联
  428. userPostMapper.deleteUserPost(userIds);
  429. return userMapper.deleteUserByIds(userIds);
  430. }
  431. /**
  432. * 导入用户数据
  433. *
  434. * @param userList 用户数据列表
  435. * @param isUpdateSupport 是否更新支持,如果已存在,则进行更新数据
  436. * @param operName 操作用户
  437. * @return 结果
  438. */
  439. @Override
  440. public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName) {
  441. if (StringUtils.isNull(userList) || userList.size() == 0) {
  442. throw new ServiceException("导入用户数据不能为空!");
  443. }
  444. int successNum = 0;
  445. int failureNum = 0;
  446. StringBuilder successMsg = new StringBuilder();
  447. StringBuilder failureMsg = new StringBuilder();
  448. String password = configService.selectConfigByKey("sys.user.initPassword");
  449. for (SysUser user : userList) {
  450. try {
  451. // 验证是否存在这个用户
  452. SysUser u = userMapper.selectUserByUserName(user.getTenantId(), user.getUserName());
  453. if (StringUtils.isNull(u)) {
  454. BeanValidators.validateWithException(validator, user);
  455. user.setPassword(SecurityUtils.encryptPassword(password));
  456. user.setCreateBy(operName);
  457. this.insertUser(user);
  458. successNum++;
  459. successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 导入成功");
  460. } else if (isUpdateSupport) {
  461. BeanValidators.validateWithException(validator, user);
  462. checkUserAllowed(user);
  463. checkUserDataScope(user.getUserId());
  464. user.setUpdateBy(operName);
  465. this.updateUser(user);
  466. successNum++;
  467. successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 更新成功");
  468. } else {
  469. failureNum++;
  470. failureMsg.append("<br/>" + failureNum + "、账号 " + user.getUserName() + " 已存在");
  471. }
  472. } catch (Exception e) {
  473. failureNum++;
  474. String msg = "<br/>" + failureNum + "、账号 " + user.getUserName() + " 导入失败:";
  475. failureMsg.append(msg + e.getMessage());
  476. log.error(msg, e);
  477. }
  478. }
  479. if (failureNum > 0) {
  480. failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:");
  481. throw new ServiceException(failureMsg.toString());
  482. } else {
  483. successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:");
  484. }
  485. return successMsg.toString();
  486. }
  487. @Transactional(propagation = Propagation.REQUIRES_NEW)
  488. @DS(BaseSourceConstant.BASE)
  489. @Override
  490. public List<SysUser> getListByUserId(List<Long> userIdList) {
  491. return listByIds(userIdList);
  492. }
  493. @Override
  494. public List<SysUser> getListByPostId(Long postId) {
  495. return baseMapper.getListByPostId(postId);
  496. }
  497. @Override
  498. public List<SysUser> getListByRoleId(Long roleId) {
  499. return baseMapper.getListByRoleId(roleId);
  500. }
  501. @Override
  502. public List<SysUser> getAuthUserList() {
  503. DynamicDataSourceContextHolder.push(BaseSourceConstant.BASE);
  504. Long userId = SecurityUtils.getUserId();
  505. List<SysDept> sysDeptList = sysDeptService.list(Wrappers.<SysDept>lambdaQuery()
  506. .and(q -> q.eq(SysDept::getDirectorId, userId).or().eq(SysDept::getLeaderId, userId)));
  507. if (sysDeptList.size() == 0) {
  508. SysUser sysUser = getById(userId);
  509. sysUser.setPassword(null);
  510. List<SysUser> sysUserList = Collections.singletonList(sysUser);
  511. DynamicDataSourceContextHolder.poll();
  512. return sysUserList;
  513. }
  514. Set<Long> deptSet = new HashSet<>();
  515. List<SysDept> list = sysDeptService.list();
  516. Map<Long, List<SysDept>> parentDeptMap = list.stream().collect(Collectors.groupingBy(SysDept::getParentId));
  517. for (SysDept sysDept : sysDeptList) {
  518. Long deptId = sysDept.getDeptId();
  519. if (Objects.equals(sysDept.getDirectorId(), userId)) {
  520. subordinateDeptId(deptId, deptSet, parentDeptMap);
  521. } else {
  522. deptSet.add(deptId);
  523. }
  524. }
  525. List<SysUser> sysUserList = list(Wrappers.<SysUser>lambdaQuery()
  526. .and(q -> q.in(SysUser::getDeptId, deptSet).or().eq(SysUser::getUserId, userId)));
  527. sysUserList.forEach(item -> item.setPassword(null));
  528. DynamicDataSourceContextHolder.poll();
  529. return sysUserList;
  530. }
  531. /**
  532. * 获取用户信息
  533. *
  534. * @return
  535. */
  536. @Override
  537. public SysUser getUserById() {
  538. DynamicDataSourceContextHolder.push(BaseSourceConstant.BASE);
  539. SysUser sysUser = getById(SecurityUtils.getUserId());
  540. DynamicDataSourceContextHolder.poll();
  541. if (ObjectUtil.isEmpty(sysUser)) {
  542. throw new ServiceException("用户异常");
  543. }
  544. return sysUser;
  545. }
  546. @Override
  547. public List<Long> getDetpIdListByUserId(Long userId) {
  548. return baseMapper.getDetpIdListByUserId(userId);
  549. }
  550. private void subordinateDeptId(Long deptId, Set<Long> deptSet, Map<Long, List<SysDept>> parentDeptMap) {
  551. deptSet.add(deptId);
  552. // 获取子部门
  553. List<SysDept> sysDeptList = parentDeptMap.get(deptId);
  554. if (ObjectUtil.isEmpty(sysDeptList)) {
  555. return;
  556. }
  557. for (SysDept sysDept : sysDeptList) {
  558. subordinateDeptId(sysDept.getDeptId(), deptSet, parentDeptMap);
  559. }
  560. }
  561. }