Jlin's Blog

林剑的博客

0%

Saas随访环境

发表于 更新于 分类于
本文字数： 2.8k 阅读时长 ≈ 10 分钟

医院

医院编码 医院名称 前缀
MA27WPGYX 沃森智能诊所 ma
47048365X 建德市梅城镇卫生院 mc
12530100 昆明社会福利院 kmfl
hzsf 杭州师范 hzsf
zylm 中医联盟 zylm
827718232 认知科技 rzkj
702404552 米市巷卫生院 msx
210987650 金华广福医院 jhgf
13920633 柯桥人民医院 kqrm
202829335 重庆医药(集团)股份有限公司 cqyy

服务器

IP 用户 密码
120.55.188.44 root BIDjda671Jhkd

数据库

ip username password database
jianhailanniu.mysql.rds.aliyuncs.com jianhai_lanniu jh88790906 cloud_followup_dingding

随访路径

1
/home/suifang2

随访地址

1
http://saas.joinhealth.cn/hug_interview/

初始化脚本

1
2
3
需要替换内容
    医院编码 #
    前缀 *
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
INSERT INTO `t_manage_role`
    (`id`, `hosp_code`, `role_name`, `role_permission`, `role_desc`, `create_time`, `update_time`)
VALUES
    ('#default-admin','#','管理员','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399','所有权限',CURRENT_TIME,CURRENT_TIME);

INSERT INTO `t_manage_user` 
    (`id`, `work_number`, `user_name`, `account`, `password`, `mobile_no`, `idcard`, `sex`, `birthdate`, `dept_code`, `dept_name`, `post_code`, `post_name`, `user_flag`, `comments`, `role_id`, `role_name`, `dept_view_auth`, `ward_view_auth`, `referral_default`, `call_auth`, `fetal_monitor_set_auth`, `hosp_code`, `hosp_name`, `hosp_abbr`, `area_code`, `user_type`, `disabled`, `create_time`, `update_time`, `login_time`, `personal_resume`, `is_bounced`, `certification`, `hug_id`, `item_codes`, `data_view_auth`, `plan_data_view_auth`, `plan_dept_view_auth`, `plan_ward_view_auth`, `extension`, `date_type`, `ascription_code`, `ascription_name`, `ai_start_status`, `free_switch_flag`, `holographic_file_id`, `hf_plan_order_flag`, `sl_plan_order_flag`, `sf_plan_order_flag`, `disease_manage_auth`, `quit_flag`) 
VALUES 
    (REPLACE(UUID(),'-',''), '000000', 'admin', '*_admin', '202cb962ac59075b964b07152d234b70', '18888888888', '', '1', '2016-11-29', '', '', NULL, '', '1', '', '#default-admin', NULL, 'all', 'all', '', '1', NULL, '#', '', '*', '0571', '2', '1', '2017-01-10 18:50:03', NULL, '2018-08-02 17:25:21', '', NULL, '0', NULL, NULL, '1', '1', 'all', 'all', NULL, '1', NULL, NULL, '0', NULL, '1', NULL, NULL, NULL, '1', '0');

INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '1', '医德医风', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '2', '医生评价', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '3', '护士评价', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '4', '后勤', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '5', '收费', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '6', '环境', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '7', '医技评价', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '8', '医疗设备评价', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '9', '医疗后随访评价', '满意度分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '6', '10', '就医流程', '满意度分类', '#', NOW(), NOW());

INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '5', '满意', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '4', '较满意', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '3', '一般', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '2', '不满意', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '1', '很不满意', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '5', '-99', '不参与评价', '满意度级别', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0201', '3', '0201', '出院宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0203', '3', '0203', '入院宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0205', '3', '0205', '术前宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0207', '3', '0207', '术后宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0209', '3', '0209', '特殊检查', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0211', '3', '0211', '用药宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0213', '3', '0213', '疾病宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0215', '3', '0215', '门诊宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0217', '3', '0217', '护理宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0219', '3', '0219', '其他宣教', '初始化宣教分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0601', '2', '0201', '出院宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0603', '2', '0203', '入院宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0605', '2', '0205', '术前宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0607', '2', '0207', '术后宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0609', '2', '0209', '特殊检查', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0611', '2', '0211', '用药宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0613', '2', '0213', '疾病宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0615', '2', '0215', '门诊宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0617', '2', '0217', '护理宣教', '初始化宣教规则分类', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES ('#0619', '2', '0219', '其他宣教', '初始化宣教规则分类', '#', NOW(), NOW());

INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '11', '1', '提出建议/望改进', '投诉目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '11', '2', '咨询了解', '投诉目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '11', '3', '望能给予合理解释', '投诉目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '11', '4', '抱怨', '投诉目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '11', '5', '要求索赔', '投诉目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '12', '1', '望转达表扬', '表扬目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '12', '2', '望嘉奖', '表扬目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '12', '3', '望树立典型', '表扬目的', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '13', '1', '来电', '投诉表扬来源', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '13', '2', '微信', '投诉表扬来源', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '13', '3', 'app', '投诉表扬来源', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '13', '4', '回访', '投诉表扬来源', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '1', '本人', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '2', '配偶', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '3', '父亲', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '4', '母亲', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '5', '儿子', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '6', '女儿', '与患者关系', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '14', '7', '朋友', '与患者关系', '#', NOW(), NOW());

INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '1', '医疗技术', '医疗技术', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '2', '流程便捷性', '流程便捷性', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '3', '收费合理性', '收费合理性', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '4', '就医环境', '就医环境', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '5', '信息告知及时度', '信息告知及时度', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '6', '服务态度', '服务态度', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '7', '工作效率', '工作效率', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '15', '8', '其他', '其他', '#', NOW(), NOW());

INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '1', '医疗技术', '医疗技术', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '2', '流程便捷性', '流程便捷性', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '3', '收费合理性', '收费合理性', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '4', '就医环境', '就医环境', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '5', '信息告知及时度', '信息告知及时度', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '6', '服务态度', '服务态度', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '7', '工作效率', '工作效率', '#', NOW(), NOW());
INSERT INTO `t_manage_range` (`id`, `catalog_id`, `range_value`, `range_key`, `range_desc`, `hosp_code`, `create_time`, `update_time`) VALUES (REPLACE(UUID(),'-',''), '16', '8', '其他', '其他', '#', NOW(), NOW());


INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0201', '出院宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0203', '入院宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0205', '术前宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0207', '术后宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0209', '特殊检查', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0211', '用药宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0213', '疾病宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0215', '门诊宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0217', '护理宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0219', '其他宣教', '2', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0601', '出院宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0603', '入院宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0605', '术前宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0607', '术后宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0609', '特殊检查', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0611', '用药宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0613', '疾病宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0615', '门诊宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0617', '护理宣教', '6', '0', '#', null, NOW(), NOW());
INSERT INTO `t_repository_category` (`category_id`, `category_name`, `category_type`, `category_property`, `hosp_code`, `user_id`, `create_time`, `update_time`) VALUES ('#0619', '其他宣教', '6', '0', '#', null, NOW(), NOW());

上线步骤

  1. 蓝牛后台维护医院信息并修改医院参数配置HOS_OR_YUN=1

  2. AI维护医院信息，配置场景，话术（问候语）

  3. celina维护医院信息

  4. 随访后台生成密钥 MAC地址：00-16-3E-12-D5-0D

  5. 登录知识库，分配表单、规则

  6. 执行初始化sql脚本

  7. 修改配置文件server.properties

    1. hos_permissions 密钥

    2. cloud_hosp saas模式医院

    3. ai_app_id、ai_app_key、ai_app_sercert AI请求相关参数

  8. 登录admin账号

  9. 创建科室、用户、计划