-- 恢复“工序维护”菜单(MySQL,可重复执行)。 -- 若依约定:visible='0' 表示显示,status='0' 表示正常。 -- 1. 恢复菜单本身,并修正前端组件地址。 UPDATE sys_menu SET visible = '0', status = '0', menu_type = 'C', component = 'productionManagement/productionProcess/index', update_by = 'admin', update_time = NOW() WHERE menu_name = '工序维护' OR component = 'productionManagement/productionProcess/index'; -- 2. 确保直接父菜单处于显示、正常状态。 UPDATE sys_menu parent INNER JOIN sys_menu child ON child.parent_id = parent.menu_id SET parent.visible = '0', parent.status = '0', parent.update_by = 'admin', parent.update_time = NOW() WHERE child.menu_name = '工序维护'; -- 3. 给管理员角色补齐菜单关系(已存在时不重复插入)。 INSERT INTO sys_role_menu (role_id, menu_id) SELECT role.role_id, menu.menu_id FROM sys_role role INNER JOIN sys_menu menu ON menu.menu_name = '工序维护' WHERE role.role_key = 'admin' AND NOT EXISTS ( SELECT 1 FROM sys_role_menu relation WHERE relation.role_id = role.role_id AND relation.menu_id = menu.menu_id ); -- 4. 执行后检查菜单、父菜单和角色授权结果。 SELECT menu.menu_id, menu.parent_id, menu.menu_name, menu.path, menu.component, menu.visible, menu.status, parent.menu_name AS parent_name, parent.visible AS parent_visible, parent.status AS parent_status FROM sys_menu menu LEFT JOIN sys_menu parent ON parent.menu_id = menu.parent_id WHERE menu.menu_name = '工序维护'; SELECT role.role_name, role.role_key, relation.menu_id FROM sys_role_menu relation INNER JOIN sys_role role ON role.role_id = relation.role_id INNER JOIN sys_menu menu ON menu.menu_id = relation.menu_id WHERE menu.menu_name = '工序维护';