5.3.1、丽水市

1、添加市节点

丽水市

-- 添加市节点
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(3301, 'node_sjyj', NULL, NULL, NULL, '丽水市', NULL, 2, NULL, 1, 3301, '1', '01', '3301', 0, 1, '2024-01-25 15:59:12', 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 (331102, 'node_jyj', null, null, null, '莲都区', null, 3, null, 3311, 331102, '1', '01', '331102', 0, 1, '2023-12-27 18:51:54', 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 (331121, 'node_jyj', null, null, null, '青田县', null, 3, null, 3311, 331121, '1', '01', '331121', 0, 1, '2023-12-27 18:51:54', 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 (331122, 'node_jyj', null, null, null, '缙云县', null, 3, null, 3311, 331122, '1', '01', '331122', 0, 1, '2023-12-27 18:51:54', 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 (331123, 'node_jyj', null, null, null, '遂昌县', null, 3, null, 3311, 331123, '1', '01', '331123', 0, 1, '2023-12-27 18:51:54', 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 (331124, 'node_jyj', null, null, null, '松阳县', null, 3, null, 3311, 331124, '1', '01', '331124', 0, 1, '2023-12-27 18:51:54', 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 (331125, 'node_jyj', null, null, null, '云和县', null, 3, null, 3311, 331125, '1', '01', '331125', 0, 1, '2023-12-27 18:51:54', 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 (331126, 'node_jyj', null, null, null, '庆元县', null, 3, null, 3311, 331126, '1', '01', '331126', 0, 1, '2023-12-27 18:51:54', 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 (331127, 'node_jyj', null, null, null, '景宁畲族自治县', null, 3, null, 3311, 331127, '1', '01', '331127', 0, 1, '2023-12-27 18:51:54', 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 (331181, 'node_jyj', null, null, null, '龙泉市', null, 3, null, 3311, 331181, '1', '01', '331181', 0, 1, '2023-12-27 18:51:54', null, null, null, null, null, null, null, null);

3、添加区（县）管理员

• 增加 - 莲都区超管

SET @org_name := '莲都区';
SET @admin_type := '超管';
SET @phone := '18956616665';
SET @idcard := '45050019740806000X';
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);

• 增加 - 青田县超管

SET @org_name := '青田县';
SET @admin_type := '超管';
SET @phone := '18956616661';
SET @idcard := '45050019740806001X';
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);

• 增加 - 缙云县超管

SET @org_name := '缙云县';
SET @nickname := '超管';
SET @phone := '18956616665';
SET @idcard := '45050019740806006X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 遂昌县超管

SET @org_name := '遂昌县';
SET @nickname := '超管';
SET @phone := '18956616662';
SET @idcard := '45050019740806002X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 松阳县超管

SET @org_name := '松阳县';
SET @nickname := '超管';
SET @phone := '18956616663';
SET @idcard := '45050019740806003X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 云和县超管

SET @org_name := '云和县';
SET @nickname := '超管';
SET @phone := '18956616664';
SET @idcard := '45050019740806004X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 庆元县超管

SET @org_name := '庆元县';
SET @nickname := '超管';
SET @phone := '18956616665';
SET @idcard := '45050019740806005X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 景宁畲族自治县超管

SET @org_name := '景宁畲族自治县';
SET @nickname := '超管';
SET @phone := '18956616667';
SET @idcard := '45050019740806007X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);

• 增加 - 龙泉市超管

SET @org_name := '龙泉市';
SET @nickname := '超管';
SET @phone := '18956616668';
SET @idcard := '45050019740806008X';
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(@nickname,@phone,@idcard,"{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=",10,@org_id,1);