{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1d6ee92fe567f117",
   "metadata": {},
   "source": [
    "客户积分批量修改\n",
    "\n",
    "单次删除10w，流失客户获取不到"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "initial_id",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2026-02-03T09:06:58.436025100Z",
     "start_time": "2026-02-03T08:57:47.208909600Z"
    },
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<>:69: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:69: SyntaxWarning: invalid escape sequence '\\I'\n",
      "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\3588797330.py:69: SyntaxWarning: invalid escape sequence '\\I'\n",
      "  ndf.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州积分客户信息-核销后1.csv\")\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "b4f414e134b043f9a434e99bef7d02b2",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/260 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import requests\n",
    "from tqdm.notebook import tqdm\n",
    "import time\n",
    "import random\n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "\n",
    "cookies = {\n",
    "    'memberSESSIONID': '627f27b2-8154-4338-874a-46afde892d0c',\n",
    "    'erpLanguage': 'zh-CN',\n",
    "    'prodOrg': '16075672590915518520',\n",
    "    'unp': '16075954693997641815',\n",
    "    'un': '16075954693997641815',\n",
    "    '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.',\n",
    "    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216075954693997641815%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',\n",
    "    'tmall': 'false',\n",
    "    'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1779688780,1779850114,1779930850,1780295117',\n",
    "    'HMACCOUNT': 'A6A0585E8C70051D',\n",
    "    'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1780295119',\n",
    "}\n",
    "\n",
    "headers = {\n",
    "    'accept': 'application/json, text/plain, */*',\n",
    "    'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
    "    'priority': 'u=1, i',\n",
    "    'referer': 'https://yunxiu.f6car.cn/erp/view/index.html',\n",
    "    'sec-ch-ua': '\"Chromium\";v=\"148\", \"Microsoft Edge\";v=\"148\", \"Not/A)Brand\";v=\"99\"',\n",
    "    'sec-ch-ua-mobile': '?0',\n",
    "    'sec-ch-ua-platform': '\"Windows\"',\n",
    "    'sec-fetch-dest': 'empty',\n",
    "    'sec-fetch-mode': 'cors',\n",
    "    'sec-fetch-site': 'same-origin',\n",
    "    'traceparent': '00-120737cdb75f4501b4a4f5bd52e129b1-38dff64dce81188c-01',\n",
    "    'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&df337affccae4a26b03e3455a05a5522&uid_nli6u6uor4pqvx0f',\n",
    "    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0',\n",
    "    'x-requested-with': 'XMLHttpRequest',\n",
    "    # 'cookie': 'memberSESSIONID=627f27b2-8154-4338-874a-46afde892d0c; erpLanguage=zh-CN; prodOrg=16075672590915518520; unp=16075954693997641815; un=16075954693997641815; _up=-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2216075954693997641815%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; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1779688780,1779850114,1779930850,1780295117; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1780295119',\n",
    "}\n",
    "\n",
    "params = {\n",
    "    'pageSize': '100',\n",
    "    'pageNo': '1',\n",
    "}\n",
    "\n",
    "response = requests.get(\n",
    "    'https://yunxiu.f6car.cn/member/customer/listForPermission',\n",
    "    params=params,\n",
    "    cookies=cookies,\n",
    "    headers=headers,\n",
    ")\n",
    "total = int(response.json()['data'][\"total\"])\n",
    "total_page = total // 100 + 1\n",
    "all_data = []\n",
    "for i in tqdm(range(total_page)):\n",
    "    params['pageNo'] = str(i + 1)\n",
    "    response = requests.get(\n",
    "        'https://yunxiu.f6car.cn/member/customer/listForPermission',\n",
    "        params=params,\n",
    "        cookies=cookies,\n",
    "        headers=headers,\n",
    "    )\n",
    "    reslut_list = response.json().get('data').get(\"data\")\n",
    "    all_data.extend(reslut_list)\n",
    "    time.sleep(0.5)\n",
    "\n",
    "ndf = pd.DataFrame(all_data)\n",
    "ndf.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州积分客户信息-核销后1.csv\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "76040d3d6324dd44",
   "metadata": {},
   "source": [
    "处理"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "2897c87161a88d58",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2026-02-04T02:52:50.187746100Z",
     "start_time": "2026-02-04T02:52:20.274151Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<>:63: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:65: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:63: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:65: SyntaxWarning: invalid escape sequence '\\I'\n",
      "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\2161723813.py:63: SyntaxWarning: invalid escape sequence '\\I'\n",
      "  df2.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户信息结果2.csv\")\n",
      "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\2161723813.py:65: SyntaxWarning: invalid escape sequence '\\I'\n",
      "  df3.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户报错信息2.csv\")\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "33af6707c9b14461a11a0c33de5ed5c8",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/10 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424976126067', '100000']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424971932047', '100000']\n",
      "[{'success': False, 'code': 0, 'message': '充值失败，该客户未开启积分', 'data': None}, '12185724343350776493', '2767']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343342388224', '100000']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '100000']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424976126067', '70841']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424971932047', '13874']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343342388224', '99707']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '21874']\n",
      "[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '100000']\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from tqdm.notebook import tqdm\n",
    "import time\n",
    "import random\n",
    "\n",
    "cookies = {\n",
    "    'memberSESSIONID': '627f27b2-8154-4338-874a-46afde892d0c',\n",
    "    'erpLanguage': 'zh-CN',\n",
    "    'prodOrg': '16075672590915518520',\n",
    "    'unp': '16075954693997641815',\n",
    "    'un': '16075954693997641815',\n",
    "    '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.',\n",
    "    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216075954693997641815%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',\n",
    "    'tmall': 'false',\n",
    "    'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1779688780,1779850114,1779930850,1780295117',\n",
    "    'HMACCOUNT': 'A6A0585E8C70051D',\n",
    "    'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1780295119',\n",
    "}\n",
    "\n",
    "headers = {\n",
    "    'accept': 'application/json, text/plain, */*',\n",
    "    'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
    "    'priority': 'u=1, i',\n",
    "    'referer': 'https://yunxiu.f6car.cn/erp/view/index.html',\n",
    "    'sec-ch-ua': '\"Chromium\";v=\"148\", \"Microsoft Edge\";v=\"148\", \"Not/A)Brand\";v=\"99\"',\n",
    "    'sec-ch-ua-mobile': '?0',\n",
    "    'sec-ch-ua-platform': '\"Windows\"',\n",
    "    'sec-fetch-dest': 'empty',\n",
    "    'sec-fetch-mode': 'cors',\n",
    "    'sec-fetch-site': 'same-origin',\n",
    "    'traceparent': '00-120737cdb75f4501b4a4f5bd52e129b1-38dff64dce81188c-01',\n",
    "    'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&df337affccae4a26b03e3455a05a5522&uid_nli6u6uor4pqvx0f',\n",
    "    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0',\n",
    "    'x-requested-with': 'XMLHttpRequest',\n",
    "    # 'cookie': 'memberSESSIONID=627f27b2-8154-4338-874a-46afde892d0c; erpLanguage=zh-CN; prodOrg=16075672590915518520; unp=16075954693997641815; un=16075954693997641815; _up=-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2216075954693997641815%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; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1779688780,1779850114,1779930850,1780295117; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1780295119',\n",
    "}\n",
    "\n",
    "\n",
    "df = pd.read_excel(fr\"C:\\Users\\hp_z66\\Desktop\\万州积分客户信息-核销后.xlsx\", sheet_name=\"最终处理\").astype(str)\n",
    "all_result_list =[]\n",
    "error_list = []\n",
    "for index, row in tqdm(df.iterrows(),total = len(df)):\n",
    "    time.sleep(random.randint(2, 4))\n",
    "    try:\n",
    "        json_data = {\n",
    "            'customerId': row[\"客户id\"],\n",
    "            'points': row['扣除'],\n",
    "            'remark': '',\n",
    "            'remarkDetail': '',\n",
    "        }\n",
    "        response1 = requests.post('https://yunxiu.f6car.cn/member/customer/points/deduct', cookies=cookies, headers=headers,json=json_data)\n",
    "        result = response1.json()\n",
    "        all_result_list.append([result,row[\"客户id\"],row['扣除']])\n",
    "        print([result,row[\"客户id\"],row['扣除']])\n",
    "        \n",
    "    except Exception as e :\n",
    "        print(f\"报错信息：{[result,row[\"客户id\"],row['扣除']]}\")\n",
    "        error_list.append([result,row[\"客户id\"],row['扣除']])\n",
    "\n",
    "\n",
    "df2 = pd.DataFrame(all_result_list)\n",
    "df2.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户信息结果2.csv\")\n",
    "df3 = pd.DataFrame(error_list)\n",
    "df3.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户报错信息2.csv\")\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "2fa5ba9202d993f5",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2026-02-04T02:49:20.745998Z",
     "start_time": "2026-02-04T02:49:20.329441300Z"
    }
   },
   "outputs": [],
   "source": [
    "df2 = pd.DataFrame(all_result_list)\n",
    "df2.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分客户信息结果7.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0ca6cea6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 查询积分变动记录"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "544faa3e120e5392",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2026-02-03T09:38:32.709008600Z",
     "start_time": "2026-02-03T09:38:32.287577Z"
    }
   },
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "b2e91d697cbe4bb9a2befaf402a25d39",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/81 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from tqdm.notebook import tqdm\n",
    "import time\n",
    "\n",
    "cookies = {\n",
    "    'memberSESSIONID': '8fda24b1-43e8-46b7-8e81-44725f8fefee',\n",
    "    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2210546443563961904423%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',\n",
    "    'erpLanguage': 'zh-CN',\n",
    "    'prodOrg': '10546443563960461203',\n",
    "    'unp': '10546443563961904423',\n",
    "    'un': '10546443563961904423',\n",
    "    '_up': '-NillNN-qyBEJ--t3vnSknvoOFt6yfeJtM4A1Xg2XOZUVvXFpZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_MVro4n0gIO_vVRv-ZNHu3M-GTZ25y3EXOrq-tWgO0bmVbHOhFsrEj9_kC5lLD6QRM.',\n",
    "    'tmall': 'false',\n",
    "    'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1769756586,1770022080,1770168808,1770175549',\n",
    "    'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1770175549',\n",
    "    'HMACCOUNT': 'A6A0585E8C70051D',\n",
    "}\n",
    "\n",
    "headers = {\n",
    "    'accept': 'application/json, text/plain, */*',\n",
    "    'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
    "    'priority': 'u=1, i',\n",
    "    'referer': 'https://yunxiu.f6car.cn/erp/view/index.html',\n",
    "    'sec-ch-ua': '\"Not(A:Brand\";v=\"8\", \"Chromium\";v=\"144\", \"Microsoft Edge\";v=\"144\"',\n",
    "    'sec-ch-ua-mobile': '?0',\n",
    "    'sec-ch-ua-platform': '\"Windows\"',\n",
    "    'sec-fetch-dest': 'empty',\n",
    "    'sec-fetch-mode': 'cors',\n",
    "    'sec-fetch-site': 'same-origin',\n",
    "    'traceparent': '00-57bb9b2437e844d1a9f370a0e8596ac2-053ca2ed20f7b0a1-01',\n",
    "    'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&c40a72c0393a4383be840fdfd4066b3c&uid_nli6u6uor4pqvx0f',\n",
    "    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0',\n",
    "    'x-requested-with': 'XMLHttpRequest',\n",
    "    # 'cookie': 'memberSESSIONID=8fda24b1-43e8-46b7-8e81-44725f8fefee; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2210546443563961904423%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; erpLanguage=zh-CN; prodOrg=10546443563960461203; unp=10546443563961904423; un=10546443563961904423; _up=-NillNN-qyBEJ--t3vnSknvoOFt6yfeJtM4A1Xg2XOZUVvXFpZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_MVro4n0gIO_vVRv-ZNHu3M-GTZ25y3EXOrq-tWgO0bmVbHOhFsrEj9_kC5lLD6QRM.; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1769756586,1770022080,1770168808,1770175549; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1770175549; HMACCOUNT=A6A0585E8C70051D',\n",
    "}\n",
    "\n",
    "df = pd.read_excel(fr\"C:\\Users\\hp_z66\\Desktop\\钉钉文件\\客户信息.xlsx\", sheet_name=\"验证\").astype(str)\n",
    "info_list =[]\n",
    "error_list = []\n",
    "for index,row in tqdm(df.iterrows(),total = len(df)):\n",
    "    try:\n",
    "        params = {\n",
    "            'customerId': row[\"客户id\"],\n",
    "            'pageNo': '1',\n",
    "            'pageSize': '10',\n",
    "        }\n",
    "\n",
    "        response = requests.get(\n",
    "            'https://yunxiu.f6car.cn/member/customer/points/charge/history',\n",
    "            params=params,\n",
    "            cookies=cookies,\n",
    "            headers=headers,\n",
    "        )\n",
    "        info = response.json().get(\"data\").get(\"data\",[])\n",
    "        info_list.extend(info)\n",
    "        time.sleep(0.5)\n",
    "    except:\n",
    "        print(f\"失败：{response.json()}\")\n",
    "        error_list.append([response.json(),row[\"客户id\"]])\n",
    "\n",
    "df5 = pd.DataFrame(info_list)\n",
    "df5.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分明细2.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "cca9de41",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "df5 = pd.DataFrame(info_list)\n",
    "df5.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分明细1.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "F6+宜搭+其它",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.13.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}