-- 采购成本分析菜单(基于 SRM 招标需求与供应商报价,不依赖 ERP) SET @srm_parent := (SELECT id FROM system_menu WHERE CAST(deleted AS UNSIGNED)=0 AND type=1 AND (name='供应商管理' OR path LIKE '%srm%' OR path LIKE '%supplier%') LIMIT 1); -- 若找不到 SRM 父菜单,退化为挂在仓储物流下 SET @srm_parent := IFNULL(@srm_parent, (SELECT id FROM system_menu WHERE CAST(deleted AS UNSIGNED)=0 AND type=1 AND name='仓储物流' 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,95,@srm_parent,'cost-analysis','lucide:line-chart','srm/statistics/cost-analysis','SrmCostAnalysis',0,b'1',b'1',b'1','1','1' WHERE @srm_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='srm/statistics/cost-analysis' AND CAST(deleted AS UNSIGNED)=0); SET @pg := (SELECT id FROM system_menu WHERE component='srm/statistics/cost-analysis' AND CAST(deleted AS UNSIGNED)=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,@pg,'','',0,b'1',b'1',b'1','1','1' FROM (SELECT '查询' name,'srm:statistics:query' permission,1 sort_no) p WHERE @pg IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@pg AND m.permission=p.permission AND CAST(m.deleted AS UNSIGNED)=0);