283 lines
32 KiB
Plaintext
283 lines
32 KiB
Plaintext
{
|
|
"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"
|
|
]
|
|
},
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"读取到省市小六技术专家区域客服区域客成表单中 66 条数据！\n",
|
|
"2023-05-05 20\n",
|
|
"[['053052302136860181'], ['0615271028177307'], ['050160034020876364'], ['106216373838354980'], ['1143206052848269'], ['19212436541043695'], ['224616673723465569'], ['6412695429095931'], ['693800011139268'], ['075458412020533110'], ['096317175340000380'], ['133703272626143118'], ['05463054031221652'], ['080964261223281432'], ['224934300132837549'], ['063512664121403125'], ['14583865321049759'], ['114115261037799570']]\n",
|
|
"{'result': '33c79823-7648-4ab3-8ba4-59e6ce175e86'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '053052302136860181', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '万商名车（总部）', 'textField_lnsi0v6s': '至尊版', 'employeeField_lnsi0v6u': '2626065538702722', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '053052302136860181', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '万商名车（总部）', 'textField_lnsi0v6z': 'CHS202305050228346', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}, {'textField_lnsi0v72': '万商名车(叶厦路店)', 'textField_lnsi0v6s': '旗舰版', 'employeeField_lnsi0v6u': '2626065538702722', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '053052302136860181', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '万商名车(叶厦路店)', 'textField_lnsi0v6z': 'CHS202305050228357', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '2626065538702722', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'a22a67ee-aba8-4d8e-8b37-38e2eb99b2d5'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '0615271028177307', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '德顺汽车服务', 'textField_lnsi0v6s': '标准版', 'employeeField_lnsi0v6u': '180720602439816818', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '0615271028177307', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '德顺汽车服务', 'textField_lnsi0v6z': 'CHS202305050228453', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '180720602439816818', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'c417d2dc-fbb9-424e-bc16-be8ae881e0a6'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '050160034020876364', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '烨城汽修', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '055512041727184572', 'employeeField_lnsi0v6v': '1218085201677303', 'employeeField_lnsi0v6w': '050160034020876364', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '烨城汽修', 'textField_lnsi0v6z': 'CHS202305050228365', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1218085201677303', 'employeeField_lmeqk424': '055512041727184572', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'b3a92ae4-e51b-4d8f-b536-488ef8b82169'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '106216373838354980', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '立奥汽车-宁波店', 'textField_lnsi0v6s': '标准版', 'employeeField_lnsi0v6u': '20590707351213970', 'employeeField_lnsi0v6v': '311003461041349', 'employeeField_lnsi0v6w': '106216373838354980', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '立奥汽车-宁波店', 'textField_lnsi0v6z': 'CHS202305050228334', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '311003461041349', 'employeeField_lmeqk424': '20590707351213970', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '2043cd03-d015-4a68-8733-60140c162888'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '1143206052848269', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '栖霞修工坊迎福路汽车服务中心', 'textField_lnsi0v6s': '旗舰版', 'employeeField_lnsi0v6u': '20590707351213970', 'employeeField_lnsi0v6v': '311003461041349', 'employeeField_lnsi0v6w': '1143206052848269', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '栖霞修工坊迎福路汽车服务中心', 'textField_lnsi0v6z': 'CHS202305050228387', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '311003461041349', 'employeeField_lmeqk424': '20590707351213970', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'ffcb5933-5e30-4d96-bfc8-594a369930ec'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '19212436541043695', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '俊逸名车服务中心', 'textField_lnsi0v6s': '标准版', 'employeeField_lnsi0v6u': '3704680936560271', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '19212436541043695', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '俊逸名车服务中心', 'textField_lnsi0v6z': 'CHS202305050228347', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '232229053125844557', 'employeeField_lmeqk424': '3704680936560271', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '9a16fb71-4f3e-4569-88c7-ac8d9913fd1a'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '0237196424846034', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '华胜专修连锁第201店', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '0237196424846034', 'employeeField_lnsi0v6v': '1218085201677303', 'employeeField_lnsi0v6w': '0237196424846034', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '华胜专修连锁第201店', 'textField_lnsi0v6z': 'CHS202005150082459', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1218085201677303', 'employeeField_lmeqk424': '0237196424846034', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'e93b4913-0b97-4d0b-b129-6e9d9f5aefba'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '6412695429095931', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '长垣诚驰', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '054169455736370109', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '6412695429095931', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '长垣诚驰', 'textField_lnsi0v6z': 'CHS202305050228400', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '054169455736370109', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'ffd0aba6-69ec-45a9-9fdd-b4227df27adf'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '693800011139268', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '北京市天智华菱汽车配件有限公司', 'textField_lnsi0v6s': '尊享版', 'employeeField_lnsi0v6u': '055512041727184572', 'employeeField_lnsi0v6v': '1218085201677303', 'employeeField_lnsi0v6w': '693800011139268', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '北京市天智华菱汽车配件有限公司', 'textField_lnsi0v6z': 'CHS202305050228376', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1218085201677303', 'employeeField_lmeqk424': '055512041727184572', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '4275ddb9-39b7-4f79-85d4-8fbe87dd3406'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '075458412020533110', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '速瑞汽车服务', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '054169455736370109', 'employeeField_lnsi0v6v': '025366033037741985', 'employeeField_lnsi0v6w': '075458412020533110', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '速瑞汽车服务', 'textField_lnsi0v6z': 'CHS202305050228391', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '025366033037741985', 'employeeField_lmeqk424': '054169455736370109', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '5b47b5a8-a43c-497a-8c38-195cf5136287'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '096317175340000380', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '啄木鸟汽车维修', 'textField_lnsi0v6s': '尊享版', 'employeeField_lnsi0v6u': '180720602439816818', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '096317175340000380', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '啄木鸟汽车维修', 'textField_lnsi0v6z': 'CHS202303230219406', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '180720602439816818', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'f1a3183c-69bb-48a5-80da-8408b762949d'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '133703272626143118', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '曲靖晶奥汽修', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '283227523421943504', 'employeeField_lnsi0v6v': '311003461041349', 'employeeField_lnsi0v6w': '133703272626143118', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '曲靖晶奥汽修', 'textField_lnsi0v6z': 'CHS202305050228374', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '311003461041349', 'employeeField_lmeqk424': '283227523421943504', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'c4df4472-52f4-4a7d-ac6f-45989b9d0483'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '05463054031221652', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '襄州区美创优车', 'textField_lnsi0v6s': '旗舰版', 'employeeField_lnsi0v6u': '3704680936560271', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '05463054031221652', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '襄州区美创优车', 'textField_lnsi0v6z': 'CHS202305050228406', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '232229053125844557', 'employeeField_lmeqk424': '3704680936560271', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '2c395052-deba-4b31-858c-689c09fe0576'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '080964261223281432', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '铭铭汽车服务中心', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '0103433535667605', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '080964261223281432', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '铭铭汽车服务中心', 'textField_lnsi0v6z': 'CHS202305050228428', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}, {'textField_lnsi0v72': '库尔勒汇邦科贸有限责任公司', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '0103433535667605', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '080964261223281432', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '库尔勒汇邦科贸有限责任公司', 'textField_lnsi0v6z': 'CHS202305050228388', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '232229053125844557', 'employeeField_lmeqk424': '0103433535667605', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '5e1d8df8-7d39-4646-88fa-dd6612fc638d'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '224934300132837549', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '娄底市周记汽修服务中心', 'textField_lnsi0v6s': '尊享版', 'employeeField_lnsi0v6u': '3704680936560271', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '224934300132837549', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '娄底市周记汽修服务中心', 'textField_lnsi0v6z': 'CHS202003100054384', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '232229053125844557', 'employeeField_lmeqk424': '3704680936560271', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '262bb6c6-c8c8-4a1b-b188-3b2047d405a0'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '063512664121403125', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '共明汽修', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '2626065538702722', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '063512664121403125', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '共明汽修', 'textField_lnsi0v6z': 'CHS202003180056359', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '2626065538702722', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': '962066a5-03b5-43cc-a1f5-8dcb971c6f29'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '14583865321049759', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '陕西锦腾阳光汽车科技有限公司', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '0103433535667605', 'employeeField_lnsi0v6v': '232229053125844557', 'employeeField_lnsi0v6w': '14583865321049759', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '陕西锦腾阳光汽车科技有限公司', 'textField_lnsi0v6z': 'CHS202305050228377', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '232229053125844557', 'employeeField_lmeqk424': '0103433535667605', 'textField_lmu0523h': '自动派发回访计划'}\n",
|
|
"{'result': 'b92fcba9-58e4-42e8-8e5e-850c49893809'} {'dateField_lmelabb1': '1698196311307', 'employeeField_lmeqk429': '114115261037799570', 'tableField_lnsi0v71': [{'textField_lnsi0v72': '上海来城汽车服务部', 'textField_lnsi0v6s': '基础版', 'employeeField_lnsi0v6u': '2626065538702722', 'employeeField_lnsi0v6v': '1525590028775887', 'employeeField_lnsi0v6w': '114115261037799570', 'dateField_lnsi0v6x': '1698196311307', 'textField_lnsi0v6y': '上海来城汽车服务部', 'textField_lnsi0v6z': 'CHS202104020118663', 'selectField_lnsi0v6q': '强化培训', 'textareaField_lnsi0v6r': '\\n 1.客户日常使用问题解答；\\n 2.跟客户查看主营分析，推荐进销存功能深度使用；\\n 3.跟客户查看车辆分析，推荐短信及其他营销功能；\\n 4.说明转介绍政策，索要转介绍；'}], 'employeeField_lmeqk423': '1525590028775887', 'employeeField_lmeqk424': '2626065538702722', 'textField_lmu0523h': '自动派发回访计划'}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import pandas as pd\n",
|
|
"import numpy as np\n",
|
|
"import requests\n",
|
|
"import json\n",
|
|
"import time\n",
|
|
"import re\n",
|
|
"from datetime import datetime\n",
|
|
"from dateutil.relativedelta import relativedelta\n",
|
|
"from pathlib import Path\n",
|
|
"from urllib.parse import quote\n",
|
|
"from io import BytesIO\n",
|
|
"\n",
|
|
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
|
"\n",
|
|
"\n",
|
|
"# 生成 token，参数不需要修改\n",
|
|
"def generateToken() -> str:\n",
|
|
" \"\"\" 生成 token \"\"\"\n",
|
|
"\n",
|
|
" token_api = 'https://api.dingtalk.com/v1.0/oauth2/accessToken'\n",
|
|
"\n",
|
|
" # 该信息在钉钉开放应用中\n",
|
|
" data = {\n",
|
|
" \"appKey\": \"ding5kqocon5s9oph5uq\",\n",
|
|
" \"appSecret\": 'HL1jgsIIfLAC0eTH0A1m4mwxUDqbgsiPeCCGGE3ocM6qJBTIW7Ivt9drxF_Z4Kb_'\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(token_api, json=data)\n",
|
|
" token = res.json()['accessToken']\n",
|
|
"\n",
|
|
" return token\n",
|
|
"\n",
|
|
"def read_instances(token, formUuid, page, n,formatted_today,formatted_today_two):\n",
|
|
" \"\"\" 函数功能：读取普通表单的所有数据 \"\"\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/search'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": token\n",
|
|
" }\n",
|
|
"\n",
|
|
" formData = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"yida_pub_account\",\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"formUuid\" : formUuid,\n",
|
|
" \"createFromTimeGMT\" : formatted_today,\n",
|
|
" \"createToTimeGMT\" : formatted_today_two,\n",
|
|
" \"currentPage\" : page,\n",
|
|
" \"pageSize\" : n\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(api, headers=headers, json=formData)\n",
|
|
" return res.json()\n",
|
|
"\n",
|
|
"def initiate_process(TOKEN,formUuid,processCode,formData):\n",
|
|
" \"\"\" 发起宜搭审批流程 \"\"\"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/processes/instances/start'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"yida_pub_account\",\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"formUuid\" : formUuid,\n",
|
|
" \"formDataJson\" : json.dumps(formData, cls=NpEncoder),\n",
|
|
" \"processCode\" : processCode,\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(api, headers=headers, json=payload)\n",
|
|
" return res.json()\n",
|
|
"def read_instances_new(token, formUuid, page, n):\n",
|
|
" \"\"\" 函数功能：读取普通表单的所有数据 \"\"\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/search'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": token\n",
|
|
" }\n",
|
|
"\n",
|
|
" formData = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"yida_pub_account\",\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"formUuid\" : formUuid,\n",
|
|
" \"currentPage\" : page,\n",
|
|
" \"pageSize\" : n\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(api, headers=headers, json=formData)\n",
|
|
" return res.json()\n",
|
|
"class NpEncoder(json.JSONEncoder):\n",
|
|
" def default(self, obj):\n",
|
|
" if isinstance(obj, np.integer):\n",
|
|
" return int(obj)\n",
|
|
" elif isinstance(obj, np.floating):\n",
|
|
" return float(obj)\n",
|
|
" elif isinstance(obj, np.ndarray):\n",
|
|
" return obj.tolist()\n",
|
|
" else:\n",
|
|
" return super(NpEncoder, self).default(obj)\n",
|
|
" \n",
|
|
"TOKEN = generateToken()\n",
|
|
"import datetime\n",
|
|
"now_time = datetime.datetime.now()\n",
|
|
"today = now_time + datetime.timedelta(days=-173)\n",
|
|
"formatted_today = today.strftime(\"%Y-%m-%d\")\n",
|
|
"today_two = now_time + datetime.timedelta(days=-172)\n",
|
|
"formatted_today_two = today_two.strftime(\"%Y-%m-%d\")\n",
|
|
"timestamp_ms = int(time.time() * 1000) # 当然日期时间戳 毫秒级\n",
|
|
"'''读取省市小六技术专家区域客服区域客成 '''\n",
|
|
"FORMID = \"FORM-TP866D918DFCA4FW79YZU5X43FO32QZJQDZJL7\" #省市小六技术专家区域客服区域客成\n",
|
|
"# 读取流程表单数据\n",
|
|
"form_data = read_instances_new(token=TOKEN, formUuid=FORMID, page=1, n=100)\n",
|
|
"PAGES = form_data.get('totalCount')//100 + 1\n",
|
|
"textField_gif29wy = {}\n",
|
|
"textField_3athky8 = {}\n",
|
|
"textField_3hgho1m = {}\n",
|
|
"textField_nc7gskc = {}\n",
|
|
"textField_qk1e5di = {}\n",
|
|
"\"\"\" 获取全量数据 \"\"\"\n",
|
|
"for i in range(1, PAGES+1):\n",
|
|
" form_data = read_instances_new(token=TOKEN, formUuid=FORMID, page=i, n=100)\n",
|
|
" for data in form_data.get('data'):\n",
|
|
" textField_gif29wy[data['formData']['textField_3hgho1m']]=data['formData']['textField_gif29wy'] #区域客成id\n",
|
|
" textField_3athky8[data['formData']['textField_3hgho1m']]=data['formData']['textField_3athky8'] #区域客服id\n",
|
|
" textField_3hgho1m[data['formData']['textField_3hgho1m']]=data['formData']['textField_3hgho1m'] #小六id\n",
|
|
" textField_nc7gskc[data['formData']['textField_3hgho1m']]=data['formData']['textField_nc7gskc'] #技术专家id\n",
|
|
" textField_qk1e5di[data['formData']['textField_3hgho1m']]=data['formData']['textField_lntniove'] #区域经理id\n",
|
|
"print(f'读取到省市小六技术专家区域客服区域客成表单中 {len(textField_gif29wy)} 条数据！')\n",
|
|
"# [流程]新签服务流程 读取待处理数据\n",
|
|
"json_data = []\n",
|
|
"read_data = read_instances(TOKEN, \"FORM-9X766NA1SOATBRSH2K42D8BJCX7L326HI64TKG5\", 1, 100,formatted_today,formatted_today_two)\n",
|
|
"PAGES = read_data.get('totalCount')//100 + 1\n",
|
|
"print(formatted_today,read_data.get('totalCount'))\n",
|
|
"for a in range(1,PAGES + 1):\n",
|
|
" read_data = read_instances(TOKEN, \"FORM-9X766NA1SOATBRSH2K42D8BJCX7L326HI64TKG5\", a, 100,formatted_today,formatted_today_two) \n",
|
|
" for i in range(0,len(read_data[\"data\"])):\n",
|
|
" json_data.append(read_data[\"data\"][i]['formData'])\n",
|
|
"\n",
|
|
"# 获取待回访人员信息+去重\n",
|
|
"name_list = []\n",
|
|
"for data in json_data:\n",
|
|
" name_list.append(data['employeeField_kyi1dqth_id'])\n",
|
|
"unique_arr = []\n",
|
|
"[unique_arr.append(x) for x in name_list if x not in unique_arr]\n",
|
|
"print(unique_arr)\n",
|
|
"\n",
|
|
"# 【测试限制提交】每日工作计划\n",
|
|
"formUuid = \"FORM-8Y866XB1YUHEM9HD6RSVU75UFGTT24QEJQVML5\"\n",
|
|
"processCode = \"TPROC--8Y866XB1YUHEM9HD6RSVU75UFGTT29TEJQVML6\"\n",
|
|
"# 遍历数据并进行创建\n",
|
|
"for name in unique_arr:\n",
|
|
" name_new = 1\n",
|
|
" tableField_lnsi0v71 = {}\n",
|
|
" tableField_lnsi0v71['dateField_lmelabb1'] = \"\"\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk429'] = \"\"\n",
|
|
" for data in json_data:\n",
|
|
" if data['employeeField_kyi1dqth_id'] == name:\n",
|
|
" data_one = {} # 子表单\n",
|
|
" data_two = {} # 主表单\n",
|
|
" # 子表单\n",
|
|
" data_one['textField_lnsi0v72'] = data['orgName']\n",
|
|
" data_one['textField_lnsi0v6s'] = data[\"saasEdition\"] # 销售版本\n",
|
|
" try:\n",
|
|
" data_one['employeeField_lnsi0v6u'] = textField_nc7gskc[name[0]] # 技术专家\n",
|
|
" data_one['employeeField_lnsi0v6v'] = textField_qk1e5di[name[0]] # 区域经理\n",
|
|
" data_one['employeeField_lnsi0v6w'] = textField_3hgho1m[name[0]] # 运营顾问\n",
|
|
" except:\n",
|
|
" data_one['employeeField_lnsi0v6u'] = data['technician_id'][0] # 技术专家\n",
|
|
" data_one['employeeField_lnsi0v6v'] = data['manager_id'][0] # 区域经理\n",
|
|
" data_one['employeeField_lnsi0v6w'] = data['technician_id'][0] # 运营顾问\n",
|
|
" data_one['dateField_lnsi0v6x'] = str(timestamp_ms) # 计划日期\n",
|
|
" data_one['textField_lnsi0v6y'] = data[\"orgName\"] # 门店名称-拷贝\n",
|
|
" data_one['textField_lnsi0v6z'] = data[\"orgCode\"] # 门店编码\n",
|
|
" data_one['selectField_lnsi0v6q'] = \"强化培训\" # 拜访目的\n",
|
|
" data_one['textareaField_lnsi0v6r'] = '''\n",
|
|
" 1.客户日常使用问题解答；\n",
|
|
" 2.跟客户查看主营分析，推荐进销存功能深度使用；\n",
|
|
" 3.跟客户查看车辆分析，推荐短信及其他营销功能；\n",
|
|
" 4.说明转介绍政策，索要转介绍；''' # 拜访目的说明\n",
|
|
" # 加入数据\n",
|
|
" if name_new == 1:\n",
|
|
" tableField_lnsi0v71['tableField_lnsi0v71'] = [data_one]\n",
|
|
" # 主表单\n",
|
|
" # data_two['dateField_lmelabb1'] = str(timestamp_ms)\n",
|
|
" # data_two['employeeField_lmeqk429'] = name\n",
|
|
" tableField_lnsi0v71['dateField_lmelabb1'] = str(timestamp_ms)\n",
|
|
" try:\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk429'] = name[0]\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk423'] = textField_qk1e5di[name[0]] # 区域经理\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk424'] = textField_nc7gskc[name[0]] # 技术专家\n",
|
|
" except:\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk429'] = data['technician_id'][0] # 运营顾问\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk423'] = data['manager_id'][0] # 区域经理\n",
|
|
" tableField_lnsi0v71['employeeField_lmeqk424'] = data['technician_id'][0] # 技术专家\n",
|
|
" tableField_lnsi0v71['textField_lmu0523h'] = \"自动派发回访计划\" # 状态备用\n",
|
|
" else:\n",
|
|
" tableField_lnsi0v71['tableField_lnsi0v71'].append(data_one)\n",
|
|
" name_new = name_new + 1\n",
|
|
" res=initiate_process(TOKEN,formUuid,processCode,tableField_lnsi0v71)\n",
|
|
" print(res,tableField_lnsi0v71)"
|
|
]
|
|
}
|
|
],
|
|
"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
|
|
}
|