SysUserServiceImpl.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501
  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.entity.SysRole;
  5. import com.railway.common.core.domain.entity.SysUser;
  6. import com.railway.common.exception.ServiceException;
  7. import com.railway.common.utils.SecurityUtils;
  8. import com.railway.common.utils.StringUtils;
  9. import com.railway.common.utils.spring.SpringUtils;
  10. import com.railway.system.domain.SysPost;
  11. import com.railway.system.domain.SysUserPost;
  12. import com.railway.system.domain.SysUserRole;
  13. import com.railway.system.mapper.SysPostMapper;
  14. import com.railway.system.mapper.SysRoleMapper;
  15. import com.railway.system.mapper.SysUserMapper;
  16. import com.railway.system.mapper.SysUserPostMapper;
  17. import com.railway.system.mapper.SysUserRoleMapper;
  18. import com.railway.system.service.ISysConfigService;
  19. import com.railway.system.service.ISysUserService;
  20. import java.util.ArrayList;
  21. import java.util.List;
  22. import lombok.extern.slf4j.Slf4j;
  23. import org.springframework.stereotype.Service;
  24. import org.springframework.transaction.annotation.Transactional;
  25. /**
  26. * 用户 业务层处理
  27. *
  28. * @author railway
  29. */
  30. @Slf4j
  31. @Service
  32. public class SysUserServiceImpl implements ISysUserService {
  33. private final SysUserMapper userMapper;
  34. private final SysRoleMapper roleMapper;
  35. private final SysPostMapper postMapper;
  36. private final SysUserRoleMapper userRoleMapper;
  37. private final SysUserPostMapper userPostMapper;
  38. private final ISysConfigService configService;
  39. public SysUserServiceImpl(SysUserMapper userMapper,
  40. SysRoleMapper roleMapper, SysPostMapper postMapper,
  41. SysUserRoleMapper userRoleMapper, SysUserPostMapper userPostMapper,
  42. ISysConfigService configService) {
  43. this.userMapper = userMapper;
  44. this.roleMapper = roleMapper;
  45. this.postMapper = postMapper;
  46. this.userRoleMapper = userRoleMapper;
  47. this.userPostMapper = userPostMapper;
  48. this.configService = configService;
  49. }
  50. /**
  51. * 根据条件分页查询用户列表
  52. *
  53. * @param user 用户信息
  54. * @return 用户信息集合信息
  55. */
  56. @Override
  57. @DataScope(deptAlias = "d", userAlias = "u")
  58. public List<SysUser> selectUserList(SysUser user) {
  59. return userMapper.selectUserList(user);
  60. }
  61. /**
  62. * 根据条件分页查询已分配用户角色列表
  63. *
  64. * @param user 用户信息
  65. * @return 用户信息集合信息
  66. */
  67. @Override
  68. @DataScope(deptAlias = "d", userAlias = "u")
  69. public List<SysUser> selectAllocatedList(SysUser user) {
  70. return userMapper.selectAllocatedList(user);
  71. }
  72. /**
  73. * 根据条件分页查询未分配用户角色列表
  74. *
  75. * @param user 用户信息
  76. * @return 用户信息集合信息
  77. */
  78. @Override
  79. @DataScope(deptAlias = "d", userAlias = "u")
  80. public List<SysUser> selectUnallocatedList(SysUser user) {
  81. return userMapper.selectUnallocatedList(user);
  82. }
  83. /**
  84. * 通过用户名查询用户
  85. *
  86. * @param userName 用户名
  87. * @return 用户对象信息
  88. */
  89. @Override
  90. public SysUser selectUserByUserName(String userName) {
  91. return userMapper.selectUserByUserName(userName);
  92. }
  93. /**
  94. * 通过用户ID查询用户
  95. *
  96. * @param userId 用户ID
  97. * @return 用户对象信息
  98. */
  99. @Override
  100. public SysUser selectUserById(Long userId) {
  101. return userMapper.selectUserById(userId);
  102. }
  103. /**
  104. * 查询用户所属角色组
  105. *
  106. * @param userName 用户名
  107. * @return 结果
  108. */
  109. @Override
  110. public String selectUserRoleGroup(String userName) {
  111. List<SysRole> list = roleMapper.selectRolesByUserName(userName);
  112. StringBuilder idsStr = new StringBuilder();
  113. for (SysRole role : list) {
  114. idsStr.append(role.getRoleName()).append(",");
  115. }
  116. if (StringUtils.isNotEmpty(idsStr.toString())) {
  117. return idsStr.substring(0, idsStr.length() - 1);
  118. }
  119. return idsStr.toString();
  120. }
  121. /**
  122. * 查询用户所属岗位组
  123. *
  124. * @param userName 用户名
  125. * @return 结果
  126. */
  127. @Override
  128. public String selectUserPostGroup(String userName) {
  129. List<SysPost> list = postMapper.selectPostsByUserName(userName);
  130. StringBuilder idsStr = new StringBuilder();
  131. for (SysPost post : list) {
  132. idsStr.append(post.getPostName()).append(",");
  133. }
  134. if (StringUtils.isNotEmpty(idsStr.toString())) {
  135. return idsStr.substring(0, idsStr.length() - 1);
  136. }
  137. return idsStr.toString();
  138. }
  139. /**
  140. * 校验用户名称是否唯一
  141. *
  142. * @param userName 用户名称
  143. * @return 结果
  144. */
  145. @Override
  146. public String checkUserNameUnique(String userName) {
  147. int count = userMapper.checkUserNameUnique(userName);
  148. if (count > 0) {
  149. return UserConstants.NOT_UNIQUE;
  150. }
  151. return UserConstants.UNIQUE;
  152. }
  153. /**
  154. * 校验用户名称是否唯一
  155. *
  156. * @param user 用户信息
  157. */
  158. @Override
  159. public String checkPhoneUnique(SysUser user) {
  160. long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  161. SysUser info = userMapper.checkPhoneUnique(user.getPhonenumber());
  162. if (StringUtils.isNotNull(info) && info.getUserId() != userId) {
  163. return UserConstants.NOT_UNIQUE;
  164. }
  165. return UserConstants.UNIQUE;
  166. }
  167. /**
  168. * 校验email是否唯一
  169. *
  170. * @param user 用户信息
  171. */
  172. @Override
  173. public String checkEmailUnique(SysUser user) {
  174. long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
  175. SysUser info = userMapper.checkEmailUnique(user.getEmail());
  176. if (StringUtils.isNotNull(info) && info.getUserId() != userId) {
  177. return UserConstants.NOT_UNIQUE;
  178. }
  179. return UserConstants.UNIQUE;
  180. }
  181. /**
  182. * 校验用户是否允许操作
  183. *
  184. * @param user 用户信息
  185. */
  186. @Override
  187. public void checkUserAllowed(SysUser user) {
  188. if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) {
  189. throw new ServiceException("不允许操作超级管理员用户");
  190. }
  191. }
  192. /**
  193. * 校验用户是否有数据权限
  194. *
  195. * @param userId 用户id
  196. */
  197. @Override
  198. public void checkUserDataScope(Long userId) {
  199. if (!SysUser.isAdmin(SecurityUtils.getUserId())) {
  200. SysUser user = new SysUser();
  201. user.setUserId(userId);
  202. List<SysUser> users = SpringUtils.getAopProxy(this).selectUserList(user);
  203. if (StringUtils.isEmpty(users)) {
  204. throw new ServiceException("没有权限访问用户数据!");
  205. }
  206. }
  207. }
  208. /**
  209. * 新增保存用户信息
  210. *
  211. * @param user 用户信息
  212. * @return 结果
  213. */
  214. @Override
  215. @Transactional
  216. public int insertUser(SysUser user) {
  217. // 新增用户信息
  218. int rows = userMapper.insertUser(user);
  219. // 新增用户岗位关联
  220. insertUserPost(user);
  221. // 新增用户与角色管理
  222. insertUserRole(user);
  223. return rows;
  224. }
  225. /**
  226. * 注册用户信息
  227. *
  228. * @param user 用户信息
  229. * @return 结果
  230. */
  231. @Override
  232. public boolean registerUser(SysUser user) {
  233. return userMapper.insertUser(user) > 0;
  234. }
  235. /**
  236. * 修改保存用户信息
  237. *
  238. * @param user 用户信息
  239. * @return 结果
  240. */
  241. @Override
  242. @Transactional
  243. public int updateUser(SysUser user) {
  244. Long userId = user.getUserId();
  245. // 删除用户与角色关联
  246. userRoleMapper.deleteUserRoleByUserId(userId);
  247. // 新增用户与角色管理
  248. insertUserRole(user);
  249. // 删除用户与岗位关联
  250. userPostMapper.deleteUserPostByUserId(userId);
  251. // 新增用户与岗位管理
  252. insertUserPost(user);
  253. return userMapper.updateUser(user);
  254. }
  255. /**
  256. * 用户授权角色
  257. *
  258. * @param userId 用户ID
  259. * @param roleIds 角色组
  260. */
  261. @Override
  262. @Transactional
  263. public void insertUserAuth(Long userId, Long[] roleIds) {
  264. userRoleMapper.deleteUserRoleByUserId(userId);
  265. insertUserRole(userId, roleIds);
  266. }
  267. /**
  268. * 修改用户状态
  269. *
  270. * @param user 用户信息
  271. * @return 结果
  272. */
  273. @Override
  274. public int updateUserStatus(SysUser user) {
  275. return userMapper.updateUser(user);
  276. }
  277. /**
  278. * 修改用户基本信息
  279. *
  280. * @param user 用户信息
  281. * @return 结果
  282. */
  283. @Override
  284. public int updateUserProfile(SysUser user) {
  285. return userMapper.updateUser(user);
  286. }
  287. /**
  288. * 修改用户头像
  289. *
  290. * @param userName 用户名
  291. * @param avatar 头像地址
  292. * @return 结果
  293. */
  294. @Override
  295. public boolean updateUserAvatar(String userName, String avatar) {
  296. return userMapper.updateUserAvatar(userName, avatar) > 0;
  297. }
  298. /**
  299. * 重置用户密码
  300. *
  301. * @param user 用户信息
  302. * @return 结果
  303. */
  304. @Override
  305. public int resetPwd(SysUser user) {
  306. return userMapper.updateUser(user);
  307. }
  308. /**
  309. * 重置用户密码
  310. *
  311. * @param userName 用户名
  312. * @param password 密码
  313. * @return 结果
  314. */
  315. @Override
  316. public int resetUserPwd(String userName, String password) {
  317. return userMapper.resetUserPwd(userName, password);
  318. }
  319. /**
  320. * 新增用户角色信息
  321. *
  322. * @param user 用户对象
  323. */
  324. public void insertUserRole(SysUser user) {
  325. Long[] roles = user.getRoleIds();
  326. if (StringUtils.isNotNull(roles)) {
  327. // 新增用户与角色管理
  328. List<SysUserRole> list = new ArrayList<>();
  329. for (Long roleId : roles) {
  330. SysUserRole ur = new SysUserRole();
  331. ur.setUserId(user.getUserId());
  332. ur.setRoleId(roleId);
  333. list.add(ur);
  334. }
  335. if (list.size() > 0) {
  336. userRoleMapper.batchUserRole(list);
  337. }
  338. }
  339. }
  340. /**
  341. * 新增用户岗位信息
  342. *
  343. * @param user 用户对象
  344. */
  345. public void insertUserPost(SysUser user) {
  346. Long[] posts = user.getPostIds();
  347. if (StringUtils.isNotNull(posts)) {
  348. // 新增用户与岗位管理
  349. List<SysUserPost> list = new ArrayList<>();
  350. for (Long postId : posts) {
  351. SysUserPost up = new SysUserPost();
  352. up.setUserId(user.getUserId());
  353. up.setPostId(postId);
  354. list.add(up);
  355. }
  356. if (list.size() > 0) {
  357. userPostMapper.batchUserPost(list);
  358. }
  359. }
  360. }
  361. /**
  362. * 新增用户角色信息
  363. *
  364. * @param userId 用户ID
  365. * @param roleIds 角色组
  366. */
  367. public void insertUserRole(Long userId, Long[] roleIds) {
  368. if (StringUtils.isNotNull(roleIds)) {
  369. // 新增用户与角色管理
  370. List<SysUserRole> userRoleList = new ArrayList<>(roleIds.length);
  371. for (Long roleId : roleIds) {
  372. SysUserRole ur = new SysUserRole();
  373. ur.setUserId(userId);
  374. ur.setRoleId(roleId);
  375. userRoleList.add(ur);
  376. }
  377. if (userRoleList.size() > 0) {
  378. userRoleMapper.batchUserRole(userRoleList);
  379. }
  380. }
  381. }
  382. /**
  383. * 通过用户ID删除用户
  384. *
  385. * @param userId 用户ID
  386. * @return 结果
  387. */
  388. @Override
  389. @Transactional
  390. public int deleteUserById(Long userId) {
  391. // 删除用户与角色关联
  392. userRoleMapper.deleteUserRoleByUserId(userId);
  393. // 删除用户与岗位表
  394. userPostMapper.deleteUserPostByUserId(userId);
  395. return userMapper.deleteUserById(userId);
  396. }
  397. /**
  398. * 批量删除用户信息
  399. *
  400. * @param userIds 需要删除的用户ID
  401. * @return 结果
  402. */
  403. @Override
  404. @Transactional
  405. public int deleteUserByIds(Long[] userIds) {
  406. for (Long userId : userIds) {
  407. checkUserAllowed(new SysUser(userId));
  408. }
  409. // 删除用户与角色关联
  410. userRoleMapper.deleteUserRole(userIds);
  411. // 删除用户与岗位关联
  412. userPostMapper.deleteUserPost(userIds);
  413. return userMapper.deleteUserByIds(userIds);
  414. }
  415. /**
  416. * 导入用户数据
  417. *
  418. * @param userList 用户数据列表
  419. * @param isUpdateSupport 是否更新支持,如果已存在,则进行更新数据
  420. * @param operName 操作用户
  421. * @return 结果
  422. */
  423. @Override
  424. public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName) {
  425. if (StringUtils.isNull(userList) || userList.size() == 0) {
  426. throw new ServiceException("导入用户数据不能为空!");
  427. }
  428. int successNum = 0;
  429. int failureNum = 0;
  430. StringBuilder successMsg = new StringBuilder();
  431. StringBuilder failureMsg = new StringBuilder();
  432. String password = configService.selectConfigByKey("sys.user.initPassword");
  433. for (SysUser user : userList) {
  434. try {
  435. // 验证是否存在这个用户
  436. SysUser u = userMapper.selectUserByUserName(user.getUserName());
  437. if (StringUtils.isNull(u)) {
  438. user.setPassword(SecurityUtils.encryptPassword(password));
  439. user.setCreateBy(operName);
  440. this.insertUser(user);
  441. successNum++;
  442. successMsg.append("<br/>").append(successNum).append("、账号 ").append(user.getUserName())
  443. .append(" 导入成功");
  444. } else if (isUpdateSupport) {
  445. user.setUpdateBy(operName);
  446. this.updateUser(user);
  447. successNum++;
  448. successMsg.append("<br/>").append(successNum).append("、账号 ").append(user.getUserName())
  449. .append(" 更新成功");
  450. } else {
  451. failureNum++;
  452. failureMsg.append("<br/>").append(failureNum).append("、账号 ").append(user.getUserName())
  453. .append(" 已存在");
  454. }
  455. } catch (Exception e) {
  456. failureNum++;
  457. String msg = "<br/>" + failureNum + "、账号 " + user.getUserName() + " 导入失败:";
  458. failureMsg.append(msg).append(e.getMessage());
  459. log.error(msg, e);
  460. }
  461. }
  462. if (failureNum > 0) {
  463. failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:");
  464. throw new ServiceException(failureMsg.toString());
  465. } else {
  466. successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:");
  467. }
  468. return successMsg.toString();
  469. }
  470. }