SysUserServiceImpl.java 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630
  1. package com.railway.system.service.impl;
  2. import com.railway.common.annotation.DataScope;
  3. import com.railway.common.constant.UserConstants;
  4. import com.railway.common.core.domain.AjaxResult;
  5. import com.railway.common.core.domain.entity.SysRole;
  6. import com.railway.common.core.domain.entity.SysUser;
  7. import com.railway.common.enums.PostTypeEnum;
  8. import com.railway.common.exception.ServiceException;
  9. import com.railway.common.utils.PhoneUtils;
  10. import com.railway.common.utils.SecurityUtils;
  11. import com.railway.common.utils.StringUtils;
  12. import com.railway.common.utils.spring.SpringUtils;
  13. import com.railway.system.domain.SysPost;
  14. import com.railway.system.domain.SysUserPost;
  15. import com.railway.system.domain.SysUserRole;
  16. import com.railway.system.enums.ConfigEnum;
  17. import com.railway.system.mapper.SysPostMapper;
  18. import com.railway.system.mapper.SysRoleMapper;
  19. import com.railway.system.mapper.SysUserMapper;
  20. import com.railway.system.mapper.SysUserPostMapper;
  21. import com.railway.system.mapper.SysUserRoleMapper;
  22. import com.railway.system.service.ISysConfigService;
  23. import com.railway.system.service.ISysUserService;
  24. import java.util.ArrayList;
  25. import java.util.List;
  26. import java.util.stream.Collectors;
  27. import lombok.extern.slf4j.Slf4j;
  28. import org.apache.commons.collections4.CollectionUtils;
  29. import org.springframework.stereotype.Service;
  30. import org.springframework.transaction.annotation.Transactional;
  31. /**
  32. * 用户 业务层处理
  33. *
  34. * @author railway
  35. */
  36. @Slf4j
  37. @Service
  38. public class SysUserServiceImpl implements ISysUserService {
  39. private final SysUserMapper userMapper;
  40. private final SysRoleMapper roleMapper;
  41. private final SysPostMapper postMapper;
  42. private final SysUserRoleMapper userRoleMapper;
  43. private final SysUserPostMapper userPostMapper;
  44. private final ISysConfigService configService;
  45. public SysUserServiceImpl(SysUserMapper userMapper,
  46. SysRoleMapper roleMapper, SysPostMapper postMapper,
  47. SysUserRoleMapper userRoleMapper, SysUserPostMapper userPostMapper,
  48. ISysConfigService configService) {
  49. this.userMapper = userMapper;
  50. this.roleMapper = roleMapper;
  51. this.postMapper = postMapper;
  52. this.userRoleMapper = userRoleMapper;
  53. this.userPostMapper = userPostMapper;
  54. this.configService = configService;
  55. }
  56. /**
  57. * 根据条件分页查询用户列表
  58. *
  59. * @param user 用户信息
  60. * @return 用户信息集合信息
  61. */
  62. @Override
  63. @DataScope(deptAlias = "d", userAlias = "u")
  64. public List<SysUser> selectUserList(SysUser user) {
  65. List<SysUser> users = userMapper.selectUserList(user);
  66. for (SysUser sysUser : users) {
  67. if (CollectionUtils.isNotEmpty(sysUser.getRoles())) {
  68. // 把多个角色名以逗号分隔拼接
  69. String roleName = sysUser.getRoles().stream().map(SysRole::getRoleName)
  70. .collect(Collectors.joining(","));
  71. sysUser.setRoleName(roleName);
  72. }
  73. // 手机号脱敏
  74. String phone = sysUser.getPhone();
  75. try {
  76. phone = PhoneUtils.blurPhone(sysUser.getPhone());
  77. } catch (IllegalArgumentException ignored) {
  78. }
  79. sysUser.setPhone(phone);
  80. }
  81. return users;
  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 userName) {
  113. return userMapper.selectUserByUserName(userName);
  114. }
  115. /**
  116. * 通过工号查询用户
  117. *
  118. * @param nickName 工号
  119. * @return 用户对象信息
  120. */
  121. @Override
  122. public SysUser selectUserByNickName(String nickName) {
  123. return userMapper.selectUserByNickName(nickName);
  124. }
  125. /**
  126. * 通过手机号查询用户
  127. *
  128. * @param phone 手机号
  129. * @return 用户对象信息
  130. */
  131. @Override
  132. public SysUser selectUserByPhone(String phone) {
  133. return userMapper.selectUserByPhone(phone);
  134. }
  135. /**
  136. * 通过用户ID查询用户
  137. *
  138. * @param userId 用户ID
  139. * @return 用户对象信息
  140. */
  141. @Override
  142. public SysUser selectUserById(Long userId) {
  143. return userMapper.selectUserById(userId);
  144. }
  145. /**
  146. * 查询用户所属角色组
  147. *
  148. * @param userId 用户ID
  149. * @return 结果
  150. */
  151. @Override
  152. public String selectUserRoleGroup(Long userId) {
  153. List<SysRole> list = roleMapper.selectRolesByUserId(userId);
  154. StringBuilder idsStr = new StringBuilder();
  155. for (SysRole role : list) {
  156. idsStr.append(role.getRoleName()).append(",");
  157. }
  158. if (StringUtils.isNotEmpty(idsStr.toString())) {
  159. return idsStr.substring(0, idsStr.length() - 1);
  160. }
  161. return idsStr.toString();
  162. }
  163. /**
  164. * 查询用户所属岗位组
  165. *
  166. * @param userId 用户ID
  167. * @return 结果
  168. */
  169. @Override
  170. public String selectUserPostGroup(Long userId) {
  171. List<SysPost> list = postMapper.selectPostsByUserId(userId);
  172. StringBuilder idsStr = new StringBuilder();
  173. for (SysPost post : list) {
  174. idsStr.append(post.getPostName()).append(",");
  175. }
  176. if (StringUtils.isNotEmpty(idsStr.toString())) {
  177. return idsStr.substring(0, idsStr.length() - 1);
  178. }
  179. return idsStr.toString();
  180. }
  181. /**
  182. * 校验用户是否唯一
  183. *
  184. * @param user 用户信息
  185. * @return 结果
  186. */
  187. @Override
  188. public AjaxResult checkUserUnique(SysUser user) {
  189. String tips = "修改用户'";
  190. if(StringUtils.isNull(user.getUserId())){
  191. tips = "新增用户'";
  192. if (UserConstants.NOT_UNIQUE.equals(checkUserNameUnique(user.getUserName()))) {
  193. return AjaxResult.error(tips + user.getUserName() + "'失败,登录账号已存在");
  194. }
  195. }
  196. if (StringUtils.isNotEmpty(user.getPhone())
  197. && UserConstants.NOT_UNIQUE.equals(checkPhoneUnique(user))) {
  198. return AjaxResult.error(tips + user.getPhone() + "'失败,手机号码已存在");
  199. } else if (StringUtils.isNotEmpty(user.getNickName())
  200. && UserConstants.NOT_UNIQUE.equals(checkNickNameUnique(user))) {
  201. return AjaxResult.error(tips + user.getNickName() + "'失败,工已存在");
  202. } else if (StringUtils.isNotEmpty(user.getEmail())
  203. && UserConstants.NOT_UNIQUE.equals(checkEmailUnique(user))) {
  204. return AjaxResult.error(tips + user.getEmail() + "'失败,邮箱账号已存在");
  205. }
  206. // 验证角色是否冲突
  207. String roleTip = checkUserRole(user.getRoleIds());
  208. if (StringUtils.isNotEmpty(roleTip)) {
  209. return AjaxResult.error(roleTip);
  210. }
  211. return null;
  212. }
  213. /**
  214. * 校验用户名称是否唯一
  215. *
  216. * @param userName 用户名称
  217. * @return 结果
  218. */
  219. @Override
  220. public String checkUserNameUnique(String userName) {
  221. int count = userMapper.checkUserNameUnique(userName);
  222. if (count > 0) {
  223. return UserConstants.NOT_UNIQUE;
  224. }
  225. return UserConstants.UNIQUE;
  226. }
  227. /**
  228. * 校验工号是否唯一
  229. *
  230. * @param user 用户信息
  231. * @return 结果
  232. */
  233. @Override
  234. public String checkNickNameUnique(SysUser user) {
  235. long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  236. SysUser info = userMapper.checkNickNameUnique(user.getNickName());
  237. if (StringUtils.isNotNull(info) && info.getUserId() != userId) {
  238. return UserConstants.NOT_UNIQUE;
  239. }
  240. return UserConstants.UNIQUE;
  241. }
  242. /**
  243. * 校验用户名称是否唯一
  244. *
  245. * @param user 用户信息
  246. */
  247. @Override
  248. public String checkPhoneUnique(SysUser user) {
  249. long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  250. SysUser info = userMapper.checkPhoneUnique(user.getPhone());
  251. if (StringUtils.isNotNull(info) && info.getUserId() != userId) {
  252. return UserConstants.NOT_UNIQUE;
  253. }
  254. return UserConstants.UNIQUE;
  255. }
  256. /**
  257. * 校验email是否唯一
  258. *
  259. * @param user 用户信息
  260. */
  261. @Override
  262. public String checkEmailUnique(SysUser user) {
  263. long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  264. SysUser info = userMapper.checkEmailUnique(user.getEmail());
  265. if (StringUtils.isNotNull(info) && info.getUserId() != userId) {
  266. return UserConstants.NOT_UNIQUE;
  267. }
  268. return UserConstants.UNIQUE;
  269. }
  270. /**
  271. * 校验用户是否允许操作
  272. *
  273. * @param user 用户信息
  274. */
  275. @Override
  276. public void checkUserAllowed(SysUser user) {
  277. if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) {
  278. throw new ServiceException("不允许操作超级管理员用户");
  279. }
  280. }
  281. /**
  282. * 校验用户是否有数据权限
  283. *
  284. * @param userId 用户id
  285. */
  286. @Override
  287. public void checkUserDataScope(Long userId) {
  288. if (!SysUser.isAdmin(SecurityUtils.getUserId())) {
  289. SysUser user = new SysUser();
  290. user.setUserId(userId);
  291. List<SysUser> users = SpringUtils.getAopProxy(this).selectUserList(user);
  292. if (StringUtils.isEmpty(users)) {
  293. throw new ServiceException("没有权限访问用户数据!");
  294. }
  295. }
  296. }
  297. /**
  298. * 校验用户角色是否冲突
  299. *
  300. * @param roleIds 角色id
  301. */
  302. @Override
  303. public String checkUserRole(Long[] roleIds) {
  304. int cateNaryRoleNum = 0;
  305. int safeToolRoleNum = 0;
  306. if(roleIds.length > 1){
  307. for(Long roleId : roleIds){
  308. SysRole role = roleMapper.selectRoleById(roleId);
  309. PostTypeEnum postType = PostTypeEnum.ofRoleName(role.getRoleName());
  310. if(PostTypeEnum.isCateNary(postType)){
  311. cateNaryRoleNum++;
  312. }else if(PostTypeEnum.isSafeTool(postType)){
  313. safeToolRoleNum++;
  314. }
  315. }
  316. }
  317. if(cateNaryRoleNum > 1){
  318. return "中心领导、车间领导、车间职工角色只能选择其一!";
  319. }
  320. if(safeToolRoleNum > 1){
  321. return "送检员、实验员角色只能选择其一!";
  322. }
  323. return null;
  324. }
  325. /**
  326. * 新增保存用户信息
  327. *
  328. * @param user 用户信息
  329. * @return 结果
  330. */
  331. @Override
  332. @Transactional(rollbackFor = Exception.class)
  333. public int insertUser(SysUser user) {
  334. String password = user.getPassword();
  335. if (StringUtils.isEmpty(password)) {
  336. password = configService.selectConfigByKey(ConfigEnum.INIT_PASSWORD.getKey());
  337. }
  338. user.setPassword(SecurityUtils.encryptPassword(password));
  339. // 新增用户信息
  340. int rows = userMapper.insertUser(user);
  341. // 新增用户岗位关联
  342. insertUserPost(user);
  343. // 新增用户与角色管理
  344. insertUserRole(user);
  345. return rows;
  346. }
  347. /**
  348. * 注册用户信息
  349. *
  350. * @param user 用户信息
  351. * @return 结果
  352. */
  353. @Override
  354. public boolean registerUser(SysUser user) {
  355. return userMapper.insertUser(user) > 0;
  356. }
  357. /**
  358. * 修改保存用户信息
  359. *
  360. * @param user 用户信息
  361. * @return 结果
  362. */
  363. @Override
  364. @Transactional(rollbackFor = Exception.class)
  365. public int updateUser(SysUser user) {
  366. Long userId = user.getUserId();
  367. // 删除用户与角色关联
  368. userRoleMapper.deleteUserRoleByUserId(userId);
  369. // 新增用户与角色管理
  370. insertUserRole(user);
  371. // 删除用户与岗位关联
  372. userPostMapper.deleteUserPostByUserId(userId);
  373. // 新增用户与岗位管理
  374. insertUserPost(user);
  375. return userMapper.updateUser(user);
  376. }
  377. /**
  378. * 用户授权角色
  379. *
  380. * @param userId 用户ID
  381. * @param roleIds 角色组
  382. */
  383. @Override
  384. @Transactional(rollbackFor = Exception.class)
  385. public void insertUserAuth(Long userId, Long[] roleIds) {
  386. userRoleMapper.deleteUserRoleByUserId(userId);
  387. insertUserRole(userId, roleIds);
  388. }
  389. /**
  390. * 修改用户状态
  391. *
  392. * @param user 用户信息
  393. * @return 结果
  394. */
  395. @Override
  396. public int updateUserStatus(SysUser user) {
  397. return userMapper.updateUser(user);
  398. }
  399. /**
  400. * 修改用户基本信息
  401. *
  402. * @param user 用户信息
  403. * @return 结果
  404. */
  405. @Override
  406. public int updateUserProfile(SysUser user) {
  407. return userMapper.updateUser(user);
  408. }
  409. /**
  410. * 修改用户头像
  411. *
  412. * @param userId 用户ID
  413. * @param avatar 头像地址
  414. * @return 结果
  415. */
  416. @Override
  417. public boolean updateUserAvatar(Long userId, String avatar) {
  418. return userMapper.updateUserAvatar(userId, avatar) > 0;
  419. }
  420. /**
  421. * 重置用户密码
  422. *
  423. * @param user 用户信息
  424. * @return 结果
  425. */
  426. @Override
  427. public int resetPwd(SysUser user) {
  428. String password = configService.selectConfigByKey(ConfigEnum.INIT_PASSWORD.getKey());
  429. user.setPassword(SecurityUtils.encryptPassword(password));
  430. return userMapper.updateUser(user);
  431. }
  432. /**
  433. * 重置用户密码
  434. *
  435. * @param userId 用户ID
  436. * @param password 密码
  437. * @return 结果
  438. */
  439. @Override
  440. public int resetUserPwd(Long userId, String password) {
  441. return userMapper.resetUserPwd(userId, password);
  442. }
  443. /**
  444. * 新增用户角色信息
  445. *
  446. * @param user 用户对象
  447. */
  448. public void insertUserRole(SysUser user) {
  449. Long[] roles = user.getRoleIds();
  450. if (StringUtils.isNotNull(roles)) {
  451. // 新增用户与角色管理
  452. List<SysUserRole> list = new ArrayList<>();
  453. for (Long roleId : roles) {
  454. SysUserRole ur = new SysUserRole();
  455. ur.setUserId(user.getUserId());
  456. ur.setRoleId(roleId);
  457. list.add(ur);
  458. }
  459. if (list.size() > 0) {
  460. userRoleMapper.batchUserRole(list);
  461. }
  462. }
  463. }
  464. /**
  465. * 新增用户岗位信息
  466. *
  467. * @param user 用户对象
  468. */
  469. public void insertUserPost(SysUser user) {
  470. Long[] posts = user.getPostIds();
  471. if (StringUtils.isNotNull(posts)) {
  472. // 新增用户与岗位管理
  473. List<SysUserPost> list = new ArrayList<>();
  474. for (Long postId : posts) {
  475. SysUserPost up = new SysUserPost();
  476. up.setUserId(user.getUserId());
  477. up.setPostId(postId);
  478. list.add(up);
  479. }
  480. if (list.size() > 0) {
  481. userPostMapper.batchUserPost(list);
  482. }
  483. }
  484. }
  485. /**
  486. * 新增用户角色信息
  487. *
  488. * @param userId 用户ID
  489. * @param roleIds 角色组
  490. */
  491. public void insertUserRole(Long userId, Long[] roleIds) {
  492. if (StringUtils.isNotNull(roleIds)) {
  493. // 新增用户与角色管理
  494. List<SysUserRole> userRoleList = new ArrayList<>(roleIds.length);
  495. for (Long roleId : roleIds) {
  496. SysUserRole ur = new SysUserRole();
  497. ur.setUserId(userId);
  498. ur.setRoleId(roleId);
  499. userRoleList.add(ur);
  500. }
  501. if (userRoleList.size() > 0) {
  502. userRoleMapper.batchUserRole(userRoleList);
  503. }
  504. }
  505. }
  506. /**
  507. * 通过用户ID删除用户
  508. *
  509. * @param userId 用户ID
  510. * @return 结果
  511. */
  512. @Override
  513. @Transactional
  514. public int deleteUserById(Long userId) {
  515. // 删除用户与角色关联
  516. userRoleMapper.deleteUserRoleByUserId(userId);
  517. // 删除用户与岗位表
  518. userPostMapper.deleteUserPostByUserId(userId);
  519. return userMapper.deleteUserById(userId);
  520. }
  521. /**
  522. * 批量删除用户信息
  523. *
  524. * @param userIds 需要删除的用户ID
  525. * @return 结果
  526. */
  527. @Override
  528. @Transactional
  529. public int deleteUserByIds(Long[] userIds) {
  530. for (Long userId : userIds) {
  531. checkUserAllowed(new SysUser(userId));
  532. }
  533. // 删除用户与角色关联
  534. userRoleMapper.deleteUserRole(userIds);
  535. // 删除用户与岗位关联
  536. userPostMapper.deleteUserPost(userIds);
  537. return userMapper.deleteUserByIds(userIds);
  538. }
  539. /**
  540. * 导入用户数据
  541. *
  542. * @param userList 用户数据列表
  543. * @param isUpdateSupport 是否更新支持,如果已存在,则进行更新数据
  544. * @param operName 操作用户
  545. * @return 结果
  546. */
  547. @Override
  548. public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName) {
  549. if (StringUtils.isNull(userList) || userList.size() == 0) {
  550. throw new ServiceException("导入用户数据不能为空!");
  551. }
  552. int successNum = 0;
  553. int failureNum = 0;
  554. StringBuilder successMsg = new StringBuilder();
  555. StringBuilder failureMsg = new StringBuilder();
  556. String password = configService.selectConfigByKey(ConfigEnum.INIT_PASSWORD.getKey());
  557. for (SysUser user : userList) {
  558. try {
  559. // 验证是否存在这个用户
  560. SysUser u = userMapper.selectUserByUserName(user.getUserName());
  561. if (StringUtils.isNull(u)) {
  562. user.setPassword(SecurityUtils.encryptPassword(password));
  563. user.setCreateBy(operName);
  564. this.insertUser(user);
  565. successNum++;
  566. successMsg.append("<br/>").append(successNum).append("、账号 ").append(user.getUserName())
  567. .append(" 导入成功");
  568. } else if (isUpdateSupport) {
  569. user.setUpdateBy(operName);
  570. this.updateUser(user);
  571. successNum++;
  572. successMsg.append("<br/>").append(successNum).append("、账号 ").append(user.getUserName())
  573. .append(" 更新成功");
  574. } else {
  575. failureNum++;
  576. failureMsg.append("<br/>").append(failureNum).append("、账号 ").append(user.getUserName())
  577. .append(" 已存在");
  578. }
  579. } catch (Exception e) {
  580. failureNum++;
  581. String msg = "<br/>" + failureNum + "、账号 " + user.getUserName() + " 导入失败:";
  582. failureMsg.append(msg).append(e.getMessage());
  583. log.error(msg, e);
  584. }
  585. }
  586. if (failureNum > 0) {
  587. failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:");
  588. throw new ServiceException(failureMsg.toString());
  589. } else {
  590. successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:");
  591. }
  592. return successMsg.toString();
  593. }
  594. }