zkxw/docs/sql/migrations/2026-10-09-payment-chase-menu.sql

-- =============================================================================
-- 催缴信息菜单：插在缴费信息之下、样本信息管理之上
-- id: 50000000000000000000000000000022
-- perms / menuCode: cellStorage:paymentChase:list
-- =============================================================================

INSERT INTO sys_menu (
  id, menu_name, parent_id, 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
  '50000000000000000000000000000022',
  '催缴信息',
  'CEL00000000000000000000000000001',
  'C',
  'payment-chase',
  '/cell-storage/payment-chase/index',
  'cellStorage:paymentChase:list',
  1,
  '1',
  '1',
  'zkxw',
  5,
  '细胞存储：催缴信息（逾期∪近30天）',
  NULL,
  '',
  NOW(),
  NULL,
  NOW(),
  0
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM sys_menu m
  WHERE m.del_flag = 0
    AND (
      m.id = '50000000000000000000000000000022'
      OR m.perms = 'cellStorage:paymentChase:list'
    )
);

-- 已有缴费信息权限的角色补授权（幂等）
INSERT INTO sys_role_menu (
  id, role_id, menu_id, tenant_no, order_num, remark,
  create_by, create_dept_id, create_time, update_by, update_time, del_flag
)
SELECT
  MD5(CONCAT(r.id, '|50000000000000000000000000000022')),
  r.id,
  '50000000000000000000000000000022',
  IFNULL(NULLIF(r.tenant_no, ''), 'zkxw'),
  0,
  'grant payment-chase to payment-info roles',
  NULL,
  '',
  NOW(),
  NULL,
  NOW(),
  0
FROM sys_role r
INNER JOIN sys_role_menu rm
  ON rm.role_id = r.id
 AND rm.del_flag = 0
INNER JOIN sys_menu m
  ON m.id = rm.menu_id
 AND m.del_flag = 0
 AND m.perms = 'cellStorage:paymentInfo:list'
WHERE r.del_flag = 0
  AND NOT EXISTS (
    SELECT 1 FROM sys_role_menu x
    WHERE x.del_flag = 0
      AND x.role_id = r.id
      AND x.menu_id = '50000000000000000000000000000022'
  );