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

# === 计算距离今天 19:00 还有多少秒 ===
now = datetime.datetime.now()
target_time = now.replace(hour=19, minute=0, second=0, microsecond=0)



org_name = "烟台福泰汽车服务有限公司"

df = pd.read_excel(fr"C:\Users\zy187\Desktop\钉钉文件\项目停用模板(1).xlsx", dtype=str, sheet_name=0)
type_ = 1  # 1 停用 0启用

cookies = {
    'f6-ids-goodsSESSIONID': '6467304f-1c3f-45d2-8828-55cc59be8a38',
    'erpLanguage': 'zh-CN',
    'tmall': 'false',
    'prodOrg': '11240984669918398632',
    'unp': '16023822438009700402',
    '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_z_KFss8B0HM_Wu5aVvHFp5vQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqEvUQqIsl0wYO-vZRv-ZNHu3M-GTf3pqyHXWqqu5diesTl1bDOhNtrEj9nkS68c_kNhc.',
    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216023822438009700402%22%2C%22first_id%22%3A%2219a48e066e68e2-067b1e693596828-4c657b58-2073600-19a48e066e71500%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%2219a48e066e68e2-067b1e693596828-4c657b58-2073600-19a48e066e71500%22%7D',
}

# 2.获取门店id
params = {
    'currentPage': '1',
    'pageSize': '10',
    'name': '',
}

response = requests.get(
    'https://yunxiu.f6car.cn/hive/org/getPageOrgGroupMembers',
    params=params,
    cookies=cookies,
)

total = response.json().get("data", {}).get("total", "")
all_page = total // 10 + 1
org_id = ""
all_org_list = []
for page in tqdm(range(1, all_page + 1)):
    params['currentPage'] = str(page)
    response = requests.get(
        'https://yunxiu.f6car.cn/hive/org/getPageOrgGroupMembers',
        params=params,
        cookies=cookies,
    )
    org_list = response.json().get("data", {}).get("list", [])

    for item in org_list:
        if item.get("orgName") == org_name:
            org_id = item.get("orgId")
            break

# 获取项目信息
json_data = {
    'param': '',
    'name': '',
    'customCode': '',
    'currentPage': 1,
    'pageSize': 100,
    'isDel': 0,
    'customInvoiceCategory': 0,
    'idOwnOrg': org_id,
}

response = requests.post(
    'https://ids-goods.f6car.cn/f6-ids-goods/service/getServiceList',
    cookies=cookies,
    json=json_data,
)
all_project_list = []
total_pages = response.json().get("data", {}).get("totalPages", "")
for page in tqdm(range(1, total_pages + 1)):
    json_data['currentPage'] = str(page)
    response = requests.post(
        'https://ids-goods.f6car.cn/f6-ids-goods/service/getServiceList',
        cookies=cookies,
        json=json_data,
    )
    project_list = response.json().get("data", {}).get("records", [])
    all_project_list.extend(project_list)

code_list = df.iloc[:, 0].dropna().astype(str).tolist()
res_data_list =[]
for item in tqdm(all_project_list):
    custom_code = item.get("customCode")
    if not custom_code or str(custom_code) not in code_list or not code_list:
        continue
    info_id = item.get("infoId")
    pk_id = item.get("pkId")
    json_data = {
        "orgIdList": [
            org_id,
        ],
        "isDel": type_,  # 1 停用 0启用
        "infoId": info_id,
        "pkId": pk_id,
        "type": 1,
        "idOwnOrg": org_id
    }

    response = requests.post(
        'https://ids-goods.f6car.cn/f6-ids-goods/service/editAttributeByType',
        cookies=cookies,
        json=json_data,
    )
    try:
        res_data_list.append(response.json())
    except:
        print(response.text)
        pass
df21 = pd.DataFrame(res_data_list)
df21.to_excel(r"C:\Users\zy187\Desktop\钉钉文件\项目停用结果1.xlsx")