-- =====================================================
-- 医院科室字典配置
-- 创建时间: 2025-10-19
-- 说明: 用于急救转运任务中的医院科室选择
-- =====================================================

-- 1. 添加科室字典类型
INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, remark)
VALUES('医院科室', 'hospital_department', '0', 'admin', SYSDATE(), '医院科室列表');

-- 2. 添加常用科室字典数据
-- 急诊相关
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(1, '急诊科', '急诊科', 'hospital_department', '', 'danger', 'Y', '0', 'admin', SYSDATE(), '急诊科室');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(2, '急救中心', '急救中心', 'hospital_department', '', 'danger', 'N', '0', 'admin', SYSDATE(), '急救中心');

-- 内科系统
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(3, '心内科', '心内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '心血管内科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(4, '呼吸内科', '呼吸内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '呼吸内科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(5, '消化内科', '消化内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '消化内科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(6, '神经内科', '神经内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '神经内科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(7, '肾内科', '肾内科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '肾内科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(8, '内分泌科', '内分泌科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '内分泌科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(9, '血液科', '血液科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '血液科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(10, '风湿免疫科', '风湿免疫科', 'hospital_department', '', 'primary', 'N', '0', 'admin', SYSDATE(), '风湿免疫科');

-- 外科系统
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(11, '普外科', '普外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '普通外科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(12, '骨科', '骨科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '骨科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(13, '神经外科', '神经外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '神经外科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(14, '心胸外科', '心胸外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '心胸外科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(15, '泌尿外科', '泌尿外科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '泌尿外科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(16, '烧伤科', '烧伤科', 'hospital_department', '', 'success', 'N', '0', 'admin', SYSDATE(), '烧伤科');

-- 专科
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(17, 'ICU', 'ICU', 'hospital_department', '', 'warning', 'N', '0', 'admin', SYSDATE(), '重症监护室');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(18, 'CCU', 'CCU', 'hospital_department', '', 'warning', 'N', '0', 'admin', SYSDATE(), '冠心病监护病房');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(19, '肿瘤科', '肿瘤科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '肿瘤科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(20, '感染科', '感染科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '感染科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(21, '儿科', '儿科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '儿科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(22, '妇产科', '妇产科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '妇产科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(23, '眼科', '眼科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '眼科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(24, '耳鼻喉科', '耳鼻喉科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '耳鼻喉科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(25, '口腔科', '口腔科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '口腔科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(26, '皮肤科', '皮肤科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '皮肤科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(27, '康复科', '康复科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '康复科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(28, '中医科', '中医科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '中医科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(29, '精神科', '精神科', 'hospital_department', '', 'info', 'N', '0', 'admin', SYSDATE(), '精神科');

INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
VALUES(30, '其他科室', '其他科室', 'hospital_department', '', 'default', 'N', '0', 'admin', SYSDATE(), '其他科室');
