import pandas as pd
import requests
from module import F6_module
import time
from tqdm import tqdm

f6_module = F6_module()

# 1.向服务器发送请求登录

# username = "13799889725"
# password = "Lc1234"
# store_name = "禹城榕桦"
module = 1
#
# res = f6_module.login_in(username, password, store_name)
# cookies = requests.utils.dict_from_cookiejar(res.cookies)

cookies = {
    'memberSESSIONID': 'cce3f82e-5045-4e35-970b-cd87a306af28',
    'erpLanguage': 'zh-CN',
    'tmall': 'false',
    'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1767076493,1767159563,1767170190',
    'HMACCOUNT': 'A6A0585E8C70051D',
    'prodOrg': '16016206505644687368',
    'unp': '16016206509084016646',
    'un': '16016206509084016646',
    '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_zPePsMsA03I_UuNdV_fHo5_QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqEvQVrosh1QML_PFRv-ZNHu3M-GTf3pm3F3euq-1cieMekFfFOBdprEj92By99srnNxc.',
    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216016206509084016646%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': '1767170321',
}

print(cookies)  # 登录获取cookies
all_data = []
# 客户信息删除
if module == 1:
    url = "https://yunxiu.f6car.cn/member/customer/listForPermission?pageSize=30000&pageNo=1"  # 获取客户信息列表
    res = requests.get(url, cookies=cookies)
    data = res.json()
    # print(data)
    print(len(data['data']['data']))
    for item in tqdm(data['data']['data']):
        try:
            idCustomer = item['idCustomer']
            phone = item['cellPhone']
            url = f"https://yunxiu.f6car.cn/member/customer/{idCustomer}"  # 客户信息删除url
            res = requests.delete(url, cookies=cookies)  # 客户信息删除
            print(res.json(), idCustomer, phone)
            all_data.append([res.json(), idCustomer, phone])

            from datetime import datetime
            now = datetime.now()
            if  now.hour >= 20 or now.hour < 8:
                time.sleep(1.5)
            else:
                time.sleep(5)

        except:
            idCustomer = item['idCustomer']
            phone = item['cellPhone']
            print("删除失败：", res.json, idCustomer, phone)


# 客户车辆信息删除
if module == 2:
    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": 1000, "pageNo": 1}  # 根据需求修改

    res = requests.post(url=url, cookies=cookies, json=data, headers=header)  # 注意需要用json发送数据
    data = res.json()

    # print(data)
    for item in tqdm(data['data']['data']):
        try:
            carId = item['tmCarInfo']['pkId']
            customerId = item['tmCustomerInfo']['pkId']
            url =f"https://yunxiu.f6car.cn/member/car/deleteCar/{carId}/{customerId}"
            # url = f"https://yunxiu.f6car.cn/macan/coupon/car/batchRemove?customerId={customerId}&carId={carId}&operateOrgId={operateOrgId}"  # 删除客户车辆信息url
            res = requests.delete(url, cookies=cookies)  # 客户车辆信息删除
            print("删除成功：", res.json, customerId, carId)
            time.sleep(5)
        except:
            carId = item['tmCarInfo']['pkId']
            customerId = item['tmCustomerInfo']['pkId']
            print("删除失败：", res.json, customerId, operateOrgId)

df = pd.DataFrame(all_data)
df.to_excel("客户信息删除明细.xlsx")