menu_seed.sql 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  1. -- ============================================================
  2. -- 菜单权限种子数据
  3. -- 使用方式:启动项目后表会自动创建,然后执行此SQL插入菜单数据
  4. -- ============================================================
  5. -- ==================== 一级菜单 ====================
  6. -- 1. 首页
  7. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  8. (1, 0, 0, '1', '/0/1/', '首页', 'C', 'icon-shouye', 'views/page/homeView', '/api/sys-user', 'home', '', 0, 1, 1, NOW(), NOW());
  9. -- 2. 系统管理(目录)
  10. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  11. (2, 0, 1, '1', '/0/2/', '系统管理', 'M', 'icon-system', '', '', 'SystemManagement', '', 0, 1, 1, NOW(), NOW());
  12. -- 2-1. 用户管理(超管版)
  13. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  14. (3, 2, 0, '1', '/0/2/3/', '用户管理', 'C', 'icon-yonghuguanli', 'views/system/interiorUserManagement', '/api/sys-user', 'interiorUserManagement', '', 0, 1, 1, NOW(), NOW());
  15. -- 2-1-1. 查询用户
  16. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  17. (31, 3, 0, '1', '/0/2/3/31/', '查询用户', 'F', '', '', '/api/sys-user', '', 'sys:user:query', 0, 1, 1, NOW(), NOW());
  18. -- 2-1-2. 新增用户
  19. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  20. (32, 3, 1, '1', '/0/2/3/32/', '新增用户', 'F', '', '', '/api/sys-user', '', 'sys:user:add', 0, 1, 1, NOW(), NOW());
  21. -- 2-1-3. 编辑用户
  22. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  23. (33, 3, 2, '1', '/0/2/3/33/', '编辑用户', 'F', '', '', '/api/sys-user', '', 'sys:user:edit', 0, 1, 1, NOW(), NOW());
  24. -- 2-1-4. 删除用户
  25. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  26. (34, 3, 3, '1', '/0/2/3/34/', '删除用户', 'F', '', '', '/api/sys-user', '', 'sys:user:delete', 0, 1, 1, NOW(), NOW());
  27. -- 2-1-5. 重置密码
  28. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  29. (35, 3, 4, '1', '/0/2/3/35/', '重置密码', 'F', '', '', '/api/sys-user/pwd/reset', '', 'sys:user:resetPwd', 0, 1, 1, NOW(), NOW());
  30. -- 2-2. 公司管理
  31. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  32. (4, 2, 1, '1', '/0/2/4/', '公司管理', 'C', 'icon-gongsi', 'views/system/CompanyManagement', '/api/company', 'CompanyManagement', '', 0, 1, 1, NOW(), NOW());
  33. -- 2-2-1. 查询公司
  34. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  35. (41, 4, 0, '1', '/0/2/4/41/', '查询公司', 'F', '', '', '/api/company', '', 'sys:company:query', 0, 1, 1, NOW(), NOW());
  36. -- 2-2-2. 新增公司
  37. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  38. (42, 4, 1, '1', '/0/2/4/42/', '新增公司', 'F', '', '', '/api/company', '', 'sys:company:add', 0, 1, 1, NOW(), NOW());
  39. -- 2-2-3. 编辑公司
  40. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  41. (43, 4, 2, '1', '/0/2/4/43/', '编辑公司', 'F', '', '', '/api/company', '', 'sys:company:edit', 0, 1, 1, NOW(), NOW());
  42. -- 2-2-4. 删除公司
  43. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  44. (44, 4, 3, '1', '/0/2/4/44/', '删除公司', 'F', '', '', '/api/company', '', 'sys:company:delete', 0, 1, 1, NOW(), NOW());
  45. -- 2-2-5. 导入公司
  46. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  47. (45, 4, 4, '1', '/0/2/4/45/', '导入公司', 'F', '', '', '/api/company/import-third-tree', '', 'sys:company:import', 0, 1, 1, NOW(), NOW());
  48. -- 2-3. 岗位管理
  49. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  50. (5, 2, 2, '1', '/0/2/5/', '岗位管理', 'C', 'icon-gangwei', 'views/system/PostManagement', '/api/post', 'PostManagement', '', 0, 1, 1, NOW(), NOW());
  51. -- 2-3-1. 查询岗位
  52. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  53. (51, 5, 0, '1', '/0/2/5/51/', '查询岗位', 'F', '', '', '/api/post', '', 'sys:post:query', 0, 1, 1, NOW(), NOW());
  54. -- 2-3-2. 新增岗位
  55. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  56. (52, 5, 1, '1', '/0/2/5/52/', '新增岗位', 'F', '', '', '/api/post', '', 'sys:post:add', 0, 1, 1, NOW(), NOW());
  57. -- 2-3-3. 编辑岗位
  58. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  59. (53, 5, 2, '1', '/0/2/5/53/', '编辑岗位', 'F', '', '', '/api/post', '', 'sys:post:edit', 0, 1, 1, NOW(), NOW());
  60. -- 2-3-4. 删除岗位
  61. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  62. (54, 5, 3, '1', '/0/2/5/54/', '删除岗位', 'F', '', '', '/api/post', '', 'sys:post:delete', 0, 1, 1, NOW(), NOW());
  63. -- 2-3-5. 分配权限
  64. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  65. (55, 5, 4, '1', '/0/2/5/55/', '分配权限', 'F', '', '', '/api/post/menu-tree', '', 'sys:post:perm', 0, 1, 1, NOW(), NOW());
  66. -- ==================== 一级菜单(续)====================
  67. -- 3. 用户管理(普通管理员版)
  68. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  69. (6, 0, 2, '1', '/0/6/', '用户管理', 'C', 'icon-yonghuguanli', 'views/system/UserManagement', '/api/sys-user', 'UserManagement', '', 0, 1, 1, NOW(), NOW());
  70. -- 3-1. 查询用户
  71. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  72. (61, 6, 0, '1', '/0/6/61/', '查询用户', 'F', '', '', '/api/sys-user', '', 'sys:user:query', 0, 1, 1, NOW(), NOW());
  73. -- 3-2. 新增用户
  74. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  75. (62, 6, 1, '1', '/0/6/62/', '新增用户', 'F', '', '', '/api/sys-user', '', 'sys:user:add', 0, 1, 1, NOW(), NOW());
  76. -- 3-3. 编辑用户
  77. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  78. (63, 6, 2, '1', '/0/6/63/', '编辑用户', 'F', '', '', '/api/sys-user', '', 'sys:user:edit', 0, 1, 1, NOW(), NOW());
  79. -- 3-4. 删除用户
  80. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  81. (64, 6, 3, '1', '/0/6/64/', '删除用户', 'F', '', '', '/api/sys-user', '', 'sys:user:delete', 0, 1, 1, NOW(), NOW());
  82. -- 4. 外部客户管理
  83. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  84. (7, 0, 3, '1', '/0/7/', '外部客户管理', 'C', 'icon-kehu', 'views/system/ClientManagement', '/api/customer', 'ClientManagement', '', 0, 1, 1, NOW(), NOW());
  85. -- 5. 车辆管理
  86. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  87. (8, 0, 4, '1', '/0/8/', '车辆管理', 'C', 'icon-cheliang', 'views/system/VehicleManagement', '/api/car', 'VehicleManagement', '', 0, 1, 1, NOW(), NOW());
  88. -- 6. 患者薄管理
  89. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  90. (9, 0, 5, '1', '/0/9/', '患者薄管理', 'C', 'icon-cangku', 'views/system/addressBook', '/api/address', 'addressBook', '', 0, 1, 1, NOW(), NOW());
  91. -- 7. 门店管理
  92. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  93. (10, 0, 6, '1', '/0/10/', '门店管理', 'C', 'icon-yaodian', 'views/IceCreamFreezer/storeManagement', '/api/warehouse', 'storeManagement', '', 0, 1, 1, NOW(), NOW());
  94. -- 8. 设备定位
  95. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  96. (11, 0, 7, '1', '/0/11/', '设备定位', 'C', 'icon-trace', 'views/page/incubatorView', '/api/device', 'incubatorView', '', 0, 1, 1, NOW(), NOW());
  97. -- 9. 设备管理(目录)
  98. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  99. (12, 0, 8, '1', '/0/12/', '设备管理', 'M', 'icon-yundan', '', '', 'IceCreamFreezer', '', 0, 1, 1, NOW(), NOW());
  100. -- 9-1. 冰排管理
  101. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  102. (121, 12, 0, '1', '/0/12/121/', '冰排管理', 'C', 'icon-bingpaiguanli', 'views/IceCreamFreezer/IceManagement', '/api/ice-raft', 'IceManagement', '', 0, 1, 1, NOW(), NOW());
  103. -- 9-2. 冰排追溯管理
  104. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  105. (122, 12, 1, '1', '/0/12/122/', '冰排追溯管理', 'C', 'icon-iceTracing', 'views/IceCreamFreezer/IceTracingManagement', '/api/ice-raft-record', 'IceTracingManagement', '', 0, 1, 1, NOW(), NOW());
  106. -- 9-3. 保温箱管理
  107. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  108. (123, 12, 2, '1', '/0/12/123/', '保温箱管理', 'C', 'icon-baowenxiangguanli', 'views/incubator/IncubatorManagement', '/api/cooler-box', 'IncubatorManagement', '', 0, 1, 1, NOW(), NOW());
  109. -- 9-4. 保温箱追溯
  110. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  111. (124, 12, 3, '1', '/0/12/124/', '保温箱追溯', 'C', 'icon-trace', 'views/incubator/IncubatorTraceability', '/api/cooler-box', 'IncubatorTraceability', '', 0, 1, 1, NOW(), NOW());
  112. -- 9-5. 冷冻柜管理
  113. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  114. (125, 12, 4, '1', '/0/12/125/', '冷冻柜管理', 'C', 'icon-binggui', 'views/IceCreamFreezer/FreezerManagement', '/api/ice-locker', 'FreezerManagement', '', 0, 1, 1, NOW(), NOW());
  115. -- 10. 订单管理(目录)
  116. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  117. (13, 0, 9, '1', '/0/13/', '订单管理', 'M', 'icon-yundan', '', '', 'OrderManagement', '', 0, 1, 1, NOW(), NOW());
  118. -- 10-1. 未确定订单
  119. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  120. (131, 13, 0, '1', '/0/13/131/', '未确定订单', 'C', 'icon-yueduye-mulu', 'views/OrderManagement/uncertainOrder', '/api/waybill', 'uncertainOrder', '', 0, 1, 1, NOW(), NOW());
  121. -- 10-2. 待审核订单
  122. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  123. (132, 13, 1, '1', '/0/13/132/', '待审核订单', 'C', 'icon-daishenhe', 'views/OrderManagement/reviewedOrder', '/api/waybill', 'reviewedOrder', '', 0, 1, 1, NOW(), NOW());
  124. -- 10-3. 待取药装箱
  125. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  126. (133, 13, 2, '1', '/0/13/133/', '待取药装箱', 'C', 'icon-daipeisong', 'views/OrderManagement/packingOrder', '/api/waybill', 'packingOrder', '', 0, 1, 1, NOW(), NOW());
  127. -- 10-4. 待配送订单(原133→138)
  128. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  129. (134, 13, 3, '1', '/0/13/138/', '待配送订单', 'C', 'icon-daipeisong', 'views/OrderManagement/pendingOrder', '/api/waybill', 'pendingOrder', '', 0, 1, 1, NOW(), NOW());
  130. -- 10-5. 配送中订单(原134→139)
  131. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  132. (135, 13, 4, '1', '/0/13/139/', '配送中订单', 'C', 'icon-peisongzhong', 'views/OrderManagement/deliveryOrder', '/api/waybill', 'deliveryOrder', '', 0, 1, 1, NOW(), NOW());
  133. -- 10-6. 已完成订单(原135→140)
  134. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  135. (136, 13, 5, '1', '/0/13/140/', '已完成订单', 'C', 'icon-yiwanchengdingdan', 'views/OrderManagement/completedOrder', '/api/waybill', 'completedOrder', '', 0, 1, 1, NOW(), NOW());
  136. -- 10-7. 已取消订单(原136→141)
  137. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  138. (137, 13, 6, '1', '/0/13/141/', '已取消订单', 'C', 'icon-yiquxiaodingdan', 'views/OrderManagement/cancelledOrder', '/api/waybill', 'cancelledOrder', '', 0, 1, 1, NOW(), NOW());
  139. -- 10-8. 已拒收订单(原137→142)
  140. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  141. (138, 13, 7, '1', '/0/13/142/', '已拒收订单', 'C', 'icon-yiquxiaodingdan', 'views/OrderManagement/rejectionOrder', '/api/waybill', 'rejectionOrder', '', 0, 1, 1, NOW(), NOW());
  142. -- 11. 订单审核
  143. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  144. (14, 0, 10, '1', '/0/14/', '订单审核', 'C', 'icon-dingdanshenhe', 'views/OrderManagement/OrderReview', '/api/waybill', 'OrderReview', '', 0, 1, 1, NOW(), NOW());
  145. -- 12. 日志管理(目录)
  146. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  147. (15, 0, 11, '1', '/0/15/', '日志管理', 'M', 'icon-rizhi', '', '', 'LogManagement', '', 0, 1, 1, NOW(), NOW());
  148. -- 12-1. 登录日志
  149. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  150. (151, 15, 0, '1', '/0/15/151/', '登录日志', 'C', 'icon-denglu', 'views/system/', '/api/sys-login-log', 'SysLoginLog', '', 0, 1, 1, NOW(), NOW());
  151. -- 12-2. 操作日志
  152. INSERT INTO `sys_menu` (`id`, `parent_id`, `sort`, `visible`, `menu_path`, `title`, `menu_type`, `icon`, `component`, `path`, `name`, `permission`, `is_dept`, `create_by`, `update_by`, `created_at`, `updated_at`) VALUES
  153. (152, 15, 1, '1', '/0/15/152/', '操作日志', 'C', 'icon-caozuo', 'views/system/', '/api/sys-opera-log', 'SysOperaLog', '', 0, 1, 1, NOW(), NOW());