zkxw/docs/sql/migrations/2026-10-16-oa-done-bank-receipt-perm.sql

-- OA 已办中心 · 上传银行回执（按钮 F）
-- perms: oa:done:bank-receipt
-- 执行前确认父菜单：perms='oa:done' 或菜单名「已办中心」
-- 执行后请在「角色管理」勾选该按钮权限，并重新登录/刷新菜单权限码

-- 查找父菜单（手工确认）：
-- SELECT id, parent_id, menu_name, perms, menu_type
-- FROM sys_menu
-- WHERE del_flag = 0 AND (perms = 'oa:done' OR menu_name LIKE '%已办中心%');

INSERT INTO sys_menu (
  id, parent_id, menu_name, menu_type, path, component, perms,
  is_frame, visible, status,
  tenant_no, order_num, remark, create_by, create_dept_id, create_time, update_by, update_time, del_flag
)
SELECT
  REPLACE(UUID(), '-', ''),
  m.id,
  '上传银行回执',
  'F',
  '',
  '',
  'oa:done:bank-receipt',
  1,
  '0',
  '1',
  'zkxw',
  90,
  '已办中心操作列：上传/管理银行回执单',
  'system',
  '',
  NOW(),
  'system',
  NOW(),
  0
FROM sys_menu m
WHERE m.del_flag = 0
  AND m.perms = 'oa:done'
  AND NOT EXISTS (
    SELECT 1 FROM sys_menu x
    WHERE x.del_flag = 0 AND x.perms = 'oa:done:bank-receipt'
  )
LIMIT 1;