-- ERP 实际已启用(销售/采购/付款订单接口均可用),撤销此前的 ERP 停用与菜单隐藏, -- 并把「采购成本分析」改为 ERP 采购订单口径的页面。 -- 1) 恢复采购管理下 ERP 子菜单启用(撤销误判停用) UPDATE system_menu SET status = 0 WHERE CAST(deleted AS UNSIGNED)=0 AND parent_id = 2602 AND component LIKE 'erp/%'; -- 2) 恢复仓库大屏(线上为启用状态) UPDATE system_menu SET status = 0, visible = b'1' WHERE CAST(deleted AS UNSIGNED)=0 AND component = 'bi/warehouse/index'; -- 3) 采购成本分析改指向 ERP 页面,并上挂到「采购管理」下(原挂在 SRM 下) UPDATE system_menu SET component = 'erp/purchase/statistics/price-analysis', component_name = 'ErpPurchasePriceAnalysis', name = '采购成本分析', parent_id = 2602, sort = 10, status = 0, visible = b'1' WHERE CAST(deleted AS UNSIGNED)=0 AND component IN ('srm/statistics/cost-analysis','erp/purchase/statistics/price-analysis'); -- 4) 确认菜单授权 INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT rm.role_id, m.id, '1', NOW(), '1', NOW(), b'0' FROM (SELECT DISTINCT role_id FROM system_role_menu WHERE menu_id = 602524 AND CAST(deleted AS UNSIGNED)=0) rm CROSS JOIN (SELECT id FROM system_menu WHERE component='erp/purchase/statistics/price-analysis' AND CAST(deleted AS UNSIGNED)=0) m WHERE NOT EXISTS (SELECT 1 FROM system_role_menu x WHERE x.role_id=rm.role_id AND x.menu_id=m.id AND CAST(x.deleted AS UNSIGNED)=0);