Accueil Explorer Aide
S'inscrire Connexion
java
/
mrqc-sys
2
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Branche: demo/edit
Branches Tags
mrqc-sys
/
doc
/
029.20201224v2.0.0
/
qc_initv2.0.0.sql

qc_initv2.0.0.sql 75 KB
Lien permanent Historique Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334 
  1. use `qc`;
    2. 

  2. /**
    3. 

  3. 注意：
    4. 

  4. 1、中间表的新增或修改需要按照实际的唯一字段来进行操作
    5. 

  5. 例如：新增sys_role_menu中数据需要sys_menu中的id、menu_id 的id否则可能会失效！！！
    6. 

  6. 2、按照顺序执行
    7. 

  7.  */
    8. 

  8. -- 最先执行字段添加
    9. 

  9.   ALTER TABLE `sys_menu_permission` ADD   `order_nu` INT(11) DEFAULT NULL COMMENT '排序' AFTER `remark`;
    10. 

  10. -- 1、开放科室菜单
    11. 

  11. UPDATE `sys_menu` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='数据报表明细(科室)', `parent_id`='-1', `code`='YH-KSZR', `show_status`='1', `maintain_status`='1', `order_no`='-7', `remark`='用户-科室主任' WHERE (`code`='YH-KSZR');
    12. 

  12. UPDATE `sys_menu` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='控制台(科室)', `parent_id`='-1', `code`='YH-KZTKS', `show_status`='1', `maintain_status`='1', `order_no`='-9', `remark`='用户-控制台（科室）' WHERE (`code`='YH-KZTKS');
    13. 

  13. 

  14. -- 2、科室菜单补齐---可能需要修改名称
    15. 

  15. -- (1)
    16. 

  16. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比', '18', 'YH-KSZR-GJTMQXZB_XQ', '1', '1', '4', '用户-科室主任-关键条目缺陷占比_详情');
    17. 

  17. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', '18', 'YH-KSZR-CYRSTJ_XQ', '1', '1', '6', '用户-科室主任-出院人数统计_详情');
    18. 

  18. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院人数统计', '18', 'YH-KSZR-RYRSTJ_XQ', '1', '1', '6', '用户-科室主任-入院人数统计_详情');
    19. 

  19. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计', '18', 'YH-KSZR-ZKHCTJ_XQ', '1', '1', '7', '用户-科室主任-质控核查统计_详情');
    20. 

  20. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '时效性相关统计', '18', 'YH-KSZR-SXXXGTJ_XQ', '1', '1', '8', '用户-科室主任-时效性相关统计_详情');
    21. 

  21. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31日再入院病人数', '18', 'YH-KSZR-31TZRYRS_XQ', '1', '1', '9', '用户-科室主任-31日再入院病人数_详情');
    22. 

  22. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '终末病历稽查表', '17', 'YH-ZKK-ZMBLJCB', '1', '1', '15', '用户-质控科-终末病历稽查表');
    23. 

  23. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '终末病历稽查表', '18', 'YH-KSZR-ZMBLJCS_XQ', '1', '1', '10', '用户-科室主任-终末病历稽查表_详情');
    24. 

  24. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `show_status`, `maintain_status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '运行病历稽查表', '18', 'YH-KSZR-YXBLJCS_XQ', '1', '1', '10', '用户-科室主任-运行病历稽查表_详情');
    25. 

  25. 

  26. -- (2)
    27. 

  27. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '41', NULL);
    28. 

  28. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '41', NULL);
    29. 

  29. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '41', NULL);
    30. 

  30. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '42', NULL);
    31. 

  31. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '42', NULL);
    32. 

  32. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '42', NULL);
    33. 

  33. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '43', NULL);
    34. 

  34. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '43', NULL);
    35. 

  35. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '43', NULL);
    36. 

  36. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '44', NULL);
    37. 

  37. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '44', NULL);
    38. 

  38. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '44', NULL);
    39. 

  39. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '45', NULL);
    40. 

  40. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '45', NULL);
    41. 

  41. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '45', NULL);
    42. 

  42. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1','46', NULL);
    43. 

  43. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '46', NULL);
    44. 

  44. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '46', NULL);
    45. 

  45. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1','47', NULL);
    46. 

  46. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '47', NULL);
    47. 

  47. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '47', NULL);
    48. 

  48. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1','48', NULL);
    49. 

  49. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '48', NULL);
    50. 

  50. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '48', NULL);
    51. 

  51. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1','49', NULL);
    52. 

  52. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '49', NULL);
    53. 

  53. INSERT INTO `sys_role_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '49', NULL);
    54. 

  54. 

  55. 

  56. -- 权限名称修改开始-----------------------------------------------
    57. 

  57. -- 一、全院控制台
    58. 

  58. -- 1、去掉多余的权限
    59. 

  59. UPDATE `sys_permission` SET  `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室质控平均分_详情', `code`='FUNC000066', `permissionUrl`='/console/getAverageScoreByDeptPage', `method`='ALL', `descritpion`='控制台-各科室质控平均分_详情', `remark`=NULL WHERE (`permissionUrl`='/console/getAverageScoreByDeptPage');
    60. 

  60. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病历相关统计', `code`='FUNC000009', `permissionUrl`='/console/mrStatistics', `method`='ALL', `descritpion`='控制台-病历相关统计', `remark`=NULL WHERE (`permissionUrl`='/console/mrStatistics');
    61. 

  61. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='缺陷相关统计', `code`='FUNC000015', `permissionUrl`='/console/resultStatistics', `method`='ALL', `descritpion`='控制台-缺陷相关统计', `remark`=NULL WHERE (`permissionUrl`='/console/resultStatistics');
    62. 

  62. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='平均值相关统计', `code`='FUNC000016', `permissionUrl`='/console/averageStatistics', `method`='ALL', `descritpion`='控制台-平均值相关统计', `remark`=NULL WHERE (`permissionUrl`='/console/averageStatistics');
    63. 

  63. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='平均住院天数', `code`='FUNC000045', `permissionUrl`='/console/getAverageDayNum', `method`='ALL', `descritpion`='控制台-平均住院天数', `remark`=NULL WHERE (`permissionUrl`='/console/getAverageDayNum');
    64. 

  64. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='平均住院费用', `code`='FUNC000046', `permissionUrl`='/console/getAverageFee', `method`='ALL', `descritpion`='控制台-平均住院费用', `remark`=NULL WHERE (`permissionUrl`='/console/getAverageFee');
    65. 

  65. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室甲级病历占比', `code`='FUNC000048', `permissionUrl`='/console/getLevelResultDept', `method`='ALL', `descritpion`='控制台-各科室甲级病历占比', `remark`=NULL WHERE (`permissionUrl`='/console/getLevelResultDept');
    66. 

  66. -- 2、现有的名称替换
    67. 

  67. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='出院人数统计图表', `code`='FUNC000049', `permissionUrl`='/console/leaveHosCount', `method`='ALL', `descritpion`='控制台-出院人数统计', `remark`=NULL WHERE (`permissionUrl`='/console/leaveHosCount');
    68. 

  68. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各模块缺陷占比排行图表', `code`='FUNC000051', `permissionUrl`='/console/entryCountGroupByCase', `method`='ALL', `descritpion`='控制台-各模块缺陷占比排行', `remark`=NULL WHERE (`permissionUrl`='/console/entryCountGroupByCase');
    69. 

  69. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比图表', `code`='FUNC000052', `permissionUrl`='/console/entryCountGroupByEntry', `method`='ALL', `descritpion`='控制台-条目缺陷占比', `remark`=NULL WHERE (`permissionUrl`='/console/entryCountGroupByEntry');
    70. 

  70. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病历评分等级占比图表', `code`='FUNC000055', `permissionUrl`='/consoleByDept/mrCountByDept', `method`='ALL', `descritpion`='控制台（科室）-质控病历数统计（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/mrCountByDept');
    71. 

  71. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室病历等级占比图表', `code`='FUNC000053', `permissionUrl`='/console/qcResultLevelPercent', `method`='ALL', `descritpion`='控制台-各科室病历等级占比图表', `remark`=NULL WHERE (`permissionUrl`='/console/entryByDept');
    72. 

  72. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页合格率占比图表', `code`='FUNC000075', `permissionUrl`='/console/homePageLevelLimit', `method`='ALL', `descritpion`='控制台-病案首页合格率占比（首页）', `remark`=NULL WHERE (`permissionUrl`='/console/homePageLevelLimit');
    73. 

  73. 

  74. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室质控平均分柱状图表', `code`='FUNC000047', `permissionUrl`='/console/getAverageScore', `method`='ALL', `descritpion`='控制台-质控平均分按科室统计', `remark`=NULL WHERE (`permissionUrl`='/console/getAverageScore');
    75. 

  75. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室质控平均分柱状图表(内外科系统)', `code`='FUNC000091', `permissionUrl`='/console/getAverageScoreByDeptClass', `method`='ALL', `descritpion`='控制台-各科室质控平均分（首页）-根据内外科系统统计', `remark`=NULL WHERE (`permissionUrl`='/console/getAverageScoreByDeptClass');
    76. 

  76. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病历评分等级占比图表', `code`='FUNC000050', `permissionUrl`='/console/mrCount', `method`='ALL', `descritpion`='控制台-质控病历统计', `remark`=NULL WHERE (`permissionUrl`='/console/mrCount');
    77. 

  77. 

  78. -- 3、新增权限
    79. 

  79. INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院人数统计图表(运行)', '', '/console/beHosCount', 'ALL', '控制台-入院人数统计图表(运行)', NULL);
    80. 

  80. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`, `order_nu`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '108', '控制台-入院人数统计图表(运行)',10);
    81. 

  81. 

  82. INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院24h内未完成图表(运行)', '', '/console/casesEntryStatisticsById', 'ALL', '入院24h内未完成图表(运行)', NULL);
    83. 

  83. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`, `order_nu`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '109', '控制台-入院24h内未完成图表(运行)',11);
    84. 

  84. 

  85. INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '单项否决占比图表', '', '/console/entryRejectPercent', 'ALL', '控制台-单项否决占比图表', NULL);
    86. 

  86. INSERT INTO `sys_menu_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`, `order_nu`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '110', '控制台-单项否决占比图表',7);
    87. 

  87. 

  88. -- 增加图表名称排序
    89. 

  89. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='49', `remark`='控制台-出院人数统计', `order_nu`='1' WHERE (`id`='36' AND `permission_id`='49');
    90. 

  90. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='51', `remark`='控制台-各模块缺陷占比排行', `order_nu`='2' WHERE (`id`='38' AND  `permission_id`='51');
    91. 

  91. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='52', `remark`='控制台-条目缺陷占比', `order_nu`='3' WHERE (`id`='39' AND  `permission_id`='52');
    92. 

  92. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='50', `remark`='控制台-质控病历统计', `order_nu`='4' WHERE (`id`='37' AND  `permission_id`='50');
    93. 

  93. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='53', `remark`='控制台-各科室缺陷占比', `order_nu`='5' WHERE (`id`='40' AND  `permission_id`='53');
    94. 

  94. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='75', `remark`='控制台-病案首页合格率占比（首页）', `order_nu`='6' WHERE (`id`='59' AND  `permission_id`='75');
    95. 

  95. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='47', `remark`='控制台-质控平均分按科室统计', `order_nu`='8' WHERE (`id`='34' AND  `permission_id`='47');
    96. 

  96. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='1', `permission_id`='91', `remark`='控制台-各科室质控平均分（首页）-根据内外科系统统计', `order_nu`='9' WHERE (`id`='64' AND  `permission_id`='91');
    97. 

  97. 

  98. -- 二、全院报表
    99. 

  99. -- 1、去掉多余的权限
    100. 

  100. 

  101. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比质控详情页（全院）', `code`='FUNC000094', `permissionUrl`='/console/qcResultShortPage', `method`='ALL', `descritpion`='数据报表明细-条目缺陷占比-条目缺陷占比质控详情页（全院）', `remark`=NULL WHERE (`permissionUrl`='/console/qcResultShortPage');
    102. 

  102. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比_详情', `code`='FUNC000060', `permissionUrl`='/console/entryCountGroupByEntryPage', `method`='ALL', `descritpion`='控制台-条目缺陷占比_详情', `remark`=NULL WHERE (`permissionUrl`='/console/entryCountGroupByEntryPage');
    103. 

  103. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室缺陷占比-缺陷详情', `code`='FUNC000067', `permissionUrl`='/console/resultStatisticsByDeptPage', `method`='ALL', `descritpion`='控制台-各科室缺陷占比-缺陷详情', `remark`=NULL WHERE (`permissionUrl`='/console/resultStatisticsByDeptPage');
    104. 

  104. 

  105. UPDATE `sys_menu` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='科室平均住院天数', `parent_id`='17', `code`='YH-ZKK-KSPJZYTS_XQ', `show_status`='1', `maintain_status`='1', `order_no`='4', `remark`='用户-质控科-科室平均住院天数_详情' WHERE (`code`='YH-ZKK-KSPJZYTS_XQ');
    106. 

  106. UPDATE `sys_menu` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='科室平均住院花费', `parent_id`='17', `code`='YH-ZKK-KSPJZYHF_XQ', `show_status`='1', `maintain_status`='1', `order_no`='5', `remark`='用户-质控科-科室平均住院花费_详情' WHERE (`code`='YH-ZKK-KSPJZYHF_XQ');
    107. 

  107. UPDATE `sys_menu` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室质控平均分', `parent_id`='17', `code`='YH-ZKK-GKSZKPJF_XQ', `show_status`='1', `maintain_status`='1', `order_no`='6', `remark`='用户-质控科-各科室质控平均分_详情' WHERE (`code`='YH-ZKK-GKSZKPJF_XQ');
    108. 

  108. UPDATE `sys_menu` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='缺陷详情', `parent_id`='17', `code`='YH-ZKK-GKSQXZB', `show_status`='1', `maintain_status`='1', `order_no`='7', `remark`='用户-质控科-各科室缺陷占比_详情' WHERE (`code`='YH-ZKK-GKSQXZB');
    109. 

  109. UPDATE `sys_menu` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室甲级病历占比', `parent_id`='17', `code`='YH-ZKK-GKSJJBLZB_XQ', `show_status`='1', `maintain_status`='1', `order_no`='8', `remark`='用户-质控科-各科室甲级病历占比_详情' WHERE (`code`='YH-ZKK-GKSJJBLZB_XQ');
    110. 

  110. 

  111. 

  112. -- 更新报表名称---可能需要改名称
    113. 

  113. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页合格占比报表', `code`='FUNC000072', `permissionUrl`='/console/homePageLevelStatistics', `method`='ALL', `descritpion`='报表-病案首页合格率占比', `remark`=NULL WHERE (`permissionUrl`='/console/homePageLevelStatistics');
    114. 

  114. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比报表', `code`='FUNC000089', `permissionUrl`='/console/entryGroupByEntryInnerPage', `method`='ALL', `descritpion`='控制台-条目缺陷占比（内页）', `remark`=NULL WHERE (`permissionUrl`='/console/entryGroupByEntryInnerPage');
    115. 

  115. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='关键条目缺陷占比报表', `code`='FUNC000100', `permissionUrl`='/console/entryStatistics', `method`='ALL', `descritpion`='数据报表明细-关键条目缺陷占比', `remark`=NULL WHERE (`permissionUrl`='/console/entryStatistics');
    116. 

  116. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各模块缺陷占比报表', `code`='FUNC000059', `permissionUrl`='/console/entryCountGroupByCasePage', `method`='ALL', `descritpion`='控制台-各模块缺陷占比报表', `remark`=NULL WHERE (`permissionUrl`='/console/entryCountGroupByCasePage');
    117. 

  117. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室缺陷占比报表', `code`='FUNC000071', `permissionUrl`='/console/levelStatistics', `method`='ALL', `descritpion`='控制台-各科室缺陷占比（组合）', `remark`=NULL WHERE (`permissionUrl`='/console/levelStatistics');
    118. 

  118. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各科室缺陷占比报表(内外科系统)', `code`='FUNC000092', `permissionUrl`='/console/levelStatisticsByDeptClass', `method`='ALL', `descritpion`='控制台-各科室缺陷占比（内页）-根据内外科系统统计', `remark`=NULL WHERE (`permissionUrl`='/console/levelStatisticsByDeptClass');
    119. 

  119. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='出院人数统计报表', `code`='FUNC000102', `permissionUrl`='/console/leaveHosMRPage', `method`='ALL', `descritpion`='数据报表明细-出院人数统计', `remark`=NULL WHERE (`permissionUrl`='/console/leaveHosMRPage');
    120. 

  120. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='质控核查统计报表', `code`='FUNC000103', `permissionUrl`='/console/qcCheckStatistics', `method`='ALL', `descritpion`='数据表白明细-质控核查统计', `remark`=NULL WHERE (`permissionUrl`='/console/qcCheckStatistics');
    121. 

  121. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='运行病历稽查表报表(运行)', `code`='FUNC000107', `permissionUrl`='/console/medicalCheckForm', `method`='ALL', `descritpion`='数据报表明细-病历稽查表', `remark`=NULL WHERE (`permissionUrl`='/console/medicalCheckForm');
    122. 

  122. UPDATE `sys_menu` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='运行病历稽查表', `parent_id`='17', `code`='YH-ZKK-YXBLJCB', `show_status`='1', `maintain_status`='1', `order_no`='15', `remark`='用户-质控科-病历稽查表' WHERE (`code`='YH-ZKK-YXBLJCB');
    123. 

  123. 

  124. 

  125. -- 新增报表---可能需要改名称
    126. 

  126. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '时效性相关统计报表', '', '/console/unModifyMRStatistics', 'ALL', '时效性相关统计报表', NULL);
    127. 

  127. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '37', '111', '时效性相关统计报表');
    128. 

  128. 

  129. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31日再入院病人数报表', '', '/console/reHos31DaysPage', 'ALL', '31日再入院病人数报表', NULL);
    130. 

  130. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '38', '112', '31日再入院病人数报表');
    131. 

  131. 

  132. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院人数统计报表(运行)', '', '/console/leaveHosMRPage', 'ALL', '数据报表明细-入院人数统计', NULL);
    133. 

  133. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '39', '113', '数据报表明细-入院人数统计');
    134. 

  134. 

  135. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '终末病历稽查表报表', '', '/console/medicalCheckForm', 'ALL', '数据报表明细-终末病历稽查表', NULL);
    136. 

  136. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '47', '114', '数据报表明细-终末病历稽查表');
    137. 

  137. 

  138. -- 报表排序
    139. 

  139. UPDATE `sys_menu` SET  `is_deleted`='N', `name`='入院人数统计', `parent_id`='17', `code`='YH-ZKK-RYRSTJ', `show_status`='1', `maintain_status`='1', `order_no`='16', `remark`='用户-质控科-入院人数统计' WHERE (`code`='YH-ZKK-RYRSTJ');
    140. 

  140. UPDATE `sys_menu` SET  `is_deleted`='N', `name`='运行病历稽查表', `parent_id`='17', `code`='YH-ZKK-YXBLJCB', `show_status`='1', `maintain_status`='1', `order_no`='17', `remark`='用户-质控科-病历稽查表' WHERE (`code`='YH-ZKK-YXBLJCB');
    141. 

  141. 

  142. 

  143. 

  144. -- 科室
    145. 

  145. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='出院人数统计图表', `code`='FUNC000054', `permissionUrl`='/consoleByDept/leaveHosCountByDept', `method`='ALL', `descritpion`='控制台（科室）-出院人数统计（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/leaveHosCountByDept');
    146. 

  146. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各模块缺陷占比排行图表', `code`='FUNC000056', `permissionUrl`='/consoleByDept/entryCountGroupByCaseAndDept', `method`='ALL', `descritpion`='控制台（科室）-各模块缺陷占比排行（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/entryCountGroupByCaseAndDept');
    147. 

  147. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比图表', `code`='FUNC000057', `permissionUrl`='/consoleByDept/entryCountGroupByEntryAndDept', `method`='ALL', `descritpion`='控制台（科室）-条目缺陷占比（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/entryCountGroupByEntryAndDept');
    148. 

  148. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病历评分等级占比图表', `code`='FUNC000055', `permissionUrl`='/consoleByDept/mrCountByDept', `method`='ALL', `descritpion`='控制台（科室）-质控病历数统计（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/mrCountByDept');
    149. 

  149. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页合格率占比图表', `code`='FUNC000076', `permissionUrl`='/consoleByDept/homePageLevelByDeptLimit', `method`='ALL', `descritpion`='控制台（科室）-病案首页合格率占比（首页）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/homePageLevelByDeptLimit');
    150. 

  150. 

  151. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院人数统计图表(运行)', '', '/consoleByDept/beHosCountByDept', 'ALL', '控制台-入院人数统计图表(运行)（科室）', NULL);
    152. 

  152. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`, `order_nu`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '115', '控制台-入院人数统计图表(运行)（科室）',6);
    153. 

  153. 

  154. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院24h内未完成图表(运行)', '', '/consoleByDept/casesEntryStatisticsByDept', 'ALL', '入院24h内未完成图表(运行)（科室）', NULL);
    155. 

  155. INSERT INTO `sys_menu_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`, `order_nu`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '116', '控制台-入院24h内未完成图表(运行)（科室）',7);
    156. 

  156. 

  157. -- 科室排序
    158. 

  158. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='15', `permission_id`='54', `remark`='控制台（科室）-出院人数统计（科室）', `order_nu`='1' WHERE (`id`='41' AND `permission_id`='54');
    159. 

  159. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='15', `permission_id`='55', `remark`='控制台（科室）-质控病历数统计（科室）', `order_nu`='4' WHERE (`id`='42' AND `permission_id`='55');
    160. 

  160. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='15', `permission_id`='56', `remark`='控制台（科室）-各模块缺陷占比排行（科室）', `order_nu`='2' WHERE (`id`='43' AND `permission_id`='56');
    161. 

  161. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='15', `permission_id`='57', `remark`='控制台（科室）-条目缺陷占比（科室）', `order_nu`='3' WHERE (`id`='44' AND `permission_id`='57');
    162. 

  162. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='15', `permission_id`='76', `remark`='控制台（科室）-病案首页合格率占比（首页）', `order_nu`='5' WHERE (`id`='60' AND `permission_id`='76');
    163. 

  163. 

  164. -- 科室控制台去掉多余的权限
    165. 

  165. UPDATE `sys_permission` SET  `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='查询用户关联科室', `code`='FUNC000058', `permissionUrl`='/consoleByDept/getDept', `method`='ALL', `descritpion`='控制台（科室）-查询用户关联科室', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/getDept');
    166. 

  166. 

  167. 

  168. 

  169. -- 科室报表
    170. 

  170. UPDATE `sys_permission` SET  `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页合格占比报表', `code`='FUNC000074', `permissionUrl`='/consoleByDept/homePageLevelStatisticsByDept', `method`='ALL', `descritpion`='报表-病案首页合格率占比（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/homePageLevelStatisticsByDept');
    171. 

  171. UPDATE `sys_permission` SET  `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='各模块缺陷占比报表', `code`='FUNC000069', `permissionUrl`='/consoleByDept/entryCountGroupByCaseAndDeptPage', `method`='ALL', `descritpion`='报表（科室）-各模块缺陷占比_详情', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/entryCountGroupByCaseAndDeptPage');
    172. 

  172. UPDATE `sys_permission` SET  `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比报表', `code`='FUNC000090', `permissionUrl`='/consoleByDept/entryGroupByEntryAndDeptInnerPage', `method`='ALL', `descritpion`='控制台（科室）-条目缺陷占比-科室（内页）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/entryGroupByEntryAndDeptInnerPage');
    173. 

  173. 

  174. -- 科室新增报表
    175. 

  175. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比报表', '', '/consoleByDept/entryStatisticsByDept', 'ALL', '(科室)数据报表明细-关键条目缺陷占比', NULL);
    176. 

  176. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '41', '117', '(科室)数据报表明细-关键条目缺陷占比');
    177. 

  177. 

  178. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计报表', '', '/consoleByDept/leaveHosMRPageByDept', 'ALL', '出院人数统计报表（科室）', NULL);
    179. 

  179. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '42', '118', '出院人数统计报表（科室）');
    180. 

  180. 

  181. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计报表', '', '/consoleByDept/qcCheckStatisticsByDept', 'ALL', '质控核查统计报表（科室）', NULL);
    182. 

  182. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '44', '119', '质控核查统计报表（科室）');
    183. 

  183. 

  184. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '时效性相关统计报表', '', '/consoleByDept/unModifyMRSByDept', 'ALL', '时效性相关统计报表（科室）', NULL);
    185. 

  185. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '45', '120', '时效性相关统计报表（科室）');
    186. 

  186. 

  187. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31日再入院病人数报表', '', '/consoleByDept/reHos31DaysPageByDept', 'ALL', '31日再入院病人数报表（科室）', NULL);
    188. 

  188. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '46', '121', '31日再入院病人数报表（科室）');
    189. 

  189. 

  190. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '终末病历稽查表报表', '', '/consoleByDept/medicalCheckFormKs', 'ALL', '', NULL);
    191. 

  191. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '48', '122', '病历稽查表报表(科室)');
    192. 

  192. 

  193. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '运行病历稽查表报表(运行)', '', '/consoleByDept/medicalCheckFormKs', 'ALL', '数据报表明细-运行病历稽查表(科室)', NULL);
    194. 

  194. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '49', '123', '数据报表明细-运行病历稽查表(科室)');
    195. 

  195. 

  196. INSERT INTO `sys_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '入院人数统计报表(运行)', '', '/consoleByDept/leaveHosMRPageByDept', 'ALL', '入院人数统计报表（科室）', NULL);
    197. 

  197. INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '43', '124', '入院人数统计报表（科室）');
    198. 

  198. 

  199. -- 科室报表排序
    200. 

  200. UPDATE `sys_menu` SET `is_deleted`='N', `parent_id`='18', `code`='YH-KSZR-RYRSTJ_XQ', `show_status`='1', `maintain_status`='1', `order_no`='11', `remark`='用户-科室主任-入院人数统计_详情' WHERE (`code`='YH-KSZR-RYRSTJ_XQ');
    201. 

  201. UPDATE `sys_menu` SET `is_deleted`='N', `parent_id`='18', `code`='YH-KSZR-YXBLJCS_XQ', `show_status`='1', `maintain_status`='1', `order_no`='12', `remark`='用户-科室主任-运行病历稽查表_详情' WHERE (`code`='YH-KSZR-YXBLJCS_XQ');
    202. 

  202. UPDATE `sys_menu` SET `is_deleted`='N',  `name`='科室缺陷占比', `parent_id`='18', `code`='YH-KSZR-KSQXZB_XQ', `show_status`='1', `maintain_status`='1', `order_no`='5', `remark`='用户-科室主任-科室缺陷占比_详情' WHERE (`code`='YH-KSZR-KSQXZB_XQ');
    203. 

  203. 

  204. -- 科室更新表名
    205. 

  205. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='科室缺陷占比报表', `code`='FUNC000073', `permissionUrl`='/consoleByDept/levelStatisticsByDept', `method`='ALL', `descritpion`='控制台（科室）-各科室缺陷占比（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/levelStatisticsByDept');
    206. 

  206. 

  207. -- 去掉多余科室报表权限
    208. 

  208. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比_详情', `code`='FUNC000070', `permissionUrl`='/consoleByDept/entryCountGroupByEntryAndDeptPage', `method`='ALL', `descritpion`='控制台（科室）-条目缺陷占比_详情', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/entryCountGroupByEntryAndDeptPage');
    209. 

  209. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='条目缺陷占比质控详情页（科室）', `code`='FUNC000095', `permissionUrl`='/consoleByDept/qcResultShortByDeptPage', `method`='ALL', `descritpion`='数据报表明细（科室）-条目缺陷占比-条目缺陷占比质控详情页（科室）', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/qcResultShortByDeptPage');
    210. 

  210. UPDATE `sys_permission` SET `is_deleted`='Y', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='科室缺陷占比-缺陷明细', `code`='FUNC000077', `permissionUrl`='/consoleByDept/resultStatisticsByDeptAndDoctorPage', `method`='ALL', `descritpion`='控制台（科室）-科室缺陷占比-缺陷明细', `remark`=NULL WHERE (`permissionUrl`='/consoleByDept/resultStatisticsByDeptAndDoctorPage');
    211. 

  211. 

  212. 

  213. -- 基础数据维护菜单
    214. 

  214. -- INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改', '', '/qc/qcType/saveOrUpdate', 'ALL', '质控类型维护-修改', NULL);
    215. 

  215. -- INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '复制', '', '/qc/qcType/saveOrUpdate', 'ALL', '质控类型维护-复制', NULL);
    216. 

  216. -- INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除', '', '/qc/qcType/delete', 'ALL', '质控类型维护-删除', NULL);
    217. 

  217. -- INSERT INTO `sys_permission` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `permissionUrl`, `method`, `descritpion`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '添加质控类型', '', '/qc/qcType/saveOrUpdate', 'ALL', '质控类型维护-添加质控类型', NULL);
    218. 

  218. 

  219. -- INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '128', '质控类型维护-添加质控类型');
    220. 

  220. -- INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '125', '质控类型维护-修改');
    221. 

  221. -- INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '126', '质控类型维护-复制');
    222. 

  222. -- INSERT INTO `sys_menu_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `menu_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '127', '质控类型维护-删除');
    223. 

  223. 

  224. -- 开放科室/全院质控类型维护查询等接口
    225. 

  225. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '78', '用户-质控类型维护-分页列表');
    226. 

  226. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '78', '用户-质控类型维护-分页列表');
    227. 

  227. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '83', '用户-质控类型维护-根据id返回内容');
    228. 

  228. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '83', '用户-质控类型维护-根据id返回内容');
    229. 

  229. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '80', '用户-质控类型维护-新增时质控条目分组信息');
    230. 

  230. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '80', '用户-质控类型维护-新增时质控条目分组信息');
    231. 

  231. 

  232. 

  233. -- UPDATE `sys_menu` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='质控类型维护', `parent_id`='2', `code`='YH-JCSJWH-ZKLXWH', `show_status`='1', `maintain_status`='1', `order_no`='3', `remark`='用户-基础数据维护-质控类型维护' WHERE (`code`='YH-JCSJWH-ZKLXWH');
    234. 

  234. -- INSERT INTO `sys_role_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '32', '用户-基础数据维护-质控类型维护');
    235. 

  235. -- INSERT INTO `sys_role_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `menu_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '32', '用户-基础数据维护-质控类型维护');
    236. 

  236. 

  237. 

  238. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '125', '质控类型维护-修改');
    239. 

  239. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '125', '质控类型维护-修改');
    240. 

  240. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '125', '质控类型维护-修改');
    241. 

  241. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '126', '质控类型维护-复制');
    242. 

  242. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '126', '质控类型维护-复制');
    243. 

  243. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '126', '质控类型维护-复制');
    244. 

  244. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '127', '质控类型维护-删除');
    245. 

  245. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '127', '质控类型维护-删除');
    246. 

  246. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '127', '质控类型维护-删除');
    247. 

  247. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '128', '质控类型维护-添加质控类型');
    248. 

  248. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '128', '质控类型维护-添加质控类型');
    249. 

  249. -- INSERT INTO `sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '128', '质控类型维护-添加质控类型');
    250. 

  250. 

  251. -- 名称
    252. 

  252. UPDATE `sys_menu` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='基础数据维护', `parent_id`='-1', `code`='YH-JCSJWH', `show_status`='1', `maintain_status`='1', `order_no`='2', `remark`='用户-基础数据维护' WHERE (`code`='YH-JCSJWH');
    253. 

  253. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改', `code`='FUNC000004', `permissionUrl`='/qc/cases/saveQcCases', `method`='ALL', `descritpion`='用户-基础数据维护-修改医院模块数据', `remark`=NULL WHERE (`permissionUrl`='/qc/cases/saveQcCases');
    254. 

  254. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改', `code`='FUNC000007', `permissionUrl`='/qc/casesEntryHospital/updataQcCasesEntry', `method`='ALL', `descritpion`='用户-条目数据维护-修改医院条目数据信息', `remark`=NULL WHERE (`permissionUrl`='/qc/casesEntryHospital/updataQcCasesEntry');
    255. 

  255. 

  256. 

  257. 

  258. -- 基础功能
    259. 

  259. UPDATE `sys_menu` SET  `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='基本信息', `parent_id`='-1', `code`='YH-QBYH-JCGN', `show_status`='0', `maintain_status`='1', `order_no`='-14', `remark`='用户-基础功能' WHERE (`code`='YH-QBYH-JCGN');
    260. 

  260. 

  261. 

  262. -- 全院菜单
    263. 

  263. 

  264. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='评分', `code`='FUNC000017', `permissionUrl`='/qc/behospitalInfo/analyze', `method`='ALL', `descritpion`='用户-质控评分-评分', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/analyze' AND id = 17 );
    265. 

  265. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='新增缺陷详情', `code`='FUNC000011', `permissionUrl`='/qc/behospitalInfo/addCase', `method`='ALL', `descritpion`='用户-质控评分-新增质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/addCase' AND id = 11);
    266. 

  266. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='删除缺陷详情', `code`='FUNC000012', `permissionUrl`='/qc/behospitalInfo/delCase', `method`='ALL', `descritpion`='用户-质控评分-删除质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/delCase' AND id = 12);
    267. 

  267. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改缺陷详情', `code`='FUNC000013', `permissionUrl`='/qc/behospitalInfo/updCase', `method`='ALL', `descritpion`='用户-质控评分-修改质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/updCase' AND id = 13);
    268. 

  268. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页&病历核查', `code`='FUNC000014', `permissionUrl`='/qc/medCheckInfo/addMedCheckInfo', `method`='ALL', `descritpion`='用户-核查数据接口', `remark`=NULL WHERE (`permissionUrl`='/qc/medCheckInfo/addMedCheckInfo' AND id = 101);
    269. 

  269. -- 排序
    270. 

  270. UPDATE `sys_menu_permission` SET `is_deleted`='N',  `menu_id`='7', `permission_id`='17', `remark`='用户-质控评分-评分', `order_nu`='1' WHERE (`id`='12' and `permission_id`='17');
    271. 

  271. UPDATE `sys_menu_permission` SET `is_deleted`='N',  `menu_id`='7', `permission_id`='101', `remark`='用户-质控评分-核查数据接口', `order_nu`='2' WHERE (`id`='73' and `permission_id`='101');
    272. 

  272. UPDATE `sys_menu_permission` SET `is_deleted`='N',  `menu_id`='7', `permission_id`='11', `remark`='用户-质控评分-新增质控条目', `order_nu`='3' WHERE (`id`='14' and `permission_id`='11');
    273. 

  273. UPDATE `sys_menu_permission` SET `is_deleted`='N',  `menu_id`='7', `permission_id`='13', `remark`='用户-质控评分-修改质控条目', `order_nu`='4' WHERE (`id`='16' and `permission_id`='13');
    274. 

  274. UPDATE `sys_menu_permission` SET `is_deleted`='N',  `menu_id`='7', `permission_id`='12', `remark`='用户-质控评分-删除质控条目', `order_nu`='5' WHERE (`id`='15' and `permission_id`='12');
    275. 

  275. 

  276. -- 科室菜单
    277. 

  277. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='评分', `code`='FUNC000017', `permissionUrl`='/qc/behospitalInfo/analyze', `method`='ALL', `descritpion`='用户-质控评分(科室)-评分', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/analyze' AND id = 34 );
    278. 

  278. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='新增缺陷详情', `code`='FUNC000011', `permissionUrl`='/qc/behospitalInfo/addCase', `method`='ALL', `descritpion`='用户-质控评分(科室)-新增质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/addCase' AND id = 35);
    279. 

  279. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='删除缺陷详情', `code`='FUNC000012', `permissionUrl`='/qc/behospitalInfo/delCase', `method`='ALL', `descritpion`='用户-质控评分(科室)-删除质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/delCase' AND id = 36);
    280. 

  280. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改缺陷详情', `code`='FUNC000013', `permissionUrl`='/qc/behospitalInfo/updCase', `method`='ALL', `descritpion`='用户-质控评分(科室)-修改质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/updCase' AND id = 37);
    281. 

  281. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页&病历核查', `code`='FUNC000014', `permissionUrl`='/qc/medCheckInfo/addMedCheckInfo', `method`='ALL', `descritpion`='用户-核查数据接口（科室）', `remark`=NULL WHERE (`permissionUrl`='/qc/medCheckInfo/addMedCheckInfo' AND id = 105);
    282. 

  282. -- 排序
    283. 

  283. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='9', `permission_id`='34', `remark`='用户-质控评分(科室)-评分', `order_nu`='1' WHERE (`id`='19' and `permission_id`='34');
    284. 

  284. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='9', `permission_id`='105', `remark`='用户-质控评分(科室)-核查数据接口', `order_nu`='2' WHERE (`id`='74' and `permission_id`='105');
    285. 

  285. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='9', `permission_id`='35', `remark`='用户-质控评分(科室)-新增质控条目', `order_nu`='3' WHERE (`id`='21' and `permission_id`='35');
    286. 

  286. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='9', `permission_id`='37', `remark`='用户-质控评分(科室)-修改质控条目', `order_nu`='4' WHERE (`id`='23' and `permission_id`='37');
    287. 

  287. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='9', `permission_id`='36', `remark`='用户-质控评分(科室)-删除质控条目', `order_nu`='5' WHERE (`id`='22' and `permission_id`='36');
    288. 

  288. 

  289. -- 个人菜单
    290. 

  290. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='评分', `code`='FUNC000017', `permissionUrl`='/qc/behospitalInfo/analyze', `method`='ALL', `descritpion`='用户-质控评分(个人)-评分', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/analyze' AND id = 40 );
    291. 

  291. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='新增缺陷详情', `code`='FUNC000011', `permissionUrl`='/qc/behospitalInfo/addCase', `method`='ALL', `descritpion`='用户-质控评分(个人)-新增质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/addCase' AND id = 41);
    292. 

  292. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='删除缺陷详情', `code`='FUNC000012', `permissionUrl`='/qc/behospitalInfo/delCase', `method`='ALL', `descritpion`='用户-质控评分(个人)-删除质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/delCase' AND id = 42);
    293. 

  293. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改缺陷详情', `code`='FUNC000013', `permissionUrl`='/qc/behospitalInfo/updCase', `method`='ALL', `descritpion`='用户-质控评分(个人)-修改质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/updCase' AND id = 43);
    294. 

  294. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页&病历核查', `code`='FUNC000014', `permissionUrl`='/qc/medCheckInfo/addMedCheckInfo', `method`='ALL', `descritpion`='用户-核查数据接口', `remark`=NULL WHERE (`permissionUrl`='/qc/medCheckInfo/addMedCheckInfo' AND `id`='104');
    295. 

  295. -- 排序
    296. 

  296. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='10', `permission_id`='40', `remark`='用户-质控评分(科室)-评分', `order_nu`='1' WHERE (`id`='19' and `permission_id`='40');
    297. 

  297. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='10', `permission_id`='104', `remark`='用户-质控评分(科室)-核查数据接口', `order_nu`='2' WHERE (`id`='74' and `permission_id`='104');
    298. 

  298. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='10', `permission_id`='41', `remark`='用户-质控评分(科室)-新增质控条目', `order_nu`='3' WHERE (`id`='21' and `permission_id`='41');
    299. 

  299. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='10', `permission_id`='43', `remark`='用户-质控评分(科室)-修改质控条目', `order_nu`='4' WHERE (`id`='23' and `permission_id`='43');
    300. 

  300. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='10', `permission_id`='42', `remark`='用户-质控评分(科室)-删除质控条目', `order_nu`='5' WHERE (`id`='22' and `permission_id`='42');
    301. 

  301. 

  302. -- 医疗组菜单
    303. 

  303. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='评分', `code`='FUNC000017', `permissionUrl`='/qc/behospitalInfo/analyze', `method`='ALL', `descritpion`='用户-医疗组-评分', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/analyze'AND id = 96);
    304. 

  304. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='新增缺陷详情', `code`='FUNC000011', `permissionUrl`='/qc/behospitalInfo/addCase', `method`='ALL', `descritpion`='用户-医疗组-新增质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/addCase' AND id = 97);
    305. 

  305. UPDATE `sys_permission` SET `is_deleted`='N',`gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='删除缺陷详情', `code`='FUNC000012', `permissionUrl`='/qc/behospitalInfo/delCase', `method`='ALL', `descritpion`='用户-医疗组-删除质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/delCase' AND id = 98);
    306. 

  306. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='修改缺陷详情', `code`='FUNC000013', `permissionUrl`='/qc/behospitalInfo/updCase', `method`='ALL', `descritpion`='用户-医疗组-修改质控条目', `remark`=NULL WHERE (`permissionUrl`='/qc/behospitalInfo/updCase' AND id = 99);
    307. 

  307. UPDATE `sys_permission` SET `is_deleted`='N', `gmt_create`='1970-01-01 12:00:00', `gmt_modified`='1970-01-01 12:00:00', `creator`='0', `modifier`='0', `name`='病案首页&病历核查', `code`='FUNC000014', `permissionUrl`='/qc/medCheckInfo/addMedCheckInfo', `method`='ALL', `descritpion`='用户-核查数据接口（医疗组）', `remark`=NULL WHERE (`permissionUrl`='/qc/medCheckInfo/addMedCheckInfo' AND id = 106);
    308. 

  308. -- 排序
    309. 

  309. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='33', `permission_id`='96', `remark`='用户-质控评分(科室)-评分', `order_nu`='1' WHERE (`id`='19' and `permission_id`='96');
    310. 

  310. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='33', `permission_id`='106', `remark`='用户-质控评分(科室)-核查数据接口', `order_nu`='2' WHERE (`id`='74' and `permission_id`='106');
    311. 

  311. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='33', `permission_id`='97', `remark`='用户-质控评分(科室)-新增质控条目', `order_nu`='3' WHERE (`id`='21' and `permission_id`='97');
    312. 

  312. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='33', `permission_id`='99', `remark`='用户-质控评分(科室)-修改质控条目', `order_nu`='4' WHERE (`id`='23' and `permission_id`='99');
    313. 

  313. UPDATE `sys_menu_permission` SET `is_deleted`='N', `menu_id`='33', `permission_id`='98', `remark`='用户-质控评分(科室)-删除质控条目', `order_nu`='5' WHERE (`id`='22' and `permission_id`='98');
    314. 

  314. 

  315. 

  316. 

  317. -- 报表可配置
    318. 

  318. INSERT INTO `sys_hospital_set` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '未整改病历统计-科室(长兴)', 'unmodify_mr_entry_ks', '2658--入院记录24h内未完成,2686--首程8h内未完成,3010--入院后未连记3天,2656--主治48h未查房,2657--主任72h未查房,2170--术后24h无手术记录,2930--术后首程未即刻完成,2900--术后24h内无主刀查房,2229--术后未连记3天,2220--病危无1天1记,2221--病重无2天1记,2655--主任每周无2次查房,2654--主治每周无3次查房,2218--转入记录24h内未完成,2217--转入后未连记3天,2495--无阶段小结', '未整改病历统计-科室(长兴)');
    319. 

  319. INSERT INTO `sys_hospital_set`  (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '未整改病历统计-科室(邵逸夫)', 'unmodify_mr_entry_ks', '2658--入院记录24h内未完成,2686--首程8h内未完成,3010--入院后未连记3天,2656--主治48h未查房,2657--主任72h未查房,2170--术后24h无手术记录,2930--术后首程未即刻完成,2900--术后24h内无主刀查房,2229--术后未连记3天,2220--病危无1天1记,2221--病重无2天1记,2655--主任每周无2次查房,2654--主治每周无3次查房,2218--转入记录24h内未完成,2217--转入后未连记3天,2495--无阶段小结', '未整改病历统计-科室(邵逸夫)');
    320. 

  320. INSERT INTO `sys_hospital_set` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '未整改病历统计-科室(台州)', 'unmodify_mr_entry_ks', '2658--入院记录24h内未完成,2686--首程8h内未完成,3010--入院后未连记3天,2656--主治48h未查房,2657--主任72h未查房,2170--术后24h无手术记录,2930--术后首程未即刻完成,2900--术后24h内无主刀查房,2229--术后未连记3天,2220--病危无1天1记,2221--病重无2天1记,2655--主任每周无2次查房,2654--主治每周无3次查房,2218--转入记录24h内未完成,2217--转入后未连记3天,2495--无阶段小结', '未整改病历统计-科室(台州)');
    321. 

  321. INSERT INTO `sys_hospital_set`  (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '未整改病历统计-科室(北仑)', 'unmodify_mr_entry_ks', '2658--入院记录24h内未完成,2686--首程8h内未完成,3010--入院后未连记3天,2656--主治48h未查房,2657--主任72h未查房,2170--术后24h无手术记录,2930--术后首程未即刻完成,2900--术后24h内无主刀查房,2229--术后未连记3天,2220--病危无1天1记,2221--病重无2天1记,2655--主任每周无2次查房,2654--主治每周无3次查房,2218--转入记录24h内未完成,2217--转入后未连记3天,2495--无阶段小结', '未整改病历统计-科室(北仑)');
    322. 

  322. INSERT INTO `sys_hospital_set` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '未整改病历统计-科室(义乌)', 'unmodify_mr_entry_ks', '2658--入院记录24h内未完成,2686--首程8h内未完成,3010--入院后未连记3天,2656--主治48h未查房,2657--主任72h未查房,2170--术后24h无手术记录,2930--术后首程未即刻完成,2900--术后24h内无主刀查房,2229--术后未连记3天,2220--病危无1天1记,2221--病重无2天1记,2655--主任每周无2次查房,2654--主治每周无3次查房,2218--转入记录24h内未完成,2217--转入后未连记3天,2495--无阶段小结', '未整改病历统计-科室(义乌)');
    323. 

  323. INSERT INTO `sys_hospital_set` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '病历稽查表-科室(长兴)', 'medical_check_form_ks', '2658--入院记录24小时内,2686--首次病程记录8小时内,2657--副主任/主任医师首次查房72小时内完成,3010--入院后连记3天病程(不包括术后首程),2655--每周至少2次副主任/主任医师查房,2654--每周至少3次主治医师查房记录,2852--抢救记录6小时内完成,2287--会诊记录在会诊申请后24小时完成,3025--术前讨论、术前小结完成,2170--手术记录术后24小时内完成,2930--术后首程在术后30分钟内完成,2900--术后主刀查房24小时内完成,2229--术后连记3天病程(包括术后首程),2217--转科后连记3天病程(包括专科记录),2218--转接科记录专科后24小时内完成,2220--病危/重患者每日记录病程,2486--输血后完成输血记录,3063--24小时完成输血后评价,3062--危急值记录,2495--住院30天阶段小结', '病历稽查表-科室(长兴)');
    324. 

  324. INSERT INTO `sys_hospital_set` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '病历稽查表-科室(邵逸夫)', 'medical_check_form_ks', '2658--入院记录24小时内,2686--首次病程记录8小时内,2657--副主任/主任医师首次查房72小时内完成,3010--入院后连记3天病程(不包括术后首程),2655--每周至少2次副主任/主任医师查房,2654--每周至少3次主治医师查房记录,2852--抢救记录6小时内完成,2287--会诊记录在会诊申请后24小时完成,3025--术前讨论、术前小结完成,2170--手术记录术后24小时内完成,2930--术后首程在术后30分钟内完成,2900--术后主刀查房24小时内完成,2229--术后连记3天病程(包括术后首程),2217--转科后连记3天病程(包括专科记录),2218--转接科记录专科后24小时内完成,2220--病危/重患者每日记录病程,2486--输血后完成输血记录,3063--24小时完成输血后评价,3062--危急值记录,2495--住院30天阶段小结', '病历稽查表-科室(邵逸夫)');
    325. 

  325. INSERT INTO `sys_hospital_set` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '病历稽查表-科室(台州)', 'medical_check_form_ks', '2658--入院记录24小时内,2686--首次病程记录8小时内,2657--副主任/主任医师首次查房72小时内完成,3010--入院后连记3天病程(不包括术后首程),2655--每周至少2次副主任/主任医师查房,2654--每周至少3次主治医师查房记录,2852--抢救记录6小时内完成,2287--会诊记录在会诊申请后24小时完成,3025--术前讨论、术前小结完成,2170--手术记录术后24小时内完成,2930--术后首程在术后30分钟内完成,2900--术后主刀查房24小时内完成,2229--术后连记3天病程(包括术后首程),2217--转科后连记3天病程(包括专科记录),2218--转接科记录专科后24小时内完成,2220--病危/重患者每日记录病程,2486--输血后完成输血记录,3063--24小时完成输血后评价,3062--危急值记录,2495--住院30天阶段小结', '病历稽查表-科室(台州)');
    326. 

  326. INSERT INTO `sys_hospital_set` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '病历稽查表-科室(北仑)', 'medical_check_form_ks', '2658--入院记录24小时内,2686--首次病程记录8小时内,2657--副主任/主任医师首次查房72小时内完成,3010--入院后连记3天病程(不包括术后首程),2655--每周至少2次副主任/主任医师查房,2654--每周至少3次主治医师查房记录,2852--抢救记录6小时内完成,2287--会诊记录在会诊申请后24小时完成,3025--术前讨论、术前小结完成,2170--手术记录术后24小时内完成,2930--术后首程在术后30分钟内完成,2900--术后主刀查房24小时内完成,2229--术后连记3天病程(包括术后首程),2217--转科后连记3天病程(包括专科记录),2218--转接科记录专科后24小时内完成,2220--病危/重患者每日记录病程,2486--输血后完成输血记录,3063--24小时完成输血后评价,3062--危急值记录,2495--住院30天阶段小结', '病历稽查表-科室(北仑)');
    327. 

  327. INSERT INTO `sys_hospital_set` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_id`, `name`, `code`, `value`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '病历稽查表-科室(义乌)', 'medical_check_form_ks', '2658--入院记录24小时内,2686--首次病程记录8小时内,2657--副主任/主任医师首次查房72小时内完成,3010--入院后连记3天病程(不包括术后首程),2655--每周至少2次副主任/主任医师查房,2654--每周至少3次主治医师查房记录,2852--抢救记录6小时内完成,2287--会诊记录在会诊申请后24小时完成,3025--术前讨论、术前小结完成,2170--手术记录术后24小时内完成,2930--术后首程在术后30分钟内完成,2900--术后主刀查房24小时内完成,2229--术后连记3天病程(包括术后首程),2217--转科后连记3天病程(包括专科记录),2218--转接科记录专科后24小时内完成,2220--病危/重患者每日记录病程,2486--输血后完成输血记录,3063--24小时完成输血后评价,3062--危急值记录,2495--住院30天阶段小结', '病历稽查表-科室(义乌)');
    328. 

  328. 

  329. 

  330. 

  331. -- =======================ok分割线===================================
    332. 

  332. 

  333. 

  334.