From 4e2be858f4ccbb7490b59ed584fd1c829eb4d556 Mon Sep 17 00:00:00 2001
From: lyh <925863403@qq.com>
Date: 星期二, 01 四月 2025 15:22:47 +0800
Subject: [PATCH] 修改审签问题
---
lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 deletions(-)
diff --git a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
index 5393931..15f8bb8 100644
--- a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
+++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
@@ -1,10 +1,12 @@
package org.jeecg.modules.system.mapper;
-import java.util.List;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
+import org.jeecg.modules.system.entity.SysUser;
import org.jeecg.modules.system.entity.SysUserRole;
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+import java.util.List;
/**
* <p>
@@ -32,4 +34,18 @@
@Select("select id from sys_role where id in (select role_id from sys_user_role where user_id = (select id from sys_user where username=#{username}))")
List<String> getRoleIdByUserName(@Param("username") String username);
+ /**
+ * 鏍规嵁瑙掕壊鏌ヨ鐢ㄦ埛
+ * @param roleList role_code闆嗗悎
+ * */
+ List<SysUser> getUsersByRoles(@Param("roleList") List<String> roleList);
+
+
+ /**
+ * 閫氳繃瑙掕壊id鑾峰彇鐢ㄦ埛username
+ * @param roleId
+ */
+ @Select("select username from sys_user where id in (select user_id from sys_user_role where role_id = #{roleId})")
+ List<String> getUserNameByRoleId(@Param("roleId") String roleId);
+
}
--
Gitblit v1.9.3