-- 将已有五个 BI 页面菜单作为各主题的服务端取数权限。 -- 保留既有角色-菜单关联:已授权页面的角色自动获得对应主题权限。 UPDATE system_menu SET permission = CASE id WHEN 1063001 THEN 'bi:dashboard:purchase_sales:query' WHEN 1063002 THEN 'bi:dashboard:warehouse:query' WHEN 1063003 THEN 'bi:dashboard:production_equipment:query' WHEN 1063004 THEN 'bi:dashboard:quality:query' WHEN 1063005 THEN 'bi:dashboard:hr_oa:query' END WHERE id IN (1063001, 1063002, 1063003, 1063004, 1063005) AND deleted = 0;