{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# 批量获取chookies + idownorg" ] }, { "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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "Login success\n", "双鸭山凯华凯天汽车销售服务有限公司\n", "11240984669917940016 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPCLs8kM2n03We5bVvXDrpDQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi1AsK_vNRv-ZNHu3M-GTc2ZGwE3Ssp-RTgegTllbHPBpmrEj9mhnuo8CyPWI.', 'prodOrg': '11240984669917948019', 'unp': '15791634996839604299', 'un': '15791634996839604299', 'f6sid': '73a7db81-3d32-4425-8318-aea52163f8d2'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华凯通汽车销售服务有限公司\n", "11240984669917939018 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPCLs8gH13M9Wu9ZUvDCoJrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0wII-_ZRv-ZNHu3M-GTc2ZGwE3StrOldi-sSlFLCPRRsrEj9nF_FgrruXWE.', 'prodOrg': '11240984669917947021', 'unp': '15791635248208441373', 'un': '15791635248208441373', 'f6sid': '7629a902-6c66-4eb0-aef1-8df1eb977e90'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华凯信汽车销售服务有限公司\n", "11240984669917940017 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPCLs8gA03s_WOFdUPHJrpnQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0wcO_flRv-ZNHu3M-GTc2ZGwE3Stq-1ViekckFDDNhpvrEj9mByw98m1Nik.', 'prodOrg': '11240984669917948020', 'unp': '15791635500026060890', 'un': '15791635500026060890', 'f6sid': '33480589-b9aa-484a-9df9-e0a4d43a17bd'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华运通汽车销售服务有限公司\n", "11240984669917938517 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPCLs8sF03g7XuBeX_nFo5_QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0wQM_vFRv-ZNHu3M-GTc2ZGwE3Suru1Wje8dk1_LOhdprEj9_R_ekMm5MGI.', 'prodOrg': '11240984669917946520', 'unp': '15791636003447398446', 'un': '15791636003447398446', 'f6sid': '5205711c-5e55-468c-a092-be91b9c34ce2'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华凯达汽车销售服务有限公司\n", "11240984669917939048 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsM0E2ng_XeBaVvPGpZHQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0woL__BRv-ZNHu3M-GTc2ZGzF3eor-RWiewdl1bBORFnrEj9nh_99cq3MmA.', 'prodOrg': '11240984669917947051', 'unp': '15792200193077702728', 'un': '15792200193077702728', 'f6sid': 'dad214da-2657-4887-a1e4-12b8e5a11010'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯天(别克)汽车销售服务有限公司\n", "11240984669917940547 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMkE13s8Xu5aXvHBpZnQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0gEJ_vlRv-ZNHu3M-GTc2ZGzF3esr-lViu8Tl17DPhFvrEj9k2bSrZ7RMmg.', 'prodOrg': '11240984669917948551', 'unp': '15792204140349780020', 'un': '15792204140349780020', 'f6sid': '8bd3e9d2-b98c-4b09-8a20-9bd18773b639'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "鹤岗凯天汽车销售服务有限公司\n", "11240984669917938537 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMkA23w-XOdYX_fEo53QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0gYN__BRv-ZNHu3M-GTc2ZGzF3esq-VSiO0alV_FOxdrrEj9nRy7_a25QAY.', 'prodOrg': '11240984669917946541', 'unp': '15792204587160596544', 'un': '15792204587160596544', 'f6sid': '90251f40-c276-4cba-88aa-851b530d1d7e'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "鹤岗凯华凯达汽车销售服务有限公司\n", "11240984669917941042 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMkM0nM4XOVfUPfHrp7QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0gQF_PJRv-ZNHu3M-GTc2ZGzF3esp-xdju0YklDFOBporEj9mGq_85e2Nj8.', 'prodOrg': '11240984669917949042', 'unp': '15792204918762266697', 'un': '15792204918762266697', 'f6sid': 'd79d2403-1e95-4eef-a193-dfb33af8debd'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯华凯立汽车销售服务有限公司\n", "11240984669917938538 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMgH03s3WeRZVvXIoZvQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0QMJ9_ZRv-ZNHu3M-GTc2ZGzF3etrO1VgegZlFbHNxVtrEj90mm_9s3VSGc.', 'prodOrg': '11240984669917946542', 'unp': '15792205200833404962', 'un': '15792205200833404962', 'f6sid': 'd925310a-24b5-4750-96b3-02bbf09d95a6'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯市郊区埃安汽车销售服务有限公司\n", "11240984669917940041 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMgB1nw_WOJbXvbHpJ3QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0QAO-_RRv-ZNHu3M-GTc2ZGzF3etquhSiekfll7EOBBrrEj9mEq8oMmxNGc.', 'prodOrg': '11240984669917948044', 'unp': '15792205457025687634', 'un': '15792205457025687634', 'f6sid': 'd1b59ce8-4b9e-4521-80de-c7bd2d722711'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华凯立汽车销售服务有限公司\n", "11240984669917939050 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMgN2385X-JUU_DIo5vQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0QUM_vRRv-ZNHu3M-GTc2ZGzF3etpuVRj-4fmVPCNxdtrEj95hS9846xPCs.', 'prodOrg': '11240984669917947053', 'unp': '15792205884655951942', 'un': '15792205884655951942', 'f6sid': 'f86974a1-1fd8-4b65-a22e-c6bf7794f65b'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山凯华凯腾汽车销售服务有限公司\n", "11240984669917940042 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMsF2nw8WeVeVfXHpZnQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0QsK-fBRv-ZNHu3M-GTc2ZGzF3euruRSiugYk1XHOBFvrEj9kx24j8-0PWc.', 'prodOrg': '11240984669917948045', 'unp': '15792206097332334620', 'un': '15792206097332334620', 'f6sid': '5144c2c6-195d-4d69-b8a3-9b70abc87334'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "鹤岗凯华运通汽车销售服务有限公司\n", "11240984669917940548 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMsG03w5XeFbXvHDopvQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0AIJ_vRRv-ZNHu3M-GTc2ZGzF3eure1Sj-wcll7DPBZtrEj9mR-9nLzhPB4.', 'prodOrg': '11240984669917948552', 'unp': '15792206307676680252', 'un': '15792206307676680252', 'f6sid': '4b8b0073-fba0-44b0-8ab9-b61cf93e8a91'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "牡丹江佰佳汽车销售服务有限公司\n", "11240984669917938539 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMsB23g8WuNaUPbFrpDQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0AcO-fhRv-ZNHu3M-GTc2ZGzF3euquVWiusel1DEOhpmrEj9n0ex_crIMmg.', 'prodOrg': '11240984669917946543', 'unp': '15792206483304767499', 'un': '15792206483304767499', 'f6sid': '05191af9-a274-401b-b30f-6e55a9f894e5'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "鹤岗凯立汽车销售服务有限公司\n", "11240984669917940549 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMsD13M2X-NbV_LJpJzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0AUF__dRv-ZNHu3M-GTc2ZGzF3euqOldgO4ellfANhBqrEj9mEjMrInFMyU.', 'prodOrg': '11240984669917948553', 'unp': '15792206648954613835', 'un': '15792206648954613835', 'f6sid': '029a8f01-85fa-4be1-aee7-7500b2923e08'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "双鸭山华通丰田汽车销售服务有限公司\n", "11240984669917940552 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMsN1H04W-BVX_jJoZvQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi0AoK_PFRv-ZNHu3M-GTc2ZGzF3eupupTjuodmF_KNhVtrEj9m3W9qMDJN2U.', 'prodOrg': '11240984669917948556', 'unp': '15792206876717899862', 'un': '15792206876717899862', 'f6sid': 'a67155ab-de6c-4212-9448-634babfab703'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "鹤岗凯华凯信汽车销售服务有限公司\n", "11240984669917940553 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMoF13k9WOJcVfjGrpzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3wEI-PVRv-ZNHu3M-GTc2ZGzF3evrulXi-kfkVXKORpqrEj9-hXE8ZbMPWc.', 'prodOrg': '11240984669917948557', 'unp': '15792207042225139795', 'un': '15792207042225139795', 'f6sid': '837c577b-866e-4168-8af4-cfe17672d770'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯华新通汽车销售服务有限公司\n", "11240984669917941043 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPOPsMoH03o8U-NaXvPCp5nQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3wYM9_ZRv-ZNHu3M-GTc2ZGzF3evrO1UiuIel17BPRNvrEj9mh3EqMC2NQk.', 'prodOrg': '11240984669917949043', 'unp': '15792207201394782300', 'un': '15792207201394782300', 'f6sid': '2f31780d-0832-4d40-a39d-fca675b88723'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯上汽通用凯迪拉克汽车服务有限公司\n", "11240984669917941551 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPWNsM4D0384XeReVvPCo5_QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3wQE-_hRv-ZNHu3M-GTc2ZG1FXerqO1RjuwZk1bBPRdprEj9yWS-rsmySWY.', 'prodOrg': '11240984669917949553', 'unp': '15794003604773302346', 'un': '15794003604773302346', 'f6sid': 'b272cc28-4ce3-4b92-9b58-f3a9cfa53799'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯通(雪佛兰)汽车销售服务有限公司\n", "11240984669917953518 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF54xPiOuMkG0ns-UuZYU_PAopjQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3gMK-fVRv-ZNHu3M-GTc2ZG4Fn-srexViOMblVPBPxZurEj9832xjsjBNSU.', 'prodOrg': '11240984669917961518', 'unp': '15799384310181552151', 'un': '15799384310181552151', 'f6sid': '7c01436a-96fe-461a-b0b4-be4244d8c94e'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯华凯信捷途汽车销售服务有限公司\n", "11240984669917968092 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF53zfeFs88G2302U-5bV_DFoJnQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3gAP_vlRv-ZNHu3M-GTc1pi3HXSqreVTgOITllfCOhRvrEj95FrE883GMWI.', 'prodOrg': '11240984669917976092', 'unp': '15806832386999611470', 'un': '15806832386999611470', 'f6sid': 'a703680c-8bd0-475b-a6ce-1da8771f9782'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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" ] }, { "name": "stdout", "output_type": "stream", "text": [ "佳木斯凯华运通汽车销售服务有限公司\n", "11240984669917939017 cookies {'_up': '-NillNN-qyBEJ--t3vnSknvoOF53z_OLs80G0Xk_UuJVUvbApZ3QjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqFfsTroIi3gUO-vBRv-ZNHu3M-GTc1pqzE3Sore9XieMfmFLEPxFrrEj9mGve96i0PCg.', 'prodOrg': '11240984669917947017', 'unp': '15822630322085847124', 'un': '15822630322085847124', 'f6sid': 'bb01e022-ff97-4c3f-bf45-220dbb1b404b'}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ ":225: 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 PySimpleGUI as sg\n", "import pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "import hashlib\n", "def F6_login(user, psw):\n", " \"\"\" 函数功能：\n", " 使用账号，密码登录 F6 系统\n", " 返回：Response\n", " \"\"\"\n", " LOGIN_URL = \"https://yunxiu.f6car.cn/kzf6/login/confirm\"\n", " session = requests.session()\n", " header = {\n", " 'Referer': LOGIN_URL,\n", " 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) Chrome/89.0.4389.82'\n", " }\n", "\n", " data = {\n", " 'username': user,\n", " 'password': hashlib.md5(psw.encode('utf-8')).hexdigest(),\n", " }\n", "\n", " resp = session.post(url=LOGIN_URL, headers=header, data=data)\n", " if resp.status_code == requests.codes.ok:\n", " # print('redirect url:', resp.url)\n", " # cookie = requests.utils.dict_from_cookiejar(session.cookies)\n", " # print('cookie',cookie)\n", " # session.cookies.save(ignore_discard=True, ignore_expires=True)\n", "\n", " # if canRedirect(BaseUrl):\n", " # print(\"Login success\")\n", " print(\"Login success\")\n", " # print(resp)\n", " return resp\n", "# 登录按钮被点击\n", "UseStoreInfo = True # 客户车辆信息CHECK 预设值变更\n", "ACCOUNT = '18246149255'\n", "PSW = 'xbc921027.'\n", "if not ACCOUNT or not PSW:\n", " sg.popup_error(\"警告:请先输入账号与密码!\")\n", "else:\n", " # 输入了账号和密码,验证是否能正常登录\n", " res_login = F6_login(ACCOUNT, PSW)\n", " login_res = res_login.json()\n", " if login_res.get('status') != 'success':\n", " sg.popup_error(login_res.get('message'))\n", " \n", " else:\n", " # 账号密码正确，将账号密码保存在本地\n", " lst_groups = login_res.get('data')\n", " if lst_groups:\n", " # 多公司，则需要选择公司\n", " LOGIN_token = login_res.get('token')\n", " # window['-F6 Group Selected-'].update(visible=True)\n", " # window['-F6 Group Selected-'].update(disabled=False)\n", " # window['-F6 Group Selected-'].update(values=[item.get('groupName') for item in lst_groups])\n", " for item in lst_groups:\n", " print(item.get('groupName'))\n", " # 当选择了公司\n", " selectedOrgName = item.get('groupName')\n", " selectedOrgID = [item.get('groupId') for item in lst_groups if item.get('groupName') == selectedOrgName][0]\n", "\n", " group_res = requests.get(f'https://yunxiu.f6car.cn/kzf6/user/loginAfterChooseGroup?token={LOGIN_token}&groupId={selectedOrgID}&macAddress=')\n", " cookies = requests.utils.dict_from_cookiejar(group_res.cookies)\n", "\n", " # 判断 cookies 信息是否有效\n", " queryCarApi = 'https://yunxiu.f6car.cn/member/car/carListForPermission'\n", "\n", " payload = {\"keyWord\": \"陕J45649\", \"pageSize\": 10, \"pageNo\": 1} # keyWord 可以是车牌号也可以是VIN码\n", "\n", " res_t = requests.post(queryCarApi, json=payload, cookies=cookies)\n", " try:\n", " res_t.json()\n", "\n", " except json.JSONDecodeError as e:\n", " print('cookie 失效')\n", " res_t_new = 1 # 错误预警次数\n", " if res_t_new > 10:\n", " res_t_new = res_t_new + 1\n", " login_res = F6_login(ACCOUNT, PSW).json()\n", " lst_groups = login_res.get('data')\n", " LOGIN_token = login_res.get('token')\n", " selectedOrgName = item.get('groupName')\n", " selectedOrgID = [item.get('groupId') for item in lst_groups if item.get('groupName') == selectedOrgName][0]\n", " group_res = requests.get(f'https://yunxiu.f6car.cn/kzf6/user/loginAfterChooseGroup?token={LOGIN_token}&groupId={selectedOrgID}&macAddress=')\n", " cookies = requests.utils.dict_from_cookiejar(group_res.cookies)\n", " queryCarApi = 'https://yunxiu.f6car.cn/member/car/carListForPermission'\n", "\n", " payload = {\"keyWord\": \"陕J45649\", \"pageSize\": 10, \"pageNo\": 1} # keyWord 可以是车牌号也可以是VIN码\n", "\n", " res_t = requests.post(queryCarApi, json=payload, cookies=cookies)\n", " try:\n", " res_t.json()\n", " except json.JSONDecodeError as e:\n", " print('cookie 失效')\n", " else:\n", " print('cookie 失效')\n", "\n", " print(item.get('groupId'),'cookies',cookies)\n", " cookie_dict = cookies\n", " \n", " data = {\n", " \"company_ids\": [11240984669917330614, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917938517, 11240984669917938537, 11240984669917938538, 11240984669917938539, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917939018, 11240984669917939048, 11240984669917939050, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917940016, 11240984669917940017, 11240984669917940041, 11240984669917940042, 11240984669917939017, 11240984669917939017, 11240984669917939017, 11240984669917940547, 11240984669917940548, 11240984669917940549, 11240984669917940552, 11240984669917940553, 11240984669917941042, 11240984669917941043, 11240984669917941551, 11240984669917953518, 11240984669917968092],\n", " \"store_ids\": [11240984669917337118, 11240984669917946517, 11240984669917946518, 11240984669917946519, 11240984669917946520, 11240984669917946541, 11240984669917946542, 11240984669917946543, 11240984669917947017, 11240984669917947018, 11240984669917947019, 11240984669917947020, 11240984669917947051, 11240984669917947053, 11240984669917947517, 11240984669917947518, 11240984669917948016, 11240984669917948017, 11240984669917948018, 11240984669917948019, 11240984669917948020, 11240984669917948044, 11240984669917948045, 11240984669917948516, 11240984669917948517, 11240984669917948518, 11240984669917948551, 11240984669917948552, 11240984669917948553, 11240984669917948556, 11240984669917948557, 11240984669917949042, 11240984669917949043, 11240984669917949553, 11240984669917961518, 11240984669917976092]\n", " }\n", "\n", " company_id = int(item.get('groupId'))\n", " index = data[\"company_ids\"].index(company_id)\n", " store_id = data[\"store_ids\"][index]\n", " idOwnOrg = store_id\n", "\n", " # import pandas as pd\n", " # import time\n", " # import requests\n", " # import json\n", " # import openpyxl\n", " # session = requests.Session()\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;charset=UTF-8\",\n", " # }\n", " # url = 'https://yunxiu.f6car.cn/maintain/repair/getBusinessCategoryList'\n", " # ALL_DATA_service = []\n", " # res = requests.get(url,cookies=cookie_dict,headers=headers)\n", " # res = res.json()\n", " # for data in res['data']:\n", " # list = {\n", " # 'groupName': item.get('groupName'),\n", " # 'maintainType': data['maintainType']\n", " # }\n", " \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))\n", " # time.sleep(2)\n", "\n", " # import pandas as pd\n", " # import time\n", " # import requests\n", " # import json\n", " # import openpyxl\n", " # session = requests.Session()\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;charset=UTF-8\",\n", " # }\n", " # url = 'https://yunxiu.f6car.cn/blazer/financial/otherPayment/getPageOtherPaymentList'\n", " # data = {\n", " # \"pageSize\": 10,\n", " # \"currentPage\": 1,\n", " # \"orgList\": [\n", " # idOwnOrg\n", " # ],\n", " # \"beginDate\": \"2024-03-19\",\n", " # \"endDate\": \"2024-06-17\",\n", " # \"isDeleted\": \"0\",\n", " # \"idOwnOrgs\": [\n", " # idOwnOrg\n", " # ],\n", " # \"tmall\": 'false'\n", " # }\n", " # ALL_DATA_service = []\n", " # res = requests.post(url,cookies=cookie_dict,headers=headers,json=data)\n", " # res = res.json()\n", " # for data in res['info']['businessType']['QTS']:\n", " # list = {\n", " # 'groupName': item.get('groupName'),\n", " # 'name': data['name']\n", " # }\n", " \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))\n", " # time.sleep(2)\n", "\n", "\n", " import pandas as pd\n", " import time\n", " import requests\n", " import json\n", " import openpyxl\n", " session = requests.Session()\n", "\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;charset=UTF-8\",\n", " }\n", " url = 'https://yunxiu.f6car.cn/blazer/financial/otherPayment/getPageOtherPaymentList'\n", " data = {\n", " \"pageSize\": 10,\n", " \"currentPage\": 1,\n", " \"orgList\": [\n", " idOwnOrg\n", " ],\n", " \"beginDate\": \"2024-03-19\",\n", " \"endDate\": \"2024-06-17\",\n", " \"isDeleted\": \"0\",\n", " \"idOwnOrgs\": [\n", " idOwnOrg\n", " ],\n", " \"tmall\": 'false'\n", " }\n", " ALL_DATA_service = []\n", " res = requests.post(url,cookies=cookie_dict,headers=headers,json=data)\n", " res = res.json()\n", " for data in res['info']['businessType']['QTZ']:\n", " list = {\n", " 'groupName': item.get('groupName'),\n", " 'name': data['name']\n", " }\n", " \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))\n", " time.sleep(2)\n", "\n", "\n", " # import pandas as pd\n", " # import time\n", " # import requests\n", " # import json\n", " # import openpyxl\n", " # session = requests.Session()\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;charset=UTF-8\",\n", " # }\n", " # url = 'https://ids-goods.f6car.cn/f6-ids-goods/part/category/initPage?idOwnOrg=' + str(idOwnOrg)\n", " # ALL_DATA_service = []\n", " # res = requests.get(url,cookies=cookie_dict,headers=headers)\n", " # res = res.json()\n", " # for data in res['data']['categoryList'][0]['nodes']:\n", " # for data_two in data['nodes']:\n", " # list = {\n", " # 'groupName': item.get('groupName'),\n", " # 'name': data['name'],\n", " # 'name_text': data_two['name']\n", " # }\n", " \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))\n", " # time.sleep(2)\n", "\n", " # import pandas as pd\n", " # import time\n", " # import requests\n", " # import json\n", " # import openpyxl\n", " # session = requests.Session()\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;charset=UTF-8\",\n", " # }\n", " # url = 'https://yunxiu.f6car.cn/kzf6/vipSet/getCardTemplateListForLayUI.do?currentPage=1&pageSize=200&idOwnOrgList=' + str(idOwnOrg)\n", " # ALL_DATA_service = []\n", " # res = requests.get(url,cookies=cookie_dict,headers=headers)\n", " # res = res.json()\n", " # for data in res['data']:\n", " # list = {\n", " # 'groupName': item.get('groupName'),\n", " # 'cardTypeName': data['cardTypeName'],\n", " # 'name': data['name'],\n", " # 'isEnable': data['isEnable']\n", " # }\n", "\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))\n", " # time.sleep(2)\n", "\n", "\n", " # import pandas as pd\n", " # import time\n", " # import requests\n", " # import json\n", " # import openpyxl\n", " # session = requests.Session()\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;charset=UTF-8\",\n", " # }\n", " # url = 'https://yunxiu.f6car.cn/hive/employee/queryPageList?currentPage=1&pageSize=100&isDel=0&userStatus=&roleId=&defaultOrgId=¶m='\n", " # ALL_DATA_service = []\n", " # res = requests.get(url,cookies=cookie_dict,headers=headers)\n", " # res = res.json()\n", " # for data in res['data']['list']:\n", " # list = {\n", " # 'groupName': item.get('groupName'),\n", " # 'cellPhone': data['cellPhone'],\n", " # 'name': data['name'],\n", " # 'positionNameStr': data['positionNameStr'],\n", " # 'roleNameListStr': data['roleNameListStr'],\n", " # 'userStatus': data['userStatus']\n", " # }\n", "\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))\n", " # time.sleep(2)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 业务分类" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":32: 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 pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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", "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;charset=UTF-8\",\n", "}\n", "url = 'https://yunxiu.f6car.cn/maintain/repair/getBusinessCategoryList'\n", "ALL_DATA_service = []\n", "res = requests.get(url,cookies=cookie_dict,headers=headers)\n", "res = res.json()\n", "for data in res['data']:\n", " list = {\n", " 'idOwnOrg': data['idOwnOrg'],\n", " 'maintainType': data['maintainType']\n", " }\n", " \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))\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 其他收入分类" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":44: 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 pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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", "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;charset=UTF-8\",\n", "}\n", "url = 'https://yunxiu.f6car.cn/blazer/financial/otherPayment/getPageOtherPaymentList'\n", "data = {\n", " \"pageSize\": 10,\n", " \"currentPage\": 1,\n", " \"orgList\": [\n", " idOwnOrg\n", " ],\n", " \"beginDate\": \"2024-03-19\",\n", " \"endDate\": \"2024-06-17\",\n", " \"isDeleted\": \"0\",\n", " \"idOwnOrgs\": [\n", " idOwnOrg\n", " ],\n", " \"tmall\": 'false'\n", "}\n", "ALL_DATA_service = []\n", "res = requests.post(url,cookies=cookie_dict,headers=headers,json=data)\n", "res = res.json()\n", "for data in res['info']['businessType']['QTS']:\n", " list = {\n", " 'idOwnOrg': idOwnOrg,\n", " 'name': data['name']\n", " }\n", " \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))\n" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":44: 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 pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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", "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;charset=UTF-8\",\n", "}\n", "url = 'https://yunxiu.f6car.cn/blazer/financial/otherPayment/getPageOtherPaymentList'\n", "data = {\n", " \"pageSize\": 10,\n", " \"currentPage\": 1,\n", " \"orgList\": [\n", " idOwnOrg\n", " ],\n", " \"beginDate\": \"2024-03-19\",\n", " \"endDate\": \"2024-06-17\",\n", " \"isDeleted\": \"0\",\n", " \"idOwnOrgs\": [\n", " idOwnOrg\n", " ],\n", " \"tmall\": 'false'\n", "}\n", "ALL_DATA_service = []\n", "res = requests.post(url,cookies=cookie_dict,headers=headers,json=data)\n", "res = res.json()\n", "for data in res['info']['businessType']['QTZ']:\n", " list = {\n", " 'idOwnOrg': idOwnOrg,\n", " 'name': data['name']\n", " }\n", " \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))\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 材料分类" ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":32: 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 pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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", "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;charset=UTF-8\",\n", "}\n", "url = 'https://ids-goods.f6car.cn/f6-ids-goods/part/category/initPage?idOwnOrg=' + idOwnOrg\n", "ALL_DATA_service = []\n", "res = requests.get(url,cookies=cookie_dict,headers=headers)\n", "res = res.json()\n", "for data in res['data']['categoryList'][0]['nodes']:\n", " for data_two in data['nodes']:\n", " list = {\n", " 'idOwnOrg': idOwnOrg,\n", " 'name': data['name'],\n", " 'name_text': data_two['name']\n", " }\n", " \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))\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 卡模板" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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", "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;charset=UTF-8\",\n", "}\n", "url = 'https://yunxiu.f6car.cn/kzf6/vipSet/getCardTemplateListForLayUI.do?currentPage=1&pageSize=200&idOwnOrgList=' + idOwnOrg\n", "ALL_DATA_service = []\n", "res = requests.get(url,cookies=cookie_dict,headers=headers)\n", "res = res.json()\n", "for data in res['data']:\n", " list = {\n", " 'idOwnOrg': idOwnOrg,\n", " 'cardTypeName': data['cardTypeName'],\n", " 'name': data['name'],\n", " 'isEnable': data_two['isEnable']\n", " }\n", "\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))\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 员工信息" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import time\n", "import requests\n", "import json\n", "import openpyxl\n", "session = requests.Session()\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;charset=UTF-8\",\n", "}\n", "url = 'https://yunxiu.f6car.cn/hive/employee/queryPageList?currentPage=1&pageSize=100&isDel=0&userStatus=&roleId=&defaultOrgId=¶m=' + str(idOwnOrg)\n", "ALL_DATA_service = []\n", "res = requests.get(url,cookies=cookie_dict,headers=headers)\n", "res = res.json()\n", "for data in res['data']['list']:\n", " list = {\n", " 'groupName': item.get('groupName'),\n", " 'cellPhone': data['cellPhone'],\n", " 'name': data['name'],\n", " 'positionNameStr': data['positionNameStr'],\n", " 'roleNameListStr': data['roleNameListStr'],\n", " 'userStatus': data['userStatus']\n", " }\n", "\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))\n", "time.sleep(2)" ] } ], "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 }