Главная Обзор Помощь
Вход
txl
/
ylrz_saas_his_scrm
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: c26e15e992
Ветки Метки
ylrz_saas_hi...
/
sql
/
admin_menu_init.sql

admin_menu_init.sql 12 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124 
  1. -- =====================================================
    2. 

  2. -- adminUI 总后台菜单初始化 SQL (sys_menu，非 fs_menu)
    3. 

  3. -- 将前端硬编码菜单迁移到数据库，支持角色-菜单权限分配
    4. 

  4. -- =====================================================
    5. 

  5. 

  6. -- 1. 清理旧数据（谨慎执行，确保备份）
    7. 

  7. DELETE FROM sys_role_menu WHERE menu_id IN (
    8. 

  8.     SELECT menu_id FROM (SELECT menu_id FROM sys_menu WHERE menu_id >= 2000) t
    9. 

  9. );
    10. 

  10. DELETE FROM sys_menu WHERE menu_id >= 2000;
    11. 

  11. 

  12. -- 2. 根节点：/admin
    13. 

  13. INSERT INTO sys_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)
    14. 

  14. VALUES (2000, '总后台', 0, 1, 'admin', 'AdminLayout', 'M', 'el-icon-s-platform', '0', '0', 0, 0, 'admin', NOW(), 'adminUI根路由');
    15. 

  15. 

  16. -- 3. 数据看板（作为 /admin 的默认重定向页面）
    17. 

  17. INSERT INTO sys_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)
    18. 

  18. VALUES (2001, '数据看板', 2000, 0, 'dashboard', 'admin/dashboard/index', 'C', 'el-icon-s-data', '0', '0', 0, 0, 'admin', NOW(), '默认首页');
    19. 

  19. 

  20. -- ============================================================================
    21. 

  21. -- 4. 分组 1：租户代理
    22. 

  22. -- ============================================================================
    23. 

  23. INSERT INTO sys_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)
    24. 

  24. VALUES (2100, '租户代理', 2000, 1, '', '', 'M', 'el-icon-office-building', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    25. 

  25. 

  26. INSERT INTO sys_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)
    27. 

  27. VALUES
    28. 

  28. (2101, '代理管理', 2100, 1, 'proxy', 'admin/proxy/index', 'C', 'el-icon-user', '0', '0', 0, 0, 'admin', NOW(), NULL),
    29. 

  29. (2102, '收费配置', 2100, 2, 'serviceCost', 'admin/serviceCost/index', 'C', 'el-icon-price-tag', '0', '0', 0, 0, 'admin', NOW(), NULL),
    30. 

  30. (2103, '收益报表', 2100, 3, 'agentReport', 'admin/agentReport/index', 'C', 'el-icon-data-analysis', '0', '0', 0, 0, 'admin', NOW(), NULL),
    31. 

  31. (2104, '租户列表', 2100, 4, 'company', 'admin/sysCompany/index', 'C', 'el-icon-notebook-2', '0', '0', 0, 0, 'admin', NOW(), NULL),
    32. 

  32. (2105, '租户模块使用统计', 2100, 5, 'moduleUsage', 'admin/moduleUsage/index', 'C', 'el-icon-pie-chart', '0', '0', 0, 0, 'admin', NOW(), NULL),
    33. 

  33. (2106, '租户管理端菜单', 2100, 6, 'tenantMenu', 'admin/tenantMenu/index', 'C', 'el-icon-menu', '0', '0', 0, 0, 'admin', NOW(), '租户管理端菜单模板 CRUD'),
    34. 

  34. (2107, '租户销售端菜单', 2100, 7, 'tenantCompany', 'admin/tenantCompany/index', 'C', 'el-icon-s-grid', '0', '0', 0, 0, 'admin', NOW(), '租户销售端菜单模板 CRUD');
    35. 

  35. 

  36. -- ============================================================================
    37. 

  37. -- 5. 分组 2：内容审计
    38. 

  38. -- ============================================================================
    39. 

  39. INSERT INTO sys_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)
    40. 

  40. VALUES (2200, '内容审计', 2000, 2, '', '', 'M', 'el-icon-view', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    41. 

  41. 

  42. INSERT INTO sys_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)
    43. 

  43. VALUES
    44. 

  44. (2201, '视频资源', 2200, 1, 'videoResource', 'admin/videoResource/index', 'C', 'el-icon-video-camera', '0', '0', 0, 0, 'admin', NOW(), NULL),
    45. 

  45. (2202, '公域课程管理', 2200, 2, 'course', 'admin/course/index', 'C', 'el-icon-reading', '0', '0', 0, 0, 'admin', NOW(), NULL),
    46. 

  46. (2203, '直播间', 2200, 3, 'live', 'admin/live/index', 'C', 'el-icon-video-camera-solid', '0', '0', 0, 0, 'admin', NOW(), NULL),
    47. 

  47. (2204, '直播视频', 2200, 4, 'liveVideo', 'admin/liveVideo/index', 'C', 'el-icon-film', '0', '0', 0, 0, 'admin', NOW(), NULL),
    48. 

  48. (2205, '商品管理', 2200, 5, 'product', 'admin/product/index', 'C', 'el-icon-goods', '0', '0', 0, 0, 'admin', NOW(), NULL),
    49. 

  49. (2206, '销售订单', 2200, 6, 'storeOrder', 'admin/storeOrder/index', 'C', 'el-icon-shopping-bag-1', '0', '0', 0, 0, 'admin', NOW(), NULL),
    50. 

  50. (2207, 'AI生成工作流', 2200, 7, 'workflowGenerate', 'lobster/workflow-generate/index', 'C', 'el-icon-cpu', '0', '0', 0, 0, 'admin', NOW(), NULL),
    51. 

  51. (2208, '销冠语料学习', 2200, 8, 'salesCorpus', 'lobster/sales-corpus/index', 'C', 'el-icon-trophy', '0', '0', 0, 0, 'admin', NOW(), NULL),
    52. 

  52. (2209, '文章管理', 2200, 9, 'article', 'admin/article/index', 'C', 'el-icon-document', '0', '0', 0, 0, 'admin', NOW(), NULL);
    53. 

  53. 

  54. -- ============================================================================
    55. 

  55. -- 6. 分组 3：财务管理
    56. 

  56. -- ============================================================================
    57. 

  57. INSERT INTO sys_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)
    58. 

  58. VALUES (2300, '财务管理', 2000, 3, '', '', 'M', 'el-icon-money', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    59. 

  59. 

  60. INSERT INTO sys_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)
    61. 

  61. VALUES
    62. 

  62. (2301, '消费扣款记录', 2300, 1, 'consumeRecord', 'admin/consumeRecord/index', 'C', 'el-icon-wallet', '0', '0', 0, 0, 'admin', NOW(), NULL),
    63. 

  63. (2302, '模块消费统计', 2300, 2, 'consumeReport', 'admin/consumeReport/index', 'C', 'el-icon-pie-chart', '0', '0', 0, 0, 'admin', NOW(), NULL),
    64. 

  64. (2303, '充值扣款记录', 2300, 3, 'rechargeRecord', 'admin/rechargeRecord/index', 'C', 'el-icon-bank-card', '0', '0', 0, 0, 'admin', NOW(), NULL),
    65. 

  65. (2304, '返佣记录', 2300, 4, 'commissionRecord', 'admin/commissionRecord/index', 'C', 'el-icon-coin', '0', '0', 0, 0, 'admin', NOW(), NULL),
    66. 

  66. (2305, '代理提现管理', 2300, 5, 'withdrawal', 'admin/withdrawalManage/index', 'C', 'el-icon-money', '0', '0', 0, 0, 'admin', NOW(), NULL);
    67. 

  67. 

  68. -- ============================================================================
    69. 

  69. -- 7. 分组 4：通信管理
    70. 

  70. -- ============================================================================
    71. 

  71. INSERT INTO sys_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)
    72. 

  72. VALUES (2400, '通信管理', 2000, 4, '', '', 'M', 'el-icon-phone-outline', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    73. 

  73. 

  74. INSERT INTO sys_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)
    75. 

  75. VALUES
    76. 

  76. (2401, '外呼管理', 2400, 1, 'voice', 'admin/voice/index', 'C', 'el-icon-phone', '0', '0', 0, 0, 'admin', NOW(), NULL),
    77. 

  77. (2402, '通话接口管理', 2400, 2, 'voiceApi', 'admin/voiceApi/index', 'C', 'el-icon-connection', '0', '0', 0, 0, 'admin', NOW(), NULL),
    78. 

  78. (2403, '通话套餐管理', 2400, 3, 'voicePackage', 'admin/voicePackage/index', 'C', 'el-icon-box', '0', '0', 0, 0, 'admin', NOW(), NULL),
    79. 

  79. (2404, '坐席管理', 2400, 4, 'voiceSeat', 'admin/voiceSeat/index', 'C', 'el-icon-service', '0', '0', 0, 0, 'admin', NOW(), NULL),
    80. 

  80. (2405, '黑名单管理', 2400, 5, 'voiceBlacklist', 'admin/voiceBlacklist/index', 'C', 'el-icon-warning', '0', '0', 0, 0, 'admin', NOW(), NULL),
    81. 

  81. (2406, '呼叫频率配置', 2400, 6, 'voiceFrequency', 'admin/voiceFrequency/index', 'C', 'el-icon-timer', '0', '0', 0, 0, 'admin', NOW(), NULL),
    82. 

  82. (2407, '通话套餐订单', 2400, 7, 'voiceOrder', 'admin/voiceOrder/index', 'C', 'el-icon-tickets', '0', '0', 0, 0, 'admin', NOW(), NULL),
    83. 

  83. (2408, '短信管理', 2400, 8, 'sms', 'admin/sms/index', 'C', 'el-icon-chat-dot-round', '0', '0', 0, 0, 'admin', NOW(), NULL),
    84. 

  84. (2409, '短信套餐', 2400, 9, 'smsPackage', 'admin/smsPackage/index', 'C', 'el-icon-box', '0', '0', 0, 0, 'admin', NOW(), NULL),
    85. 

  85. (2410, '短信订单', 2400, 10, 'smsOrder', 'admin/smsOrder/index', 'C', 'el-icon-tickets', '0', '0', 0, 0, 'admin', NOW(), NULL);
    86. 

  86. 

  87. -- ============================================================================
    88. 

  88. -- 8. 分组 5：系统管理
    89. 

  89. -- ============================================================================
    90. 

  90. INSERT INTO sys_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)
    91. 

  91. VALUES (2500, '系统管理', 2000, 5, '', '', 'M', 'el-icon-setting', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    92. 

  92. 

  93. INSERT INTO sys_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)
    94. 

  94. VALUES
    95. 

  95. (2501, '员工管理', 2500, 1, 'sysUser', 'admin/sysUser/index', 'C', 'el-icon-user', '0', '0', 0, 0, 'admin', NOW(), NULL),
    96. 

  96. (2502, '角色管理', 2500, 2, 'role', 'system/role/index', 'C', 'el-icon-s-check', '0', '0', 0, 0, 'admin', NOW(), NULL),
    97. 

  97. (2503, '菜单管理', 2500, 3, 'menu', 'system/menu/index', 'C', 'el-icon-menu', '0', '0', 0, 0, 'admin', NOW(), NULL),
    98. 

  98. (2504, '部门管理', 2500, 4, 'dept', 'system/dept/index', 'C', 'el-icon-s-cooperation', '0', '0', 0, 0, 'admin', NOW(), NULL),
    99. 

  99. (2505, '岗位管理', 2500, 5, 'post', 'system/post/index', 'C', 'el-icon-s-custom', '0', '0', 0, 0, 'admin', NOW(), NULL),
    100. 

  100. (2506, '操作日志', 2500, 6, 'operLog', 'monitor/operlog/index', 'C', 'el-icon-document', '0', '0', 0, 0, 'admin', NOW(), NULL),
    101. 

  101. (2507, '登录日志', 2500, 7, 'loginLog', 'monitor/logininfor/index', 'C', 'el-icon-key', '0', '0', 0, 0, 'admin', NOW(), NULL),
    102. 

  102. (2508, '租户操作日志', 2500, 8, 'companyOperLog', 'monitor/componentsOperLog/index', 'C', 'el-icon-notebook-2', '0', '0', 0, 0, 'admin', NOW(), NULL),
    103. 

  103. (2509, '代理操作日志', 2500, 9, 'proxyOperLog', 'admin/proxyOperLog/index', 'C', 'el-icon-document-copy', '0', '0', 0, 0, 'admin', NOW(), NULL);
    104. 

  104. 

  105. -- ============================================================================
    106. 

  106. -- 9. 分组 6：系统配置
    107. 

  107. -- ============================================================================
    108. 

  108. INSERT INTO sys_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)
    109. 

  109. VALUES (2600, '系统配置', 2000, 6, '', '', 'M', 'el-icon-s-tools', '0', '0', 0, 0, 'admin', NOW(), '顶部导航分组');
    110. 

  110. 

  111. INSERT INTO sys_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)
    112. 

  112. VALUES
    113. 

  113. (2601, '字典管理', 2600, 1, 'dict', 'system/dict/index', 'C', 'el-icon-collection', '0', '0', 0, 0, 'admin', NOW(), NULL),
    114. 

  114. (2602, '参数管理', 2600, 2, 'config', 'system/config/index', 'C', 'el-icon-edit-outline', '0', '0', 0, 0, 'admin', NOW(), NULL),
    115. 

  115. (2603, '通知公告', 2600, 3, 'notice', 'system/notice/index', 'C', 'el-icon-bell', '0', '0', 0, 0, 'admin', NOW(), NULL),
    116. 

  116. (2604, '违规词语', 2600, 4, 'keyword', 'system/keyword/index', 'C', 'el-icon-warning-outline', '0', '0', 0, 0, 'admin', NOW(), NULL),
    117. 

  117. (2605, 'CID配置', 2600, 5, 'cidConfig', 'admin/cidConfig/index', 'C', 'el-icon-phone', '0', '0', 0, 0, 'admin', NOW(), NULL),
    118. 

  118. (2606, '个微配置', 2600, 6, 'wxConfig', 'admin/wxConfig/index', 'C', 'el-icon-chat-line-round', '0', '0', 0, 0, 'admin', NOW(), NULL),
    119. 

  119. (2607, 'OSS配置', 2600, 7, 'ossConfig', 'admin/ossConfig/index', 'C', 'el-icon-upload', '0', '0', 0, 0, 'admin', NOW(), NULL),
    120. 

  120. (2608, '前端配置', 2600, 8, 'frontConfig', 'admin/frontConfig/index', 'C', 'el-icon-monitor', '0', '0', 0, 0, 'admin', NOW(), NULL),
    121. 

  121. (2609, 'Ipad服务器', 2600, 9, 'ipadServer', 'admin/ipadServer/index', 'C', 'el-icon-mobile-phone', '0', '0', 0, 0, 'admin', NOW(), NULL),
    122. 

  122. (2610, '关键词管理', 2600, 10, 'keywordManage', 'admin/keywordManage/index', 'C', 'el-icon-search', '0', '0', 0, 0, 'admin', NOW(), NULL),
    123. 

  123. (2611, '文本模型配置', 2600, 11, 'textModel', 'admin/textModel/index', 'C', 'el-icon-cpu', '0', '0', 0, 0, 'admin', NOW(), NULL),
    124. 

  124. (2612, 'DB配置', 2600, 12, 'dbConfig', 'admin/dbConfig/index', 'C', 'el-icon-s-data', '0', '0', 0, 0, 'admin', NOW(), NULL);
    125.