SysRoleServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412
  1. package com.ruoyi.system.service.impl;
  2. import cn.hutool.core.collection.CollUtil;
  3. import cn.hutool.core.util.ObjectUtil;
  4. import com.baomidou.mybatisplus.core.conditions.Wrapper;
  5. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  6. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  7. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
  8. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  9. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  10. import com.ruoyi.common.constant.UserConstants;
  11. import com.ruoyi.common.core.domain.PageQuery;
  12. import com.ruoyi.common.core.domain.entity.SysRole;
  13. import com.ruoyi.common.core.page.TableDataInfo;
  14. import com.ruoyi.common.exception.ServiceException;
  15. import com.ruoyi.common.helper.LoginHelper;
  16. import com.ruoyi.system.domain.SysRoleDept;
  17. import com.ruoyi.system.domain.SysRoleMenu;
  18. import com.ruoyi.system.domain.SysUserRole;
  19. import com.ruoyi.system.mapper.SysRoleDeptMapper;
  20. import com.ruoyi.system.mapper.SysRoleMapper;
  21. import com.ruoyi.system.mapper.SysRoleMenuMapper;
  22. import com.ruoyi.system.mapper.SysUserRoleMapper;
  23. import com.ruoyi.system.service.ISysRoleService;
  24. import lombok.RequiredArgsConstructor;
  25. import org.springframework.stereotype.Service;
  26. import org.springframework.transaction.annotation.Transactional;
  27. import java.util.*;
  28. /**
  29. * 角色 业务层处理
  30. *
  31. * @author Lion Li
  32. */
  33. @RequiredArgsConstructor
  34. @Service
  35. public class SysRoleServiceImpl implements ISysRoleService {
  36. private final SysRoleMapper baseMapper;
  37. private final SysRoleMenuMapper roleMenuMapper;
  38. private final SysUserRoleMapper userRoleMapper;
  39. private final SysRoleDeptMapper roleDeptMapper;
  40. @Override
  41. public TableDataInfo<SysRole> selectPageRoleList(SysRole role, PageQuery pageQuery) {
  42. Page<SysRole> page = baseMapper.selectPageRoleList(pageQuery.build(), this.buildQueryWrapper(role));
  43. return TableDataInfo.build(page);
  44. }
  45. /**
  46. * 根据条件分页查询角色数据
  47. *
  48. * @param role 角色信息
  49. * @return 角色数据集合信息
  50. */
  51. @Override
  52. public List<SysRole> selectRoleList(SysRole role) {
  53. return baseMapper.selectRoleList(this.buildQueryWrapper(role));
  54. }
  55. private Wrapper<SysRole> buildQueryWrapper(SysRole role) {
  56. Map<String, Object> params = role.getParams();
  57. QueryWrapper<SysRole> wrapper = Wrappers.query();
  58. wrapper.eq("r.del_flag", UserConstants.ROLE_NORMAL)
  59. .eq(ObjectUtil.isNotNull(role.getRoleId()), "r.role_id", role.getRoleId())
  60. .like(StringUtils.isNotBlank(role.getRoleName()), "r.role_name", role.getRoleName())
  61. .eq(StringUtils.isNotBlank(role.getStatus()), "r.status", role.getStatus())
  62. .like(StringUtils.isNotBlank(role.getRoleKey()), "r.role_key", role.getRoleKey())
  63. .between(params.get("beginTime") != null && params.get("endTime") != null,
  64. "r.create_time", params.get("beginTime"), params.get("endTime"))
  65. .orderByAsc("r.role_sort");
  66. return wrapper;
  67. }
  68. /**
  69. * 根据用户ID查询角色
  70. *
  71. * @param userId 用户ID
  72. * @return 角色列表
  73. */
  74. @Override
  75. public List<SysRole> selectRolesByUserId(Long userId) {
  76. List<SysRole> userRoles = baseMapper.selectRolePermissionByUserId(userId);
  77. List<SysRole> roles = selectRoleAll();
  78. for (SysRole role : roles) {
  79. for (SysRole userRole : userRoles) {
  80. if (role.getRoleId().longValue() == userRole.getRoleId().longValue()) {
  81. role.setFlag(true);
  82. break;
  83. }
  84. }
  85. }
  86. return roles;
  87. }
  88. /**
  89. * 根据用户ID查询权限
  90. *
  91. * @param userId 用户ID
  92. * @return 权限列表
  93. */
  94. @Override
  95. public Set<String> selectRolePermissionByUserId(Long userId) {
  96. List<SysRole> perms = baseMapper.selectRolePermissionByUserId(userId);
  97. Set<String> permsSet = new HashSet<>();
  98. for (SysRole perm : perms) {
  99. if (ObjectUtil.isNotNull(perm)) {
  100. permsSet.addAll(Arrays.asList(perm.getRoleKey().trim().split(",")));
  101. }
  102. }
  103. return permsSet;
  104. }
  105. /**
  106. * 查询所有角色
  107. *
  108. * @return 角色列表
  109. */
  110. @Override
  111. public List<SysRole> selectRoleAll() {
  112. return this.selectRoleList(new SysRole());
  113. }
  114. /**
  115. * 根据用户ID获取角色选择框列表
  116. *
  117. * @param userId 用户ID
  118. * @return 选中角色ID列表
  119. */
  120. @Override
  121. public List<Long> selectRoleListByUserId(Long userId) {
  122. return baseMapper.selectRoleListByUserId(userId);
  123. }
  124. /**
  125. * 通过角色ID查询角色
  126. *
  127. * @param roleId 角色ID
  128. * @return 角色对象信息
  129. */
  130. @Override
  131. public SysRole selectRoleById(Long roleId) {
  132. return baseMapper.selectById(roleId);
  133. }
  134. /**
  135. * 校验角色名称是否唯一
  136. *
  137. * @param role 角色信息
  138. * @return 结果
  139. */
  140. @Override
  141. public String checkRoleNameUnique(SysRole role) {
  142. boolean exist = baseMapper.exists(new LambdaQueryWrapper<SysRole>()
  143. .eq(SysRole::getRoleName, role.getRoleName())
  144. .ne(ObjectUtil.isNotNull(role.getRoleId()), SysRole::getRoleId, role.getRoleId()));
  145. if (exist) {
  146. return UserConstants.NOT_UNIQUE;
  147. }
  148. return UserConstants.UNIQUE;
  149. }
  150. /**
  151. * 校验角色权限是否唯一
  152. *
  153. * @param role 角色信息
  154. * @return 结果
  155. */
  156. @Override
  157. public String checkRoleKeyUnique(SysRole role) {
  158. boolean exist = baseMapper.exists(new LambdaQueryWrapper<SysRole>()
  159. .eq(SysRole::getRoleKey, role.getRoleKey())
  160. .ne(ObjectUtil.isNotNull(role.getRoleId()), SysRole::getRoleId, role.getRoleId()));
  161. if (exist) {
  162. return UserConstants.NOT_UNIQUE;
  163. }
  164. return UserConstants.UNIQUE;
  165. }
  166. /**
  167. * 校验角色是否允许操作
  168. *
  169. * @param role 角色信息
  170. */
  171. @Override
  172. public void checkRoleAllowed(SysRole role) {
  173. if (ObjectUtil.isNotNull(role.getRoleId()) && role.isAdmin()) {
  174. throw new ServiceException("不允许操作超级管理员角色");
  175. }
  176. }
  177. /**
  178. * 校验角色是否有数据权限
  179. *
  180. * @param roleId 角色id
  181. */
  182. @Override
  183. public void checkRoleDataScope(Long roleId) {
  184. if (!LoginHelper.isAdmin()) {
  185. SysRole role = new SysRole();
  186. role.setRoleId(roleId);
  187. List<SysRole> roles = this.selectRoleList(role);
  188. if (CollUtil.isEmpty(roles)) {
  189. throw new ServiceException("没有权限访问角色数据!");
  190. }
  191. }
  192. }
  193. /**
  194. * 通过角色ID查询角色使用数量
  195. *
  196. * @param roleId 角色ID
  197. * @return 结果
  198. */
  199. @Override
  200. public long countUserRoleByRoleId(Long roleId) {
  201. return userRoleMapper.selectCount(new LambdaQueryWrapper<SysUserRole>().eq(SysUserRole::getRoleId, roleId));
  202. }
  203. /**
  204. * 新增保存角色信息
  205. *
  206. * @param role 角色信息
  207. * @return 结果
  208. */
  209. @Override
  210. @Transactional(rollbackFor = Exception.class)
  211. public int insertRole(SysRole role) {
  212. // 新增角色信息
  213. baseMapper.insert(role);
  214. return insertRoleMenu(role);
  215. }
  216. /**
  217. * 修改保存角色信息
  218. *
  219. * @param role 角色信息
  220. * @return 结果
  221. */
  222. @Override
  223. @Transactional(rollbackFor = Exception.class)
  224. public int updateRole(SysRole role) {
  225. // 修改角色信息
  226. baseMapper.updateById(role);
  227. // 删除角色与菜单关联
  228. roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, role.getRoleId()));
  229. return insertRoleMenu(role);
  230. }
  231. /**
  232. * 修改角色状态
  233. *
  234. * @param role 角色信息
  235. * @return 结果
  236. */
  237. @Override
  238. public int updateRoleStatus(SysRole role) {
  239. return baseMapper.updateById(role);
  240. }
  241. /**
  242. * 修改数据权限信息
  243. *
  244. * @param role 角色信息
  245. * @return 结果
  246. */
  247. @Override
  248. @Transactional(rollbackFor = Exception.class)
  249. public int authDataScope(SysRole role) {
  250. // 修改角色信息
  251. baseMapper.updateById(role);
  252. // 删除角色与部门关联
  253. roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().eq(SysRoleDept::getRoleId, role.getRoleId()));
  254. // 新增角色和部门信息(数据权限)
  255. return insertRoleDept(role);
  256. }
  257. /**
  258. * 新增角色菜单信息
  259. *
  260. * @param role 角色对象
  261. */
  262. public int insertRoleMenu(SysRole role) {
  263. int rows = 1;
  264. // 新增用户与角色管理
  265. List<SysRoleMenu> list = new ArrayList<SysRoleMenu>();
  266. for (Long menuId : role.getMenuIds()) {
  267. SysRoleMenu rm = new SysRoleMenu();
  268. rm.setRoleId(role.getRoleId());
  269. rm.setMenuId(menuId);
  270. list.add(rm);
  271. }
  272. if (list.size() > 0) {
  273. rows = roleMenuMapper.insertBatch(list) ? list.size() : 0;
  274. }
  275. return rows;
  276. }
  277. /**
  278. * 新增角色部门信息(数据权限)
  279. *
  280. * @param role 角色对象
  281. */
  282. public int insertRoleDept(SysRole role) {
  283. int rows = 1;
  284. // 新增角色与部门(数据权限)管理
  285. List<SysRoleDept> list = new ArrayList<SysRoleDept>();
  286. for (Long deptId : role.getDeptIds()) {
  287. SysRoleDept rd = new SysRoleDept();
  288. rd.setRoleId(role.getRoleId());
  289. rd.setDeptId(deptId);
  290. list.add(rd);
  291. }
  292. if (list.size() > 0) {
  293. rows = roleDeptMapper.insertBatch(list) ? list.size() : 0;
  294. }
  295. return rows;
  296. }
  297. /**
  298. * 通过角色ID删除角色
  299. *
  300. * @param roleId 角色ID
  301. * @return 结果
  302. */
  303. @Override
  304. @Transactional(rollbackFor = Exception.class)
  305. public int deleteRoleById(Long roleId) {
  306. // 删除角色与菜单关联
  307. roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, roleId));
  308. // 删除角色与部门关联
  309. roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().eq(SysRoleDept::getRoleId, roleId));
  310. return baseMapper.deleteById(roleId);
  311. }
  312. /**
  313. * 批量删除角色信息
  314. *
  315. * @param roleIds 需要删除的角色ID
  316. * @return 结果
  317. */
  318. @Override
  319. @Transactional(rollbackFor = Exception.class)
  320. public int deleteRoleByIds(Long[] roleIds) {
  321. for (Long roleId : roleIds) {
  322. checkRoleAllowed(new SysRole(roleId));
  323. checkRoleDataScope(roleId);
  324. SysRole role = selectRoleById(roleId);
  325. if (countUserRoleByRoleId(roleId) > 0) {
  326. throw new ServiceException(String.format("%1$s已分配,不能删除", role.getRoleName()));
  327. }
  328. }
  329. List<Long> ids = Arrays.asList(roleIds);
  330. // 删除角色与菜单关联
  331. roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().in(SysRoleMenu::getRoleId, ids));
  332. // 删除角色与部门关联
  333. roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().in(SysRoleDept::getRoleId, ids));
  334. return baseMapper.deleteBatchIds(ids);
  335. }
  336. /**
  337. * 取消授权用户角色
  338. *
  339. * @param userRole 用户和角色关联信息
  340. * @return 结果
  341. */
  342. @Override
  343. public int deleteAuthUser(SysUserRole userRole) {
  344. return userRoleMapper.delete(new LambdaQueryWrapper<SysUserRole>()
  345. .eq(SysUserRole::getRoleId, userRole.getRoleId())
  346. .eq(SysUserRole::getUserId, userRole.getUserId()));
  347. }
  348. /**
  349. * 批量取消授权用户角色
  350. *
  351. * @param roleId 角色ID
  352. * @param userIds 需要取消授权的用户数据ID
  353. * @return 结果
  354. */
  355. @Override
  356. public int deleteAuthUsers(Long roleId, Long[] userIds) {
  357. return userRoleMapper.delete(new LambdaQueryWrapper<SysUserRole>()
  358. .eq(SysUserRole::getRoleId, roleId)
  359. .in(SysUserRole::getUserId, Arrays.asList(userIds)));
  360. }
  361. /**
  362. * 批量选择授权用户角色
  363. *
  364. * @param roleId 角色ID
  365. * @param userIds 需要授权的用户数据ID
  366. * @return 结果
  367. */
  368. @Override
  369. public int insertAuthUsers(Long roleId, Long[] userIds) {
  370. // 新增用户与角色管理
  371. int rows = 1;
  372. List<SysUserRole> list = new ArrayList<SysUserRole>();
  373. for (Long userId : userIds) {
  374. SysUserRole ur = new SysUserRole();
  375. ur.setUserId(userId);
  376. ur.setRoleId(roleId);
  377. list.add(ur);
  378. }
  379. if (list.size() > 0) {
  380. rows = userRoleMapper.insertBatch(list) ? list.size() : 0;
  381. }
  382. return rows;
  383. }
  384. }