{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import json\n",
    "import xlrd\n",
    "from pprint import pprint\n",
    "cookies_str = 'sl-session=PflzbKB+XmYmcInyxiECYw==; SESSION=01bcddbd-ffe6-44cc-a87b-c01a7a23782b; token=26e2f66c-8c13-4d2d-b08b-e8edbf2cccea; timestamp=1717382436108; ciphers=HydZaYAbYfX'\n",
    "\n",
    "cookies_str = cookies_str.encode('utf-8').decode('latin-1')\n",
    "\n",
    "cookie_dict = {item.split('=')[0]: item.split('=')[1]\n",
    "               for item in cookies_str.split('; ')}\n",
    "\n",
    "headers = {\n",
    "    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36',\n",
    "    \"Content-Type\": \"application/json\",\n",
    "    'origin': 'http://app.hexieqiche.com.cn'\n",
    "}\n",
    "ID=[]\n",
    "for i in range(1,59):\n",
    "    json={\n",
    "  \"assign_insuranceUserID\": \"\",\n",
    "  \"assign_managerUserID\": \"\",\n",
    "  \"assign_serveUserID\": \"\",\n",
    "  \"cityID\": \"\",\n",
    "  \"customerCar\": \"\",\n",
    "  \"customerCode\": \"\",\n",
    "  \"customerName\": \"\",\n",
    "  \"isCompany\": [],\n",
    "  \"isMember\": [],\n",
    "  \"phone\": \"\",\n",
    "  \"provinceID\": \"\",\n",
    "  \"storeIds\": [\n",
    "    \"6\"\n",
    "  ],\n",
    "  \"typeID\": [],\n",
    "  \"forPage\": {\n",
    "    \"curPage\": i,\n",
    "    \"pageSize\": 100\n",
    "  }\n",
    "}\n",
    "    url = 'http://app.hexieqiche.com.cn/crm/customer/info/queryCustomerList'\n",
    "    res = requests.post(url,cookies=cookie_dict,headers=headers,json=json)\n",
    "    strele = res.json()\n",
    "\n",
    "    for a in range(0,strele['body']['pageSize']):\n",
    "        try:\n",
    "          try:\n",
    "            for c in range(0,len(strele['body']['data'][a]['carList'])):\n",
    "              MX={}\n",
    "              MX['客户编号']=strele['body']['data'][a]['customerCode']\n",
    "              MX['客户名称']=strele['body']['data'][a]['customerName']\n",
    "              MX['客户性质']=strele['body']['data'][a]['isCompanyName']\n",
    "              MX['客户类型']=strele['body']['data'][a]['typeName']\n",
    "              MX['是否会员']=strele['body']['data'][a]['isMemberName']\n",
    "              MX['手机号']=strele['body']['data'][a]['phone']\n",
    "              MX['客户来源']=strele['body']['data'][a]['sourceName']\n",
    "              MX['assign_managerUserName']=strele['body']['data'][a]['assign_managerUserName']\n",
    "              MX['assign_serveUserName']=strele['body']['data'][a]['assign_serveUserName']\n",
    "              MX['assign_insuranceUserName']=strele['body']['data'][a]['assign_insuranceUserName']\n",
    "              MX['wx_nickname']=strele['body']['data'][a]['wx_nickname']\n",
    "              MX['lastServData']=strele['body']['data'][a]['lastServData']\n",
    "              MX['车辆']=strele['body']['data'][a]['carList'][c]['carNumber']\n",
    "              MX['车型']=strele['body']['data'][a]['carList'][c]['vehicleName']\n",
    "              ID.append(MX)\n",
    "          except:\n",
    "              MX={}\n",
    "              MX['客户编号']=strele['body']['data'][a]['customerCode']\n",
    "              MX['客户名称']=strele['body']['data'][a]['customerName']\n",
    "              MX['客户性质']=strele['body']['data'][a]['isCompanyName']\n",
    "              MX['客户类型']=strele['body']['data'][a]['typeName']\n",
    "              MX['是否会员']=strele['body']['data'][a]['isMemberName']\n",
    "              MX['手机号']=strele['body']['data'][a]['phone']\n",
    "              MX['客户来源']=strele['body']['data'][a]['sourceName']\n",
    "              MX['assign_managerUserName']=strele['body']['data'][a]['assign_managerUserName']\n",
    "              MX['assign_serveUserName']=strele['body']['data'][a]['assign_serveUserName']\n",
    "              MX['assign_insuranceUserName']=strele['body']['data'][a]['assign_insuranceUserName']\n",
    "              MX['wx_nickname']=strele['body']['data'][a]['wx_nickname']\n",
    "              MX['lastServData']=strele['body']['data'][a]['lastServData']\n",
    "              ID.append(MX)\n",
    "        except:\n",
    "           print(\"1\")\n",
    "df=pd.DataFrame(ID)\n",
    "df.to_excel(r'C:\\Users\\admin\\Desktop\\客户车辆信息.xlsx',index=False)\n"
   ]
  }
 ],
 "metadata": {
  "language_info": {
   "name": "python"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}