-- 直播预约记录 / 直播观看记录菜单权限修复脚本
-- 适用场景：已有数据库已初始化，但 sys_menu 中 3080/3081 仍是按钮权限，导致前端左侧菜单不显示。

START TRANSACTION;

UPDATE `sys_menu`
SET
  `parent_id` = 3050,
  `name` = '直播预约记录',
  `type` = 'C',
  `path` = '/live/course/reserve-records',
  `component` = 'Live/ReserveRecords',
  `sort` = 20,
  `permission_key` = 'live:reserve:view',
  `remark` = '直播预约记录菜单',
  `status` = 1,
  `visible` = 1,
  `deleted` = 0
WHERE `id` = 3080
   OR `menu_code` = 'live_reserve_view';

UPDATE `sys_menu`
SET
  `parent_id` = 3050,
  `name` = '直播观看记录',
  `type` = 'C',
  `path` = '/live/course/watch-records',
  `component` = 'Live/WatchRecords',
  `sort` = 21,
  `permission_key` = 'live:watch:view',
  `remark` = '直播观看记录菜单',
  `status` = 1,
  `visible` = 1,
  `deleted` = 0
WHERE `id` = 3081
   OR `menu_code` = 'live_watch_view';

INSERT INTO `sys_menu`
  (`id`, `parent_id`, `name`, `menu_code`, `type`, `path`, `component`, `icon`, `sort`, `status`, `visible`, `permission_key`, `remark`, `deleted`)
SELECT 3080, 3050, '直播预约记录', 'live_reserve_view', 'C', '/live/course/reserve-records', 'Live/ReserveRecords', NULL, 20, 1, 1, 'live:reserve:view', '直播预约记录菜单', 0
WHERE NOT EXISTS (
  SELECT 1 FROM `sys_menu` WHERE `id` = 3080 OR `menu_code` = 'live_reserve_view'
);

INSERT INTO `sys_menu`
  (`id`, `parent_id`, `name`, `menu_code`, `type`, `path`, `component`, `icon`, `sort`, `status`, `visible`, `permission_key`, `remark`, `deleted`)
SELECT 3081, 3050, '直播观看记录', 'live_watch_view', 'C', '/live/course/watch-records', 'Live/WatchRecords', NULL, 21, 1, 1, 'live:watch:view', '直播观看记录菜单', 0
WHERE NOT EXISTS (
  SELECT 1 FROM `sys_menu` WHERE `id` = 3081 OR `menu_code` = 'live_watch_view'
);

INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT r.`id`, 3080
FROM `sys_role` r
WHERE r.`deleted` = 0
  AND r.`status` = 1
  AND EXISTS (
    SELECT 1
    FROM `sys_role_menu` rm
    WHERE rm.`role_id` = r.`id`
      AND rm.`menu_id` = 3060
  );

INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT r.`id`, 3081
FROM `sys_role` r
WHERE r.`deleted` = 0
  AND r.`status` = 1
  AND EXISTS (
    SELECT 1
    FROM `sys_role_menu` rm
    WHERE rm.`role_id` = r.`id`
      AND rm.`menu_id` = 3060
  );

COMMIT;