-- 诚发五金(CFWJ)角色菜单授权补漏 2026-11-03 -- 背景:菜单补齐后仍有若干页面只授权给了超管(role_id=1),普通演示角色看不到; -- 另外「计划排程」顶级目录本身没有授权记录,会导致其下的生产计划/生产排产在普通角色菜单树里被丢弃。 -- 角色:163 设备 / 164 质量 / 165 销售 / 166 生产管理员 / 167 生产员 / 168 经理 -- 幂等:逐对检查 system_role_menu 是否已存在,不会产生重复授权。 INSERT INTO system_role_menu (role_id, menu_id, creator, create_time) SELECT p.role_id, p.menu_id, '1', NOW() FROM ( SELECT 2 AS role_id, 1075513 AS menu_id UNION ALL SELECT 155 AS role_id, 1075513 AS menu_id UNION ALL SELECT 160 AS role_id, 1075513 AS menu_id UNION ALL SELECT 161 AS role_id, 1075513 AS menu_id UNION ALL SELECT 162 AS role_id, 1075513 AS menu_id UNION ALL SELECT 166 AS role_id, 1075513 AS menu_id UNION ALL SELECT 167 AS role_id, 1075513 AS menu_id UNION ALL SELECT 168 AS role_id, 1075513 AS menu_id UNION ALL SELECT 166 AS role_id, 1075538 AS menu_id UNION ALL SELECT 167 AS role_id, 1075538 AS menu_id UNION ALL SELECT 168 AS role_id, 1075538 AS menu_id UNION ALL SELECT 166 AS role_id, 1075539 AS menu_id UNION ALL SELECT 167 AS role_id, 1075539 AS menu_id UNION ALL SELECT 168 AS role_id, 1075539 AS menu_id UNION ALL SELECT 166 AS role_id, 1075540 AS menu_id UNION ALL SELECT 167 AS role_id, 1075540 AS menu_id UNION ALL SELECT 168 AS role_id, 1075540 AS menu_id UNION ALL SELECT 166 AS role_id, 1075541 AS menu_id UNION ALL SELECT 167 AS role_id, 1075541 AS menu_id UNION ALL SELECT 168 AS role_id, 1075541 AS menu_id UNION ALL SELECT 166 AS role_id, 1075542 AS menu_id UNION ALL SELECT 167 AS role_id, 1075542 AS menu_id UNION ALL SELECT 168 AS role_id, 1075542 AS menu_id UNION ALL SELECT 166 AS role_id, 1075543 AS menu_id UNION ALL SELECT 167 AS role_id, 1075543 AS menu_id UNION ALL SELECT 168 AS role_id, 1075543 AS menu_id UNION ALL SELECT 166 AS role_id, 1075544 AS menu_id UNION ALL SELECT 167 AS role_id, 1075544 AS menu_id UNION ALL SELECT 168 AS role_id, 1075544 AS menu_id UNION ALL SELECT 166 AS role_id, 1075545 AS menu_id UNION ALL SELECT 167 AS role_id, 1075545 AS menu_id UNION ALL SELECT 168 AS role_id, 1075545 AS menu_id UNION ALL SELECT 166 AS role_id, 1075546 AS menu_id UNION ALL SELECT 167 AS role_id, 1075546 AS menu_id UNION ALL SELECT 168 AS role_id, 1075546 AS menu_id UNION ALL SELECT 166 AS role_id, 1075547 AS menu_id UNION ALL SELECT 167 AS role_id, 1075547 AS menu_id UNION ALL SELECT 168 AS role_id, 1075547 AS menu_id UNION ALL SELECT 163 AS role_id, 1075514 AS menu_id UNION ALL SELECT 166 AS role_id, 1075514 AS menu_id UNION ALL SELECT 167 AS role_id, 1075514 AS menu_id UNION ALL SELECT 163 AS role_id, 1075515 AS menu_id UNION ALL SELECT 166 AS role_id, 1075515 AS menu_id UNION ALL SELECT 167 AS role_id, 1075515 AS menu_id UNION ALL SELECT 163 AS role_id, 1075516 AS menu_id UNION ALL SELECT 166 AS role_id, 1075516 AS menu_id UNION ALL SELECT 167 AS role_id, 1075516 AS menu_id UNION ALL SELECT 163 AS role_id, 1075517 AS menu_id UNION ALL SELECT 166 AS role_id, 1075517 AS menu_id UNION ALL SELECT 167 AS role_id, 1075517 AS menu_id UNION ALL SELECT 163 AS role_id, 1075518 AS menu_id UNION ALL SELECT 166 AS role_id, 1075518 AS menu_id UNION ALL SELECT 167 AS role_id, 1075518 AS menu_id UNION ALL SELECT 163 AS role_id, 1075519 AS menu_id UNION ALL SELECT 166 AS role_id, 1075519 AS menu_id UNION ALL SELECT 167 AS role_id, 1075519 AS menu_id UNION ALL SELECT 163 AS role_id, 1075521 AS menu_id UNION ALL SELECT 163 AS role_id, 1075522 AS menu_id UNION ALL SELECT 168 AS role_id, 1075523 AS menu_id UNION ALL SELECT 168 AS role_id, 1075524 AS menu_id UNION ALL SELECT 168 AS role_id, 1075525 AS menu_id UNION ALL SELECT 168 AS role_id, 1075526 AS menu_id UNION ALL SELECT 168 AS role_id, 1075527 AS menu_id UNION ALL SELECT 168 AS role_id, 1075528 AS menu_id UNION ALL SELECT 168 AS role_id, 1075536 AS menu_id UNION ALL SELECT 168 AS role_id, 1075537 AS menu_id UNION ALL SELECT 168 AS role_id, 1075548 AS menu_id UNION ALL SELECT 168 AS role_id, 1075549 AS menu_id UNION ALL SELECT 168 AS role_id, 1075550 AS menu_id UNION ALL SELECT 168 AS role_id, 1075551 AS menu_id UNION ALL SELECT 168 AS role_id, 1075552 AS menu_id UNION ALL SELECT 168 AS role_id, 1075553 AS menu_id UNION ALL SELECT 168 AS role_id, 1075554 AS menu_id UNION ALL SELECT 168 AS role_id, 1075555 AS menu_id UNION ALL SELECT 168 AS role_id, 1075556 AS menu_id UNION ALL SELECT 168 AS role_id, 1075557 AS menu_id UNION ALL SELECT 168 AS role_id, 1075558 AS menu_id UNION ALL SELECT 168 AS role_id, 1075559 AS menu_id UNION ALL SELECT 168 AS role_id, 1075560 AS menu_id UNION ALL SELECT 168 AS role_id, 1075561 AS menu_id UNION ALL SELECT 168 AS role_id, 1075562 AS menu_id UNION ALL SELECT 168 AS role_id, 1075563 AS menu_id UNION ALL SELECT 168 AS role_id, 1075564 AS menu_id UNION ALL SELECT 168 AS role_id, 1075565 AS menu_id UNION ALL SELECT 168 AS role_id, 1075566 AS menu_id UNION ALL SELECT 168 AS role_id, 1075567 AS menu_id UNION ALL SELECT 165 AS role_id, 1075568 AS menu_id UNION ALL SELECT 168 AS role_id, 1075568 AS menu_id UNION ALL SELECT 165 AS role_id, 1075569 AS menu_id UNION ALL SELECT 168 AS role_id, 1075569 AS menu_id UNION ALL SELECT 165 AS role_id, 1075570 AS menu_id UNION ALL SELECT 168 AS role_id, 1075570 AS menu_id UNION ALL SELECT 165 AS role_id, 1075571 AS menu_id UNION ALL SELECT 168 AS role_id, 1075571 AS menu_id UNION ALL SELECT 165 AS role_id, 1075572 AS menu_id UNION ALL SELECT 168 AS role_id, 1075572 AS menu_id UNION ALL SELECT 165 AS role_id, 1075573 AS menu_id UNION ALL SELECT 168 AS role_id, 1075573 AS menu_id UNION ALL SELECT 165 AS role_id, 1075574 AS menu_id UNION ALL SELECT 168 AS role_id, 1075574 AS menu_id ) p WHERE NOT EXISTS ( SELECT 1 FROM system_role_menu rm WHERE rm.role_id = p.role_id AND rm.menu_id = p.menu_id AND rm.deleted = b'0' );