123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208 |
- -- ----------------------------
- -- Records of fmea_permission
- -- ----------------------------
- INSERT INTO `fmea_permission` VALUES (1, '首页', 'dashboard', '/dashboard', NULL, '01', 0, 0, '2021-04-01 16:39:42', NULL, '2021-04-01 16:39:42', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (2, '工作台', 'workbench', NULL, NULL, '01', 1, 0, '2021-04-01 16:39:49', 1, '2021-04-01 16:39:49', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (3, '我的项目', 'fmea:project:list', '/fmea/project/list', '/rdfmMyProject/getMyProjectPageList.do', '01', 2, 0, '2020-10-11 16:22:33', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (4, '我的DFMEA', 'fmea:dfmea:my:list', '/fmea/dfmea/list', '/projectDFMEA/getProjectDFMEAPageList.do', '01', 0, 126, '2021-04-01 16:07:44', 1, '2021-04-01 16:07:44', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (5, '我的Master FMEA', 'fmea:master:my:list', '/fmea/master/list', '/masterFMEA/getMasterDFMEAPageList.do', '01', 0, 128, '2021-04-01 16:07:42', 1, '2021-04-01 16:07:42', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (6, '报表中心', 'report', NULL, NULL, '01', 5, 0, '2021-04-01 16:39:28', 1, '2021-04-01 16:39:28', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (7, '知识库', 'settings:library:list', NULL, NULL, '01', 6, 0, '2020-10-11 16:22:33', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (9, '系统设置', 'settings:system:list', NULL, NULL, '01', 8, 0, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (11, '待办任务', 'workbench:todo:list', '/workbench/todo/list', '/sysTask/getSysTaskPageList.do', '01', 1, 2, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (12, '已办任务', 'workbench:done:list', '/workbench/done/list', '/sysTask/getSysTaskPageList.do', '01', 2, 2, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (13, '车辆失效报告', 'workbench:carFailureReport:list', '/workbench/carFailureReport/list', '/failreport/list.do', '01', 3, 2, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (14, '项目报表', 'report:projectreport:index', '/report/projectreport/index', NULL, '01', 0, 6, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (15, 'Master FMEA报表', 'report:masterfmeareport:index', '/report/masterfmeareport/index', NULL, '01', 1, 6, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (16, '月度报表', 'report:master:index', '/report/master/index', NULL, '01', 2, 6, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (17, '访问报表', 'report:visit:index', '/report/visit/index', NULL, '01', 3, 6, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (18, '历史失效案例库', 'library:historyCase:list', '/library/historyCase/list', '/historyfail/list.do', '02', 0, 7, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (24, '用户管理', 'setmanager:user:list', '', NULL, '02', 7, 9, '2021-04-21 14:58:33', 1, '2021-04-21 14:58:33', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (25, '项目信息管理', 'setmanager:project:list', '/setmanager/project/list', NULL, '02', 3, 9, '2021-04-21 14:47:58', 1, '2021-04-21 14:47:58', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (26, '权限分配', 'setmanager:fun:list', '', NULL, '02', 6, 9, '2021-04-21 14:58:28', 1, '2021-04-21 14:58:28', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (27, '权限管理', 'setmanager:auth:list', NULL, NULL, '02', 5, 9, '2021-04-22 16:36:52', 1, '2021-04-22 16:36:52', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (28, 'svpps管理', 'setmanager:svpps', '/setmanager/svpps/list', NULL, '02', 4, 9, '2021-04-21 15:04:17', 1, '2021-04-21 15:04:17', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (31, '页面', 'workbench:todo:list:search', NULL, NULL, '03', 0, 11, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (32, '进入', 'workbench:todo:list:edit', NULL, NULL, '03', 1, 11, '2021-04-21 13:40:19', 1, '2021-04-21 13:40:19', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (33, '页面', 'workbench:done:list:search', NULL, NULL, '03', 0, 12, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (34, '查看', 'workbench:done:list:view', NULL, NULL, '03', 1, 12, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (35, '页面', 'workbench:carFailureReport:list:search', NULL, NULL, '03', 0, 13, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (36, '新建', 'workbench:carFailureReport:list:create', NULL, NULL, '03', 1, 13, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (37, '编辑', 'workbench:carFailureReport:list:edit', NULL, NULL, '03', 2, 13, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (38, '查看', 'workbench:carFailureReport:list:view', NULL, NULL, '03', 3, 13, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (39, '页面', 'fmea:project:list:search', NULL, NULL, '03', 0, 3, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (40, '新建整车项目', 'fmea:project:list:create:car', NULL, NULL, '03', 1, 3, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (41, '新建PT&JN项目', 'fmea:project:list:create:pt', NULL, NULL, '03', 2, 3, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (43, '查看', 'fmea:project:list:view', NULL, NULL, '03', 4, 3, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (44, '页面', 'fmea:dfmea:my:list:search', NULL, NULL, '03', 0, 4, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (45, '新建', 'fmea:dfmea:my:list:create', NULL, NULL, '03', 1, 4, '2021-04-01 16:12:44', 1, '2021-04-01 16:12:44', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (46, '编制(七步法)', 'fmea:dfmea:my:list:fe', NULL, NULL, '03', 2, 4, '2021-04-21 14:17:14', 1, '2021-04-21 14:17:14', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (47, '延期申请', 'fmea:dfmea:my:list:delay', NULL, NULL, '03', 3, 4, '2021-04-21 14:17:44', 1, '2021-04-21 14:17:44', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (49, '查看', 'fmea:dfmea:my:list:view:fe', NULL, NULL, '03', 5, 4, '2021-04-21 14:17:27', 1, '2021-04-21 14:17:27', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (50, '页面', 'fmea:master:my:list:search', NULL, NULL, '03', 0, 5, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (51, '新建', 'fmea:master:my:list:create', NULL, NULL, '03', 1, 5, '2021-04-01 16:36:08', 1, '2021-04-01 16:36:08', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (53, '编制(七步法)', 'fmea:master:my:list:fe', NULL, NULL, '03', 3, 5, '2021-04-21 14:26:00', 1, '2021-04-21 14:26:00', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (54, '查看', 'fmea:master:my:list:view:fe', NULL, NULL, '03', 4, 5, '2021-04-21 14:25:50', 1, '2021-04-21 14:25:50', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (55, '页面', 'report:projectreport:index:search', NULL, NULL, '03', 0, 14, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (56, '查看', 'report:projectreport:index:view', NULL, NULL, '03', 1, 14, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (57, '查看', 'report:masterfmeareport:view', NULL, NULL, '03', 0, 15, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (58, '页面', 'report:master:index:search', NULL, NULL, '03', 0, 16, '2021-04-22 16:17:55', 1, '2021-04-22 16:17:55', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (59, '查看', 'report:master:index:view', NULL, NULL, '03', 0, 16, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (60, '查看', 'report:visit:index:view', NULL, NULL, '03', 0, 17, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (61, '页面', 'library:historyCase:list:search', NULL, NULL, '03', 0, 18, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (62, '查看', 'library:historyCase:list:view', NULL, NULL, '03', 1, 18, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (75, '页面', 'setmanager:project:detail:search', NULL, NULL, '03', 0, 25, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (76, '查看', 'setmanager:project:detail:view', NULL, NULL, '03', 1, 25, '2020-11-02 00:15:54', 1, '2020-11-02 00:15:54', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (77, '删除', 'fmea:master:my:list:delete', NULL, NULL, '03', 5, 5, '2021-04-01 16:36:16', 1, '2021-04-01 16:36:16', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (81, '编辑', 'fmeamanager:ap:list:edit', NULL, NULL, '03', 5, 22, '2020-11-02 00:15:54', 1, '2020-11-02 00:15:54', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (82, '同步', 'setmanager:project:detail:sync', NULL, NULL, '03', 2, 25, '2020-11-02 00:15:54', 1, '2020-11-02 00:15:54', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (83, '整车项目', 'setmanager:project:detail:vpm', NULL, NULL, '03', 3, 25, '2021-04-21 15:02:38', 1, '2021-04-21 15:02:38', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (84, 'PT&JN项目', 'setmanager:project:detail:pt', NULL, NULL, '03', 4, 25, '2021-04-21 15:02:33', 1, '2021-04-21 15:02:33', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (85, '删除', 'workbench:carFailureReport:list:delete', NULL, NULL, '03', 4, 13, '2020-11-02 00:15:54', 1, '2020-11-02 00:15:54', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (86, '删除', 'fmea:dfmea:my:list:delete', NULL, NULL, '03', 6, 4, '2021-04-01 16:12:57', 1, '2021-04-01 16:12:57', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (126, '项目DFMEA', 'fmea:dfmea', NULL, NULL, '01', 3, 0, '2021-03-22 16:06:36', 1, '2021-03-22 16:06:36', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (127, '所有DFMEA', 'fmea:dfmea:all:list', NULL, NULL, '01', 1, 126, '2021-04-01 15:59:25', 1, '2021-04-01 15:59:25', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (128, 'MASTER-FMEA', 'fmea:master', NULL, NULL, '01', 4, 0, '2021-03-22 16:07:03', 1, '2021-03-22 16:07:03', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (129, '所有MASTER-FMEA', 'fmea:master:all:list', NULL, NULL, '01', 1, 128, '2021-04-01 16:06:18', 1, '2021-04-01 16:06:18', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (131, '提交审批', 'fmea:dfmea:my:list:submit', NULL, NULL, '03', 7, 4, '2021-04-01 16:12:36', 1, '2021-04-01 16:12:36', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (132, '页面', 'fmea:dfmea:all:list:search', NULL, NULL, '03', 0, 127, '2021-04-21 13:43:25', 1, '2021-04-21 13:43:25', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (133, '查看', 'fmea:dfmea:all:list:view', NULL, NULL, '03', 1, 127, '2021-04-01 16:03:52', 1, NULL, NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (134, '激活', 'fmea:dfmea:all:list:act', NULL, NULL, '03', 2, 127, '2021-04-01 16:04:25', 1, '2021-04-01 16:04:32', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (135, '页面', 'fmea:master:all:list:search', NULL, NULL, '03', 0, 129, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (136, '查看', 'fmea:master:all:list:view', NULL, NULL, '03', 1, 129, '2021-04-01 16:38:26', 1, '2021-04-01 16:38:26', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (137, '代理', 'setmanager:allow', NULL, NULL, '02', 8, 9, '2021-07-28 18:04:44', 1, '2021-07-28 18:04:44', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (138, '权限转移', 'setmanager:transfer', NULL, NULL, '02', 9, 9, '2021-07-28 18:04:46', 1, '2021-07-28 18:04:46', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (139, '新建', 'setmanager:auth:list:create', NULL, NULL, '03', 0, 27, '2021-04-28 15:58:09', 1, '2021-04-28 15:58:09', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (140, '编辑', 'setmanager:auth:list:edit', NULL, NULL, '03', 1, 27, '2021-04-01 17:01:52', 1, '2021-04-01 17:01:52', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (141, '配置', 'setmanager:auth:list:setting', NULL, NULL, '03', 2, 27, '2021-04-01 17:01:53', 1, '2021-04-01 17:01:53', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (142, '删除', 'setmanager:auth:list:delete', NULL, NULL, '03', 3, 27, '2021-04-01 17:01:56', 1, '2021-04-01 17:01:56', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (143, '页面', 'setmanager:fun:list:search', NULL, NULL, '03', 0, 26, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (144, '按人员', 'setmanager:fun:list:user', NULL, NULL, '03', 1, 26, '2021-04-21 15:05:07', 1, '2021-04-21 15:05:07', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (145, '按角色', 'setmanager:fun:list:role', NULL, NULL, '03', 2, 26, '2021-04-21 15:05:10', 1, '2021-04-21 15:05:10', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (146, '按规则', 'setmanager:fun:list:rule', NULL, NULL, '03', 3, 26, '2021-04-21 15:05:15', 1, '2021-04-21 15:05:15', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (147, '页面', 'setmanager:user:list:search', NULL, NULL, '03', 0, 24, '2021-04-21 13:30:21', 1, '2021-04-21 13:30:21', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (148, '导出', 'setmanager:user:list:export', NULL, NULL, '03', 0, 24, '2021-04-01 16:59:45', 1, '2021-04-01 16:59:45', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (152, '查看范围(全部)', 'fmea:master:all:list:data:all', NULL, NULL, '04', 0, 129, '2021-04-21 14:28:49', 1, '2021-04-21 14:28:49', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (153, '查看范围(本部门)', 'fmea:master:all:list:data:org', NULL, NULL, '04', 1, 129, '2021-04-21 14:27:03', 1, '2021-04-21 14:27:03', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (155, '查看范围(全部)', 'fmea:dfmea:all:list:data:all', NULL, NULL, '04', 4, 127, '2021-04-21 14:27:27', 1, '2021-04-21 14:27:27', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (156, '查看范围(本部门)', 'fmea:dfmea:all:list:data:org', NULL, NULL, '04', 5, 127, '2021-04-21 14:27:39', 1, '2021-04-21 14:27:39', NULL, 1, 0);
- INSERT INTO `fmea_permission` VALUES (159, '评审意见', 'fmea:master:my:list:comment', NULL, NULL, '03', 6, 5, '2021-04-12 13:32:20', 1, '2021-04-12 13:32:20', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (160, '评审意见', 'fmea:master:all:list:comment', NULL, NULL, '03', 2, 129, '2021-04-12 11:24:53', 1, '2021-04-12 11:24:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (162, '评审意见', 'fmea:dfmea:my:list:comment', NULL, NULL, '03', 7, 4, '2021-04-12 13:48:37', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (163, '评审意见', 'fmea:dfmea:all:list:comment', NULL, NULL, '03', 3, 127, '2021-04-12 13:48:37', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (164, '转移他人权限', 'setmanager:transfer:other', NULL, NULL, '03', 1, 138, '2021-07-28 18:04:26', 1, '2021-07-28 18:04:26', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (165, '已读消息', 'workbench:message:read', NULL, NULL, '02', 4, 2, '2021-04-21 13:59:56', 1, '2021-04-21 13:59:56', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (166, '页面', 'workbench:message:read:list', NULL, NULL, '03', 0, 165, '2021-04-21 14:00:14', 1, '2021-04-21 14:00:14', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (167, '查看', 'workbench:message:read:list:view', NULL, NULL, '03', 1, 165, '2021-04-21 13:59:32', 1, '2021-04-21 13:59:32', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (168, '未读消息', 'workbench:message:unread', NULL, NULL, '02', 5, 2, '2021-04-21 14:00:49', 1, '2021-04-21 14:00:49', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (169, '页面', 'workbench:message:unread:list', NULL, NULL, '03', 0, 168, '2021-04-21 14:01:23', 1, '2021-04-21 14:01:23', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (170, '查看', 'workbench:message:unread:list:view', NULL, NULL, '03', 1, 168, '2021-04-21 14:02:35', 1, '2021-04-21 14:02:35', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (171, '核实', 'workbench:carFailureReport:list:check', NULL, NULL, '03', 5, 13, '2021-05-14 10:58:22', 1, '2021-05-14 10:58:22', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (173, '查看范围(本部门)', 'workbench:carFailureReport:list:data:org', NULL, NULL, '04', 7, 13, '2021-04-21 14:08:53', 1, '2021-04-21 14:08:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (174, '查看范围(全部)', 'workbench:carFailureReport:list:data:all', NULL, NULL, '04', 8, 13, '2021-04-21 14:09:02', 1, '2021-04-21 14:09:02', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (175, '编辑整车项目', 'fmea:project:list:edit:car', NULL, NULL, '03', 6, 3, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (176, '编辑PT&JN项目', 'fmea:project:list:edit:pt', NULL, NULL, '03', 7, 3, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (177, '查看范围(本部门)', 'report:projectreport:index:data:org', NULL, NULL, '04', 2, 14, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (178, '查看范围(全部)', 'report:projectreport:index:data:all', NULL, NULL, '04', 3, 14, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (179, '查看范围(本部门)', 'report:masterfmeareport:data:org', NULL, NULL, '04', 1, 15, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (180, '查看范围(全部)', 'report:masterfmeareport:data:all', NULL, NULL, '04', 2, 15, '2020-11-02 00:15:53', 1, '2020-11-02 00:15:53', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (181, '查看范围(本部门)', 'library:historyCase:list:data:org', NULL, NULL, '04', 2, 18, '2021-04-21 14:38:32', 1, '2021-04-21 14:38:32', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (182, '查看范围(全部)', 'library:historyCase:list:data:all', NULL, NULL, '04', 3, 18, '2021-04-21 14:38:37', 1, '2021-04-21 14:38:37', NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (191, '页面', 'setmanager:svpps:list', '', NULL, '03', 0, 28, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (192, '查看', 'setmanager:svpps:view', '', NULL, '03', 1, 28, '2020-10-11 16:22:34', 1, NULL, NULL, NULL, 0);
- INSERT INTO `fmea_permission` VALUES (193, '开启代理', 'setmanager:allow:open', NULL, NULL, '03', 0, 137, '2021-07-28 18:04:27', 1, '2021-07-28 18:04:27', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (194, '关闭代理', 'setmanager:allow:close', NULL, NULL, '03', 1, 137, '2021-07-28 18:04:28', 1, '2021-07-28 18:04:28', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (195, '转移自己权限', 'setmanager:transfer:my', NULL, NULL, '03', 0, 138, '2021-07-28 18:04:29', 1, '2021-07-28 18:04:29', NULL, NULL, 1);
- INSERT INTO `fmea_permission` VALUES (196, '帮助文档', 'setmanager:help:doc', NULL, NULL, '02', 0, 9, '2021-07-28 10:23:38', 1, '2021-07-28 10:23:41', NULL, NULL, 0);
- -- ----------------------------
- -- Records of sys_role
- -- ----------------------------
- INSERT INTO `sys_role` VALUES (1, 1, 'bpm_manager', '业务管理员', '业务管理员', 1, 1, 1, NULL, '1', NULL, NULL, 10000037840184, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '000000');
- -- ----------------------------
- -- Records of sys_user
- -- ----------------------------
- INSERT INTO `sys_user` VALUES (1, '超级管理员', 'admin', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2010-12-01 00:00:00', 1, 'yg_zhangyg@126.com', '13580000000', '020-61151619', 1, NULL, NULL, NULL);
- INSERT INTO `sys_user` VALUES (2, '测试账号', 'test1', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@111.com', '13213231231', '123-12312312', 1, NULL, NULL, NULL);
- INSERT INTO `sys_user` VALUES (3, '测试账号2', 'test2', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@222.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:13:57');
- INSERT INTO `sys_user` VALUES (4, 'DFMEA辅导员', 'test3', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@333.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:14:23');
- INSERT INTO `sys_user` VALUES (5, '系统经理', 'test4', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@444.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:14:39');
- INSERT INTO `sys_user` VALUES (6, 'VSE', 'test5', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@555.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:15:00');
- INSERT INTO `sys_user` VALUES (7, 'PQM', 'test6', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@666.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:15:20');
- INSERT INTO `sys_user` VALUES (8, '业务管理员', 'test7', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@777.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:15:38');
- INSERT INTO `sys_user` VALUES (9, '高级经理', 'test8', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@888.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:16:01');
- INSERT INTO `sys_user` VALUES (10, '测试账号9', 'test9', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@999.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:16:21');
- INSERT INTO `sys_user` VALUES (11, '高级领导', 'test10', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@101010.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:16:41');
- INSERT INTO `sys_user` VALUES (12, 'FMEA工具工程师', 'test11', 'c4ca4238a0b923820dcc509a6f75849b', 0, 0, '2021-07-19 13:34:08', 1, 'test@111111.com', '13213231231', '123-12312312', 1, '', '', '2021-07-19 14:16:41');
- -- ----------------------------
- -- Records of sys_user_org
- -- ----------------------------
- INSERT INTO `sys_user_org` VALUES (1, 1004, 2);
- INSERT INTO `sys_user_org` VALUES (2, 1004, 3);
- INSERT INTO `sys_user_org` VALUES (3, 1004, 4);
- INSERT INTO `sys_user_org` VALUES (4, 1004, 5);
- INSERT INTO `sys_user_org` VALUES (5, 1004, 6);
- INSERT INTO `sys_user_org` VALUES (6, 1004, 7);
- INSERT INTO `sys_user_org` VALUES (7, 1004, 8);
- INSERT INTO `sys_user_org` VALUES (8, 1004, 9);
- INSERT INTO `sys_user_org` VALUES (9, 1004, 10);
- INSERT INTO `sys_user_org` VALUES (10, 1004, 11);
- INSERT INTO `sys_user_org` VALUES (11, 1004, 12);
- -- ----------------------------
- -- Records of sys_user_role
- -- ----------------------------
- INSERT INTO `sys_user_role` VALUES (1, 1, 1);
- -- ----------------------------
- -- Records of fmea_role
- -- ----------------------------
- INSERT INTO `fmea_role` VALUES (1, '1', '系统管理员', '主要对系统用户、角色功能进行管理', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (2, '2', '业务管理员(EQ)', '主要对用户角色关系进行管理,对我的项目、DFMEA、Master FMEA进行创建、编制、查看及对报表进行查看', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (3, '3', 'FMEA工具工程师', '主要对我的项目、DFMEA、Master FMEA进行创建、编制、查看及对报表进行查看', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (4, '4', 'DFMEA辅导员', '主要对DFMEA的查看、手动触发TG2及之后的归档版本的升级', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (5, '5', 'FO', '主要对Master FMEA的创建、编制、审核', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (6, '6', 'VSE', '主要对DFMEA进行查看及报表的查看', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (7, '7', 'PSE', '主要对PT&JN项目的创建、查看、零部件任务的分发。', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (8, '8', 'PQM', '主要对整车项目进行创建、查看、零部件任务的分发。', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (9, '9', '高级领导', '1', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (10, '10', '工程师', '主要对DFMEA进行创建、编制、查看', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (11, '11', '高级经理', '主要对DFMEA进行查看、审批及对DFMEA、Master FMEA、报表的查看', 0, 1, now(), now());
- INSERT INTO `fmea_role` VALUES (12, '12', '系统经理', '待编辑', 0, 1, now(), now());
- -- ----------------------------
- -- Records of fmea_msg_template
- -- ----------------------------
- INSERT INTO `fmea_msg_template` VALUES (1, 16, 1, '01', 'Master FMEA审批', 0, '【审批通知】Master FMEA审批结果', '您提交的Master FMEA【零件系统名称】【FMEA编号】【审批意见】', '审批发起人', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (2, 16, 1, '02', '项目DFMEA归档审批', 0, '【审批通知】项目DFMEA归档审批结果', '您提交的项目DFMEA【零件系统名称】【FMEA编号】【版本】归档审批【审批意见】', '审批发起人', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (3, 16, 1, '03', '“不编制”项目DFMEA', 0, '【审批通知】项目DFMEA不编制审批结果', '您提交的【零件系统名称】不新建DFMEA申请【审批意见】', '发起人', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (4, 16, 0, '07', '超期通知', 0, NULL, '项目DFMEA【零件系统名称】【FMEA编号】完成时间已超过节点时间', '项目DFMEA owner ,部门VSE,PQM', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (5, 16, 0, '06', '到期预警', 0, NULL, '项目DFMEA【零件系统名称】【FMEA编号】完成时间距离节点时间不足7天', '项目DFMEA owner', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (7, 16, 0, '09', '车辆失效报告核实结果', 0, NULL, '您提交的车辆失效报告【车辆失效报告编号】【车型】【问题种类】【失效类型】已核实,审批意见:【审批意见】。', '车辆失效报告提交人', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (9, 16, 0, '04', '项目DFMEA延期审批', 0, NULL, '您提交的项目DFMEA【零件系统名称】【FMEA编号】延期审批【审批意见】', '审批发起人', '2021-02-19 19:22:10', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (10, 16, 1, '11', 'Master FMEA Owner转移', 0, '【Master FMEA系统消息】Master FMEA Owner转移通知', '【转移权限的用户姓名】已将【FMEA编号】的owner变更为您。', '被转移人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (11, 16, 1, '10', 'Master FMEA更新', 0, 'Master FMEA更新', '项目DFMEA【零件系统名称】【FMEA编号】【版本】归档审批已通过,请确认是否需要更新其所引用的Master FMEA【MATSER FMEA零件系统名称】【MATSER FMEA编号】。', 'Master FMEA owner', '2021-03-25 13:59:43', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (12, 16, 1, '12', '项目DFMEA Owner转移', 0, '【DFMEA系统消息】FMEA Owner转移通知', '【转移权限的用户姓名】已将【FMEA编号】的owner变更为您。', '被转移人\r\n(新的FMEA Owner)', '2021-03-25 14:08:36', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (13, 16, 1, '13', '【DFMEA系统消息】权限代理取消通知-发给代理人', 0, '【DFMEA系统消息】代理取消通知', '【被代理权限的用户姓名】已取消邮件、任务、消息代理。', '代理人', '2021-03-25 14:14:47', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (14, 16, 0, '13', '【DFMEA系统消息】权限代理取消通知-发给被代理人', 0, '【DFMEA系统消息】代理取消通知', '您已取消DFMEA系统邮件、任务、消息代理。', '被代理人', '2021-03-25 14:24:42', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (15, 16, 1, '14', '【DFMEA系统消息】权限代理通知-发给代理人', 0, '【DFMEA系统消息】代理通知', '【被代理权限的用户姓名】已将DFMEA系统邮件、任务、消息交由您代理。', '代理人', '2021-03-25 14:26:47', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (16, 16, 0, '14', '【DFMEA系统消息】权限代理通知-发给被代理人', 0, NULL, '您DFMEA系统邮件、任务、消息已交由【代理权限的用户姓名】代理。', '被代理人', '2021-03-25 14:27:50', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (17, 16, 1, '15', '【DFMEA系统消息】系统权限转移通知-本人操作', 0, '【DFMEA系统消息】权限转移通知', '【离岗人】已将DFMEA系统权限转移给您。', '接手人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (18, 16, 1, '15', '【DFMEA系统消息】系统权限转移通知-管理员操作', 0, '【DFMEA系统消息】权限转移通知', '【管理员】已将【离岗人】的DFMEA系统权限转移给您。', '接手人', '2021-03-25 14:31:19', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (19, 16, 0, '16', '零部件通知', 0, NULL, '您有零件【多个零件名称】的零部件任务已被转移到其他工程师。', '原零件工程师', '2021-03-27 13:22:16', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (100, 15, 1, '1', '编制项目DFMEA', 1, '【待办任务】编制项目DFMEA', '您有零件【多个零件名称】需要制定DFMEA计划。', '零件负责人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (101, 15, 1, '2', '项目DFMEA TG1延期申请', 1, '【待办任务】审批项目DFMEA 延期申请', '项目DFMEA【零件系统名称】【FMEA编号】申请延期。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (102, 15, 1, '3', '“不编制”项目DFMEA', 1, '【待办任务】审批项目DFMEA“不编制”申请', '【多个零件名称】申请不编制DFMEA。', '审批者(系统经理)', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (103, 15, 1, '4', '项目DFMEA TG1归档申请', 1, '【待办任务】审批项目DFMEA TG1归档', '项目DFMEA【零件系统名称】【FMEA编号】申请TG1归档。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (104, 15, 1, '5', '审批Master FMEA', 1, '【待办任务】审批Master FMEA', 'Master FMEA【零件系统名称】【FMEA编号】申请审批。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (105, 15, 1, '6', '项目DFMEA EWO更新归档申请', 1, '【待办任务】审批项目DFMEA归档(EWO更新)', '项目DFMEA【零件系统名称】【FMEA编号】申请EWO更新归档。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (106, 15, 1, '7', '项目DFMEA TG2归档申请', 1, '【待办任务】审批项目DFMEA TG2归档', '项目DFMEA【零件系统名称】【FMEA编号】申请TG2归档。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (107, 15, 1, '8', '项目DFMEA TG2延期申请', 1, '【待办任务】审批项目DFMEA 延期申请', '项目DFMEA【零件系统名称】【FMEA编号】申请延期。', '审批人', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (108, 15, 1, '9', '项目DFMEA EWO更新', 0, '【待办任务】更新项目DFMEA(EWO更新)', '由【EWO提交者】提交的EWO【EWO号】已审批通过,该EWO影响了您编制的项目DFMEA【零件系统名称】【FMEA编号】,请与【EWO提交者】协调更新项目DFMEA事宜(如果需要,您可将DFMEA Owner权限转移给【EWO提交者】)。', 'EWO提交者', '2021-02-19 19:22:11', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (109, 15, 1, '10', '项目DFMEA 主动更新归档申请', 1, '【待办任务】审批项目DFMEA归档(主动更新)', '项目DFMEA【零件系统名称】【FMEA编号】申请主动更新归档。', '审批者', '2021-03-25 17:03:40', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (110, 15, 1, '11', '更新项目DFMEA(主动更新)', 1, '【待办任务】更新项目DFMEA(主动更新)', '项目DFMEA【零件系统名称】【FMEA编号】需要更新。', '项目DFMEA Owner', '2021-03-25 17:05:07', NULL, NULL, NULL);
- INSERT INTO `fmea_msg_template` VALUES (111, 15, 1, '12', '核实车辆失效报告', 1, '【待办任务】核实车辆失效报告', '您有一份车辆失效报告待核实:车型:【车型】,问题种类:【问题种类】,失效类型:【失效类型】。', '核实人', '2021-03-25 17:06:09', NULL, NULL, NULL);
|