5.3.3、温州市

1、添加市节点

温州市的行政区划代码为33030，其下辖各区县的具体代码如下：鹿城区（330302）、龙湾区（330303）、瓯海区（330304）、洞头区（330305）、永嘉县（330324）、平阳县（330326）、苍南县（330327）、文成县（330328）、泰顺县（330329）、瑞安市（330381）、乐清市（330382）、龙港市（330383）

-- 添加市节点
INSERT INTO t_org_tree
(org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag)
VALUES(3303, 'node_sjyj', NULL, NULL, NULL, '温州市', NULL, 2, NULL, 1, 3303, '1', '01', '3303', 0, 1, '2025-06-09 12:30:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

2、添加区（县）节点

莲都区，青田县，缙云县，遂昌县，松阳县，云和县，庆元县，景宁畲族自治县，龙泉市

INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330302, 'node_jyj', null, null, null, '鹿城区', null, 3, null, 3303, 330302, '1', '01', '330302', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330303, 'node_jyj', null, null, null, '龙湾区', null, 3, null, 3303, 330303, '1', '01', '330303', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330304, 'node_jyj', null, null, null, '瓯海区', null, 3, null, 3303, 330304, '1', '01', '330304', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330305, 'node_jyj', null, null, null, '洞头区', null, 3, null, 3303, 330305, '1', '01', '330305', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330324, 'node_jyj', null, null, null, '永嘉县', null, 3, null, 3303, 330324, '1', '01', '330324', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330326, 'node_jyj', null, null, null, '平阳县', null, 3, null, 3303, 330326, '1', '01', '330326', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330327, 'node_jyj', null, null, null, '苍南县', null, 3, null, 3303, 330327, '1', '01', '330327', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330328, 'node_jyj', null, null, null, '文成县', null, 3, null, 3303, 330328, '1', '01', '330328', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330329, 'node_jyj', null, null, null, '泰顺县', null, 3, null, 3303, 330329, '1', '01', '330329', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330381, 'node_jyj', null, null, null, '瑞安市', null, 3, null, 3303, 330381, '1', '01', '330381', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330382, 'node_jyj', null, null, null, '乐清市', null, 3, null, 3303, 330382, '1', '01', '330382', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330383, 'node_jyj', null, null, null, '龙港市', null, 3, null, 3303, 330383, '1', '01', '330383', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);

3、添加区节点下的子节点

INSERT INTO t_org_tree
(org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag)
VALUES(330304312, 'node_category', NULL, NULL, NULL, '九年一贯制学校', NULL, 4, NULL, 330304, 5, '1', '82', '312', 0, 1, '2025-06-09 12:30:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO t_org_tree
(org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag)
VALUES(330304211, 'node_category', NULL, NULL, NULL, '小学', NULL, 4, NULL, 330304, 7, '1', '82', '211', 0, 1, '2025-06-09 12:30:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO t_org_tree
(org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag)
VALUES(330304513, 'node_category', NULL, NULL, NULL, '培智学校', NULL, 4, NULL, 330304, 8, '1', '82', '513', 0, 1, '2025-06-09 12:30:00', NULL, '2025-06-09 12:30:00', NULL, NULL, NULL, NULL, NULL, NULL);

4、添加区（县）管理员

• 增加 - 鹿城区（330302）超管

SET @org_name := '鹿城区';
SET @admin_type := '超管';
SET @phone := '10033030299';
SET @idcard := '33030200000000000X';
SET @org_id := (SELECT org_id FROM t_org_tree
WHERE org_name = @org_name and org_type in  ('node_school','node_sydw','node_sjyj','node_jyj'));

call add_admin_user(@admin_type, @phone, @idcard, "{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=", 10, @org_id, 1);

• 增加 - 龙湾区（330303）超管
• 增加 - 瓯海区（330304）超管

SET @org_name := '瓯海区';
SET @admin_type := '超管';
SET @phone := '10033030999';
SET @idcard := '33030000000000000X';
SET @org_id := (SELECT org_id FROM t_org_tree
WHERE org_name = @org_name and org_type in  ('node_school','node_sydw','node_sjyj','node_jyj'));

call add_admin_user(@admin_type, @phone, @idcard, "{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=", 10, @org_id, 1);

• 增加 - 洞头区（330305）超管
• 增加 - 永嘉县（330324）超管
• 增加 - 平阳县（330326）超管
• 增加 - 苍南县（330327）超管
• 增加 - 文成县（330328）超管
• 增加 - 泰顺县（330329）超管
• 增加 - 瑞安市（330381）超管
• 增加 - 乐清市（330382）超管
• 增加 - 龙港市（330383）超管