mrqc-sys/doc/049.20220613_v2.1.6厦门个性化_出院人数统计/qc_init_v2.1.6.sql

use `qc`;

INSERT INTO `sys_user_pageset` (`is_deleted`,`gmt_create`,`gmt_modified`,`creator`,`modifier`,`user_id`,`page_type`,`name`,`val`,`status`,`order_no`) VALUES ('N','1970-01-01 12:00:00','1970-01-01 12:00:00','0','0',354,1,'主刀医生','operationDoctorName',1,19);
INSERT INTO `sys_user_pageset` (`is_deleted`,`gmt_create`,`gmt_modified`,`creator`,`modifier`,`user_id`,`page_type`,`name`,`val`,`status`,`order_no`) VALUES ('N','1970-01-01 12:00:00','1970-01-01 12:00:00','0','0',354,1,'手术级别','operationLevel',1,20);

update sys_user_pageset a set a.order_no = 21 where a.name = '科室' and a.user_id = 354;
update sys_user_pageset a set a.order_no = 22 where a.name = '评分时间' and a.user_id = 354;


INSERT INTO `sys_user_pageset` (`is_deleted`,`gmt_create`,`gmt_modified`,`creator`,`modifier`,`user_id`,`page_type`,`name`,`val`,`status`,`order_no`) VALUES ('N','1970-01-01 12:00:00','1970-01-01 12:00:00','0','0',-1,1,'主刀医生','operationDoctorName',1,22);
INSERT INTO `sys_user_pageset` (`is_deleted`,`gmt_create`,`gmt_modified`,`creator`,`modifier`,`user_id`,`page_type`,`name`,`val`,`status`,`order_no`) VALUES ('N','1970-01-01 12:00:00','1970-01-01 12:00:00','0','0',-1,1,'手术级别','operationLevel',1,23);

update sys_user_pageset a set a.order_no = 24 where a.name = '科室' and a.user_id = -1;
update sys_user_pageset a set a.order_no = 25 where a.name = '评分时间' and a.user_id = -1;
update sys_user_pageset a set a.order_no = 26 where a.name = '是否日间病历' and a.user_id = -1;