python----/数据分析/泡中老师分组/demo.ipynb at master

Files

T

- 新增websocket客户端和服务端实现
- 添加图片压缩工具和快速压缩脚本
- 实现学生信息处理相关API
- 添加MQTT客户端和消息处理功能
- 更新.gitignore忽略更多文件类型
- 添加数据库操作工具和示例
- 实现多个测试脚本和工具类

2026-04-13 14:47:50 +08:00

83 KiB

Raw Permalink Blame History

In [ ]:

import pandas as pd

# 读取Excel文件中的所有sheet
file_path = "./教工信息.xlsx"  # 替换为你的Excel文件路径
all_sheets = pd.read_excel(file_path, sheet_name=None,dtype=str)

[1;31m在当前单元格或上一个单元格中执行代码时 Kernel 崩溃。

[1;31m请查看单元格中的代码，以确定故障的可能原因。

[1;31m单击<a href='https://aka.ms/vscodeJupyterKernelCrash'>此处</a>了解详细信息。

[1;31m有关更多详细信息，请查看 Jupyter <a href='command:jupyter.viewOutput'>log</a>。

In [8]:

print("所有sheet名称：", list(all_sheets.keys()))

所有sheet名称： ['总表格透视表', '总表格', '百仁教师63', '本部教师207', '离职教师29', '食堂55', '特色课外聘教师10', '图书馆1', '外来运送人员2', '文印室1', '物业24', '鸿兴运达17', '128个未确定账号']

In [10]:

all_sheets["百仁教师63"]

Out [10]:

	姓名	手环号	工号	性别	电话号码	类别	聘用形式	部门/部门职责	部门权限	年级	班级	课程	账户名	分组	学科
0	王露	2402976695	zz_wanglu	女	NaN	学工处	校聘	NaN	NaN	NaN	NaN	政治	zz_wanglu	百仁分校教师组	NaN
1	董明湘	3184695831	ls_dongmingxiang	男	NaN	学工处	校聘	NaN	NaN	NaN	NaN	历史	ls_dongmingxiang	百仁分校教师组	NaN
2	何佳	2489238298	wl_hejia	女	18282551593	普通教师	校聘	教师/2024学部,物理/教师,出勤、形象、通讯/主管	考勤组,任课老师	2021级	NaN	物理	wl_hejia	百仁分校教师组	NaN
3	袁郭婷	2493974330	wy_yuanguoting	女	13438309202	班主任	校聘	教师/2024学部,英语/教师,导师项目组/导师	班主任	2021级	14班	英语	wy_yuanguoting	百仁分校教师组	NaN
4	赵海西	3856389518	wl_zhaohaixi	女	18111670821	普通教师	在编	教师/2024学部	任课老师	2022级	NaN	物理	zhaohaixi_js	百仁分校教师组	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
58	李红沄	3274430679	sx_lihongyun	女	19823001768	普通教师	外聘	数学/教师	任课老师	NaN	NaN	NaN	sx_lihongyun	百仁分校教师组	NaN
59	王雯雯	2476255722	yy_wangwenwen	女	17740276207	普通教师	外聘	语文/教师	任课老师	NaN	NaN	NaN	yy_wangwenwen	百仁分校教师组	NaN
60	向洋伸	1673678106	yy_xiangyangshen	男	19938041918	普通教师	外聘	语文/教师	任课老师	NaN	NaN	NaN	yy_xiangyangshen	百仁分校教师组	NaN
61	白婧	2465527370	sx_baijing	女	18123377937	普通教师	外聘	数学/教师	任课老师	NaN	NaN	NaN	sx_baijing	百仁分校教师组	NaN
62	刘春宏	2635403867	liuchunhong	女	15282119055	普通教师	外聘	历史/教师	任课老师	NaN	NaN	NaN	NaN	百仁分校教师组	NaN

63 rows × 15 columns

In [50]:

from requests import get,post
ip = "http://band.hxzhxy.cn"
param = {
    "username": "xtl",
    "password": "xia123456",
    "client_id": "client",
    "grant_type": "password",
    "client_secret": "123456",
}
data = get(url=f"http://band.hxzhxy.cn/oauth/token?username=zhongwei&password=123456a&client_id=client&grant_type=password&client_secret=123456").json()
token = data["access_token"]
header = {
    "content-type": "application/json",
    "authorization": f"Bearer {token}",
}

In [ ]:

tree = get("https://www.hxzhxy.cn/hxyd-api/uc/depart/tree?teaId=&teamId=19&access_token=85eef73e-3422-4919-ba7b-cce9cebe8c62").json()["data"]

{'success': True,
 'msg': '操作成功',
 'code': 0,
 'data': {'id': '-1',
  'text': '顶级节点',
  'jobId': None,
  'state': {'opened': True},
  'checked': True,
  'attributes': None,
  'children': [{'id': '162',
    'text': '教师',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '462',
      'text': '语文',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 377, 'jobName': '教师', 'departId': 462, 'teamId': 19},
       {'id': 378, 'jobName': '学科主任', 'departId': 462, 'teamId': 19},
       {'id': 415, 'jobName': '备课组长', 'departId': 462, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '463',
      'text': '数学',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 379, 'jobName': '教师', 'departId': 463, 'teamId': 19},
       {'id': 380, 'jobName': '学科主任', 'departId': 463, 'teamId': 19},
       {'id': 412, 'jobName': '备课组长', 'departId': 463, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '464',
      'text': '英语',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 381, 'jobName': '教师', 'departId': 464, 'teamId': 19},
       {'id': 382, 'jobName': '学科主任', 'departId': 464, 'teamId': 19},
       {'id': 416, 'jobName': '备课组长', 'departId': 464, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '465',
      'text': '物理',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 383, 'jobName': '教师', 'departId': 465, 'teamId': 19},
       {'id': 384, 'jobName': '学科主任', 'departId': 465, 'teamId': 19},
       {'id': 417, 'jobName': '备课组长', 'departId': 465, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '466',
      'text': '化学',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 385, 'jobName': '教师', 'departId': 466, 'teamId': 19},
       {'id': 386, 'jobName': '学科主任', 'departId': 466, 'teamId': 19},
       {'id': 418, 'jobName': '备课组长', 'departId': 466, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '467',
      'text': '生物',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 387, 'jobName': '教师', 'departId': 467, 'teamId': 19},
       {'id': 388, 'jobName': '学科主任', 'departId': 467, 'teamId': 19},
       {'id': 419, 'jobName': '备课组长', 'departId': 467, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '468',
      'text': '道法',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 389, 'jobName': '教师', 'departId': 468, 'teamId': 19},
       {'id': 390, 'jobName': '学科主任', 'departId': 468, 'teamId': 19},
       {'id': 420, 'jobName': '备课组长', 'departId': 468, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '469',
      'text': '历史',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 391, 'jobName': '教师', 'departId': 469, 'teamId': 19},
       {'id': 392, 'jobName': '学科主任', 'departId': 469, 'teamId': 19},
       {'id': 421, 'jobName': '备课组长', 'departId': 469, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '470',
      'text': '地理',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 393, 'jobName': '教师', 'departId': 470, 'teamId': 19},
       {'id': 394, 'jobName': '学科主任', 'departId': 470, 'teamId': 19},
       {'id': 422, 'jobName': '备课组长', 'departId': 470, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '471',
      'text': '音乐',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 395, 'jobName': '教师', 'departId': 471, 'teamId': 19},
       {'id': 396, 'jobName': '学科主任', 'departId': 471, 'teamId': 19},
       {'id': 423, 'jobName': '备课组长', 'departId': 471, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '472',
      'text': '体育',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 397, 'jobName': '教师', 'departId': 472, 'teamId': 19},
       {'id': 398, 'jobName': '学科主任', 'departId': 472, 'teamId': 19},
       {'id': 424, 'jobName': '备课组长', 'departId': 472, 'teamId': 19},
       {'id': 429, 'jobName': '器材管理员', 'departId': 472, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '473',
      'text': '美术',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 399, 'jobName': '教师', 'departId': 473, 'teamId': 19},
       {'id': 400, 'jobName': '学科主任', 'departId': 473, 'teamId': 19},
       {'id': 425, 'jobName': '备课组长', 'departId': 473, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '474',
      'text': '技术',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 401, 'jobName': '教师', 'departId': 474, 'teamId': 19},
       {'id': 402, 'jobName': '学科主任', 'departId': 474, 'teamId': 19},
       {'id': 426, 'jobName': '备课组长', 'departId': 474, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '475',
      'text': '艺术',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 403, 'jobName': '教师', 'departId': 475, 'teamId': 19},
       {'id': 404, 'jobName': '学科主任', 'departId': 475, 'teamId': 19},
       {'id': 427, 'jobName': '备课组长', 'departId': 475, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '476',
      'text': '综合',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 405, 'jobName': '教师', 'departId': 476, 'teamId': 19},
       {'id': 406, 'jobName': '学科主任', 'departId': 476, 'teamId': 19},
       {'id': 428, 'jobName': '备课组长', 'departId': 476, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '478',
      'text': '心理',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 430, 'jobName': '教师', 'departId': 478, 'teamId': 19},
       {'id': 431, 'jobName': '学科主任', 'departId': 478, 'teamId': 19},
       {'id': 432, 'jobName': '备课组长', 'departId': 478, 'teamId': 19}],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False},
     {'id': '479',
      'text': '教辅',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [],
      'parentId': '162',
      'hasParent': True,
      'hasChildren': False}],
    'list': [{'id': 366, 'jobName': '2024学部', 'departId': 162, 'teamId': 19},
     {'id': 375, 'jobName': '2025学部', 'departId': 162, 'teamId': 19},
     {'id': 376, 'jobName': '2026学部', 'departId': 162, 'teamId': 19},
     {'id': 409, 'jobName': '2024学部主任', 'departId': 162, 'teamId': 19},
     {'id': 410, 'jobName': '2025学部主任', 'departId': 162, 'teamId': 19},
     {'id': 411, 'jobName': '2026学部主任', 'departId': 162, 'teamId': 19},
     {'id': 413, 'jobName': '交流', 'departId': 162, 'teamId': 19},
     {'id': 414, 'jobName': '病假', 'departId': 162, 'teamId': 19},
     {'id': 443, 'jobName': '2027学部主任', 'departId': 162, 'teamId': 19},
     {'id': 444, 'jobName': '2027学部', 'departId': 162, 'teamId': 19}],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '164',
    'text': '项目组',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '213',
      'text': '教育顾问',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 147, 'jobName': '教育顾问', 'departId': 213, 'teamId': 19},
       {'id': 164, 'jobName': '主管', 'departId': 213, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '214',
      'text': '导师项目组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 146, 'jobName': '导师', 'departId': 214, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '215',
      'text': '游学项目组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 144, 'jobName': '主管', 'departId': 215, 'teamId': 19},
       {'id': 145, 'jobName': '组员', 'departId': 215, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '216',
      'text': '自主管理学院',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 142, 'jobName': '主管', 'departId': 216, 'teamId': 19},
       {'id': 143, 'jobName': '组员', 'departId': 216, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '217',
      'text': '出勤、形象、通讯',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [{'id': '441',
        'text': '初一出勤项目组',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 310, 'jobName': '主管', 'departId': 441, 'teamId': 19},
         {'id': 311, 'jobName': '组员', 'departId': 441, 'teamId': 19}],
        'parentId': '217',
        'hasParent': True,
        'hasChildren': False},
       {'id': '442',
        'text': '初二出勤项目组',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 312, 'jobName': '主管', 'departId': 442, 'teamId': 19},
         {'id': 313, 'jobName': '组员', 'departId': 442, 'teamId': 19}],
        'parentId': '217',
        'hasParent': True,
        'hasChildren': False},
       {'id': '443',
        'text': '初三出勤项目组',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 314, 'jobName': '主管', 'departId': 443, 'teamId': 19},
         {'id': 315, 'jobName': '组员', 'departId': 443, 'teamId': 19}],
        'parentId': '217',
        'hasParent': True,
        'hasChildren': False},
       {'id': '495',
        'text': '2025级出勤项目组',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 450, 'jobName': '主管', 'departId': 495, 'teamId': 19}],
        'parentId': '217',
        'hasParent': True,
        'hasChildren': False}],
      'list': [{'id': 140, 'jobName': '主管', 'departId': 217, 'teamId': 19},
       {'id': 141, 'jobName': '组员', 'departId': 217, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': True},
     {'id': '218',
      'text': '晨练',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 138, 'jobName': '主管', 'departId': 218, 'teamId': 19},
       {'id': 139, 'jobName': '组员', 'departId': 218, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '219',
      'text': '自习',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 136, 'jobName': '主管', 'departId': 219, 'teamId': 19},
       {'id': 137, 'jobName': '组员', 'departId': 219, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '331',
      'text': '大课间',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 159, 'jobName': '主管', 'departId': 331, 'teamId': 19},
       {'id': 160, 'jobName': '组员', 'departId': 331, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '332',
      'text': '学生综合素养',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 162, 'jobName': '主管', 'departId': 332, 'teamId': 19},
       {'id': 163, 'jobName': '组员', 'departId': 332, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '338',
      'text': '国际化',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 177, 'jobName': '主管', 'departId': 338, 'teamId': 19},
       {'id': 178, 'jobName': '组员', 'departId': 338, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '414',
      'text': '校医保健',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 265, 'jobName': '主管', 'departId': 414, 'teamId': 19},
       {'id': 266, 'jobName': '组员', 'departId': 414, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '447',
      'text': '党政办公室',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 322, 'jobName': '人事主管', 'departId': 447, 'teamId': 19},
       {'id': 323, 'jobName': '人事专员', 'departId': 447, 'teamId': 19},
       {'id': 335, 'jobName': '党务主管', 'departId': 447, 'teamId': 19},
       {'id': 336, 'jobName': '宣传主管', 'departId': 447, 'teamId': 19},
       {'id': 337, 'jobName': '成员', 'departId': 447, 'teamId': 19},
       {'id': 338, 'jobName': '办公室主任', 'departId': 447, 'teamId': 19},
       {'id': 339, 'jobName': '办公室副主任', 'departId': 447, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '450',
      'text': '校务委员会',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 324, 'jobName': '书记', 'departId': 450, 'teamId': 19},
       {'id': 325, 'jobName': '校长', 'departId': 450, 'teamId': 19},
       {'id': 326, 'jobName': '行政副校长', 'departId': 450, 'teamId': 19},
       {'id': 327, 'jobName': '教学副校长', 'departId': 450, 'teamId': 19},
       {'id': 328, 'jobName': '德育副校长', 'departId': 450, 'teamId': 19},
       {'id': 329, 'jobName': '后勤副校长', 'departId': 450, 'teamId': 19},
       {'id': 330, 'jobName': '校长助理', 'departId': 450, 'teamId': 19},
       {'id': 331, 'jobName': '办公室主任', 'departId': 450, 'teamId': 19},
       {'id': 332, 'jobName': '总务后勤中心主任', 'departId': 450, 'teamId': 19},
       {'id': 333, 'jobName': '教务中心主任', 'departId': 450, 'teamId': 19},
       {'id': 334, 'jobName': '课程中心主任', 'departId': 450, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '451',
      'text': '成长联合会',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 340, 'jobName': '主任', 'departId': 451, 'teamId': 19},
       {'id': 341, 'jobName': '德育主管', 'departId': 451, 'teamId': 19},
       {'id': 343, 'jobName': '团委书记', 'departId': 451, 'teamId': 19},
       {'id': 344, 'jobName': '心理工作主管', 'departId': 451, 'teamId': 19},
       {'id': 345, 'jobName': '成员', 'departId': 451, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '454',
      'text': '课程教学中心',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 346, 'jobName': '主任', 'departId': 454, 'teamId': 19},
       {'id': 347, 'jobName': '成员', 'departId': 454, 'teamId': 19},
       {'id': 348, 'jobName': '教学主管', 'departId': 454, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '457',
      'text': '后勤中心',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 352, 'jobName': '电教员', 'departId': 457, 'teamId': 19},
       {'id': 353, 'jobName': '报账员', 'departId': 457, 'teamId': 19},
       {'id': 354, 'jobName': '工会主席', 'departId': 457, 'teamId': 19},
       {'id': 355, 'jobName': '工会成员', 'departId': 457, 'teamId': 19},
       {'id': 356, 'jobName': '图书管理员', 'departId': 457, 'teamId': 19},
       {'id': 357, 'jobName': '文印管理员', 'departId': 457, 'teamId': 19},
       {'id': 358, 'jobName': '主任', 'departId': 457, 'teamId': 19},
       {'id': 359, 'jobName': '成员', 'departId': 457, 'teamId': 19},
       {'id': 435, 'jobName': '生活管理', 'departId': 457, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '459',
      'text': '教师书院',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 364, 'jobName': '成员', 'departId': 459, 'teamId': 19},
       {'id': 365, 'jobName': '院长', 'departId': 459, 'teamId': 19}],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False},
     {'id': '477',
      'text': '学术委员会',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [],
      'parentId': '164',
      'hasParent': True,
      'hasChildren': False}],
    'list': [{'id': 79, 'jobName': '主管', 'departId': 164, 'teamId': 19},
     {'id': 80, 'jobName': '组员', 'departId': 164, 'teamId': 19}],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '448',
    'text': '物业',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '487',
      'text': '电工组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 441, 'jobName': '员工', 'departId': 487, 'teamId': 19}],
      'parentId': '448',
      'hasParent': True,
      'hasChildren': False},
     {'id': '511',
      'text': '安保组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 462, 'jobName': '员工', 'departId': 511, 'teamId': 19}],
      'parentId': '448',
      'hasParent': True,
      'hasChildren': False},
     {'id': '512',
      'text': '保洁组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 463, 'jobName': '员工', 'departId': 512, 'teamId': 19}],
      'parentId': '448',
      'hasParent': True,
      'hasChildren': False},
     {'id': '520',
      'text': '文印图书室',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 464, 'jobName': '员工', 'departId': 520, 'teamId': 19}],
      'parentId': '448',
      'hasParent': True,
      'hasChildren': False},
     {'id': '521',
      'text': '管理组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 465, 'jobName': '经理', 'departId': 521, 'teamId': 19}],
      'parentId': '448',
      'hasParent': True,
      'hasChildren': False}],
    'list': [{'id': 360, 'jobName': '保洁', 'departId': 448, 'teamId': 19},
     {'id': 361, 'jobName': '保安', 'departId': 448, 'teamId': 19},
     {'id': 362, 'jobName': '保洁班长', 'departId': 448, 'teamId': 19},
     {'id': 363, 'jobName': '安保队长', 'departId': 448, 'teamId': 19},
     {'id': 433, 'jobName': '文印', 'departId': 448, 'teamId': 19},
     {'id': 434, 'jobName': '库管', 'departId': 448, 'teamId': 19}],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '449',
    'text': '食堂',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '489',
      'text': '食堂员工',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 445, 'jobName': '员工', 'departId': 489, 'teamId': 19},
       {'id': 446, 'jobName': '经理', 'departId': 489, 'teamId': 19}],
      'parentId': '449',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '452',
    'text': '临时',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '453',
      'text': '信息保障部',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [{'id': '497',
        'text': '外部人员',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [],
        'parentId': '453',
        'hasParent': True,
        'hasChildren': False}],
      'list': [{'id': 342, 'jobName': '工程师', 'departId': 453, 'teamId': 19}],
      'parentId': '452',
      'hasParent': True,
      'hasChildren': True},
     {'id': '480',
      'text': '文印室门卡',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 436, 'jobName': '临时卡', 'departId': 480, 'teamId': 19}],
      'parentId': '452',
      'hasParent': True,
      'hasChildren': False},
     {'id': '485',
      'text': '分校教师',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [{'id': '486',
        'text': '地理',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 440, 'jobName': '教师', 'departId': 486, 'teamId': 19}],
        'parentId': '485',
        'hasParent': True,
        'hasChildren': False},
       {'id': '499',
        'text': '历史',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 454, 'jobName': '教师', 'departId': 499, 'teamId': 19}],
        'parentId': '485',
        'hasParent': True,
        'hasChildren': False}],
      'list': [],
      'parentId': '452',
      'hasParent': True,
      'hasChildren': True},
     {'id': '490',
      'text': '外来运送人员',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 447, 'jobName': '运试卷人员', 'departId': 490, 'teamId': 19}],
      'parentId': '452',
      'hasParent': True,
      'hasChildren': False},
     {'id': '498',
      'text': '临时外教',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 452, 'jobName': '教官', 'departId': 498, 'teamId': 19},
       {'id': 453, 'jobName': '跟岗实习老师', 'departId': 498, 'teamId': 19}],
      'parentId': '452',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '500',
    'text': '鸿兴运达测试账号',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '507',
      'text': '测试组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [{'id': '516',
        'text': '鸿兴运达',
        'jobId': None,
        'state': {'opened': True},
        'checked': False,
        'attributes': None,
        'children': [],
        'list': [{'id': 455, 'jobName': '开发', 'departId': 516, 'teamId': 19},
         {'id': 456, 'jobName': '市场', 'departId': 516, 'teamId': 19},
         {'id': 457, 'jobName': '闲置账号', 'departId': 516, 'teamId': 19}],
        'parentId': '507',
        'hasParent': True,
        'hasChildren': False}],
      'list': [],
      'parentId': '500',
      'hasParent': True,
      'hasChildren': True}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '503',
    'text': '百仁分校',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '504',
      'text': '百仁分校教师组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 458, 'jobName': '百仁教师', 'departId': 504, 'teamId': 19}],
      'parentId': '503',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '505',
    'text': '同文分校',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '506',
      'text': '同文分校教师组',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 461, 'jobName': '同文教师', 'departId': 506, 'teamId': 19}],
      'parentId': '505',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '509',
    'text': '账号未确认组',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '510',
      'text': '未确认账号',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [],
      'parentId': '509',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '513',
    'text': '离职组',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '519',
      'text': '离职教师',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 459, 'jobName': '离职教师', 'departId': 519, 'teamId': 19}],
      'parentId': '513',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '517',
    'text': '跟岗教师',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '518',
      'text': '跟岗教师',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 460, 'jobName': '跟岗教师', 'departId': 518, 'teamId': 19}],
      'parentId': '517',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True},
   {'id': '524',
    'text': '特色课外聘教师组',
    'jobId': None,
    'state': {'opened': True},
    'checked': False,
    'attributes': None,
    'children': [{'id': '525',
      'text': '特色课外聘教师',
      'jobId': None,
      'state': {'opened': True},
      'checked': False,
      'attributes': None,
      'children': [],
      'list': [{'id': 466, 'jobName': '教师', 'departId': 525, 'teamId': 19}],
      'parentId': '524',
      'hasParent': True,
      'hasChildren': False}],
    'list': [],
    'parentId': '0',
    'hasParent': False,
    'hasChildren': True}],
  'list': None,
  'parentId': '',
  'hasParent': False,
  'hasChildren': True}}

