1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| -- 依赖 process_knowledge_menu_20261105.sql；菜单 ID 由数据库生成。
| SET @process_parent := (SELECT id FROM system_menu WHERE path = '/process-design' AND parent_id = 0 AND deleted = b'0' LIMIT 1);
| SET @knowledge_menu := (SELECT id FROM system_menu WHERE parent_id = @process_parent AND path = 'knowledge' AND type = 1 AND deleted = b'0' LIMIT 1);
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, updater)
| SELECT '知识维护', '', 2, 0, @knowledge_menu, 'catalog', 'lucide:book-open', 'mes/process-design/knowledge/index', 'MesPdKnowledge', 0, b'1', b'1', b'1', '1', '1'
| WHERE @knowledge_menu IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component = 'mes/process-design/knowledge/index' AND deleted = b'0');
| SET @knowledge_page := (SELECT id FROM system_menu WHERE component = 'mes/process-design/knowledge/index' AND deleted = b'0' LIMIT 1);
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, updater)
| SELECT p.name, p.permission, 3, p.sort_no, @knowledge_page, '', '', 0, b'1', b'1', b'1', '1', '1'
| FROM (SELECT '知识查询' name, 'mes:pd-knowledge:query' permission, 1 sort_no UNION ALL
| SELECT '知识创建', 'mes:pd-knowledge:create', 2 UNION ALL
| SELECT '知识修改', 'mes:pd-knowledge:update', 3 UNION ALL
| SELECT '知识发布', 'mes:pd-knowledge:publish', 4 UNION ALL
| SELECT '知识参考', 'mes:pd-knowledge:reference', 5) p
| WHERE @knowledge_page IS NOT NULL AND NOT EXISTS
| (SELECT 1 FROM system_menu m WHERE m.permission = p.permission AND m.deleted = b'0');
|
| -- 页面与操作权限通过系统角色管理显式分配；不自动扩大已有角色权限。
|
|
