-- 仅当原采购一级菜单已停用时,把已有供应商管理目录归入仓储物流;不增改一级菜单。 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_root := (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_menu := (SELECT id FROM system_menu WHERE parent_id=@old_purchase AND path='srm' AND type=1 AND deleted=b'0' LIMIT 1); SET @srm_conflict := (SELECT COUNT(*) FROM system_menu WHERE parent_id=@warehouse_root AND path='srm' AND deleted=b'0' AND id<>IFNULL(@srm_menu,0)); UPDATE system_menu SET parent_id=@warehouse_root, updater='1', update_time=NOW() WHERE id=@srm_menu AND @warehouse_root IS NOT NULL AND @srm_conflict=0; -- 保留原有授权角色对新增祖先菜单的可见性,不赋予额外业务按钮权限。 INSERT INTO system_role_menu (role_id,menu_id,creator,updater,tenant_id) SELECT DISTINCT rm.role_id,@warehouse_root,'1','1',rm.tenant_id FROM system_role_menu rm WHERE rm.menu_id=@srm_menu AND rm.deleted=b'0' AND @warehouse_root IS NOT NULL AND @srm_conflict=0 AND NOT EXISTS (SELECT 1 FROM system_role_menu existing WHERE existing.role_id=rm.role_id AND existing.tenant_id=rm.tenant_id AND existing.menu_id=@warehouse_root AND existing.deleted=b'0');