-- 仅当原采购一级菜单已停用时,把已有供应商管理目录归入仓储物流;不增改一级菜单。
|
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');
|