qc_initv1.3.7.sql 170 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248
  1. use `qc`;
  2. ALTER TABLE `med_qcresult_info` ADD `have_home_page` tinyint(4) DEFAULT '0' COMMENT '是否有病案首页(0:无,1:有)' AFTER `score_res`;
  3. DELETE FROM sys_user_pageset WHERE user_id = -1;
  4. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病历等级', 'level', '1', '1', NULL);
  5. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病历得分', 'scoreRes', '1', '2', NULL);
  6. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病人住院序号', 'behospitalCode', '1', '3', NULL);
  7. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病案号', 'fileCode', '1', '5', NULL);
  8. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病人姓名', 'name', '1', '6', NULL);
  9. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '性别', 'sex', '1', '7', NULL);
  10. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '年龄', 'age', '1', '8', NULL);
  11. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '床号', 'bedCode', '1', '9', NULL);
  12. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '入院日期', 'behospitalDate', '1', '10', NULL);
  13. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '出院日期', 'leaveHospitalDate', '1', '11', NULL);
  14. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '归档日期', 'placefileDate', '1', '12', NULL);
  15. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主诊断', 'diagnose', '1', '13', NULL);
  16. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '住院医生', 'behDoctorName', '1', '14', NULL);
  17. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主管医生', 'doctorName', '1', '15', NULL);
  18. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主任医生', 'directorDoctorName', '1', '16', NULL);
  19. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '科室', 'behDeptName', '1', '17', NULL);
  20. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '评分时间', 'gradeTime', '1', '18', NULL);
  21. INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '核查状态', 'checkStatus', '1', '4', NULL);
  22. -- 找出没有”核查状态“的人员并给加上
  23. INSERT INTO sys_user_pageset
  24. ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`)
  25. SELECT is_deleted,
  26. gmt_create,
  27. gmt_modified,
  28. creator,
  29. MODIFIER,
  30. user_id,
  31. page_type,
  32. CASE WHEN ISNULL(NAME) THEN "核查状态" ELSE "核查状态" END NAME,
  33. CASE WHEN ISNULL(userId) THEN "checkStatus" ELSE "checkStatus" END val,
  34. CASE WHEN ISNULL(STATUS) THEN 0 ELSE 0 END STATUS,
  35. CASE WHEN ISNULL(order_no) THEN 4 ELSE 4 END order_no,
  36. remark
  37. FROM (SELECT * FROM sys_user_pageset WHERE user_id <> -1) b LEFT JOIN (SELECT c.user_id AS userId FROM sys_user_pageset c WHERE user_id <> -1 AND val = "checkStatus") p ON b.user_id = p.userId
  38. WHERE userId IS NULL
  39. GROUP BY user_id ;
  40. -- ----------------------------
  41. -- Table structure for sys_menu
  42. -- ----------------------------
  43. DROP TABLE IF EXISTS `sys_menu`;
  44. CREATE TABLE `sys_menu` (
  45. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  46. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  47. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  48. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  49. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  50. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  51. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单名称',
  52. `parent_id` bigint(20) NOT NULL DEFAULT '-1' COMMENT '-1:表示顶级,其他值表示上级菜单的id',
  53. `code` varchar(255) NOT NULL DEFAULT '' COMMENT '编码,与前端对应',
  54. `show_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否在右侧菜单显示(0:不显示,1:显示)',
  55. `maintain_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否可以维护(0:不可维护,1:可以维护)',
  56. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序,从小到大',
  57. `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  58. PRIMARY KEY (`id`)
  59. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='系统菜单';
  60. -- ----------------------------
  61. -- Records of sys_menu
  62. -- ----------------------------
  63. INSERT INTO `sys_menu` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台', '-1', 'YH-KZT', '1', '1', '-10', '用户-控制台');
  64. INSERT INTO `sys_menu` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '基础数据维护', '-1', 'YH-JCSJWH', '1', '1', '2', '用户-基础数据维护');
  65. INSERT INTO `sys_menu` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案质控', '-1', 'YH-BLZK', '1', '1', '3', '用户-病历质控');
  66. INSERT INTO `sys_menu` VALUES ('4', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '统计分析', '-1', 'YH-TJFX', '1', '1', '4', '用户-统计分析');
  67. INSERT INTO `sys_menu` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模块数据维护', '2', 'YH-JCSJWH-MKSJWH', '1', '1', '1', '用户-基础数据维护-模块数据维护');
  68. INSERT INTO `sys_menu` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目数据维护', '2', 'YH-JCSJWH-TMSJWH', '1', '1', '2', '用户-基础数据维护-条目数据维护');
  69. INSERT INTO `sys_menu` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', '3', 'YH-BLZK-ZKPF', '1', '1', '1', '用户-病历质控-质控评分');
  70. INSERT INTO `sys_menu` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '基础功能', '-1', 'YH-QBYH-JCGN', '0', '1', '0', '用户-基础功能');
  71. INSERT INTO `sys_menu` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(科室)', '3', 'YH-BLZK-ZKPFKS', '1', '1', '2', '用户-病历质控-质控评分(科室)');
  72. INSERT INTO `sys_menu` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(个人)', '3', 'YH-BLZK-ZKPFGR', '1', '1', '3', '用户-病历质控-质控评分(个人)');
  73. INSERT INTO `sys_menu` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '权限管理', '-1', 'YH-QXGL', '1', '0', '5', '用户-权限管理');
  74. INSERT INTO `sys_menu` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户管理', '12', 'YH-QXGL-YHGL', '1', '0', '1', '用户-权限管理-用户管理');
  75. INSERT INTO `sys_menu` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '角色管理', '12', 'YH-QXGL-JSGL', '1', '0', '2', '用户-权限管理-角色管理');
  76. INSERT INTO `sys_menu` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台(科室)', '-1', 'YH-KZTKS', '1', '1', '-9', '用户-控制台(科室)');
  77. INSERT INTO `sys_menu` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '异常数据监控', '-1', 'YH-YCSJJK', '1', '0', '10', '用户-异常数据监控');
  78. INSERT INTO `sys_menu` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '数据报表明细', '-1', 'YH-ZKK', '1', '1', '-8', '用户-质控科');
  79. INSERT INTO `sys_menu` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '数据报表明细(科室)', '-1', 'YH-KSZR', '1', '1', '-7', '用户-科室主任');
  80. INSERT INTO `sys_menu` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比', '17', 'YH-ZKK-GMKQXZB_XQ', '1', '1', '2', '用户-质控科-各模块缺陷占比_详情');
  81. INSERT INTO `sys_menu` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', '17', 'YH-ZKK-TMQXZB_XQ', '1', '1', '3', '用户-质控科-条目缺陷占比_详情');
  82. INSERT INTO `sys_menu` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院天数', '17', 'YH-ZKK-KSPJZYTS_XQ', '1', '1', '4', '用户-质控科-科室平均住院天数_详情');
  83. INSERT INTO `sys_menu` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院花费', '17', 'YH-ZKK-KSPJZYHF_XQ', '1', '1', '5', '用户-质控科-科室平均住院花费_详情');
  84. INSERT INTO `sys_menu` VALUES ('23', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分', '17', 'YH-ZKK-GKSZKPJF_XQ', '1', '1', '6', '用户-质控科-各科室质控平均分_详情');
  85. INSERT INTO `sys_menu` VALUES ('24', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '缺陷详情', '17', 'YH-ZKK-GKSQXZB', '1', '1', '7', '用户-质控科-各科室缺陷占比_详情');
  86. INSERT INTO `sys_menu` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比', '17', 'YH-ZKK-GKSJJBLZB_XQ', '1', '1', '8', '用户-质控科-各科室甲级病历占比_详情');
  87. INSERT INTO `sys_menu` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比', '18', 'YH-KSZR-GMKQXZB_XQ', '1', '1', '2', '用户-科室主任-各模块缺陷占比_详情');
  88. INSERT INTO `sys_menu` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', '18', 'YH-KSZR-TMQXZB_XQ', '1', '1', '3', '用户-科室主任-条目缺陷占比_详情');
  89. INSERT INTO `sys_menu` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', '17', 'YH-ZKK-BASYHGLZB_XQ', '1', '1', '1', '用户-质控科-病案首页合格率占比_详情');
  90. INSERT INTO `sys_menu` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', '18', 'YH-KSZR-BASYHGLZB_XQ', '1', '1', '1', '用户-科室主任-病案首页合格率占比_详情');
  91. INSERT INTO `sys_menu` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室缺陷占比', '18', 'YH-KSZR-KSQXZB_XQ', '1', '1', '4', '用户-科室主任-科室缺陷占比_详情');
  92. INSERT INTO `sys_menu` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', '17', 'YH-ZKK-GKSQXZB_XQ', '1', '1', '9', '用户-质控科-各科室缺陷占比_详情');
  93. INSERT INTO `sys_menu` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控类型维护', '2', 'YH-JCSJWH-ZKLXWH', '1', '0', '3', '用户-基础数据维护-质控类型维护');
  94. INSERT INTO `sys_menu` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(医疗组)', '3', 'YH-BLZK-ZKPFYLZ', '1', '1', '4', '用户-病历质控-质控评分(医疗组)');
  95. INSERT INTO `sys_menu` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比', '17', 'YH-ZKK-GJTMQXZB', '1', '1', '10', '用户-质控科-关键条目缺陷占比');
  96. INSERT INTO `sys_menu` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', '17', 'YH-ZKK-CYRSTJ', '1', '1', '11', '用户-质控科-出院人数统计');
  97. INSERT INTO `sys_menu` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计', '17', 'YH-ZKK-ZKHCTJ', '1', '1', '12', '用户-质控科-质控核查统计');
  98. -- ----------------------------
  99. -- Table structure for sys_menu_permission
  100. -- ----------------------------
  101. DROP TABLE IF EXISTS `sys_menu_permission`;
  102. CREATE TABLE `sys_menu_permission` (
  103. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  104. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  105. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  106. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  107. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  108. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  109. `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  110. `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '系统资源id',
  111. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  112. PRIMARY KEY (`id`)
  113. ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='菜单和系统资源的映射表';
  114. -- ----------------------------
  115. -- Records of sys_menu_permission
  116. -- ----------------------------
  117. INSERT INTO `sys_menu_permission` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '1', '基础功能-获取用户、机构、菜单信息');
  118. INSERT INTO `sys_menu_permission` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '2', '基础功能-修改密码');
  119. INSERT INTO `sys_menu_permission` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '9', '控制台-病历相关统计');
  120. INSERT INTO `sys_menu_permission` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '15', '控制台-缺陷相关统计');
  121. INSERT INTO `sys_menu_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '16', '控制台-医院运营相关统计');
  122. INSERT INTO `sys_menu_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '3', '用户-基础数据维护-获取医院模块数据信息');
  123. INSERT INTO `sys_menu_permission` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '4', '用户-基础数据维护-批量更新模块数据');
  124. INSERT INTO `sys_menu_permission` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '6', '用户-条目数据维护-分页获取医院条目数据信息');
  125. INSERT INTO `sys_menu_permission` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '7', '用户-条目数据维护-修改医院条目数据信息');
  126. INSERT INTO `sys_menu_permission` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '8', '用户-条目数据维护-获取医院模块数据下拉列表');
  127. INSERT INTO `sys_menu_permission` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
  128. INSERT INTO `sys_menu_permission` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '17', '用户-质控评分-评分');
  129. INSERT INTO `sys_menu_permission` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '5', '用户-质控评分-分页');
  130. INSERT INTO `sys_menu_permission` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '11', '用户-质控评分-新增质控条目');
  131. INSERT INTO `sys_menu_permission` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '12', '用户-质控评分-删除质控条目');
  132. INSERT INTO `sys_menu_permission` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '13', '用户-质控评分-修改质控条目');
  133. INSERT INTO `sys_menu_permission` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '14', '用户-质控评分-获取详情');
  134. INSERT INTO `sys_menu_permission` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '31', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息');
  135. INSERT INTO `sys_menu_permission` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '34', '用户-质控评分(科室)-评分');
  136. INSERT INTO `sys_menu_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '32', '用户-质控评分(科室)-分页');
  137. INSERT INTO `sys_menu_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '35', '用户-质控评分(科室)-新增质控条目');
  138. INSERT INTO `sys_menu_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '36', '用户-质控评分(科室)-删除质控条目');
  139. INSERT INTO `sys_menu_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '37', '用户-质控评分(科室)-修改质控条目');
  140. INSERT INTO `sys_menu_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '38', '用户-质控评分(科室)-获取详情');
  141. INSERT INTO `sys_menu_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
  142. INSERT INTO `sys_menu_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '40', '用户-质控评分(个人)-评分');
  143. INSERT INTO `sys_menu_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '33', '用户-质控评分(个人)-分页');
  144. INSERT INTO `sys_menu_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '41', '用户-质控评分(个人)-新增质控条目');
  145. INSERT INTO `sys_menu_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '42', '用户-质控评分(个人)-删除质控条目');
  146. INSERT INTO `sys_menu_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '43', '用户-质控评分(个人)-修改质控条目');
  147. INSERT INTO `sys_menu_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '44', '用户-质控评分(个人)-获取详情');
  148. INSERT INTO `sys_menu_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '45', '控制台-平均住院天数');
  149. INSERT INTO `sys_menu_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '46', '控制台-平均住院费用');
  150. INSERT INTO `sys_menu_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '47', '控制台-质控平均分按科室统计');
  151. INSERT INTO `sys_menu_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '48', '控制台-各科室甲级病历占比');
  152. INSERT INTO `sys_menu_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '49', '控制台-出院人数统计');
  153. INSERT INTO `sys_menu_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '50', '控制台-质控病历统计');
  154. INSERT INTO `sys_menu_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '51', '控制台-各模块缺陷占比排行');
  155. INSERT INTO `sys_menu_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '52', '控制台-条目缺陷占比');
  156. INSERT INTO `sys_menu_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '53', '控制台-各科室缺陷占比');
  157. INSERT INTO `sys_menu_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '54', '控制台(科室)-出院人数统计(科室)');
  158. INSERT INTO `sys_menu_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '55', '控制台(科室)-质控病历数统计(科室)');
  159. INSERT INTO `sys_menu_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '56', '控制台(科室)-各模块缺陷占比排行(科室)');
  160. INSERT INTO `sys_menu_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '57', '控制台(科室)-条目缺陷占比(科室)');
  161. INSERT INTO `sys_menu_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '58', '控制台(科室)-查询用户关联科室');
  162. INSERT INTO `sys_menu_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '19', '59', '控制台-各模块缺陷占比_详情');
  163. INSERT INTO `sys_menu_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '60', '控制台-条目缺陷占比_详情');
  164. INSERT INTO `sys_menu_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '21', '64', '控制台-科室平均住院天数_详情');
  165. INSERT INTO `sys_menu_permission` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '22', '65', '控制台-科室平均住院花费_详情');
  166. INSERT INTO `sys_menu_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '66', '控制台-各科室质控平均分_详情');
  167. INSERT INTO `sys_menu_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '67', '控制台-各科室缺陷占比-缺陷详情');
  168. INSERT INTO `sys_menu_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '25', '68', '控制台-各科室甲级病历占比_详情');
  169. INSERT INTO `sys_menu_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '26', '69', '控制台(科室)-各模块缺陷占比_详情');
  170. INSERT INTO `sys_menu_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '70', '控制台(科室)-条目缺陷占比_详情');
  171. INSERT INTO `sys_menu_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '71', '控制台-各科室缺陷占比(组合)');
  172. INSERT INTO `sys_menu_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '28', '72', '控制台-病案首页合格率占比');
  173. INSERT INTO `sys_menu_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '73', '控制台(科室)-各科室缺陷占比(科室)');
  174. INSERT INTO `sys_menu_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '29', '74', '控制台(科室)-病案首页合格率占比(科室)');
  175. INSERT INTO `sys_menu_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '75', '控制台-病案首页合格率占比(首页)');
  176. INSERT INTO `sys_menu_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '76', '控制台(科室)-病案首页合格率占比(首页)');
  177. INSERT INTO `sys_menu_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '77', '控制台(科室)-科室缺陷占比-缺陷明细');
  178. INSERT INTO `sys_menu_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '89', '控制台-条目缺陷占比(内页)');
  179. INSERT INTO `sys_menu_permission` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '90', '控制台(科室)-条目缺陷占比-科室(内页)');
  180. INSERT INTO `sys_menu_permission` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '91', '控制台-各科室质控平均分(首页)-根据内外科系统统计');
  181. INSERT INTO `sys_menu_permission` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '92', '控制台-各科室缺陷占比(内页)-根据内外科系统统计');
  182. INSERT INTO `sys_menu_permission` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '94', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页(全院)');
  183. INSERT INTO `sys_menu_permission` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '95', '数据报表明细(科室)-条目缺陷占比-条目缺陷占比质控详情页(科室)');
  184. INSERT INTO `sys_menu_permission` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '96', '用户-医疗组-分页');
  185. INSERT INTO `sys_menu_permission` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '97', '用户-医疗组-新增质控条目');
  186. INSERT INTO `sys_menu_permission` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '98', '用户-医疗组-删除质控条目');
  187. INSERT INTO `sys_menu_permission` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '99', '用户-医疗组-修改质控条目');
  188. INSERT INTO `sys_menu_permission` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '34', '100', '数据报表明细-关键条目缺陷占比');
  189. INSERT INTO `sys_menu_permission` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '101', '用户-质控评分-核查数据接口');
  190. INSERT INTO `sys_menu_permission` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '101', '用户-质控评分(科室)-核查数据接口');
  191. INSERT INTO `sys_menu_permission` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '101', '用户-质控评分(个人)-核查数据接口');
  192. INSERT INTO `sys_menu_permission` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '101', '用户-医疗组-核查数据接口');
  193. INSERT INTO `sys_menu_permission` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '35', '102', '数据报表明细-出院人数统计');
  194. INSERT INTO `sys_menu_permission` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '36', '103', '数据报表明细-质控核查统计');
  195. -- ----------------------------
  196. -- Table structure for sys_permission
  197. -- ----------------------------
  198. DROP TABLE IF EXISTS `sys_permission`;
  199. CREATE TABLE `sys_permission` (
  200. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '资源ID',
  201. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  202. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  203. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  204. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  205. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  206. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '资源名称',
  207. `code` varchar(20) NOT NULL DEFAULT '' COMMENT '资源编码',
  208. `permissionUrl` varchar(255) NOT NULL DEFAULT '' COMMENT '资源Url',
  209. `method` varchar(255) NOT NULL DEFAULT 'ALL' COMMENT '资源允许的请求方式',
  210. `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '资源描述',
  211. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  212. PRIMARY KEY (`id`)
  213. ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COMMENT='系统资源表';
  214. -- ----------------------------
  215. -- Records of sys_permission
  216. -- ----------------------------
  217. INSERT INTO `sys_permission` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户、机构、菜单信息', 'FUNC000001', '/sys/user/getUserOrgMenu', 'ALL', '基础功能-获取用户、机构、菜单信息', null);
  218. INSERT INTO `sys_permission` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改密码', 'FUNC000002', '/sys/user/midifyPassword', 'ALL', '基础功能-修改密码', null);
  219. INSERT INTO `sys_permission` VALUES ('3', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院模块数据信息', 'FUNC000003', '/qc/cases/getQcCases', 'ALL', '用户-基础数据维护-获取医院模块数据信息', '无需加密');
  220. INSERT INTO `sys_permission` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改医院模块数据', 'FUNC000004', '/qc/cases/saveQcCases', 'ALL', '用户-基础数据维护-修改医院模块数据', null);
  221. INSERT INTO `sys_permission` VALUES ('5', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000005', '/qc/behospitalInfo/page', 'ALL', '用户-质控评分-分页', '无需加密');
  222. INSERT INTO `sys_permission` VALUES ('6', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页获取医院条目数据信息', 'FUNC000006', '/qc/casesEntryHospital/getQcCasesEntryAll', 'ALL', '用户-条目数据维护-分页获取医院条目数据信息', '无需加密');
  223. INSERT INTO `sys_permission` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改医院条目数据信息', 'FUNC000007', '/qc/casesEntryHospital/updataQcCasesEntry', 'ALL', '用户-条目数据维护-修改医院条目数据信息', null);
  224. INSERT INTO `sys_permission` VALUES ('8', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院模块下拉数据列表', 'FUNC000008', '/qc/casesEntryHospital/getQcCasesAll', 'ALL', '获取医院模块数据列表', '无需加密');
  225. INSERT INTO `sys_permission` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病历相关统计', 'FUNC000009', '/console/mrStatistics', 'ALL', '控制台-病历相关统计', null);
  226. INSERT INTO `sys_permission` VALUES ('10', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模糊查询医院模块条目列表', 'FUNC000010', '/qc/casesEntryHospital/findQcCasesEntry', 'ALL', '用户-条目数据维护-模糊查询医院模块条目列表', null);
  227. INSERT INTO `sys_permission` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分-新增质控条目', null);
  228. INSERT INTO `sys_permission` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分-删除质控条目', null);
  229. INSERT INTO `sys_permission` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分-修改质控条目', null);
  230. INSERT INTO `sys_permission` VALUES ('14', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分-获取详情', '无需加密');
  231. INSERT INTO `sys_permission` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '缺陷相关统计', 'FUNC000015', '/console/resultStatistics', 'ALL', '控制台-缺陷相关统计', null);
  232. INSERT INTO `sys_permission` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均值相关统计', 'FUNC000016', '/console/averageStatistics', 'ALL', '控制台-平均值相关统计', null);
  233. INSERT INTO `sys_permission` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分-评分', null);
  234. INSERT INTO `sys_permission` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色列表信息', 'FUNC000018', '/sys/role/list', 'ALL', '用户-权限管理-角色管理-获取角色列表信息', null);
  235. INSERT INTO `sys_permission` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色菜权限单等数据', 'FUNC000019', '/sys/role/getRoleMenu', 'ALL', '用户-权限管理-角色管理-获取角色菜权限单等数据', null);
  236. INSERT INTO `sys_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改角色菜单权限数据', 'FUNC000020', '/sys/role/saveRoleMenu', 'ALL', '用户-权限管理-角色管理-修改角色菜单权限数据', null);
  237. INSERT INTO `sys_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院科室下拉列表信息', 'FUNC000021', '/bas/dept/listForUser', 'ALL', '用户-权限管理-用户管理-获取用户管理下医院科室下拉列表信息', null);
  238. INSERT INTO `sys_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色下拉列表信息', 'FUNC000022', '/sys/role/listForUser', 'ALL', '用户-权限管理-用户管理-获取角色下拉列表信息', null);
  239. INSERT INTO `sys_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户列表翻页信息查询', 'FUNC000023', '/sys/user/userPage', 'ALL', '用户-权限管理-用户管理-用户列表翻页信息查询', null);
  240. INSERT INTO `sys_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室', 'FUNC000024', '/sys/user/getUserDepts', 'ALL', '用户-权限管理-用户管理-获取用户科室', null);
  241. INSERT INTO `sys_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户角色', 'FUNC000025', '/sys/user/getUserRoles', 'ALL', '用户-权限管理-用户管理-获取用户角色', null);
  242. INSERT INTO `sys_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户启用', 'FUNC000026', '/sys/user/enable', 'ALL', '用户-权限管理-用户管理-用户启用', null);
  243. INSERT INTO `sys_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户停用', 'FUNC000027', '/sys/user/disable', 'ALL', '用户-权限管理-用户管理-用户停用', null);
  244. INSERT INTO `sys_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '编辑用户科室', 'FUNC000028', '/sys/user/editUserDepts', 'ALL', '用户-权限管理-用户管理-编辑用户科室', null);
  245. INSERT INTO `sys_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '编辑用户角色', 'FUNC000029', '/sys/user/editUserRoles', 'ALL', '用户-权限管理-用户管理-编辑用户角色', null);
  246. INSERT INTO `sys_permission` VALUES ('30', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院科室下拉列表信息', 'FUNC000030', '/bas/dept/getList', 'ALL', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息', '无需加密');
  247. INSERT INTO `sys_permission` VALUES ('31', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室下拉列表信息', 'FUNC000031', '/bas/dept/getListUser', 'ALL', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
  248. INSERT INTO `sys_permission` VALUES ('32', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000032', '/qc/behospitalInfo/page_dept', 'ALL', '用户-质控评分(科室)-分页', '无需加密');
  249. INSERT INTO `sys_permission` VALUES ('33', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000033', '/qc/behospitalInfo/page_person', 'ALL', '用户-质控评分(个人)-分页', '无需加密');
  250. INSERT INTO `sys_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分(科室)-评分', null);
  251. INSERT INTO `sys_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分(科室)-新增质控条目', null);
  252. INSERT INTO `sys_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分(科室)-删除质控条目', null);
  253. INSERT INTO `sys_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分(科室)-修改质控条目', null);
  254. INSERT INTO `sys_permission` VALUES ('38', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分(科室)-获取详情', '无需加密');
  255. INSERT INTO `sys_permission` VALUES ('39', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室下拉列表信息', 'FUNC000031', '/bas/dept/getListUser', 'ALL', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
  256. INSERT INTO `sys_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分(个人)-评分', null);
  257. INSERT INTO `sys_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分(个人)-新增质控条目', null);
  258. INSERT INTO `sys_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分(个人)-删除质控条目', null);
  259. INSERT INTO `sys_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分(个人)-修改质控条目', null);
  260. INSERT INTO `sys_permission` VALUES ('44', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分(个人)-获取详情', '无需加密');
  261. INSERT INTO `sys_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均住院天数', 'FUNC000045', '/console/getAverageDayNum', 'ALL', '控制台-平均住院天数', null);
  262. INSERT INTO `sys_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均住院费用', 'FUNC000046', '/console/getAverageFee', 'ALL', '控制台-平均住院费用', null);
  263. INSERT INTO `sys_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控平均分按科室统计', 'FUNC000047', '/console/getAverageScore', 'ALL', '控制台-质控平均分按科室统计', null);
  264. INSERT INTO `sys_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比', 'FUNC000048', '/console/getLevelResultDept', 'ALL', '控制台-各科室甲级病历占比', null);
  265. INSERT INTO `sys_permission` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', 'FUNC000049', '/console/leaveHosCount', 'ALL', '控制台-出院人数统计', null);
  266. INSERT INTO `sys_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控病历统计', 'FUNC000050', '/console/mrCount', 'ALL', '控制台-质控病历统计', null);
  267. INSERT INTO `sys_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比排行', 'FUNC000051', '/console/entryCountGroupByCase', 'ALL', '控制台-各模块缺陷占比排行', null);
  268. INSERT INTO `sys_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', 'FUNC000052', '/console/entryCountGroupByEntry', 'ALL', '控制台-条目缺陷占比', null);
  269. INSERT INTO `sys_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', 'FUNC000053', '/console/entryByDept', 'ALL', '控制台-各科室缺陷占比', null);
  270. INSERT INTO `sys_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计(科室)', 'FUNC000054', '/consoleByDept/leaveHosCountByDept', 'ALL', '控制台(科室)-出院人数统计(科室)', null);
  271. INSERT INTO `sys_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控病历数统计(科室)', 'FUNC000055', '/consoleByDept/mrCountByDept', 'ALL', '控制台(科室)-质控病历数统计(科室)', null);
  272. INSERT INTO `sys_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比排行(科室)', 'FUNC000056', '/consoleByDept/entryCountGroupByCaseAndDept', 'ALL', '控制台(科室)-各模块缺陷占比排行(科室)', null);
  273. INSERT INTO `sys_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比(科室)', 'FUNC000057', '/consoleByDept/entryCountGroupByEntryAndDept', 'ALL', '控制台(科室)-条目缺陷占比(科室)', null);
  274. INSERT INTO `sys_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '查询用户关联科室', 'FUNC000058', '/consoleByDept/getDept', 'ALL', '控制台(科室)-查询用户关联科室', null);
  275. INSERT INTO `sys_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比_详情', 'FUNC000059', '/console/entryCountGroupByCasePage', 'ALL', '控制台-各模块缺陷占比_详情', null);
  276. INSERT INTO `sys_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比_详情', 'FUNC000060', '/console/entryCountGroupByEntryPage', 'ALL', '控制台-条目缺陷占比_详情', null);
  277. INSERT INTO `sys_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '查询异常数据监控信息', 'FUNC000061', '/qc/abnormal/getQcAnnormal', 'ALL', '异常数据监控-查询异常数据监控信息', null);
  278. INSERT INTO `sys_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '更新异常数据监控信息', 'FUNC000062', '/qc/abnormal/saveQcAnnormal', 'ALL', '异常数据监控-异常数据监控-查询异常数据监控信息', null);
  279. INSERT INTO `sys_permission` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除异常数据监控信息', 'FUNC000063', '/qc/abnormal/delQcAnnormal', 'ALL', '异常数据监控-异常数据监控-删除异常数据监控信息', null);
  280. INSERT INTO `sys_permission` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院天数_详情', 'FUNC000064', '/console/getAverageDayNumPage', 'ALL', '控制台-科室平均住院天数_详情', null);
  281. INSERT INTO `sys_permission` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院花费_详情', 'FUNC000065', '/console/getAverageFeePage', 'ALL', '控制台-科室平均住院花费_详情', null);
  282. INSERT INTO `sys_permission` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分_详情', 'FUNC000066', '/console/getAverageScoreByDeptPage', 'ALL', '控制台-各科室质控平均分_详情', null);
  283. INSERT INTO `sys_permission` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比-缺陷详情', 'FUNC000067', '/console/resultStatisticsByDeptPage', 'ALL', '控制台-各科室缺陷占比-缺陷详情', null);
  284. INSERT INTO `sys_permission` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比_详情', 'FUNC000068', '/console/levelPercentGroupByDeptPage', 'ALL', '控制台-各科室甲级病历占比_详情', null);
  285. INSERT INTO `sys_permission` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比_详情', 'FUNC000069', '/consoleByDept/entryCountGroupByCaseAndDeptPage', 'ALL', '控制台(科室)-各模块缺陷占比_详情', null);
  286. INSERT INTO `sys_permission` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比_详情', 'FUNC000070', '/consoleByDept/entryCountGroupByEntryAndDeptPage', 'ALL', '控制台(科室)-条目缺陷占比_详情', null);
  287. INSERT INTO `sys_permission` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比(组合)', 'FUNC000071', '/console/levelStatistics', 'ALL', '控制台-各科室缺陷占比(组合)', null);
  288. INSERT INTO `sys_permission` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', 'FUNC000072', '/console/homePageLevelStatistics', 'ALL', '控制台-病案首页合格率占比', null);
  289. INSERT INTO `sys_permission` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', 'FUNC000073', '/consoleByDept/levelStatisticsByDept', 'ALL', '控制台(科室)-各科室缺陷占比(科室)', null);
  290. INSERT INTO `sys_permission` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', 'FUNC000074', '/consoleByDept/homePageLevelStatisticsByDept', 'ALL', '控制台(科室)-病案首页合格率占比(科室)', null);
  291. INSERT INTO `sys_permission` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比(首页)', 'FUNC000075', '/console/homePageLevelLimit', 'ALL', '控制台-病案首页合格率占比(首页)', null);
  292. INSERT INTO `sys_permission` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比(首页)', 'FUNC000076', '/consoleByDept/homePageLevelByDeptLimit', 'ALL', '控制台(科室)-病案首页合格率占比(首页)', null);
  293. INSERT INTO `sys_permission` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室缺陷占比-缺陷明细', 'FUNC000077', '/consoleByDept/resultStatisticsByDeptAndDoctorPage', 'ALL', '控制台(科室)-科室缺陷占比-缺陷明细', null);
  294. INSERT INTO `sys_permission` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页列表', 'FUNC000078', '/qc/qcType/page', 'ALL', '用户-质控类型维护-分页列表', null);
  295. INSERT INTO `sys_permission` VALUES ('79', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增或更新', 'FUNC000079', '/qc/qcType/saveOrUpdate', 'ALL', '用户-质控类型维护-新增或更新', null);
  296. INSERT INTO `sys_permission` VALUES ('80', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增时质控条目分组信息', 'FUNC000080', '/qc/qcType/getEntryByHospital', 'ALL', '用户-质控类型维护-新增时质控条目分组信息', null);
  297. INSERT INTO `sys_permission` VALUES ('81', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控条目检索', 'FUNC000081', '/qc/qcType/index', 'ALL', '用户-质控类型维护-质控条目检索', null);
  298. INSERT INTO `sys_permission` VALUES ('82', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除', 'FUNC000082', '/qc/qcType/delete', 'ALL', '用户-质控类型维护-删除', null);
  299. INSERT INTO `sys_permission` VALUES ('83', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id返回内容', 'FUNC000083', '/qc/qcType/getById', 'ALL', '用户-质控类型维护-根据id返回内容', null);
  300. INSERT INTO `sys_permission` VALUES ('84', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院数据全部条目', 'FUNC000084', '/qc/modelHospital/getModelHospitalAll', 'ALL', '用户-质控类型维护-获取医院数据全部条目', null);
  301. INSERT INTO `sys_permission` VALUES ('85', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id获取医院数据', 'FUNC000085', '/qc/modelHospital/getModelHospitalById', 'ALL', '用户-质控类型维护-根据id获取医院数据', null);
  302. INSERT INTO `sys_permission` VALUES ('86', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '添加和修改医院数据模块', 'FUNC000086', '/qc/modelHospital/saveAndupdataModel', 'ALL', '用户-质控类型维护-添加和修改医院数据模块', null);
  303. INSERT INTO `sys_permission` VALUES ('87', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除医院数据模块', 'FUNC000087', '/qc/modelHospital/clearModelHospital', 'ALL', '用户-质控类型维护-删除医院数据模块', null);
  304. INSERT INTO `sys_permission` VALUES ('88', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院全部模块', 'FUNC0000888', '/qc/mode/getModes', 'ALL', '用户-质控类型维护-获取医院全部模块', null);
  305. INSERT INTO `sys_permission` VALUES ('89', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比(内页)', 'FUNC000089', '/console/entryGroupByEntryInnerPage', 'ALL', '控制台-条目缺陷占比(内页)', null);
  306. INSERT INTO `sys_permission` VALUES ('90', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比-科室(内页)', 'FUNC000090', '/consoleByDept/entryGroupByEntryAndDeptInnerPage', 'ALL', '控制台(科室)-条目缺陷占比-科室(内页)', null);
  307. INSERT INTO `sys_permission` VALUES ('91', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分(首页)-根据内外科系统统计', 'FUNC000091', '/console/getAverageScoreByDeptClass', 'ALL', '控制台-各科室质控平均分(首页)-根据内外科系统统计', null);
  308. INSERT INTO `sys_permission` VALUES ('92', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比(内页)-根据内外科系统统计', 'FUNC000092', '/console/levelStatisticsByDeptClass', 'ALL', '控制台-各科室缺陷占比(内页)-根据内外科系统统计', null);
  309. INSERT INTO `sys_permission` VALUES ('93', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id查询数据模块信息', 'FUNC000093', '/qc/abnormal/getQcAnnormalMode', 'ALL', '异常数据监控-异常数据监控-根据id查询数据模块信息', null);
  310. INSERT INTO `sys_permission` VALUES ('94', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比质控详情页(全院)', 'FUNC000094', '/console/qcResultShortPage', 'ALL', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页(全院)', null);
  311. INSERT INTO `sys_permission` VALUES ('95', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比质控详情页(科室)', 'FUNC000095', '/consoleByDept/qcResultShortByDeptPage', 'ALL', '数据报表明细(科室)-条目缺陷占比-条目缺陷占比质控详情页(科室)', null);
  312. INSERT INTO `sys_permission` VALUES ('96', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-医疗组-评分', null);
  313. INSERT INTO `sys_permission` VALUES ('97', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-医疗组-新增质控条目', null);
  314. INSERT INTO `sys_permission` VALUES ('98', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-医疗组-删除质控条目', null);
  315. INSERT INTO `sys_permission` VALUES ('99', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-医疗组-修改质控条目', null);
  316. INSERT INTO `sys_permission` VALUES ('100', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比', 'FUNC000100', '/console/entryStatistics', 'ALL', '数据报表明细-关键条目缺陷占比', null);
  317. INSERT INTO `sys_permission` VALUES ('101', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '核查数据接口', 'FUNC000014', '/qc/medCheckInfo/addMedCheckInfo', 'ALL', '用户-核查数据接口', null);
  318. INSERT INTO `sys_permission` VALUES ('102', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', 'FUNC000102', '/console/leaveHosMRPage', 'ALL', '数据报表明细-出院人数统计', null);
  319. INSERT INTO `sys_permission` VALUES ('103', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计', 'FUNC000103', '/console/qcCheckStatistics', 'ALL', '数据表白明细-质控核查统计', null);
  320. -- ----------------------------
  321. -- Table structure for sys_role
  322. -- ----------------------------
  323. DROP TABLE IF EXISTS `sys_role`;
  324. CREATE TABLE `sys_role` (
  325. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  326. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  327. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  328. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  329. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  330. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  331. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '角色名称',
  332. `roleLevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  333. `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '角色描述',
  334. `menuItems` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单ID:对应角色ID(暂无用处)',
  335. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  336. PRIMARY KEY (`id`)
  337. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统角色表';
  338. -- ----------------------------
  339. -- Records of sys_role
  340. -- ----------------------------
  341. INSERT INTO `sys_role` VALUES ('-1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '超级管理员', '0', '', '', '');
  342. INSERT INTO `sys_role` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(全局)', '0', '', '', '');
  343. INSERT INTO `sys_role` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(科室)', '0', '', '', null);
  344. INSERT INTO `sys_role` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(个人)', '0', '', '', null);
  345. -- ----------------------------
  346. -- Table structure for sys_role_menu
  347. -- ----------------------------
  348. DROP TABLE IF EXISTS `sys_role_menu`;
  349. CREATE TABLE `sys_role_menu` (
  350. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  351. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  352. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  353. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  354. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  355. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  356. `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  357. `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  358. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  359. PRIMARY KEY (`id`)
  360. ) ENGINE=InnoDB AUTO_INCREMENT=829 DEFAULT CHARSET=utf8 COMMENT='角色和菜单的映射表';
  361. -- ----------------------------
  362. -- Records of sys_role_menu
  363. -- ----------------------------
  364. INSERT INTO `sys_role_menu` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', null);
  365. INSERT INTO `sys_role_menu` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '2', null);
  366. INSERT INTO `sys_role_menu` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '3', null);
  367. INSERT INTO `sys_role_menu` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '4', null);
  368. INSERT INTO `sys_role_menu` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '5', null);
  369. INSERT INTO `sys_role_menu` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '6', null);
  370. INSERT INTO `sys_role_menu` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '7', null);
  371. INSERT INTO `sys_role_menu` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '8', null);
  372. INSERT INTO `sys_role_menu` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '9', null);
  373. INSERT INTO `sys_role_menu` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '10', null);
  374. INSERT INTO `sys_role_menu` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '12', null);
  375. INSERT INTO `sys_role_menu` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '13', null);
  376. INSERT INTO `sys_role_menu` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '14', null);
  377. INSERT INTO `sys_role_menu` VALUES ('499', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '15', null);
  378. INSERT INTO `sys_role_menu` VALUES ('543', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '1', null);
  379. INSERT INTO `sys_role_menu` VALUES ('544', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '8', null);
  380. INSERT INTO `sys_role_menu` VALUES ('545', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '2', null);
  381. INSERT INTO `sys_role_menu` VALUES ('546', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '5', null);
  382. INSERT INTO `sys_role_menu` VALUES ('547', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '6', null);
  383. INSERT INTO `sys_role_menu` VALUES ('548', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '3', null);
  384. INSERT INTO `sys_role_menu` VALUES ('549', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '7', null);
  385. INSERT INTO `sys_role_menu` VALUES ('550', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '16', '用户-异常数据监控');
  386. INSERT INTO `sys_role_menu` VALUES ('551', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '17', '用户-质控科');
  387. INSERT INTO `sys_role_menu` VALUES ('552', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '18', '用户-科室主任');
  388. INSERT INTO `sys_role_menu` VALUES ('553', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '19', '用户-质控科-各模块缺陷占比_详情');
  389. INSERT INTO `sys_role_menu` VALUES ('554', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '20', '用户-质控科-条目缺陷占比_详情');
  390. INSERT INTO `sys_role_menu` VALUES ('555', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '21', '用户-质控科-科室平均住院天数_详情');
  391. INSERT INTO `sys_role_menu` VALUES ('556', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '22', '用户-质控科-科室平均住院花费_详情');
  392. INSERT INTO `sys_role_menu` VALUES ('557', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '23', '用户-质控科-各科室质控平均分_详情');
  393. INSERT INTO `sys_role_menu` VALUES ('558', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '24', '用户-质控科-各科室缺陷占比_详情');
  394. INSERT INTO `sys_role_menu` VALUES ('559', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '25', '用户-质控科-各科室甲级病历占比_详情');
  395. INSERT INTO `sys_role_menu` VALUES ('560', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '26', '用户-科室主任-各模块缺陷占比_详情');
  396. INSERT INTO `sys_role_menu` VALUES ('561', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '27', '用户-科室主任-条目缺陷占比_详情');
  397. INSERT INTO `sys_role_menu` VALUES ('562', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '15', null);
  398. INSERT INTO `sys_role_menu` VALUES ('563', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '8', null);
  399. INSERT INTO `sys_role_menu` VALUES ('564', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '2', null);
  400. INSERT INTO `sys_role_menu` VALUES ('565', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '5', null);
  401. INSERT INTO `sys_role_menu` VALUES ('566', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '6', null);
  402. INSERT INTO `sys_role_menu` VALUES ('567', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '3', null);
  403. INSERT INTO `sys_role_menu` VALUES ('568', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '10', null);
  404. INSERT INTO `sys_role_menu` VALUES ('569', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '15', null);
  405. INSERT INTO `sys_role_menu` VALUES ('570', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '8', null);
  406. INSERT INTO `sys_role_menu` VALUES ('571', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '2', null);
  407. INSERT INTO `sys_role_menu` VALUES ('572', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '5', null);
  408. INSERT INTO `sys_role_menu` VALUES ('573', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '6', null);
  409. INSERT INTO `sys_role_menu` VALUES ('574', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '3', null);
  410. INSERT INTO `sys_role_menu` VALUES ('575', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '9', null);
  411. INSERT INTO `sys_role_menu` VALUES ('576', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '17', '用户-质控科');
  412. INSERT INTO `sys_role_menu` VALUES ('577', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '18', '用户-科室主任');
  413. INSERT INTO `sys_role_menu` VALUES ('578', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '19', '用户-质控科-各模块缺陷占比_详情');
  414. INSERT INTO `sys_role_menu` VALUES ('579', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '20', '用户-质控科-条目缺陷占比_详情');
  415. INSERT INTO `sys_role_menu` VALUES ('580', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '21', '用户-质控科-科室平均住院天数_详情');
  416. INSERT INTO `sys_role_menu` VALUES ('581', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '22', '用户-质控科-科室平均住院花费_详情');
  417. INSERT INTO `sys_role_menu` VALUES ('582', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '23', '用户-质控科-各科室质控平均分_详情');
  418. INSERT INTO `sys_role_menu` VALUES ('583', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '24', '用户-质控科-各科室缺陷占比_详情');
  419. INSERT INTO `sys_role_menu` VALUES ('584', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '25', '用户-质控科-各科室甲级病历占比_详情');
  420. INSERT INTO `sys_role_menu` VALUES ('585', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '26', '用户-科室主任-各模块缺陷占比_详情');
  421. INSERT INTO `sys_role_menu` VALUES ('586', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '27', '用户-科室主任-条目缺陷占比_详情');
  422. INSERT INTO `sys_role_menu` VALUES ('587', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '28', '用户-质控科-病案首页合格率占比_详情');
  423. INSERT INTO `sys_role_menu` VALUES ('588', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '29', '用户-科室主任-病案首页合格率占比_详情');
  424. INSERT INTO `sys_role_menu` VALUES ('589', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '30', '用户-科室主任-科室缺陷占比_详情');
  425. INSERT INTO `sys_role_menu` VALUES ('590', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '31', '用户-质控科-各科室缺陷占比_详情');
  426. INSERT INTO `sys_role_menu` VALUES ('591', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '1', null);
  427. INSERT INTO `sys_role_menu` VALUES ('592', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '17', null);
  428. INSERT INTO `sys_role_menu` VALUES ('593', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '28', null);
  429. INSERT INTO `sys_role_menu` VALUES ('594', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '19', null);
  430. INSERT INTO `sys_role_menu` VALUES ('595', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '20', null);
  431. INSERT INTO `sys_role_menu` VALUES ('596', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '21', null);
  432. INSERT INTO `sys_role_menu` VALUES ('597', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '22', null);
  433. INSERT INTO `sys_role_menu` VALUES ('598', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '25', null);
  434. INSERT INTO `sys_role_menu` VALUES ('599', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '31', null);
  435. INSERT INTO `sys_role_menu` VALUES ('600', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '8', null);
  436. INSERT INTO `sys_role_menu` VALUES ('601', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '2', null);
  437. INSERT INTO `sys_role_menu` VALUES ('602', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '5', null);
  438. INSERT INTO `sys_role_menu` VALUES ('603', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '6', null);
  439. INSERT INTO `sys_role_menu` VALUES ('604', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '3', null);
  440. INSERT INTO `sys_role_menu` VALUES ('605', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '7', null);
  441. INSERT INTO `sys_role_menu` VALUES ('606', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '1', null);
  442. INSERT INTO `sys_role_menu` VALUES ('607', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '17', null);
  443. INSERT INTO `sys_role_menu` VALUES ('608', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '28', null);
  444. INSERT INTO `sys_role_menu` VALUES ('609', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '19', null);
  445. INSERT INTO `sys_role_menu` VALUES ('610', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '20', null);
  446. INSERT INTO `sys_role_menu` VALUES ('611', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '21', null);
  447. INSERT INTO `sys_role_menu` VALUES ('612', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '22', null);
  448. INSERT INTO `sys_role_menu` VALUES ('613', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '25', null);
  449. INSERT INTO `sys_role_menu` VALUES ('614', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '31', null);
  450. INSERT INTO `sys_role_menu` VALUES ('615', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '8', null);
  451. INSERT INTO `sys_role_menu` VALUES ('616', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '2', null);
  452. INSERT INTO `sys_role_menu` VALUES ('617', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '5', null);
  453. INSERT INTO `sys_role_menu` VALUES ('618', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '6', null);
  454. INSERT INTO `sys_role_menu` VALUES ('619', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '3', null);
  455. INSERT INTO `sys_role_menu` VALUES ('620', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '7', null);
  456. INSERT INTO `sys_role_menu` VALUES ('621', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '1', null);
  457. INSERT INTO `sys_role_menu` VALUES ('622', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '17', null);
  458. INSERT INTO `sys_role_menu` VALUES ('623', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '28', null);
  459. INSERT INTO `sys_role_menu` VALUES ('624', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '19', null);
  460. INSERT INTO `sys_role_menu` VALUES ('625', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '20', null);
  461. INSERT INTO `sys_role_menu` VALUES ('626', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '21', null);
  462. INSERT INTO `sys_role_menu` VALUES ('627', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '22', null);
  463. INSERT INTO `sys_role_menu` VALUES ('628', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '25', null);
  464. INSERT INTO `sys_role_menu` VALUES ('629', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '31', null);
  465. INSERT INTO `sys_role_menu` VALUES ('630', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '8', null);
  466. INSERT INTO `sys_role_menu` VALUES ('631', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '2', null);
  467. INSERT INTO `sys_role_menu` VALUES ('632', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '5', null);
  468. INSERT INTO `sys_role_menu` VALUES ('633', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '6', null);
  469. INSERT INTO `sys_role_menu` VALUES ('634', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '3', null);
  470. INSERT INTO `sys_role_menu` VALUES ('635', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '7', null);
  471. INSERT INTO `sys_role_menu` VALUES ('636', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '1', null);
  472. INSERT INTO `sys_role_menu` VALUES ('637', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '17', null);
  473. INSERT INTO `sys_role_menu` VALUES ('638', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '28', null);
  474. INSERT INTO `sys_role_menu` VALUES ('639', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '19', null);
  475. INSERT INTO `sys_role_menu` VALUES ('640', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '20', null);
  476. INSERT INTO `sys_role_menu` VALUES ('641', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '21', null);
  477. INSERT INTO `sys_role_menu` VALUES ('642', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '22', null);
  478. INSERT INTO `sys_role_menu` VALUES ('643', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '25', null);
  479. INSERT INTO `sys_role_menu` VALUES ('644', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '31', null);
  480. INSERT INTO `sys_role_menu` VALUES ('645', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '8', null);
  481. INSERT INTO `sys_role_menu` VALUES ('646', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '2', null);
  482. INSERT INTO `sys_role_menu` VALUES ('647', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '5', null);
  483. INSERT INTO `sys_role_menu` VALUES ('648', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '6', null);
  484. INSERT INTO `sys_role_menu` VALUES ('649', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '3', null);
  485. INSERT INTO `sys_role_menu` VALUES ('650', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '7', null);
  486. INSERT INTO `sys_role_menu` VALUES ('651', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '32', '用户-基础数据维护-质控类型维护');
  487. INSERT INTO `sys_role_menu` VALUES ('652', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '1', null);
  488. INSERT INTO `sys_role_menu` VALUES ('653', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '15', null);
  489. INSERT INTO `sys_role_menu` VALUES ('654', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '17', null);
  490. INSERT INTO `sys_role_menu` VALUES ('655', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '28', null);
  491. INSERT INTO `sys_role_menu` VALUES ('656', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '19', null);
  492. INSERT INTO `sys_role_menu` VALUES ('657', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '20', null);
  493. INSERT INTO `sys_role_menu` VALUES ('658', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '21', null);
  494. INSERT INTO `sys_role_menu` VALUES ('659', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '22', null);
  495. INSERT INTO `sys_role_menu` VALUES ('660', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '25', null);
  496. INSERT INTO `sys_role_menu` VALUES ('661', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '31', null);
  497. INSERT INTO `sys_role_menu` VALUES ('662', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '18', null);
  498. INSERT INTO `sys_role_menu` VALUES ('663', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '29', null);
  499. INSERT INTO `sys_role_menu` VALUES ('664', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '26', null);
  500. INSERT INTO `sys_role_menu` VALUES ('665', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '27', null);
  501. INSERT INTO `sys_role_menu` VALUES ('666', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '30', null);
  502. INSERT INTO `sys_role_menu` VALUES ('667', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '8', null);
  503. INSERT INTO `sys_role_menu` VALUES ('668', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '2', null);
  504. INSERT INTO `sys_role_menu` VALUES ('669', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '5', null);
  505. INSERT INTO `sys_role_menu` VALUES ('670', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '6', null);
  506. INSERT INTO `sys_role_menu` VALUES ('671', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '3', null);
  507. INSERT INTO `sys_role_menu` VALUES ('672', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '7', null);
  508. INSERT INTO `sys_role_menu` VALUES ('673', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '1', null);
  509. INSERT INTO `sys_role_menu` VALUES ('674', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '15', null);
  510. INSERT INTO `sys_role_menu` VALUES ('675', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '17', null);
  511. INSERT INTO `sys_role_menu` VALUES ('676', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '28', null);
  512. INSERT INTO `sys_role_menu` VALUES ('677', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '19', null);
  513. INSERT INTO `sys_role_menu` VALUES ('678', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '20', null);
  514. INSERT INTO `sys_role_menu` VALUES ('679', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '21', null);
  515. INSERT INTO `sys_role_menu` VALUES ('680', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '22', null);
  516. INSERT INTO `sys_role_menu` VALUES ('681', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '25', null);
  517. INSERT INTO `sys_role_menu` VALUES ('682', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '31', null);
  518. INSERT INTO `sys_role_menu` VALUES ('683', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '18', null);
  519. INSERT INTO `sys_role_menu` VALUES ('684', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '29', null);
  520. INSERT INTO `sys_role_menu` VALUES ('685', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '26', null);
  521. INSERT INTO `sys_role_menu` VALUES ('686', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '27', null);
  522. INSERT INTO `sys_role_menu` VALUES ('687', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '30', null);
  523. INSERT INTO `sys_role_menu` VALUES ('688', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '8', null);
  524. INSERT INTO `sys_role_menu` VALUES ('689', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '2', null);
  525. INSERT INTO `sys_role_menu` VALUES ('690', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '5', null);
  526. INSERT INTO `sys_role_menu` VALUES ('691', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '6', null);
  527. INSERT INTO `sys_role_menu` VALUES ('692', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '3', null);
  528. INSERT INTO `sys_role_menu` VALUES ('693', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '7', null);
  529. INSERT INTO `sys_role_menu` VALUES ('694', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '1', null);
  530. INSERT INTO `sys_role_menu` VALUES ('695', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '15', null);
  531. INSERT INTO `sys_role_menu` VALUES ('696', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '17', null);
  532. INSERT INTO `sys_role_menu` VALUES ('697', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '28', null);
  533. INSERT INTO `sys_role_menu` VALUES ('698', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '19', null);
  534. INSERT INTO `sys_role_menu` VALUES ('699', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '20', null);
  535. INSERT INTO `sys_role_menu` VALUES ('700', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '21', null);
  536. INSERT INTO `sys_role_menu` VALUES ('701', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '22', null);
  537. INSERT INTO `sys_role_menu` VALUES ('702', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '25', null);
  538. INSERT INTO `sys_role_menu` VALUES ('703', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '31', null);
  539. INSERT INTO `sys_role_menu` VALUES ('704', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '18', null);
  540. INSERT INTO `sys_role_menu` VALUES ('705', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '29', null);
  541. INSERT INTO `sys_role_menu` VALUES ('706', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '26', null);
  542. INSERT INTO `sys_role_menu` VALUES ('707', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '27', null);
  543. INSERT INTO `sys_role_menu` VALUES ('708', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '30', null);
  544. INSERT INTO `sys_role_menu` VALUES ('709', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '8', null);
  545. INSERT INTO `sys_role_menu` VALUES ('710', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '2', null);
  546. INSERT INTO `sys_role_menu` VALUES ('711', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '5', null);
  547. INSERT INTO `sys_role_menu` VALUES ('712', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '6', null);
  548. INSERT INTO `sys_role_menu` VALUES ('713', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '3', null);
  549. INSERT INTO `sys_role_menu` VALUES ('714', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '7', null);
  550. INSERT INTO `sys_role_menu` VALUES ('715', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
  551. INSERT INTO `sys_role_menu` VALUES ('716', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '15', null);
  552. INSERT INTO `sys_role_menu` VALUES ('717', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '18', null);
  553. INSERT INTO `sys_role_menu` VALUES ('718', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '26', null);
  554. INSERT INTO `sys_role_menu` VALUES ('719', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '27', null);
  555. INSERT INTO `sys_role_menu` VALUES ('720', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '8', null);
  556. INSERT INTO `sys_role_menu` VALUES ('721', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
  557. INSERT INTO `sys_role_menu` VALUES ('722', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '5', null);
  558. INSERT INTO `sys_role_menu` VALUES ('723', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '6', null);
  559. INSERT INTO `sys_role_menu` VALUES ('724', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '3', null);
  560. INSERT INTO `sys_role_menu` VALUES ('725', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '9', null);
  561. INSERT INTO `sys_role_menu` VALUES ('726', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '1', null);
  562. INSERT INTO `sys_role_menu` VALUES ('727', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '15', null);
  563. INSERT INTO `sys_role_menu` VALUES ('728', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '17', null);
  564. INSERT INTO `sys_role_menu` VALUES ('729', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '28', null);
  565. INSERT INTO `sys_role_menu` VALUES ('730', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '19', null);
  566. INSERT INTO `sys_role_menu` VALUES ('731', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '20', null);
  567. INSERT INTO `sys_role_menu` VALUES ('732', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '21', null);
  568. INSERT INTO `sys_role_menu` VALUES ('733', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '22', null);
  569. INSERT INTO `sys_role_menu` VALUES ('734', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '25', null);
  570. INSERT INTO `sys_role_menu` VALUES ('735', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '31', null);
  571. INSERT INTO `sys_role_menu` VALUES ('736', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '18', null);
  572. INSERT INTO `sys_role_menu` VALUES ('737', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '29', null);
  573. INSERT INTO `sys_role_menu` VALUES ('738', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '26', null);
  574. INSERT INTO `sys_role_menu` VALUES ('739', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '27', null);
  575. INSERT INTO `sys_role_menu` VALUES ('740', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '30', null);
  576. INSERT INTO `sys_role_menu` VALUES ('741', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '8', null);
  577. INSERT INTO `sys_role_menu` VALUES ('742', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '2', null);
  578. INSERT INTO `sys_role_menu` VALUES ('743', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '5', null);
  579. INSERT INTO `sys_role_menu` VALUES ('744', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '6', null);
  580. INSERT INTO `sys_role_menu` VALUES ('745', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '3', null);
  581. INSERT INTO `sys_role_menu` VALUES ('746', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '7', null);
  582. INSERT INTO `sys_role_menu` VALUES ('747', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '1', null);
  583. INSERT INTO `sys_role_menu` VALUES ('748', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '15', null);
  584. INSERT INTO `sys_role_menu` VALUES ('749', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '17', null);
  585. INSERT INTO `sys_role_menu` VALUES ('750', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '28', null);
  586. INSERT INTO `sys_role_menu` VALUES ('751', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '19', null);
  587. INSERT INTO `sys_role_menu` VALUES ('752', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '20', null);
  588. INSERT INTO `sys_role_menu` VALUES ('753', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '21', null);
  589. INSERT INTO `sys_role_menu` VALUES ('754', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '22', null);
  590. INSERT INTO `sys_role_menu` VALUES ('755', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '25', null);
  591. INSERT INTO `sys_role_menu` VALUES ('756', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '31', null);
  592. INSERT INTO `sys_role_menu` VALUES ('757', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '18', null);
  593. INSERT INTO `sys_role_menu` VALUES ('758', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '29', null);
  594. INSERT INTO `sys_role_menu` VALUES ('759', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '26', null);
  595. INSERT INTO `sys_role_menu` VALUES ('760', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '27', null);
  596. INSERT INTO `sys_role_menu` VALUES ('761', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '30', null);
  597. INSERT INTO `sys_role_menu` VALUES ('762', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '8', null);
  598. INSERT INTO `sys_role_menu` VALUES ('763', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '2', null);
  599. INSERT INTO `sys_role_menu` VALUES ('764', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '5', null);
  600. INSERT INTO `sys_role_menu` VALUES ('765', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '6', null);
  601. INSERT INTO `sys_role_menu` VALUES ('766', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '3', null);
  602. INSERT INTO `sys_role_menu` VALUES ('767', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '7', null);
  603. INSERT INTO `sys_role_menu` VALUES ('769', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '1', null);
  604. INSERT INTO `sys_role_menu` VALUES ('770', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '15', null);
  605. INSERT INTO `sys_role_menu` VALUES ('771', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '17', null);
  606. INSERT INTO `sys_role_menu` VALUES ('772', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '28', null);
  607. INSERT INTO `sys_role_menu` VALUES ('773', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '19', null);
  608. INSERT INTO `sys_role_menu` VALUES ('774', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '20', null);
  609. INSERT INTO `sys_role_menu` VALUES ('775', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '21', null);
  610. INSERT INTO `sys_role_menu` VALUES ('776', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '22', null);
  611. INSERT INTO `sys_role_menu` VALUES ('777', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '25', null);
  612. INSERT INTO `sys_role_menu` VALUES ('778', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '31', null);
  613. INSERT INTO `sys_role_menu` VALUES ('779', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '33', null);
  614. INSERT INTO `sys_role_menu` VALUES ('780', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '18', null);
  615. INSERT INTO `sys_role_menu` VALUES ('781', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '29', null);
  616. INSERT INTO `sys_role_menu` VALUES ('782', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '26', null);
  617. INSERT INTO `sys_role_menu` VALUES ('783', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '27', null);
  618. INSERT INTO `sys_role_menu` VALUES ('784', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '30', null);
  619. INSERT INTO `sys_role_menu` VALUES ('785', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '8', null);
  620. INSERT INTO `sys_role_menu` VALUES ('786', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '2', null);
  621. INSERT INTO `sys_role_menu` VALUES ('787', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '5', null);
  622. INSERT INTO `sys_role_menu` VALUES ('788', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '6', null);
  623. INSERT INTO `sys_role_menu` VALUES ('789', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '3', null);
  624. INSERT INTO `sys_role_menu` VALUES ('790', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '7', null);
  625. INSERT INTO `sys_role_menu` VALUES ('791', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '8', null);
  626. INSERT INTO `sys_role_menu` VALUES ('792', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '3', null);
  627. INSERT INTO `sys_role_menu` VALUES ('793', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '10', null);
  628. INSERT INTO `sys_role_menu` VALUES ('794', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '8', null);
  629. INSERT INTO `sys_role_menu` VALUES ('795', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '3', null);
  630. INSERT INTO `sys_role_menu` VALUES ('796', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '9', null);
  631. INSERT INTO `sys_role_menu` VALUES ('797', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
  632. INSERT INTO `sys_role_menu` VALUES ('798', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '15', null);
  633. INSERT INTO `sys_role_menu` VALUES ('799', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '17', null);
  634. INSERT INTO `sys_role_menu` VALUES ('800', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '28', null);
  635. INSERT INTO `sys_role_menu` VALUES ('801', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '19', null);
  636. INSERT INTO `sys_role_menu` VALUES ('802', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '20', null);
  637. INSERT INTO `sys_role_menu` VALUES ('803', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '21', null);
  638. INSERT INTO `sys_role_menu` VALUES ('804', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '22', null);
  639. INSERT INTO `sys_role_menu` VALUES ('805', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '25', null);
  640. INSERT INTO `sys_role_menu` VALUES ('806', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '31', null);
  641. INSERT INTO `sys_role_menu` VALUES ('807', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '18', null);
  642. INSERT INTO `sys_role_menu` VALUES ('808', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '29', null);
  643. INSERT INTO `sys_role_menu` VALUES ('809', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '26', null);
  644. INSERT INTO `sys_role_menu` VALUES ('810', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '27', null);
  645. INSERT INTO `sys_role_menu` VALUES ('811', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '30', null);
  646. INSERT INTO `sys_role_menu` VALUES ('812', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '8', null);
  647. INSERT INTO `sys_role_menu` VALUES ('813', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
  648. INSERT INTO `sys_role_menu` VALUES ('814', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '5', null);
  649. INSERT INTO `sys_role_menu` VALUES ('815', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '6', null);
  650. INSERT INTO `sys_role_menu` VALUES ('816', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '3', null);
  651. INSERT INTO `sys_role_menu` VALUES ('817', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
  652. INSERT INTO `sys_role_menu` VALUES ('818', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '9', null);
  653. INSERT INTO `sys_role_menu` VALUES ('819', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '10', null);
  654. INSERT INTO `sys_role_menu` VALUES ('820', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '33', null);
  655. INSERT INTO `sys_role_menu` VALUES ('821', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '8', null);
  656. INSERT INTO `sys_role_menu` VALUES ('822', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '3', null);
  657. INSERT INTO `sys_role_menu` VALUES ('823', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '10', null);
  658. INSERT INTO `sys_role_menu` VALUES ('824', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '33', null);
  659. INSERT INTO `sys_role_menu` VALUES ('825', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '33', null);
  660. INSERT INTO `sys_role_menu` VALUES ('826', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '34', '用户-质控科-关键条目缺陷占比');
  661. INSERT INTO `sys_role_menu` VALUES ('827', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '35', '用户-质控科-出院人数统计');
  662. INSERT INTO `sys_role_menu` VALUES ('828', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '36', '用户-质控科-质控核查统计');
  663. -- ----------------------------
  664. -- Table structure for sys_role_permission
  665. -- ----------------------------
  666. DROP TABLE IF EXISTS `sys_role_permission`;
  667. CREATE TABLE `sys_role_permission` (
  668. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  669. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  670. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  671. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  672. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  673. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  674. `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  675. `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '资源id',
  676. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  677. PRIMARY KEY (`id`)
  678. ) ENGINE=InnoDB AUTO_INCREMENT=1660 DEFAULT CHARSET=utf8 COMMENT='角色和资源的映射表';
  679. -- ----------------------------
  680. -- Records of sys_role_permission
  681. -- ----------------------------
  682. INSERT INTO `sys_role_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '基础功能-获取用户、机构、菜单信息');
  683. INSERT INTO `sys_role_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '2', '基础功能-修改密码');
  684. INSERT INTO `sys_role_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '3', '用户-基础数据维护-获取医院模块数据信息');
  685. INSERT INTO `sys_role_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '4', '用户-基础数据维护-批量更新模块数据');
  686. INSERT INTO `sys_role_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '5', '用户-质控评分-分页');
  687. INSERT INTO `sys_role_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '6', '用户-条目数据维护-分页获取医院条目数据信息');
  688. INSERT INTO `sys_role_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '7', '用户-条目数据维护-修改医院条目数据信息');
  689. INSERT INTO `sys_role_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '8', '用户-条目数据维护-获取医院模块数据列表');
  690. INSERT INTO `sys_role_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '9', '控制台-病历相关统计');
  691. INSERT INTO `sys_role_permission` VALUES ('27', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '10', '用户-条目数据维护-模糊查询医院模块条目列表');
  692. INSERT INTO `sys_role_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '11', '用户-质控评分-新增质控条目');
  693. INSERT INTO `sys_role_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '12', '用户-质控评分-删除质控条目');
  694. INSERT INTO `sys_role_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '13', '用户-质控评分-修改质控条目');
  695. INSERT INTO `sys_role_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '14', '用户-质控评分-获取详情');
  696. INSERT INTO `sys_role_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '15', '控制台-缺陷相关统计');
  697. INSERT INTO `sys_role_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '16', '控制台-医院运营相关统计');
  698. INSERT INTO `sys_role_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '17', '用户-质控评分-评分');
  699. INSERT INTO `sys_role_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '18', '用户-权限管理-角色管理-获取角色列表信息');
  700. INSERT INTO `sys_role_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '19', '用户-权限管理-角色管理-获取角色菜权限单等数据');
  701. INSERT INTO `sys_role_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '20', '用户-权限管理-角色管理-修改角色菜单权限数据');
  702. INSERT INTO `sys_role_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '21', '用户-权限管理-用户管理-获取医院科室下拉列表信息');
  703. INSERT INTO `sys_role_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '22', '用户-权限管理-用户管理-获取角色下拉列表信息');
  704. INSERT INTO `sys_role_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '23', '用户-权限管理-用户管理-用户列表翻页信息查询');
  705. INSERT INTO `sys_role_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '24', '用户-权限管理-用户管理-获取用户科室');
  706. INSERT INTO `sys_role_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '25', '用户-权限管理-用户管理-获取用户角色');
  707. INSERT INTO `sys_role_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '26', '用户-权限管理-用户管理-用户启用');
  708. INSERT INTO `sys_role_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '27', '用户-权限管理-用户管理-用户停用');
  709. INSERT INTO `sys_role_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '28', '用户-权限管理-用户管理-编辑用户科室');
  710. INSERT INTO `sys_role_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '29', '用户-权限管理-用户管理-编辑用户角色');
  711. INSERT INTO `sys_role_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
  712. INSERT INTO `sys_role_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '31', '用户-质控评分-获取病历质控一览下用户科室下拉列表信息');
  713. INSERT INTO `sys_role_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '32', '用户-质控评分(科室)-分页');
  714. INSERT INTO `sys_role_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '33', '用户-质控评分(个人)-分页');
  715. INSERT INTO `sys_role_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '34', '用户-质控评分(科室)-评分');
  716. INSERT INTO `sys_role_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '35', '用户-质控评分(科室)-新增质控条目');
  717. INSERT INTO `sys_role_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '36', '用户-质控评分(科室)-删除质控条目');
  718. INSERT INTO `sys_role_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '37', '用户-质控评分(科室)-修改质控条目');
  719. INSERT INTO `sys_role_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '38', '用户-质控评分(科室)-获取详情');
  720. INSERT INTO `sys_role_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
  721. INSERT INTO `sys_role_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '40', '用户-质控评分(科室)-评分');
  722. INSERT INTO `sys_role_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '41', '用户-质控评分(科室)-新增质控条目');
  723. INSERT INTO `sys_role_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '42', '用户-质控评分(科室)-删除质控条目');
  724. INSERT INTO `sys_role_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '43', '用户-质控评分(科室)-修改质控条目');
  725. INSERT INTO `sys_role_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '44', '用户-质控评分(科室)-获取详情');
  726. INSERT INTO `sys_role_permission` VALUES ('502', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '45', '控制台-平均住院天数');
  727. INSERT INTO `sys_role_permission` VALUES ('503', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '46', '控制台-平均住院费用');
  728. INSERT INTO `sys_role_permission` VALUES ('504', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '47', '控制台-质控平均分按科室统计');
  729. INSERT INTO `sys_role_permission` VALUES ('505', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '48', '控制台-各科室甲级病历占比');
  730. INSERT INTO `sys_role_permission` VALUES ('506', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '49', '控制台-出院人数统计');
  731. INSERT INTO `sys_role_permission` VALUES ('507', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '50', '控制台-质控病历统计');
  732. INSERT INTO `sys_role_permission` VALUES ('508', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '51', '控制台-各模块缺陷占比排行');
  733. INSERT INTO `sys_role_permission` VALUES ('509', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '52', '控制台-条目缺陷占比');
  734. INSERT INTO `sys_role_permission` VALUES ('510', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '53', '控制台-各科室缺陷占比');
  735. INSERT INTO `sys_role_permission` VALUES ('511', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '54', '控制台(科室)-出院人数统计(科室)');
  736. INSERT INTO `sys_role_permission` VALUES ('512', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '55', '控制台(科室)-质控病历数统计(科室)');
  737. INSERT INTO `sys_role_permission` VALUES ('513', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '56', '控制台(科室)-各模块缺陷占比排行(科室)');
  738. INSERT INTO `sys_role_permission` VALUES ('514', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '57', '控制台(科室)-条目缺陷占比(科室)');
  739. INSERT INTO `sys_role_permission` VALUES ('1164', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '45', null);
  740. INSERT INTO `sys_role_permission` VALUES ('1165', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '46', null);
  741. INSERT INTO `sys_role_permission` VALUES ('1166', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '47', null);
  742. INSERT INTO `sys_role_permission` VALUES ('1167', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '48', null);
  743. INSERT INTO `sys_role_permission` VALUES ('1168', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '49', null);
  744. INSERT INTO `sys_role_permission` VALUES ('1169', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '50', null);
  745. INSERT INTO `sys_role_permission` VALUES ('1170', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '51', null);
  746. INSERT INTO `sys_role_permission` VALUES ('1171', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '52', null);
  747. INSERT INTO `sys_role_permission` VALUES ('1172', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '53', null);
  748. INSERT INTO `sys_role_permission` VALUES ('1173', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '1', null);
  749. INSERT INTO `sys_role_permission` VALUES ('1174', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '2', null);
  750. INSERT INTO `sys_role_permission` VALUES ('1175', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '4', null);
  751. INSERT INTO `sys_role_permission` VALUES ('1176', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '7', null);
  752. INSERT INTO `sys_role_permission` VALUES ('1177', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '17', null);
  753. INSERT INTO `sys_role_permission` VALUES ('1178', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '11', null);
  754. INSERT INTO `sys_role_permission` VALUES ('1179', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '12', null);
  755. INSERT INTO `sys_role_permission` VALUES ('1180', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '13', null);
  756. INSERT INTO `sys_role_permission` VALUES ('1182', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '59', '控制台-各模块缺陷占比_详情');
  757. INSERT INTO `sys_role_permission` VALUES ('1183', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '60', '控制台-条目缺陷占比_详情');
  758. INSERT INTO `sys_role_permission` VALUES ('1184', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '61', '异常数据监控-查询异常数据监控信息');
  759. INSERT INTO `sys_role_permission` VALUES ('1185', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '62', '异常数据监控-异常数据监控-查询异常数据监控信息');
  760. INSERT INTO `sys_role_permission` VALUES ('1186', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '63', '异常数据监控-异常数据监控-删除异常数据监控信息');
  761. INSERT INTO `sys_role_permission` VALUES ('1187', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '64', '控制台-科室平均住院天数_详情');
  762. INSERT INTO `sys_role_permission` VALUES ('1188', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '65', '控制台-科室平均住院花费_详情');
  763. INSERT INTO `sys_role_permission` VALUES ('1189', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '66', '控制台-各科室质控平均分_详情');
  764. INSERT INTO `sys_role_permission` VALUES ('1190', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '67', '控制台-各科室缺陷占比_详情');
  765. INSERT INTO `sys_role_permission` VALUES ('1191', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '68', '控制台-各科室甲级病历占比_详情');
  766. INSERT INTO `sys_role_permission` VALUES ('1192', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '69', '控制台(科室)-各模块缺陷占比_详情');
  767. INSERT INTO `sys_role_permission` VALUES ('1193', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '70', '控制台(科室)-条目缺陷占比_详情');
  768. INSERT INTO `sys_role_permission` VALUES ('1194', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '54', null);
  769. INSERT INTO `sys_role_permission` VALUES ('1195', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '55', null);
  770. INSERT INTO `sys_role_permission` VALUES ('1196', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '56', null);
  771. INSERT INTO `sys_role_permission` VALUES ('1197', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '57', null);
  772. INSERT INTO `sys_role_permission` VALUES ('1199', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '1', null);
  773. INSERT INTO `sys_role_permission` VALUES ('1200', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '2', null);
  774. INSERT INTO `sys_role_permission` VALUES ('1201', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '4', null);
  775. INSERT INTO `sys_role_permission` VALUES ('1202', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '7', null);
  776. INSERT INTO `sys_role_permission` VALUES ('1203', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '40', null);
  777. INSERT INTO `sys_role_permission` VALUES ('1204', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '41', null);
  778. INSERT INTO `sys_role_permission` VALUES ('1205', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '42', null);
  779. INSERT INTO `sys_role_permission` VALUES ('1206', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '43', null);
  780. INSERT INTO `sys_role_permission` VALUES ('1207', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '54', null);
  781. INSERT INTO `sys_role_permission` VALUES ('1208', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '55', null);
  782. INSERT INTO `sys_role_permission` VALUES ('1209', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '56', null);
  783. INSERT INTO `sys_role_permission` VALUES ('1210', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '57', null);
  784. INSERT INTO `sys_role_permission` VALUES ('1212', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '1', null);
  785. INSERT INTO `sys_role_permission` VALUES ('1213', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '2', null);
  786. INSERT INTO `sys_role_permission` VALUES ('1214', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '4', null);
  787. INSERT INTO `sys_role_permission` VALUES ('1215', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '7', null);
  788. INSERT INTO `sys_role_permission` VALUES ('1216', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '34', null);
  789. INSERT INTO `sys_role_permission` VALUES ('1217', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '35', null);
  790. INSERT INTO `sys_role_permission` VALUES ('1218', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '36', null);
  791. INSERT INTO `sys_role_permission` VALUES ('1219', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '59', '控制台-各模块缺陷占比_详情');
  792. INSERT INTO `sys_role_permission` VALUES ('1220', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '60', '控制台-条目缺陷占比_详情');
  793. INSERT INTO `sys_role_permission` VALUES ('1221', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '64', '控制台-科室平均住院天数_详情');
  794. INSERT INTO `sys_role_permission` VALUES ('1222', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '65', '控制台-科室平均住院花费_详情');
  795. INSERT INTO `sys_role_permission` VALUES ('1223', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '66', '控制台-各科室质控平均分_详情');
  796. INSERT INTO `sys_role_permission` VALUES ('1224', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '67', '控制台-各科室缺陷占比-缺陷详情');
  797. INSERT INTO `sys_role_permission` VALUES ('1225', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '68', '控制台-各科室甲级病历占比_详情');
  798. INSERT INTO `sys_role_permission` VALUES ('1226', 'N', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '69', '控制台(科室)-各模块缺陷占比_详情');
  799. INSERT INTO `sys_role_permission` VALUES ('1227', 'N', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '70', '控制台(科室)-条目缺陷占比_详情');
  800. INSERT INTO `sys_role_permission` VALUES ('1228', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '71', '控制台-各科室缺陷占比(组合)');
  801. INSERT INTO `sys_role_permission` VALUES ('1229', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '72', '控制台-病案首页合格率占比');
  802. INSERT INTO `sys_role_permission` VALUES ('1230', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '73', '控制台(科室)-各科室缺陷占比(科室)');
  803. INSERT INTO `sys_role_permission` VALUES ('1231', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '74', '控制台(科室)-病案首页合格率占比(科室)');
  804. INSERT INTO `sys_role_permission` VALUES ('1232', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '75', '控制台-病案首页合格率占比(首页)');
  805. INSERT INTO `sys_role_permission` VALUES ('1233', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '76', '控制台(科室)-病案首页合格率占比(首页)');
  806. INSERT INTO `sys_role_permission` VALUES ('1234', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '77', '控制台(科室)-科室缺陷占比-缺陷明细');
  807. INSERT INTO `sys_role_permission` VALUES ('1235', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '45', null);
  808. INSERT INTO `sys_role_permission` VALUES ('1236', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '46', null);
  809. INSERT INTO `sys_role_permission` VALUES ('1237', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '47', null);
  810. INSERT INTO `sys_role_permission` VALUES ('1238', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '48', null);
  811. INSERT INTO `sys_role_permission` VALUES ('1239', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '49', null);
  812. INSERT INTO `sys_role_permission` VALUES ('1240', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '50', null);
  813. INSERT INTO `sys_role_permission` VALUES ('1241', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '51', null);
  814. INSERT INTO `sys_role_permission` VALUES ('1242', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '52', null);
  815. INSERT INTO `sys_role_permission` VALUES ('1243', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '53', null);
  816. INSERT INTO `sys_role_permission` VALUES ('1244', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '66', null);
  817. INSERT INTO `sys_role_permission` VALUES ('1245', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '75', null);
  818. INSERT INTO `sys_role_permission` VALUES ('1246', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '72', null);
  819. INSERT INTO `sys_role_permission` VALUES ('1247', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '59', null);
  820. INSERT INTO `sys_role_permission` VALUES ('1248', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '60', null);
  821. INSERT INTO `sys_role_permission` VALUES ('1249', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '64', null);
  822. INSERT INTO `sys_role_permission` VALUES ('1250', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '65', null);
  823. INSERT INTO `sys_role_permission` VALUES ('1251', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '68', null);
  824. INSERT INTO `sys_role_permission` VALUES ('1252', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '67', null);
  825. INSERT INTO `sys_role_permission` VALUES ('1253', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '1', null);
  826. INSERT INTO `sys_role_permission` VALUES ('1254', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '2', null);
  827. INSERT INTO `sys_role_permission` VALUES ('1255', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '4', null);
  828. INSERT INTO `sys_role_permission` VALUES ('1256', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '7', null);
  829. INSERT INTO `sys_role_permission` VALUES ('1257', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '17', null);
  830. INSERT INTO `sys_role_permission` VALUES ('1258', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '11', null);
  831. INSERT INTO `sys_role_permission` VALUES ('1259', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '12', null);
  832. INSERT INTO `sys_role_permission` VALUES ('1260', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '13', null);
  833. INSERT INTO `sys_role_permission` VALUES ('1261', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '45', null);
  834. INSERT INTO `sys_role_permission` VALUES ('1262', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '46', null);
  835. INSERT INTO `sys_role_permission` VALUES ('1263', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '47', null);
  836. INSERT INTO `sys_role_permission` VALUES ('1264', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '48', null);
  837. INSERT INTO `sys_role_permission` VALUES ('1265', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '49', null);
  838. INSERT INTO `sys_role_permission` VALUES ('1266', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '50', null);
  839. INSERT INTO `sys_role_permission` VALUES ('1267', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '51', null);
  840. INSERT INTO `sys_role_permission` VALUES ('1268', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '52', null);
  841. INSERT INTO `sys_role_permission` VALUES ('1269', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '53', null);
  842. INSERT INTO `sys_role_permission` VALUES ('1270', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '66', null);
  843. INSERT INTO `sys_role_permission` VALUES ('1271', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '75', null);
  844. INSERT INTO `sys_role_permission` VALUES ('1272', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '72', null);
  845. INSERT INTO `sys_role_permission` VALUES ('1273', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '59', null);
  846. INSERT INTO `sys_role_permission` VALUES ('1274', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '60', null);
  847. INSERT INTO `sys_role_permission` VALUES ('1275', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '64', null);
  848. INSERT INTO `sys_role_permission` VALUES ('1276', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '65', null);
  849. INSERT INTO `sys_role_permission` VALUES ('1277', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '68', null);
  850. INSERT INTO `sys_role_permission` VALUES ('1278', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '71', null);
  851. INSERT INTO `sys_role_permission` VALUES ('1279', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '1', null);
  852. INSERT INTO `sys_role_permission` VALUES ('1280', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '2', null);
  853. INSERT INTO `sys_role_permission` VALUES ('1281', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '4', null);
  854. INSERT INTO `sys_role_permission` VALUES ('1282', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '7', null);
  855. INSERT INTO `sys_role_permission` VALUES ('1283', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '17', null);
  856. INSERT INTO `sys_role_permission` VALUES ('1284', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '11', null);
  857. INSERT INTO `sys_role_permission` VALUES ('1285', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '12', null);
  858. INSERT INTO `sys_role_permission` VALUES ('1286', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '13', null);
  859. INSERT INTO `sys_role_permission` VALUES ('1287', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '45', null);
  860. INSERT INTO `sys_role_permission` VALUES ('1288', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '46', null);
  861. INSERT INTO `sys_role_permission` VALUES ('1289', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '47', null);
  862. INSERT INTO `sys_role_permission` VALUES ('1290', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '48', null);
  863. INSERT INTO `sys_role_permission` VALUES ('1291', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '49', null);
  864. INSERT INTO `sys_role_permission` VALUES ('1292', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '50', null);
  865. INSERT INTO `sys_role_permission` VALUES ('1293', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '51', null);
  866. INSERT INTO `sys_role_permission` VALUES ('1294', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '52', null);
  867. INSERT INTO `sys_role_permission` VALUES ('1295', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '53', null);
  868. INSERT INTO `sys_role_permission` VALUES ('1296', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '66', null);
  869. INSERT INTO `sys_role_permission` VALUES ('1297', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '75', null);
  870. INSERT INTO `sys_role_permission` VALUES ('1298', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '72', null);
  871. INSERT INTO `sys_role_permission` VALUES ('1299', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '59', null);
  872. INSERT INTO `sys_role_permission` VALUES ('1300', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '60', null);
  873. INSERT INTO `sys_role_permission` VALUES ('1301', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '64', null);
  874. INSERT INTO `sys_role_permission` VALUES ('1302', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '65', null);
  875. INSERT INTO `sys_role_permission` VALUES ('1303', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '68', null);
  876. INSERT INTO `sys_role_permission` VALUES ('1304', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '67', null);
  877. INSERT INTO `sys_role_permission` VALUES ('1305', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '71', null);
  878. INSERT INTO `sys_role_permission` VALUES ('1306', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '1', null);
  879. INSERT INTO `sys_role_permission` VALUES ('1307', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '2', null);
  880. INSERT INTO `sys_role_permission` VALUES ('1308', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '4', null);
  881. INSERT INTO `sys_role_permission` VALUES ('1309', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '7', null);
  882. INSERT INTO `sys_role_permission` VALUES ('1310', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '17', null);
  883. INSERT INTO `sys_role_permission` VALUES ('1311', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '11', null);
  884. INSERT INTO `sys_role_permission` VALUES ('1312', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '12', null);
  885. INSERT INTO `sys_role_permission` VALUES ('1313', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '13', null);
  886. INSERT INTO `sys_role_permission` VALUES ('1314', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '45', null);
  887. INSERT INTO `sys_role_permission` VALUES ('1315', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '46', null);
  888. INSERT INTO `sys_role_permission` VALUES ('1316', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '47', null);
  889. INSERT INTO `sys_role_permission` VALUES ('1317', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '48', null);
  890. INSERT INTO `sys_role_permission` VALUES ('1318', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '49', null);
  891. INSERT INTO `sys_role_permission` VALUES ('1319', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '50', null);
  892. INSERT INTO `sys_role_permission` VALUES ('1320', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '51', null);
  893. INSERT INTO `sys_role_permission` VALUES ('1321', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '52', null);
  894. INSERT INTO `sys_role_permission` VALUES ('1322', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '53', null);
  895. INSERT INTO `sys_role_permission` VALUES ('1323', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '66', null);
  896. INSERT INTO `sys_role_permission` VALUES ('1324', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '75', null);
  897. INSERT INTO `sys_role_permission` VALUES ('1325', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '72', null);
  898. INSERT INTO `sys_role_permission` VALUES ('1326', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '59', null);
  899. INSERT INTO `sys_role_permission` VALUES ('1327', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '60', null);
  900. INSERT INTO `sys_role_permission` VALUES ('1328', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '64', null);
  901. INSERT INTO `sys_role_permission` VALUES ('1329', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '65', null);
  902. INSERT INTO `sys_role_permission` VALUES ('1330', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '68', null);
  903. INSERT INTO `sys_role_permission` VALUES ('1331', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '67', null);
  904. INSERT INTO `sys_role_permission` VALUES ('1332', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '71', null);
  905. INSERT INTO `sys_role_permission` VALUES ('1333', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '1', null);
  906. INSERT INTO `sys_role_permission` VALUES ('1334', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '2', null);
  907. INSERT INTO `sys_role_permission` VALUES ('1335', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '4', null);
  908. INSERT INTO `sys_role_permission` VALUES ('1336', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '7', null);
  909. INSERT INTO `sys_role_permission` VALUES ('1337', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '17', null);
  910. INSERT INTO `sys_role_permission` VALUES ('1338', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '11', null);
  911. INSERT INTO `sys_role_permission` VALUES ('1339', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '12', null);
  912. INSERT INTO `sys_role_permission` VALUES ('1340', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '13', null);
  913. INSERT INTO `sys_role_permission` VALUES ('1341', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '78', '用户-质控类型维护-分页列表');
  914. INSERT INTO `sys_role_permission` VALUES ('1342', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '79', '用户-质控类型维护-新增或更新');
  915. INSERT INTO `sys_role_permission` VALUES ('1343', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '80', '用户-质控类型维护-新增时质控条目分组信息');
  916. INSERT INTO `sys_role_permission` VALUES ('1344', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '81', '用户-质控类型维护-质控条目检索');
  917. INSERT INTO `sys_role_permission` VALUES ('1345', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '82', '用户-质控类型维护-删除');
  918. INSERT INTO `sys_role_permission` VALUES ('1346', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '83', '用户-质控类型维护-根据id返回内容');
  919. INSERT INTO `sys_role_permission` VALUES ('1347', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '84', '用户-质控类型维护-获取医院数据全部条目');
  920. INSERT INTO `sys_role_permission` VALUES ('1348', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '85', '用户-质控类型维护-根据id获取医院数据');
  921. INSERT INTO `sys_role_permission` VALUES ('1349', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '86', '用户-质控类型维护-添加和修改医院数据模块');
  922. INSERT INTO `sys_role_permission` VALUES ('1350', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '87', '用户-质控类型维护-删除医院数据模块');
  923. INSERT INTO `sys_role_permission` VALUES ('1351', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '88', '用户-质控类型维护-获取医院全部模块');
  924. INSERT INTO `sys_role_permission` VALUES ('1352', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '89', '控制台-条目缺陷占比(内页)');
  925. INSERT INTO `sys_role_permission` VALUES ('1353', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '90', '控制台(科室)-条目缺陷占比-科室(内页)');
  926. INSERT INTO `sys_role_permission` VALUES ('1354', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '45', null);
  927. INSERT INTO `sys_role_permission` VALUES ('1355', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '46', null);
  928. INSERT INTO `sys_role_permission` VALUES ('1356', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '47', null);
  929. INSERT INTO `sys_role_permission` VALUES ('1357', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '48', null);
  930. INSERT INTO `sys_role_permission` VALUES ('1358', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '49', null);
  931. INSERT INTO `sys_role_permission` VALUES ('1359', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '50', null);
  932. INSERT INTO `sys_role_permission` VALUES ('1360', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '51', null);
  933. INSERT INTO `sys_role_permission` VALUES ('1361', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '52', null);
  934. INSERT INTO `sys_role_permission` VALUES ('1362', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '53', null);
  935. INSERT INTO `sys_role_permission` VALUES ('1363', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '66', null);
  936. INSERT INTO `sys_role_permission` VALUES ('1364', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '75', null);
  937. INSERT INTO `sys_role_permission` VALUES ('1365', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '54', null);
  938. INSERT INTO `sys_role_permission` VALUES ('1366', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '55', null);
  939. INSERT INTO `sys_role_permission` VALUES ('1367', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '56', null);
  940. INSERT INTO `sys_role_permission` VALUES ('1368', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '57', null);
  941. INSERT INTO `sys_role_permission` VALUES ('1369', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '76', null);
  942. INSERT INTO `sys_role_permission` VALUES ('1370', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '72', null);
  943. INSERT INTO `sys_role_permission` VALUES ('1371', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '59', null);
  944. INSERT INTO `sys_role_permission` VALUES ('1372', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '64', null);
  945. INSERT INTO `sys_role_permission` VALUES ('1373', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '65', null);
  946. INSERT INTO `sys_role_permission` VALUES ('1374', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '68', null);
  947. INSERT INTO `sys_role_permission` VALUES ('1375', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '67', null);
  948. INSERT INTO `sys_role_permission` VALUES ('1376', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '71', null);
  949. INSERT INTO `sys_role_permission` VALUES ('1377', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '74', null);
  950. INSERT INTO `sys_role_permission` VALUES ('1378', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '69', null);
  951. INSERT INTO `sys_role_permission` VALUES ('1379', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '90', null);
  952. INSERT INTO `sys_role_permission` VALUES ('1380', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '73', null);
  953. INSERT INTO `sys_role_permission` VALUES ('1381', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '77', null);
  954. INSERT INTO `sys_role_permission` VALUES ('1382', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '1', null);
  955. INSERT INTO `sys_role_permission` VALUES ('1383', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '2', null);
  956. INSERT INTO `sys_role_permission` VALUES ('1384', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '4', null);
  957. INSERT INTO `sys_role_permission` VALUES ('1385', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '7', null);
  958. INSERT INTO `sys_role_permission` VALUES ('1386', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '17', null);
  959. INSERT INTO `sys_role_permission` VALUES ('1387', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '11', null);
  960. INSERT INTO `sys_role_permission` VALUES ('1388', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '12', null);
  961. INSERT INTO `sys_role_permission` VALUES ('1389', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '13', null);
  962. INSERT INTO `sys_role_permission` VALUES ('1390', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '91', '控制台-各科室质控平均分(首页)-根据内外科系统统计');
  963. INSERT INTO `sys_role_permission` VALUES ('1391', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '92', '控制台-各科室缺陷占比(内页)-根据内外科系统统计');
  964. INSERT INTO `sys_role_permission` VALUES ('1392', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '46', null);
  965. INSERT INTO `sys_role_permission` VALUES ('1393', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '47', null);
  966. INSERT INTO `sys_role_permission` VALUES ('1394', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '48', null);
  967. INSERT INTO `sys_role_permission` VALUES ('1395', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '49', null);
  968. INSERT INTO `sys_role_permission` VALUES ('1396', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '50', null);
  969. INSERT INTO `sys_role_permission` VALUES ('1397', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '51', null);
  970. INSERT INTO `sys_role_permission` VALUES ('1398', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '52', null);
  971. INSERT INTO `sys_role_permission` VALUES ('1399', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '53', null);
  972. INSERT INTO `sys_role_permission` VALUES ('1400', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '66', null);
  973. INSERT INTO `sys_role_permission` VALUES ('1401', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '75', null);
  974. INSERT INTO `sys_role_permission` VALUES ('1402', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '54', null);
  975. INSERT INTO `sys_role_permission` VALUES ('1403', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '55', null);
  976. INSERT INTO `sys_role_permission` VALUES ('1404', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '56', null);
  977. INSERT INTO `sys_role_permission` VALUES ('1405', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '57', null);
  978. INSERT INTO `sys_role_permission` VALUES ('1406', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '76', null);
  979. INSERT INTO `sys_role_permission` VALUES ('1407', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '72', null);
  980. INSERT INTO `sys_role_permission` VALUES ('1408', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '59', null);
  981. INSERT INTO `sys_role_permission` VALUES ('1409', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '64', null);
  982. INSERT INTO `sys_role_permission` VALUES ('1410', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '65', null);
  983. INSERT INTO `sys_role_permission` VALUES ('1411', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '68', null);
  984. INSERT INTO `sys_role_permission` VALUES ('1412', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '67', null);
  985. INSERT INTO `sys_role_permission` VALUES ('1413', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '71', null);
  986. INSERT INTO `sys_role_permission` VALUES ('1414', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '74', null);
  987. INSERT INTO `sys_role_permission` VALUES ('1415', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '69', null);
  988. INSERT INTO `sys_role_permission` VALUES ('1416', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '90', null);
  989. INSERT INTO `sys_role_permission` VALUES ('1417', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '73', null);
  990. INSERT INTO `sys_role_permission` VALUES ('1418', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '77', null);
  991. INSERT INTO `sys_role_permission` VALUES ('1419', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '1', null);
  992. INSERT INTO `sys_role_permission` VALUES ('1420', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '2', null);
  993. INSERT INTO `sys_role_permission` VALUES ('1421', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '4', null);
  994. INSERT INTO `sys_role_permission` VALUES ('1422', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '7', null);
  995. INSERT INTO `sys_role_permission` VALUES ('1423', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '17', null);
  996. INSERT INTO `sys_role_permission` VALUES ('1424', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '11', null);
  997. INSERT INTO `sys_role_permission` VALUES ('1425', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '12', null);
  998. INSERT INTO `sys_role_permission` VALUES ('1426', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '13', null);
  999. INSERT INTO `sys_role_permission` VALUES ('1427', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '45', null);
  1000. INSERT INTO `sys_role_permission` VALUES ('1428', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '46', null);
  1001. INSERT INTO `sys_role_permission` VALUES ('1429', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '47', null);
  1002. INSERT INTO `sys_role_permission` VALUES ('1430', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '48', null);
  1003. INSERT INTO `sys_role_permission` VALUES ('1431', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '49', null);
  1004. INSERT INTO `sys_role_permission` VALUES ('1432', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '50', null);
  1005. INSERT INTO `sys_role_permission` VALUES ('1433', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '51', null);
  1006. INSERT INTO `sys_role_permission` VALUES ('1434', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '52', null);
  1007. INSERT INTO `sys_role_permission` VALUES ('1435', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '53', null);
  1008. INSERT INTO `sys_role_permission` VALUES ('1436', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '66', null);
  1009. INSERT INTO `sys_role_permission` VALUES ('1437', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '75', null);
  1010. INSERT INTO `sys_role_permission` VALUES ('1438', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '91', null);
  1011. INSERT INTO `sys_role_permission` VALUES ('1439', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '54', null);
  1012. INSERT INTO `sys_role_permission` VALUES ('1440', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '55', null);
  1013. INSERT INTO `sys_role_permission` VALUES ('1441', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '56', null);
  1014. INSERT INTO `sys_role_permission` VALUES ('1442', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '57', null);
  1015. INSERT INTO `sys_role_permission` VALUES ('1443', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '76', null);
  1016. INSERT INTO `sys_role_permission` VALUES ('1444', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '72', null);
  1017. INSERT INTO `sys_role_permission` VALUES ('1445', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '59', null);
  1018. INSERT INTO `sys_role_permission` VALUES ('1446', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '64', null);
  1019. INSERT INTO `sys_role_permission` VALUES ('1447', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '65', null);
  1020. INSERT INTO `sys_role_permission` VALUES ('1448', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '68', null);
  1021. INSERT INTO `sys_role_permission` VALUES ('1449', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '67', null);
  1022. INSERT INTO `sys_role_permission` VALUES ('1450', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '71', null);
  1023. INSERT INTO `sys_role_permission` VALUES ('1451', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '74', null);
  1024. INSERT INTO `sys_role_permission` VALUES ('1452', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '69', null);
  1025. INSERT INTO `sys_role_permission` VALUES ('1453', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '90', null);
  1026. INSERT INTO `sys_role_permission` VALUES ('1454', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '73', null);
  1027. INSERT INTO `sys_role_permission` VALUES ('1455', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '77', null);
  1028. INSERT INTO `sys_role_permission` VALUES ('1456', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '1', null);
  1029. INSERT INTO `sys_role_permission` VALUES ('1457', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '2', null);
  1030. INSERT INTO `sys_role_permission` VALUES ('1458', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '4', null);
  1031. INSERT INTO `sys_role_permission` VALUES ('1459', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '7', null);
  1032. INSERT INTO `sys_role_permission` VALUES ('1460', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '17', null);
  1033. INSERT INTO `sys_role_permission` VALUES ('1461', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '11', null);
  1034. INSERT INTO `sys_role_permission` VALUES ('1462', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '12', null);
  1035. INSERT INTO `sys_role_permission` VALUES ('1463', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '13', null);
  1036. INSERT INTO `sys_role_permission` VALUES ('1464', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '93', null);
  1037. INSERT INTO `sys_role_permission` VALUES ('1465', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '45', null);
  1038. INSERT INTO `sys_role_permission` VALUES ('1466', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '46', null);
  1039. INSERT INTO `sys_role_permission` VALUES ('1467', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '47', null);
  1040. INSERT INTO `sys_role_permission` VALUES ('1468', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '48', null);
  1041. INSERT INTO `sys_role_permission` VALUES ('1469', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '49', null);
  1042. INSERT INTO `sys_role_permission` VALUES ('1470', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '50', null);
  1043. INSERT INTO `sys_role_permission` VALUES ('1471', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '51', null);
  1044. INSERT INTO `sys_role_permission` VALUES ('1472', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '52', null);
  1045. INSERT INTO `sys_role_permission` VALUES ('1473', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '53', null);
  1046. INSERT INTO `sys_role_permission` VALUES ('1474', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '66', null);
  1047. INSERT INTO `sys_role_permission` VALUES ('1475', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '75', null);
  1048. INSERT INTO `sys_role_permission` VALUES ('1476', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '91', null);
  1049. INSERT INTO `sys_role_permission` VALUES ('1477', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '54', null);
  1050. INSERT INTO `sys_role_permission` VALUES ('1478', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '55', null);
  1051. INSERT INTO `sys_role_permission` VALUES ('1479', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '56', null);
  1052. INSERT INTO `sys_role_permission` VALUES ('1480', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '57', null);
  1053. INSERT INTO `sys_role_permission` VALUES ('1481', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '69', null);
  1054. INSERT INTO `sys_role_permission` VALUES ('1482', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '70', null);
  1055. INSERT INTO `sys_role_permission` VALUES ('1483', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
  1056. INSERT INTO `sys_role_permission` VALUES ('1484', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
  1057. INSERT INTO `sys_role_permission` VALUES ('1485', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '4', null);
  1058. INSERT INTO `sys_role_permission` VALUES ('1486', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
  1059. INSERT INTO `sys_role_permission` VALUES ('1487', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '34', null);
  1060. INSERT INTO `sys_role_permission` VALUES ('1488', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '35', null);
  1061. INSERT INTO `sys_role_permission` VALUES ('1489', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '36', null);
  1062. INSERT INTO `sys_role_permission` VALUES ('1490', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '45', null);
  1063. INSERT INTO `sys_role_permission` VALUES ('1491', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '46', null);
  1064. INSERT INTO `sys_role_permission` VALUES ('1492', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '47', null);
  1065. INSERT INTO `sys_role_permission` VALUES ('1493', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '48', null);
  1066. INSERT INTO `sys_role_permission` VALUES ('1494', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '49', null);
  1067. INSERT INTO `sys_role_permission` VALUES ('1495', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '50', null);
  1068. INSERT INTO `sys_role_permission` VALUES ('1496', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '51', null);
  1069. INSERT INTO `sys_role_permission` VALUES ('1497', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '52', null);
  1070. INSERT INTO `sys_role_permission` VALUES ('1498', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '53', null);
  1071. INSERT INTO `sys_role_permission` VALUES ('1499', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '66', null);
  1072. INSERT INTO `sys_role_permission` VALUES ('1500', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '75', null);
  1073. INSERT INTO `sys_role_permission` VALUES ('1501', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '91', null);
  1074. INSERT INTO `sys_role_permission` VALUES ('1502', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '54', null);
  1075. INSERT INTO `sys_role_permission` VALUES ('1503', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '55', null);
  1076. INSERT INTO `sys_role_permission` VALUES ('1504', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '56', null);
  1077. INSERT INTO `sys_role_permission` VALUES ('1505', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '57', null);
  1078. INSERT INTO `sys_role_permission` VALUES ('1506', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '76', null);
  1079. INSERT INTO `sys_role_permission` VALUES ('1507', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '72', null);
  1080. INSERT INTO `sys_role_permission` VALUES ('1508', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '59', null);
  1081. INSERT INTO `sys_role_permission` VALUES ('1509', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '60', null);
  1082. INSERT INTO `sys_role_permission` VALUES ('1510', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '89', null);
  1083. INSERT INTO `sys_role_permission` VALUES ('1511', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '64', null);
  1084. INSERT INTO `sys_role_permission` VALUES ('1512', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '65', null);
  1085. INSERT INTO `sys_role_permission` VALUES ('1513', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '68', null);
  1086. INSERT INTO `sys_role_permission` VALUES ('1514', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '67', null);
  1087. INSERT INTO `sys_role_permission` VALUES ('1515', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '71', null);
  1088. INSERT INTO `sys_role_permission` VALUES ('1516', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '74', null);
  1089. INSERT INTO `sys_role_permission` VALUES ('1517', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '69', null);
  1090. INSERT INTO `sys_role_permission` VALUES ('1518', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '90', null);
  1091. INSERT INTO `sys_role_permission` VALUES ('1519', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '73', null);
  1092. INSERT INTO `sys_role_permission` VALUES ('1520', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '77', null);
  1093. INSERT INTO `sys_role_permission` VALUES ('1521', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '1', null);
  1094. INSERT INTO `sys_role_permission` VALUES ('1522', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '2', null);
  1095. INSERT INTO `sys_role_permission` VALUES ('1523', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '4', null);
  1096. INSERT INTO `sys_role_permission` VALUES ('1524', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '7', null);
  1097. INSERT INTO `sys_role_permission` VALUES ('1525', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '17', null);
  1098. INSERT INTO `sys_role_permission` VALUES ('1526', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '11', null);
  1099. INSERT INTO `sys_role_permission` VALUES ('1527', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '12', null);
  1100. INSERT INTO `sys_role_permission` VALUES ('1528', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '13', null);
  1101. INSERT INTO `sys_role_permission` VALUES ('1529', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '45', null);
  1102. INSERT INTO `sys_role_permission` VALUES ('1530', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '46', null);
  1103. INSERT INTO `sys_role_permission` VALUES ('1531', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '47', null);
  1104. INSERT INTO `sys_role_permission` VALUES ('1532', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '48', null);
  1105. INSERT INTO `sys_role_permission` VALUES ('1533', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '49', null);
  1106. INSERT INTO `sys_role_permission` VALUES ('1534', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '50', null);
  1107. INSERT INTO `sys_role_permission` VALUES ('1535', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '51', null);
  1108. INSERT INTO `sys_role_permission` VALUES ('1536', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '52', null);
  1109. INSERT INTO `sys_role_permission` VALUES ('1537', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '53', null);
  1110. INSERT INTO `sys_role_permission` VALUES ('1538', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '66', null);
  1111. INSERT INTO `sys_role_permission` VALUES ('1539', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '75', null);
  1112. INSERT INTO `sys_role_permission` VALUES ('1540', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '91', null);
  1113. INSERT INTO `sys_role_permission` VALUES ('1541', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '54', null);
  1114. INSERT INTO `sys_role_permission` VALUES ('1542', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '55', null);
  1115. INSERT INTO `sys_role_permission` VALUES ('1543', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '56', null);
  1116. INSERT INTO `sys_role_permission` VALUES ('1544', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '57', null);
  1117. INSERT INTO `sys_role_permission` VALUES ('1545', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '76', null);
  1118. INSERT INTO `sys_role_permission` VALUES ('1546', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '72', null);
  1119. INSERT INTO `sys_role_permission` VALUES ('1547', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '59', null);
  1120. INSERT INTO `sys_role_permission` VALUES ('1548', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '60', null);
  1121. INSERT INTO `sys_role_permission` VALUES ('1549', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '89', null);
  1122. INSERT INTO `sys_role_permission` VALUES ('1550', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '64', null);
  1123. INSERT INTO `sys_role_permission` VALUES ('1551', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '65', null);
  1124. INSERT INTO `sys_role_permission` VALUES ('1552', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '68', null);
  1125. INSERT INTO `sys_role_permission` VALUES ('1553', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '67', null);
  1126. INSERT INTO `sys_role_permission` VALUES ('1554', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '71', null);
  1127. INSERT INTO `sys_role_permission` VALUES ('1555', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '92', null);
  1128. INSERT INTO `sys_role_permission` VALUES ('1556', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '74', null);
  1129. INSERT INTO `sys_role_permission` VALUES ('1557', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '69', null);
  1130. INSERT INTO `sys_role_permission` VALUES ('1558', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '70', null);
  1131. INSERT INTO `sys_role_permission` VALUES ('1559', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '90', null);
  1132. INSERT INTO `sys_role_permission` VALUES ('1560', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '73', null);
  1133. INSERT INTO `sys_role_permission` VALUES ('1561', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '77', null);
  1134. INSERT INTO `sys_role_permission` VALUES ('1562', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '1', null);
  1135. INSERT INTO `sys_role_permission` VALUES ('1563', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '2', null);
  1136. INSERT INTO `sys_role_permission` VALUES ('1564', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '4', null);
  1137. INSERT INTO `sys_role_permission` VALUES ('1565', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '7', null);
  1138. INSERT INTO `sys_role_permission` VALUES ('1566', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '17', null);
  1139. INSERT INTO `sys_role_permission` VALUES ('1567', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '11', null);
  1140. INSERT INTO `sys_role_permission` VALUES ('1568', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '12', null);
  1141. INSERT INTO `sys_role_permission` VALUES ('1569', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '13', null);
  1142. INSERT INTO `sys_role_permission` VALUES ('1570', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '45', null);
  1143. INSERT INTO `sys_role_permission` VALUES ('1571', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '46', null);
  1144. INSERT INTO `sys_role_permission` VALUES ('1572', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '47', null);
  1145. INSERT INTO `sys_role_permission` VALUES ('1573', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '48', null);
  1146. INSERT INTO `sys_role_permission` VALUES ('1574', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '49', null);
  1147. INSERT INTO `sys_role_permission` VALUES ('1575', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '50', null);
  1148. INSERT INTO `sys_role_permission` VALUES ('1576', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '51', null);
  1149. INSERT INTO `sys_role_permission` VALUES ('1577', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '52', null);
  1150. INSERT INTO `sys_role_permission` VALUES ('1578', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '53', null);
  1151. INSERT INTO `sys_role_permission` VALUES ('1579', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '66', null);
  1152. INSERT INTO `sys_role_permission` VALUES ('1580', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '75', null);
  1153. INSERT INTO `sys_role_permission` VALUES ('1581', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '91', null);
  1154. INSERT INTO `sys_role_permission` VALUES ('1582', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '54', null);
  1155. INSERT INTO `sys_role_permission` VALUES ('1583', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '55', null);
  1156. INSERT INTO `sys_role_permission` VALUES ('1584', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '56', null);
  1157. INSERT INTO `sys_role_permission` VALUES ('1585', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '57', null);
  1158. INSERT INTO `sys_role_permission` VALUES ('1586', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '76', null);
  1159. INSERT INTO `sys_role_permission` VALUES ('1587', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '72', null);
  1160. INSERT INTO `sys_role_permission` VALUES ('1588', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '59', null);
  1161. INSERT INTO `sys_role_permission` VALUES ('1589', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '60', null);
  1162. INSERT INTO `sys_role_permission` VALUES ('1590', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '89', null);
  1163. INSERT INTO `sys_role_permission` VALUES ('1591', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '64', null);
  1164. INSERT INTO `sys_role_permission` VALUES ('1592', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '65', null);
  1165. INSERT INTO `sys_role_permission` VALUES ('1593', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '68', null);
  1166. INSERT INTO `sys_role_permission` VALUES ('1594', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '67', null);
  1167. INSERT INTO `sys_role_permission` VALUES ('1595', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '71', null);
  1168. INSERT INTO `sys_role_permission` VALUES ('1596', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '92', null);
  1169. INSERT INTO `sys_role_permission` VALUES ('1597', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '74', null);
  1170. INSERT INTO `sys_role_permission` VALUES ('1598', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '69', null);
  1171. INSERT INTO `sys_role_permission` VALUES ('1599', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '70', null);
  1172. INSERT INTO `sys_role_permission` VALUES ('1600', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '90', null);
  1173. INSERT INTO `sys_role_permission` VALUES ('1601', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '73', null);
  1174. INSERT INTO `sys_role_permission` VALUES ('1602', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '77', null);
  1175. INSERT INTO `sys_role_permission` VALUES ('1603', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '1', null);
  1176. INSERT INTO `sys_role_permission` VALUES ('1604', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '2', null);
  1177. INSERT INTO `sys_role_permission` VALUES ('1605', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '4', null);
  1178. INSERT INTO `sys_role_permission` VALUES ('1606', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '7', null);
  1179. INSERT INTO `sys_role_permission` VALUES ('1607', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '17', null);
  1180. INSERT INTO `sys_role_permission` VALUES ('1608', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '11', null);
  1181. INSERT INTO `sys_role_permission` VALUES ('1609', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '12', null);
  1182. INSERT INTO `sys_role_permission` VALUES ('1610', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '13', null);
  1183. INSERT INTO `sys_role_permission` VALUES ('1611', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '1', null);
  1184. INSERT INTO `sys_role_permission` VALUES ('1612', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '2', null);
  1185. INSERT INTO `sys_role_permission` VALUES ('1613', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '40', null);
  1186. INSERT INTO `sys_role_permission` VALUES ('1614', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '41', null);
  1187. INSERT INTO `sys_role_permission` VALUES ('1615', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '42', null);
  1188. INSERT INTO `sys_role_permission` VALUES ('1616', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '43', null);
  1189. INSERT INTO `sys_role_permission` VALUES ('1617', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '1', null);
  1190. INSERT INTO `sys_role_permission` VALUES ('1618', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '2', null);
  1191. INSERT INTO `sys_role_permission` VALUES ('1619', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '34', null);
  1192. INSERT INTO `sys_role_permission` VALUES ('1620', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '35', null);
  1193. INSERT INTO `sys_role_permission` VALUES ('1621', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '36', null);
  1194. INSERT INTO `sys_role_permission` VALUES ('1622', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '37', null);
  1195. INSERT INTO `sys_role_permission` VALUES ('1623', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '94', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页(全院)');
  1196. INSERT INTO `sys_role_permission` VALUES ('1624', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '95', '数据报表明细(科室)-条目缺陷占比-条目缺陷占比质控详情页(科室)');
  1197. INSERT INTO `sys_role_permission` VALUES ('1625', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
  1198. INSERT INTO `sys_role_permission` VALUES ('1626', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
  1199. INSERT INTO `sys_role_permission` VALUES ('1627', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '4', null);
  1200. INSERT INTO `sys_role_permission` VALUES ('1628', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
  1201. INSERT INTO `sys_role_permission` VALUES ('1629', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '17', null);
  1202. INSERT INTO `sys_role_permission` VALUES ('1630', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '11', null);
  1203. INSERT INTO `sys_role_permission` VALUES ('1631', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '12', null);
  1204. INSERT INTO `sys_role_permission` VALUES ('1632', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '13', null);
  1205. INSERT INTO `sys_role_permission` VALUES ('1633', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '34', null);
  1206. INSERT INTO `sys_role_permission` VALUES ('1634', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '35', null);
  1207. INSERT INTO `sys_role_permission` VALUES ('1635', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '36', null);
  1208. INSERT INTO `sys_role_permission` VALUES ('1636', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '37', null);
  1209. INSERT INTO `sys_role_permission` VALUES ('1637', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '40', null);
  1210. INSERT INTO `sys_role_permission` VALUES ('1638', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '41', null);
  1211. INSERT INTO `sys_role_permission` VALUES ('1639', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '42', null);
  1212. INSERT INTO `sys_role_permission` VALUES ('1640', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '43', null);
  1213. INSERT INTO `sys_role_permission` VALUES ('1641', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '1', null);
  1214. INSERT INTO `sys_role_permission` VALUES ('1642', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '2', null);
  1215. INSERT INTO `sys_role_permission` VALUES ('1643', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '40', null);
  1216. INSERT INTO `sys_role_permission` VALUES ('1644', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '41', null);
  1217. INSERT INTO `sys_role_permission` VALUES ('1645', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '42', null);
  1218. INSERT INTO `sys_role_permission` VALUES ('1646', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '43', null);
  1219. INSERT INTO `sys_role_permission` VALUES ('1647', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '96', null);
  1220. INSERT INTO `sys_role_permission` VALUES ('1648', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '97', null);
  1221. INSERT INTO `sys_role_permission` VALUES ('1649', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '98', null);
  1222. INSERT INTO `sys_role_permission` VALUES ('1650', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '99', null);
  1223. INSERT INTO `sys_role_permission` VALUES ('1651', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '96', null);
  1224. INSERT INTO `sys_role_permission` VALUES ('1652', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '97', null);
  1225. INSERT INTO `sys_role_permission` VALUES ('1653', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '98', null);
  1226. INSERT INTO `sys_role_permission` VALUES ('1654', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '99', null);
  1227. INSERT INTO `sys_role_permission` VALUES ('1655', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '100', '数据报表明细-关键条目缺陷占比');
  1228. INSERT INTO `sys_role_permission` VALUES ('1656', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '101', null);
  1229. INSERT INTO `sys_role_permission` VALUES ('1657', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '101', null);
  1230. INSERT INTO `sys_role_permission` VALUES ('1658', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '102', '数据报表明细-出院人数统计');
  1231. INSERT INTO `sys_role_permission` VALUES ('1659', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '103', '数据报表明细-质控核查统计');