-- 员工合同 - 导入/导入模板 按钮权限 -- 父菜单:员工合同(parent_id = 1063105) -- 参照:合同新增按钮 id=1063107(type=3, permission=hrm:employee-contract:create) INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (1063300, '合同导入', 'hrm:employee-contract:import', 3, 5, 1063105, '', '#', '', NULL, 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0); -- 授予超级管理员角色(role_id=1)该按钮权限(幂等) INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT 1, 1063300, '1', NOW(), '1', NOW(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_role_menu WHERE role_id = 1 AND menu_id = 1063300);