-- =====================================================================
-- 多语言国际化：补充「静态文案」菜单（已有库升级脚本）
-- 适用场景：侧栏仅显示“语言配置 / 翻译管理”，未显示“静态文案”
-- 执行环境：MySQL 8+
-- 幂等：可重复执行
-- =====================================================================

-- 1) 菜单：静态文案（C）
INSERT INTO `sys_menu` (
  `menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
  `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
  `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
)
SELECT
  2991, '静态文案', 2660, 3, 'staticText', 'huayang/staticText/index',
  '', '', 1, 0, 'C', '0', '0',
  'huayang:translation:list', 'form', 'admin', NOW(), '', NULL, '按 key 维护静态文案'
FROM DUAL
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2660)
  AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991);

-- 2) 按钮权限（F）：查询 / 新增 / 修改 / 删除
INSERT INTO `sys_menu` (
  `menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
  `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
  `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
)
SELECT
  2992, '静态文案查询', 2991, 1, '', '', '', '', 1, 0, 'F', '0', '0',
  'huayang:translation:query', '#', 'admin', NOW(), '', NULL, ''
FROM DUAL
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
  AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2992);

INSERT INTO `sys_menu` (
  `menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
  `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
  `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
)
SELECT
  2993, '静态文案新增', 2991, 2, '', '', '', '', 1, 0, 'F', '0', '0',
  'huayang:translation:add', '#', 'admin', NOW(), '', NULL, ''
FROM DUAL
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
  AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2993);

INSERT INTO `sys_menu` (
  `menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
  `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
  `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
)
SELECT
  2994, '静态文案修改', 2991, 3, '', '', '', '', 1, 0, 'F', '0', '0',
  'huayang:translation:edit', '#', 'admin', NOW(), '', NULL, ''
FROM DUAL
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
  AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2994);

INSERT INTO `sys_menu` (
  `menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
  `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
  `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
)
SELECT
  2995, '静态文案删除', 2991, 4, '', '', '', '', 1, 0, 'F', '0', '0',
  'huayang:translation:remove', '#', 'admin', NOW(), '', NULL, ''
FROM DUAL
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
  AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2995);

-- 3) 给已有“翻译管理(2662)”权限的角色补“静态文案(2991~2995)”权限
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT rm.`role_id`, 2991
FROM `sys_role_menu` rm
WHERE rm.`menu_id` = 2662
  AND NOT EXISTS (
    SELECT 1 FROM `sys_role_menu` t
    WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2991
  );

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT rm.`role_id`, 2992
FROM `sys_role_menu` rm
WHERE rm.`menu_id` = 2662
  AND NOT EXISTS (
    SELECT 1 FROM `sys_role_menu` t
    WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2992
  );

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT rm.`role_id`, 2993
FROM `sys_role_menu` rm
WHERE rm.`menu_id` = 2662
  AND NOT EXISTS (
    SELECT 1 FROM `sys_role_menu` t
    WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2993
  );

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT rm.`role_id`, 2994
FROM `sys_role_menu` rm
WHERE rm.`menu_id` = 2662
  AND NOT EXISTS (
    SELECT 1 FROM `sys_role_menu` t
    WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2994
  );

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
SELECT rm.`role_id`, 2995
FROM `sys_role_menu` rm
WHERE rm.`menu_id` = 2662
  AND NOT EXISTS (
    SELECT 1 FROM `sys_role_menu` t
    WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2995
  );