-- 原采购一级菜单停用时,将原采购订单及其按钮归入现有仓储物流/SRM 目录。 -- 不创建一级菜单,不授予新的采购业务权限;目标不存在或路径冲突时不迁移。 SET @old_purchase := (SELECT id FROM system_menu WHERE parent_id=0 AND path='/purchase' AND type=1 AND status=1 AND deleted=b'0' LIMIT 1); SET @warehouse := (SELECT id FROM system_menu WHERE parent_id=0 AND path='/wls' AND type=1 AND status=0 AND deleted=b'0' LIMIT 1); SET @srm := (SELECT id FROM system_menu WHERE parent_id=@warehouse AND path='srm' AND type=1 AND status=0 AND deleted=b'0' LIMIT 1); SET @order := (SELECT id FROM system_menu WHERE parent_id=@old_purchase AND component='erp/purchase/order/index' AND type=2 AND deleted=b'0' LIMIT 1); SET @conflict := (SELECT COUNT(*) FROM system_menu WHERE parent_id=@srm AND path='order' AND deleted=b'0' AND id<>IFNULL(@order,0)); UPDATE system_menu SET parent_id=@srm, updater='1', update_time=NOW() WHERE id=@order AND @srm IS NOT NULL AND @conflict=0; INSERT INTO system_role_menu (role_id,menu_id,creator,updater,tenant_id) SELECT DISTINCT rm.role_id, parents.id, '1','1',rm.tenant_id FROM system_role_menu rm JOIN system_menu parents ON parents.id IN (@warehouse,@srm) WHERE rm.menu_id=@order AND rm.deleted=b'0' AND @srm IS NOT NULL AND @conflict=0 AND NOT EXISTS (SELECT 1 FROM system_role_menu e WHERE e.role_id=rm.role_id AND e.tenant_id=rm.tenant_id AND e.menu_id=parents.id AND e.deleted=b'0');