1057 lines
51 KiB
Plaintext
1057 lines
51 KiB
Plaintext
{
|
|
"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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-1-3908d3cf86e9>: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": [
|
|
"<ipython-input-7-95d241cc5250>: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": [
|
|
"<ipython-input-20-032bc2c7dc89>: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": [
|
|
"<ipython-input-21-163f209bdb4e>: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": [
|
|
"<ipython-input-36-4c8a749a2fb0>: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
|
|
}
|