From f8ab5663ef7220f8adc0fd8fcbd7d0cf84c6d77d Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期一, 02 八月 2021 12:15:14 +0800 Subject: [PATCH] update 日常字符串校验 统一重构到 StringUtils 便于维护扩展 --- ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysRoleServiceImpl.java | 133 ++++++++++++++++++++++++++++++++++++-------- 1 files changed, 108 insertions(+), 25 deletions(-) diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysRoleServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysRoleServiceImpl.java index e2691ab..70a33ee 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysRoleServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysRoleServiceImpl.java @@ -1,14 +1,18 @@ package com.ruoyi.system.service.impl; import cn.hutool.core.lang.Validator; -import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.ruoyi.common.annotation.DataScope; import com.ruoyi.common.constant.UserConstants; import com.ruoyi.common.core.domain.entity.SysRole; +import com.ruoyi.common.core.mybatisplus.core.ServicePlusImpl; +import com.ruoyi.common.core.page.TableDataInfo; import com.ruoyi.common.exception.CustomException; +import com.ruoyi.common.utils.PageUtils; import com.ruoyi.common.utils.spring.SpringUtils; import com.ruoyi.system.domain.SysRoleDept; import com.ruoyi.system.domain.SysRoleMenu; +import com.ruoyi.system.domain.SysUserRole; import com.ruoyi.system.mapper.SysRoleDeptMapper; import com.ruoyi.system.mapper.SysRoleMapper; import com.ruoyi.system.mapper.SysRoleMenuMapper; @@ -26,9 +30,7 @@ * @author ruoyi */ @Service -public class SysRoleServiceImpl extends ServiceImpl<SysRoleMapper, SysRole> implements ISysRoleService { - @Autowired - private SysRoleMapper roleMapper; +public class SysRoleServiceImpl extends ServicePlusImpl<SysRoleMapper, SysRole, SysRole> implements ISysRoleService { @Autowired private SysRoleMenuMapper roleMenuMapper; @@ -39,6 +41,12 @@ @Autowired private SysRoleDeptMapper roleDeptMapper; + @Override + @DataScope(deptAlias = "d") + public TableDataInfo<SysRole> selectPageRoleList(SysRole role) { + return PageUtils.buildDataInfo(baseMapper.selectPageRoleList(PageUtils.buildPage(), role)); + } + /** * 鏍规嵁鏉′欢鍒嗛〉鏌ヨ瑙掕壊鏁版嵁 * @@ -48,7 +56,28 @@ @Override @DataScope(deptAlias = "d") public List<SysRole> selectRoleList(SysRole role) { - return roleMapper.selectRoleList(role); + return baseMapper.selectRoleList(role); + } + + /** + * 鏍规嵁鐢ㄦ埛ID鏌ヨ瑙掕壊 + * + * @param userId 鐢ㄦ埛ID + * @return 瑙掕壊鍒楄〃 + */ + @Override + public List<SysRole> selectRolesByUserId(Long userId) { + List<SysRole> userRoles = baseMapper.selectRolePermissionByUserId(userId); + List<SysRole> roles = selectRoleAll(); + for (SysRole role : roles) { + for (SysRole userRole : userRoles) { + if (role.getRoleId().longValue() == userRole.getRoleId().longValue()) { + role.setFlag(true); + break; + } + } + } + return roles; } /** @@ -59,7 +88,7 @@ */ @Override public Set<String> selectRolePermissionByUserId(Long userId) { - List<SysRole> perms = roleMapper.selectRolePermissionByUserId(userId); + List<SysRole> perms = baseMapper.selectRolePermissionByUserId(userId); Set<String> permsSet = new HashSet<>(); for (SysRole perm : perms) { if (Validator.isNotNull(perm)) { @@ -87,7 +116,7 @@ */ @Override public List<Integer> selectRoleListByUserId(Long userId) { - return roleMapper.selectRoleListByUserId(userId); + return baseMapper.selectRoleListByUserId(userId); } /** @@ -98,7 +127,7 @@ */ @Override public SysRole selectRoleById(Long roleId) { - return roleMapper.selectRoleById(roleId); + return getById(roleId); } /** @@ -110,7 +139,8 @@ @Override public String checkRoleNameUnique(SysRole role) { Long roleId = Validator.isNull(role.getRoleId()) ? -1L : role.getRoleId(); - SysRole info = roleMapper.checkRoleNameUnique(role.getRoleName()); + SysRole info = getOne(new LambdaQueryWrapper<SysRole>() + .eq(SysRole::getRoleName, role.getRoleName()).last("limit 1")); if (Validator.isNotNull(info) && info.getRoleId().longValue() != roleId.longValue()) { return UserConstants.NOT_UNIQUE; } @@ -126,7 +156,8 @@ @Override public String checkRoleKeyUnique(SysRole role) { Long roleId = Validator.isNull(role.getRoleId()) ? -1L : role.getRoleId(); - SysRole info = roleMapper.checkRoleKeyUnique(role.getRoleKey()); + SysRole info = getOne(new LambdaQueryWrapper<SysRole>() + .eq(SysRole::getRoleKey, role.getRoleKey()).last("limit 1")); if (Validator.isNotNull(info) && info.getRoleId().longValue() != roleId.longValue()) { return UserConstants.NOT_UNIQUE; } @@ -153,7 +184,7 @@ */ @Override public int countUserRoleByRoleId(Long roleId) { - return userRoleMapper.countUserRoleByRoleId(roleId); + return userRoleMapper.selectCount(new LambdaQueryWrapper<SysUserRole>().eq(SysUserRole::getRoleId, roleId)); } /** @@ -166,7 +197,7 @@ @Transactional public int insertRole(SysRole role) { // 鏂板瑙掕壊淇℃伅 - roleMapper.insertRole(role); + baseMapper.insert(role); return insertRoleMenu(role); } @@ -180,9 +211,9 @@ @Transactional public int updateRole(SysRole role) { // 淇敼瑙掕壊淇℃伅 - roleMapper.updateRole(role); + baseMapper.updateById(role); // 鍒犻櫎瑙掕壊涓庤彍鍗曞叧鑱� - roleMenuMapper.deleteRoleMenuByRoleId(role.getRoleId()); + roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, role.getRoleId())); return insertRoleMenu(role); } @@ -194,7 +225,7 @@ */ @Override public int updateRoleStatus(SysRole role) { - return roleMapper.updateRole(role); + return baseMapper.updateById(role); } /** @@ -207,9 +238,9 @@ @Transactional public int authDataScope(SysRole role) { // 淇敼瑙掕壊淇℃伅 - roleMapper.updateRole(role); + baseMapper.updateById(role); // 鍒犻櫎瑙掕壊涓庨儴闂ㄥ叧鑱� - roleDeptMapper.deleteRoleDeptByRoleId(role.getRoleId()); + roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().eq(SysRoleDept::getRoleId, role.getRoleId())); // 鏂板瑙掕壊鍜岄儴闂ㄤ俊鎭紙鏁版嵁鏉冮檺锛� return insertRoleDept(role); } @@ -230,7 +261,7 @@ list.add(rm); } if (list.size() > 0) { - rows = roleMenuMapper.batchRoleMenu(list); + rows = roleMenuMapper.insertAll(list); } return rows; } @@ -251,7 +282,7 @@ list.add(rd); } if (list.size() > 0) { - rows = roleDeptMapper.batchRoleDept(list); + rows = roleDeptMapper.insertAll(list); } return rows; } @@ -266,10 +297,10 @@ @Transactional public int deleteRoleById(Long roleId) { // 鍒犻櫎瑙掕壊涓庤彍鍗曞叧鑱� - roleMenuMapper.deleteRoleMenuByRoleId(roleId); + roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, roleId)); // 鍒犻櫎瑙掕壊涓庨儴闂ㄥ叧鑱� - roleDeptMapper.deleteRoleDeptByRoleId(roleId); - return roleMapper.deleteRoleById(roleId); + roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().eq(SysRoleDept::getRoleId, roleId)); + return baseMapper.deleteById(roleId); } /** @@ -288,10 +319,62 @@ throw new CustomException(String.format("%1$s宸插垎閰�,涓嶈兘鍒犻櫎", role.getRoleName())); } } + List<Long> ids = Arrays.asList(roleIds); // 鍒犻櫎瑙掕壊涓庤彍鍗曞叧鑱� - roleMenuMapper.deleteRoleMenu(roleIds); + roleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().in(SysRoleMenu::getRoleId, ids)); // 鍒犻櫎瑙掕壊涓庨儴闂ㄥ叧鑱� - roleDeptMapper.deleteRoleDept(roleIds); - return roleMapper.deleteRoleByIds(roleIds); + roleDeptMapper.delete(new LambdaQueryWrapper<SysRoleDept>().in(SysRoleDept::getRoleId, ids)); + return baseMapper.deleteBatchIds(ids); + } + + /** + * 鍙栨秷鎺堟潈鐢ㄦ埛瑙掕壊 + * + * @param userRole 鐢ㄦ埛鍜岃鑹插叧鑱斾俊鎭� + * @return 缁撴灉 + */ + @Override + public int deleteAuthUser(SysUserRole userRole) { + return userRoleMapper.delete(new LambdaQueryWrapper<SysUserRole>() + .eq(SysUserRole::getRoleId, userRole.getRoleId()) + .eq(SysUserRole::getUserId, userRole.getUserId())); + } + + /** + * 鎵归噺鍙栨秷鎺堟潈鐢ㄦ埛瑙掕壊 + * + * @param roleId 瑙掕壊ID + * @param userIds 闇�瑕佸彇娑堟巿鏉冪殑鐢ㄦ埛鏁版嵁ID + * @return 缁撴灉 + */ + @Override + public int deleteAuthUsers(Long roleId, Long[] userIds) { + return userRoleMapper.delete(new LambdaQueryWrapper<SysUserRole>() + .eq(SysUserRole::getRoleId, roleId) + .in(SysUserRole::getUserId, Arrays.asList(userIds))); + } + + /** + * 鎵归噺閫夋嫨鎺堟潈鐢ㄦ埛瑙掕壊 + * + * @param roleId 瑙掕壊ID + * @param userIds 闇�瑕佸垹闄ょ殑鐢ㄦ埛鏁版嵁ID + * @return 缁撴灉 + */ + @Override + public int insertAuthUsers(Long roleId, Long[] userIds) { + // 鏂板鐢ㄦ埛涓庤鑹茬鐞� + int rows = 1; + List<SysUserRole> list = new ArrayList<SysUserRole>(); + for (Long userId : userIds) { + SysUserRole ur = new SysUserRole(); + ur.setUserId(userId); + ur.setRoleId(roleId); + list.add(ur); + } + if (list.size() > 0) { + rows = userRoleMapper.insertAll(list); + } + return rows; } } -- Gitblit v1.9.3