{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "92f27fd2",
   "metadata": {},
   "source": [
    "管理后台-使用统计"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "679fdcc5",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<>:60: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:60: SyntaxWarning: invalid escape sequence '\\I'\n",
      "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_25140\\3645530864.py:60: SyntaxWarning: invalid escape sequence '\\I'\n",
      "  df.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\人员使用记录.csv\")\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "\n",
    "cookies = {\n",
    "    'fx-lang': 'zh_cn',\n",
    "    'auth_token': 's%3A.9uztgExtmqUJXHCi00hv9SGq6eVYSvH%2BxQSwrox1Yls',\n",
    "    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2257956c24ceedab0c48c17b4e%22%2C%22first_id%22%3A%2219b6dd1a10c148a-063e3a033b10ed-4c657b58-2073600-19b6dd1a10d145b%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%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMTliNmRkMWExMGMxNDhhLTA2M2UzYTAzM2IxMGVkLTRjNjU3YjU4LTIwNzM2MDAtMTliNmRkMWExMGQxNDViIiwiJGlkZW50aXR5X2xvZ2luX2lkIjoiNTc5NTZjMjRjZWVkYWIwYzQ4YzE3YjRlIn0%3D%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%24identity_login_id%22%2C%22value%22%3A%2257956c24ceedab0c48c17b4e%22%7D%7D',\n",
    "    '_csrf': 's%3A_D_KxBikFhOaA2gkTYpORFF6.AqupOk5Q%2B7GUjR1bKbiQLAXksxGmkcsVthKkDYiBQRE',\n",
    "    'Hm_lvt_de47dd1629940fe88b02865de93dd9fe': '1770176033,1770257492,1770281854,1770359422',\n",
    "    'HMACCOUNT': 'A6A0585E8C70051D',\n",
    "    'Hm_lpvt_de47dd1629940fe88b02865de93dd9fe': '1770600610',\n",
    "    'GSuvNKHqfvX2r6v7P8HkZv2bow': 's%3ANKEleTNCioVWeMitYN3WOVYYmCXbGFB0.qD1J8obD4MP4FNXKiVimB2UWfI2g3Nm%2FFOuYEmdeQek',\n",
    "    'JDY_SID': 's%3Aar54WVlu4J-OyZzN0zEvAOU_FgbWMSvc.nCgiElAa2EoL3zf2gCIUV4XCFBE6aF6fsodt4%2F1daj4',\n",
    "    'acw_tc': '743e76f717706025725901488e72f65ae43f08af57c9b931c35df2a672f5ff',\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",
    "    'content-type': 'application/json',\n",
    "    'origin': 'https://www.jiandaoyun.com',\n",
    "    'priority': 'u=1, i',\n",
    "    'referer': 'https://www.jiandaoyun.com/product/usage_statistics',\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",
    "    '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-csrf-token': 'V3tEncMi-0KtoUAbnjwbKp66GsbVQMEL4bAc',\n",
    "    'x-jdy-ver': '10.17.2',\n",
    "    'x-request-id': 'c16157d6-0b12-4bf2-b56c-6858f66831e1',\n",
    "    # 'cookie': 'fx-lang=zh_cn; auth_token=s%3A.9uztgExtmqUJXHCi00hv9SGq6eVYSvH%2BxQSwrox1Yls; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2257956c24ceedab0c48c17b4e%22%2C%22first_id%22%3A%2219b6dd1a10c148a-063e3a033b10ed-4c657b58-2073600-19b6dd1a10d145b%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%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMTliNmRkMWExMGMxNDhhLTA2M2UzYTAzM2IxMGVkLTRjNjU3YjU4LTIwNzM2MDAtMTliNmRkMWExMGQxNDViIiwiJGlkZW50aXR5X2xvZ2luX2lkIjoiNTc5NTZjMjRjZWVkYWIwYzQ4YzE3YjRlIn0%3D%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%24identity_login_id%22%2C%22value%22%3A%2257956c24ceedab0c48c17b4e%22%7D%7D; _csrf=s%3A_D_KxBikFhOaA2gkTYpORFF6.AqupOk5Q%2B7GUjR1bKbiQLAXksxGmkcsVthKkDYiBQRE; Hm_lvt_de47dd1629940fe88b02865de93dd9fe=1770176033,1770257492,1770281854,1770359422; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_de47dd1629940fe88b02865de93dd9fe=1770600610; GSuvNKHqfvX2r6v7P8HkZv2bow=s%3ANKEleTNCioVWeMitYN3WOVYYmCXbGFB0.qD1J8obD4MP4FNXKiVimB2UWfI2g3Nm%2FFOuYEmdeQek; JDY_SID=s%3Aar54WVlu4J-OyZzN0zEvAOU_FgbWMSvc.nCgiElAa2EoL3zf2gCIUV4XCFBE6aF6fsodt4%2F1daj4; acw_tc=743e76f717706025725901488e72f65ae43f08af57c9b931c35df2a672f5ff',\n",
    "}\n",
    "\n",
    "json_data = {\n",
    "    'from': None,\n",
    "    'to': None,\n",
    "    'granularity': 'daily',\n",
    "    'members': [],\n",
    "    'has_count': False,\n",
    "    'sort': {},\n",
    "    'limit': 50,\n",
    "    'skip': 0,\n",
    "}\n",
    "all_data_list = []\n",
    "for i in range(0,28):\n",
    "    json_data[\"skip\"] = i*50\n",
    "    response = requests.post(\n",
    "        'https://www.jiandaoyun.com/corp/activity/user_user_metrics',\n",
    "        cookies=cookies,\n",
    "        headers=headers,\n",
    "        json=json_data,\n",
    "    )\n",
    "\n",
    "    data_list = response.json().get(\"data\",[])\n",
    "    all_data_list.extend(data_list)\n",
    "df = pd.DataFrame(all_data_list)\n",
    "df.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(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
}