SysUserServiceImpl.java 18 KB

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