{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\_distributor_init.py:30: UserWarning: loaded more than 1 DLL from .libs:\n",
      "c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\.libs\\libopenblas.EL2C6PLE4ZYW3ECEVIV3OXXGRN2NRFM2.gfortran-win_amd64.dll\n",
      "c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\.libs\\libopenblas64__v0.3.21-gcc_10_3_0.dll\n",
      "  warnings.warn(\"loaded more than 1 DLL from .libs:\"\n",
      "<ipython-input-1-66fb43067687>:45: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n",
      "  df_list.to_excel(r'C:\\Users\\admin\\Desktop\\打印单模板{}.xlsx'.format(data_time))\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import time\n",
    "\n",
    "session = requests.Session()\n",
    "login_url = 'https://print.f6yc.com/print-server/template/getTemplate?clsId=&tempCode=&tempName=&currentPage=1&pageSize=100'\n",
    "\n",
    "headers = {\n",
    "    'Accept':'application/json, text/plain, */*',\n",
    "    'Accept-Encoding':'gzip, deflate, br, zstd',\n",
    "    'Accept-Language':'zh-CN,zh;q=0.9',\n",
    "    'Authorization':'Basic NjAyMzg6Q3dAMzQwODI2',\n",
    "    'Cache-Control':'no-cache',\n",
    "    'Cookie':'print-serverSESSIONID=fV0OqIJhtIhjaZD2Way9jN7FkvCnJP63o8p924DT; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%222268275546837446%22%2C%22first_id%22%3A%221753edeb75a603-0155d23aa05675-3d634f03-1327104-1753edeb75b347%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%221753edeb75a603-0155d23aa05675-3d634f03-1327104-1753edeb75b347%22%7D',\n",
    "    'Pragma':'no-cache',\n",
    "    'Referer':'https://print.f6yc.com/print-server/ui/index.html',\n",
    "    'Sec-Ch-Ua':'\"Chromium\";v=\"122\", \"Not(A:Brand\";v=\"24\", \"Google Chrome\";v=\"122\"',\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/122.0.0.0 Safari/537.36'\n",
    "}\n",
    "\n",
    "response = session.get(login_url,headers=headers)\n",
    "response = response.json()\n",
    "total = response['data']['total'] //100 + 2\n",
    "ALL_DATA_service = []\n",
    "for i in range(1,total):\n",
    "    login_url = 'https://print.f6yc.com/print-server/template/getTemplate?clsId=&tempCode=&tempName=&currentPage='+ str(i) +'&pageSize=100'\n",
    "    form_data = session.get(login_url,headers=headers)\n",
    "    form_data = form_data.json()\n",
    "    for data in form_data.get('data').get('list'):\n",
    "        list = {\n",
    "            'rowId': data['rowId'],\n",
    "            'tempName': data['tempName'],\n",
    "            'tempCode': data['tempCode']\n",
    "        }\n",
    "        # print(i,list)\n",
    "        ALL_DATA_service.append(list)\n",
    "df_list = pd.DataFrame(ALL_DATA_service)\n",
    "data_time = time.strftime(\"%Y-%m-%d %H:%M:%S\", time.localtime())\n",
    "data_time = data_time.replace(':', '-')\n",
    "df_list.to_excel(r'C:\\Users\\admin\\Desktop\\打印单模板{}.xlsx'.format(data_time))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "F6processing",
   "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.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}