-- 依赖既有售后管理目录,所有 ID 由目标库生成;角色权限需在目标系统显式分配。 SET @after_sale_parent := (SELECT id FROM system_menu WHERE path = '/aftersales' AND parent_id = 0 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, 20, @after_sale_parent, 'collaboration', 'lucide:users', 'aftersales/collaboration/index', 'AftersalesCollaboration', 0, b'1', b'1', b'1', '1', '1' WHERE @after_sale_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component = 'aftersales/collaboration/index' AND deleted = b'0'); SET @collaboration_page := (SELECT id FROM system_menu WHERE component = 'aftersales/collaboration/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, @collaboration_page, '', '', 0, b'1', b'1', b'1', '1', '1' FROM (SELECT '协同查询' name, 'aftersales:collaboration:query' permission, 1 sort_no UNION ALL SELECT '协同发起', 'aftersales:collaboration:create', 2 UNION ALL SELECT '协同处理', 'aftersales:collaboration:update', 3 UNION ALL SELECT '业务审核', 'aftersales:collaboration:approve', 4) p WHERE @collaboration_page IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.permission = p.permission AND m.deleted = b'0');