-- ============================================= -- MES 生产基础数据:物料BOM维护 / 工序管理 / 工艺路线 菜单与权限 -- 背景:MPS 辅料明细、工单辅料预览按 BOM 展开计算,但维护入口未挂菜单: -- 1) 物料BOM维护 → MES 物料页(含「BOM 组成」页签),维护产品 BOM(mes_md_product_bom) -- 2) 工序管理 → 维护生产工序(mes_pro_process),工艺路线必须挂工序 -- 3) 工艺路线 → 维护路线、产出产品、工序投料(mes_pro_route_*),路线投料优先于产品 BOM -- 可重复执行,不包含 tenant_id(项目不使用多租户) -- ============================================= START TRANSACTION; -- ============================================= -- 0. 目录:生产基础数据(不存在时补建,挂在 生产管控 下) -- ============================================= SET @prod_root = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '生产管控' AND parent_id = 0 LIMIT 1); SET @base_dir = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '生产基础数据' AND parent_id = @prod_root LIMIT 1); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '生产基础数据', '', 1, 1, @prod_root, 'md', 'ep:data-analysis', NULL, NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @prod_root IS NOT NULL AND @base_dir IS NULL; SET @base_dir = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '生产基础数据' AND parent_id = @prod_root LIMIT 1); -- 目录此前可能是隐藏状态(visible=0)或停用状态(status<>0),会导致子菜单在侧边栏完全不显示,统一置为显示、启用 UPDATE system_menu SET visible = b'1', status = 0, updater = '1', update_time = NOW() WHERE deleted = b'0' AND id = @base_dir AND (visible = b'0' OR status <> 0); -- ============================================= -- 1. 页面菜单 -- ============================================= -- 1.1 物料BOM维护(MES 物料页,编辑弹窗内含「BOM 组成」页签) 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '物料BOM维护', '', 2, 1, @base_dir, 'item-bom', 'ep:box', 'mes/md/item/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @base_dir IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/md/item/index'); -- 1.2 工序管理 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工序管理', '', 2, 2, @base_dir, 'process', 'ep:operation', 'mes/pro/process/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @base_dir IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/process/index'); -- 1.3 工艺路线(含产出产品、工序、工序投料) 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线', '', 2, 3, @base_dir, 'route', 'ep:guide', 'mes/pro/route/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @base_dir IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/route/index'); SET @page_item = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/md/item/index' ORDER BY id LIMIT 1); SET @page_process = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/process/index' ORDER BY id LIMIT 1); SET @page_route = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/route/index' ORDER BY id LIMIT 1); -- ============================================= -- 2. 按钮权限 -- ============================================= -- 2.1 物料BOM维护(BOM 组成的增删改与物料导出共用 mes:md-item:* 权限码) 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '物料BOM-新增', 'mes:md-item:create', 3, 1, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_item IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item: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) SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '物料BOM-编辑', 'mes:md-item:update', 3, 2, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_item IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:update'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '物料BOM-删除', 'mes:md-item:delete', 3, 3, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_item IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:delete'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '物料BOM-导出', 'mes:md-item:export', 3, 4, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_item IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:export'); -- 2.2 工序管理 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工序-新增', 'mes:pro-process:create', 3, 1, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_process IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process: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) SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工序-编辑', 'mes:pro-process:update', 3, 2, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_process IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:update'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工序-删除', 'mes:pro-process:delete', 3, 3, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_process IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:delete'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工序-导出', 'mes:pro-process:export', 3, 4, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_process IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:export'); -- 2.3 工艺路线(产品、工序、工序投料的新增/修改统一使用 mes:pro-route:update) 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线-新增', 'mes:pro-route:create', 3, 1, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_route IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route: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) SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线-编辑', 'mes:pro-route:update', 3, 2, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_route IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:update'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线-删除', 'mes:pro-route:delete', 3, 3, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_route IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:delete'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线-导出', 'mes:pro-route:export', 3, 4, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_route IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:export'); 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 (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '工艺路线-导入', 'mes:pro-route:import', 3, 5, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE @page_route IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:import'); -- ============================================= -- 3. 授权 -- 生产管理员(SC)、经理(JL):全部 -- 生产员(SCY):查看 + 编辑/导出(不授予新增、删除、导入) -- ============================================= INSERT INTO system_role_menu(role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0' FROM system_role r JOIN system_menu m ON m.deleted = b'0' AND ( m.id = @base_dir OR m.parent_id IN (@page_item, @page_process, @page_route) OR m.id IN (@page_item, @page_process, @page_route)) -- 新增/删除/导入属于管理动作,生产员不授予(见下方单独授权段) AND COALESCE(m.permission, '') NOT IN ('mes:md-item:create', 'mes:md-item:delete', 'mes:pro-process:create', 'mes:pro-process:delete', 'mes:pro-route:create', 'mes:pro-route:delete', 'mes:pro-route:import') WHERE r.deleted = b'0' AND r.code IN ('SC', 'SCY', 'JL') AND NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id = r.id AND rm.menu_id = m.id AND rm.deleted = b'0'); INSERT INTO system_role_menu(role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0' FROM system_role r JOIN system_menu m ON m.deleted = b'0' AND m.permission IN ('mes:md-item:create', 'mes:md-item:delete', 'mes:pro-process:create', 'mes:pro-process:delete', 'mes:pro-route:create', 'mes:pro-route:delete', 'mes:pro-route:import') WHERE r.deleted = b'0' AND r.code IN ('SC', 'JL') AND NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id = r.id AND rm.menu_id = m.id AND rm.deleted = b'0'); COMMIT;