From 5288955200b6e51bc828c2fac0aab3451a8d3ab1 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 29 一月 2024 17:00:27 +0800
Subject: [PATCH] #
---
zy-asrs-wcs/src/main/resources/mapper/sys/RoleMenuMapper.xml | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git a/zy-asrs-wcs/src/main/resources/mapper/sys/RoleMenuMapper.xml b/zy-asrs-wcs/src/main/resources/mapper/sys/RoleMenuMapper.xml
index a69559c..4270e27 100644
--- a/zy-asrs-wcs/src/main/resources/mapper/sys/RoleMenuMapper.xml
+++ b/zy-asrs-wcs/src/main/resources/mapper/sys/RoleMenuMapper.xml
@@ -3,7 +3,21 @@
<mapper namespace="com.zy.asrs.wcs.sys.mapper.RoleMenuMapper">
<select id="listMenuByUserId" resultType="com.zy.asrs.wcs.sys.entity.Menu">
-
+ SELECT a.*
+ FROM sys_menu a
+ <where>
+ AND a.menu_id IN (
+ SELECT menu_id FROM sys_role_menu WHERE role_id IN (
+ SELECT ta.role_id FROM sys_user_role ta LEFT JOIN sys_role tb ON ta.role_id = tb.role_id
+ WHERE ta.user_id = #{userId} AND tb.deleted = 0
+ )
+ )
+ <if test="menuType != null">
+ AND a.menu_type = #{menuType}
+ </if>
+ AND a.deleted = 0
+ </where>
+ ORDER BY a.sort_number
</select>
</mapper>
--
Gitblit v1.9.1