water/server/plugin/saiadmin/db/20261009_add_member_activation_button_permission.sql

-- 会员开通按钮权限。可重复执行。

-- 1) 在 UserList 菜单下挂 type=3(button) 的「用户会员开通」按钮。
INSERT INTO `sa_system_menu` (
    `parent_id`, `name`, `code`, `slug`, `type`, `path`, `component`, `method`, `icon`, `sort`,
    `link_url`, `is_iframe`, `is_keep_alive`, `is_hidden`, `is_fixed_tab`, `is_full_page`,
    `generate_id`, `generate_key`, `status`, `remark`, `created_by`, `updated_by`, `create_time`, `update_time`, `delete_time`
)
SELECT user_menu.`id`, '用户会员开通', 'RentalUserMemberActivation', 'core:user:list:memberActivation', 3,
       NULL, NULL, 'POST', NULL, 110,
       NULL, 2, 2, 2, 2, 2, 0, NULL, 1,
       '管理员对当前可见小程序租借用户开通或续费会员', 1, 1, NOW(), NOW(), NULL
FROM `sa_system_menu` user_menu
WHERE user_menu.`code` = 'UserList' AND user_menu.`delete_time` IS NULL
  AND NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE `slug` = 'core:user:list:memberActivation' AND `delete_time` IS NULL);

UPDATE `sa_system_menu`
SET `name` = '用户会员开通', `method` = 'POST',
    `remark` = '管理员对当前可见小程序租借用户开通或续费会员', `update_time` = NOW()
WHERE `slug` = 'core:user:list:memberActivation' AND `delete_time` IS NULL;

-- 2) 已有 UserList 权限的角色自动获得该按钮。
INSERT INTO `sa_system_role_menu` (`role_id`, `menu_id`)
SELECT DISTINCT source_role.`role_id`, target_menu.`id`
FROM `sa_system_role_menu` source_role
INNER JOIN `sa_system_menu` source_menu
        ON source_menu.`id` = source_role.`menu_id`
       AND source_menu.`code` = 'UserList'
       AND source_menu.`delete_time` IS NULL
INNER JOIN `sa_system_menu` target_menu
        ON target_menu.`slug` = 'core:user:list:memberActivation'
       AND target_menu.`delete_time` IS NULL
LEFT JOIN `sa_system_role_menu` existing_role
       ON existing_role.`role_id` = source_role.`role_id`
      AND existing_role.`menu_id` = target_menu.`id`
WHERE existing_role.`id` IS NULL;