From 23855599412c4d61b38d78f0f3abd3430a48b5b1 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 25 六月 2025 11:51:38 +0800
Subject: [PATCH] Merge branch 'mdc_hyjs_master'
---
lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 51 insertions(+), 0 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
new file mode 100644
index 0000000..15f8bb8
--- /dev/null
+++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
@@ -0,0 +1,51 @@
+package org.jeecg.modules.system.mapper;
+
+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 java.util.List;
+
+/**
+ * <p>
+ * 鐢ㄦ埛瑙掕壊琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @Author scott
+ * @since 2018-12-21
+ */
+public interface SysUserRoleMapper extends BaseMapper<SysUserRole> {
+
+ /**
+ * 閫氳繃鐢ㄦ埛璐﹀彿鏌ヨ瑙掕壊闆嗗悎
+ * @param username 鐢ㄦ埛璐﹀彿鍚嶇О
+ * @return List<String>
+ */
+ @Select("select role_code 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> getRoleByUserName(@Param("username") String username);
+
+ /**
+ * 閫氳繃鐢ㄦ埛璐﹀彿鏌ヨ瑙掕壊Id闆嗗悎
+ * @param username 鐢ㄦ埛璐﹀彿鍚嶇О
+ * @return List<String>
+ */
+ @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