Files
python----/智慧校园/同文下发老师 copy.ipynb
2025-10-20 12:32:18 +08:00

24 KiB

In [ ]:
infos = [
    {
        "room": "2101",
        "names": []
    },
    {
        "room": "2105",
        "names": [
            {
                "username": "李伟杰",
                "bandNo": "3470371521"
            }
        ]
    },
    {
        "room": "2106",
        "names": []
    },
    {
        "room": "2107",
        "names": [
            {
                "username": "王菁婵",
                "bandNo": "3478823249"
            }
        ]
    },
    {
        "room": "2108",
        "names": [
            {
                "username": "陈曦",
                "bandNo": "3469732433"
            }
        ]
    },
    {
        "room": "2109",
        "names": []
    },
    {
        "room": "2110",
        "names": []
    },
    {
        "room": "2111",
        "names": []
    },
    {
        "room": "2112",
        "names": [
            {
                "username": "田力豪",
                "bandNo": "3479278081"
            }
        ]
    },
    {
        "room": "2113",
        "names": [
            {
                "username": "段静远",
                "bandNo": "3470462129"
            }
        ]
    },
    {
        "room": "2114",
        "names": [
            {
                "username": "王佳",
                "bandNo": "3470399841"
            }
        ]
    },
    {
        "room": "2115",
        "names": []
    },
    {
        "room": "2116",
        "names": []
    },
    {
        "room": "2201",
        "names": []
    },
    {
        "room": "2202",
        "names": []
    },
    {
        "room": "2203",
        "names": []
    },
    {
        "room": "2204",
        "names": [
            {
                "username": "易建军",
                "bandNo": "3470323953"
            },
            {
                "username": "王佳",
                "bandNo": "3470399841"
            },
            {
                "username": "田力豪",
                "bandNo": "3479278081"
            },
            {
                "username": "段静远",
                "bandNo": "3470462129"
            }
        ]
    },
    {
        "room": "2205",
        "names": [
            {
                "username": "罗星琪",
                "bandNo": "3469625873"
            }
        ]
    },
    {
        "room": "2206",
        "names": [
            {
                "username": "张桃",
                "bandNo": "3470463665"
            }
        ]
    },
    {
        "room": "2207",
        "names": [
            {
                "username": "陈小林",
                "bandNo": "3478087713"
            },
            {
                "username": "金秀",
                "bandNo": "3479319313"
            },
            {
                "username": "刘钰",
                "bandNo": "3478899473"
            },
            {
                "username": "张瑜",
                "bandNo": "3469876433"
            }
        ]
    },
    {
        "room": "2208",
        "names": [
            {
                "username": "王永久",
                "bandNo": "3478934433"
            },
            {
                "username": "韦晨曦",
                "bandNo": "3479368753"
            },
            {
                "username": "袁为明",
                "bandNo": "3469688737"
            },
            {
                "username": "黄怡岚",
                "bandNo": "3469796657"
            },
            {
                "username": "李莉",
                "bandNo": "3478812529"
            },
            {
                "username": "唐晓丽",
                "bandNo": "3474320001"
            }
        ]
    },
    {
        "room": "2209",
        "names": []
    },
    {
        "room": "2210",
        "names": []
    },
    {
        "room": "2211",
        "names": []
    },
    {
        "room": "2212",
        "names": []
    },
    {
        "room": "2213",
        "names": []
    },
    {
        "room": "2214",
        "names": []
    },
    {
        "room": "2215",
        "names": []
    },
    {
        "room": "2216",
        "names": []
    },
    {
        "room": "2217",
        "names": []
    },
    {
        "room": "2301",
        "names": [
            {
                "username": "李华",
                "bandNo": "3470049553"
            }
        ]
    },
    {
        "room": "2302",
        "names": [
            {
                "username": "张琼丹",
                "bandNo": "3470175681"
            }
        ]
    },
    {
        "room": "2303",
        "names": [
            {
                "username": "唐艳",
                "bandNo": "3478260977"
            }
        ]
    },
    {
        "room": "2304",
        "names": []
    },
    {
        "room": "2305",
        "names": [
            {
                "username": "黄敏",
                "bandNo": "3478295185"
            }
        ]
    },
    {
        "room": "2306",
        "names": [
            {
                "username": "张敬之",
                "bandNo": "3470058945"
            }
        ]
    },
    {
        "room": "2307",
        "names": [
            {
                "username": "唐文凯",
                "bandNo": "3478926993"
            }
        ]
    },
    {
        "room": "2308",
        "names": [
            {
                "username": "曾伟宏",
                "bandNo": "3478292849"
            }
        ]
    },
    {
        "room": "2309",
        "names": [
            {
                "username": "杨莉",
                "bandNo": "3479187969"
            }
        ]
    },
    {
        "room": "2310",
        "names": [
            {
                "username": "姚瑶",
                "bandNo": "3470453105"
            }
        ]
    },
    {
        "room": "2311",
        "names": [
            {
                "username": "贾琼",
                "bandNo": "3479277169"
            }
        ]
    },
    {
        "room": "2312",
        "names": [
            {
                "username": "董湘蓉",
                "bandNo": "3470450737"
            }
        ]
    },
    {
        "room": "2313",
        "names": [
            {
                "username": "薛燕",
                "bandNo": "3469743921"
            }
        ]
    },
    {
        "room": "2314",
        "names": [
            {
                "username": "张丽平",
                "bandNo": "3470021249"
            }
        ]
    },
    {
        "room": "2315",
        "names": [
            {
                "username": "刘杰",
                "bandNo": "3478769761"
            }
        ]
    },
    {
        "room": "2316",
        "names": [
            {
                "username": "唐光辉",
                "bandNo": "3479121729"
            }
        ]
    },
    {
        "room": "2317",
        "names": [
            {
                "username": "杨晓伟",
                "bandNo": "3478134817"
            }
        ]
    },
    {
        "room": "2401",
        "names": [
            {
                "username": "张启容",
                "bandNo": "3469575377"
            }
        ]
    },
    {
        "room": "2402",
        "names": [
            {
                "username": "闫满琳",
                "bandNo": "3478920081"
            }
        ]
    },
    {
        "room": "2403",
        "names": [
            {
                "username": "贺蕾",
                "bandNo": "3479268465"
            }
        ]
    },
    {
        "room": "2404",
        "names": [
            {
                "username": "刘志坚",
                "bandNo": "3478320321"
            },
            {
                "username": "唐文凯",
                "bandNo": "3478926993"
            },
            {
                "username": "董怡",
                "bandNo": "3479118689"
            },
            {
                "username": "黄黠",
                "bandNo": "3469699089"
            },
            {
                "username": "叶顺刚",
                "bandNo": "3470150801"
            }
        ]
    },
    {
        "room": "2405",
        "names": [
            {
                "username": "韩金金",
                "bandNo": "3479331137"
            }
        ]
    },
    {
        "room": "2406",
        "names": [
            {
                "username": "王建军",
                "bandNo": "3469848993"
            }
        ]
    },
    {
        "room": "2407",
        "names": [
            {
                "username": "张明惠",
                "bandNo": "3470455681"
            }
        ]
    },
    {
        "room": "2408",
        "names": []
    },
    {
        "room": "2409",
        "names": []
    },
    {
        "room": "2410",
        "names": []
    },
    {
        "room": "2411",
        "names": []
    },
    {
        "room": "2412",
        "names": [
            {
                "username": "唐廷凤",
                "bandNo": "3478379537"
            }
        ]
    },
    {
        "room": "2413",
        "names": [
            {
                "username": "吴杰",
                "bandNo": "3470379953"
            }
        ]
    },
    {
        "room": "2414",
        "names": [
            {
                "username": "马靖",
                "bandNo": "3469775921"
            }
        ]
    },
    {
        "room": "2415",
        "names": [
            {
                "username": "文仕宇",
                "bandNo": "3479296977"
            }
        ]
    },
    {
        "room": "2416",
        "names": [
            {
                "username": "庄秋雨",
                "bandNo": "3478905073"
            }
        ]
    },
    {
        "room": "2417",
        "names": [
            {
                "username": "王德琳",
                "bandNo": "3479320897"
            }
        ]
    },
    {
        "room": "2501",
        "names": []
    },
    {
        "room": "2502",
        "names": []
    },
    {
        "room": "2503",
        "names": []
    },
    {
        "room": "2504",
        "names": [
            {
                "username": "舒勇",
                "bandNo": "3478913041"
            },
            {
                "username": "张洪春",
                "bandNo": "3470118433"
            },
            {
                "username": "周黎",
                "bandNo": "3478843745"
            },
            {
                "username": "黎锐",
                "bandNo": "3470453105"
            },
            {
                "username": "刘本章",
                "bandNo": "3478294225"
            },
            {
                "username": "蒲秀娟",
                "bandNo": "3478914385"
            }
        ]
    },
    {
        "room": "2505",
        "names": []
    },
    {
        "room": "2506",
        "names": []
    },
    {
        "room": "2507",
        "names": []
    },
    {
        "room": "2508",
        "names": []
    },
    {
        "room": "2509",
        "names": [
            {
                "username": "任学丽",
                "bandNo": "3470402273"
            },
            {
                "username": "张春玲",
                "bandNo": "3469575809"
            },
            {
                "username": "张荣华",
                "bandNo": "3469720401"
            },
            {
                "username": "周琼英",
                "bandNo": "3470480753"
            }
        ]
    },
    {
        "room": "2510",
        "names": []
    },
    {
        "room": "2511",
        "names": []
    },
    {
        "room": "2512",
        "names": []
    },
    {
        "room": "2513",
        "names": []
    },
    {
        "room": "2514",
        "names": []
    },
    {
        "room": "2515",
        "names": []
    },
    {
        "room": "2516",
        "names": []
    },
    {
        "room": "2517",
        "names": []
    }
]
In [1]:
from requests import get,post
import time
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 [10]:
data = get(f"https://band.hxzhxy.cn/door/lock/listLockPage?teamId=119&pageSize=60&pageNumber=0&value=&areaId=&tierId=&regionId=&bindType=&lockName=&type=2&mainTypeId=&sizeType=&lockType=&access_token={token}").json()
In [11]:
import time
In [ ]:
for item in data["data"]["content"]:
    addAdminBand = "3478926993"
    post("https://band.hxzhxy.cn/door/accredit/sendNews",json={
        "startTime":"25082114","endTime":"35051814","adminType":"55","type":"01","time":[1755756984314,2071380076000],"accountIp":"183.220.92.213","accountName":"183.220.92.213","lockNo":item["lockNo"],"serialNo":item["serialNo"],"addAdminBand":addAdminBand,"addUserBand":"","removeBand":"","doorAccreditIds":""
    },headers=header,proxies={"http": "http://127.0.0.1:8080", "https": "http://127.0.0.1:8080"},verify=False)
    time.sleep(1)
            
