ylrz_saas_his_scrm/sql/add_traffic_pricing_menu.sql

-- ============================================================
-- adminUI 总后台菜单补充 - 租户流量定价管理(trafficPricing)
-- 挂载到 通信管理(2400) 分组下
-- ============================================================

-- 租户流量定价管理 (menu_id=2415)
INSERT INTO fs_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, is_frame, is_cache, create_by, create_time, remark)
VALUES (2415, '流量定价管理', 2400, 4, 'trafficPricing', 'admin/trafficPricing/index', 'C', 'el-icon-data-line', '0', '0', 0, 0, 'admin', NOW(), '按租户覆盖课程/直播流量定价');

-- 流量定价按钮权限
INSERT INTO fs_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, perms, icon, visible, status, is_frame, is_cache, create_by, create_time)
VALUES
(24151, '定价查询', 2415, 1, '', '', 'F', 'platform:trafficPricing:list',   '#', '0', '0', 0, 0, 'admin', NOW()),
(24152, '定价新增', 2415, 2, '', '', 'F', 'platform:trafficPricing:add',    '#', '0', '0', 0, 0, 'admin', NOW()),
(24153, '定价编辑', 2415, 3, '', '', 'F', 'platform:trafficPricing:edit',   '#', '0', '0', 0, 0, 'admin', NOW()),
(24154, '定价删除', 2415, 4, '', '', 'F', 'platform:trafficPricing:remove', '#', '0', '0', 0, 0, 'admin', NOW());

-- 将新菜单关联到admin角色(role_id=1)
INSERT INTO fs_role_menu (role_id, menu_id) VALUES
(1, 2415),
(1, 24151),
(1, 24152),
(1, 24153),
(1, 24154);