-- =============================================
|
-- 移除仓库"库区/库位"菜单与权限
|
-- 仓库不再维护库区(warehouse_location)、库位(warehouse_area),
|
-- 同步清理后台菜单及角色授权,避免前端访问已删除的页面组件。
|
-- =============================================
|
|
-- 1. 清理角色与库区/库位菜单的授权关联
|
DELETE rm FROM system_role_menu rm
|
JOIN system_menu m ON m.id = rm.menu_id
|
WHERE m.component LIKE 'wls/warehouse/location%'
|
OR m.component LIKE 'wls/warehouse/area%'
|
OR m.component LIKE 'mes/wm/warehouse/location%'
|
OR m.component LIKE 'mes/wm/warehouse/area%'
|
OR m.permission LIKE 'mes:wm-warehouse-location%'
|
OR m.permission LIKE 'mes:wm-warehouse-area%';
|
|
-- 2. 删除库区/库位菜单
|
DELETE FROM system_menu
|
WHERE component LIKE 'wls/warehouse/location%'
|
OR component LIKE 'wls/warehouse/area%'
|
OR component LIKE 'mes/wm/warehouse/location%'
|
OR component LIKE 'mes/wm/warehouse/area%'
|
OR permission LIKE 'mes:wm-warehouse-location%'
|
OR permission LIKE 'mes:wm-warehouse-area%';
|