In [12]:
import tqdm
In [31]:
data = get(f"https://band.hxzhxy.cn/door/lock/listLockPage?teamId=119&pageSize=60&pageNumber=0&value=&areaId=&tierId=&regionId=&bindType=&lockName=&type=2&mainTypeId=&sizeType=&lockType=&access_token={token}").json()
with tqdm.tqdm(total=len(data["data"]["content"])) as pbar:
    for item in data["data"]["content"]:
        if item["password"] == "12345687" or item["password"]==None: 
            pbar.update(1)
            continue
        post("https://band.hxzhxy.cn/door/password/send",json={"lockNos":item["lockNo"],"serialNos":item["serialNo"],"password":"12345687","type":"04","typeSend":"0","accountIp":"183.220.91.181","accountName":"183.220.91.181","account":"5789"},headers=header)
        time.sleep(7)
        pbar.update(1)
100%|██████████| 52/52 [00:07<00:00,  7.22it/s]
In [33]:
data = get(f"https://band.hxzhxy.cn/door/lock/listLockPage?teamId=119&pageSize=60&pageNumber=0&value=&areaId=&tierId=&regionId=&bindType=&lockName=&type=2&mainTypeId=&sizeType=&lockType=&access_token={token}").json()
for item in data["data"]["content"]:
    if item["password"] != "12345687" and item["password"]!=None:
        print(item)
        print(item['password'])
{'bandUserCount': 0, 'lockNo': '181681774855', 'teamId': 119, 'electric': 100, 'tierName': '5', 'doorName': '2512前门', 'ID': 723, 'lockType': 2, 'remark': None, 'mainType': '教室', 'type': '', 'password': '88888888', 'bandAdminCount': 4, 'remask': None, 'alias': '教学楼3-2门锁网关', 'createTime': 1755314698000, 'dongId': 28, 'genre': None, 'gateType': 1, 'dongName': '1栋', 'lockName': '2512前门', 'roomName': '2512', 'image': None, 'sizeType': 1, 'isPassword': 1, 'regionName': '无', 'areaId': 20, 'updateTime': None, 'version': None, 'serialNo': '868002345684074', 'opsTime': None, 'teamName': '2512', 'tierId': 64, 'doorId': 747, 'areaName': '教学楼', 'batteryType': None}
88888888
In [9]:
len("Xpaotongshutongwenzhongxue971001")
Out [9]:
32
In [ ]:
泡桐树同文