In [55]:

import pymysql
import snowflake
import random
# 创建数据库连接
conn = pymysql.connect(
host='www.hxzhxy.cn',
user='root',
password='@HXYD1109mysql',
database='school_server',
charset='utf8'
)
# 创建游标对象
cursor = conn.cursor()

In [56]:

def create_table(cursor,result):
    
    data = []
    for i in result:
        list_list = list(i)
        des=cursor.description  # 获取表详情，字段名，长度，属性等
        t = ",".join([item[0] for item in des])
        table_head = t.split(',')  # # 查询表列名 用,分割
    
        dict_result = dict(zip(table_head, list_list))  # 打包为元组的列表 再转换为字典
        data.append(dict_result)  # 将字典添加到list_result中
    return data

In [58]:

sql = "select * from teacher where team_id = 19"
cursor.execute(sql)
result = cursor.fetchall()
teacher = create_table(cursor,result)

In [59]:

len(teacher)

Out [59]:

In [62]:

def findTeacher(key,value):
    tem=[]
    for item in teacher:
        if item[key] == value:
            tem.append(item)
    return tem

In [78]:

move_teachers = []
for index, row in all_sheets["鸿兴运达17"].iterrows():
    serial_no = row["手环号"]
    no = row["工号"]
    tem = None
    tem = findTeacher("serial_no",serial_no)
    if len(tem) ==1:
        tem = tem[0]
    else:
        tem = findTeacher("tea_no",no)
        if len(tem) ==1:
            tem = tem[0]
        else:
            tem = None
    if tem != None:
        move_teachers.append(tem)
