-- 将采购价格分析归入现有决策分析菜单,不修改一级菜单或自动授予角色权限。 -- 目标环境没有 /bi 时,请按现有菜单结构选择父菜单后再执行。 SET @price_parent := (SELECT id FROM system_menu WHERE parent_id=0 AND path='/bi' 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 '采购价格分析', 'erp:statistics:query', 2, 50, @price_parent, 'purchase-price', 'lucide:chart-column', 'erp/purchase/statistics/price', 'ErpPurchaseStatisticsPrice', 0, b'1', b'1', b'1', '1', '1' WHERE @price_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='erp/purchase/statistics/price' AND deleted=b'0');