import pandas as pd
import requests
# from module import F6_module
import time
from tqdm import tqdm
from pathlib import Path

# f6_module = F6_module()

# # 1.向服务器发送请求登录
# username = "13799889725"
# password = "Lc1234"
# store_name = "禹城榕桦"
# module = 2

# res = f6_module.login_in(username, password, store_name)
# cookies = requests.utils.dict_from_cookiejar(res.cookies)

cookies = {
    'memberSESSIONID': '38d027b4-1f86-44fe-a8d2-2211fbd46394',
    'erpLanguage': 'zh-CN',
    'tmall': 'false',
    'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1775553704,1775799422,1776043595,1776153876',
    'HMACCOUNT': 'A6A0585E8C70051D',
    'prodOrg': '11240984669918128522',
    'unp': '15851362811188895763',
    'un': '15851362811188895763',
    '_up': '-NillNN-qyBEJ--t3vnSknvoOF53yPCOts8N0no-Uu9VX_TGoZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_UXoIgm0QIF_PBRv-ZNHu3M-GTc1p2wFnGqpuxUiOMSmF_GORVsrEj92RzBn7rDYmA.',
    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2215851362811188895763%22%2C%22first_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%7D',
    'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1776393475',
}


print(cookies)  # 登录获取cookies
all_data =  []
operateOrgId = cookies['prodOrg']
url = "https://yunxiu.f6car.cn/member/car/carListForPermission"  # 获取客户车辆信息列表
header = {
    'Referer': 'https://yunxiu.f6car.cn/erp/view/index.html',
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 Edg/130.0.0.0'
}
data = {"pageSize": 100, "pageNo": 1}  # 根据需求修改
res = requests.post(url=url, cookies=cookies, json=data, headers=header)  # 注意需要用json发送数据
total = res.json().get('data').get('total')
total = int(total)
all_page = int(total / 100) + 1

for i in tqdm(range(1, all_page)):
    data = {"pageSize": 100, "pageNo": i}  # 根据需求修改
    res = requests.post(url=url, cookies=cookies, json=data, headers=header)  # 注意需要用json发送数据
    data1 = res.json()
    for item in data1['data']['data']:
        carId = item['tmCarInfo']['pkId']
        customerId = item['tmCustomerInfo']['pkId']
        car_number = item['tmCarInfo']['carPrefix']+item['tmCarInfo']['carNo']
        all_data.append([carId, customerId, car_number])
    time.sleep(2)
df = pd.DataFrame(all_data, columns=['carId', 'customerId', 'car_number'])
output_path = "D:\Idea Project\F6+宜搭+其它(1)\张阳脚本\文件输出\车辆信息.xlsx"
df.to_excel(output_path, index=False)
print("已保存：", str(output_path))