len(move_teachers)

Out [78]:

In [79]:

move_teachers

Out [79]:

[{'id': 339,
  'tea_name': '张三',
  'sex': 1,
  'phone': '18295478652',
  'type': 2,
  'grade_id': 107,
  'class_id': None,
  'user_name': 'zhangsan',
  'team_id': '19',
  'pid': None,
  'serial_no': '1111111114',
  'openid': None,
  'tea_no': '1006',
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '职工',
  'power': '',
  'class_type_name': '物业',
  'hire_id': 5,
  'flag': None,
  'state': 2},
 {'id': 341,
  'tea_name': '校长',
  'sex': 1,
  'phone': '16879797576',
  'type': 1,
  'grade_id': None,
  'class_id': None,
  'user_name': 'xiaozhang',
  'team_id': '19',
  'pid': None,
  'serial_no': '1111111115',
  'openid': None,
  'tea_no': '1008',
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '职工',
  'power': '',
  'class_type_name': '物业',
  'hire_id': 5,
  'flag': None,
  'state': 2},
 {'id': 65,
  'tea_name': '舒红星测',
  'sex': 1,
  'phone': '13980866925',
  'type': 7,
  'grade_id': 110,
  'class_id': 417,
  'user_name': 'ptslingshi',
  'team_id': '19',
  'pid': None,
  'serial_no': '0483168775',
  'openid': None,
  'tea_no': 'hxyd0001',
  'wx_phone': '13980866925',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,校长,年级主任,班主任,考勤组,门卫安保,维护,任课老师',
  'class_type_name': '物业',
  'hire_id': 5,
  'flag': None,
  'state': 2},
 {'id': 90,
  'tea_name': 'locktest',
  'sex': 1,
  'phone': '13118109637',
  'type': 1,
  'grade_id': None,
  'class_id': None,
  'user_name': 'locktest',
  'team_id': '19',
  'pid': None,
  'serial_no': '1111111112',
  'openid': None,
  'tea_no': None,
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '职工',
  'power': '校长',
  'class_type_name': '物业',
  'hire_id': 5,
  'flag': None,
  'state': 2},
 {'id': 602,
  'tea_name': '唐超教师测试',
  'sex': 1,
  'phone': '18782084828',
  'type': 1,
  'grade_id': None,
  'class_id': None,
  'user_name': 'tangchaoteachertest',
  'team_id': '19',
  'pid': None,
  'serial_no': '1111111111',
  'openid': None,
  'tea_no': 'testtang',
  'wx_phone': '18782084828',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '任课老师,管理员,维护',
  'class_type_name': '物理',
  'hire_id': 109,
  'flag': None,
  'state': 2},
 {'id': 805,
  'tea_name': '夏天乐',
  'sex': 1,
  'phone': '17307283669',
  'type': 7,
  'grade_id': 110,
  'class_id': 520,
  'user_name': 'xiatianle',
  'team_id': '19',
  'pid': None,
  'serial_no': '9090909090',
  'openid': None,
  'tea_no': '2010530150',
  'wx_phone': '17307283669',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '班主任,年级主任,校长,管理员,考勤组,任课老师,维护',
  'class_type_name': None,
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 1139,
  'tea_name': '邹路露',
  'sex': 2,
  'phone': '17741322142',
  'type': 7,
  'grade_id': None,
  'class_id': None,
  'user_name': '20250606',
  'team_id': '19',
  'pid': None,
  'serial_no': '1780821797',
  'openid': None,
  'tea_no': '20250606',
  'wx_phone': '17741322142',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,校长,年级主任,班主任,维护,门卫安保,任课老师,考勤组',
  'class_type_name': '',
  'hire_id': 106,
  'flag': None,
  'state': None},
 {'id': 1150,
  'tea_name': '高天丽测试',
  'sex': 2,
  'phone': '15176025298',
  'type': 7,
  'grade_id': 120,
  'class_id': 444,
  'user_name': 'gaotianli',
  'team_id': '19',
  'pid': None,
  'serial_no': '1517602529',
  'openid': None,
  'tea_no': 'gaotianli',
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,校长,任课老师,年级主任,门卫安保,班主任,维护,考勤组,食堂',
  'class_type_name': '心理',
  'hire_id': 106,
  'flag': None,
  'state': None},
 {'id': 804,
  'tea_name': '唐超（维护）',
  'sex': 1,
  'phone': '18782084828',
  'type': 4,
  'grade_id': 120,
  'class_id': None,
  'user_name': 'qyh-ces',
  'team_id': '19',
  'pid': '513',
  'serial_no': '2010530199',
  'openid': None,
  'tea_no': '2010530149',
  'wx_phone': '19192637569',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '在编',
  'power': '任课老师,考勤组',
  'class_type_name': None,
  'hire_id': 7,
  'flag': None,
  'state': 2},
 {'id': 89,
  'tea_name': '测试校长',
  'sex': 1,
  'phone': '18863263652',
  'type': 1,
  'grade_id': None,
  'class_id': None,
  'user_name': 'ptstest',
  'team_id': '19',
  'pid': None,
  'serial_no': '1111111113',
  'openid': None,
  'tea_no': None,
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '职工',
  'power': '管理员,校长,年级主任,班主任,考勤组',
  'class_type_name': '物业',
  'hire_id': 5,
  'flag': None,
  'state': 2},
 {'id': 238,
  'tea_name': '王强',
  'sex': 1,
  'phone': '15528252515',
  'type': 1,
  'grade_id': 110,
  'class_id': 363,
  'user_name': 'wangwang',
  'team_id': '19',
  'pid': None,
  'serial_no': '2063765495',
  'openid': None,
  'tea_no': 'wangqiang',
  'wx_phone': None,
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '任课老师',
  'class_type_name': '物业',
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 596,
  'tea_name': '彭海东',
  'sex': 1,
  'phone': '13688433616',
  'type': 3,
  'grade_id': None,
  'class_id': None,
  'user_name': '2097666787',
  'team_id': '19',
  'pid': None,
  'serial_no': '2995466598',
  'openid': None,
  'tea_no': '2024041101',
  'wx_phone': '13688433616',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '任课老师,班主任,校长,年级主任,门卫安保,考勤组,维护,食堂,管理员',
  'class_type_name': None,
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 603,
  'tea_name': '罗德军',
  'sex': 1,
  'phone': '18111797614',
  'type': 7,
  'grade_id': None,
  'class_id': None,
  'user_name': 'luodejun',
  'team_id': '19',
  'pid': None,
  'serial_no': '1340308791',
  'openid': None,
  'tea_no': 'luodejun',
  'wx_phone': '18111797614',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,门卫安保,校长',
  'class_type_name': None,
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 606,
  'tea_name': '大屏账号',
  'sex': 1,
  'phone': '17307283669',
  'type': 1,
  'grade_id': 120,
  'class_id': None,
  'user_name': 'ptsmaintain',
  'team_id': '19',
  'pid': None,
  'serial_no': '1780105621',
  'openid': None,
  'tea_no': '13222222',
  'wx_phone': '19113729874',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '在编',
  'power': '考勤组,年级主任,任课老师,班主任,门卫安保,校长,管理员',
  'class_type_name': None,
  'hire_id': 7,
  'flag': None,
  'state': 2},
 {'id': 609,
  'tea_name': '李豪测试',
  'sex': 1,
  'phone': '18228111545',
  'type': 4,
  'grade_id': None,
  'class_id': None,
  'user_name': 'lihao',
  'team_id': '19',
  'pid': None,
  'serial_no': '0123345666789',
  'openid': None,
  'tea_no': '2347550554',
  'wx_phone': '18228111545',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,校长,年级主任,班主任,门卫安保,维护,任课老师,考勤组',
  'class_type_name': None,
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 626,
  'tea_name': '钱正宇',
  'sex': 1,
  'phone': '15928771672',
  'type': 8,
  'grade_id': 107,
  'class_id': 367,
  'user_name': 'pt-qzy',
  'team_id': '19',
  'pid': None,
  'serial_no': '3460980620',
  'openid': None,
  'tea_no': 'hxydqzy1',
  'wx_phone': '15928771672',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '管理员,年级主任,门卫安保,任课老师,班主任',
  'class_type_name': None,
  'hire_id': 106,
  'flag': None,
  'state': 2},
 {'id': 682,
  'tea_name': '苗陕川',
  'sex': 1,
  'phone': '18202818328',
  'type': 8,
  'grade_id': None,
  'class_id': None,
  'user_name': 'pts-csq',
  'team_id': '19',
  'pid': None,
  'serial_no': '1620426772',
  'openid': None,
  'tea_no': 'pts-csq',
  'wx_phone': '18202818328',
  'user_id': None,
  'department_id': None,
  'zt_teacher_uuid': None,
  'hire': '临时工',
  'power': '维护,门卫安保,管理员,校长,年级主任,班主任,考勤组,任课老师',
  'class_type_name': None,
  'hire_id': 7,
  'flag': None,
  'state': 2}]

