1
2
3
4
5
6
7
8
9
10
11
12
13
| -- 员工合同 - 导入/导入模板 按钮权限
| -- 父菜单：员工合同（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);
|
|
