1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| -- 工艺路线导入权限：普通导入和完整路线批量导入共用 mes:pro-route:import。
| -- 优先挂到“工艺设计 / 工艺路线”菜单；若目标库只有生产模块旧菜单，则挂到旧菜单。
| -- 可重复执行；仅自动授权超级管理员角色，其他角色请在角色管理中按需勾选。
|
| SET @route_menu_id := COALESCE(
| (SELECT id FROM system_menu
| WHERE component LIKE '%process-design/route%' AND type = 2 AND deleted = 0
| ORDER BY id LIMIT 1),
| (SELECT id FROM system_menu
| WHERE component LIKE '%mes/pro/route/index%' AND type = 2 AND deleted = 0
| ORDER BY id LIMIT 1)
| );
|
| SET @import_menu_id := (
| SELECT id FROM system_menu
| WHERE permission = 'mes:pro-route:import' AND deleted = 0
| ORDER BY id LIMIT 1
| );
| SET @new_menu_id := (SELECT COALESCE(MAX(id), 0) + 1 FROM system_menu);
|
| 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)
| SELECT @new_menu_id,
| '工艺路线导入', 'mes:pro-route:import', 3, 6, @route_menu_id,
| '', '#', '', NULL, 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0
| FROM DUAL
| WHERE @route_menu_id IS NOT NULL AND @import_menu_id IS NULL;
|
| SET @import_menu_id := (
| SELECT id FROM system_menu
| WHERE permission = 'mes:pro-route:import' AND deleted = 0
| ORDER BY id LIMIT 1
| );
|
| INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted, tenant_id)
| SELECT r.id, @import_menu_id, '1', NOW(), '1', NOW(), 0, r.tenant_id
| FROM system_role r
| WHERE r.id = 1 AND r.deleted = 0 AND @import_menu_id IS NOT NULL
| AND NOT EXISTS (
| SELECT 1 FROM system_role_menu
| WHERE role_id = r.id AND menu_id = @import_menu_id
| AND tenant_id = r.tenant_id AND deleted = 0
| );
|
|