In [80]:

for item in move_teachers:
    if item is None:
        print("未找到")
    else:
        tea = get(f"{ip}/uc/teacher/get/{item['id']}",headers=header).json()["data"]
        tea["departIds"] = "516-457"
        tea["departNames"] = "鸿兴运达-闲置账号"
        print(tea)
        res = post(f"{ip}/uc/teacher/update/{item['id']}",json=tea,headers=header).json()
        print(res)

{'id': 339, 'teaName': '张三', 'sex': 1, 'phone': '18295478652', 'type': 2, 'gradeId': 107, 'classId': None, 'userName': 'zhangsan', 'teamId': 19, 'pid': None, 'serialNo': '1111111114', 'openid': None, 'teaNo': '1006', 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '职工', 'hireId': 5, 'power': '', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 341, 'teaName': '校长', 'sex': 1, 'phone': '16879797576', 'type': 1, 'gradeId': None, 'classId': None, 'userName': 'xiaozhang', 'teamId': 19, 'pid': None, 'serialNo': '1111111115', 'openid': None, 'teaNo': '1008', 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '职工', 'hireId': 5, 'power': '', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 65, 'teaName': '舒红星测', 'sex': 1, 'phone': '13980866925', 'type': 7, 'gradeId': 110, 'classId': 417, 'userName': 'ptslingshi', 'teamId': 19, 'pid': None, 'serialNo': '0483168775', 'openid': None, 'teaNo': 'hxyd0001', 'wxPhone': '13980866925', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 5, 'power': '管理员,校长,年级主任,班主任,考勤组,门卫安保,维护,任课老师', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 90, 'teaName': 'locktest', 'sex': 1, 'phone': '13118109637', 'type': 1, 'gradeId': None, 'classId': None, 'userName': 'locktest', 'teamId': 19, 'pid': None, 'serialNo': '1111111112', 'openid': None, 'teaNo': None, 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '职工', 'hireId': 5, 'power': '校长', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 602, 'teaName': '唐超教师测试', 'sex': 1, 'phone': '18782084828', 'type': 1, 'gradeId': None, 'classId': None, 'userName': 'tangchaoteachertest', 'teamId': 19, 'pid': None, 'serialNo': '1111111111', 'openid': None, 'teaNo': 'testtang', 'wxPhone': '18782084828', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 109, 'power': '任课老师,管理员,维护', 'flag': None, 'state': 2, 'classTypeName': '物理', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 805, 'teaName': '夏天乐', 'sex': 1, 'phone': '17307283669', 'type': 7, 'gradeId': 110, 'classId': 520, 'userName': 'xiatianle', 'teamId': 19, 'pid': None, 'serialNo': '9090909090', 'openid': None, 'teaNo': '2010530150', 'wxPhone': '17307283669', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '班主任,年级主任,校长,管理员,考勤组,任课老师,维护', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 1139, 'teaName': '邹路露', 'sex': 2, 'phone': '17741322142', 'type': 7, 'gradeId': None, 'classId': None, 'userName': '20250606', 'teamId': 19, 'pid': None, 'serialNo': '1780821797', 'openid': None, 'teaNo': '20250606', 'wxPhone': '17741322142', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '管理员,校长,年级主任,班主任,维护,门卫安保,任课老师,考勤组', 'flag': None, 'state': None, 'classTypeName': '', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 1150, 'teaName': '高天丽测试', 'sex': 2, 'phone': '15176025298', 'type': 7, 'gradeId': 120, 'classId': 444, 'userName': 'gaotianli', 'teamId': 19, 'pid': None, 'serialNo': '1517602529', 'openid': None, 'teaNo': 'gaotianli', 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '管理员,校长,任课老师,年级主任,门卫安保,班主任,维护,考勤组,食堂', 'flag': None, 'state': None, 'classTypeName': '心理', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 804, 'teaName': '唐超（维护）', 'sex': 1, 'phone': '18782084828', 'type': 4, 'gradeId': 120, 'classId': None, 'userName': 'qyh-ces', 'teamId': 19, 'pid': '513', 'serialNo': '2010530199', 'openid': None, 'teaNo': '2010530149', 'wxPhone': '19192637569', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '在编', 'hireId': 7, 'power': '任课老师,考勤组', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 89, 'teaName': '测试校长', 'sex': 1, 'phone': '18863263652', 'type': 1, 'gradeId': None, 'classId': None, 'userName': 'ptstest', 'teamId': 19, 'pid': None, 'serialNo': '1111111113', 'openid': None, 'teaNo': None, 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '职工', 'hireId': 5, 'power': '管理员,校长,年级主任,班主任,考勤组', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 238, 'teaName': '王强', 'sex': 1, 'phone': '15528252515', 'type': 1, 'gradeId': 110, 'classId': 363, 'userName': 'wangwang', 'teamId': 19, 'pid': None, 'serialNo': '2063765495', 'openid': None, 'teaNo': 'wangqiang', 'wxPhone': None, 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '任课老师', 'flag': None, 'state': 2, 'classTypeName': '物业', 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 596, 'teaName': '彭海东', 'sex': 1, 'phone': '13688433616', 'type': 3, 'gradeId': None, 'classId': None, 'userName': '2097666787', 'teamId': 19, 'pid': None, 'serialNo': '2995466598', 'openid': None, 'teaNo': '2024041101', 'wxPhone': '13688433616', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '任课老师,班主任,校长,年级主任,门卫安保,考勤组,维护,食堂,管理员', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 603, 'teaName': '罗德军', 'sex': 1, 'phone': '18111797614', 'type': 7, 'gradeId': None, 'classId': None, 'userName': 'luodejun', 'teamId': 19, 'pid': None, 'serialNo': '1340308791', 'openid': None, 'teaNo': 'luodejun', 'wxPhone': '18111797614', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '管理员,门卫安保,校长', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 606, 'teaName': '大屏账号', 'sex': 1, 'phone': '17307283669', 'type': 1, 'gradeId': 120, 'classId': None, 'userName': 'ptsmaintain', 'teamId': 19, 'pid': None, 'serialNo': '1780105621', 'openid': None, 'teaNo': '13222222', 'wxPhone': '19113729874', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '在编', 'hireId': 7, 'power': '考勤组,年级主任,任课老师,班主任,门卫安保,校长,管理员', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 609, 'teaName': '李豪测试', 'sex': 1, 'phone': '18228111545', 'type': 4, 'gradeId': None, 'classId': None, 'userName': 'lihao', 'teamId': 19, 'pid': None, 'serialNo': '0123345666789', 'openid': None, 'teaNo': '2347550554', 'wxPhone': '18228111545', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '管理员,校长,年级主任,班主任,门卫安保,维护,任课老师,考勤组', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 626, 'teaName': '钱正宇', 'sex': 1, 'phone': '15928771672', 'type': 8, 'gradeId': 107, 'classId': 367, 'userName': 'pt-qzy', 'teamId': 19, 'pid': None, 'serialNo': '3460980620', 'openid': None, 'teaNo': 'hxydqzy1', 'wxPhone': '15928771672', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 106, 'power': '管理员,年级主任,门卫安保,任课老师,班主任', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}
{'id': 682, 'teaName': '苗陕川', 'sex': 1, 'phone': '18202818328', 'type': 8, 'gradeId': None, 'classId': None, 'userName': 'pts-csq', 'teamId': 19, 'pid': None, 'serialNo': '1620426772', 'openid': None, 'teaNo': 'pts-csq', 'wxPhone': '18202818328', 'userId': None, 'departmentId': None, 'ztTeacherUuid': None, 'hire': '临时工', 'hireId': 7, 'power': '维护,门卫安保,管理员,校长,年级主任,班主任,考勤组,任课老师', 'flag': None, 'state': 2, 'classTypeName': None, 'departs': None, 'jobs': None, 'departIds': '516-457', 'departNames': '鸿兴运达-闲置账号'}
{'success': True, 'msg': '操作成功', 'code': 0, 'data': None}

In [ ]:

83 KiB Raw Permalink Blame History Unescape Escape

83 KiB

Raw Permalink Blame History