11_init_menu.sql 2.3 KB

12345678910111213141516171819202122232425262728293031323334
  1. TRUNCATE TABLE sys_resource;
  2. INSERT INTO sys_resource
  3. (`resource_id`,`resource_name`, `resource_code`, `resource_type`,`resource_url`,`parent_resource_id`,`is_show`,`menu_order`)
  4. VALUES
  5. (1, '系统管理','system', 'M', '#', 0, 1, 1),
  6. (2, '部门人员','staff', 'M', '#', 0, 1, 2),
  7. (3, '生产管理', 'message', 'M', '#', 0, 1, 3),
  8. (6, '产量统计', 'bus', 'M', '#', 0, 1, 6),
  9. (9, '日志管理','log', 'M', '#', 0, 1, 8),
  10. -- 1系统管理
  11. (11, '角色管理', 'sysRole.listPage', 'M', '/server/sysRole/listPage', 1, 1, 11),
  12. (12, '用户管理', 'sysUser.listPage', 'M', '/server/sysUser/listPage', 1, 1, 12),
  13. -- 2部门管理
  14. (21, '部门管理', 'oaDepartment.listPage', 'M', '/server/oaDepartment/listPage', 2, 1, 21),
  15. (22, '职工管理', 'oaStaff.listPage', 'M', '/server/oaStaff/listPage', 2, 1, 22),
  16. -- 3生产管理
  17. (31, '产线设置', 'fcFlow.listPage', 'M', '/server/fcFlow/listPage', 3, 1, 31),
  18. (32, '采集端设置', 'epConfig.listPage', 'M', '/server/epConfig/listPage', 3, 1, 32),
  19. (33, '控制板设置', 'epBoardSpot.listPage', 'M', '/server/epBoardSpot/listPage', 3, 1, 33),
  20. (34, '时间段设置', 'fcWorkPeriod.listPage', 'M', '/server/fcWorkPeriod/listPage', 3, 1, 34),
  21. -- 6产量统计
  22. (61, '实时产量', 'fcWorkScheduleLoad.listPage', 'M', '/server/fcWorkScheduleLoad/listPage', 6, 1, 61),
  23. (62, '过程数据', 'fcWorkRaw.listPage', 'M', '/server/fcWorkRaw/listPage', 6, 1, 62),
  24. (63, '班次结算', 'fcWorkScheduleOutcome.listPage', 'M', '/server/fcWorkScheduleOutcome/listPage', 6, 1, 63),
  25. (64, '工人日结', 'fcBiWorkerDaily.listPage', 'M', '/server/fcBiWorkerDaily/listPage', 6, 1, 64),
  26. (65, '产线日结', 'fcBiFlowDaily.listPage', 'M', '/server/fcBiFlowDaily/listPage', 6, 1, 65),
  27. (66, '工厂日结', 'fcBiFactoryDaily.listPage', 'M', '/server/fcBiFactoryDaily/listPage', 6, 1, 66),
  28. (67, '工作点日结', 'fcBiBoardDaily.listPage', 'M', '/server/fcBiBoardDaily/listPage', 6, 1, 67),
  29. -- 9日志管理
  30. (91, '操作日志', 'sysVisitLog.listPage', 'M', '/server/sysVisitLog/listPage', 9, 1, 91),
  31. (92, '生产事件', 'fcWorkScheduleEvent.listPage', 'M', '/server/fcWorkScheduleEvent/listPage', 9, 1, 92),
  32. (93, '运行事件', 'fcSystemEvent.listPage', 'M', '/server/fcSystemEvent/listPage', 9, 1, 93),
  33. (94, '班次日志', 'fcWorkSchedule.listPage', 'M', '/server/fcWorkSchedule/listPage', 9, 1, 94);