262 lines
100 KiB
Plaintext
262 lines
100 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "markdown",
|
|
"source": "### 历史维修记录",
|
|
"id": "c70d36ff865b275b"
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"id": "initial_id",
|
|
"metadata": {
|
|
"collapsed": true,
|
|
"ExecuteTime": {
|
|
"end_time": "2025-07-31T06:31:23.494865Z",
|
|
"start_time": "2025-07-31T06:31:23.314998Z"
|
|
}
|
|
},
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import requests\n",
|
|
"from urllib.parse import quote\n",
|
|
"\n",
|
|
"# 对中文进行 URL 编码\n",
|
|
"loginuser_encoded = quote('超级用户') # -> '%E8%B6%85%E7%BA%A7%E7%94%A8%E6%88%B7'\n",
|
|
"loginempname_encoded = quote('管理员') # -> '%E7%AE%A1%E7%90%86%E5%91%98'\n",
|
|
"\n",
|
|
"cookies = {\n",
|
|
" 'ASP.NET_SessionId': 'pahcjz0hkhxxfdt5chh4e5ha',\n",
|
|
" 'dbname': 'db_180723001',\n",
|
|
" 'loginuser': loginuser_encoded,\n",
|
|
" 'loginempname': loginempname_encoded,\n",
|
|
" 'orgid': '1',\n",
|
|
"}\n",
|
|
"\n",
|
|
"headers = {\n",
|
|
" 'Accept': 'application/json, text/javascript, */*; q=0.01',\n",
|
|
" 'Accept-Language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
|
|
" 'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8',\n",
|
|
" 'Origin': 'http://114.220.76.90:6060',\n",
|
|
" 'Proxy-Connection': 'keep-alive',\n",
|
|
" 'Referer': 'http://114.220.76.90:6060/repair/repair_document.html?v=V6.19.0415',\n",
|
|
" 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36 Edg/138.0.0.0',\n",
|
|
" 'X-Requested-With': 'XMLHttpRequest',\n",
|
|
" # 'Cookie': 'ASP.NET_SessionId=pahcjz0hkhxxfdt5chh4e5ha; dbname=db_180723001; loginuser=超级用户; loginempname=管ç\\x90†å‘˜; orgid=1',\n",
|
|
"}\n",
|
|
"\n",
|
|
"data = {\n",
|
|
" 'startDate': '2015-07-23',\n",
|
|
" 'endDate': '2025-07-30',\n",
|
|
" 'RepairState': '',\n",
|
|
" 'repairSort': '',\n",
|
|
" 'waiter': '',\n",
|
|
" 'searchValue': '',\n",
|
|
" 'car_id': '',\n",
|
|
" 'page': '1',\n",
|
|
" 'rows': '20',\n",
|
|
"}\n",
|
|
"\n",
|
|
"response = requests.post(\n",
|
|
" 'http://114.220.76.90:6060/repair/httphandler/get_repair.ashx',\n",
|
|
" cookies=cookies,\n",
|
|
" headers=headers,\n",
|
|
" data=data,\n",
|
|
" verify=False,\n",
|
|
")\n"
|
|
],
|
|
"outputs": [],
|
|
"execution_count": 1
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-07-30T09:25:29.389466Z",
|
|
"start_time": "2025-07-30T09:25:29.356393Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": "print(response.json())",
|
|
"id": "2e51c0abba6f4cc3",
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"{'total': 14430, 'rows': [{'repair_id': 'KX250730003', 'state': '已竣工待结算', 'car_platenum': '苏A30JA0', 'repair_sort': '维修', 'driver': '渤海', 'driver_movephone': '18118995692', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '福特福睿斯', 'cur_mileage': '', 'sign_time': '2025-07-30', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/30 13:38:52'}, {'repair_id': 'KX250730002', 'state': '已竣工待结算', 'car_platenum': '苏LLV203', 'repair_sort': '轮胎', 'driver': '喻女士', 'driver_movephone': '13646100208', 'total_money': '280.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '高尔夫', 'cur_mileage': '', 'sign_time': '2025-07-30', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/30 10:40:37'}, {'repair_id': 'KX250730001', 'state': '已竣工待结算', 'car_platenum': '苏L55009', 'repair_sort': '维修', 'driver': '韦金祥', 'driver_movephone': '15105290033', 'total_money': '470.000000', 'cust_describe': '故障灯亮', 'check_result': '更换刹车油壶', 'settle_money': '', 'low_money': '', 'car_brand': '奇骏', 'cur_mileage': '214309.00', 'sign_time': '2025-07-30', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/30 8:43:01'}, {'repair_id': 'KX250729008', 'state': '已竣工待结算', 'car_platenum': '苏LS551V', 'repair_sort': '事故', 'driver': '刘军', 'driver_movephone': '17176574777', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '东风货车', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/29 15:33:56'}, {'repair_id': 'KX250729007', 'state': '已竣工待结算', 'car_platenum': '浙AV623J', 'repair_sort': '维修', 'driver': '谢志强', 'driver_movephone': '13004367275', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '捷豹', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/29 15:16:44'}, {'repair_id': 'KX250729006', 'state': '已竣工待结算', 'car_platenum': '苏L02Q36', 'repair_sort': '维修', 'driver': '戚先生', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': 'ABS报警', 'check_result': '右前轮数传感器', 'settle_money': '', 'low_money': '', 'car_brand': '朗逸', 'cur_mileage': '88691.00', 'sign_time': '2025-07-29', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/29 15:12:42'}, {'repair_id': 'KX250729005', 'state': '已竣工待结算', 'car_platenum': '苏L1611M', 'repair_sort': '钣金做漆', 'driver': '苏L1611M', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '大众', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/29 14:48:57'}, {'repair_id': 'KX250729004', 'state': '已竣工待结算', 'car_platenum': '苏EY8537', 'repair_sort': '事故', 'driver': '苏EY8537', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '渤海事故', 'settle_money': '', 'low_money': '', 'car_brand': '野马', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/29 14:38:22'}, {'repair_id': 'KX250729002', 'state': '已竣工待结算', 'car_platenum': '苏L8B246', 'repair_sort': '轮胎', 'driver': '小牛', 'driver_movephone': '', 'total_money': '330.000000', 'cust_describe': '仪表故障灯亮', 'check_result': '更换轮数传感器,左前轮数传感器，右前轮数传感器，右后轮数传感器', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '235165.00', 'sign_time': '2025-07-29', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/7/29 11:22:54'}, {'repair_id': 'KX250728003', 'state': '已竣工待结算', 'car_platenum': '苏L5Q005', 'repair_sort': '保养', 'driver': '甘鹏', 'driver_movephone': '17768790907', 'total_money': '1075.000000', 'cust_describe': '保养', 'check_result': '保养，后轮刹车片剩余五六毫米', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰E300', 'cur_mileage': '102108.00', 'sign_time': '2025-07-28', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/7/28 14:29:29'}, {'repair_id': 'KX250728002', 'state': '已竣工待结算', 'car_platenum': '苏L5Q005', 'repair_sort': '轮胎', 'driver': '甘鹏', 'driver_movephone': '17768790907', 'total_money': '40.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰E300', 'cur_mileage': '', 'sign_time': '2025-07-28', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/7/28 11:57:50'}, {'repair_id': 'KX250727007', 'state': '已竣工待结算', 'car_platenum': '苏L70W00', 'repair_sort': '维修', 'driver': '张先生', 'driver_movephone': '15606107261', 'total_money': '600.000000', 'cust_describe': '打不着', 'check_result': '更换电瓶', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A3', 'cur_mileage': '126056.00', 'sign_time': '2025-07-27', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/7/27 17:12:14'}, {'repair_id': 'KX250727006', 'state': '已竣工待结算', 'car_platenum': '苏LBV281', 'repair_sort': '保养', 'driver': '张玉忠', 'driver_movephone': '13906104448', 'total_money': '468.000000', 'cust_describe': '保养', 'check_result': '保养，连接后雨刮出水管，行李箱内衬盖子/左4.26已出.本次来安装', 'settle_money': '', 'low_money': '', 'car_brand': '高尔夫7', 'cur_mileage': '170815.00', 'sign_time': '2025-07-27', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/7/27 15:26:01'}, {'repair_id': 'KX250726004', 'state': '已竣工待结算', 'car_platenum': '苏LQ2463', 'repair_sort': '维修', 'driver': '苏LQ2463', 'driver_movephone': '18952888386', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-26', 'waiter': '高安', 'settle_time': '', 'create_man': '高安', 'create_time': '2025/7/26 17:11:31'}, {'repair_id': 'KX250726002', 'state': '已竣工待结算', 'car_platenum': '苏L19589', 'repair_sort': '维修', 'driver': '张老板', 'driver_movephone': '13951288089', 'total_money': '770.000000', 'cust_describe': '仪表报刹车故障', 'check_result': '更换刹车片 刹车盘 报警线', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪', 'cur_mileage': '155256.00', 'sign_time': '2025-07-26', 'waiter': '徐宗诚', 'settle_time': '', 'create_man': '徐宗诚', 'create_time': '2025/7/26 11:21:18'}, {'repair_id': 'KX250724001', 'state': '已竣工待结算', 'car_platenum': '苏LL173J', 'repair_sort': '钣金做漆', 'driver': '六六 马超同事', 'driver_movephone': '', 'total_money': '550.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰C260', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/24 9:01:42'}, {'repair_id': 'KX250723008', 'state': '已竣工待结算', 'car_platenum': '苏A3UD35', 'repair_sort': '事故', 'driver': '小牛', 'driver_movephone': '', 'total_money': '6500.000000', 'cust_describe': '人寿事故6500', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/23 11:10:10'}, {'repair_id': 'KX250722002', 'state': '已竣工待结算', 'car_platenum': '苏L40A50', 'repair_sort': '维修', 'driver': '蒋宇', 'driver_movephone': '15051115958', 'total_money': '60.000000', 'cust_describe': '加冷媒', 'check_result': '加冷媒', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '124536.00', 'sign_time': '2025-07-22', 'waiter': '徐宗诚', 'settle_time': '', 'create_man': '徐宗诚', 'create_time': '2025/7/22 10:41:09'}, {'repair_id': 'KX250722001', 'state': '已竣工待结算', 'car_platenum': '苏L5777X', 'repair_sort': '轮胎', 'driver': '马超', 'driver_movephone': '13952850444', 'total_money': '50.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '宝马', 'cur_mileage': '', 'sign_time': '2025-07-22', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/7/22 9:46:11'}, {'repair_id': 'KX250717001', 'state': '已竣工待结算', 'car_platenum': '苏L08T18', 'repair_sort': '产品销售', 'driver': '小咪眼', 'driver_movephone': '18505117618', 'total_money': '180.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': 'Q3', 'cur_mileage': '', 'sign_time': '2025-07-17', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/17 17:12:54'}, {'repair_id': 'KX250716009', 'state': '已竣工待结算', 'car_platenum': '苏LM1856', 'repair_sort': '事故', 'driver': '周老师', 'driver_movephone': '13852987506', 'total_money': '1380.000000', 'cust_describe': '', 'check_result': '人保事故', 'settle_money': '', 'low_money': '', 'car_brand': '大众途观', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/16 15:00:50'}, {'repair_id': 'KX250711001', 'state': '已竣工待结算', 'car_platenum': '苏L52221', 'repair_sort': '维修', 'driver': '韦友谊', 'driver_movephone': '13952880422', 'total_money': '1220.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A4', 'cur_mileage': '', 'sign_time': '2025-07-11', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/11 9:22:01'}, {'repair_id': 'KX250708008', 'state': '已竣工待结算', 'car_platenum': '苏LP819C', 'repair_sort': '维修', 'driver': '越时新', 'driver_movephone': '', 'total_money': '520.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-08', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/7/8 17:34:58'}, {'repair_id': 'KX250708001', 'state': '已竣工待结算', 'car_platenum': '苏L2920B', 'repair_sort': '维修', 'driver': '徐女士', 'driver_movephone': '18605110920', 'total_money': '108.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰', 'cur_mileage': '', 'sign_time': '2025-07-08', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/8 8:37:11'}, {'repair_id': 'KX250706004', 'state': '已竣工待结算', 'car_platenum': '苏L7H121', 'repair_sort': '维修', 'driver': '胡骐', 'driver_movephone': '18151903098', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '大众', 'cur_mileage': '', 'sign_time': '2025-07-06', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2025/7/6 15:05:34'}, {'repair_id': 'KX250704001', 'state': '已竣工待结算', 'car_platenum': '苏L19589', 'repair_sort': '保养', 'driver': '张老板', 'driver_movephone': '13951288089', 'total_money': '945.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪', 'cur_mileage': '154432.00', 'sign_time': '2025-07-04', 'waiter': '徐宗诚', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/4 8:50:28'}, {'repair_id': 'KX250703008', 'state': '已竣工待结算', 'car_platenum': '苏L691Q0', 'repair_sort': '事故', 'driver': '王从举', 'driver_movephone': '13861396597', 'total_money': '3000.000000', 'cust_describe': '', 'check_result': '人保事故', 'settle_money': '', 'low_money': '', 'car_brand': '五菱', 'cur_mileage': '', 'sign_time': '2025-07-14', 'waiter': '邢小军', 'settle_time': '', 'create_man': '朱玲', 'create_time': '2025/7/3 13:27:15'}, {'repair_id': 'KX250702004', 'state': '已竣工待结算', 'car_platenum': '苏LDD068W', 'repair_sort': '维修', 'driver': '苏LDD068W', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '长城', 'cur_mileage': '', 'sign_time': '2025-07-02', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/7/2 10:45:27'}, {'repair_id': 'KX250629001', 'state': '已竣工待结算', 'car_platenum': '苏L50Y00', 'repair_sort': '产品销售', 'driver': '陈先生', 'driver_movephone': '15862981545', 'total_money': '100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯巴鲁', 'cur_mileage': '', 'sign_time': '2025-06-29', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2025/6/29 11:27:55'}, {'repair_id': 'KX250628013', 'state': '已竣工待结算', 'car_platenum': '苏L52221', 'repair_sort': '保养', 'driver': '韦友谊', 'driver_movephone': '13952880422', 'total_money': '593.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A4', 'cur_mileage': '141611.00', 'sign_time': '2025-06-30', 'waiter': '徐宗诚', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/28 17:47:05'}, {'repair_id': 'KX250626002', 'state': '已竣工待结算', 'car_platenum': '苏LW133B', 'repair_sort': '维修', 'driver': '景波', 'driver_movephone': '', 'total_money': '150.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达 ', 'cur_mileage': '', 'sign_time': '2025-06-26', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/6/26 11:29:49'}, {'repair_id': 'KX250625004', 'state': '已竣工待结算', 'car_platenum': '苏LV857T', 'repair_sort': '保养', 'driver': '翟飞程', 'driver_movephone': '', 'total_money': '488.000000', 'cust_describe': '保养', 'check_result': '保养常规检查', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '24000.00', 'sign_time': '2025-06-25', 'waiter': '管理员', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/6/25 16:32:53'}, {'repair_id': 'KX250623005', 'state': '已竣工待结算', 'car_platenum': '苏L6956K', 'repair_sort': '维修', 'driver': '姚女士', 'driver_movephone': '13852913776', 'total_money': '630.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '凯迪拉克', 'cur_mileage': '', 'sign_time': '2025-06-23', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/23 14:55:30'}, {'repair_id': 'KX250622003', 'state': '已竣工待结算', 'car_platenum': '苏L6Q522', 'repair_sort': '维修', 'driver': '吴昊', 'driver_movephone': '15952885612', 'total_money': '210.000000', 'cust_describe': '没有启停功能', 'check_result': '通过电脑诊断发现制动助力器故障', 'settle_money': '', 'low_money': '', 'car_brand': '大众', 'cur_mileage': '56731.00', 'sign_time': '2025-06-22', 'waiter': '宋振宇', 'settle_time': '', 'create_man': '宋振宇', 'create_time': '2025/6/22 13:35:33'}, {'repair_id': 'KX250619004', 'state': '已竣工待结算', 'car_platenum': '苏LD3960', 'repair_sort': '维修', 'driver': '周懿', 'driver_movephone': '13913434447', 'total_money': '913.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪Q7', 'cur_mileage': '', 'sign_time': '2025-06-19', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/19 16:54:35'}, {'repair_id': 'KX250618004', 'state': '已竣工待结算', 'car_platenum': '苏L5777X', 'repair_sort': '轮胎', 'driver': '马超', 'driver_movephone': '13952850444', 'total_money': '50.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '宝马', 'cur_mileage': '', 'sign_time': '2025-06-18', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/6/18 12:23:34'}, {'repair_id': 'KX250617007', 'state': '已竣工待结算', 'car_platenum': '苏L85H01', 'repair_sort': '维修', 'driver': '孙先生', 'driver_movephone': '13906108548', 'total_money': '1060.000000', 'cust_describe': '', 'check_result': '空调制冷', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰', 'cur_mileage': '', 'sign_time': '2025-06-17', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/17 16:01:02'}, {'repair_id': 'KX250616005', 'state': '已竣工待结算', 'car_platenum': '苏L6S885', 'repair_sort': '维修', 'driver': '陈扬', 'driver_movephone': '13862443943', 'total_money': '1370.000000', 'cust_describe': '', 'check_result': '年审 做漆 天窗漏水 换洗车记录仪', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A4', 'cur_mileage': '', 'sign_time': '2025-06-18', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/16 11:58:52'}, {'repair_id': 'KX250616002', 'state': '已竣工待结算', 'car_platenum': '苏A30JA0', 'repair_sort': '保养', 'driver': '渤海', 'driver_movephone': '18118995692', 'total_money': '2642.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '福特福睿斯', 'cur_mileage': '16726.00', 'sign_time': '2025-06-16', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/16 9:30:13'}, {'repair_id': 'KX250613001', 'state': '已竣工待结算', 'car_platenum': '苏LW133B', 'repair_sort': '维修', 'driver': '景波', 'driver_movephone': '', 'total_money': '280.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达 ', 'cur_mileage': '', 'sign_time': '2025-06-13', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/13 10:07:44'}, {'repair_id': 'KX250612008', 'state': '已竣工待结算', 'car_platenum': '苏LD8779', 'repair_sort': '年审', 'driver': '蔡玲玲', 'driver_movephone': '18605111411', 'total_money': '700.000000', 'cust_describe': '电瓶', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '福克斯', 'cur_mileage': '', 'sign_time': '2025-06-12', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/12 13:47:58'}, {'repair_id': 'KX250609002', 'state': '已竣工待结算', 'car_platenum': '苏LDH7717', 'repair_sort': '轮胎', 'driver': '特斯拉', 'driver_movephone': '', 'total_money': '40.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-06-09', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/6/9 15:51:31'}, {'repair_id': 'KX250605004', 'state': '已竣工待结算', 'car_platenum': '苏LM135A', 'repair_sort': '保养', 'driver': '风轻云淡', 'driver_movephone': '13815150456', 'total_money': '990.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪Q3', 'cur_mileage': '97160.00', 'sign_time': '2025-06-05', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/6/5 13:20:09'}, {'repair_id': 'KX250526006', 'state': '已竣工待结算', 'car_platenum': '苏LG397T', 'repair_sort': '维修', 'driver': '黄强', 'driver_movephone': '1333776389', 'total_money': '300.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达', 'cur_mileage': '', 'sign_time': '2025-05-26', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/5/26 11:02:21'}, {'repair_id': 'KX250515003', 'state': '已竣工待结算', 'car_platenum': '苏L59G99', 'repair_sort': '保养', 'driver': '苏L59G99', 'driver_movephone': '18912805078', 'total_money': '3998.000000', 'cust_describe': '', 'check_result': '大保养', 'settle_money': '', 'low_money': '', 'car_brand': '指南者', 'cur_mileage': '129931.00', 'sign_time': '2025-05-16', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/5/15 9:26:45'}, {'repair_id': 'KX250509003', 'state': '已竣工待结算', 'car_platenum': '苏L6956K', 'repair_sort': '维修', 'driver': '姚女士', 'driver_movephone': '13852913776', 'total_money': '310.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '凯迪拉克', 'cur_mileage': '', 'sign_time': '2025-05-09', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/5/9 10:20:57'}, {'repair_id': 'KX250509002', 'state': '已竣工待结算', 'car_platenum': '苏LHM985', 'repair_sort': '维修', 'driver': '王慧林', 'driver_movephone': '13952877878', 'total_money': '310.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '伊兰特', 'cur_mileage': '', 'sign_time': '2025-05-09', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/5/9 10:01:23'}, {'repair_id': 'KX250505002', 'state': '已竣工待结算', 'car_platenum': '苏LDF7818', 'repair_sort': '轮胎', 'driver': '蔚来', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '蔚来', 'cur_mileage': '', 'sign_time': '2025-05-05', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/5/5 12:02:45'}, {'repair_id': 'KX250427001', 'state': '已竣工待结算', 'car_platenum': '苏LUV707', 'repair_sort': '保养', 'driver': '邓先生', 'driver_movephone': '15952883023', 'total_money': '243.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '江淮', 'cur_mileage': '57352.00', 'sign_time': '2025-04-27', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2025/4/27 11:01:17'}, {'repair_id': 'KX250422002', 'state': '已竣工待结算', 'car_platenum': '苏L507V0', 'repair_sort': '保养', 'driver': '洪刚', 'driver_movephone': '15952886558', 'total_money': '810.000000', 'cust_describe': '', 'check_result': '三送一 第二次 加送一次保养', 'settle_money': '', 'low_money': '', 'car_brand': '昂科威', 'cur_mileage': '67939.00', 'sign_time': '2025-04-22', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/22 9:18:48'}, {'repair_id': 'KX250414004', 'state': '已竣工待结算', 'car_platenum': '苏L016K8', 'repair_sort': '维修', 'driver': '老扁(徐斌)', 'driver_movephone': '13179390666', 'total_money': '10.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '途胜LBETLBFC7HY342797', 'cur_mileage': '', 'sign_time': '2025-04-14', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/14 15:23:10'}, {'repair_id': 'KX250412008', 'state': '已竣工待结算', 'car_platenum': '苏L55009', 'repair_sort': '轮胎', 'driver': '韦金祥', 'driver_movephone': '15105290033', 'total_money': '1050.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奇骏', 'cur_mileage': '', 'sign_time': '2025-04-12', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/12 13:47:22'}, {'repair_id': 'KX250410003', 'state': '已竣工待结算', 'car_platenum': '苏L55009', 'repair_sort': '维修', 'driver': '韦金祥', 'driver_movephone': '15105290033', 'total_money': '570.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奇骏', 'cur_mileage': '', 'sign_time': '2025-04-10', 'waiter': '高安', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/10 13:40:43'}, {'repair_id': 'KX250409003', 'state': '已竣工待结算', 'car_platenum': '苏LW133B', 'repair_sort': '维修', 'driver': '景波', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '返修', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达 ', 'cur_mileage': '', 'sign_time': '2025-04-13', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/9 9:42:24'}, {'repair_id': 'KX250409002', 'state': '已竣工待结算', 'car_platenum': '苏LHM985', 'repair_sort': '维修', 'driver': '王慧林', 'driver_movephone': '13952877878', 'total_money': '180.000000', 'cust_describe': '空调不制冷 后备箱打不开', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '伊兰特', 'cur_mileage': '', 'sign_time': '2025-04-09', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '朱玲', 'create_time': '2025/4/9 9:37:46'}, {'repair_id': 'KX250404002', 'state': '已竣工待结算', 'car_platenum': '苏L08T18', 'repair_sort': '保养', 'driver': '小咪眼', 'driver_movephone': '18505117618', 'total_money': '130.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': 'Q3', 'cur_mileage': '', 'sign_time': '2025-04-04', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/4/4 14:19:26'}, {'repair_id': 'KX250331002', 'state': '已竣工待结算', 'car_platenum': '苏LX771Y', 'repair_sort': '年审', 'driver': '王守忠', 'driver_movephone': '15006103759', 'total_money': '360.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-03-31', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2025/3/31 8:57:15'}, {'repair_id': 'KX250327005', 'state': '已竣工待结算', 'car_platenum': '苏A1V79G', 'repair_sort': '保养', 'driver': '郑一心', 'driver_movephone': '13815152838', 'total_money': '400.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '大通', 'cur_mileage': '148112.00', 'sign_time': '2025-03-27', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/3/27 14:49:13'}, {'repair_id': 'KX250315003', 'state': '已竣工待结算', 'car_platenum': '苏LAW883', 'repair_sort': '年审', 'driver': '刘国强', 'driver_movephone': '15806108891', 'total_money': '360.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '起亚K3', 'cur_mileage': '', 'sign_time': '2025-03-15', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/3/15 10:08:49'}, {'repair_id': 'KX250312003', 'state': '已竣工待结算', 'car_platenum': '苏L52221', 'repair_sort': '维修', 'driver': '韦友谊', 'driver_movephone': '13952880422', 'total_money': '530.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A4', 'cur_mileage': '', 'sign_time': '2025-03-12', 'waiter': '张涛', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/3/12 10:18:14'}, {'repair_id': 'KX250310001', 'state': '已竣工待结算', 'car_platenum': '苏AE9311', 'repair_sort': '钣金做漆', 'driver': '苏AE9311', 'driver_movephone': '', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-03-10', 'waiter': '邢小军', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/3/10 8:59:57'}, {'repair_id': 'KX250301005', 'state': '已竣工待结算', 'car_platenum': '苏L169Q5', 'repair_sort': '维修', 'driver': '阿伦', 'driver_movephone': '', 'total_money': '1100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '迈腾', 'cur_mileage': '', 'sign_time': '2025-03-01', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/3/1 13:44:21'}, {'repair_id': 'KX250217005', 'state': '已竣工待结算', 'car_platenum': '苏L52221', 'repair_sort': '维修', 'driver': '韦友谊', 'driver_movephone': '13952880422', 'total_money': '260.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A4', 'cur_mileage': '', 'sign_time': '2025-02-17', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/2/17 10:24:36'}, {'repair_id': 'KX250217004', 'state': '已竣工待结算', 'car_platenum': '苏L55009', 'repair_sort': '维修', 'driver': '韦金祥', 'driver_movephone': '15105290033', 'total_money': '80.000000', 'cust_describe': '异响 水箱漏水', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奇骏', 'cur_mileage': '', 'sign_time': '2025-02-17', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2025/2/17 10:23:35'}, {'repair_id': 'KX250210001', 'state': '已竣工待结算', 'car_platenum': '苏LTC260', 'repair_sort': '事故', 'driver': '邱国强', 'driver_movephone': '17712824066', 'total_money': '1450.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '陆风', 'cur_mileage': '', 'sign_time': '2025-02-12', 'waiter': '邢小军', 'settle_time': '', 'create_man': '张涛', 'create_time': '2025/2/10 9:30:06'}, {'repair_id': 'KX250124004', 'state': '已竣工待结算', 'car_platenum': '苏L6956K', 'repair_sort': '维修', 'driver': '姚女士', 'driver_movephone': '13852913776', 'total_money': '800.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '凯迪拉克', 'cur_mileage': '', 'sign_time': '2025-01-24', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '张涛', 'create_time': '2025/1/24 10:11:27'}, {'repair_id': 'KX241230003', 'state': '已竣工待结算', 'car_platenum': '苏LN096W', 'repair_sort': '轮胎', 'driver': '斯玛特 ', 'driver_movephone': '', 'total_money': '350.000000', 'cust_describe': '', 'check_result': '西津渡救援服务', 'settle_money': '', 'low_money': '', 'car_brand': '斯玛特 ', 'cur_mileage': '', 'sign_time': '2024-12-30', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2024/12/30 9:41:11'}, {'repair_id': 'KX241219007', 'state': '已竣工待结算', 'car_platenum': '苏LEY110', 'repair_sort': '轮胎', 'driver': '屈志刚', 'driver_movephone': '13094956000', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '迈锐宝', 'cur_mileage': '', 'sign_time': '2024-12-19', 'waiter': '孙飞', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/12/19 11:25:11'}, {'repair_id': 'KX241211004', 'state': '已竣工待结算', 'car_platenum': '苏LH1077', 'repair_sort': '维修', 'driver': '杜威', 'driver_movephone': '15952802079', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '毕加索', 'cur_mileage': '', 'sign_time': '2024-12-11', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '张涛', 'create_time': '2024/12/11 13:57:01'}, {'repair_id': 'KX241119003', 'state': '已竣工待结算', 'car_platenum': '苏LQ5858', 'repair_sort': '产品销售', 'driver': '纪全', 'driver_movephone': '13094950285', 'total_money': '20.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '别克', 'cur_mileage': '', 'sign_time': '2024-11-19', 'waiter': '朱玲', 'settle_time': '', 'create_man': '张涛', 'create_time': '2024/11/19 10:52:28'}, {'repair_id': 'KX241116003', 'state': '已竣工待结算', 'car_platenum': '苏L590E5', 'repair_sort': '维修', 'driver': '风轻云淡', 'driver_movephone': '13815150456', 'total_money': '390.000000', 'cust_describe': '玻璃升降器', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A6', 'cur_mileage': '', 'sign_time': '2024-11-16', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '张涛', 'create_time': '2024/11/16 14:08:11'}, {'repair_id': 'KX241116002', 'state': '已竣工待结算', 'car_platenum': '苏LE7351', 'repair_sort': '维修', 'driver': '杨先生', 'driver_movephone': '13952855908', 'total_money': '245.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '福特嘉年华', 'cur_mileage': '', 'sign_time': '2024-11-14', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/11/16 12:36:54'}, {'repair_id': 'KX241109003', 'state': '已竣工待结算', 'car_platenum': '苏LD8779', 'repair_sort': '维修', 'driver': '蔡玲玲', 'driver_movephone': '18605111411', 'total_money': '100.000000', 'cust_describe': '发动机管子老化', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '福克斯', 'cur_mileage': '', 'sign_time': '2024-11-09', 'waiter': '孙飞', 'settle_time': '', 'create_man': '张涛', 'create_time': '2024/11/9 9:34:55'}, {'repair_id': 'KX241028004', 'state': '已竣工待结算', 'car_platenum': '苏L710L0', 'repair_sort': '', 'driver': '周先生', 'driver_movephone': '13921582143', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2024-10-28', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2024/10/28 11:39:03'}, {'repair_id': 'KX241012006', 'state': '已竣工待结算', 'car_platenum': '苏LDY7756', 'repair_sort': '维修', 'driver': '屈海斌', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奇瑞', 'cur_mileage': '', 'sign_time': '2024-10-12', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/10/12 16:02:37'}, {'repair_id': 'KX241005001', 'state': '已竣工待结算', 'car_platenum': '苏LD55166', 'repair_sort': '维修', 'driver': '顾平', 'driver_movephone': '', 'total_money': '70.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2024-10-05', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/10/5 11:37:21'}, {'repair_id': 'KX240918006', 'state': '已竣工待结算', 'car_platenum': '苏L97888', 'repair_sort': '年审', 'driver': '小马', 'driver_movephone': '', 'total_money': '258.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A8', 'cur_mileage': '', 'sign_time': '2024-09-18', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2024/9/18 15:34:55'}, {'repair_id': 'KX240830004', 'state': '已竣工待结算', 'car_platenum': '苏L2K220', 'repair_sort': '维修', 'driver': '蔡先生', 'driver_movephone': '13775371983', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '标志', 'cur_mileage': '', 'sign_time': '2024-08-30', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/8/30 14:16:01'}, {'repair_id': 'KX240829005', 'state': '已竣工待结算', 'car_platenum': '苏L19V88', 'repair_sort': '保养', 'driver': '万院长', 'driver_movephone': '18952819888', 'total_money': '378.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '帕萨特', 'cur_mileage': '80162.00', 'sign_time': '2024-08-29', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/8/29 12:56:07'}, {'repair_id': 'KX240824002', 'state': '已竣工待结算', 'car_platenum': '苏L5S199', 'repair_sort': '保养', 'driver': '曹娟娟', 'driver_movephone': '13815173306', 'total_money': '578.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A3', 'cur_mileage': '29479.00', 'sign_time': '2024-08-24', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/8/24 10:47:50'}, {'repair_id': 'KX240818006', 'state': '已竣工待结算', 'car_platenum': '苏L57L75', 'repair_sort': '维修', 'driver': '李东伟', 'driver_movephone': '13921585760', 'total_money': '1046.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '大众', 'cur_mileage': '123607.00', 'sign_time': '2024-08-18', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/8/18 15:34:07'}, {'repair_id': 'KX240803002', 'state': '已竣工待结算', 'car_platenum': '苏L328V8', 'repair_sort': '维修', 'driver': '大众', 'driver_movephone': '', 'total_money': '90.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2024-08-03', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/8/3 14:39:48'}, {'repair_id': 'KX240803001', 'state': '已竣工待结算', 'car_platenum': '苏L1X456', 'repair_sort': '事故', 'driver': '苏L1X456', 'driver_movephone': '', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2024-07-25', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/8/3 13:37:06'}, {'repair_id': 'KX240730006', 'state': '已竣工待结算', 'car_platenum': '苏L2M830', 'repair_sort': '维修', 'driver': '谢昊', 'driver_movephone': '', 'total_money': '20.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达', 'cur_mileage': '', 'sign_time': '2024-07-30', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/7/30 17:16:00'}, {'repair_id': 'KX240724007', 'state': '已竣工待结算', 'car_platenum': '苏L59G99', 'repair_sort': '保养', 'driver': '苏L59G99', 'driver_movephone': '18912805078', 'total_money': '528.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '指南者', 'cur_mileage': '', 'sign_time': '2024-07-24', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/7/24 17:40:07'}, {'repair_id': 'KX240704004', 'state': '已竣工待结算', 'car_platenum': '苏AG6725', 'repair_sort': '事故', 'driver': '方习军', 'driver_movephone': '13809003710', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '人保事故', 'settle_money': '', 'low_money': '', 'car_brand': '菱智', 'cur_mileage': '', 'sign_time': '2024-07-04', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/7/4 15:08:46'}, {'repair_id': 'KX240703004', 'state': '已竣工待结算', 'car_platenum': '苏L620Q7', 'repair_sort': '保养', 'driver': '张先生', 'driver_movephone': '', 'total_money': '413.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '雪佛兰', 'cur_mileage': '122619.00', 'sign_time': '2024-07-03', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/7/3 17:42:14'}, {'repair_id': 'KX240629001', 'state': '已竣工待结算', 'car_platenum': '苏L620Q7', 'repair_sort': '年审', 'driver': '张先生', 'driver_movephone': '', 'total_money': '258.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '雪佛兰', 'cur_mileage': '', 'sign_time': '2024-06-29', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2024/6/29 11:56:00'}, {'repair_id': 'KX240625003', 'state': '已竣工待结算', 'car_platenum': '苏L59G99', 'repair_sort': '维修', 'driver': '苏L59G99', 'driver_movephone': '18912805078', 'total_money': '180.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '指南者', 'cur_mileage': '', 'sign_time': '2024-06-25', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/6/25 15:01:36'}, {'repair_id': 'KX240601011', 'state': '已竣工待结算', 'car_platenum': '苏L6P393', 'repair_sort': '事故', 'driver': '程莉', 'driver_movephone': '', 'total_money': '2550.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奔驰', 'cur_mileage': '', 'sign_time': '2024-04-23', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/6/1 15:44:51'}, {'repair_id': 'KX240531008', 'state': '已竣工待结算', 'car_platenum': '苏L59G99', 'repair_sort': '维修', 'driver': '苏L59G99', 'driver_movephone': '18912805078', 'total_money': '50.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '指南者', 'cur_mileage': '', 'sign_time': '2024-05-31', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/5/31 16:59:30'}, {'repair_id': 'KX240430003', 'state': '已竣工待结算', 'car_platenum': '苏L0B088', 'repair_sort': '维修', 'driver': '京洲会计事务所', 'driver_movephone': '', 'total_money': '260.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪q5Q5', 'cur_mileage': '', 'sign_time': '2024-04-30', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/4/30 10:15:16'}, {'repair_id': 'KX240420001', 'state': '已竣工待结算', 'car_platenum': '苏LEL062', 'repair_sort': '维修', 'driver': '祝瑜', 'driver_movephone': '15850458221', 'total_money': '60.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '别克凯越', 'cur_mileage': '', 'sign_time': '2024-04-20', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2024/4/20 9:11:46'}, {'repair_id': 'KX240313007', 'state': '已竣工待结算', 'car_platenum': '苏LDG8851', 'repair_sort': '事故', 'driver': '张勇', 'driver_movephone': '13952852383', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '华晨鑫源', 'cur_mileage': '', 'sign_time': '2024-03-01', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/3/13 20:41:35'}, {'repair_id': 'KX240309004', 'state': '已竣工待结算', 'car_platenum': '苏L07R61', 'repair_sort': '保养', 'driver': '屈海斌', 'driver_movephone': '13905282033', 'total_money': '413.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '马自达CX5', 'cur_mileage': '79490.00', 'sign_time': '2024-03-09', 'waiter': '孙飞', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2024/3/9 13:23:48'}, {'repair_id': 'KX240306004', 'state': '已竣工待结算', 'car_platenum': '苏L676E0', 'repair_sort': '维修', 'driver': '邵医生', 'driver_movephone': '', 'total_money': '480.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '哈佛H8', 'cur_mileage': '', 'sign_time': '2024-03-06', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/3/6 13:58:12'}, {'repair_id': 'KX240227001', 'state': '已竣工待结算', 'car_platenum': '苏L0B088', 'repair_sort': '维修', 'driver': '京洲会计事务所', 'driver_movephone': '', 'total_money': '210.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪q5Q5', 'cur_mileage': '', 'sign_time': '2024-02-27', 'waiter': '穆家奎', 'settle_time': '', 'create_man': '穆家奎', 'create_time': '2024/2/27 9:37:57'}, {'repair_id': 'KX240103004', 'state': '已竣工待结算', 'car_platenum': '苏L3H350', 'repair_sort': '维修', 'driver': '胡立军', 'driver_movephone': '13655286688', 'total_money': '490.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': 'S350', 'cur_mileage': '', 'sign_time': '2023-12-31', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2024/1/3 13:55:05'}, {'repair_id': 'KX231230003', 'state': '已竣工待结算', 'car_platenum': '苏LAP391', 'repair_sort': '维修', 'driver': '胡立军', 'driver_movephone': '13655286688', 'total_money': '180.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '迈腾', 'cur_mileage': '', 'sign_time': '2023-12-30', 'waiter': '李杰', 'settle_time': '', 'create_man': '李杰', 'create_time': '2023/12/30 14:53:36'}, {'repair_id': 'KX231226001', 'state': '已竣工待结算', 'car_platenum': '苏LB021P', 'repair_sort': '保养', 'driver': '孙坚', 'driver_movephone': '13815473803', 'total_money': '928.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '本田思域', 'cur_mileage': '15880.00', 'sign_time': '2023-12-26', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2023/12/26 10:43:52'}, {'repair_id': 'KX231216003', 'state': '已竣工待结算', 'car_platenum': '苏LAP391', 'repair_sort': '维修', 'driver': '胡立军', 'driver_movephone': '13655286688', 'total_money': '258.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '迈腾', 'cur_mileage': '', 'sign_time': '2023-12-16', 'waiter': '李杰', 'settle_time': '', 'create_man': '孙飞', 'create_time': '2023/12/16 9:48:41'}, {'repair_id': 'KX231211007', 'state': '已竣工待结算', 'car_platenum': '苏LL665T', 'repair_sort': '维修', 'driver': '屈海滨', 'driver_movephone': '', 'total_money': '658.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '桑塔纳3000', 'cur_mileage': '', 'sign_time': '2023-12-11', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2023/12/11 15:54:17'}, {'repair_id': 'KX231208001', 'state': '已竣工待结算', 'car_platenum': '苏L11H85', 'repair_sort': '保养', 'driver': '王先生', 'driver_movephone': '13921593018', 'total_money': '238.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '101179.00', 'sign_time': '2023-12-08', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2023/12/8 9:14:14'}, {'repair_id': 'KX231119004', 'state': '已竣工待结算', 'car_platenum': '苏LH638N', 'repair_sort': '维修', 'driver': '快快乐乐', 'driver_movephone': '13305281327', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '马6', 'cur_mileage': '', 'sign_time': '2023-11-19', 'waiter': '冯天祥', 'settle_time': '', 'create_man': '冯天祥', 'create_time': '2023/11/19 12:24:53'}, {'repair_id': 'KX231116001', 'state': '已竣工待结算', 'car_platenum': '苏AP88U8', 'repair_sort': '做漆', 'driver': '毛女士', 'driver_movephone': '13305281327', 'total_money': '900.000000', 'cust_describe': '自费900', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-11-16', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2023/11/16 9:46:37'}, {'repair_id': 'KX231026002', 'state': '已竣工待结算', 'car_platenum': '苏LAP391', 'repair_sort': '维修', 'driver': '胡立军', 'driver_movephone': '13655286688', 'total_money': '350.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '迈腾', 'cur_mileage': '', 'sign_time': '2023-10-26', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2023/10/26 9:27:12'}, {'repair_id': 'KX231003002', 'state': '已竣工待结算', 'car_platenum': '苏LX595X', 'repair_sort': '保养', 'driver': '吴', 'driver_movephone': '', 'total_money': '378.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '14788.00', 'sign_time': '2023-10-03', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/10/3 14:51:14'}, {'repair_id': 'KX230830002', 'state': '已竣工待结算', 'car_platenum': '苏L75997', 'repair_sort': '事故', 'driver': '刘文宏', 'driver_movephone': '13775534977', 'total_money': '500.000000', 'cust_describe': '渤海汤俊定损', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '别克XT英朗', 'cur_mileage': '', 'sign_time': '2023-08-30', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2023/8/30 9:00:05'}, {'repair_id': 'KX230802007', 'state': '已竣工待结算', 'car_platenum': '苏L0F126', 'repair_sort': '维修', 'driver': '王芯', 'driver_movephone': '15051118843', 'total_money': '520.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-08-02', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/8/2 17:08:13'}, {'repair_id': 'KX230705001', 'state': '已竣工待结算', 'car_platenum': '鄂A41AT0', 'repair_sort': '事故', 'driver': '吴钢', 'driver_movephone': '18013071256', 'total_money': '1000.000000', 'cust_describe': '人保陆启国定损', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '东风', 'cur_mileage': '', 'sign_time': '2023-07-05', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2023/7/5 9:18:28'}, {'repair_id': 'KX230609001', 'state': '已竣工待结算', 'car_platenum': '苏L3280S', 'repair_sort': '维修', 'driver': '李小明', 'driver_movephone': '', 'total_money': '500.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '途观', 'cur_mileage': '', 'sign_time': '2023-06-09', 'waiter': '管理员', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2023/6/9 8:05:04'}, {'repair_id': 'KX230605004', 'state': '已竣工待结算', 'car_platenum': '苏J619AR', 'repair_sort': '轮胎', 'driver': '许超', 'driver_movephone': '', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-06-05', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/6/5 14:27:37'}, {'repair_id': 'KX230601004', 'state': '已竣工待结算', 'car_platenum': '苏L5P010', 'repair_sort': '轮胎', 'driver': '许超', 'driver_movephone': '', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-06-01', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/6/1 10:47:24'}, {'repair_id': 'KX230520002', 'state': '已竣工待结算', 'car_platenum': '苏LR766H', 'repair_sort': '轮胎', 'driver': '许超', 'driver_movephone': '', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-05-20', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/5/20 12:56:56'}, {'repair_id': 'KX230424005', 'state': '已竣工待结算', 'car_platenum': '苏LM731V', 'repair_sort': '维修', 'driver': '凯迪拉克', 'driver_movephone': '', 'total_money': '300.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-04-24', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/4/24 14:14:07'}, {'repair_id': 'KX230413003', 'state': '已竣工待结算', 'car_platenum': '苏LL956N', 'repair_sort': '保养', 'driver': 'L956N', 'driver_movephone': '', 'total_money': '100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '18661.00', 'sign_time': '2023-04-13', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/4/13 12:25:28'}, {'repair_id': 'KX230302007', 'state': '已竣工待结算', 'car_platenum': '苏LH1680', 'repair_sort': '轮胎', 'driver': 'H1680', 'driver_movephone': '', 'total_money': '300.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-03-02', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/3/2 12:04:26'}, {'repair_id': 'KX230105001', 'state': '已竣工待结算', 'car_platenum': '苏LQW270', 'repair_sort': '维修', 'driver': '马先生', 'driver_movephone': '', 'total_money': '180.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2023-01-05', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2023/1/5 9:28:35'}, {'repair_id': 'KX221213004', 'state': '已竣工待结算', 'car_platenum': '苏L001E0', 'repair_sort': '轮胎', 'driver': '镇江新航精密铸造有限公司', 'driver_movephone': '15105295526', 'total_money': '350.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2022-12-13', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2022/12/13 15:32:40'}, {'repair_id': 'KX221130007', 'state': '已竣工待结算', 'car_platenum': '苏L8Q608', 'repair_sort': '保养', 'driver': '徐军', 'driver_movephone': '18344715811', 'total_money': '780.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '奥迪A6L', 'cur_mileage': '85197.00', 'sign_time': '2022-11-30', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2022/11/30 16:39:49'}, {'repair_id': 'KX220826007', 'state': '已竣工待结算', 'car_platenum': '苏L37H71', 'repair_sort': '保养', 'driver': '刘强', 'driver_movephone': '15952888797', 'total_money': '70.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '斯柯达明锐', 'cur_mileage': '', 'sign_time': '2022-08-26', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2022/8/26 16:23:21'}, {'repair_id': 'KX211227013', 'state': '已竣工待结算', 'car_platenum': '皖H32GA7', 'repair_sort': '保养', 'driver': '梁文欢', 'driver_movephone': '', 'total_money': '2000.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': 'A7 3.0', 'cur_mileage': '83386.00', 'sign_time': '2021-12-27', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2021/12/27 20:15:56'}, {'repair_id': 'KX211104001', 'state': '已竣工待结算', 'car_platenum': '苏LAH713', 'repair_sort': '维修', 'driver': '别克', 'driver_movephone': '', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2021-11-04', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2021/11/4 9:10:01'}, {'repair_id': 'KX211013002', 'state': '已竣工待结算', 'car_platenum': '苏LV2997', 'repair_sort': '事故', 'driver': '潘总朋友', 'driver_movephone': '', 'total_money': '4450.000000', 'cust_describe': '渤海事故4450 保险公司供货', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '尼桑奇骏', 'cur_mileage': '', 'sign_time': '2021-10-13', 'waiter': '张涛', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2021/10/13 13:13:02'}, {'repair_id': 'KX210921001', 'state': '已竣工待结算', 'car_platenum': '苏L0K755', 'repair_sort': '维修', 'driver': '祝辉', 'driver_movephone': '15952811487', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '途观', 'cur_mileage': '', 'sign_time': '2021-09-21', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2021/9/21 16:05:18'}, {'repair_id': 'KX210622008', 'state': '已竣工待结算', 'car_platenum': '沪C757Q8', 'repair_sort': '维修', 'driver': '庄先生', 'driver_movephone': '13952860819', 'total_money': '2168.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '雪佛兰', 'cur_mileage': '147584.00', 'sign_time': '2021-06-22', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2021/6/22 17:32:28'}, {'repair_id': 'KX201110006', 'state': '已竣工待结算', 'car_platenum': '苏L22289', 'repair_sort': '保养', 'driver': '秦', 'driver_movephone': '18605112680', 'total_money': '690.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '本田艾力绅', 'cur_mileage': '177780.00', 'sign_time': '2020-11-10', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2020/11/10 11:02:13'}, {'repair_id': 'KX200708005', 'state': '已竣工待结算', 'car_platenum': '苏LBY001', 'repair_sort': '维修', 'driver': '周先生', 'driver_movephone': '13012933999', 'total_money': '100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2020-07-08', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2020/7/8 18:01:23'}, {'repair_id': 'KX200523004', 'state': '已竣工待结算', 'car_platenum': '苏L2852Y', 'repair_sort': '维修', 'driver': '王先生', 'driver_movephone': '13952851861', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '本田', 'cur_mileage': '', 'sign_time': '2020-05-23', 'waiter': '张涛', 'settle_time': '', 'create_man': '超级用户', 'create_time': '2020/5/23 12:01:49'}, {'repair_id': 'KX191221001', 'state': '已竣工待结算', 'car_platenum': '苏L18Y55', 'repair_sort': '轮胎', 'driver': '朱先生', 'driver_movephone': '13805284806', 'total_money': '400.000000', 'cust_describe': '凯通蒋总', 'check_result': '', 'settle_money': '', 'low_money': '', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2019-12-21', 'waiter': '张涛', 'settle_time': '', 'create_man': '张涛', 'create_time': '2019/12/21 9:33:51'}, {'repair_id': 'KX250729010', 'state': '完成', 'car_platenum': '苏L8J971', 'repair_sort': '维修', 'driver': '孙先生', 'driver_movephone': '15152111396', 'total_money': '1600.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1600.000000', 'low_money': '0.000000', 'car_brand': '丰田', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '穆家奎', 'settle_time': '2025-07-29', 'create_man': '超级用户', 'create_time': '2025/7/29 17:18:43'}, {'repair_id': 'KX250729009', 'state': '完成', 'car_platenum': '苏LAK937', 'repair_sort': '事故', 'driver': '卢祥春', 'driver_movephone': '17834711064', 'total_money': '1380.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1380.000000', 'low_money': '0.000000', 'car_brand': '福特', 'cur_mileage': '', 'sign_time': '2025-07-29', 'waiter': '邢小军', 'settle_time': '2025-07-29', 'create_man': '超级用户', 'create_time': '2025/7/29 16:54:12'}, {'repair_id': 'KX250729003', 'state': '完成', 'car_platenum': '苏L6A988', 'repair_sort': '维修', 'driver': '江苏远望仪器集团有限公司', 'driver_movephone': '13376159975', 'total_money': '870.000000', 'cust_describe': '换下摆臂', 'check_result': '更换下摆臂', 'settle_money': '870.000000', 'low_money': '0.000000', 'car_brand': '科帕奇', 'cur_mileage': '115873.00', 'sign_time': '2025-07-29', 'waiter': '徐宗诚', 'settle_time': '2025-07-29', 'create_man': '超级用户', 'create_time': '2025/7/29 14:30:18'}, {'repair_id': 'KX250729001', 'state': '完成', 'car_platenum': '苏LEW791', 'repair_sort': '保养', 'driver': '尤卫中', 'driver_movephone': '15952812508', 'total_money': '658.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '601.300000', 'low_money': '0.000000', 'car_brand': '速腾', 'cur_mileage': '172392.00', 'sign_time': '2025-07-29', 'waiter': '孙飞', 'settle_time': '2025-07-29', 'create_man': '高安', 'create_time': '2025/7/29 10:32:58'}, {'repair_id': 'KX250728004', 'state': '完成', 'car_platenum': '苏LA444P', 'repair_sort': '保养', 'driver': '徐', 'driver_movephone': '', 'total_money': '780.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '663.000000', 'low_money': '0.000000', 'car_brand': 'A7', 'cur_mileage': '29046.00', 'sign_time': '2025-07-28', 'waiter': '高安', 'settle_time': '2025-07-28', 'create_man': '高安', 'create_time': '2025/7/28 15:06:40'}, {'repair_id': 'KX250728001', 'state': '完成', 'car_platenum': '苏AE8T72', 'repair_sort': '保养', 'driver': '宜万军', 'driver_movephone': '', 'total_money': '1208.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1208.000000', 'low_money': '0.000000', 'car_brand': '福特', 'cur_mileage': '82372.00', 'sign_time': '2025-07-28', 'waiter': '高安', 'settle_time': '2025-07-28', 'create_man': '高安', 'create_time': '2025/7/28 11:17:34'}, {'repair_id': 'KX250727008', 'state': '完成', 'car_platenum': '苏L872K7', 'repair_sort': '维修', 'driver': '纪', 'driver_movephone': '1816860188', 'total_money': '80.000000', 'cust_describe': '颠簸路面响', 'check_result': '更换平衡杆连接杆', 'settle_money': '80.000000', 'low_money': '0.000000', 'car_brand': '东南', 'cur_mileage': '', 'sign_time': '2025-07-27', 'waiter': '徐宗诚', 'settle_time': '2025-07-27', 'create_man': '徐宗诚', 'create_time': '2025/7/27 17:13:59'}, {'repair_id': 'KX250727005', 'state': '完成', 'car_platenum': '苏L9X101', 'repair_sort': '保养', 'driver': '方', 'driver_movephone': '13775535921', 'total_money': '618.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '518.000000', 'low_money': '0.000000', 'car_brand': '新福克斯', 'cur_mileage': '33347.00', 'sign_time': '2025-07-27', 'waiter': '宋振宇', 'settle_time': '2025-07-27', 'create_man': '宋振宇', 'create_time': '2025/7/27 13:14:42'}, {'repair_id': 'KX250727004', 'state': '完成', 'car_platenum': '苏LUB191', 'repair_sort': '钣金做漆', 'driver': '雷诺', 'driver_movephone': '', 'total_money': '300.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '300.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-27', 'waiter': '穆家奎', 'settle_time': '2025-07-27', 'create_man': '穆家奎', 'create_time': '2025/7/27 12:43:40'}, {'repair_id': 'KX250727003', 'state': '完成', 'car_platenum': '苏L0T700', 'repair_sort': '保养', 'driver': '小孙朋友', 'driver_movephone': '13776478801', 'total_money': '1090.000000', 'cust_describe': '保养', 'check_result': '保养三送一 第三次', 'settle_money': '895.000000', 'low_money': '0.000000', 'car_brand': '宝马', 'cur_mileage': '95127.00', 'sign_time': '2025-07-27', 'waiter': '徐宗诚', 'settle_time': '2025-07-27', 'create_man': '徐宗诚', 'create_time': '2025/7/27 12:40:22'}, {'repair_id': 'KX250727002', 'state': '完成', 'car_platenum': '苏A06N35', 'repair_sort': '保养', 'driver': '冯钰皓', 'driver_movephone': '15952059199', 'total_money': '1152.000000', 'cust_describe': '保养，发动机故障灯亮', 'check_result': '保养，检查发现缺缸，更换点火线圈，更换火花塞', 'settle_money': '995.300000', 'low_money': '0.000000', 'car_brand': '英朗XT', 'cur_mileage': '187387.00', 'sign_time': '2025-07-27', 'waiter': '宋振宇', 'settle_time': '2025-07-27', 'create_man': '宋振宇', 'create_time': '2025/7/27 12:17:06'}, {'repair_id': 'KX250727001', 'state': '完成', 'car_platenum': '苏A9L6A6', 'repair_sort': '维修', 'driver': '朱路', 'driver_movephone': '18862611026', 'total_money': '90.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '90.000000', 'low_money': '0.000000', 'car_brand': '高尔夫', 'cur_mileage': '', 'sign_time': '2025-07-27', 'waiter': '高安', 'settle_time': '2025-07-27', 'create_man': '高安', 'create_time': '2025/7/27 10:23:53'}, {'repair_id': 'KX250726003', 'state': '完成', 'car_platenum': '苏E48W7S', 'repair_sort': '维修', 'driver': '钱小平', 'driver_movephone': '15312364408', 'total_money': '270.000000', 'cust_describe': '有汽油味，大灯时而亮时而不亮', 'check_result': '更换油箱进油管，更换大灯继电器', 'settle_money': '270.000000', 'low_money': '0.000000', 'car_brand': '金杯', 'cur_mileage': '210636.00', 'sign_time': '2025-07-26', 'waiter': '宋振宇', 'settle_time': '2025-07-26', 'create_man': '宋振宇', 'create_time': '2025/7/26 17:06:17'}, {'repair_id': 'KX250726001', 'state': '完成', 'car_platenum': '苏L258GA', 'repair_sort': '产品销售', 'driver': '冷俊文', 'driver_movephone': '15952888332', 'total_money': '350.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '350.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-26', 'waiter': '管理员', 'settle_time': '2025-07-26', 'create_man': '超级用户', 'create_time': '2025/7/26 8:38:09'}, {'repair_id': 'KX250725005', 'state': '完成', 'car_platenum': '苏LAD987', 'repair_sort': '轮胎', 'driver': '孟先生', 'driver_movephone': '13952809703', 'total_money': '700.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '700.000000', 'low_money': '0.000000', 'car_brand': '蒙迪欧', 'cur_mileage': '', 'sign_time': '2025-07-25', 'waiter': '孙飞', 'settle_time': '2025-07-25', 'create_man': '孙飞', 'create_time': '2025/7/25 17:36:41'}, {'repair_id': 'KX250725004', 'state': '完成', 'car_platenum': '苏L06K20', 'repair_sort': '轮胎', 'driver': '张佾', 'driver_movephone': '13812451890', 'total_money': '350.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '350.000000', 'low_money': '0.000000', 'car_brand': '丰田', 'cur_mileage': '', 'sign_time': '2025-07-25', 'waiter': '孙飞', 'settle_time': '2025-07-25', 'create_man': '孙飞', 'create_time': '2025/7/25 16:59:52'}, {'repair_id': 'KX250725003', 'state': '完成', 'car_platenum': '苏LX1908', 'repair_sort': '轮胎', 'driver': '王先生', 'driver_movephone': '13912804765', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '30.000000', 'low_money': '0.000000', 'car_brand': '别克', 'cur_mileage': '', 'sign_time': '2025-07-25', 'waiter': '孙飞', 'settle_time': '2025-07-25', 'create_man': '孙飞', 'create_time': '2025/7/25 14:10:42'}, {'repair_id': 'KX250725002', 'state': '完成', 'car_platenum': '苏LHV776', 'repair_sort': '保养', 'driver': '陈亚秋', 'driver_movephone': '18806100052', 'total_money': '448.000000', 'cust_describe': '保养', 'check_result': '保养，前轮刹车片厚度还有四毫米左右，已告知客户，后门高位刹车灯不亮已告知客户', 'settle_money': '448.000000', 'low_money': '0.000000', 'car_brand': '福特翼虎', 'cur_mileage': '208870.00', 'sign_time': '2025-07-25', 'waiter': '宋振宇', 'settle_time': '2025-07-25', 'create_man': '宋振宇', 'create_time': '2025/7/25 10:28:10'}, {'repair_id': 'KX250725001', 'state': '完成', 'car_platenum': '苏L62V00', 'repair_sort': '年审', 'driver': '张凯', 'driver_movephone': '', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '200.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-25', 'waiter': '孙飞', 'settle_time': '2025-07-25', 'create_man': '孙飞', 'create_time': '2025/7/25 8:57:26'}, {'repair_id': 'KX250724011', 'state': '完成', 'car_platenum': '苏LDF7818', 'repair_sort': '轮胎', 'driver': '张伟', 'driver_movephone': '18952977939', 'total_money': '50.000000', 'cust_describe': '', 'check_result': '苏L5Q337大众买三送一退款941.5还有2次', 'settle_money': '50.000000', 'low_money': '0.000000', 'car_brand': '蔚来', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '孙飞', 'settle_time': '2025-07-25', 'create_man': '超级用户', 'create_time': '2025/7/24 17:54:20'}, {'repair_id': 'KX250724010', 'state': '完成', 'car_platenum': '苏L3G787', 'repair_sort': '保养', 'driver': '谢杨', 'driver_movephone': '13951401258', 'total_money': '618.000000', 'cust_describe': '', 'check_result': '买三送一 第四次', 'settle_money': '486.000000', 'low_money': '0.000000', 'car_brand': 'MG', 'cur_mileage': '51732.00', 'sign_time': '2025-07-23', 'waiter': '高安', 'settle_time': '2025-07-23', 'create_man': '高安', 'create_time': '2025/7/24 17:44:01'}, {'repair_id': 'KX250724009', 'state': '完成', 'car_platenum': '苏L8338K', 'repair_sort': '保养', 'driver': '徐小静', 'driver_movephone': '13016808338', 'total_money': '1360.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1172.000000', 'low_money': '0.000000', 'car_brand': '奔驰B200', 'cur_mileage': '75476.00', 'sign_time': '2025-07-24', 'waiter': '高安', 'settle_time': '2025-07-25', 'create_man': '超级用户', 'create_time': '2025/7/24 15:35:36'}, {'repair_id': 'KX250724008', 'state': '完成', 'car_platenum': '苏A5T9H7', 'repair_sort': '维修', 'driver': '叶先生', 'driver_movephone': '13951280373', 'total_money': '1725.000000', 'cust_describe': '启动有浓浓的烟，', 'check_result': '废气阀漏气，3缸积碳多。修好后未发现浓烟。检查时发现正时皮带有裂纹，发动机支架右漏油。正常更换。', 'settle_money': '1725.000000', 'low_money': '0.000000', 'car_brand': '沃尔沃X60', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '高安', 'settle_time': '2025-07-26', 'create_man': '超级用户', 'create_time': '2025/7/24 15:25:33'}, {'repair_id': 'KX250724007', 'state': '完成', 'car_platenum': '苏LBP529', 'repair_sort': '轮胎', 'driver': '王总', 'driver_movephone': '', 'total_money': '510.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '510.000000', 'low_money': '0.000000', 'car_brand': '本田', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '徐宗诚', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 15:13:51'}, {'repair_id': 'KX250724006', 'state': '完成', 'car_platenum': '苏L1L769', 'repair_sort': '产品销售', 'driver': '尹夕春', 'driver_movephone': '18652853180', 'total_money': '580.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '580.000000', 'low_money': '0.000000', 'car_brand': '奥迪', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '曹贴膜', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 14:31:12'}, {'repair_id': 'KX250724005', 'state': '完成', 'car_platenum': '闽JXT376', 'repair_sort': '轮胎', 'driver': '小牛', 'driver_movephone': '', 'total_money': '650.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '650.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '孙飞', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 13:49:01'}, {'repair_id': 'KX250724004', 'state': '完成', 'car_platenum': '苏LS669R', 'repair_sort': '轮胎', 'driver': '卢彬', 'driver_movephone': '13952816958', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '30.000000', 'low_money': '0.000000', 'car_brand': 'Q5L', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '孙飞', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 12:01:55'}, {'repair_id': 'KX250724003', 'state': '完成', 'car_platenum': '苏L555M7', 'repair_sort': '维修', 'driver': '孔繁勇', 'driver_movephone': '18151901333', 'total_money': '240.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '240.000000', 'low_money': '0.000000', 'car_brand': '福特', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '高安', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 10:11:34'}, {'repair_id': 'KX250724002', 'state': '完成', 'car_platenum': '苏LX8168', 'repair_sort': '维修', 'driver': '唐先生', 'driver_movephone': '13905281028', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '0.000000', 'low_money': '0.000000', 'car_brand': '宝马X5', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '管理员', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/24 9:10:04'}, {'repair_id': 'KX250723009', 'state': '完成', 'car_platenum': '苏LZ0280', 'repair_sort': '维修', 'driver': '顾小安', 'driver_movephone': '18952811353', 'total_money': '180.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '180.000000', 'low_money': '0.000000', 'car_brand': '奥迪A3', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '管理员', 'settle_time': '2025-07-23', 'create_man': '超级用户', 'create_time': '2025/7/23 11:17:08'}, {'repair_id': 'KX250723007', 'state': '完成', 'car_platenum': '苏L097H3', 'repair_sort': '维修', 'driver': '镇江华云化工有限公司', 'driver_movephone': '余13306102398', 'total_money': '20.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '20.000000', 'low_money': '0.000000', 'car_brand': '奥德赛', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '穆家奎', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/23 10:19:37'}, {'repair_id': 'KX250723006', 'state': '完成', 'car_platenum': '苏L1L769', 'repair_sort': '维修', 'driver': '尹夕春', 'driver_movephone': '18652853180', 'total_money': '880.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '880.000000', 'low_money': '0.000000', 'car_brand': '奥迪', 'cur_mileage': '', 'sign_time': '2025-07-24', 'waiter': '装玻璃', 'settle_time': '2025-07-24', 'create_man': '超级用户', 'create_time': '2025/7/23 9:53:45'}, {'repair_id': 'KX250723005', 'state': '完成', 'car_platenum': '苏L3X688', 'repair_sort': '事故', 'driver': '叶飞', 'driver_movephone': '18252581995', 'total_money': '2930.000000', 'cust_describe': '', 'check_result': '人保事故', 'settle_money': '2930.000000', 'low_money': '0.000000', 'car_brand': '沃尔沃', 'cur_mileage': '', 'sign_time': '2025-07-22', 'waiter': '装玻璃', 'settle_time': '2025-07-22', 'create_man': '超级用户', 'create_time': '2025/7/23 9:34:07'}, {'repair_id': 'KX250723004', 'state': '完成', 'car_platenum': '苏L33C93', 'repair_sort': '年审', 'driver': '殷先生', 'driver_movephone': '13952883992', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '200.000000', 'low_money': '0.000000', 'car_brand': '卡罗拉', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '孙飞', 'settle_time': '2025-07-23', 'create_man': '孙飞', 'create_time': '2025/7/23 9:28:15'}, {'repair_id': 'KX250723003', 'state': '完成', 'car_platenum': '苏L3X688', 'repair_sort': '产品销售', 'driver': '叶飞', 'driver_movephone': '18252581995', 'total_money': '251.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '251.000000', 'low_money': '0.000000', 'car_brand': '沃尔沃', 'cur_mileage': '', 'sign_time': '2025-07-22', 'waiter': '管理员', 'settle_time': '2025-07-22', 'create_man': '超级用户', 'create_time': '2025/7/23 9:14:46'}, {'repair_id': 'KX250723002', 'state': '完成', 'car_platenum': '苏L718M6', 'repair_sort': '保养', 'driver': '钱', 'driver_movephone': '', 'total_money': '403.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '346.300000', 'low_money': '0.000000', 'car_brand': '英朗', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '高安', 'settle_time': '2025-07-23', 'create_man': '超级用户', 'create_time': '2025/7/23 9:13:23'}, {'repair_id': 'KX250723001', 'state': '完成', 'car_platenum': '苏L727U0', 'repair_sort': '事故', 'driver': '陈洪筛', 'driver_movephone': '13092697013', 'total_money': '2100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '2100.000000', 'low_money': '0.000000', 'car_brand': '本田', 'cur_mileage': '', 'sign_time': '2025-07-23', 'waiter': '邢小军', 'settle_time': '2025-07-23', 'create_man': '超级用户', 'create_time': '2025/7/23 9:03:52'}, {'repair_id': 'KX250722005', 'state': '完成', 'car_platenum': '苏LA753E', 'repair_sort': '轮胎', 'driver': '张佳伟', 'driver_movephone': '17705296871', 'total_money': '1380.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1380.000000', 'low_money': '0.000000', 'car_brand': '奥迪A3', 'cur_mileage': '', 'sign_time': '2025-07-22', 'waiter': '孙飞', 'settle_time': '2025-07-22', 'create_man': '孙飞', 'create_time': '2025/7/22 15:22:51'}, {'repair_id': 'KX250722004', 'state': '完成', 'car_platenum': '苏A0C1Y7', 'repair_sort': '电瓶', 'driver': '李莎', 'driver_movephone': '17712820067', 'total_money': '0.000000', 'cust_describe': '', 'check_result': '售后', 'settle_money': '0.000000', 'low_money': '0.000000', 'car_brand': '起亚KX3', 'cur_mileage': '', 'sign_time': '2025-07-22', 'waiter': '孙飞', 'settle_time': '2025-07-22', 'create_man': '孙飞', 'create_time': '2025/7/22 14:20:57'}, {'repair_id': 'KX250722003', 'state': '完成', 'car_platenum': '浙AV623J', 'repair_sort': '保养', 'driver': '谢志强', 'driver_movephone': '13004367275', 'total_money': '2744.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '2582.000000', 'low_money': '0.000000', 'car_brand': '捷豹', 'cur_mileage': '125838.00', 'sign_time': '2025-07-22', 'waiter': '徐宗诚', 'settle_time': '2025-07-24', 'create_man': '徐宗诚', 'create_time': '2025/7/22 13:23:07'}, {'repair_id': 'KX250721005', 'state': '完成', 'car_platenum': '苏L76R23', 'repair_sort': '维修', 'driver': '朱老师', 'driver_movephone': '', 'total_money': '750.000000', 'cust_describe': '没空调', 'check_result': '更换冷凝器', 'settle_money': '650.000000', 'low_money': '0.000000', 'car_brand': '别克', 'cur_mileage': '', 'sign_time': '2025-07-21', 'waiter': '宋振宇', 'settle_time': '2025-07-21', 'create_man': '宋振宇', 'create_time': '2025/7/21 17:54:54'}, {'repair_id': 'KX250721004', 'state': '完成', 'car_platenum': '苏L2211F', 'repair_sort': '保养', 'driver': '穆为光', 'driver_movephone': '15189102300', 'total_money': '903.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '903.000000', 'low_money': '0.000000', 'car_brand': '奥迪A6', 'cur_mileage': '155065.00', 'sign_time': '2025-07-21', 'waiter': '穆家奎', 'settle_time': '2025-07-21', 'create_man': '穆家奎', 'create_time': '2025/7/21 16:44:27'}, {'repair_id': 'KX250721003', 'state': '完成', 'car_platenum': '苏L0566K', 'repair_sort': '维修', 'driver': '邓岳', 'driver_movephone': '13705284651', 'total_money': '855.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '855.000000', 'low_money': '0.000000', 'car_brand': '奔驰', 'cur_mileage': '', 'sign_time': '2025-07-21', 'waiter': '高安', 'settle_time': '2025-07-21', 'create_man': '超级用户', 'create_time': '2025/7/21 14:20:44'}, {'repair_id': 'KX250721002', 'state': '完成', 'car_platenum': '苏LU872P', 'repair_sort': '维修', 'driver': '洪小银', 'driver_movephone': '13347776877', 'total_money': '140.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '140.000000', 'low_money': '0.000000', 'car_brand': '日产颐达', 'cur_mileage': '', 'sign_time': '2025-07-21', 'waiter': '穆家奎', 'settle_time': '2025-07-21', 'create_man': '穆家奎', 'create_time': '2025/7/21 11:07:58'}, {'repair_id': 'KX250721001', 'state': '完成', 'car_platenum': '浙G3X1F0', 'repair_sort': '年审', 'driver': '长安', 'driver_movephone': '13819941044', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '200.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-21', 'waiter': '孙飞', 'settle_time': '2025-07-22', 'create_man': '孙飞', 'create_time': '2025/7/21 10:35:51'}, {'repair_id': 'KX250720003', 'state': '完成', 'car_platenum': '苏LM8102', 'repair_sort': '保养', 'driver': '蔣先生', 'driver_movephone': '18015980777', 'total_money': '448.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '391.300000', 'low_money': '0.000000', 'car_brand': '丰田卡罗拉', 'cur_mileage': '187293.00', 'sign_time': '2025-07-20', 'waiter': '宋振宇', 'settle_time': '2025-07-20', 'create_man': '宋振宇', 'create_time': '2025/7/20 14:17:03'}, {'repair_id': 'KX250720002', 'state': '完成', 'car_platenum': '苏L1970R', 'repair_sort': '维修', 'driver': '彭女士', 'driver_movephone': '13861390950', 'total_money': '1688.000000', 'cust_describe': '维修', 'check_result': '更换刹车油 防冻液 变速箱油 进气管 空滤 空调滤 火花塞', 'settle_money': '1688.000000', 'low_money': '0.000000', 'car_brand': '雪铁龙', 'cur_mileage': '120170.00', 'sign_time': '2025-07-20', 'waiter': '徐宗诚', 'settle_time': '2025-07-24', 'create_man': '徐宗诚', 'create_time': '2025/7/20 11:23:57'}, {'repair_id': 'KX250720001', 'state': '完成', 'car_platenum': '苏L0920B', 'repair_sort': '维修', 'driver': '徐莉莉', 'driver_movephone': '13775362662', 'total_money': '360.000000', 'cust_describe': '漏防冻液', 'check_result': '更换补水壶', 'settle_money': '290.000000', 'low_money': '0.000000', 'car_brand': '奔驰B', 'cur_mileage': '105844.00', 'sign_time': '2025-07-20', 'waiter': '宋振宇', 'settle_time': '2025-07-20', 'create_man': '宋振宇', 'create_time': '2025/7/20 10:13:38'}, {'repair_id': 'KX250719010', 'state': '完成', 'car_platenum': '苏L33C93', 'repair_sort': '保养', 'driver': '殷先生', 'driver_movephone': '13952883992', 'total_money': '368.000000', 'cust_describe': '保养', 'check_result': '保养', 'settle_money': '368.000000', 'low_money': '0.000000', 'car_brand': '卡罗拉', 'cur_mileage': '84551.00', 'sign_time': '2025-07-19', 'waiter': '宋振宇', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 16:16:24'}, {'repair_id': 'KX250719009', 'state': '完成', 'car_platenum': '苏LRJ112', 'repair_sort': '维修', 'driver': '周宇', 'driver_movephone': '15850442950', 'total_money': '120.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '120.000000', 'low_money': '0.000000', 'car_brand': '凯美瑞', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '高安', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 15:38:01'}, {'repair_id': 'KX250719008', 'state': '完成', 'car_platenum': '苏LD33766', 'repair_sort': '钣金做漆', 'driver': '史克飞', 'driver_movephone': '13815486080', 'total_money': '100.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '100.000000', 'low_money': '0.000000', 'car_brand': '小米', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '邢小军', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 15:24:31'}, {'repair_id': 'KX250719007', 'state': '完成', 'car_platenum': '苏L5111H', 'repair_sort': '轮胎', 'driver': '左光辉', 'driver_movephone': '13805289161', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '30.000000', 'low_money': '0.000000', 'car_brand': '东南', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '孙飞', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 14:36:07'}, {'repair_id': 'KX250719006', 'state': '完成', 'car_platenum': '浙C0M715', 'repair_sort': '维修', 'driver': '小牛', 'driver_movephone': '', 'total_money': '1000.000000', 'cust_describe': '', 'check_result': '维修质保一年', 'settle_money': '1000.000000', 'low_money': '0.000000', 'car_brand': '雷克萨斯', 'cur_mileage': '', 'sign_time': '2025-07-21', 'waiter': '高安', 'settle_time': '2025-07-22', 'create_man': '超级用户', 'create_time': '2025/7/19 13:50:42'}, {'repair_id': 'KX250719005', 'state': '完成', 'car_platenum': '苏LJF710', 'repair_sort': '轮胎', 'driver': '苏LJF710', 'driver_movephone': '', 'total_money': '20.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '20.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '孙飞', 'settle_time': '2025-07-19', 'create_man': '孙飞', 'create_time': '2025/7/19 12:57:41'}, {'repair_id': 'KX250719002', 'state': '完成', 'car_platenum': '苏LT278J', 'repair_sort': '轮胎', 'driver': '王成辰', 'driver_movephone': '18952898765', 'total_money': '450.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '450.000000', 'low_money': '0.000000', 'car_brand': 'polo', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '孙飞', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 9:08:26'}, {'repair_id': 'KX250719001', 'state': '完成', 'car_platenum': '苏A9L6A6', 'repair_sort': '维修', 'driver': '朱路', 'driver_movephone': '18862611026', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '200.000000', 'low_money': '0.000000', 'car_brand': '高尔夫', 'cur_mileage': '', 'sign_time': '2025-07-19', 'waiter': '管理员', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/19 9:04:42'}, {'repair_id': 'KX250718005', 'state': '完成', 'car_platenum': '苏L882J1', 'repair_sort': '维修', 'driver': '陈方正', 'driver_movephone': '13505281805', 'total_money': '1310.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1310.000000', 'low_money': '0.000000', 'car_brand': '奥迪A4', 'cur_mileage': '', 'sign_time': '2025-07-18', 'waiter': '管理员', 'settle_time': '2025-07-18', 'create_man': '超级用户', 'create_time': '2025/7/18 16:18:41'}, {'repair_id': 'KX250718004', 'state': '完成', 'car_platenum': '粤C6536H', 'repair_sort': '轮胎', 'driver': '云先生', 'driver_movephone': '17601358845', 'total_money': '320.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '320.000000', 'low_money': '0.000000', 'car_brand': '大众', 'cur_mileage': '', 'sign_time': '2025-07-18', 'waiter': '孙飞', 'settle_time': '2025-07-18', 'create_man': '超级用户', 'create_time': '2025/7/18 15:16:33'}, {'repair_id': 'KX250718003', 'state': '完成', 'car_platenum': '苏A9L6A6', 'repair_sort': '保养', 'driver': '朱路', 'driver_movephone': '18862611026', 'total_money': '878.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '878.000000', 'low_money': '0.000000', 'car_brand': '高尔夫', 'cur_mileage': '193281.00', 'sign_time': '2025-07-18', 'waiter': '高安', 'settle_time': '2025-07-18', 'create_man': '超级用户', 'create_time': '2025/7/18 13:12:11'}, {'repair_id': 'KX250718002', 'state': '完成', 'car_platenum': '苏L052F3', 'repair_sort': '维修', 'driver': '张', 'driver_movephone': '15996848586', 'total_money': '80.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '80.000000', 'low_money': '0.000000', 'car_brand': '雪佛兰', 'cur_mileage': '', 'sign_time': '2025-07-18', 'waiter': '穆家奎', 'settle_time': '2025-07-18', 'create_man': '超级用户', 'create_time': '2025/7/18 9:49:36'}, {'repair_id': 'KX250718001', 'state': '完成', 'car_platenum': '苏L792Q0', 'repair_sort': '维修', 'driver': '朱顺', 'driver_movephone': '13812461258', 'total_money': '140.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '140.000000', 'low_money': '0.000000', 'car_brand': '丰田', 'cur_mileage': '', 'sign_time': '2025-07-18', 'waiter': '管理员', 'settle_time': '2025-07-18', 'create_man': '超级用户', 'create_time': '2025/7/18 8:49:59'}, {'repair_id': 'KX250716008', 'state': '完成', 'car_platenum': '苏L15C11', 'repair_sort': '轮胎', 'driver': '小牛', 'driver_movephone': '', 'total_money': '410.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '410.000000', 'low_money': '0.000000', 'car_brand': '雨燕', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '孙飞', 'settle_time': '2025-07-16', 'create_man': '孙飞', 'create_time': '2025/7/16 14:46:07'}, {'repair_id': 'KX250716007', 'state': '完成', 'car_platenum': '苏L7099G', 'repair_sort': '维修', 'driver': '张文春', 'driver_movephone': '18912115355', 'total_money': '60.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '60.000000', 'low_money': '0.000000', 'car_brand': '明锐', 'cur_mileage': '', 'sign_time': '2025-07-06', 'waiter': '穆家奎', 'settle_time': '2025-07-06', 'create_man': '超级用户', 'create_time': '2025/7/16 14:05:28'}, {'repair_id': 'KX250716006', 'state': '完成', 'car_platenum': '苏L30S36', 'repair_sort': '维修', 'driver': '史克飞', 'driver_movephone': '13815486080', 'total_money': '785.000000', 'cust_describe': '漏冷媒', 'check_result': '', 'settle_money': '785.000000', 'low_money': '0.000000', 'car_brand': '大众', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '宋振宇', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/16 11:27:09'}, {'repair_id': 'KX250716004', 'state': '完成', 'car_platenum': '苏L5777X', 'repair_sort': '年审', 'driver': '马超', 'driver_movephone': '13952850444', 'total_money': '200.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '200.000000', 'low_money': '0.000000', 'car_brand': '宝马', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '孙飞', 'settle_time': '2025-07-16', 'create_man': '孙飞', 'create_time': '2025/7/16 9:54:09'}, {'repair_id': 'KX250716003', 'state': '完成', 'car_platenum': '苏L12K02', 'repair_sort': '钣金做漆', 'driver': '宗晓明', 'driver_movephone': '18952882172', 'total_money': '250.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '250.000000', 'low_money': '0.000000', 'car_brand': '别克凯越', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '邢小军', 'settle_time': '2025-07-19', 'create_man': '超级用户', 'create_time': '2025/7/16 9:41:50'}, {'repair_id': 'KX250716002', 'state': '完成', 'car_platenum': '苏LE777Y', 'repair_sort': '保养', 'driver': '马晓冰', 'driver_movephone': '18605113987', 'total_money': '1570.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '1453.000000', 'low_money': '0.000000', 'car_brand': '奥迪A4', 'cur_mileage': '27782.00', 'sign_time': '2025-07-16', 'waiter': '高安', 'settle_time': '2025-07-20', 'create_man': '超级用户', 'create_time': '2025/7/16 9:32:22'}, {'repair_id': 'KX250716001', 'state': '完成', 'car_platenum': '苏LW1619', 'repair_sort': '轮胎', 'driver': '何总', 'driver_movephone': '', 'total_money': '30.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '30.000000', 'low_money': '0.000000', 'car_brand': '奥迪A6L', 'cur_mileage': '', 'sign_time': '2025-07-16', 'waiter': '孙飞', 'settle_time': '2025-07-16', 'create_man': '超级用户', 'create_time': '2025/7/16 8:57:44'}, {'repair_id': 'KX250715004', 'state': '完成', 'car_platenum': '苏E48W7S', 'repair_sort': '维修', 'driver': '钱小平', 'driver_movephone': '15312364408', 'total_money': '320.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '320.000000', 'low_money': '0.000000', 'car_brand': '金杯', 'cur_mileage': '', 'sign_time': '2025-07-09', 'waiter': '高安', 'settle_time': '2025-07-09', 'create_man': '超级用户', 'create_time': '2025/7/15 15:18:01'}, {'repair_id': 'KX250715003', 'state': '完成', 'car_platenum': '沪EHH265', 'repair_sort': '年审', 'driver': 'X3', 'driver_movephone': '', 'total_money': '250.000000', 'cust_describe': '', 'check_result': '', 'settle_money': '250.000000', 'low_money': '0.000000', 'car_brand': '', 'cur_mileage': '', 'sign_time': '2025-07-15', 'waiter': '孙飞', 'settle_time': '2025-07-15', 'create_man': '孙飞', 'create_time': '2025/7/15 10:08:16'}], 'footer': [{'manage': '合计', 'total_money': 11842696.18, 'settle_money': 11693963.68, 'low_money': 141712.0}]}\n"
|
|
]
|
|
}
|
|
],
|
|
"execution_count": 11
|
|
},
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "markdown",
|
|
"source": "### 历史维修记录明细",
|
|
"id": "2b2610c132b26565"
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-07-31T07:11:32.457785Z",
|
|
"start_time": "2025-07-31T07:03:37.366711Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": [
|
|
"import requests\n",
|
|
"import pandas as pd\n",
|
|
"from urllib.parse import quote\n",
|
|
"import time\n",
|
|
"from tqdm import tqdm\n",
|
|
"\n",
|
|
"# 编码用户名\n",
|
|
"loginuser_encoded = quote('超级用户') # -> '%E8%B6%85%E7%BA%A7%E7%94%A8%E6%88%B7'\n",
|
|
"loginempname_encoded = quote('管理员')\n",
|
|
"url = \"http://114.220.76.90:6060/repair/httphandler/get_repair_item.ashx\"\n",
|
|
"\n",
|
|
"# 读取Excel文件\n",
|
|
"try:\n",
|
|
" df = pd.read_excel(r\"C:\\Users\\Administrator.DESKTOP-7IC2USJ\\Downloads\\业务管理_202507311458475.xls\",\n",
|
|
" sheet_name=\"Test\")\n",
|
|
"except Exception as e:\n",
|
|
" print(f\"读取Excel文件失败: {e}\")\n",
|
|
" exit()\n",
|
|
"\n",
|
|
"# 设置会话保持\n",
|
|
"session = requests.Session()\n",
|
|
"all_data = []\n",
|
|
"\n",
|
|
"def make_request_with_retry(session, url, headers, cookies, params, max_retries=5, delay=10):\n",
|
|
" for attempt in range(max_retries):\n",
|
|
" try:\n",
|
|
" response = session.get(url, headers=headers, cookies=cookies,\n",
|
|
" params=params, verify=False, timeout=10)\n",
|
|
"\n",
|
|
" if response.status_code == 200:\n",
|
|
" return response\n",
|
|
" else:\n",
|
|
" print(f\"尝试 {attempt + 1}/{max_retries} 失败，状态码: {response.status_code}\")\n",
|
|
" if attempt < max_retries - 1:\n",
|
|
" time.sleep(delay)\n",
|
|
" except requests.exceptions.RequestException as e:\n",
|
|
" print(f\"尝试 {attempt + 1}/{max_retries} 失败，错误: {e}\")\n",
|
|
" if attempt < max_retries - 1:\n",
|
|
" time.sleep(delay)\n",
|
|
" return None\n",
|
|
"\n",
|
|
"for index, row in tqdm(df.iterrows(), total=len(df), desc=\"处理进度\"):\n",
|
|
" repair_id = row['维修单号']\n",
|
|
"\n",
|
|
" # 添加请求头\n",
|
|
" headers = {\n",
|
|
" 'Referer': f'http://114.220.76.90:6060/repair/repair_detail.html?repair_id={repair_id}&v=V6.19.0415',\n",
|
|
" 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',\n",
|
|
" 'Accept': 'application/json, text/javascript, */*; q=0.01',\n",
|
|
" 'Accept-Language': 'zh-CN,zh;q=0.9',\n",
|
|
" }\n",
|
|
"\n",
|
|
" # 设置cookies\n",
|
|
" cookies = {\n",
|
|
" 'td_cookie': '2361446951',\n",
|
|
" 'ASP.NET_SessionId': 'l4bbsjffyuhmgmgwmwkelemv',\n",
|
|
" 'dbname': 'db_180723001',\n",
|
|
" 'loginuser': loginuser_encoded,\n",
|
|
" 'loginempname': loginempname_encoded,\n",
|
|
" 'orgid': '1'\n",
|
|
" }\n",
|
|
"\n",
|
|
" params = {'repair_id': repair_id}\n",
|
|
"\n",
|
|
" response = make_request_with_retry(session, url, headers, cookies, params)\n",
|
|
"\n",
|
|
" if response is None:\n",
|
|
" print(f\"维修单号 {repair_id} 的所有重试均失败，跳过此单\")\n",
|
|
" continue\n",
|
|
"\n",
|
|
" try:\n",
|
|
" # 尝试解析JSON响应\n",
|
|
" data = response.json()\n",
|
|
"\n",
|
|
" # 处理响应数据\n",
|
|
" ritem = data.get(\"ritem\", [])\n",
|
|
" product = data.get(\"product\", [])\n",
|
|
"\n",
|
|
" # 将行数据转换为字典\n",
|
|
" row_dict = row.to_dict()\n",
|
|
"\n",
|
|
" # 合并维修项数据\n",
|
|
" for item in ritem:\n",
|
|
" if isinstance(item, dict):\n",
|
|
" merged_item = {**row_dict, **item}\n",
|
|
" all_data.append(merged_item)\n",
|
|
"\n",
|
|
" # 合并产品数据\n",
|
|
" for prod in product:\n",
|
|
" if isinstance(prod, dict):\n",
|
|
" merged_prod = {**row_dict, **prod}\n",
|
|
" all_data.append(merged_prod)\n",
|
|
"\n",
|
|
" except ValueError:\n",
|
|
" print(f\"维修单号 {repair_id} 的响应内容不是有效的JSON:\", response.text)\n",
|
|
" continue\n",
|
|
"\n",
|
|
" # 添加延迟，避免请求过于频繁\n",
|
|
" # time.sleep(2)\n",
|
|
"\n",
|
|
"# 保存数据到Excel\n",
|
|
"if all_data:\n",
|
|
" result_df = pd.DataFrame(all_data)\n",
|
|
" try:\n",
|
|
" result_df.to_excel('output.xlsx', index=False)\n",
|
|
" print(\"数据已成功保存到output.xlsx\")\n",
|
|
" except Exception as e:\n",
|
|
" print(f\"保存文件失败: {e}\")\n",
|
|
"else:\n",
|
|
" print(\"没有获取到有效数据\")"
|
|
],
|
|
"id": "9245e089e4ca0639",
|
|
"outputs": [
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"D:\\ProgramTools\\Anaconda\\Lib\\site-packages\\openpyxl\\styles\\stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default\n",
|
|
" warn(\"Workbook contains no default style, apply openpyxl's default\")\n",
|
|
"处理进度: 100%|██████████| 14434/14434 [07:22<00:00, 32.60it/s]\n"
|
|
]
|
|
},
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"数据已成功保存到output.xlsx\n"
|
|
]
|
|
}
|
|
],
|
|
"execution_count": 21
|
|
}
|
|
],
|
|
"metadata": {
|
|
"kernelspec": {
|
|
"display_name": "Python 3",
|
|
"language": "python",
|
|
"name": "python3"
|
|
},
|
|
"language_info": {
|
|
"codemirror_mode": {
|
|
"name": "ipython",
|
|
"version": 2
|
|
},
|
|
"file_extension": ".py",
|
|
"mimetype": "text/x-python",
|
|
"name": "python",
|
|
"nbconvert_exporter": "python",
|
|
"pygments_lexer": "ipython2",
|
|
"version": "2.7.6"
|
|
}
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 5
|
|
}
|