2082 lines
130 KiB
Plaintext
2082 lines
130 KiB
Plaintext
{
|
||
"cells": [
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 68,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"# 基础函数配置\n",
|
||
"import pandas as pd\n",
|
||
"import pandas as pd\n",
|
||
"import requests\n",
|
||
"from pathlib import Path\n",
|
||
"from urllib.parse import quote\n",
|
||
"import json\n",
|
||
"import numpy as np\n",
|
||
"import time\n",
|
||
"from datetime import date, timedelta\n",
|
||
"\n",
|
||
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
||
"\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 transcation(token,FORMID,data_new):\n",
|
||
" \"\"\" 函数功能：更新表单内容 \"\"\"\n",
|
||
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": token\n",
|
||
" }\n",
|
||
"\n",
|
||
" payload = {\n",
|
||
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
||
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
||
" \"userId\" : \"2268275546837446\", # 曹伟 id\n",
|
||
" \"language\" : \"zh_CN\",\n",
|
||
" \"useLatestVersion\" : \"false\",\n",
|
||
" \"formInstanceId\" : FORMID,\n",
|
||
" \"updateFormDataJson\" : json.dumps(data_new, cls=NpEncoder),\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.put(api, headers=headers, json=payload)\n",
|
||
"\n",
|
||
" return res.json()\n",
|
||
"def aggree_approval(token: str, taskId: str, processInstanceId: str, formData: dict,res_new):\n",
|
||
" \"\"\" 函数功能：同意审批节点 --F6客户服务 应用 \"\"\"\n",
|
||
" api = f'https://api.dingtalk.com/v1.0/yida/tasks/execute'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": token\n",
|
||
" }\n",
|
||
"\n",
|
||
" payload = {\n",
|
||
" \"outResult\": \"AGREE\",\n",
|
||
" \"appType\": \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
||
" \"systemToken\": \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
||
" \"remark\": \"同意(接口自动)\",\n",
|
||
" \"formDataJson\": json.dumps(formData, cls=NpEncoder),\n",
|
||
" \"processInstanceId\": processInstanceId,\n",
|
||
" # \"userId\": \"yida_pub_account\",\n",
|
||
" \"userId\": res_new, \n",
|
||
" \"language\": \"zh_CN\",\n",
|
||
" \"taskId\": int(taskId)\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.post(api, headers=headers, json=payload)\n",
|
||
" # print('同意审批节点')\n",
|
||
" return res\n",
|
||
"def read_instances_new(token, formUuid, page, n):\n",
|
||
" \"\"\" 函数功能：读取流程表单的所有数据 \"\"\"\n",
|
||
"\n",
|
||
" api = f'https://api.dingtalk.com//v1.0/yida/processes/instances?pageNumber={page}&pageSize={n}'\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",
|
||
" # \"searchFieldJson\": json.dumps(searchField), # 如果增加上这一项会要求升级宜搭存储\n",
|
||
" \"instanceStatus\": \"RUNNING\"\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.post(api, headers=headers, json=formData)\n",
|
||
" return res.json()\n",
|
||
"def get_approval_records(token: str, processInstanceId: str):\n",
|
||
" \"\"\" 函数功能：获取流程表单的审批记录 --F6客户服务 应用 \"\"\"\n",
|
||
" appType = \"APP_UYZ0KG6L0CCNV80GZ66O\"\n",
|
||
" systemToken = \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\"\n",
|
||
" userId = \"yida_pub_account\"\n",
|
||
"\n",
|
||
" api = f'https://api.dingtalk.com/v1.0/yida/processes/operationRecords?appType={appType}&systemToken={systemToken}&userId={userId}&language=zh_CN&processInstanceId={processInstanceId}'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": token\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.get(api, headers=headers)\n",
|
||
" # print('获取流程表单的审批记录')\n",
|
||
" return res.json()\n",
|
||
"def read_instances_pt(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",
|
||
"def read_processes(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",
|
||
"def instances_id(TOKEN,id):\n",
|
||
" \"\"\" 函数功能：查询表单实例 \"\"\"\n",
|
||
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/{id}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=yida_pub_account&language=zh_CN'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.get(api, headers=headers)\n",
|
||
"\n",
|
||
" return res.json()\n",
|
||
"def component(FORMID,TOKEN):\n",
|
||
" \"\"\" 获取组件信息 \"\"\"\n",
|
||
" api = f'https://api.dingtalk.com//v1.0/yida/forms/formFields'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
||
" }\n",
|
||
" payload = {\n",
|
||
" \"formUuid\" : FORMID,\n",
|
||
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
||
" # \"formDataJson\" : json.dumps(formData, cls=NpEncoder),\n",
|
||
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
||
" # \"language\" : \"zh_CN\",\n",
|
||
" \"userId\" : \"yida_pub_account\"\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.get(api, headers=headers, json=payload)\n",
|
||
"\n",
|
||
" return res.json()\n",
|
||
"def component_id(id,TOKEN):\n",
|
||
" api = f'https://api.dingtalk.com/v1.0/yida/processes/instancesInfos/{id}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=yida_pub_account&language=zh_CN'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
||
" }\n",
|
||
" \n",
|
||
" res = requests.get(api, headers=headers)\n",
|
||
"\n",
|
||
" return res.json()\n",
|
||
"def find_indexes(daichuli_mendian_name,i_two):\n",
|
||
" indexes = [i for i, x in enumerate(daichuli_mendian_name) if x == i_two]\n",
|
||
" return indexes\n",
|
||
"def get_staffID(TOKEN: str,ALL_DATA_staff,staff_name):\n",
|
||
" res_new = [v['formData']['textField_lfrw3u59'] for v in ALL_DATA_staff if v['formData']['textField_lfrw3u58']== staff_name]\n",
|
||
" # print('通过员工名称获取员工id')\n",
|
||
" return res_new\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"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 69,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"name": "stdout",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"读取到流程表中 3 条数据！\n",
|
||
"1 ['测试门店3', '测试门店2']\n",
|
||
"{'radioField_kuntp6fm': '小六', 'textField_ksydghrg': '', 'textField_ksydghrm': '', 'textField_livc8bjj': '', 'radioField_kuntp6fn': '小六', 'textField_kuhnydls': '', 'textField_kuhnydlw': '', 'textField_livc8bjk': '', 'radioField_kurxyhvp': '小六', 'textField_kuhnydmg': '', 'textField_kuhnydmk': '', 'textField_livc8bjl': '曹伟', 'dateField_lifr1fdx': 1692327690000, 'radioField_kurxyhvq': '小六', 'radioField_kuhnydn0': '是', 'dateField_kuhnydn2': 1665158400000, 'textField_kuhnydn3': '', 'radioField_kuhnydn5': '否', 'dateField_kuhnydn6': 1667145600000, 'textField_kuhnydn7': '', 'textField_livc8bjm': '', 'radioField_l85ppdia': '是', 'textField_lbodyv8i': '', 'textField_l85ppdic': '', 'textField_l85ppdig': '', 'radioField_r3yeqvd': '暂时没有问题', 'textAreaField_972lhkt': '111', 'textField_lhbnuvtn': '', 'radioField_l85ppdie': '不确定', 'textField_livcjyvr': '', 'selectField_l31clxfy': '门店原因', 'selectField_l31clxg1': '疫情原因', 'textareaField_l31clxg4': '疫情开门再续', 'radioField_ljqi5we3': '无', 'textareaField_liviovx0': '测试0818', 'radioField_la7x32mq': '是', 'textField_la7x32mp': '1111'}\n",
|
||
"16141854873 30天联系情况\n",
|
||
"['测试门店1', '测试门店3', '测试门店2'] [999901, 999903, 999902]\n",
|
||
"{} 测试公司 8454ccf1-03ec-4775-b849-45dc61333acb 测试门店1\n",
|
||
"8454ccf1-03ec-4775-b849-45dc61333acb\n",
|
||
"16140672888 60天联系情况\n",
|
||
"{}\n",
|
||
"{} 测试公司 5c48c47d-f29e-4470-b3da-018d583570f0 测试门店3\n",
|
||
"5c48c47d-f29e-4470-b3da-018d583570f0\n",
|
||
"16141854873 30天联系情况\n",
|
||
"{} 测试公司 3bb9e42a-7858-4141-8189-a05c1d2453f7 测试门店2\n",
|
||
"3bb9e42a-7858-4141-8189-a05c1d2453f7\n",
|
||
"16140917497 60天联系情况\n",
|
||
"{}\n"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"TOKEN = generateToken()\n",
|
||
"# 读取 [流程]续约服务流程_复制测试0815\n",
|
||
"FORMID = \"FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC\" \n",
|
||
"# 读取[流程]新签服务流程表单\n",
|
||
"form_data = read_instances_pt(token=TOKEN, formUuid=FORMID, page=1, n=100)\n",
|
||
"PAGES = form_data.get('totalCount')//100 + 1\n",
|
||
"ALL_DATA_id = []\n",
|
||
"ALL_DATA_data = []\n",
|
||
"ALL_DATA_mengdian_name = []\n",
|
||
"\"\"\" 获取全量数据 \"\"\"\n",
|
||
"for i in range(1, PAGES+1):\n",
|
||
" form_data = read_instances_pt(token=TOKEN, formUuid=FORMID, page=i, n=100)\n",
|
||
" for data in form_data.get('data'):\n",
|
||
" ALL_DATA_id.append(data[\"formInstanceId\"])\n",
|
||
" ALL_DATA_data.append(data[\"instanceValue\"])\n",
|
||
" ALL_DATA_mengdian_name.append(data['formData']['textField_ksirro5j'])\n",
|
||
"print(f'读取到流程表中 {len(ALL_DATA_id)} 条数据！')\n",
|
||
"CODE_NAME = ['radioField_kuntp6fm','radioField_ksydghrf','dateField_ksydghri','textField_ksydghrg','dateField_ksydghrj','radioField_ksydghrk','dateField_ksydghrl','textField_ksydghrm','textField_livc8bjj','dateField_lifr1fdv','radioField_kuntp6fn','radioField_kuhnydlp','dateField_kuhnydlr','textField_kuhnydls','dateField_kuhnydlt','radioField_kuhnydlu','dateField_kuhnydlv','textField_kuhnydlw','textField_livc8bjk','dateField_lifr1fdw','radioField_kurxyhvp','radioField_kuhnydmd','dateField_kuhnydmf','textField_kuhnydmg','dateField_kuhnydmh','radioField_kuhnydmi','dateField_kuhnydmj','textField_kuhnydmk','textField_livc8bjl','dateField_lifr1fdx','radioField_kurxyhvq','radioField_kuhnydn0','dateField_kuhnydn2','textField_kuhnydn3','dateField_kuhnydn4','radioField_kuhnydn5','dateField_kuhnydn6','textField_kuhnydn7','textField_livc8bjm','dateField_lifr1fdy','radioField_l85ppdia','dateField_l85ppdib','textField_lbodyv8i','textField_l85ppdic','dateField_l85ppdid','dateField_l85ppdif','textField_l85ppdig','radioField_r3yeqvd','textAreaField_972lhkt','employeeField_lhbkudx0','textField_lhbnuvtn','selectField_lb0gxmq8','selectField_lb5xhwk4','selectField_lc70femm','radioField_l85ppdie','textField_livcjyvr','dateField_livcjyvp','selectField_l31clxfy','selectField_l31clxfz','selectField_l31clxg0','selectField_l31clxg1','selectField_l31clxg2','selectField_l31clxg3','textareaField_l31clxg4','radioField_ljqi5we3','textareaField_liviovx0','radioField_la7x32mq','textField_la7x32mp','imageField_la7x32mt']\n",
|
||
"daichuli_id = []\n",
|
||
"daichuli_value = []\n",
|
||
"daichuli_gongsiid = []\n",
|
||
"daichuli_mendian_name = []\n",
|
||
"daichuli_gongsi_name = []\n",
|
||
"# 获取待处理的表单实例id daichuli_id\n",
|
||
"for i in range(0,len(ALL_DATA_id)):\n",
|
||
" data_json = json.loads(ALL_DATA_data[i])\n",
|
||
" # 判断是否更新\n",
|
||
" for data_json_list in data_json:\n",
|
||
" updateFormDataJson = {}\n",
|
||
" if data_json_list['fieldId'] == 'textField_ksirro5j':\n",
|
||
" daichuli_mendian_name.append(data_json_list['fieldData']['value'])\n",
|
||
" if data_json_list['fieldId'] == 'textField_ksirm9xx':\n",
|
||
" daichuli_gongsi_name.append(data_json_list['fieldData']['value'])\n",
|
||
" if data_json_list['fieldId'] == 'multiSelectField_ll5x02m5':\n",
|
||
" try:\n",
|
||
" fieldData = data_json_list['fieldData']['value']\n",
|
||
" if len(fieldData)>0:\n",
|
||
" # 记录表单实例id\n",
|
||
" daichuli_id.append(ALL_DATA_id[i])\n",
|
||
" daichuli_value.append(data_json_list['fieldData']['value'])\n",
|
||
" print(i,data_json_list['fieldData']['value'])\n",
|
||
" except:\n",
|
||
" pass\n",
|
||
"# 逐条处理——————————————————————————————————————————————\n",
|
||
"if len(daichuli_id) > 0:\n",
|
||
" \"\"\" 通过员工名称获取员工id\"\"\"\n",
|
||
" # 读取员工对应关系：宜搭员工-ID对应表\n",
|
||
" FORMID_two = \"FORM-EA866E715PF9YA7ECCAGSABX91Q72PVA3WRFL6\" # 宜搭员工-ID对应表 FORM-EA866E715PF9YA7ECCAGSABX91Q72PVA3WRFL6\n",
|
||
" # 读取流程表单数据\n",
|
||
" form_data_two = read_processes(token=TOKEN, formUuid=FORMID_two, page=1, n=100)\n",
|
||
" PAGES_two = form_data_two.get('totalCount')//100 + 1\n",
|
||
"\n",
|
||
" ALL_DATA_staff = []\n",
|
||
" \"\"\" 获取员工全量数据 \"\"\"\n",
|
||
" for i in range(1, PAGES_two+1):\n",
|
||
" # form_data = read_processes_instances(token=TOKEN, formUuid=FORMID, createFromTimeGMT=CREATE_FROM, createToTimeGMT=CREATE_TO, page=i, n=100, searchField={'textField_l7if5ff9': '否'})\n",
|
||
" form_data_two = read_processes(token=TOKEN, formUuid=FORMID_two, page=i, n=100)\n",
|
||
" for data in form_data_two.get('data'):\n",
|
||
" ALL_DATA_staff.append(data)\n",
|
||
" # -*- coding: utf-8 -*-\n",
|
||
" import psycopg2\n",
|
||
" import pandas as pd\n",
|
||
" # 获得连接\n",
|
||
" conn = psycopg2.connect(database=\"f6_bi\", user=\"BASIC$ro_caowei\", password=\"!ro_caowei123\", host=\"hgprecn-cn-nif1vnv0y002-cn-shanghai.hologres.aliyuncs.com\", port=\"80\")\n",
|
||
" # 获得游标对象，一个游标对象可以对数据库进行执行操作\n",
|
||
" cursor = conn.cursor()\n",
|
||
"\n",
|
||
" import datetime\n",
|
||
" now_time = datetime.datetime.now()\n",
|
||
" yes_time = now_time + datetime.timedelta(days=-1)\n",
|
||
" yes_time_nyr = int(yes_time.strftime('%Y%m%d'))# 获取前一天日期\n",
|
||
" # sql语句 建表\n",
|
||
" sql =f\"\"\"SELECT * FROM \"public\".\"holo_ads_report_saas_profile_ngv_detail_d\" WHERE \"date_id\" = '{yes_time_nyr}';\"\"\"\n",
|
||
" # 执行语句\n",
|
||
" cursor.execute(sql)\n",
|
||
" # 获取结果集的每一行\n",
|
||
" rows = cursor.fetchall()\n",
|
||
" # 获取所有字段名\n",
|
||
" all_fields = cursor.description\n",
|
||
" #执行结果转化为dataframe\n",
|
||
" col = []\n",
|
||
" for i in all_fields:\n",
|
||
" col.append(i[0])\n",
|
||
" data_NGV = pd.DataFrame(list(rows),columns=col)\n",
|
||
" # data_NGV.to_excel(r'C:\\Users\\admin\\Desktop\\NGV明细.xlsx')\n",
|
||
" data_NGV = pd.read_excel(r'C:\\Users\\admin\\Desktop\\NGV明细.xlsx')\n",
|
||
" # 关闭数据库连接\n",
|
||
" cursor.close()\n",
|
||
" conn.close()\n",
|
||
" tinydict = {'0天处理情况': 1, '30天联系情况': 2, '60天联系情况': 3, '90天联系情况': 4, '120天联系情况': 5}\n",
|
||
" for i in range(0,len(daichuli_id)):\n",
|
||
" # 获取可更新内容 updateFormDataJson\n",
|
||
" data_json = instances_id(TOKEN,daichuli_id[i])\n",
|
||
" updateFormDataJson = {}\n",
|
||
" for list_name in CODE_NAME:\n",
|
||
" try:\n",
|
||
" updateFormDataJson[list_name] = data_json['formData'][list_name]\n",
|
||
" except:\n",
|
||
" pass\n",
|
||
" print(updateFormDataJson)\n",
|
||
" # 获取当前流程节点\n",
|
||
" res_new = get_approval_records(token=TOKEN, processInstanceId=daichuli_id[i])\n",
|
||
" records_new = res_new.get('result')\n",
|
||
" # 获取审批节点的 taskId\n",
|
||
" records_new = [item for item in records_new if item.get('type') == \"TODO\"]\n",
|
||
" taskId_new = records_new[0].get('taskId')\n",
|
||
" print(taskId_new,records_new[0]['showName'])\n",
|
||
" # 获取待同步表单实例id\n",
|
||
" gongsi_id = component_id(daichuli_id[i],TOKEN)[\"data\"]['textField_kuntp6fj'] # 获取公司id\n",
|
||
" gongsi_name = component_id(daichuli_id[i],TOKEN)[\"data\"]['textField_ksirm9xx'] # 获取公司id\n",
|
||
" # NGV中获取当前公司id对应的内容\n",
|
||
" row_indexes = data_NGV[data_NGV['id_own_group'] == int(gongsi_id)].index.tolist()\n",
|
||
" org_name_list = []\n",
|
||
" org_id_list = []\n",
|
||
" for i_one in row_indexes:\n",
|
||
" org_name_list.append(data_NGV.loc[i_one,\"org_name\"])\n",
|
||
" org_id_list.append(data_NGV.loc[i_one,\"id_own_org\"])\n",
|
||
" print(org_name_list,org_id_list)\n",
|
||
" # 根据门店名称获取单号 + 校验公司名称是否相同，不同则继续查找\n",
|
||
" for i_two in org_name_list:\n",
|
||
" i_two_list = find_indexes(daichuli_mendian_name,i_two)[0]\n",
|
||
" if daichuli_gongsi_name[i_two_list] == gongsi_name and i_two == ALL_DATA_mengdian_name[i_two_list] :\n",
|
||
" # 开始同步数据\n",
|
||
" res_three = transcation(TOKEN,ALL_DATA_id[i_two_list],updateFormDataJson)\n",
|
||
" print(res_three,daichuli_gongsi_name[i_two_list],ALL_DATA_id[i_two_list],ALL_DATA_mengdian_name[i_two_list])\n",
|
||
" # 开始同步节点\n",
|
||
" print(ALL_DATA_id[i_two_list])\n",
|
||
" res_new_one = get_approval_records(token=TOKEN, processInstanceId=ALL_DATA_id[i_two_list])\n",
|
||
" records_new_one = res_new_one.get('result')\n",
|
||
" # 获取审批节点的 taskId\n",
|
||
" records_new_one = [item for item in records_new_one if item.get('type') == \"TODO\"]\n",
|
||
" taskId_new_one = records_new_one[0].get('taskId')\n",
|
||
" print(taskId_new_one,records_new_one[0]['showName'])\n",
|
||
" if tinydict[records_new_one[0]['showName']] > tinydict[records_new[0]['showName']] :\n",
|
||
" data_new = {}\n",
|
||
" res=aggree_approval(token=TOKEN, taskId=taskId_new_one, processInstanceId=ALL_DATA_id[i_two_list], formData=data_new,res_new =get_staffID(TOKEN,ALL_DATA_staff,records_new_one[0]['operatorName'])[0] )\n",
|
||
" print(res.json())\n",
|
||
" updateFormDataJson_new = {'multiSelectField_ll5x02m5':\"\"}\n",
|
||
" transcation(TOKEN,daichuli_id[i],updateFormDataJson_new)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# [流程]续约服务流程 FORM-PE866MD1MJMU0WGLYRFLYEN5YN9L1I55Z7ZUK22\n",
|
||
"# 连锁店数据同步_[流程]续约服务流程 FORM-3C866TC1IU8DKKYP8NH9D95OUYS82W5BTX4LL7"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": null,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"# 获取可更新内容 updateFormDataJson"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": null,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"instances_id(TOKEN,daichuli_id[i])"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 66,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"name": "stdout",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"{'radioField_kuntp6fm': '小六', 'radioField_ksydghrf': '是', 'textField_ksydghrg': '', 'radioField_ksydghrk': '不确定', 'textField_ksydghrm': '', 'textField_livc8bjj': '曹伟', 'dateField_lifr1fdv': 1692179184000, 'radioField_kuntp6fn': '小六', 'radioField_kuhnydlp': '是', 'textField_kuhnydls': '', 'radioField_kuhnydlu': '不确定', 'textField_kuhnydlw': '', 'textField_livc8bjk': '', 'radioField_kurxyhvp': '小六', 'radioField_kuhnydmd': '是', 'textField_kuhnydmg': '', 'radioField_kuhnydmi': '不确定', 'textField_kuhnydmk': '', 'textField_livc8bjl': '', 'radioField_kurxyhvq': '小六', 'radioField_kuhnydn0': '是', 'dateField_kuhnydn2': 1665158400000, 'textField_kuhnydn3': '', 'radioField_kuhnydn5': '不确定', 'dateField_kuhnydn6': 1667145600000, 'textField_kuhnydn7': '', 'textField_livc8bjm': '', 'radioField_l85ppdia': '是', 'textField_lbodyv8i': '', 'textField_l85ppdic': '', 'textField_l85ppdig': '', 'radioField_r3yeqvd': '暂时没有问题', 'textAreaField_972lhkt': '111', 'textField_lhbnuvtn': '', 'radioField_l85ppdie': '不确定', 'textField_livcjyvr': '', 'selectField_l31clxfy': '门店原因', 'selectField_l31clxg1': '疫情原因', 'textareaField_l31clxg4': '疫情开门再续', 'radioField_ljqi5we3': '无', 'textareaField_liviovx0': '测试0816', 'radioField_la7x32mq': '是', 'textField_la7x32mp': '1111'}\n"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"# 获取可更新内容 updateFormDataJson\n",
|
||
"data_json = instances_id(TOKEN,daichuli_id[i])\n",
|
||
"updateFormDataJson = {}\n",
|
||
"for list_name in CODE_NAME:\n",
|
||
" try:\n",
|
||
" updateFormDataJson[list_name] = data_json['formData'][list_name]\n",
|
||
" except:\n",
|
||
" pass\n",
|
||
"print(updateFormDataJson)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 67,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'radioField_kuntp6fm': '小六',\n",
|
||
" 'radioField_ksydghrf': '是',\n",
|
||
" 'textField_ksydghrg': '',\n",
|
||
" 'radioField_ksydghrk': '不确定',\n",
|
||
" 'textField_ksydghrm': '',\n",
|
||
" 'textField_livc8bjj': '曹伟',\n",
|
||
" 'dateField_lifr1fdv': 1692179184000,\n",
|
||
" 'radioField_kuntp6fn': '小六',\n",
|
||
" 'radioField_kuhnydlp': '是',\n",
|
||
" 'textField_kuhnydls': '',\n",
|
||
" 'radioField_kuhnydlu': '不确定',\n",
|
||
" 'textField_kuhnydlw': '',\n",
|
||
" 'textField_livc8bjk': '',\n",
|
||
" 'radioField_kurxyhvp': '小六',\n",
|
||
" 'radioField_kuhnydmd': '是',\n",
|
||
" 'textField_kuhnydmg': '',\n",
|
||
" 'radioField_kuhnydmi': '不确定',\n",
|
||
" 'textField_kuhnydmk': '',\n",
|
||
" 'textField_livc8bjl': '',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'dateField_kuhnydn2': 1665158400000,\n",
|
||
" 'textField_kuhnydn3': '',\n",
|
||
" 'radioField_kuhnydn5': '不确定',\n",
|
||
" 'dateField_kuhnydn6': 1667145600000,\n",
|
||
" 'textField_kuhnydn7': '',\n",
|
||
" 'textField_livc8bjm': '',\n",
|
||
" 'radioField_l85ppdia': '是',\n",
|
||
" 'textField_lbodyv8i': '',\n",
|
||
" 'textField_l85ppdic': '',\n",
|
||
" 'textField_l85ppdig': '',\n",
|
||
" 'radioField_r3yeqvd': '暂时没有问题',\n",
|
||
" 'textAreaField_972lhkt': '111',\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'radioField_l85ppdie': '不确定',\n",
|
||
" 'textField_livcjyvr': '',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'radioField_ljqi5we3': '无',\n",
|
||
" 'textareaField_liviovx0': '测试0816',\n",
|
||
" 'radioField_la7x32mq': '是',\n",
|
||
" 'textField_la7x32mp': '1111'}"
|
||
]
|
||
},
|
||
"execution_count": 67,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"updateFormDataJson"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 47,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'radioField_kuntp6fm': '小六',\n",
|
||
" 'radioField_kuntp6fn': '小六',\n",
|
||
" 'radioField_kurxyhvp': '小六',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'radioField_l85ppdia': '是',\n",
|
||
" 'radioField_r3yeqvd': '暂时没有问题',\n",
|
||
" 'textAreaField_972lhkt': '111',\n",
|
||
" 'employeeField_lhbkudx0': [],\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'radioField_l85ppdie': '不确定',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'selectField_l31clxfz': '',\n",
|
||
" 'selectField_l31clxg0': '',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'selectField_l31clxg2': '',\n",
|
||
" 'selectField_l31clxg3': '',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'radioField_ljqi5we3': '无',\n",
|
||
" 'textareaField_liviovx0': '测试0816',\n",
|
||
" 'radioField_la7x32mq': '是',\n",
|
||
" 'textField_la7x32mp': '1111'}"
|
||
]
|
||
},
|
||
"execution_count": 47,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"updateFormDataJson"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 18,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'3bb9e42a-7858-4141-8189-a05c1d2453f7'"
|
||
]
|
||
},
|
||
"execution_count": 18,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"ALL_DATA_id[i_two_list]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 28,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"\"\"\" 通过员工名称获取员工id\"\"\"\n",
|
||
"# 读取员工对应关系：宜搭员工-ID对应表\n",
|
||
"FORMID_two = \"FORM-EA866E715PF9YA7ECCAGSABX91Q72PVA3WRFL6\" # 宜搭员工-ID对应表 FORM-EA866E715PF9YA7ECCAGSABX91Q72PVA3WRFL6\n",
|
||
"# 读取流程表单数据\n",
|
||
"form_data_two = read_processes(token=TOKEN, formUuid=FORMID_two, page=1, n=100)\n",
|
||
"PAGES_two = form_data_two.get('totalCount')//100 + 1\n",
|
||
"\n",
|
||
"ALL_DATA_staff = []\n",
|
||
"\"\"\" 获取员工全量数据 \"\"\"\n",
|
||
"for i in range(1, PAGES_two+1):\n",
|
||
" # form_data = read_processes_instances(token=TOKEN, formUuid=FORMID, createFromTimeGMT=CREATE_FROM, createToTimeGMT=CREATE_TO, page=i, n=100, searchField={'textField_l7if5ff9': '否'})\n",
|
||
" form_data_two = read_processes(token=TOKEN, formUuid=FORMID_two, page=i, n=100)\n",
|
||
" for data in form_data_two.get('data'):\n",
|
||
" ALL_DATA_staff.append(data)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 34,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'曹伟'"
|
||
]
|
||
},
|
||
"execution_count": 34,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"records_new[0]['operatorName']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 41,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"name": "stdout",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"8454ccf1-03ec-4775-b849-45dc61333acb\n",
|
||
"16140672888 60天联系情况\n",
|
||
"5c48c47d-f29e-4470-b3da-018d583570f0\n",
|
||
"15985709763 120天联系情况\n",
|
||
"{}\n",
|
||
"3bb9e42a-7858-4141-8189-a05c1d2453f7\n",
|
||
"15985709739 120天联系情况\n",
|
||
"{}\n"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"# 根据门店名称获取单号 + 校验公司名称是否相同，不同则继续查找\n",
|
||
"for i_two in org_name_list:\n",
|
||
" i_two_list = find_indexes(daichuli_mendian_name,i_two)[0]\n",
|
||
" if daichuli_gongsi_name[i_two_list] == gongsi_name and i_two == ALL_DATA_mengdian_name[i_two_list] :\n",
|
||
" # 开始同步节点\n",
|
||
" # 获取当前流程节点\n",
|
||
" print(ALL_DATA_id[i_two_list])\n",
|
||
" res_new_one = get_approval_records(token=TOKEN, processInstanceId=ALL_DATA_id[i_two_list])\n",
|
||
" records_new_one = res_new_one.get('result')\n",
|
||
" # 获取审批节点的 taskId\n",
|
||
" records_new_one = [item for item in records_new_one if item.get('type') == \"TODO\"]\n",
|
||
" taskId_new_one = records_new_one[0].get('taskId')\n",
|
||
" print(taskId_new_one,records_new_one[0]['showName'])\n",
|
||
" if tinydict[records_new_one[0]['showName']] > tinydict[records_new[0]['showName']] :\n",
|
||
" data_new = {}\n",
|
||
" res=aggree_approval(token=TOKEN, taskId=taskId_new_one, processInstanceId=ALL_DATA_id[i_two_list], formData=data_new,res_new =get_staffID(TOKEN,ALL_DATA_staff,records_new_one[0]['operatorName'])[0] )\n",
|
||
" print(res.json())"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 40,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"[{'processInstanceId': '5c48c47d-f29e-4470-b3da-018d583570f0',\n",
|
||
" 'showName': '120天联系情况',\n",
|
||
" 'taskHoldTimeGMT': 245130963,\n",
|
||
" 'type': 'TODO',\n",
|
||
" 'operatorName': '曹伟',\n",
|
||
" 'actionExit': 'doing',\n",
|
||
" 'operatorUserId': '2268275546837446',\n",
|
||
" 'activityId': 'sid-6470221a-82ec-4bdd-a873-245ee47a5605',\n",
|
||
" 'taskType': 'COMMON_ALL_AT_ONCE',\n",
|
||
" 'size': 1,\n",
|
||
" 'operatorDisplayName': '曹伟',\n",
|
||
" 'activeTimeGMT': '2023-08-15T14:35Z',\n",
|
||
" 'taskId': '15985709763',\n",
|
||
" 'operatorPhotoUrl': 'https://static.dingtalk.com/media/lADPDiQ3OVc5PdLNA1nNArA_688_857.jpg'}]"
|
||
]
|
||
},
|
||
"execution_count": 40,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"records_new_one"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 20,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"4"
|
||
]
|
||
},
|
||
"execution_count": 20,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"tinydict[records_new[0]['showName']]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 21,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"5"
|
||
]
|
||
},
|
||
"execution_count": 21,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"tinydict[records_new_one[0]['showName']]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 24,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"[{'processInstanceId': '3bb9e42a-7858-4141-8189-a05c1d2453f7',\n",
|
||
" 'showName': '120天联系情况',\n",
|
||
" 'taskHoldTimeGMT': 244741817,\n",
|
||
" 'type': 'TODO',\n",
|
||
" 'operatorName': '曹伟',\n",
|
||
" 'actionExit': 'doing',\n",
|
||
" 'operatorUserId': '2268275546837446',\n",
|
||
" 'activityId': 'sid-6470221a-82ec-4bdd-a873-245ee47a5605',\n",
|
||
" 'taskType': 'COMMON_ALL_AT_ONCE',\n",
|
||
" 'size': 1,\n",
|
||
" 'operatorDisplayName': '曹伟',\n",
|
||
" 'activeTimeGMT': '2023-08-15T14:35Z',\n",
|
||
" 'taskId': '15985709739',\n",
|
||
" 'operatorPhotoUrl': 'https://static.dingtalk.com/media/lADPDiQ3OVc5PdLNA1nNArA_688_857.jpg'}]"
|
||
]
|
||
},
|
||
"execution_count": 24,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"records_new_one"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 16,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"['8454ccf1-03ec-4775-b849-45dc61333acb']"
|
||
]
|
||
},
|
||
"execution_count": 16,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"if tinydict[records_new_one[0]['showName']] > tinydict[records_new[0]['showName']] :\n",
|
||
" data_new = {}\n",
|
||
" res=aggree_approval(token=TOKEN, taskId=taskId_new, processInstanceId=form_data['data'][v]['processInstanceId'], formData=data_new,res_new =get_staffID(TOKEN,ALL_DATA_staff,records_new[0]['operatorName'])[0] )\n",
|
||
" print(res.json())"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 5,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"2"
|
||
]
|
||
},
|
||
"execution_count": 5,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"i_two_list"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 11,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'creatorUserId': 'yida_pub_account',\n",
|
||
" 'formUuid': 'FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC',\n",
|
||
" 'modifiedTimeGMT': '2023-08-16T17:46Z',\n",
|
||
" 'createdTimeGMT': '2023-08-15T14:35Z',\n",
|
||
" 'formInstanceId': '8454ccf1-03ec-4775-b849-45dc61333acb',\n",
|
||
" 'originator': {'userName': {'nameInChinese': '宜搭平台',\n",
|
||
" 'nameInEnglish': 'yida',\n",
|
||
" 'type': 'i18n'},\n",
|
||
" 'userId': 'yida_pub_account'},\n",
|
||
" 'modelUuid': 'FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC',\n",
|
||
" 'title': '门店名称：测试门店1,\\n门店编码：CHS0000001,\\n待办派发时间：2023-08-15 14:35:41\\n的续约服务待办',\n",
|
||
" 'instanceValue': '[{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"测试公司\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirm9xx\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"测试门店1\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5j\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"28\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr7\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"CHS0000001\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqw\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1562688000000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5k\",\"format\":\"yyyy-MM-dd\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1667145600000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5l\",\"format\":\"yyyy-MM-dd\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr8\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_liwg9trm\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqx\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"18733037999\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqy\"},{\"componentName\":\"SelectField\",\"fieldData\":{\"value\":\"基础版\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuz7mfmc\",\"options\":[]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"SaaS续约:699.00\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kujm5mv8\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_kykw5ege\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"小六\",\"value\":\"小六\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuntp6fm\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":true,\"text\":\"小六\",\"__sid__\":\"serial_l38hvew2\",\"value\":\"小六\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"小六\",\"value\":\"小六\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuntp6fn\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":true,\"text\":\"小六\",\"__sid__\":\"serial_kuntrv8m\",\"value\":\"小六\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"小六\",\"value\":\"小六\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kurxyhvp\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":true,\"text\":\"小六\",\"__sid__\":\"serial_kuntrv8m\",\"value\":\"小六\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"小六\",\"value\":\"小六\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kurxyhvq\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":true,\"text\":\"小六\",\"__sid__\":\"serial_kuntrv8m\",\"value\":\"小六\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"是\",\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuhnydn0\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":false,\"text\":\"是\",\"__sid__\":\"serial_ksydoo24\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"是\",\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_l85ppdia\",\"options\":[{\"color\":\"#e1f7ea\",\"defaultChecked\":false,\"text\":\"是\",\"__sid__\":\"serial_ksydoo24\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_l85ppdid\",\"format\":\"yyyy-MM-dd\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"暂时没有问题\",\"value\":\"暂时没有问题\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_r3yeqvd\",\"options\":[{\"defaultChecked\":false,\"text\":\"暂时没有问题\",\"__sid__\":\"serial_lb0djmh6\",\"value\":\"暂时没有问题\",\"sid\":\"serial_lb0djmh6\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"111\"},\"fieldDataUpdated\":false,\"fieldId\":\"textAreaField_972lhkt\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_lhbkudx0\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_lhbnuvtn\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"不确定\",\"value\":\"不确定\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_l85ppdie\",\"options\":[{\"color\":\"#f2edff\",\"defaultChecked\":false,\"text\":\"不确定\",\"__sid__\":\"serial_ksydoo27\",\"value\":\"不确定\",\"sid\":\"serial_ksydoo27\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"门店原因\",\"value\":\"门店原因\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxfy\",\"options\":[{\"color\":\"#fff4e0\",\"defaultChecked\":false,\"__sid\":\"item_lk2db6gm\",\"text\":\"门店原因\",\"__sid__\":\"serial_l31cta68\",\"value\":\"门店原因\",\"sid\":\"serial_l31cta68\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxfz\",\"options\":[{\"text\":{\"pureEn_US\":\"系统功能缺失\",\"en_US\":\"系统功能缺失\",\"zh_CN\":\"系统功能缺失\",\"type\":\"JSExpression\"},\"value\":\"系统功能缺失\"},{\"text\":{\"pureEn_US\":\"系统需求、故障处理时间长\",\"en_US\":\"系统需求、故障处理时间长\",\"zh_CN\":\"系统故障\",\"type\":\"JSExpression\"},\"value\":\"系统故障\"},{\"text\":{\"pureEn_US\":\"系统操作繁琐\",\"en_US\":\"系统操作繁琐\",\"zh_CN\":\"系统操作繁琐\",\"type\":\"JSExpression\"},\"value\":\"系统操作繁琐\"},{\"text\":{\"pureEn_US\":\"系统现有功能不完全满足\",\"en_US\":\"系统现有功能不完全满足\",\"zh_CN\":\"系统功能不满足\",\"type\":\"JSExpression\"},\"value\":\"系统功能不满足\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg0\",\"options\":[{\"text\":{\"pureEn_US\":\"小六离职未能获取不续约原因\",\"en_US\":\"小六离职未能获取不续约原因\",\"zh_CN\":\"小六离职未能获取不续约原因\",\"type\":\"JSExpression\"},\"value\":\"小六离职未能获取不续约原因\"},{\"text\":{\"pureEn_US\":\"小六态度问题\",\"en_US\":\"小六态度问题\",\"zh_CN\":\"小六态度问题\",\"type\":\"JSExpression\"},\"value\":\"小六态度问题\"},{\"text\":{\"pureEn_US\":\"小六业务不专业\",\"en_US\":\"小六业务不专业\",\"zh_CN\":\"小六业务不专业\",\"type\":\"JSExpression\"},\"value\":\"小六业务不专业\"},{\"text\":{\"pureEn_US\":\"联系不上小六\",\"en_US\":\"联系不上小六\",\"zh_CN\":\"联系不上小六\",\"type\":\"JSExpression\"},\"value\":\"联系不上小六\"},{\"text\":{\"pureEn_US\":\"无人培训\",\"en_US\":\"无人培训\",\"zh_CN\":\"无人培训\",\"type\":\"JSExpression\"},\"value\":\"无人培训\"},{\"text\":{\"pureEn_US\":\"在线客服服务问题\",\"en_US\":\"在线客服服务问题\",\"zh_CN\":\"在线客服服务问题\",\"type\":\"JSExpression\"},\"value\":\"在线客服服务问题\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"value\":\"疫情原因\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg1\",\"options\":[]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg2\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"现版本价格太高\",\"type\":\"JSExpression\"},\"value\":\"现版本价格太高\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"无法接受年费制\",\"type\":\"JSExpression\"},\"value\":\"无法接受年费制\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"无法接受涨价\",\"type\":\"JSExpression\"},\"value\":\"无法接受涨价\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"竞品价格低\",\"type\":\"JSExpression\"},\"value\":\"竞品价格低\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg3\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"业绩\",\"type\":\"JSExpression\"},\"value\":\"业绩\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"采购库存\",\"type\":\"JSExpression\"},\"value\":\"采购库存\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"工单\",\"type\":\"JSExpression\"},\"value\":\"工单\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"营销\",\"type\":\"JSExpression\"},\"value\":\"营销\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"财务\",\"type\":\"JSExpression\"},\"value\":\"财务\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"客户资料相关\",\"type\":\"JSExpression\"},\"value\":\"客户资料相关\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"报表\",\"type\":\"JSExpression\"},\"value\":\"报表\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"参数设置\",\"type\":\"JSExpression\"},\"value\":\"参数设置\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"疫情开门再续\"},\"fieldDataUpdated\":false,\"fieldId\":\"textareaField_l31clxg4\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"无\",\"value\":\"无\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ljqi5we3\",\"options\":[{\"defaultChecked\":true,\"__sid\":\"item_ljqi5xlu\",\"text\":\"无\",\"__sid__\":\"serial_ljqi5xlu\",\"value\":\"无\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"测试0816\"},\"fieldDataUpdated\":false,\"fieldId\":\"textareaField_liviovx0\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"是\",\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_la7x32mq\",\"options\":[{\"defaultChecked\":false,\"text\":\"是\",\"__sid__\":\"serial_la7x55w4\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"1111\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_la7x32mp\"},{\"componentName\":\"ImageField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"imageField_la7x32mt\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"胡松林\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5h\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"13363671643\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5i\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"10\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5g\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"A\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr2\"},{\"componentName\":\"SelectField\",\"fieldData\":{\"value\":\"E.S（旧）\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuz7mfmd\",\"options\":[]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"否\",\"value\":\"否\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ktuxbopv\",\"options\":[{\"defaultChecked\":false,\"text\":\"否\",\"__sid__\":\"serial_ktv8znti\",\"value\":\"否\",\"sid\":\"serial_khe7yak5\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"value\":\"已完成\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuwa866e\",\"options\":[]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"快修快保\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr1\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"1088天\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuzcvh3b\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"普通客户（VIP）\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kycfic6o\"},{\"componentName\":\"RadioField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ll7yj7g4\",\"options\":[{\"color\":\"\",\"defaultChecked\":true,\"__sid\":\"item_ll7yj8h1\",\"text\":{\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\",\"__sid__\":\"param_ll7yj8m9\",\"value\":\"({\\\\\"en_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"zh_CN\\\\\":\\\\\"是\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"__sid__\\\\\":\\\\\"param_ll7yj8m9\\\\\",\\\\\"extType\\\\\":\\\\\"i18n\\\\\"})[this.utils.getLocale()]\",\"extType\":\"i18n\"},\"__sid__\":\"serial_ll7yj8h2\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"是\",\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ll7yj7g5\",\"options\":[{\"defaultChecked\":false,\"__sid\":\"item_ll7yj8h8\",\"text\":\"是\",\"__sid__\":\"serial_ll7yj8h9\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydght0\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6gvwd\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6gvwc\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6416i\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6416j\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksirro5o\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydghrd\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"value\":\"2268275546837446\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydghre\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"XYFWD20230809052\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuntp6fl\"},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_lgx3os2m\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr5\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"2\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr6\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"30\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr9\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghra\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"30\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghrb\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"稳定健康\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghrc\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_liwu7769\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1635609600000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5m\",\"format\":\"yyyy-MM-dd\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_lbodyv8h\"},{\"componentName\":\"MultiSelectField\",\"fieldData\":{\"value\":[\"测试门店1\",\"测试门店3\",\"测试门店2\"]},\"fieldDataUpdated\":false,\"fieldId\":\"multiSelectField_ll5x02m5\",\"options\":[{\"text\":\"测试门店1\",\"value\":\"测试门店1\"},{\"text\":\"测试门店3\",\"value\":\"测试门店3\"},{\"text\":\"测试门店2\",\"value\":\"测试门店2\"}]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kto3q3ev\"},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_kto3q3ex\",\"format\":\"yyyy-MM-dd\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"河北省\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuj8nx00\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"沧州市\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuj8nx01\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ljz74n2f\"}]',\n",
|
||
" 'version': 0,\n",
|
||
" 'modifierUserId': '2268275546837446',\n",
|
||
" 'modifyUser': {'userName': {'nameInChinese': '曹伟',\n",
|
||
" 'nameInEnglish': '曹伟',\n",
|
||
" 'type': 'i18n'},\n",
|
||
" 'userId': '2268275546837446'},\n",
|
||
" 'formData': {'employeeField_ljz6416i_id': ['2268275546837446'],\n",
|
||
" 'textField_kuj8nx00': '河北省',\n",
|
||
" 'selectField_kuz7mfmd': 'E.S（旧）',\n",
|
||
" 'textField_kuj8nx01': '沧州市',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'employeeField_ksydghrd_id': ['2268275546837446'],\n",
|
||
" 'radioField_r3yeqvd_id': '暂时没有问题',\n",
|
||
" 'textField_ksirm9xx': '测试公司',\n",
|
||
" 'selectField_l31clxg1_id': '疫情原因',\n",
|
||
" 'multiSelectField_ll5x02m5': ['测试门店1', '测试门店3', '测试门店2'],\n",
|
||
" 'selectField_kuz7mfmc': '基础版',\n",
|
||
" 'textField_liwu7769': '',\n",
|
||
" 'radioField_kurxyhvp': '小六',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'radioField_ll7yj7g5_id': '是',\n",
|
||
" 'employeeField_ksirro5o_id': ['2268275546837446'],\n",
|
||
" 'radioField_kuntp6fn_id': '小六',\n",
|
||
" 'selectField_kuz7mfmc_id': '基础版',\n",
|
||
" 'employeeField_ljz6gvwc': ['曹伟'],\n",
|
||
" 'employeeField_ljz6gvwd': ['曹伟'],\n",
|
||
" 'radioField_kuntp6fm': '小六',\n",
|
||
" 'employeeField_ljz6gvwd_id': ['2268275546837446'],\n",
|
||
" 'radioField_kuntp6fn': '小六',\n",
|
||
" 'radioField_l85ppdie': '不确定',\n",
|
||
" 'radioField_l85ppdia': '是',\n",
|
||
" 'employeeField_ljz6416j_id': ['2268275546837446'],\n",
|
||
" 'textareaField_liviovx0': '测试0816',\n",
|
||
" 'employeeField_ksydghre_id': ['2268275546837446'],\n",
|
||
" 'textField_kuzcvh3b': '1088天',\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'employeeField_ksirro5o': ['曹伟'],\n",
|
||
" 'radioField_ljqi5we3_id': '无',\n",
|
||
" 'textAreaField_972lhkt': '111',\n",
|
||
" 'textField_liwg9trm': '',\n",
|
||
" 'textField_lbodyv8h': '',\n",
|
||
" 'multiSelectField_ll5x02m5_id': ['测试门店1', '测试门店2', '测试门店3'],\n",
|
||
" 'textField_kycfic6o': '普通客户（VIP）',\n",
|
||
" 'employeeField_ksydght0': ['曹伟'],\n",
|
||
" 'textField_ksirro5g': '10',\n",
|
||
" 'textField_ksirro5h': '胡松林',\n",
|
||
" 'textField_ksirro5i': '13363671643',\n",
|
||
" 'radioField_ktuxbopv': '否',\n",
|
||
" 'textField_ksirro5j': '测试门店1',\n",
|
||
" 'textField_kto3q3ev': '',\n",
|
||
" 'employeeField_ksydghre': ['曹伟'],\n",
|
||
" 'employeeField_ksydghrd': ['曹伟'],\n",
|
||
" 'textField_ljz74n2f': '',\n",
|
||
" 'textField_ksydghqy': '18733037999',\n",
|
||
" 'employeeField_ljz6416i': ['曹伟'],\n",
|
||
" 'textField_ksydghqx': '',\n",
|
||
" 'employeeField_ljz6416j': ['曹伟'],\n",
|
||
" 'textField_ksydghqw': 'CHS0000001',\n",
|
||
" 'radioField_l85ppdia_id': '是',\n",
|
||
" 'radioField_ll7yj7g5': '是',\n",
|
||
" 'radioField_kurxyhvq_id': '小六',\n",
|
||
" 'selectField_kuwa866e': '已完成',\n",
|
||
" 'radioField_la7x32mq': '是',\n",
|
||
" 'radioField_l85ppdie_id': '不确定',\n",
|
||
" 'radioField_la7x32mq_id': '是',\n",
|
||
" 'selectField_l31clxfy_id': '门店原因',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'textField_ksydghrc': '稳定健康',\n",
|
||
" 'textField_ksydghrb': '30',\n",
|
||
" 'textField_ksydghra': '是',\n",
|
||
" 'textField_ksydghr7': '28',\n",
|
||
" 'textField_ksydghr6': '2',\n",
|
||
" 'textField_ksydghr5': '是',\n",
|
||
" 'textField_ksydghr9': '30',\n",
|
||
" 'dateField_ksirro5m': 1635609600000,\n",
|
||
" 'textField_ksydghr8': '是',\n",
|
||
" 'dateField_ksirro5l': 1667145600000,\n",
|
||
" 'dateField_ksirro5k': 1562688000000,\n",
|
||
" 'radioField_kurxyhvp_id': '小六',\n",
|
||
" 'radioField_ljqi5we3': '无',\n",
|
||
" 'textField_ksydghr2': 'A',\n",
|
||
" 'textField_ksydghr1': '快修快保',\n",
|
||
" 'radioField_kuhnydn0_id': '是',\n",
|
||
" 'employeeField_ksydght0_id': ['2268275546837446'],\n",
|
||
" 'selectField_kuz7mfmd_id': 'E.S（旧）',\n",
|
||
" 'radioField_kuntp6fm_id': '小六',\n",
|
||
" 'textField_la7x32mp': '1111',\n",
|
||
" 'employeeField_ljz6gvwc_id': ['2268275546837446'],\n",
|
||
" 'textField_kuntp6fl': 'XYFWD20230809052',\n",
|
||
" 'selectField_kuwa866e_id': '已完成',\n",
|
||
" 'radioField_ktuxbopv_id': '否',\n",
|
||
" 'radioField_r3yeqvd': '暂时没有问题',\n",
|
||
" 'textField_kujm5mv8': 'SaaS续约:699.00'}}"
|
||
]
|
||
},
|
||
"execution_count": 11,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"form_data['data'][0]['formData']['textField_ksirro5j']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 203,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"['测试公司', '测试公司', '测试公司']"
|
||
]
|
||
},
|
||
"execution_count": 203,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"ALL_DATA_id"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 151,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'测试门店2'"
|
||
]
|
||
},
|
||
"execution_count": 151,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data_NGV.loc[i_one,\"org_name\"]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 135,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/html": [
|
||
"<div>\n",
|
||
"<style scoped>\n",
|
||
" .dataframe tbody tr th:only-of-type {\n",
|
||
" vertical-align: middle;\n",
|
||
" }\n",
|
||
"\n",
|
||
" .dataframe tbody tr th {\n",
|
||
" vertical-align: top;\n",
|
||
" }\n",
|
||
"\n",
|
||
" .dataframe thead th {\n",
|
||
" text-align: right;\n",
|
||
" }\n",
|
||
"</style>\n",
|
||
"<table border=\"1\" class=\"dataframe\">\n",
|
||
" <thead>\n",
|
||
" <tr style=\"text-align: right;\">\n",
|
||
" <th></th>\n",
|
||
" <th>date_id</th>\n",
|
||
" <th>date_fmt</th>\n",
|
||
" <th>id_own_group</th>\n",
|
||
" <th>group_name</th>\n",
|
||
" <th>id_own_org</th>\n",
|
||
" <th>org_name</th>\n",
|
||
" <th>org_code</th>\n",
|
||
" <th>group_grade</th>\n",
|
||
" <th>org_type</th>\n",
|
||
" <th>org_status</th>\n",
|
||
" <th>...</th>\n",
|
||
" <th>org_size</th>\n",
|
||
" <th>qualification_type_fmt</th>\n",
|
||
" <th>business_scope_fmt</th>\n",
|
||
" <th>store_type_fmt</th>\n",
|
||
" <th>area</th>\n",
|
||
" <th>station_number</th>\n",
|
||
" <th>header_type_fmt</th>\n",
|
||
" <th>org_stage</th>\n",
|
||
" <th>g_count_this_month</th>\n",
|
||
" <th>saas_customer_type</th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>0</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>10907434497328928538</td>\n",
|
||
" <td>聚能汽修</td>\n",
|
||
" <td>10907434497328928536</td>\n",
|
||
" <td>宝顺奥迪(东莞聚能店)</td>\n",
|
||
" <td>CHS202007290101393</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>NA</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>一站式综合店</td>\n",
|
||
" <td>0.00</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>续约</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>NA</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>1</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>10907434497328986242</td>\n",
|
||
" <td>上海徐行幻锦汽车服务</td>\n",
|
||
" <td>10907434497328986240</td>\n",
|
||
" <td>上海徐行幻锦汽车服务</td>\n",
|
||
" <td>CHS202007290101404</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>小</td>\n",
|
||
" <td>三类资格</td>\n",
|
||
" <td>保养,洗车,维修,美容,轮胎</td>\n",
|
||
" <td>一站式综合店</td>\n",
|
||
" <td>200.00</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>轮胎</td>\n",
|
||
" <td>续约</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>C</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>2</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>10907434497328990208</td>\n",
|
||
" <td>车之坊汽车服务有限公司</td>\n",
|
||
" <td>10907434497328990206</td>\n",
|
||
" <td>常州车之坊汽车服务有限公司</td>\n",
|
||
" <td>CHS202007290101405</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>中</td>\n",
|
||
" <td>三类资格</td>\n",
|
||
" <td>保养,改装,洗车,维修,美容,装潢精品,轮胎,钣喷</td>\n",
|
||
" <td>一站式综合店</td>\n",
|
||
" <td>500.00</td>\n",
|
||
" <td>9</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>成长</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>D</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>3</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>10907434497329296681</td>\n",
|
||
" <td>重庆新车路科技有限公司</td>\n",
|
||
" <td>10907434497329296679</td>\n",
|
||
" <td>壹米养车（融创白象街店）</td>\n",
|
||
" <td>CHS202007290101417</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>小</td>\n",
|
||
" <td>三类资格</td>\n",
|
||
" <td>保养,洗车,维修,美容</td>\n",
|
||
" <td>快修快保店</td>\n",
|
||
" <td>120.00</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>续约</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>C</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>4</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>10907434497329485905</td>\n",
|
||
" <td>沈阳市于洪区煜玖汽车服务中心</td>\n",
|
||
" <td>10907434497329485903</td>\n",
|
||
" <td>煜玖保养</td>\n",
|
||
" <td>CHS202007300101424</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>微</td>\n",
|
||
" <td>三类资格</td>\n",
|
||
" <td>保养,维修</td>\n",
|
||
" <td>快修快保店</td>\n",
|
||
" <td>100.00</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>续约</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>A</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>...</th>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>30968</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>168822842966671386</td>\n",
|
||
" <td>泰州市泰和汽车修理厂</td>\n",
|
||
" <td>24320717914899306</td>\n",
|
||
" <td>泰州市龙顺达汽车修理厂</td>\n",
|
||
" <td>CHS201512110264</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>中</td>\n",
|
||
" <td>一类资格</td>\n",
|
||
" <td>保养,洗车,维修,轮胎,钣喷</td>\n",
|
||
" <td>一站式综合店</td>\n",
|
||
" <td>200.00</td>\n",
|
||
" <td>6</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>成熟</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>D</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>30969</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>168822842966671387</td>\n",
|
||
" <td>南通福铃快修服务中心</td>\n",
|
||
" <td>10545724654287244872</td>\n",
|
||
" <td>南通福铃汽车服务有限公司</td>\n",
|
||
" <td>CHS201803092363</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>过期</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>小</td>\n",
|
||
" <td>无维修资质</td>\n",
|
||
" <td>维修,美容,轮胎</td>\n",
|
||
" <td>快修快保店</td>\n",
|
||
" <td>200.00</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>流失</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>C</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>30970</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>168822842966671387</td>\n",
|
||
" <td>南通福铃快修服务中心</td>\n",
|
||
" <td>24329934746943958</td>\n",
|
||
" <td>南通福铃汽车服务有限公司</td>\n",
|
||
" <td>CHS201512160271</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>小</td>\n",
|
||
" <td>无维修资质</td>\n",
|
||
" <td>保养,维修</td>\n",
|
||
" <td>快修快保店</td>\n",
|
||
" <td>100.00</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>成熟</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>C</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>30971</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>24351585207892975</td>\n",
|
||
" <td>自由行快捷服务</td>\n",
|
||
" <td>24351585207892939</td>\n",
|
||
" <td>自由行汽车服务</td>\n",
|
||
" <td>CHS201604230339</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>留存</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>微</td>\n",
|
||
" <td>二类资格</td>\n",
|
||
" <td>保养,维修,轮胎</td>\n",
|
||
" <td>快修快保店</td>\n",
|
||
" <td>160.00</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>自有单店-无需选图片</td>\n",
|
||
" <td>成熟</td>\n",
|
||
" <td>16</td>\n",
|
||
" <td>A</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>30972</th>\n",
|
||
" <td>20230816</td>\n",
|
||
" <td>2023-08-16</td>\n",
|
||
" <td>24351585208096885</td>\n",
|
||
" <td>沭阳县沭城镇欧驰汽车维修部</td>\n",
|
||
" <td>24334095865624707</td>\n",
|
||
" <td>沭阳县宝沃欧驰汽车服务有限公司</td>\n",
|
||
" <td>CHS201512290282</td>\n",
|
||
" <td>普通客户（VIP）</td>\n",
|
||
" <td>一般</td>\n",
|
||
" <td>过期</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>None</td>\n",
|
||
" <td>流失</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>None</td>\n",
|
||
" </tr>\n",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"<p>30973 rows × 139 columns</p>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" date_id date_fmt id_own_group group_name \n",
|
||
"0 20230816 2023-08-16 10907434497328928538 聚能汽修 \\\n",
|
||
"1 20230816 2023-08-16 10907434497328986242 上海徐行幻锦汽车服务 \n",
|
||
"2 20230816 2023-08-16 10907434497328990208 车之坊汽车服务有限公司 \n",
|
||
"3 20230816 2023-08-16 10907434497329296681 重庆新车路科技有限公司 \n",
|
||
"4 20230816 2023-08-16 10907434497329485905 沈阳市于洪区煜玖汽车服务中心 \n",
|
||
"... ... ... ... ... \n",
|
||
"30968 20230816 2023-08-16 168822842966671386 泰州市泰和汽车修理厂 \n",
|
||
"30969 20230816 2023-08-16 168822842966671387 南通福铃快修服务中心 \n",
|
||
"30970 20230816 2023-08-16 168822842966671387 南通福铃快修服务中心 \n",
|
||
"30971 20230816 2023-08-16 24351585207892975 自由行快捷服务 \n",
|
||
"30972 20230816 2023-08-16 24351585208096885 沭阳县沭城镇欧驰汽车维修部 \n",
|
||
"\n",
|
||
" id_own_org org_name org_code group_grade \n",
|
||
"0 10907434497328928536 宝顺奥迪(东莞聚能店) CHS202007290101393 普通客户（VIP） \\\n",
|
||
"1 10907434497328986240 上海徐行幻锦汽车服务 CHS202007290101404 普通客户（VIP） \n",
|
||
"2 10907434497328990206 常州车之坊汽车服务有限公司 CHS202007290101405 普通客户（VIP） \n",
|
||
"3 10907434497329296679 壹米养车（融创白象街店） CHS202007290101417 普通客户（VIP） \n",
|
||
"4 10907434497329485903 煜玖保养 CHS202007300101424 普通客户（VIP） \n",
|
||
"... ... ... ... ... \n",
|
||
"30968 24320717914899306 泰州市龙顺达汽车修理厂 CHS201512110264 普通客户（VIP） \n",
|
||
"30969 10545724654287244872 南通福铃汽车服务有限公司 CHS201803092363 普通客户（VIP） \n",
|
||
"30970 24329934746943958 南通福铃汽车服务有限公司 CHS201512160271 普通客户（VIP） \n",
|
||
"30971 24351585207892939 自由行汽车服务 CHS201604230339 普通客户（VIP） \n",
|
||
"30972 24334095865624707 沭阳县宝沃欧驰汽车服务有限公司 CHS201512290282 普通客户（VIP） \n",
|
||
"\n",
|
||
" org_type org_status ... org_size qualification_type_fmt \n",
|
||
"0 一般 留存 ... NA None \\\n",
|
||
"1 一般 留存 ... 小 三类资格 \n",
|
||
"2 一般 留存 ... 中 三类资格 \n",
|
||
"3 一般 留存 ... 小 三类资格 \n",
|
||
"4 一般 留存 ... 微 三类资格 \n",
|
||
"... ... ... ... ... ... \n",
|
||
"30968 一般 留存 ... 中 一类资格 \n",
|
||
"30969 一般 过期 ... 小 无维修资质 \n",
|
||
"30970 一般 留存 ... 小 无维修资质 \n",
|
||
"30971 一般 留存 ... 微 二类资格 \n",
|
||
"30972 一般 过期 ... None None \n",
|
||
"\n",
|
||
" business_scope_fmt store_type_fmt area station_number \n",
|
||
"0 None 一站式综合店 0.00 0 \\\n",
|
||
"1 保养,洗车,维修,美容,轮胎 一站式综合店 200.00 3 \n",
|
||
"2 保养,改装,洗车,维修,美容,装潢精品,轮胎,钣喷 一站式综合店 500.00 9 \n",
|
||
"3 保养,洗车,维修,美容 快修快保店 120.00 4 \n",
|
||
"4 保养,维修 快修快保店 100.00 1 \n",
|
||
"... ... ... ... ... \n",
|
||
"30968 保养,洗车,维修,轮胎,钣喷 一站式综合店 200.00 6 \n",
|
||
"30969 维修,美容,轮胎 快修快保店 200.00 3 \n",
|
||
"30970 保养,维修 快修快保店 100.00 3 \n",
|
||
"30971 保养,维修,轮胎 快修快保店 160.00 2 \n",
|
||
"30972 None None None None \n",
|
||
"\n",
|
||
" header_type_fmt org_stage g_count_this_month saas_customer_type \n",
|
||
"0 None 续约 16 NA \n",
|
||
"1 轮胎 续约 16 C \n",
|
||
"2 自有单店-无需选图片 成长 16 D \n",
|
||
"3 自有单店-无需选图片 续约 16 C \n",
|
||
"4 自有单店-无需选图片 续约 16 A \n",
|
||
"... ... ... ... ... \n",
|
||
"30968 自有单店-无需选图片 成熟 16 D \n",
|
||
"30969 自有单店-无需选图片 流失 0 C \n",
|
||
"30970 自有单店-无需选图片 成熟 16 C \n",
|
||
"30971 自有单店-无需选图片 成熟 16 A \n",
|
||
"30972 None 流失 0 None \n",
|
||
"\n",
|
||
"[30973 rows x 139 columns]"
|
||
]
|
||
},
|
||
"execution_count": 135,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data_NGV"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 99,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"name": "stdout",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"读取到流程表中 3 条数据！\n",
|
||
"0 ['测试门店1', '测试门店3', '测试门店2']\n",
|
||
"{'radioField_kuntp6fm': '小六', 'radioField_kuntp6fn': '小六', 'radioField_kurxyhvp': '小六', 'radioField_kurxyhvq': '小六', 'radioField_kuhnydn0': '是', 'radioField_l85ppdia': '是', 'radioField_r3yeqvd': '暂时没有问题', 'textAreaField_972lhkt': '111', 'employeeField_lhbkudx0': [], 'textField_lhbnuvtn': '', 'radioField_l85ppdie': '不确定', 'selectField_l31clxfy': '门店原因', 'selectField_l31clxfz': '', 'selectField_l31clxg0': '', 'selectField_l31clxg1': '疫情原因', 'selectField_l31clxg2': '', 'selectField_l31clxg3': '', 'textareaField_l31clxg4': '疫情开门再续', 'radioField_ljqi5we3': '无', 'textareaField_liviovx0': '测试0816', 'radioField_la7x32mq': '是', 'textField_la7x32mp': '1111'}\n",
|
||
"16046661843 90天联系情况\n"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"TOKEN = generateToken()\n",
|
||
"# 读取 [流程]续约服务流程_复制测试0815\n",
|
||
"FORMID = \"FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC\" \n",
|
||
"# 读取[流程]新签服务流程表单\n",
|
||
"form_data = read_instances_pt(token=TOKEN, formUuid=FORMID, page=1, n=100)\n",
|
||
"PAGES = form_data.get('totalCount')//100 + 1\n",
|
||
"ALL_DATA_id = []\n",
|
||
"ALL_DATA_data = []\n",
|
||
"\"\"\" 获取全量数据 \"\"\"\n",
|
||
"for i in range(1, PAGES+1):\n",
|
||
" form_data = read_instances_pt(token=TOKEN, formUuid=FORMID, page=i, n=100)\n",
|
||
" for data in form_data.get('data'):\n",
|
||
" ALL_DATA_id.append(data[\"formInstanceId\"])\n",
|
||
" ALL_DATA_data.append(data[\"instanceValue\"])\n",
|
||
"print(f'读取到流程表中 {len(ALL_DATA_id)} 条数据！')\n",
|
||
"code_name = ['radioField_kuntp6fm','radioField_ksydghrf','dateField_ksydghri','textField_ksydghrg','dateField_ksydghrj','radioField_ksydghrk','dateField_ksydghrl','textField_ksydghrm','textField_livc8bjj','dateField_lifr1fdv','radioField_kuntp6fn','radioField_kuhnydlp','dateField_kuhnydlr','textField_kuhnydls','dateField_kuhnydlt','radioField_kuhnydlu','dateField_kuhnydlv','textField_kuhnydlw','textField_livc8bjk','dateField_lifr1fdw','radioField_kurxyhvp','radioField_kuhnydmd','dateField_kuhnydmf','textField_kuhnydmg','dateField_kuhnydmh','radioField_kuhnydmi','dateField_kuhnydmj','textField_kuhnydmk','textField_livc8bjl','dateField_lifr1fdx','radioField_kurxyhvq','radioField_kuhnydn0','dateField_kuhnydn2','textField_kuhnydn3','dateField_kuhnydn4','radioField_kuhnydn5','dateField_kuhnydn6','textField_kuhnydn7','textField_livc8bjm','dateField_lifr1fdy','radioField_l85ppdia','dateField_l85ppdib','textField_lbodyv8i','textField_l85ppdic','dateField_l85ppdid','dateField_l85ppdif','textField_l85ppdig','radioField_r3yeqvd','textAreaField_972lhkt','employeeField_lhbkudx0','textField_lhbnuvtn','selectField_lb0gxmq8','selectField_lb5xhwk4','selectField_lc70femm','radioField_l85ppdie','textField_livcjyvr','dateField_livcjyvp','selectField_l31clxfy','selectField_l31clxfz','selectField_l31clxg0','selectField_l31clxg1','selectField_l31clxg2','selectField_l31clxg3','textareaField_l31clxg4','radioField_ljqi5we3','textareaField_liviovx0','radioField_la7x32mq','textField_la7x32mp','imageField_la7x32mt']\n",
|
||
"daichuli_id = []\n",
|
||
"daichuli_value = []\n",
|
||
"daichuli_gongsiid = []\n",
|
||
"# 获取待处理的表单实例id daichuli_id\n",
|
||
"for i in range(0,len(ALL_DATA_id)):\n",
|
||
" data_json = json.loads(ALL_DATA_data[i])\n",
|
||
" # 判断是否更新\n",
|
||
" for data_json_list in data_json:\n",
|
||
" updateFormDataJson = {}\n",
|
||
" if data_json_list['fieldId'] == 'multiSelectField_ll5x02m5':\n",
|
||
" try:\n",
|
||
" fieldData = data_json_list['fieldData']['value']\n",
|
||
" if len(fieldData)>0:\n",
|
||
" # 记录表单实例id\n",
|
||
" daichuli_id.append(ALL_DATA_id[i])\n",
|
||
" daichuli_value.append(data_json_list['fieldData']['value'])\n",
|
||
" print(i,data_json_list['fieldData']['value'])\n",
|
||
" \n",
|
||
" except:\n",
|
||
" pass\n",
|
||
"# 逐条处理——————————————————————————————————————————————\n",
|
||
"tinydict = {'0天处理情况': 1, '30天联系情况': 2, '60天联系情况': 3, '90天联系情况': 4, '120天联系情况': 5}\n",
|
||
"for i in range(0,len(daichuli_id)):\n",
|
||
" # 获取可更新内容 updateFormDataJson\n",
|
||
" data_json = json.loads(ALL_DATA_data[i])\n",
|
||
" updateFormDataJson = {}\n",
|
||
" for data_json_list in data_json:\n",
|
||
" try:\n",
|
||
" if data_json_list['fieldId'] in CODE_NAME:\n",
|
||
" updateFormDataJson[data_json_list['fieldId']] = data_json_list['fieldData']['value']\n",
|
||
" except:\n",
|
||
" pass\n",
|
||
" print(updateFormDataJson)\n",
|
||
" # 获取当前流程节点\n",
|
||
" res_new = get_approval_records(token=TOKEN, processInstanceId=daichuli_id[i])\n",
|
||
" records_new = res_new.get('result')\n",
|
||
" # 获取审批节点的 taskId\n",
|
||
" records_new = [item for item in records_new if item.get('type') == \"TODO\"]\n",
|
||
" taskId_new = records_new[0].get('taskId')\n",
|
||
" print(taskId_new,records_new[0]['showName'])\n",
|
||
" # 获取待同步表单实例id"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 109,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"['8454ccf1-03ec-4775-b849-45dc61333acb',\n",
|
||
" '5c48c47d-f29e-4470-b3da-018d583570f0',\n",
|
||
" '3bb9e42a-7858-4141-8189-a05c1d2453f7']"
|
||
]
|
||
},
|
||
"execution_count": 109,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"ALL_DATA_id"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 38,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"CODE_NAME = ['radioField_kuntp6fm','radioField_ksydghrf','dateField_ksydghri','textField_ksydghrg','dateField_ksydghrj','radioField_ksydghrk','dateField_ksydghrl','textField_ksydghrm','textField_livc8bjj','dateField_lifr1fdv','radioField_kuntp6fn','radioField_kuhnydlp','dateField_kuhnydlr','textField_kuhnydls','dateField_kuhnydlt','radioField_kuhnydlu','dateField_kuhnydlv','textField_kuhnydlw','textField_livc8bjk','dateField_lifr1fdw','radioField_kurxyhvp','radioField_kuhnydmd','dateField_kuhnydmf','textField_kuhnydmg','dateField_kuhnydmh','radioField_kuhnydmi','dateField_kuhnydmj','textField_kuhnydmk','textField_livc8bjl','dateField_lifr1fdx','radioField_kurxyhvq','radioField_kuhnydn0','dateField_kuhnydn2','textField_kuhnydn3','dateField_kuhnydn4','radioField_kuhnydn5','dateField_kuhnydn6','textField_kuhnydn7','textField_livc8bjm','dateField_lifr1fdy','radioField_l85ppdia','dateField_l85ppdib','textField_lbodyv8i','textField_l85ppdic','dateField_l85ppdid','dateField_l85ppdif','textField_l85ppdig','radioField_r3yeqvd','textAreaField_972lhkt','employeeField_lhbkudx0','textField_lhbnuvtn','selectField_lb0gxmq8','selectField_lb5xhwk4','selectField_lc70femm','radioField_l85ppdie','textField_livcjyvr','dateField_livcjyvp','selectField_l31clxfy','selectField_l31clxfz','selectField_l31clxg0','selectField_l31clxg1','selectField_l31clxg2','selectField_l31clxg3','textareaField_l31clxg4','radioField_ljqi5we3','textareaField_liviovx0','radioField_la7x32mq','textField_la7x32mp','imageField_la7x32mt']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 71,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"updateFormDataJson = {}\n",
|
||
"for i in range(0,len(ALL_DATA_id)):\n",
|
||
" data_json = json.loads(ALL_DATA_data[i])\n",
|
||
" for data_json_list in data_json:\n",
|
||
" try:\n",
|
||
" if data_json_list['fieldId'] in CODE_NAME:\n",
|
||
" updateFormDataJson[data_json_list['fieldId']] = data_json_list['fieldData']['value']\n",
|
||
" except:\n",
|
||
" pass"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 31,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"name": "stdout",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"0 ['测试门店1', '测试门店3', '测试门店2']\n"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"for i in range(0,len(ALL_DATA_id)):\n",
|
||
" data_json = json.loads(ALL_DATA_data[i])\n",
|
||
" for data_json_list in data_json:\n",
|
||
" if data_json_list['fieldId'] == 'multiSelectField_ll5x02m5':\n",
|
||
" try:\n",
|
||
" fieldData = data_json_list['fieldData']['value']\n",
|
||
" if len(fieldData)>0:\n",
|
||
" # 开始处理-----------------------------------------------------\n",
|
||
" print(i,data_json_list['fieldData']['value'])\n",
|
||
" # 获取待更新字段，将数据进行同步\n",
|
||
" \n",
|
||
" except:\n",
|
||
" pass"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": null,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"if data_json_list['fieldId'] != 'multiSelectField_ll5x02m5':"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 72,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'radioField_kuntp6fm': '系统',\n",
|
||
" 'radioField_kuntp6fn': '系统',\n",
|
||
" 'radioField_kurxyhvp': '系统',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'radioField_l85ppdia': '',\n",
|
||
" 'radioField_r3yeqvd': '',\n",
|
||
" 'textAreaField_972lhkt': '',\n",
|
||
" 'employeeField_lhbkudx0': [],\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'radioField_l85ppdie': '',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'selectField_l31clxfz': '',\n",
|
||
" 'selectField_l31clxg0': '',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'selectField_l31clxg2': '',\n",
|
||
" 'selectField_l31clxg3': '',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'radioField_ljqi5we3': '',\n",
|
||
" 'textareaField_liviovx0': '',\n",
|
||
" 'radioField_la7x32mq': '',\n",
|
||
" 'textField_la7x32mp': ''}"
|
||
]
|
||
},
|
||
"execution_count": 72,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"updateFormDataJson"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 45,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'componentName': 'TextField',\n",
|
||
" 'fieldData': {'value': ''},\n",
|
||
" 'fieldDataUpdated': False,\n",
|
||
" 'fieldId': 'textField_ljz74n2f'}"
|
||
]
|
||
},
|
||
"execution_count": 45,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data_json_list"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 9,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'测试公司'"
|
||
]
|
||
},
|
||
"execution_count": 9,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data = json.loads(ALL_DATA_data[i])\n",
|
||
"data[0]['fieldData']['value']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 32,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"for data in ALL_DATA_code:\n",
|
||
" res = instances_id(TOKEN,FORMID,data)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 42,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"ename": "NameError",
|
||
"evalue": "name 'res' is not defined",
|
||
"output_type": "error",
|
||
"traceback": [
|
||
"\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
|
||
"\u001b[1;31mNameError\u001b[0m Traceback (most recent call last)",
|
||
"\u001b[1;32m<ipython-input-42-c08785e04264>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mres\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
|
||
"\u001b[1;31mNameError\u001b[0m: name 'res' is not defined"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"res"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 40,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'creatorUserId': 'yida_pub_account',\n",
|
||
" 'formUuid': 'FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC',\n",
|
||
" 'modifiedTimeGMT': '2023-08-15T14:35Z',\n",
|
||
" 'createdTimeGMT': '2023-08-15T14:35Z',\n",
|
||
" 'formInstanceId': '3bb9e42a-7858-4141-8189-a05c1d2453f7',\n",
|
||
" 'originator': {'userName': {'nameInChinese': '宜搭平台',\n",
|
||
" 'nameInEnglish': 'yida',\n",
|
||
" 'type': 'i18n'},\n",
|
||
" 'userId': 'yida_pub_account'},\n",
|
||
" 'modelUuid': 'FORM-5L666481EBADF46Y5O7HC8ZX5MW42TN7DXBLLC',\n",
|
||
" 'title': '门店名称：测试门店2,\\n门店编码：CHS0000002,\\n待办派发时间：2023-08-15 14:35:41\\n的续约服务待办',\n",
|
||
" 'instanceValue': '[{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"测试公司\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirm9xx\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"测试门店2\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5j\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"28\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr7\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"CHS0000002\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqw\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1562688000000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5k\",\"format\":\"YYYY-MM-DD\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1667145600000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5l\",\"format\":\"YYYY-MM-DD\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr8\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_liwg9trm\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqx\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"18733037999\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghqy\"},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"基础版\",\"value\":\"基础版\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuz7mfmc\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"尊享版\",\"type\":\"JSExpression\"},\"value\":\"35\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"皇冠版\",\"type\":\"JSExpression\"},\"value\":\"50\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"至尊版\",\"type\":\"JSExpression\"},\"value\":\"40\"},{\"text\":{\"pureEn_US\":\"Option 3\",\"en_US\":\"Option 3\",\"zh_CN\":\"旗舰版\",\"type\":\"JSExpression\"},\"value\":\"30\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"标准版\",\"type\":\"JSExpression\"},\"value\":\"20\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"基础版\",\"type\":\"JSExpression\"},\"value\":\"10\"},{\"text\":\"基础版\",\"value\":\"基础版\"}]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"SaaS续约:699.00\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kujm5mv8\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_kykw5ege\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"系统\\\\\"}\",\"value\":\"系统\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuntp6fm\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"小六\",\"type\":\"JSExpression\"},\"value\":\"小六\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"系统\",\"type\":\"JSExpression\"},\"value\":\"系统\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"系统\\\\\"}\",\"value\":\"系统\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuntp6fn\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"小六\",\"type\":\"JSExpression\"},\"value\":\"小六\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"系统\",\"type\":\"JSExpression\"},\"value\":\"系统\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"系统\\\\\"}\",\"value\":\"系统\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kurxyhvp\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"小六\",\"type\":\"JSExpression\"},\"value\":\"小六\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"系统\",\"type\":\"JSExpression\"},\"value\":\"系统\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"小六\\\\\"}\",\"value\":\"小六\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kurxyhvq\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"小六\",\"type\":\"JSExpression\"},\"value\":\"小六\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"系统\",\"type\":\"JSExpression\"},\"value\":\"系统\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"是\\\\\"}\",\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_kuhnydn0\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"否\",\"type\":\"JSExpression\"},\"value\":\"否\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\"},\"value\":\"是\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_l85ppdia\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"否\",\"type\":\"JSExpression\"},\"value\":\"否\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\"},\"value\":\"是\"}]},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_l85ppdid\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_r3yeqvd\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 3\",\"en_US\":\"Option 3\",\"zh_CN\":\"价格问题\",\"type\":\"JSExpression\"},\"value\":\"价格问题\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"门店问题\",\"type\":\"JSExpression\"},\"value\":\"门店问题\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"产品问题\",\"type\":\"JSExpression\"},\"value\":\"产品问题\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"暂时没有问题\",\"type\":\"JSExpression\"},\"value\":\"暂时没有问题\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"暂无法获取问题\",\"type\":\"JSExpression\"},\"value\":\"暂无法获取问题\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"服务问题\",\"type\":\"JSExpression\"},\"value\":\"服务问题\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textAreaField_972lhkt\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_lhbkudx0\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_lhbnuvtn\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_l85ppdie\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"否\",\"type\":\"JSExpression\"},\"value\":\"否\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"不确定\",\"type\":\"JSExpression\"},\"value\":\"不确定\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\"},\"value\":\"是\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"New Option\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"New Option\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"门店原因\\\\\"}\",\"value\":\"门店原因\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxfy\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"价格问题\",\"type\":\"JSExpression\"},\"value\":\"价格问题\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"门店原因\",\"type\":\"JSExpression\"},\"value\":\"门店原因\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"产品原因\",\"type\":\"JSExpression\"},\"value\":\"产品原因\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"待召回\",\"type\":\"JSExpression\"},\"value\":\"待召回\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"服务问题\",\"type\":\"JSExpression\"},\"value\":\"服务问题\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxfz\",\"options\":[{\"text\":{\"pureEn_US\":\"系统功能缺失\",\"en_US\":\"系统功能缺失\",\"zh_CN\":\"系统功能缺失\",\"type\":\"JSExpression\"},\"value\":\"系统功能缺失\"},{\"text\":{\"pureEn_US\":\"系统需求、故障处理时间长\",\"en_US\":\"系统需求、故障处理时间长\",\"zh_CN\":\"系统故障\",\"type\":\"JSExpression\"},\"value\":\"系统故障\"},{\"text\":{\"pureEn_US\":\"系统操作繁琐\",\"en_US\":\"系统操作繁琐\",\"zh_CN\":\"系统操作繁琐\",\"type\":\"JSExpression\"},\"value\":\"系统操作繁琐\"},{\"text\":{\"pureEn_US\":\"系统现有功能不完全满足\",\"en_US\":\"系统现有功能不完全满足\",\"zh_CN\":\"系统功能不满足\",\"type\":\"JSExpression\"},\"value\":\"系统功能不满足\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg0\",\"options\":[{\"text\":{\"pureEn_US\":\"小六离职未能获取不续约原因\",\"en_US\":\"小六离职未能获取不续约原因\",\"zh_CN\":\"小六离职未能获取不续约原因\",\"type\":\"JSExpression\"},\"value\":\"小六离职未能获取不续约原因\"},{\"text\":{\"pureEn_US\":\"小六态度问题\",\"en_US\":\"小六态度问题\",\"zh_CN\":\"小六态度问题\",\"type\":\"JSExpression\"},\"value\":\"小六态度问题\"},{\"text\":{\"pureEn_US\":\"小六业务不专业\",\"en_US\":\"小六业务不专业\",\"zh_CN\":\"小六业务不专业\",\"type\":\"JSExpression\"},\"value\":\"小六业务不专业\"},{\"text\":{\"pureEn_US\":\"联系不上小六\",\"en_US\":\"联系不上小六\",\"zh_CN\":\"联系不上小六\",\"type\":\"JSExpression\"},\"value\":\"联系不上小六\"},{\"text\":{\"pureEn_US\":\"无人培训\",\"en_US\":\"无人培训\",\"zh_CN\":\"无人培训\",\"type\":\"JSExpression\"},\"value\":\"无人培训\"},{\"text\":{\"pureEn_US\":\"在线客服服务问题\",\"en_US\":\"在线客服服务问题\",\"zh_CN\":\"在线客服服务问题\",\"type\":\"JSExpression\"},\"value\":\"在线客服服务问题\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"疫情原因\",\"value\":\"疫情原因\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg1\",\"options\":[{\"text\":{\"pureEn_US\":\"老板/老板娘不想用系统管理门店\",\"en_US\":\"老板/老板娘不想用系统管理门店\",\"zh_CN\":\"老板/老板娘不想用系统管理门店\",\"type\":\"JSExpression\"},\"value\":\"老板/老板娘不想用系统管理门店\"},{\"text\":{\"pureEn_US\":\"加盟途虎养车\",\"en_US\":\"加盟途虎养车\",\"zh_CN\":\"加盟途虎养车\",\"type\":\"JSExpression\"},\"value\":\"加盟途虎养车\"},{\"text\":{\"pureEn_US\":\"加盟天猫养车\",\"en_US\":\"加盟天猫养车\",\"zh_CN\":\"加盟天猫养车\",\"type\":\"JSExpression\"},\"value\":\"加盟天猫养车\"},{\"text\":{\"pureEn_US\":\"加盟其他连锁\",\"en_US\":\"加盟其他连锁\",\"zh_CN\":\"加盟其他连锁\",\"type\":\"JSExpression\"},\"value\":\"加盟其他连锁\"},{\"text\":{\"pureEn_US\":\"门店内部问题/股东问题\",\"en_US\":\"门店内部问题/股东问题\",\"zh_CN\":\"门店内部问题/股东问题\",\"type\":\"JSExpression\"},\"value\":\"门店内部问题/股东问题\"},{\"text\":{\"pureEn_US\":\"虚拟总部\",\"en_US\":\"虚拟总部\",\"zh_CN\":\"虚拟门店\",\"type\":\"JSExpression\"},\"value\":\"虚拟门店\"},{\"text\":{\"pureEn_US\":\"门店废弃/废弃重开\",\"en_US\":\"门店废弃/废弃重开\",\"zh_CN\":\"门店废弃/废弃重开\",\"type\":\"JSExpression\"},\"value\":\"门店废弃/废弃重开\"},{\"text\":{\"pureEn_US\":\"门店附近修路/断网/装修/搬迁/分家\",\"en_US\":\"门店附近修路/断网/装修/搬迁/分家\",\"zh_CN\":\"修路/断网/装修/搬迁/分家\",\"type\":\"JSExpression\"},\"value\":\"修路/断网/装修/搬迁/分家\"},{\"text\":{\"pureEn_US\":\"担心数据安全\",\"en_US\":\"担心数据安全\",\"zh_CN\":\"担心数据安全\",\"type\":\"JSExpression\"},\"value\":\"担心数据安全\"},{\"text\":{\"pureEn_US\":\"生意不好\",\"en_US\":\"生意不好\",\"zh_CN\":\"生意不好\",\"type\":\"JSExpression\"},\"value\":\"生意不好\"},{\"text\":{\"pureEn_US\":\"只用非SaaS功能（智能货柜/安装服务/数据查询）\",\"en_US\":\"只用非SaaS功能（智能货柜/安装服务/数据查询）\",\"zh_CN\":\"智能货柜/安装服务/数据查询/电子档案\",\"type\":\"JSExpression\"},\"value\":\"智能货柜/安装服务/数据查询/电子档案\"},{\"text\":{\"pureEn_US\":\"加盟轻连锁（修工坊/金铁橡）\",\"en_US\":\"加盟轻连锁（修工坊/金铁橡）\",\"zh_CN\":\"加盟轻连锁\",\"type\":\"JSExpression\"},\"value\":\"加盟轻连锁\"},{\"text\":{\"pureEn_US\":\"只用SaaS部分功能\",\"en_US\":\"只用SaaS部分功能\",\"zh_CN\":\"只用SaaS部分功能\",\"type\":\"JSExpression\"},\"value\":\"只用SaaS部分功能\"},{\"text\":{\"pureEn_US\":\"门店转让\",\"en_US\":\"门店转让\",\"zh_CN\":\"门店转让\",\"type\":\"JSExpression\"},\"value\":\"门店转让\"},{\"text\":{\"pureEn_US\":\"加盟京车汇\",\"en_US\":\"加盟京车汇\",\"zh_CN\":\"加盟京车汇\",\"type\":\"JSExpression\"},\"value\":\"加盟京车汇\"},{\"text\":{\"pureEn_US\":\"员工离职/无专人操作/员工不想用\",\"en_US\":\"员工离职/无专人操作/员工不想用\",\"zh_CN\":\"员工离职/无专人操作/员工不想用\",\"type\":\"JSExpression\"},\"value\":\"员工离职/无专人操作/员工不想用\"},{\"text\":{\"pureEn_US\":\"加盟零公里\",\"en_US\":\"加盟零公里\",\"zh_CN\":\"加盟零公里\",\"type\":\"JSExpression\"},\"value\":\"加盟零公里\"},{\"text\":{\"pureEn_US\":\"门店倒闭\",\"en_US\":\"门店倒闭\",\"zh_CN\":\"门店倒闭\",\"type\":\"JSExpression\"},\"value\":\"门店倒闭\"},{\"text\":{\"pureEn_US\":\"联系不上客户\",\"en_US\":\"联系不上客户\",\"zh_CN\":\"联系不上客户\",\"type\":\"JSExpression\"},\"value\":\"联系不上客户\"},{\"text\":\"疫情原因\",\"value\":\"疫情原因\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg2\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"现版本价格太高\",\"type\":\"JSExpression\"},\"value\":\"现版本价格太高\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"无法接受年费制\",\"type\":\"JSExpression\"},\"value\":\"无法接受年费制\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"无法接受涨价\",\"type\":\"JSExpression\"},\"value\":\"无法接受涨价\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"竞品价格低\",\"type\":\"JSExpression\"},\"value\":\"竞品价格低\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_l31clxg3\",\"options\":[{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"业绩\",\"type\":\"JSExpression\"},\"value\":\"业绩\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"采购库存\",\"type\":\"JSExpression\"},\"value\":\"采购库存\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"工单\",\"type\":\"JSExpression\"},\"value\":\"工单\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"营销\",\"type\":\"JSExpression\"},\"value\":\"营销\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"财务\",\"type\":\"JSExpression\"},\"value\":\"财务\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"客户资料相关\",\"type\":\"JSExpression\"},\"value\":\"客户资料相关\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"报表\",\"type\":\"JSExpression\"},\"value\":\"报表\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"参数设置\",\"type\":\"JSExpression\"},\"value\":\"参数设置\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"疫情开门再续\"},\"fieldDataUpdated\":false,\"fieldId\":\"textareaField_l31clxg4\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ljqi5we3\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"无\",\"type\":\"JSExpression\"},\"value\":\"无\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"有商机\",\"type\":\"JSExpression\"},\"value\":\"有商机\"}]},{\"componentName\":\"TextareaField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textareaField_liviovx0\"},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"\",\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_la7x32mq\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"否\",\"type\":\"JSExpression\"},\"value\":\"否\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\"},\"value\":\"是\"}]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_la7x32mp\"},{\"componentName\":\"ImageField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"imageField_la7x32mt\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"胡松林\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5h\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"13363671643\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5i\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"10\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksirro5g\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"A\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr2\"},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"E.S（旧）\",\"value\":\"E.S（旧）\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuz7mfmd\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 3\",\"en_US\":\"Option 3\",\"zh_CN\":\"E.L\",\"type\":\"JSExpression\"},\"value\":\"35\"},{\"text\":{\"pureEn_US\":\"New Option\",\"en_US\":\"New Option\",\"zh_CN\":\"Tmall\",\"type\":\"JSExpression\"},\"value\":\"40\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"E.L（旧）\",\"type\":\"JSExpression\"},\"value\":\"30\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"E.S（旧）\",\"type\":\"JSExpression\"},\"value\":\"10\"},{\"text\":\"E.S（旧）\",\"value\":\"E.S（旧）\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{\"text\":\"{\\\\\"en_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"pureEn_US\\\\\":\\\\\"Option 2\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"zh_CN\\\\\":\\\\\"否\\\\\"}\",\"value\":\"否\"},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ktuxbopv\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"否\",\"type\":\"JSExpression\"},\"value\":\"否\"},{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\"},\"value\":\"是\"}]},{\"componentName\":\"SelectField\",\"fieldData\":{\"text\":\"已完成\",\"value\":\"已完成\"},\"fieldDataUpdated\":false,\"fieldId\":\"selectField_kuwa866e\",\"options\":[{\"text\":{\"pureEn_US\":\"Option 1\",\"en_US\":\"Option 1\",\"zh_CN\":\"进行中\",\"type\":\"JSExpression\"},\"value\":\"1\"},{\"text\":{\"pureEn_US\":\"Option 2\",\"en_US\":\"Option 2\",\"zh_CN\":\"已完成\",\"type\":\"JSExpression\"},\"value\":\"3\"},{\"text\":{\"pureEn_US\":\"Option 3\",\"en_US\":\"Option 3\",\"zh_CN\":\"已终止\",\"type\":\"JSExpression\"},\"value\":\"4\"},{\"text\":\"已完成\",\"value\":\"已完成\"}]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"快修快保\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr1\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"1088天\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuzcvh3b\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"普通客户（VIP）\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kycfic6o\"},{\"componentName\":\"RadioField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ll7yj7g4\",\"options\":[{\"color\":\"\",\"defaultChecked\":true,\"__sid\":\"item_ll7yj8h1\",\"text\":{\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\",\"__sid__\":\"param_ll7yj8m9\",\"value\":\"({\\\\\"en_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"zh_CN\\\\\":\\\\\"是\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"__sid__\\\\\":\\\\\"param_ll7yj8m9\\\\\",\\\\\"extType\\\\\":\\\\\"i18n\\\\\"})[this.utils.getLocale()]\",\"extType\":\"i18n\"},\"__sid__\":\"serial_ll7yj8h2\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"}]},{\"componentName\":\"RadioField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"radioField_ll7yj7g5\",\"options\":[{\"defaultChecked\":false,\"__sid\":\"item_ll7yj8h8\",\"text\":{\"en_US\":\"Option 1\",\"zh_CN\":\"是\",\"type\":\"JSExpression\",\"__sid__\":\"param_ll7yj8l3\",\"value\":\"({\\\\\"en_US\\\\\":\\\\\"Option 1\\\\\",\\\\\"zh_CN\\\\\":\\\\\"是\\\\\",\\\\\"type\\\\\":\\\\\"JSExpression\\\\\",\\\\\"__sid__\\\\\":\\\\\"param_ll7yj8l3\\\\\",\\\\\"extType\\\\\":\\\\\"i18n\\\\\"})[this.utils.getLocale()]\",\"extType\":\"i18n\"},\"__sid__\":\"serial_ll7yj8h9\",\"value\":\"是\",\"sid\":\"serial_khe7yak4\"},{\"defaultChecked\":false,\"__sid\":\"item_ll7yj8hb\",\"text\":{\"en_US\":\"New Option\",\"use\":\"zh_CN\",\"zh_CN\":\"否\",\"type\":\"JSExpression\",\"__sid__\":\"param_ll7yj8ll\",\"value\":\"\\\\\"否\\\\\"\",\"extType\":\"i18n\"},\"__sid__\":\"serial_ll7yj8hc\",\"value\":\"否\",\"sid\":\"serial_ll7yj8hc\"}]},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydght0\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6gvwd\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6gvwc\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6416i\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ljz6416j\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksirro5o\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydghrd\"},{\"componentName\":\"EmployeeField\",\"fieldData\":{\"value\":[{\"label\":\"曹伟\",\"key\":\"2268275546837446\"}]},\"fieldDataUpdated\":false,\"fieldId\":\"employeeField_ksydghre\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"XYFWD20230809052\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuntp6fl\"},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_lgx3os2m\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr5\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"2\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr6\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"30\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghr9\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"是\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghra\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"30\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghrb\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"稳定健康\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ksydghrc\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_liwu7769\"},{\"componentName\":\"DateField\",\"fieldData\":{\"value\":1635609600000},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_ksirro5m\",\"format\":\"YYYY-MM-DD\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_lbodyv8h\"},{\"componentName\":\"MultiSelectField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"multiSelectField_ll5x02m5\",\"options\":[]},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kto3q3ev\"},{\"componentName\":\"DateField\",\"fieldData\":{},\"fieldDataUpdated\":false,\"fieldId\":\"dateField_kto3q3ex\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"河北省\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuj8nx00\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"沧州市\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_kuj8nx01\"},{\"componentName\":\"TextField\",\"fieldData\":{\"value\":\"\"},\"fieldDataUpdated\":false,\"fieldId\":\"textField_ljz74n2f\"}]',\n",
|
||
" 'version': 0,\n",
|
||
" 'modifierUserId': 'yida_pub_account',\n",
|
||
" 'modifyUser': {'userName': {'nameInChinese': '宜搭平台',\n",
|
||
" 'nameInEnglish': 'yida',\n",
|
||
" 'type': 'i18n'},\n",
|
||
" 'userId': 'yida_pub_account'},\n",
|
||
" 'formData': {'employeeField_ljz6416i_id': ['2268275546837446'],\n",
|
||
" 'textField_kuj8nx00': '河北省',\n",
|
||
" 'selectField_kuz7mfmd': 'E.S（旧）',\n",
|
||
" 'textField_kuj8nx01': '沧州市',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'employeeField_ksydghrd_id': ['2268275546837446'],\n",
|
||
" 'textField_ksirm9xx': '测试公司',\n",
|
||
" 'selectField_l31clxg1_id': '疫情原因',\n",
|
||
" 'selectField_kuz7mfmc': '基础版',\n",
|
||
" 'textField_liwu7769': '',\n",
|
||
" 'radioField_kurxyhvp': '系统',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'employeeField_ksirro5o_id': ['2268275546837446'],\n",
|
||
" 'radioField_kuntp6fn_id': '系统',\n",
|
||
" 'selectField_kuz7mfmc_id': '基础版',\n",
|
||
" 'employeeField_ljz6gvwc': ['曹伟'],\n",
|
||
" 'employeeField_ljz6gvwd': ['曹伟'],\n",
|
||
" 'radioField_kuntp6fm': '系统',\n",
|
||
" 'employeeField_ljz6gvwd_id': ['2268275546837446'],\n",
|
||
" 'radioField_kuntp6fn': '系统',\n",
|
||
" 'employeeField_ljz6416j_id': ['2268275546837446'],\n",
|
||
" 'textareaField_liviovx0': '',\n",
|
||
" 'employeeField_ksydghre_id': ['2268275546837446'],\n",
|
||
" 'textField_kuzcvh3b': '1088天',\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'employeeField_ksirro5o': ['曹伟'],\n",
|
||
" 'textAreaField_972lhkt': '',\n",
|
||
" 'textField_liwg9trm': '',\n",
|
||
" 'textField_lbodyv8h': '',\n",
|
||
" 'textField_kycfic6o': '普通客户（VIP）',\n",
|
||
" 'employeeField_ksydght0': ['曹伟'],\n",
|
||
" 'textField_ksirro5g': '10',\n",
|
||
" 'textField_ksirro5h': '胡松林',\n",
|
||
" 'textField_ksirro5i': '13363671643',\n",
|
||
" 'radioField_ktuxbopv': '否',\n",
|
||
" 'textField_ksirro5j': '测试门店2',\n",
|
||
" 'textField_kto3q3ev': '',\n",
|
||
" 'employeeField_ksydghre': ['曹伟'],\n",
|
||
" 'employeeField_ksydghrd': ['曹伟'],\n",
|
||
" 'textField_ljz74n2f': '',\n",
|
||
" 'textField_ksydghqy': '18733037999',\n",
|
||
" 'employeeField_ljz6416i': ['曹伟'],\n",
|
||
" 'textField_ksydghqx': '',\n",
|
||
" 'employeeField_ljz6416j': ['曹伟'],\n",
|
||
" 'textField_ksydghqw': 'CHS0000002',\n",
|
||
" 'radioField_kurxyhvq_id': '小六',\n",
|
||
" 'selectField_kuwa866e': '已完成',\n",
|
||
" 'selectField_l31clxfy_id': '门店原因',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'textField_ksydghrc': '稳定健康',\n",
|
||
" 'textField_ksydghrb': '30',\n",
|
||
" 'textField_ksydghra': '是',\n",
|
||
" 'textField_ksydghr7': '28',\n",
|
||
" 'textField_ksydghr6': '2',\n",
|
||
" 'textField_ksydghr5': '是',\n",
|
||
" 'textField_ksydghr9': '30',\n",
|
||
" 'dateField_ksirro5m': 1635609600000,\n",
|
||
" 'textField_ksydghr8': '是',\n",
|
||
" 'dateField_ksirro5l': 1667145600000,\n",
|
||
" 'dateField_ksirro5k': 1562688000000,\n",
|
||
" 'radioField_kurxyhvp_id': '系统',\n",
|
||
" 'textField_ksydghr2': 'A',\n",
|
||
" 'textField_ksydghr1': '快修快保',\n",
|
||
" 'radioField_kuhnydn0_id': '是',\n",
|
||
" 'employeeField_ksydght0_id': ['2268275546837446'],\n",
|
||
" 'selectField_kuz7mfmd_id': 'E.S（旧）',\n",
|
||
" 'radioField_kuntp6fm_id': '系统',\n",
|
||
" 'textField_la7x32mp': '',\n",
|
||
" 'employeeField_ljz6gvwc_id': ['2268275546837446'],\n",
|
||
" 'textField_kuntp6fl': 'XYFWD20230809052',\n",
|
||
" 'selectField_kuwa866e_id': '已完成',\n",
|
||
" 'radioField_ktuxbopv_id': '否',\n",
|
||
" 'textField_kujm5mv8': 'SaaS续约:699.00'}}"
|
||
]
|
||
},
|
||
"execution_count": 40,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 23,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"code_zhu = data['formData']['textField_ll4xtlp8']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 24,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'CHS0000001'"
|
||
]
|
||
},
|
||
"execution_count": 24,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"code_zhu"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 44,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"def read_form_instances_v2(token, formInstanceId):\n",
|
||
" \"\"\" 函数功能：调用本接口通过表单实例ID查询表单数据。 -- 应用：F6客户服务 \"\"\"\n",
|
||
"\n",
|
||
" api = f'https://api.dingtalk.com/v1.0/yida/forms/instances/{formInstanceId}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=yida_pub_account&language=zh_CN'\n",
|
||
"\n",
|
||
" headers = {\n",
|
||
" \"Content-Type\": \"application/json\",\n",
|
||
" \"x-acs-dingtalk-access-token\": token\n",
|
||
" }\n",
|
||
"\n",
|
||
" res = requests.get(api, headers=headers)\n",
|
||
" return res.json()\n",
|
||
"formInstanceId = res['data'][0]['formInstanceId']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 45,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"aaa = read_form_instances_v2(TOKEN, formInstanceId)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 46,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"bbb = aaa['formData']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 54,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"ccc = [ 'textField_ksirm9xx' , 'dateField_ksirro5k' , 'textField_ksydghqx' , 'selectField_kuz7mfmc' , 'textField_ksirro5j' , 'dateField_ksirro5l' , 'textField_ksydghqy' , 'textField_kujm5mv8' , 'textField_ksydghr7' , 'textField_ksydghr8' , 'employeeField_kykw5ege' , 'textField_ksydghqw' , 'textField_liwg9trm' , 'textField_ksirro5h' , 'employeeField_ksydght0' , 'textField_ksydghr5' , 'textField_kto3q3ev' , 'textField_ksirro5i' , 'employeeField_ljz6gvwd' , 'textField_ksydghr6' , 'dateField_kto3q3ex' , 'textField_ksirro5g' , 'employeeField_ljz6gvwc' , 'textField_ksydghr9' , 'textField_kyjy1kkn' , 'textField_ksydghr2' , 'employeeField_ljz6416i' , 'textField_ksydghra' , 'textField_kyjy1kkm' , 'selectField_kuz7mfmd' , 'employeeField_ljz6416j' , 'textField_ksydghrb' , 'dateField_ksirro5n' , 'radioField_ktuxbopv' , 'employeeField_ksirro5o' , 'textField_ksydghrc' , 'textField_kuj8nx00' , 'selectField_kuwa866e' , 'employeeField_ksydghrd' , 'textField_liwu7769' , 'textField_kuj8nx01' , 'textField_ksydghr1' , 'employeeField_ksydghre' , 'dateField_ksirro5m' , 'textField_kuntp6fl' , 'textField_lbodyv8h' , 'textField_kuntp6fj' , 'textField_kycfic6o' , 'dateField_lgx3os2m' , 'textField_kuntp6fk' , 'textField_ljz74n2f' ]\n",
|
||
"for ddd in ccc:\n",
|
||
" try:\n",
|
||
" del bbb[ddd]\n",
|
||
" except:\n",
|
||
" pass"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": null,
|
||
"metadata": {},
|
||
"outputs": [],
|
||
"source": [
|
||
"del bbb['textField_ksirm9xx']\n",
|
||
"del bbb['dateField_ksirro5k']\n",
|
||
"del bbb['textField_ksydghqx']\n",
|
||
"del bbb['selectField_kuz7mfmc']\n",
|
||
"del bbb['textField_ksirro5j']\n",
|
||
"del bbb['dateField_ksirro5l']\n",
|
||
"del bbb['textField_ksydghqy']\n",
|
||
"del bbb['textField_kujm5mv8']\n",
|
||
"del bbb['textField_ksydghr7']\n",
|
||
"del bbb['textField_ksydghr8']\n",
|
||
"del bbb['employeeField_kykw5ege']\n",
|
||
"del bbb['textField_ksydghqw']\n",
|
||
"del bbb['textField_liwg9trm']\n",
|
||
"del bbb['textField_ksirro5h']\n",
|
||
"del bbb['employeeField_ksydght0']\n",
|
||
"del bbb['textField_ksydghr5']\n",
|
||
"del bbb['textField_kto3q3ev']\n",
|
||
"del bbb['textField_ksirro5i']\n",
|
||
"del bbb['employeeField_ljz6gvwd']\n",
|
||
"del bbb['textField_ksydghr6']\n",
|
||
"del bbb['dateField_kto3q3ex']\n",
|
||
"del bbb['textField_ksirro5g']\n",
|
||
"del bbb['employeeField_ljz6gvwc']\n",
|
||
"del bbb['textField_ksydghr9']\n",
|
||
"del bbb['textField_kyjy1kkn']\n",
|
||
"del bbb['textField_ksydghr2']\n",
|
||
"del bbb['employeeField_ljz6416i']\n",
|
||
"del bbb['textField_ksydghra']\n",
|
||
"del bbb['textField_kyjy1kkm']\n",
|
||
"del bbb['selectField_kuz7mfmd']\n",
|
||
"del bbb['employeeField_ljz6416j']\n",
|
||
"del bbb['textField_ksydghrb']\n",
|
||
"del bbb['dateField_ksirro5n']\n",
|
||
"del bbb['radioField_ktuxbopv']\n",
|
||
"del bbb['employeeField_ksirro5o']\n",
|
||
"del bbb['textField_ksydghrc']\n",
|
||
"del bbb['textField_kuj8nx00']\n",
|
||
"del bbb['selectField_kuwa866e']\n",
|
||
"del bbb['employeeField_ksydghrd']\n",
|
||
"del bbb['textField_liwu7769']\n",
|
||
"del bbb['textField_kuj8nx01']\n",
|
||
"del bbb['textField_ksydghr1']\n",
|
||
"del bbb['employeeField_ksydghre']\n",
|
||
"del bbb['dateField_ksirro5m']\n",
|
||
"del bbb['textField_kuntp6fl']\n",
|
||
"del bbb['textField_lbodyv8h']\n",
|
||
"del bbb['textField_kuntp6fj']\n",
|
||
"del bbb['textField_kycfic6o']\n",
|
||
"del bbb['dateField_lgx3os2m']\n",
|
||
"del bbb['textField_kuntp6fk']\n",
|
||
"del bbb['textField_ljz74n2f']\n"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 55,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'employeeField_ljz6416i_id': ['2268275546837446'],\n",
|
||
" 'textField_kuhnydmk': '',\n",
|
||
" 'selectField_l31clxfy': '门店原因',\n",
|
||
" 'employeeField_ksydghrd_id': ['2268275546837446'],\n",
|
||
" 'textField_livcjyvr': '',\n",
|
||
" 'textField_kuhnydmg': '',\n",
|
||
" 'employeeField_ksirro5o_id': ['2268275546837446'],\n",
|
||
" 'radioField_kuntp6fn_id': '小六',\n",
|
||
" 'selectField_kuz7mfmc_id': '基础版',\n",
|
||
" 'radioField_kuntp6fm': '小六',\n",
|
||
" 'radioField_kuntp6fn': '小六',\n",
|
||
" 'textareaField_liviovx0': '1',\n",
|
||
" 'textField_lhbnuvtn': '',\n",
|
||
" 'selectField_l31clxg1': '疫情原因',\n",
|
||
" 'textAreaField_972lhkt': '111',\n",
|
||
" 'radioField_kuhnydlu_id': '是',\n",
|
||
" 'textField_livc8bjl': '',\n",
|
||
" 'textField_livc8bjm': '',\n",
|
||
" 'radioField_l85ppdia_id': '是',\n",
|
||
" 'textField_livc8bjj': '曹伟',\n",
|
||
" 'textField_livc8bjk': '',\n",
|
||
" 'radioField_kurxyhvq_id': '小六',\n",
|
||
" 'textField_ksydghrg': '',\n",
|
||
" 'radioField_la7x32mq': '否',\n",
|
||
" 'radioField_la7x32mq_id': '否',\n",
|
||
" 'selectField_l31clxfy_id': '门店原因',\n",
|
||
" 'employeeField_ksydght0_id': ['2268275546837446'],\n",
|
||
" 'radioField_ksydghrf': '是',\n",
|
||
" 'radioField_ksydghrk': '是',\n",
|
||
" 'textField_la7x32mp': '',\n",
|
||
" 'employeeField_ljz6gvwc_id': ['2268275546837446'],\n",
|
||
" 'selectField_kuwa866e_id': '已完成',\n",
|
||
" 'radioField_r3yeqvd': '暂时没有问题',\n",
|
||
" 'radioField_r3yeqvd_id': '暂时没有问题',\n",
|
||
" 'selectField_l31clxg1_id': '疫情原因',\n",
|
||
" 'radioField_kuhnydn5_id': '是',\n",
|
||
" 'radioField_kurxyhvp': '小六',\n",
|
||
" 'radioField_kurxyhvq': '小六',\n",
|
||
" 'dateField_kuhnydn2': 1665158400000,\n",
|
||
" 'radioField_kuhnydmd_id': '是',\n",
|
||
" 'dateField_kuhnydn6': 1667145600000,\n",
|
||
" 'radioField_ksydghrk_id': '是',\n",
|
||
" 'employeeField_ljz6gvwd_id': ['2268275546837446'],\n",
|
||
" 'radioField_l85ppdie': '是',\n",
|
||
" 'radioField_l85ppdia': '是',\n",
|
||
" 'radioField_ksydghrf_id': '是',\n",
|
||
" 'employeeField_ljz6416j_id': ['2268275546837446'],\n",
|
||
" 'employeeField_ksydghre_id': ['2268275546837446'],\n",
|
||
" 'textField_kuzcvh3b': '1088天',\n",
|
||
" 'radioField_kuhnydlp': '是',\n",
|
||
" 'radioField_kuhnydlp_id': '是',\n",
|
||
" 'radioField_kuhnydn0': '是',\n",
|
||
" 'textField_ksydghrm': '',\n",
|
||
" 'radioField_ljqi5we3_id': '有商机',\n",
|
||
" 'textField_lbodyv8i': '',\n",
|
||
" 'radioField_kuhnydmi_id': '是',\n",
|
||
" 'radioField_kuhnydmi': '是',\n",
|
||
" 'radioField_kuhnydmd': '是',\n",
|
||
" 'dateField_lifr1fdv': 1691660417000,\n",
|
||
" 'textField_l85ppdic': '',\n",
|
||
" 'textField_l85ppdig': '',\n",
|
||
" 'radioField_l85ppdie_id': '是',\n",
|
||
" 'radioField_kuhnydlu': '是',\n",
|
||
" 'radioField_kuhnydn5': '是',\n",
|
||
" 'textareaField_l31clxg4': '疫情开门再续',\n",
|
||
" 'radioField_kurxyhvp_id': '小六',\n",
|
||
" 'textField_ktp3uuo7': '自主开户',\n",
|
||
" 'radioField_ljqi5we3': '有商机',\n",
|
||
" 'radioField_kuhnydn0_id': '是',\n",
|
||
" 'textField_kuhnydlw': '',\n",
|
||
" 'selectField_kuz7mfmd_id': 'E.S（旧）',\n",
|
||
" 'radioField_kuntp6fm_id': '小六',\n",
|
||
" 'textField_kuhnydn3': '',\n",
|
||
" 'radioField_ktuxbopv_id': '否',\n",
|
||
" 'textField_kuhnydn7': '',\n",
|
||
" 'textField_kuhnydls': ''}"
|
||
]
|
||
},
|
||
"execution_count": 55,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"bbb"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 26,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'2948895d-f77b-4da0-984b-e5a711357aec'"
|
||
]
|
||
},
|
||
"execution_count": 26,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"res['data'][0]['formInstanceId']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 9,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"'CHS0000001'"
|
||
]
|
||
},
|
||
"execution_count": 9,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data['formData']['textField_ll4xtlp8']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 7,
|
||
"metadata": {},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'textField_ll4xtlpd': '123123',\n",
|
||
" 'radioField_ll4xtlpc': '全部门店',\n",
|
||
" 'textField_ll4xtlp8': 'CHS0000001',\n",
|
||
" 'textField_ll4y37hr': '',\n",
|
||
" 'radioField_ll4xtlpc_id': '全部门店',\n",
|
||
" 'textField_ll4xtlpa': '测试公司'}"
|
||
]
|
||
},
|
||
"execution_count": 7,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"data['formData']"
|
||
]
|
||
}
|
||
],
|
||
"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"
|
||
},
|
||
"orig_nbformat": 4
|
||
},
|
||
"nbformat": 4,
|
||
"nbformat_minor": 2
|
||
}
|