{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", ":60: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n" ] } ], "source": [ "import pandas as pd\n", "import requests\n", "import json\n", "import math\n", "import xlrd\n", "from pprint import pprint\n", "cookies_str = 'PHPSESSID=8drfmud5pe87gbsfj7ngec486a'\n", "\n", "cookies_str = cookies_str.encode('utf-8').decode('latin-1')\n", "\n", "cookie_dict = {item.split('=')[0]: item.split('=')[1]\n", " for item in cookies_str.split('; ')}\n", "\n", "headers = {\n", " 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36',\n", " \"Content-Type\": \"application/json;charset=UTF-8\",\n", " 'referer':'https://crm.hfbsoftware.com/'\n", "\n", "}\n", "df = pd.read_excel(r'C:\\Users\\admin\\Desktop\\智能统车.xls',sheet_name='Sheet6',dtype='string')\n", "\n", "for da in df.values:\n", " json1={\n", " \"search\": \"\",\n", " \"sid\": da[0],\n", " \"is_member\": \"\",\n", " \"item_type\": \"\",\n", " \"start_time\": da[1],\n", " \"end_time\": da[2],\n", " \"page\": 1,\n", " \"quantity\": 100\n", " }\n", " url = 'https://api.hfbsoftware.com/storeadmin/Financial/getOrderDetailList'\n", " res = requests.post(url,cookies=cookie_dict,headers=headers,json=json1)\n", " strele = res.json()\n", " aaaa = strele['data']['total'] / 100\n", " aaaa = math.floor(aaaa)\n", " # 创建一个空的DataFrame\n", " all_data = pd.DataFrame()\n", " for i in range(1,aaaa+2):\n", " json2={\n", " \"search\": \"\",\n", " \"sid\": da[0],\n", " \"is_member\": \"\",\n", " \"item_type\": \"\",\n", " \"start_time\": da[1],\n", " \"end_time\": da[2],\n", " \"page\": i,\n", " \"quantity\": 100\n", " }\n", " url = 'https://api.hfbsoftware.com/storeadmin/Financial/getOrderDetailList'\n", " res1 = requests.post(url,cookies=cookie_dict,headers=headers,json=json2)\n", " strele1 = res1.json()\n", " for a in range(0,len(strele1['data']['data'])):\n", " data_list = [strele1['data']['data'][a]]\n", " df_new1 = pd.DataFrame(data_list)\n", " # 将当前接口的数据添加到总数据中\n", " all_data = all_data._append(df_new1, ignore_index=True)\n", " \n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\智能统车,{},{},{}.xlsx'.format(da[3],da[1],da[2]))\n", "\n" ] }, { "cell_type": "code", "execution_count": 72, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
order_snin_factory_timecategory_namenamechepaitelvinp_chexingmingchengmileageupdate_time...wechat_official_payintergal_payalipaypreferential_amountcoupons_amountcard_nototal_amountreal_priceinsurance_creditinadequate_credit
0202408011610336013512024-08-01 16:09:55None先生赣A0FK5617779101463None02024-08-01 16:10:50...0.000.000.000.000None0.000.000.000.00
1202408011609256012562024-08-01 16:09:01None杨先生赣A0P29913627911912None02024-08-01 16:09:44...0.000.000.000.000None0.000.000.000.00
2202408011609256012562024-08-01 16:09:01None杨先生赣A0P29913627911912None02024-08-01 16:09:44...0.000.000.000.000None0.000.000.000.00
3202408011608386014192024-08-01 16:08:10None陈先生赣A2218S18897951610None02024-08-01 16:08:56...0.000.000.000.000None0.000.000.000.00
4202408011607376014432024-08-01 16:07:14None杨先生赣A318P815170497679None02024-08-01 16:07:58...0.000.000.000.000None0.000.000.000.00
..................................................................
184202407311910416016392024-07-31 19:10:41None朱先生赣AWT506181070898288None02024-08-01 09:14:12...0.000.000.000.000None632.000.000.000.00
185202407311910416016392024-07-31 19:10:41None朱先生赣AWT506181070898288None02024-08-01 09:14:12...0.000.000.000.000None632.000.000.000.00
186202407311910416016392024-07-31 19:10:41None朱先生赣AWT506181070898288None02024-08-01 09:14:12...0.000.000.000.000None632.000.000.000.00
187202407311910416016392024-07-31 19:10:41None朱先生赣AWT506181070898288None02024-08-01 09:14:12...0.000.000.000.000None632.000.000.000.00
188202407311910416016392024-07-31 19:10:41None朱先生赣AWT506181070898288None02024-08-01 09:14:12...0.000.000.000.000None632.000.000.000.00
\n", "

189 rows × 42 columns

\n", "
" ], "text/plain": [ " order_sn in_factory_time category_name name chepai \n", "0 20240801161033601351 2024-08-01 16:09:55 None 先生 赣A0FK56 \\\n", "1 20240801160925601256 2024-08-01 16:09:01 None 杨先生 赣A0P299 \n", "2 20240801160925601256 2024-08-01 16:09:01 None 杨先生 赣A0P299 \n", "3 20240801160838601419 2024-08-01 16:08:10 None 陈先生 赣A2218S \n", "4 20240801160737601443 2024-08-01 16:07:14 None 杨先生 赣A318P8 \n", ".. ... ... ... ... ... \n", "184 20240731191041601639 2024-07-31 19:10:41 None 朱先生 赣AWT506 \n", "185 20240731191041601639 2024-07-31 19:10:41 None 朱先生 赣AWT506 \n", "186 20240731191041601639 2024-07-31 19:10:41 None 朱先生 赣AWT506 \n", "187 20240731191041601639 2024-07-31 19:10:41 None 朱先生 赣AWT506 \n", "188 20240731191041601639 2024-07-31 19:10:41 None 朱先生 赣AWT506 \n", "\n", " tel vin p_chexingmingcheng mileage update_time ... \n", "0 17779101463 None 0 2024-08-01 16:10:50 ... \\\n", "1 13627911912 None 0 2024-08-01 16:09:44 ... \n", "2 13627911912 None 0 2024-08-01 16:09:44 ... \n", "3 18897951610 None 0 2024-08-01 16:08:56 ... \n", "4 15170497679 None 0 2024-08-01 16:07:58 ... \n", ".. ... .. ... ... ... ... \n", "184 181070898288 None 0 2024-08-01 09:14:12 ... \n", "185 181070898288 None 0 2024-08-01 09:14:12 ... \n", "186 181070898288 None 0 2024-08-01 09:14:12 ... \n", "187 181070898288 None 0 2024-08-01 09:14:12 ... \n", "188 181070898288 None 0 2024-08-01 09:14:12 ... \n", "\n", " wechat_official_pay intergal_pay alipay preferential_amount \n", "0 0.00 0.00 0.00 0.00 \\\n", "1 0.00 0.00 0.00 0.00 \n", "2 0.00 0.00 0.00 0.00 \n", "3 0.00 0.00 0.00 0.00 \n", "4 0.00 0.00 0.00 0.00 \n", ".. ... ... ... ... \n", "184 0.00 0.00 0.00 0.00 \n", "185 0.00 0.00 0.00 0.00 \n", "186 0.00 0.00 0.00 0.00 \n", "187 0.00 0.00 0.00 0.00 \n", "188 0.00 0.00 0.00 0.00 \n", "\n", " coupons_amount card_no total_amount real_price insurance_credit \n", "0 0 None 0.00 0.00 0.00 \\\n", "1 0 None 0.00 0.00 0.00 \n", "2 0 None 0.00 0.00 0.00 \n", "3 0 None 0.00 0.00 0.00 \n", "4 0 None 0.00 0.00 0.00 \n", ".. ... ... ... ... ... \n", "184 0 None 632.00 0.00 0.00 \n", "185 0 None 632.00 0.00 0.00 \n", "186 0 None 632.00 0.00 0.00 \n", "187 0 None 632.00 0.00 0.00 \n", "188 0 None 632.00 0.00 0.00 \n", "\n", " inadequate_credit \n", "0 0.00 \n", "1 0.00 \n", "2 0.00 \n", "3 0.00 \n", "4 0.00 \n", ".. ... \n", "184 0.00 \n", "185 0.00 \n", "186 0.00 \n", "187 0.00 \n", "188 0.00 \n", "\n", "[189 rows x 42 columns]" ] }, "execution_count": 72, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_data" ] }, { "cell_type": "code", "execution_count": 61, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ ":1: UserWarning: Pandas requires version '1.4.3' or newer of 'xlsxwriter' (version '1.3.8' currently installed).\n", " all_data.to_excel(r'C:\\Users\\admin\\Downloads\\1111111111111111.xlsx')\n" ] } ], "source": [ "all_data.to_excel(r'C:\\Users\\admin\\Downloads\\1111111111111111.xlsx')" ] }, { "cell_type": "code", "execution_count": 62, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1" ] }, "execution_count": 62, "metadata": {}, "output_type": "execute_result" } ], "source": [ "aaaa" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'order_sn': '20240801161033601351',\n", " 'in_factory_time': '2024-08-01 16:09:55',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '赣A0FK56',\n", " 'tel': '17779101463',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:10:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '蓄电池传感器',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '390.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:10:33',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'}" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "\n", "data_list = [strele['data']['data'][0]]\n", "df_new = pd.DataFrame(data_list)\n", "# 合并两个DataFrame\n", "merged_df = pd.merge(df_new1, df_new2, on='key', how='inner')" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'total': 189,\n", " 'per_page': '100',\n", " 'current_page': 1,\n", " 'last_page': 2,\n", " 'data': [{'order_sn': '20240801161033601351',\n", " 'in_factory_time': '2024-08-01 16:09:55',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '赣A0FK56',\n", " 'tel': '17779101463',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:10:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '蓄电池传感器',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '390.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:10:33',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160925601256',\n", " 'in_factory_time': '2024-08-01 16:09:01',\n", " 'category_name': None,\n", " 'name': '杨先生',\n", " 'chepai': '赣A0P299',\n", " 'tel': '13627911912',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:09:44',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '曲轴前油封',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '100.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:09:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160925601256',\n", " 'in_factory_time': '2024-08-01 16:09:01',\n", " 'category_name': None,\n", " 'name': '杨先生',\n", " 'chepai': '赣A0P299',\n", " 'tel': '13627911912',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:09:44',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': 'Y型管堵头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '20.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:09:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160838601419',\n", " 'in_factory_time': '2024-08-01 16:08:10',\n", " 'category_name': None,\n", " 'name': '陈先生',\n", " 'chepai': '赣A2218S',\n", " 'tel': '18897951610',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:08:56',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '轮胎',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '265.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:08:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160737601443',\n", " 'in_factory_time': '2024-08-01 16:07:14',\n", " 'category_name': None,\n", " 'name': '杨先生',\n", " 'chepai': '赣A318P8',\n", " 'tel': '15170497679',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:07:58',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左后门框密封条',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '55.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:07:37',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160737601443',\n", " 'in_factory_time': '2024-08-01 16:07:14',\n", " 'category_name': None,\n", " 'name': '杨先生',\n", " 'chepai': '赣A318P8',\n", " 'tel': '15170497679',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:07:58',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左后门玻璃外压条',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '50.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:07:37',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160649601605',\n", " 'in_factory_time': '2024-08-01 16:06:23',\n", " 'category_name': None,\n", " 'name': '江先生',\n", " 'chepai': '赣A525B5',\n", " 'tel': '13970071381',\n", " 'vin': 'LBV5S3102HSN56730',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:06:58',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '副水壶盖',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '45.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:06:49',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160547601705',\n", " 'in_factory_time': '2024-08-01 16:05:21',\n", " 'category_name': None,\n", " 'name': '吴莺',\n", " 'chepai': '赣A52W13',\n", " 'tel': '13767048185',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:06:10',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机油(速霸2000)',\n", " 'classify_name': '保养类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '200.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:05:47',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160547601705',\n", " 'in_factory_time': '2024-08-01 16:05:21',\n", " 'category_name': None,\n", " 'name': '吴莺',\n", " 'chepai': '赣A52W13',\n", " 'tel': '13767048185',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:06:10',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机油(速霸2000)',\n", " 'classify_name': '保养类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '55.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:05:47',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160504601863',\n", " 'in_factory_time': '2024-08-01 16:04:40',\n", " 'category_name': None,\n", " 'name': '周先生',\n", " 'chepai': '赣A65Y52',\n", " 'tel': '13879178270',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:05:09',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '上水管接头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '48.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:05:04',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160358601281',\n", " 'in_factory_time': '2024-08-01 16:03:11',\n", " 'category_name': None,\n", " 'name': '陈先生',\n", " 'chepai': '赣A6878J',\n", " 'tel': '13507094713',\n", " 'vin': 'LE44M8HB3MN007103',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:04:29',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '手缝方向盘套',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '45.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:03:58',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160241601837',\n", " 'in_factory_time': '2024-08-01 16:02:22',\n", " 'category_name': None,\n", " 'name': '刘先生',\n", " 'chepai': '赣A71P16',\n", " 'tel': '13807919016',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:03:01',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机油格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:02:41',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160051601574',\n", " 'in_factory_time': '2024-08-01 16:00:23',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣A7526R',\n", " 'tel': '13576926517',\n", " 'vin': 'LFV2A21K1J4026515',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:01:32',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空调格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:00:51',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801160051601574',\n", " 'in_factory_time': '2024-08-01 16:00:23',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣A7526R',\n", " 'tel': '13576926517',\n", " 'vin': 'LFV2A21K1J4026515',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 16:01:32',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空气格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 17:00:51',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155731601476',\n", " 'in_factory_time': '2024-08-01 15:52:52',\n", " 'category_name': None,\n", " 'name': '徐先生',\n", " 'chepai': '赣A77S12',\n", " 'tel': '15979151333',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:58:39',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '后档玻璃贴膜',\n", " 'classify_name': '装潢件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '150.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:57:31',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155221601170',\n", " 'in_factory_time': '2024-08-01 15:52:02',\n", " 'category_name': None,\n", " 'name': '',\n", " 'chepai': '赣A812M6',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:52:48',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '紧急救援辅助电池',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:52:21',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155134601873',\n", " 'in_factory_time': '2024-08-01 15:50:51',\n", " 'category_name': None,\n", " 'name': '艾其文',\n", " 'chepai': '赣A91271',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:51:48',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '变速箱滤网',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '55.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:51:35',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155134601873',\n", " 'in_factory_time': '2024-08-01 15:50:51',\n", " 'category_name': None,\n", " 'name': '艾其文',\n", " 'chepai': '赣A91271',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:51:48',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '变速箱油底壳',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '45.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:51:35',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155032601348',\n", " 'in_factory_time': '2024-08-01 15:50:13',\n", " 'category_name': None,\n", " 'name': '汤先生',\n", " 'chepai': '赣AFT850',\n", " 'tel': '15879058774',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:50:46',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空调格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '14.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:50:32',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801155032601348',\n", " 'in_factory_time': '2024-08-01 15:50:13',\n", " 'category_name': None,\n", " 'name': '汤先生',\n", " 'chepai': '赣AFT850',\n", " 'tel': '15879058774',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:50:46',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空气格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:50:32',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801154849601804',\n", " 'in_factory_time': '2024-08-01 15:48:07',\n", " 'category_name': None,\n", " 'name': '刘昊',\n", " 'chepai': '赣AKH913',\n", " 'tel': '13907081748',\n", " 'vin': 'LSGUA82L5MF028565',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:48:55',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '专用前摄像头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '200.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:48:50',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801153813601590',\n", " 'in_factory_time': '2024-08-01 15:37:37',\n", " 'category_name': None,\n", " 'name': '唐娜',\n", " 'chepai': '赣AL3N09',\n", " 'tel': '13907096821',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:38:28',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左前杠支架',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '20.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:38:13',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801153704601800',\n", " 'in_factory_time': '2024-08-01 15:36:17',\n", " 'category_name': None,\n", " 'name': '东风面包车',\n", " 'chepai': '赣ALR490',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:37:22',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '齿轮油',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '68.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:37:04',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801153704601800',\n", " 'in_factory_time': '2024-08-01 15:36:17',\n", " 'category_name': None,\n", " 'name': '东风面包车',\n", " 'chepai': '赣ALR490',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:37:22',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '离合器线',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '20.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:37:04',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801153210601232',\n", " 'in_factory_time': '2024-08-01 15:31:48',\n", " 'category_name': None,\n", " 'name': '李建成',\n", " 'chepai': '赣AMN848',\n", " 'tel': '13970978127',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:36:00',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '全景摄像头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '230.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:32:10',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801153011601972',\n", " 'in_factory_time': '2024-08-01 15:29:40',\n", " 'category_name': None,\n", " 'name': '龚漂漂',\n", " 'chepai': '赣ANB900',\n", " 'tel': '18702597853',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:31:07',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空调格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:30:11',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152839601318',\n", " 'in_factory_time': '2024-08-01 15:28:20',\n", " 'category_name': None,\n", " 'name': '万女士',\n", " 'chepai': '赣APS399',\n", " 'tel': '19970067777',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:29:17',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '后刹车报警线',\n", " 'classify_name': '机修件',\n", " 'quantity': '2.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '40.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:28:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152800601381',\n", " 'in_factory_time': '2024-08-01 15:27:17',\n", " 'category_name': None,\n", " 'name': '熊海刚',\n", " 'chepai': '赣AQ81W1',\n", " 'tel': '15170096742',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:28:07',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '轮胎',\n", " 'classify_name': '轮胎',\n", " 'quantity': '2.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '680.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:28:00',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152800601381',\n", " 'in_factory_time': '2024-08-01 15:27:17',\n", " 'category_name': None,\n", " 'name': '熊海刚',\n", " 'chepai': '赣AQ81W1',\n", " 'tel': '15170096742',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:28:07',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '轮胎螺帽',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '8.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:28:00',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152651601576',\n", " 'in_factory_time': '2024-08-01 15:26:22',\n", " 'category_name': None,\n", " 'name': '邬女士',\n", " 'chepai': '赣AQ83S3',\n", " 'tel': '13870905010',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:27:02',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空调格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:26:52',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152651601576',\n", " 'in_factory_time': '2024-08-01 15:26:22',\n", " 'category_name': None,\n", " 'name': '邬女士',\n", " 'chepai': '赣AQ83S3',\n", " 'tel': '13870905010',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:27:02',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空气格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:26:52',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152546601932',\n", " 'in_factory_time': '2024-08-01 15:25:36',\n", " 'category_name': None,\n", " 'name': '小郭朋友',\n", " 'chepai': '赣AR05H7',\n", " 'tel': '000000',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:26:03',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '全车玻璃贴膜',\n", " 'classify_name': '装潢件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '350.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:25:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152505601522',\n", " 'in_factory_time': '2024-08-01 15:24:40',\n", " 'category_name': None,\n", " 'name': '殷先生',\n", " 'chepai': '赣AR27C3',\n", " 'tel': '15797790021',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:25:22',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '右后尾灯',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '75.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:25:05',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152411601759',\n", " 'in_factory_time': '2024-08-01 15:23:42',\n", " 'category_name': None,\n", " 'name': '胡先生',\n", " 'chepai': '赣AX3X87',\n", " 'tel': '18172895555',\n", " 'vin': 'LE40B8BB5NL792265',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:24:23',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '空滤壳接头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '130.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:24:11',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801152248601869',\n", " 'in_factory_time': '2024-08-01 15:19:26',\n", " 'category_name': None,\n", " 'name': '吴女士',\n", " 'chepai': '赣CU7307',\n", " 'tel': '13732997556',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:23:20',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左后门锁块',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '115.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:22:48',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801151843601379',\n", " 'in_factory_time': '2024-08-01 15:18:30',\n", " 'category_name': None,\n", " 'name': '徐巍威',\n", " 'chepai': '赣F2J565',\n", " 'tel': '18797847807',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:18:57',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '倒车雷达外框',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:18:43',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801151153601286',\n", " 'in_factory_time': '2024-08-01 15:11:33',\n", " 'category_name': None,\n", " 'name': '二手车',\n", " 'chepai': '赣GY0750',\n", " 'tel': '15070929352',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:12:20',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '凸轮轴传感器插头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '40.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:11:53',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801151050601908',\n", " 'in_factory_time': '2024-08-01 15:10:28',\n", " 'category_name': None,\n", " 'name': '养护所杨队长',\n", " 'chepai': '赣M04898',\n", " 'tel': '18979618266',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:11:07',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '轮毂盖',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '20.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:10:50',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150949601895',\n", " 'in_factory_time': '2024-08-01 15:09:19',\n", " 'category_name': None,\n", " 'name': '养护所',\n", " 'chepai': '赣M05738',\n", " 'tel': '17370568619',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:10:14',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '后平衡杆球头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '40.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:09:49',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150949601895',\n", " 'in_factory_time': '2024-08-01 15:09:19',\n", " 'category_name': None,\n", " 'name': '养护所',\n", " 'chepai': '赣M05738',\n", " 'tel': '17370568619',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:10:14',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '后平衡杆开口胶',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:09:49',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150949601895',\n", " 'in_factory_time': '2024-08-01 15:09:19',\n", " 'category_name': None,\n", " 'name': '养护所',\n", " 'chepai': '赣M05738',\n", " 'tel': '17370568619',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:10:14',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '点火线圈',\n", " 'classify_name': '机修件',\n", " 'quantity': '2.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '140.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:09:49',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150850601671',\n", " 'in_factory_time': '2024-08-01 15:08:30',\n", " 'category_name': None,\n", " 'name': '熊先生',\n", " 'chepai': '赣M05851',\n", " 'tel': '18170026288',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:09:05',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机油格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '10.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:08:50',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150758601444',\n", " 'in_factory_time': '2024-08-01 15:07:42',\n", " 'category_name': None,\n", " 'name': '邓云明',\n", " 'chepai': '赣MU2079',\n", " 'tel': '13870622185',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:08:20',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机盖拉线短',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:07:58',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150659601868',\n", " 'in_factory_time': '2024-08-01 15:06:27',\n", " 'category_name': None,\n", " 'name': '雷先生',\n", " 'chepai': '赣MW1791',\n", " 'tel': '15970676991',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:07:32',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左前门升降器开关',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '105.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:06:59',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150557601162',\n", " 'in_factory_time': '2024-08-01 15:05:32',\n", " 'category_name': None,\n", " 'name': '张',\n", " 'chepai': '赣MZ6372',\n", " 'tel': '13699533477',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:06:15',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '助力泵皮带',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '13.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:05:57',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150557601162',\n", " 'in_factory_time': '2024-08-01 15:05:32',\n", " 'category_name': None,\n", " 'name': '张',\n", " 'chepai': '赣MZ6372',\n", " 'tel': '13699533477',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:06:15',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '曲轴位置传感器',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '45.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:05:57',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150506601656',\n", " 'in_factory_time': '2024-08-01 15:03:43',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '鲁QX60Y0',\n", " 'tel': '15870030791',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:05:19',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '雨刮喷水电机',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:05:06',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801150213601521',\n", " 'in_factory_time': '2024-08-01 15:01:24',\n", " 'category_name': None,\n", " 'name': '郭文',\n", " 'chepai': '苏BDW3268',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 15:03:04',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '远程解码',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '200.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 16:02:13',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801144324601450',\n", " 'in_factory_time': '2024-08-01 14:41:56',\n", " 'category_name': None,\n", " 'name': '郭文',\n", " 'chepai': '苏BZT102',\n", " 'tel': '17779101463',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:43:39',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '前杠雷达插头',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '30.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:43:24',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143933601821',\n", " 'in_factory_time': '2024-08-01 14:39:11',\n", " 'category_name': None,\n", " 'name': '郭文',\n", " 'chepai': '苏D8T80T',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:41:46',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左前半轴',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '480.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:39:33',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143933601821',\n", " 'in_factory_time': '2024-08-01 14:39:11',\n", " 'category_name': None,\n", " 'name': '郭文',\n", " 'chepai': '苏D8T80T',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:41:46',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '燃油通风阀管路',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '210.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:39:33',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '组合仪表拉线',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '40.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '右前叶子板内衬',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '65.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '发动机下护板',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '110.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '右前轮眉',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '75.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '龙门架',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '195.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801143653601213',\n", " 'in_factory_time': '2024-08-01 14:34:39',\n", " 'category_name': None,\n", " 'name': '先生',\n", " 'chepai': '苏DG017Z',\n", " 'tel': '13579122666',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:50',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '右前杠骨架支架',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '85.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:36:54',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801142918601336',\n", " 'in_factory_time': '2024-08-01 14:28:39',\n", " 'category_name': None,\n", " 'name': '',\n", " 'chepai': '赣无牌保时捷',\n", " 'tel': '',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 14:38:28',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '功放维修',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '550.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 15:29:18',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801132157601321',\n", " 'in_factory_time': '2024-08-01 13:21:10',\n", " 'category_name': None,\n", " 'name': '赵先生',\n", " 'chepai': '赣AZ58V3',\n", " 'tel': '18879109972',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 13:22:36',\n", " 'item_type': '维修项目',\n", " 'item_code': '1688375437847',\n", " 'item_name': '前档贴膜.',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '150.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 14:21:57',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801132038601947',\n", " 'in_factory_time': '2024-08-01 13:20:05',\n", " 'category_name': None,\n", " 'name': '养护所杨队长',\n", " 'chepai': '赣M04898',\n", " 'tel': '18979618266',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 13:20:53',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '后档贴膜.',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '0.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 14:20:38',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '0.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '0.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801114217601962',\n", " 'in_factory_time': '2024-08-01 11:41:22',\n", " 'category_name': None,\n", " 'name': '刘先生',\n", " 'chepai': '浙JZ11A9',\n", " 'tel': '18815217599',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:42:37',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '机油机滤走保险赠送',\n", " 'classify_name': '机修类',\n", " 'quantity': '1.00',\n", " 'price': '94.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '94.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 12:42:17',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '94.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '94.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240801114217601962',\n", " 'in_factory_time': '2024-08-01 11:41:22',\n", " 'category_name': None,\n", " 'name': '刘先生',\n", " 'chepai': '浙JZ11A9',\n", " 'tel': '18815217599',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:42:37',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机油格',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '7.00',\n", " 'amount': '94.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-08-01 12:42:17',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '94.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '94.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '1440.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修项目',\n", " 'item_code': '1668905122298',\n", " 'item_name': '左前叶子板喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '更换做前叶子板轮眉',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '更换左前杠轮眉',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修项目',\n", " 'item_code': '1692767686860',\n", " 'item_name': '前杠喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左前杠轮眉',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '35.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240730095711601517',\n", " 'in_factory_time': '2024-07-30 09:59:25',\n", " 'category_name': None,\n", " 'name': '廖先生',\n", " 'chepai': '赣AEQ338',\n", " 'tel': '13576928451',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:29:59',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '左前叶子板轮眉',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '35.00',\n", " 'amount': '1440.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-30 10:59:25',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1440.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1440.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240720115101601420',\n", " 'in_factory_time': '2024-07-20 11:51:01',\n", " 'category_name': None,\n", " 'name': '郑先生',\n", " 'chepai': '赣A9FC51',\n", " 'tel': '13184585078',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:25:39',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '2520.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '2520.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-20 12:51:01',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '2520.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '2520.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240720115101601420',\n", " 'in_factory_time': '2024-07-20 11:51:01',\n", " 'category_name': None,\n", " 'name': '郑先生',\n", " 'chepai': '赣A9FC51',\n", " 'tel': '13184585078',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:25:39',\n", " 'item_type': '维修项目',\n", " 'item_code': '1722325895177',\n", " 'item_name': '轮眉补车衣',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '200.00',\n", " 'amount': '2520.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-20 12:51:01',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '2520.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '2520.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240720115101601420',\n", " 'in_factory_time': '2024-07-20 11:51:01',\n", " 'category_name': None,\n", " 'name': '郑先生',\n", " 'chepai': '赣A9FC51',\n", " 'tel': '13184585078',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:25:39',\n", " 'item_type': '维修项目',\n", " 'item_code': '1682733087608',\n", " 'item_name': '右前叶子板车衣',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '700.00',\n", " 'amount': '2520.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-20 12:51:01',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '2520.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '2520.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240720115101601420',\n", " 'in_factory_time': '2024-07-20 11:51:01',\n", " 'category_name': None,\n", " 'name': '郑先生',\n", " 'chepai': '赣A9FC51',\n", " 'tel': '13184585078',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:25:39',\n", " 'item_type': '维修项目',\n", " 'item_code': '1673930010643',\n", " 'item_name': '前杠车衣.',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '700.00',\n", " 'amount': '2520.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-20 12:51:01',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '2520.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '2520.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240720115101601420',\n", " 'in_factory_time': '2024-07-20 11:51:01',\n", " 'category_name': None,\n", " 'name': '郑先生',\n", " 'chepai': '赣A9FC51',\n", " 'tel': '13184585078',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:25:39',\n", " 'item_type': '维修项目',\n", " 'item_code': '1671357751564',\n", " 'item_name': '机盖车衣.',\n", " 'classify_name': '美容类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '700.00',\n", " 'amount': '2520.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-20 12:51:01',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '2520.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '2520.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240731115624601229',\n", " 'in_factory_time': '2024-07-31 11:53:55',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣AD98736',\n", " 'tel': '18779185658',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:24:42',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '1400.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1400.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-31 12:56:24',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1400.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1400.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240731115624601229',\n", " 'in_factory_time': '2024-07-31 11:53:55',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣AD98736',\n", " 'tel': '18779185658',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:24:42',\n", " 'item_type': '维修项目',\n", " 'item_code': '1696906803733',\n", " 'item_name': '后杠喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1400.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-31 12:56:24',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1400.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1400.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240731115624601229',\n", " 'in_factory_time': '2024-07-31 11:53:55',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣AD98736',\n", " 'tel': '18779185658',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:24:42',\n", " 'item_type': '维修项目',\n", " 'item_code': '1699783104616',\n", " 'item_name': '后杠更换',\n", " 'classify_name': '机修类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1400.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-31 12:56:24',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1400.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1400.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240731115624601229',\n", " 'in_factory_time': '2024-07-31 11:53:55',\n", " 'category_name': None,\n", " 'name': '黄先生',\n", " 'chepai': '赣AD98736',\n", " 'tel': '18779185658',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:24:42',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '后杠原厂',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '300.00',\n", " 'amount': '1400.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-31 12:56:24',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1400.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1400.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '1876.39',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1698657657304',\n", " 'item_name': '机盖内外喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '180.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1684205861670',\n", " 'item_name': '右前叶子板喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1692767686860',\n", " 'item_name': '前杠喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1721956225920',\n", " 'item_name': '更换水箱框架',\n", " 'classify_name': '综合类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1721956175987',\n", " 'item_name': '更换机盖链条',\n", " 'classify_name': '机修类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '1721550353129',\n", " 'item_name': '更换中网',\n", " 'classify_name': '综合类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '更换机盖',\n", " 'classify_name': '外观类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机盖',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '240.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '中网',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '70.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '水箱框架',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '水箱',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '100.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '中网标',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '15.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240726091146601128',\n", " 'in_factory_time': '2024-07-26 09:05:39',\n", " 'category_name': None,\n", " 'name': '李先生',\n", " 'chepai': '赣AJ68Q3',\n", " 'tel': '18397915317',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:23:30',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '机盖铰链',\n", " 'classify_name': '机修件',\n", " 'quantity': '2.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '30.00',\n", " 'amount': '1876.39',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-26 10:11:46',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1876.39',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1876.39',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240715130439601164',\n", " 'in_factory_time': '2024-07-15 13:02:25',\n", " 'category_name': None,\n", " 'name': '蒋先生',\n", " 'chepai': '赣A607C9',\n", " 'tel': '15270015023',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:21:55',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '1820.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1820.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-15 14:04:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1820.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1820.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240715130439601164',\n", " 'in_factory_time': '2024-07-15 13:02:25',\n", " 'category_name': None,\n", " 'name': '蒋先生',\n", " 'chepai': '赣A607C9',\n", " 'tel': '15270015023',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:21:55',\n", " 'item_type': '维修项目',\n", " 'item_code': '1668904996286',\n", " 'item_name': '右前门喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1820.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-15 14:04:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1820.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1820.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240715130439601164',\n", " 'in_factory_time': '2024-07-15 13:02:25',\n", " 'category_name': None,\n", " 'name': '蒋先生',\n", " 'chepai': '赣A607C9',\n", " 'tel': '15270015023',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:21:55',\n", " 'item_type': '维修项目',\n", " 'item_code': '1717918201872',\n", " 'item_name': '右前叶子板钣金喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1820.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-15 14:04:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1820.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1820.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240715130439601164',\n", " 'in_factory_time': '2024-07-15 13:02:25',\n", " 'category_name': None,\n", " 'name': '蒋先生',\n", " 'chepai': '赣A607C9',\n", " 'tel': '15270015023',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:21:55',\n", " 'item_type': '维修项目',\n", " 'item_code': '1716716232672',\n", " 'item_name': '右前杠支架',\n", " 'classify_name': '机修类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1820.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-15 14:04:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1820.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1820.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240715130439601164',\n", " 'in_factory_time': '2024-07-15 13:02:25',\n", " 'category_name': None,\n", " 'name': '蒋先生',\n", " 'chepai': '赣A607C9',\n", " 'tel': '15270015023',\n", " 'vin': '',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:21:55',\n", " 'item_type': '维修配件',\n", " 'item_code': '',\n", " 'item_name': '右前杠支架',\n", " 'classify_name': '机修件',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '10.00',\n", " 'amount': '1820.00',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-15 14:04:39',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1820.00',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1820.00',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240727180712601457',\n", " 'in_factory_time': '2024-07-27 18:07:12',\n", " 'category_name': None,\n", " 'name': '徐先生',\n", " 'chepai': '赣AQL665',\n", " 'tel': '15079086337',\n", " 'vin': 'LSVNV2185E2020048',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:20:34',\n", " 'item_type': '维修项目',\n", " 'item_code': '1669005872319',\n", " 'item_name': '定损款',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '1354.50',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1354.50',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-27 19:07:12',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1354.50',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1354.50',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240727180712601457',\n", " 'in_factory_time': '2024-07-27 18:07:12',\n", " 'category_name': None,\n", " 'name': '徐先生',\n", " 'chepai': '赣AQL665',\n", " 'tel': '15079086337',\n", " 'vin': 'LSVNV2185E2020048',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:20:34',\n", " 'item_type': '维修项目',\n", " 'item_code': '',\n", " 'item_name': '雨刮器',\n", " 'classify_name': '外观类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '0.00',\n", " 'amount': '1354.50',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-27 19:07:12',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1354.50',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1354.50',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'},\n", " {'order_sn': '20240727180712601457',\n", " 'in_factory_time': '2024-07-27 18:07:12',\n", " 'category_name': None,\n", " 'name': '徐先生',\n", " 'chepai': '赣AQL665',\n", " 'tel': '15079086337',\n", " 'vin': 'LSVNV2185E2020048',\n", " 'p_chexingmingcheng': None,\n", " 'mileage': 0,\n", " 'update_time': '2024-08-01 11:20:34',\n", " 'item_type': '维修项目',\n", " 'item_code': '1684205861670',\n", " 'item_name': '右前叶子板喷漆',\n", " 'classify_name': '钣喷类',\n", " 'quantity': '1.00',\n", " 'price': '0.00',\n", " 'discount': '10.00',\n", " 'cost': '120.00',\n", " 'amount': '1354.50',\n", " 'remark': '',\n", " 'repair_type': None,\n", " 'account_type': None,\n", " 'construction_personnel': '',\n", " 'sales_personnel': '',\n", " 'construction_commission': '0.00',\n", " 'sales_commission': '0.00',\n", " 'leave_factory_time': '2024-07-27 19:07:12',\n", " 'cash': '0.00',\n", " 'unionpay': '0.00',\n", " 'credit': '0.00',\n", " 'pay_card': '0.00',\n", " 'wechat_pay': '1354.50',\n", " 'wechat_official_pay': '0.00',\n", " 'intergal_pay': '0.00',\n", " 'alipay': '0.00',\n", " 'preferential_amount': '0.00',\n", " 'coupons_amount': '0',\n", " 'card_no': None,\n", " 'total_amount': '1354.50',\n", " 'real_price': '0.00',\n", " 'insurance_credit': '0.00',\n", " 'inadequate_credit': '0.00'}]}" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "strele['data']" ] } ], "metadata": { "kernelspec": { "display_name": "F6processing", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.4" } }, "nbformat": 4, "nbformat_minor": 2 }