import pandas as pd
import requests
from tqdm import tqdm
from module import F6_module
import time
from http.cookies import SimpleCookie

# f6_module = F6_module()
# username = "18742526670"
# password = "Zy18742526670"
# store_name = "F6汽车科技数据组测试（废弃）"
# brandNmae = "恒泰20" # 品牌名称
#
# res = f6_module.login_in(username,password)


def parse_cookie_string(cookie_str):
    cookie = SimpleCookie()
    cookie.load(cookie_str)
    return {k: v.value for k, v in cookie.items()}


cookies = "camaroSESSIONID=a3f9a309-cdbf-4ada-9afd-9fedbbf5a611; erpLanguage=zh-CN; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1772617481,1772846629,1773129610,1773900258; HMACCOUNT=A6A0585E8C70051D; prodOrg=11240984669917749532; unp=15671257394116059163; un=15671257394116059163; _up=-NillNN-qyBEJ--t3vnSknvoOF55yvCPtcoG2n8-W-FdU_jAoZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_AdqIsi0QoL__BRv-ZNHu3M-GTc2J-wF3KvreRRiOockFPKPxVsrEj94Xz8q7jyNhY.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2215671257394116059163%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=1773910193"

cookies_dict = parse_cookie_string(cookies)
df = pd.read_excel(fr"C:\Users\hp_z66\Downloads\品牌 (1).xlsx",sheet_name=0)
for index,row in tqdm(df.iterrows()):
    brandNmae = row["品牌名"]
    # cookies = requests.utils.dict_from_cookiejar(cookies)
    # print(cookies) # 检查是否登录成功
    url1 = 'https://yunxiu.f6car.cn/camaro/brand/getOrCreate' # 更新品牌url
    data = {"brandName":f"{brandNmae}"} 
    res1 = requests.post(url=url1,cookies=cookies_dict,json=data)
    print(res1.json())