-- 质检单「完成」按钮权限
|
--
|
-- 背景：后端 MesQcIqc/Ipqc/Oqc/RqcController 的 /finish 接口分别校验
|
-- mes:qc-iqc:finish / mes:qc-ipqc:finish / mes:qc-oqc:finish / mes:qc-rqc:finish，
|
-- 但 system_menu 中没有这四个权限码对应的按钮，导致非超管用户点击「完成」
|
-- 直接返回 403「没有该操作权限」。
|
--
|
-- 本脚本幂等，可重复执行。执行后清理 Redis 中相关角色的 role_menu_ids 缓存，
|
-- 或让用户重新登录后生效。
|
|
-- 1. 补四个「完成」按钮，挂在各自质检列表菜单下
|
INSERT INTO system_menu (name, permission, type, sort, parent_id, status, icon, creator, updater)
|
SELECT s.name, s.permission, 3, 7, p.id, 0, '', '1', '1'
|
FROM system_menu p
|
JOIN (
|
SELECT '来料检验完成' AS name, 'mes:qc-iqc:finish' AS permission, 'mes/qc/iqc/index' AS component
|
UNION ALL SELECT '过程检验完成', 'mes:qc-ipqc:finish', 'mes/qc/ipqc/index'
|
UNION ALL SELECT '出货检验完成', 'mes:qc-oqc:finish', 'mes/qc/oqc/index'
|
UNION ALL SELECT '退料检验完成', 'mes:qc-rqc:finish', 'mes/qc/rqc/index'
|
) s ON p.component = s.component
|
WHERE p.type = 2 AND p.deleted = b'0'
|
AND NOT EXISTS (
|
SELECT 1 FROM system_menu m
|
WHERE m.permission = s.permission AND m.deleted = b'0'
|
);
|
|
-- 2. 授予已拥有对应质检列表菜单的角色
|
INSERT INTO system_role_menu (role_id, menu_id, creator, updater)
|
SELECT DISTINCT rm.role_id, m.id, '1', '1'
|
FROM system_role_menu rm
|
JOIN system_menu p ON p.id = rm.menu_id AND p.type = 2 AND p.deleted = b'0'
|
JOIN system_menu m ON m.parent_id = p.id AND m.deleted = b'0'
|
WHERE p.component IN ('mes/qc/iqc/index', 'mes/qc/ipqc/index', 'mes/qc/oqc/index', 'mes/qc/rqc/index')
|
AND m.permission IN ('mes:qc-iqc:finish', 'mes:qc-ipqc:finish', 'mes:qc-oqc:finish', 'mes:qc-rqc:finish')
|
AND rm.deleted = b'0'
|
AND NOT EXISTS (
|
SELECT 1 FROM system_role_menu x
|
WHERE x.role_id = rm.role_id AND x.menu_id = m.id AND x.deleted = b'0'
|
);
|
