-- 采购申请「批量提交」按钮权限
|
-- 影响页面：ERP -> 采购管理 -> 采购申请
|
--
|
-- 背景：采购申请提交接口（PUT /erp/purchase-request/submit、/submit-batch）使用
|
-- 权限码 erp:purchase-request:submit，但 system_menu 中从未维护该权限按钮，
|
-- 导致前端工具栏「批量提交」按钮被权限过滤隐藏，普通角色调用接口会 403。
|
--
|
-- 本脚本幂等，可重复执行。执行后需清理权限缓存（重启后端或删除
|
-- redis 中的 permission_menu_ids:erp:purchase-request:submit 与相关 role_menu_ids:*），
|
-- 前端重新登录/刷新后生效。
|
|
-- 1. 补按钮菜单（挂在“采购申请”菜单下）
|
INSERT INTO system_menu (name, permission, type, sort, parent_id, status, icon, creator, updater)
|
SELECT '批量提交审批', 'erp:purchase-request:submit', 3, 9, p.id, 0, '#', '1', '1'
|
FROM system_menu p
|
WHERE p.component = 'erp/purchase/request/index'
|
AND p.type = 2
|
AND p.deleted = b'0'
|
AND NOT EXISTS (
|
SELECT 1 FROM system_menu m
|
WHERE m.permission = 'erp:purchase-request:submit' 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.component = 'erp/purchase/request/index' AND p.type = 2 AND p.deleted = b'0'
|
JOIN system_menu m ON m.permission = 'erp:purchase-request:submit' AND m.deleted = b'0'
|
WHERE rm.menu_id = p.id
|
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'
|
);
|
