admin/fix_role_menus.sql
lvfengfree b92e1119ae fix: 修复菜单为空问题 - 移除后端过滤home路由的错误逻辑
- 修复RouteService中错误过滤home路由的问题
- 后端现在正确返回所有用户有权限的路由
- 添加设备管理相关功能(列表、在线监控、电源管理、远程监控)
- 添加详细的修复文档和重启脚本
- 更新权限配置脚本

问题根源:后端代码中有逻辑会过滤掉home路由,导致前端收到空数组,无法生成菜单
解决方案:移除过滤home路由的逻辑,让后端返回所有有权限的路由
2026-03-01 09:50:19 +08:00

18 lines
670 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- 修复角色菜单配置
-- 问题R_USER 和 R_STU 的菜单名称格式错误
-- 修复 R_USER 角色的菜单配置(使用连字符而不是下划线)
UPDATE sys_role
SET menus = 'my-device,my-device_status,my-device_remote-control,my-device_power-control,my-application,my-application_apply,my-application_my-list'
WHERE role_code = 'R_USER';
-- 修复 R_STU 角色的菜单配置(添加实际可访问的菜单)
UPDATE sys_role
SET menus = 'my-device,my-device_status,my-application,my-application_my-list'
WHERE role_code = 'R_STU';
-- 验证修复结果
SELECT role_code, role_name, menus
FROM sys_role
WHERE role_code IN ('R_USER', 'R_STU');