Files
python----/智慧校园/本部/修改学生信息.ipynb
admin aac9f5934d feat: 添加多个功能模块和工具脚本
- 新增websocket客户端和服务端实现
- 添加图片压缩工具和快速压缩脚本
- 实现学生信息处理相关API
- 添加MQTT客户端和消息处理功能
- 更新.gitignore忽略更多文件类型
- 添加数据库操作工具和示例
- 实现多个测试脚本和工具类
2026-04-13 14:47:50 +08:00

49 KiB

In [ ]:
from requests import get,post
import pandas as pd
import time
teamId = 19
ip = "http://band.hxzhxy.cn"
param = {
    "username": "zhongwei",
    "password": "123456a",
    "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 [2]:
ip = "http://band.hxzhxy.cn"
param = {
    "username": "zhongwei",
    "password": "123456a",
    "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 [4]:
post(f"https://www.hxzhxy.cn/hxyd-api/uc/student/update/10988?access_token=8e3b06f6-8afa-4c0c-af86-7f7883295561",json={"boarder":2,"stuNo":"20242011","stuName":"杨坤泽","sex":1,"teamId":19,"gradeId":120,"classId":465,"seralNo":"0022830060","score":None,"moralEducation":None,"userName":"20242011CDSPTSZX","pid":None,"phone":None,"imgUrl":None,"accountIp":"183.220.91.179, 172.18.0.1","accountName":"None","trust":0,"gateRules":[{"serialNo":"DDG1350081071420319","ruleId":29},{"serialNo":"GHY5235100143","ruleId":29},{"serialNo":"DDG1350081071420327","ruleId":29}],"id":10988,"openid":None,"wxPhone":"13981832515","userId":None,"stature":None,"weight":None,"wxPhones":"17380618965","userIdse":None,"payUserId":None,"payState":0,"teaChild":0,"openids":None,"casId":None,"board":2,"chatOpenId":None,"chatOpenIds":None},headers=header).text
Out [4]:
'{"success":true,"msg":"操作成功","code":0,"data":null}'
In [8]:
for i in range(0,86):
    tem = get(f"https://www.hxzhxy.cn/hxyd-api/uc/student/pageInfo?teamId=19&name=&type=0&pageSize=30&pageNumber={i}&orderDirection=asc&access_token=8e3b06f6-8afa-4c0c-af86-7f7883295561").json()
    students = tem["data"]["content"]
    for student in students:
        if student["boarder"]==1:
            print(student["stuName"])
In [ ]:
In [ ]:
[{'id': 8355,
  'stuNo': '20240001',
  'stuName': '白航瑞',
  'sex': 1,
  'classId': 465,
  'gradeId': 120,
  'seralNo': '1617962212',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240001CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13666232465',
  'trust': 0,
  'userId': '5938903399464960',
  'stature': None,
  'weight': None,
  'wxPhones': '13980940027',
  'userIdse': None,
  'payUserId': '24082920111101886431',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '22班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 5,
  'setTime': None,
  'status': None,
  'userType': 0,
  'sumLocation': None,
  'arkName': None},
 {'id': 8486,
  'stuNo': '20240002',
  'stuName': '白洪睿',
  'sex': 1,
  'classId': 468,
  'gradeId': 120,
  'seralNo': '0270210100',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240002CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18981900580',
  'trust': 0,
  'userId': '5938903399481344',
  'stature': None,
  'weight': None,
  'wxPhones': '18981900590',
  'userIdse': None,
  'payUserId': '24082919550801883566',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '25班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8075,
  'stuNo': '20240003',
  'stuName': '白若耶',
  'sex': 2,
  'classId': 458,
  'gradeId': 120,
  'seralNo': '0267553092',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240003CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13981888123',
  'trust': 0,
  'userId': '5938903399481347',
  'stature': None,
  'weight': None,
  'wxPhones': '13558645862',
  'userIdse': None,
  'payUserId': '24082920102301886082',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '15班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7871,
  'stuNo': '20240005',
  'stuName': '班玛旦真',
  'sex': 1,
  'classId': 453,
  'gradeId': 120,
  'seralNo': '0269160820',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240005CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13558589553',
  'trust': 0,
  'userId': '5938903399481353',
  'stature': None,
  'weight': None,
  'wxPhones': '13666166162',
  'userIdse': None,
  'payUserId': '24082920183101890521',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '10班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8035,
  'stuNo': '20240006',
  'stuName': '蔡欣言',
  'sex': 2,
  'classId': 457,
  'gradeId': 120,
  'seralNo': '0269099620',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240006CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18140168633',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '13398154033',
  'userIdse': None,
  'payUserId': '24082920190401890886',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '14班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7787,
  'stuNo': '20240007',
  'stuName': '蔡雨宸',
  'sex': 2,
  'classId': 451,
  'gradeId': 120,
  'seralNo': '0269870596',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240007CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13981962651',
  'trust': 0,
  'userId': '5938903399497728',
  'stature': None,
  'weight': None,
  'wxPhones': '13699436293',
  'userIdse': None,
  'payUserId': '24082920174501889838',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '8班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7716,
  'stuNo': '20240008',
  'stuName': '蔡卓妗',
  'sex': 2,
  'classId': 449,
  'gradeId': 120,
  'seralNo': '3108310705',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240008CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '15984896777',
  'trust': 0,
  'userId': '5938903399497731',
  'stature': None,
  'weight': None,
  'wxPhones': '15328428888',
  'userIdse': None,
  'payUserId': '24082920170001889270',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '6班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8399,
  'stuNo': '20240009',
  'stuName': '蔡梓晨',
  'sex': 1,
  'classId': 466,
  'gradeId': 120,
  'seralNo': '0269296420',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240009CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '15828586559',
  'trust': 0,
  'userId': '5938903399497734',
  'stature': None,
  'weight': None,
  'wxPhones': '13688034159',
  'userIdse': None,
  'payUserId': '24082920052701885353',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '23班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7752,
  'stuNo': '20240011',
  'stuName': '曹云清',
  'sex': 2,
  'classId': 450,
  'gradeId': 120,
  'seralNo': '3108363729',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240011CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13797135968',
  'trust': 0,
  'userId': '5938903399497740',
  'stature': None,
  'weight': None,
  'wxPhones': '13986468673',
  'userIdse': None,
  'payUserId': '24082920172201889558',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '7班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8316,
  'stuNo': '20240012',
  'stuName': '曹哲',
  'sex': 1,
  'classId': 464,
  'gradeId': 120,
  'seralNo': '0268757828',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240012CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18681270088',
  'trust': 0,
  'userId': '5938903399497743',
  'stature': None,
  'weight': None,
  'wxPhones': '13981776563',
  'userIdse': None,
  'payUserId': '24082920195801891545',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '21班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8036,
  'stuNo': '20240013',
  'stuName': '陈柏屹',
  'sex': 1,
  'classId': 457,
  'gradeId': 120,
  'seralNo': '0266482244',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240013CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13880634411',
  'trust': 0,
  'userId': '5938903399514114',
  'stature': None,
  'weight': None,
  'wxPhones': '13880632773',
  'userIdse': None,
  'payUserId': '24082920190401890894',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '14班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8443,
  'stuNo': '20240014',
  'stuName': '陈春洋',
  'sex': 1,
  'classId': 467,
  'gradeId': 120,
  'seralNo': '0268471540',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240014CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18382158416',
  'trust': 0,
  'userId': '5938903399514117',
  'stature': None,
  'weight': None,
  'wxPhones': '13881735212',
  'userIdse': None,
  'payUserId': '24082919502701883178',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '24班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8076,
  'stuNo': '20240015',
  'stuName': '陈纯熙',
  'sex': 2,
  'classId': 458,
  'gradeId': 120,
  'seralNo': '3108296273',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240015CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18784368811',
  'trust': 0,
  'userId': '5938903399514120',
  'stature': None,
  'weight': None,
  'wxPhones': '18200302713',
  'userIdse': None,
  'payUserId': '24082920102401886090',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '15班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8077,
  'stuNo': '20240016',
  'stuName': '陈澹雅',
  'sex': 2,
  'classId': 458,
  'gradeId': 120,
  'seralNo': '3108598465',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240016CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18581958883',
  'trust': 0,
  'userId': '5938903399514123',
  'stature': None,
  'weight': None,
  'wxPhones': '18584180806',
  'userIdse': None,
  'payUserId': '24082920102401886098',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '15班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8275,
  'stuNo': '20240017',
  'stuName': '陈杜昀晓',
  'sex': 2,
  'classId': 463,
  'gradeId': 120,
  'seralNo': '0266152756',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240017CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18200295266',
  'trust': 0,
  'userId': '5938903399514126',
  'stature': None,
  'weight': None,
  'wxPhones': '13550109926',
  'userIdse': None,
  'payUserId': '24082920193901891209',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '20班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7956,
  'stuNo': '20240018',
  'stuName': '陈海云',
  'sex': 1,
  'classId': 455,
  'gradeId': 120,
  'seralNo': '0022678444',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240018CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18980446044',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '13908202095',
  'userIdse': None,
  'payUserId': '24082920142701886845',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '12班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7789,
  'stuNo': '20240019',
  'stuName': '陈昊贤',
  'sex': 1,
  'classId': 451,
  'gradeId': 120,
  'seralNo': '3108348977',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240019CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13980056121',
  'trust': 0,
  'userId': '5938903399530499',
  'stature': None,
  'weight': None,
  'wxPhones': '13541345248',
  'userIdse': None,
  'payUserId': '24082920174501889846',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '8班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8317,
  'stuNo': '20240020',
  'stuName': '陈何瑞',
  'sex': 1,
  'classId': 464,
  'gradeId': 120,
  'seralNo': '1778486261',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240020CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18081872193',
  'trust': 0,
  'userId': '5938903399530502',
  'stature': None,
  'weight': None,
  'wxPhones': '13880581128',
  'userIdse': None,
  'payUserId': '24082920195801891553',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '21班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7585,
  'stuNo': '20240021',
  'stuName': '陈佳蕾',
  'sex': 2,
  'classId': 446,
  'gradeId': 120,
  'seralNo': '0268829684',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240021CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18589056614',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '15680811681',
  'userIdse': None,
  'payUserId': '24082920155701888200',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '3班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8357,
  'stuNo': '20240022',
  'stuName': '陈嘉懿',
  'sex': 2,
  'classId': 465,
  'gradeId': 120,
  'seralNo': '0268549828',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240022CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18982096276',
  'trust': 0,
  'userId': '5938903399530508',
  'stature': None,
  'weight': None,
  'wxPhones': '15828413876',
  'userIdse': None,
  'payUserId': '24082920111101886439',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '22班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7996,
  'stuNo': '20240023',
  'stuName': '陈金都',
  'sex': 1,
  'classId': 456,
  'gradeId': 120,
  'seralNo': '3108665329',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240023CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13408505945',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '18161182550',
  'userIdse': None,
  'payUserId': '24082920000601884633',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '13班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7717,
  'stuNo': '20240024',
  'stuName': '陈琻瑶',
  'sex': 2,
  'classId': 449,
  'gradeId': 120,
  'seralNo': '3108630721',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240024CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13183889899',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '13183821819',
  'userIdse': None,
  'payUserId': '24082920170001889278',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '6班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8358,
  'stuNo': '20240025',
  'stuName': '陈锦轩',
  'sex': 1,
  'classId': 465,
  'gradeId': 120,
  'seralNo': '3108646209',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240025CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13880606905',
  'trust': 0,
  'userId': '5938903399546886',
  'stature': None,
  'weight': None,
  'wxPhones': '13551235299',
  'userIdse': None,
  'payUserId': '24082920111101886447',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '22班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7957,
  'stuNo': '20240026',
  'stuName': '陈璟悦',
  'sex': 2,
  'classId': 455,
  'gradeId': 120,
  'seralNo': '3108299345',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240026CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18602829680',
  'trust': 0,
  'userId': None,
  'stature': None,
  'weight': None,
  'wxPhones': '13550085643',
  'userIdse': None,
  'payUserId': '24082920142701886853',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '12班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7496,
  'stuNo': '20240028',
  'stuName': '陈俊喆',
  'sex': 1,
  'classId': 444,
  'gradeId': 120,
  'seralNo': '3108445889',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240028CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '15828301984',
  'trust': 0,
  'userId': '5938903399546895',
  'stature': None,
  'weight': None,
  'wxPhones': '13882286072',
  'userIdse': None,
  'payUserId': '24082920151401887484',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '1班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8444,
  'stuNo': '20240029',
  'stuName': '陈浚哲',
  'sex': 1,
  'classId': 467,
  'gradeId': 120,
  'seralNo': '3108305761',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240029CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13558841109',
  'trust': 0,
  'userId': '5938903399563266',
  'stature': None,
  'weight': None,
  'wxPhones': '13458569125',
  'userIdse': None,
  'payUserId': '24082919502801883187',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '24班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 2,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8117,
  'stuNo': '20240030',
  'stuName': '陈骏豪',
  'sex': 1,
  'classId': 459,
  'gradeId': 120,
  'seralNo': '0266605940',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240030CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18280082677',
  'trust': 0,
  'userId': '5938903399563269',
  'stature': None,
  'weight': None,
  'wxPhones': '13982137777',
  'userIdse': None,
  'payUserId': '24082920074201885748',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '16班',
  'sexName': '男',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 8400,
  'stuNo': '20240031',
  'stuName': '陈柯彤',
  'sex': 2,
  'classId': 466,
  'gradeId': 120,
  'seralNo': '0268698676',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240031CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '18383243137',
  'trust': 0,
  'userId': '5938903399563272',
  'stature': None,
  'weight': None,
  'wxPhones': '15983355660',
  'userIdse': None,
  'payUserId': '24082920052801885361',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '23班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7833,
  'stuNo': '20240032',
  'stuName': '陈可菲',
  'sex': 2,
  'classId': 452,
  'gradeId': 120,
  'seralNo': '0266010532',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240032CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '13982222582',
  'trust': 0,
  'userId': '5938903399563275',
  'stature': None,
  'weight': None,
  'wxPhones': '13808027918',
  'userIdse': None,
  'payUserId': '24082920180901890199',
  'payState': 0,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '9班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 1,
  'sumLocation': None,
  'arkName': None},
 {'id': 7628,
  'stuNo': '20240033',
  'stuName': '陈可欣',
  'sex': 2,
  'classId': 447,
  'gradeId': 120,
  'seralNo': '0270105684',
  'score': 'A',
  'moralEducation': 'A',
  'userName': '20240033CDSPTSZX',
  'teamId': 19,
  'pid': None,
  'phone': None,
  'imgUrl': None,
  'openid': None,
  'boarder': 2,
  'wxPhone': '15884480539',
  'trust': 0,
  'userId': '5938903399563278',
  'stature': None,
  'weight': None,
  'wxPhones': '13540295176',
  'userIdse': None,
  'payUserId': '24082920161701888553',
  'payState': 3,
  'teaChild': 0,
  'openids': None,
  'casId': None,
  'board': None,
  'chatOpenId': None,
  'chatOpenIds': None,
  'teamName': '成都市泡桐树中学',
  'gradeName': '2024级',
  'className': '4班',
  'sexName': '女',
  'battery': None,
  'steps': None,
  'rank': None,
  'roleName': None,
  'sleepStart': None,
  'sleepEnd': None,
  'type': 4,
  'setTime': None,
  'status': None,
  'userType': 0,
  'sumLocation': None,
  'arkName': None}]
In [ ]: