xtl/python----
6
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
python----/智慧校园/本部/demo.ipynb
T
admin 2d8c1ea8f9 chore: 批量新增各类工具脚本与配置文件 
1. 新增音频录制、下载、上传相关脚本
2. 新增数据库操作、API调用工具
3. 新增Excel数据处理脚本
4. 新增弱密码检测脚本
2026-06-14 17:47:15 +08:00

26 KiB
Raw Permalink Blame History

In [2]:
from requests import get,post
import pandas as pd
import time
teamId = 19
ip = "http://192.168.0.209:8100"
param = {
    "username": "zhongwei",
    "password": "123456a",
    "client_id": "client",
    "grant_type": "password",
    "client_secret": "123456",
}
data = get(url=f"{ip}/oauth/token",params=param).json()
token = data["access_token"]
header = {
    "content-type": "application/json",
    "authorization": f"Bearer {token}",
}
In [5]:
get(f"{ip}/uc/project/ueditor",headers=header).json()
Out [5]:
{'scrawlMaxSize': 10485760,
 'videoMaxSize': 104857600,
 'imageInsertAlign': 'none',
 'catcherMaxSize': 10485760,
 'snapscreenUrlPrefix': '',
 'videoActionName': 'video',
 'fileActionName': 'file',
 'imageCompressBorder': 5000,
 'imageManagerUrlPrefix': '',
 'imageManagerAllowFiles': ['.jpg', '.png', '.jpeg'],
 'scrawlUrlPrefix': '',
 'scrawlFieldName': 'file',
 'imageMaxSize': 10485760,
 'imageAllowFiles': ['.jpg', '.png', '.jpeg'],
 'snapscreenActionName': 'snap',
 'fileMaxSize': 104857600,
 'catcherActionName': 'catch',
 'fileFieldName': 'file',
 'fileManagerAllowFiles': ['.zip', '.pdf', '.doc'],
 'fileManagerActionName': 'listFile',
 'snapscreenInsertAlign': 'none',
 'fileUrlPrefix': '',
 'scrawlActionName': 'crawl',
 'imageManagerInsertAlign': 'none',
 'videoFieldName': 'file',
 'catcherLocalDomain': ['127.0.0.1', 'localhost'],
 'fileManagerListSize': 20,
 'imageActionName': 'image',
 'imageCompressEnable': True,
 'imageFieldName': 'file',
 'imageUrlPrefix': '',
 'videoUrlPrefix': '',
 'scrawlInsertAlign': 'none',
 'fileAllowFiles': ['.zip', '.pdf', '.doc'],
 'catcherUrlPrefix': '',
 'imageManagerListSize': 20,
 'catcherFieldName': 'source',
 'fileManagerUrlPrefix': '',
 'catcherAllowFiles': ['.jpg', '.png', '.jpeg'],
 'videoAllowFiles': ['.mp4'],
 'formulaConfig': {'imageUrlTemplate': 'https://r.latexeasy.com/image.svg?{}'},
 'imageManagerActionName': 'listImage'}
In [ ]:
get(
    f"{ip}/classAttend/into/pre",
    headers=header,
    params={
        "teamId": 119,
        "dateTime": 1776009600000,
        "teaName": "马靖",
        "serial": 9,
        "courseName": "26学部1班-班会",
    },
).json()
{'success': True,
 'msg': '操作成功',
 'code': 0,
 'data': [{'id': 11365245,
   'stuName': '郭嘉欣',
   'serialNo': '0022681452',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776050001000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8864,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365248,
   'stuName': '雷江昊然',
   'serialNo': '0022681580',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8867,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365267,
   'stuName': '吴梓萌',
   'serialNo': '0022722732',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036853000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8886,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036842000},
  {'id': 11365241,
   'stuName': '程柏涵',
   'serialNo': '0022795772',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036329000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8860,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036336000},
  {'id': 11365249,
   'stuName': '李然壹',
   'serialNo': '0022795964',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035905000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8868,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035899000},
  {'id': 11365274,
   'stuName': '杨雨嘉',
   'serialNo': '0022799916',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036401000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8893,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036382000},
  {'id': 11365238,
   'stuName': '蔡雨芮',
   'serialNo': '0022822732',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035453000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8857,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035468000},
  {'id': 11365265,
   'stuName': '魏俊洁',
   'serialNo': '0022830076',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036331000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8884,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036311000},
  {'id': 11365277,
   'stuName': '姚祉玲',
   'serialNo': '0022834044',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036142000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8896,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036135000},
  {'id': 11365260,
   'stuName': '汪昊涵',
   'serialNo': '3107628753',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8879,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365244,
   'stuName': '郭佳',
   'serialNo': '3108354337',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035462000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8863,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035455000},
  {'id': 11365270,
   'stuName': '徐文昊',
   'serialNo': '3108354417',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036866000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8889,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036861000},
  {'id': 11367018,
   'stuName': '唐悠雯',
   'serialNo': '3108388513',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 10981,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365259,
   'stuName': '万梓涵',
   'serialNo': '3108390097',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8878,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365279,
   'stuName': '朱泓安',
   'serialNo': '3108390369',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036955000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8898,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036996000},
  {'id': 11365240,
   'stuName': '陈峻鑫',
   'serialNo': '3108390481',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036695000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8859,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036686000},
  {'id': 11365242,
   'stuName': '代晋铭',
   'serialNo': '3108415505',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776047344000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8861,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776047354000},
  {'id': 11365257,
   'stuName': '唐裕康',
   'serialNo': '3108415697',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036869000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8876,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036873000},
  {'id': 11365253,
   'stuName': '吕仕瑞',
   'serialNo': '3108435409',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035766000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8872,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036856000},
  {'id': 11365255,
   'stuName': '彭雨绮',
   'serialNo': '3108435585',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036569000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8874,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036555000},
  {'id': 11365256,
   'stuName': '孙婧琪',
   'serialNo': '3108441105',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036193000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8875,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036185000},
  {'id': 11365258,
   'stuName': '涂凤扬',
   'serialNo': '3108442785',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036470000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8877,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036497000},
  {'id': 11365246,
   'stuName': '何俊达',
   'serialNo': '3108460593',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036368000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8865,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036374000},
  {'id': 11365271,
   'stuName': '徐梓轩',
   'serialNo': '3108464465',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035922000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8890,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035916000},
  {'id': 11365278,
   'stuName': '张紫涵',
   'serialNo': '3108580737',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035797000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8897,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035794000},
  {'id': 11365252,
   'stuName': '罗靖洁',
   'serialNo': '3108583121',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8871,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365261,
   'stuName': '王露静',
   'serialNo': '3108583313',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036402000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8880,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036386000},
  {'id': 11365247,
   'stuName': '侯家鸿',
   'serialNo': '3108588801',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035778000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8866,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035778000},
  {'id': 11365262,
   'stuName': '王洋梓桐',
   'serialNo': '3108598337',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776059188000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8881,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365268,
   'stuName': '夏紫萱',
   'serialNo': '3108601489',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036824000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8887,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036812000},
  {'id': 11365250,
   'stuName': '刘鸿维',
   'serialNo': '3108601841',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036278000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8869,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036308000},
  {'id': 11365276,
   'stuName': '姚谊诚',
   'serialNo': '3108603729',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8895,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035945000},
  {'id': 11365269,
   'stuName': '谢汶良',
   'serialNo': '3108605233',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036656000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8888,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036671000},
  {'id': 11365273,
   'stuName': '杨佳颖',
   'serialNo': '3108606065',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036436000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8892,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036424000},
  {'id': 11365239,
   'stuName': '曹雅莉',
   'serialNo': '3108606273',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036335000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8858,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036329000},
  {'id': 11365251,
   'stuName': '刘蔚菘',
   'serialNo': '3108606433',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036055000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8870,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036089000},
  {'id': 11365275,
   'stuName': '杨子涵',
   'serialNo': '3108607729',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8894,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036154000},
  {'id': 11365243,
   'stuName': '符唐骏',
   'serialNo': '3108614209',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035795000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8862,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035802000},
  {'id': 11365263,
   'stuName': '位云馨',
   'serialNo': '3108633697',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8882,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None},
  {'id': 11365266,
   'stuName': '吴琳楠',
   'serialNo': '3108635073',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036323000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8885,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036316000},
  {'id': 11365272,
   'stuName': '杨丰瑞',
   'serialNo': '3108650865',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776036330000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8891,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776036322000},
  {'id': 11365254,
   'stuName': '庞雨橦',
   'serialNo': '3108679985',
   'gradeId': 126,
   'classId': 474,
   'startTime': 1776035795000,
   'endTime': None,
   'intoState': 1,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8873,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': 1776035786000},
  {'id': 11365264,
   'stuName': '魏本杨',
   'serialNo': '3108682001',
   'gradeId': 126,
   'classId': 474,
   'startTime': None,
   'endTime': None,
   'intoState': None,
   'boarder': 2,
   'attendDate': 1776009600000,
   'stuId': 8883,
   'teamId': 119,
   'lockTime': None,
   'gateTime': None,
   'gateStartTime': None}]}
In [ ]:
attendDate: "2026-04-13"
classRoom: "2510"
color: "#FB923C"
courseName: "26学部1班-班会"
serial: "第9节"
serialnum: "9"
status: "下节课"
teaName: "马靖"
timeSlot: "16:20-17:00"
Reference in New Issue View Git Blame Copy Permalink