716 lines
30 KiB
Plaintext
716 lines
30 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "markdown",
|
|
"id": "1cdf8cdc",
|
|
"metadata": {},
|
|
"source": [
|
|
"客户信息导出"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 4,
|
|
"id": "4ffdf71d",
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"{'RowsCount': 0,\n",
|
|
" 'Data': [{'Id': 'MM9995626323',\n",
|
|
" 'MemberId': 'MM9995626323',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 5,\n",
|
|
" 'MemName': '鲍先生',\n",
|
|
" 'MemMobile': '13969813963',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '13969813963',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 740.0,\n",
|
|
" 'IntegralAmount': 6,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 60.0,\n",
|
|
" 'TotalConsumTimes': 1,\n",
|
|
" 'LastConsumTime': '2025-12-24T11:38:39',\n",
|
|
" 'ToStoreTimes': 117,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-12-24T11:35:32',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': 'otST1wH1I0NmejvUEYzwSdi7Wo4I',\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁B9LM65',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': 'https%3A%2F%2Fthirdwx.qlogo.cn%2Fmmopen%2Fvi_32%2FVTvcGww1B9KT5Bibr0sAHjQtSRKt2LqM0RzO4FVXRYkH4CseBlIXS0omNzyshjreRbUF1oyHibmt3afRiaKEVvc3g%2F132',\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995629539',\n",
|
|
" 'MemberId': 'MM9995629539',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 0,\n",
|
|
" 'MemName': '王先生',\n",
|
|
" 'MemMobile': '18000800080',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '18000800080',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 608.0,\n",
|
|
" 'IntegralAmount': 16,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 192.0,\n",
|
|
" 'TotalConsumTimes': 4,\n",
|
|
" 'LastConsumTime': '2026-02-23T10:41:03',\n",
|
|
" 'ToStoreTimes': 56,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-12-21T15:19:19',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': 'otST1wHeI4aMavhAkweedxcC56uc',\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁B0048D',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': 'https%3A%2F%2Fthirdwx.qlogo.cn%2Fmmopen%2Fvi_32%2FibzEtZY7mqJVibibLibL3Nm9iauvAQYO1icI4YnoyQWrYDHm0dS4TKXH6wklUUl1N6Io7PuKUxEQjFPLybjyialG30UVZ2Mz64x9FbWXCaa37CWvOg%2F132',\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995645867',\n",
|
|
" 'MemberId': 'MM9995645867',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 0,\n",
|
|
" 'MemName': '王先生',\n",
|
|
" 'MemMobile': '13801229158',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '13801229158',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000000211',\n",
|
|
" 'MemCardGradeName': '普通',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 0.0,\n",
|
|
" 'IntegralAmount': 139,\n",
|
|
" 'TotalRechargePrice': 0.0,\n",
|
|
" 'TotalConsumPrice': 1398.0,\n",
|
|
" 'TotalConsumTimes': 1,\n",
|
|
" 'LastConsumTime': '2025-12-10T17:20:22',\n",
|
|
" 'ToStoreTimes': 131,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-12-10T17:18:44',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': None,\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '京L26920',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': None,\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995649031',\n",
|
|
" 'MemberId': 'MM9995649031',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 0,\n",
|
|
" 'MemName': '（慈善总会）张先生',\n",
|
|
" 'MemMobile': '13791911122',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '13791911122',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 310.0,\n",
|
|
" 'IntegralAmount': 47,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 490.0,\n",
|
|
" 'TotalConsumTimes': 7,\n",
|
|
" 'LastConsumTime': '2026-03-24T10:14:16',\n",
|
|
" 'ToStoreTimes': 27,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-12-08T14:55:02',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': None,\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁UAJ561',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': None,\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995667455',\n",
|
|
" 'MemberId': 'MM9995667455',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 0,\n",
|
|
" 'MemName': '市场龙大冷鲜肉',\n",
|
|
" 'MemMobile': '18653254568',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '18653254568',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000000211',\n",
|
|
" 'MemCardGradeName': '普通',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 0.0,\n",
|
|
" 'IntegralAmount': 103,\n",
|
|
" 'TotalRechargePrice': 0.0,\n",
|
|
" 'TotalConsumPrice': 1038.0,\n",
|
|
" 'TotalConsumTimes': 1,\n",
|
|
" 'LastConsumTime': '2025-11-26T16:50:54',\n",
|
|
" 'ToStoreTimes': 145,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-11-26T15:48:22',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': None,\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁BRF12110',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': None,\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995669799',\n",
|
|
" 'MemberId': 'MM9995669799',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 6,\n",
|
|
" 'MemName': '王先生',\n",
|
|
" 'MemMobile': '15963200818',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '15963200818',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000000211',\n",
|
|
" 'MemCardGradeName': '普通',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 0.0,\n",
|
|
" 'IntegralAmount': 91,\n",
|
|
" 'TotalRechargePrice': 0.0,\n",
|
|
" 'TotalConsumPrice': 918.0,\n",
|
|
" 'TotalConsumTimes': 1,\n",
|
|
" 'LastConsumTime': '2025-11-24T19:17:03',\n",
|
|
" 'ToStoreTimes': 147,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-11-24T19:15:54',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': None,\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁B82FD8',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': None,\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995681626',\n",
|
|
" 'MemberId': 'MM9995681626',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 6,\n",
|
|
" 'MemName': '丁先生',\n",
|
|
" 'MemMobile': '15166655600',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '15166655600',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 50.0,\n",
|
|
" 'IntegralAmount': 73,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 750.0,\n",
|
|
" 'TotalConsumTimes': 12,\n",
|
|
" 'LastConsumTime': '2026-04-07T12:53:57',\n",
|
|
" 'ToStoreTimes': 13,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-11-17T09:27:09',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': 'otST1wHo_IkEQuKNFI9bbYTN-RGY',\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁B5X1Z7',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': 'https%3A%2F%2Fthirdwx.qlogo.cn%2Fmmopen%2Fvi_32%2FWnoLdrqW83HCxhCA67uP1LmT5R8n1hSx82NeGkMSVhiaLQbCJibfrQxFzJVDiaa8yQjcpqibaibfiboekW9x1icpjpnHz0Ppp4WAFepSSSj0IE0jsA%2F132',\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995694249',\n",
|
|
" 'MemberId': 'MM9995694249',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 5,\n",
|
|
" 'MemName': '王先生',\n",
|
|
" 'MemMobile': '18366205288',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '18366205288',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 540.0,\n",
|
|
" 'IntegralAmount': 26,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 360.0,\n",
|
|
" 'TotalConsumTimes': 5,\n",
|
|
" 'LastConsumTime': '2026-04-06T14:38:17',\n",
|
|
" 'ToStoreTimes': 14,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-12-21T14:00:26',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': 'otST1wE09a-st8_vY1uTMPPds0is',\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁BFS2799',\n",
|
|
" 'AllCarModelName': '-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': 'https%3A%2F%2Fthirdwx.qlogo.cn%2Fmmopen%2Fvi_32%2FQ0j4TwGTfTJeTu8goEic626iakUMLh41gLRQUDN0C38iaXLkNH8X1GD1ic74uGEAh1HbZOSKlh1ic1uCBRmTibN9QKdg%2F132',\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995697970',\n",
|
|
" 'MemberId': 'MM9995697970',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 5,\n",
|
|
" 'MemName': '谢女士',\n",
|
|
" 'MemMobile': '13305320367',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '13305320367',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000024724',\n",
|
|
" 'MemCardGradeName': '18周年庆-1000',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 2,\n",
|
|
" 'BalancePrice': 11.0,\n",
|
|
" 'IntegralAmount': 178,\n",
|
|
" 'TotalRechargePrice': 1800.0,\n",
|
|
" 'TotalConsumPrice': 1839.0,\n",
|
|
" 'TotalConsumTimes': 4,\n",
|
|
" 'LastConsumTime': '2026-04-10T09:31:04',\n",
|
|
" 'ToStoreTimes': 10,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2026-01-23T17:30:36',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': None,\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁AEV999,鲁U60J09',\n",
|
|
" 'AllCarModelName': '一汽奥迪A645TFSIqutro运动型,-',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': None,\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0},\n",
|
|
" {'Id': 'MM9995700319',\n",
|
|
" 'MemberId': 'MM9995700319',\n",
|
|
" 'MemCarId': None,\n",
|
|
" 'MerchantId': 'CR0000002145',\n",
|
|
" 'MerStoreId': 'CS0000044172',\n",
|
|
" 'MerStoreCode': '0214500001',\n",
|
|
" 'MerStoreName': '众得信汽车用品',\n",
|
|
" 'TagCode': None,\n",
|
|
" 'TagName': None,\n",
|
|
" 'MemType': 1,\n",
|
|
" 'MemSource': 0,\n",
|
|
" 'MemName': '刘先生',\n",
|
|
" 'MemMobile': '18678998881',\n",
|
|
" 'MemIDNumber': None,\n",
|
|
" 'MemSexType': False,\n",
|
|
" 'MemCardNo': '18678998881',\n",
|
|
" 'MemBirthDay': None,\n",
|
|
" 'MemCardGradeId': 'MG0000025026',\n",
|
|
" 'MemCardGradeName': '19周年庆-800',\n",
|
|
" 'CardExpiredDate': None,\n",
|
|
" 'MemCarsAmount': 1,\n",
|
|
" 'BalancePrice': 704.0,\n",
|
|
" 'IntegralAmount': 8,\n",
|
|
" 'TotalRechargePrice': 800.0,\n",
|
|
" 'TotalConsumPrice': 96.0,\n",
|
|
" 'TotalConsumTimes': 2,\n",
|
|
" 'LastConsumTime': '2025-11-29T15:12:46',\n",
|
|
" 'ToStoreTimes': 142,\n",
|
|
" 'CreditBillPrice': 0.0,\n",
|
|
" 'TotalCreditBillPrice': 0.0,\n",
|
|
" 'LastRepayTime': None,\n",
|
|
" 'DefRepayTime': None,\n",
|
|
" 'MemCreatedAt': '2025-11-04T12:58:15',\n",
|
|
" 'MemCompany': None,\n",
|
|
" 'MemAddress': None,\n",
|
|
" 'MemOpenId': 'otST1wOkxmGIso8GeCcdC7487IuQ',\n",
|
|
" 'IsSetPassword': 0,\n",
|
|
" 'AllCarPlateNumber': '鲁BY6663',\n",
|
|
" 'AllCarModelName': '进口奔驰E级',\n",
|
|
" 'MemWechatName': None,\n",
|
|
" 'MemWechatImageLink': 'https%3A%2F%2Fthirdwx.qlogo.cn%2Fmmopen%2Fvi_32%2FQ6vSFVsNGKZgWibQ7Z6WZUg8OZagGI0BtTjlcBuh7JhXcLNicnias5xs6HD7B7BP8HJorw8AsI2hyAnn1PTvrfOah7XLopq9weqCC5XAuP2IMo%2F132',\n",
|
|
" 'Enabled': True,\n",
|
|
" 'IsDisplay': True,\n",
|
|
" 'Remark': None,\n",
|
|
" 'MerAppId': 'wxe6801eee9c3e1853',\n",
|
|
" 'IId': 0}],\n",
|
|
" 'HasErrors': False,\n",
|
|
" 'Success': True,\n",
|
|
" 'AllMessages': '',\n",
|
|
" 'Messages': []}"
|
|
]
|
|
},
|
|
"execution_count": 4,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"source": [
|
|
"import requests\n",
|
|
"\n",
|
|
"headers = {\n",
|
|
" 'accept': 'application/json, text/plain, */*',\n",
|
|
" 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
|
|
" 'appkey': '8e240000-3e12-0016-1e0f-08d58267a484',\n",
|
|
" 'audl_user': 'a9980000-3e10-0016-3126-08d46c195899',\n",
|
|
" 'authtoken': 'fdf15a45-e109-4268-bc82-d45c212d51dc',\n",
|
|
" 'content-type': 'application/json',\n",
|
|
" 'openchainsign': 'fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM',\n",
|
|
" 'origin': 'https://fos.lunz.cn',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'sec-ch-ua': '\"Microsoft Edge\";v=\"147\", \"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"147\"',\n",
|
|
" 'sec-ch-ua-mobile': '?0',\n",
|
|
" 'sec-ch-ua-platform': '\"Windows\"',\n",
|
|
" 'sec-fetch-dest': 'empty',\n",
|
|
" 'sec-fetch-mode': 'cors',\n",
|
|
" 'sec-fetch-site': 'same-site',\n",
|
|
" 'signstring': 'KDhKfryYtTU3pxQ7dhkCuA==',\n",
|
|
" 'ucuserid': '8e240000-3e12-0016-8992-08d46c17a418',\n",
|
|
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0',\n",
|
|
"}\n",
|
|
"\n",
|
|
"json_data = {\n",
|
|
" 'paging': {\n",
|
|
" 'pageSize': 10,\n",
|
|
" 'pageIndex': 1,\n",
|
|
" 'sort': [],\n",
|
|
" 'filters': [\n",
|
|
" {\n",
|
|
" 'field': 'IsDisplay',\n",
|
|
" 'op': 'eq',\n",
|
|
" 'Term': '1',\n",
|
|
" },\n",
|
|
" {\n",
|
|
" 'field': 'Enabled',\n",
|
|
" 'op': 'eq',\n",
|
|
" 'Term': '1',\n",
|
|
" },\n",
|
|
" ],\n",
|
|
" },\n",
|
|
" 'qxentity': {\n",
|
|
" 'roletype': 3,\n",
|
|
" 'roleId': '8fb00000-3e0d-0016-d490-08d5826bb3c5',\n",
|
|
" 'memberuserid': 'a9980000-3e10-0016-3126-08d46c195899',\n",
|
|
" 'userid': '8e240000-3e12-0016-8992-08d46c17a418',\n",
|
|
" 'signstring': 'KDhKfryYtTU3pxQ7dhkCuA==',\n",
|
|
" 'custcentercode': '02145',\n",
|
|
" 'custcenterid': 'CR0000002145',\n",
|
|
" 'businessproductunitcode': '0214500001',\n",
|
|
" 'businessproductunitid': 'CS0000044172',\n",
|
|
" 'businessproductunitName': '众得信汽车用品',\n",
|
|
" 'openChainSign': 'fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM',\n",
|
|
" 'openChain': 0,\n",
|
|
" 'toke': '00000000-0000-0000-0000-000000000000',\n",
|
|
" },\n",
|
|
" 'searchValue': '',\n",
|
|
" 'memType': 1,\n",
|
|
"}\n",
|
|
"\n",
|
|
"response = requests.post('https://fos-api.lunz.cn/api/member/GetMemberinfoList', headers=headers, json=json_data)\n"
|
|
]
|
|
},
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "code",
|
|
"outputs": [],
|
|
"execution_count": null,
|
|
"source": "# 单位客户",
|
|
"id": "5bd770cacae23461"
|
|
},
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "code",
|
|
"outputs": [],
|
|
"execution_count": null,
|
|
"source": [
|
|
"import requests\n",
|
|
"\n",
|
|
"headers = {\n",
|
|
" 'accept': 'application/json, text/plain, */*',\n",
|
|
" 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
|
|
" 'appkey': '8e240000-3e12-0016-1e0f-08d58267a484',\n",
|
|
" 'audl_user': 'a9980000-3e10-0016-3126-08d46c195899',\n",
|
|
" 'authtoken': 'fdf15a45-e109-4268-bc82-d45c212d51dc',\n",
|
|
" 'content-type': 'application/json',\n",
|
|
" 'openchainsign': 'fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM',\n",
|
|
" 'origin': 'https://fos.lunz.cn',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'sec-ch-ua': '\"Microsoft Edge\";v=\"147\", \"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"147\"',\n",
|
|
" 'sec-ch-ua-mobile': '?0',\n",
|
|
" 'sec-ch-ua-platform': '\"Windows\"',\n",
|
|
" 'sec-fetch-dest': 'empty',\n",
|
|
" 'sec-fetch-mode': 'cors',\n",
|
|
" 'sec-fetch-site': 'same-site',\n",
|
|
" 'signstring': 'KDhKfryYtTU3pxQ7dhkCuA==',\n",
|
|
" 'ucuserid': '8e240000-3e12-0016-8992-08d46c17a418',\n",
|
|
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0',\n",
|
|
"}\n",
|
|
"\n",
|
|
"json_data = {\n",
|
|
" 'paging': {\n",
|
|
" 'pageSize': 10,\n",
|
|
" 'pageIndex': 1,\n",
|
|
" 'sort': [],\n",
|
|
" 'filters': [\n",
|
|
" {\n",
|
|
" 'field': 'IsDisplay',\n",
|
|
" 'op': 'eq',\n",
|
|
" 'Term': '1',\n",
|
|
" },\n",
|
|
" {\n",
|
|
" 'field': 'Enabled',\n",
|
|
" 'op': 'eq',\n",
|
|
" 'Term': '1',\n",
|
|
" },\n",
|
|
" ],\n",
|
|
" },\n",
|
|
" 'qxentity': {\n",
|
|
" 'roletype': 3,\n",
|
|
" 'roleId': '8fb00000-3e0d-0016-d490-08d5826bb3c5',\n",
|
|
" 'memberuserid': 'a9980000-3e10-0016-3126-08d46c195899',\n",
|
|
" 'userid': '8e240000-3e12-0016-8992-08d46c17a418',\n",
|
|
" 'signstring': 'KDhKfryYtTU3pxQ7dhkCuA==',\n",
|
|
" 'custcentercode': '02145',\n",
|
|
" 'custcenterid': 'CR0000002145',\n",
|
|
" 'businessproductunitcode': '0214500001',\n",
|
|
" 'businessproductunitid': 'CS0000044172',\n",
|
|
" 'businessproductunitName': '众得信汽车用品',\n",
|
|
" 'openChainSign': 'fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM',\n",
|
|
" 'openChain': 0,\n",
|
|
" 'toke': '00000000-0000-0000-0000-000000000000',\n",
|
|
" },\n",
|
|
" 'searchValue': '',\n",
|
|
" 'memType': 2,\n",
|
|
"}\n",
|
|
"\n",
|
|
"response = requests.post('https://fos-api.lunz.cn/api/member/GetMemberinfoList', headers=headers, json=json_data)\n",
|
|
"\n",
|
|
"# Note: json_data will not be serialized by requests\n",
|
|
"# exactly as it was in the original request.\n",
|
|
"#data = '{\\n \"paging\": {\\n \"pageSize\": 10,\\n \"pageIndex\": 1,\\n \"sort\": [],\\n \"filters\": [\\n {\\n \"field\": \"IsDisplay\",\\n \"op\": \"eq\",\\n \"Term\": \"1\"\\n },\\n {\\n \"field\": \"Enabled\",\\n \"op\": \"eq\",\\n \"Term\": \"1\"\\n }\\n ]\\n },\\n \"qxentity\": {\\n \"roletype\": 3,\\n \"roleId\": \"8fb00000-3e0d-0016-d490-08d5826bb3c5\",\\n \"memberuserid\": \"a9980000-3e10-0016-3126-08d46c195899\",\\n \"userid\": \"8e240000-3e12-0016-8992-08d46c17a418\",\\n \"signstring\": \"KDhKfryYtTU3pxQ7dhkCuA==\",\\n \"custcentercode\": \"02145\",\\n \"custcenterid\": \"CR0000002145\",\\n \"businessproductunitcode\": \"0214500001\",\\n \"businessproductunitid\": \"CS0000044172\",\\n \"businessproductunitName\": \"众得信汽车用品\",\\n \"openChainSign\": \"fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM\",\\n \"openChain\": 0,\\n \"toke\": \"00000000-0000-0000-0000-000000000000\"\\n },\\n \"searchValue\": \"\",\\n \"memType\": 2\\n}'.encode()\n",
|
|
"#response = requests.post('https://fos-api.lunz.cn/api/member/GetMemberinfoList', headers=headers, data=data)\n"
|
|
],
|
|
"id": "aeee08e848672701"
|
|
},
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "code",
|
|
"outputs": [],
|
|
"execution_count": null,
|
|
"source": "# 会员卡业务",
|
|
"id": "f11a5a42a1062bc7"
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 5,
|
|
"id": "88fdb482",
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"{'Data': [{'Id': 'BR9998813435', 'MerchantId': 'CR0000002145', 'MerStoreId': 'CS0000044172', 'MerStoreCode': '0214500001', 'MerName': '众得信汽车养护中心', 'ShortName': '众得信汽车用品', 'TagCode': None, 'TagName': None, 'MemberId': 'MM9995471853', 'MemCarId': None, 'MemCarList': '鲁VL525V', 'CreatedAt': '2026-04-09T11:33:34', 'UpdatedAt': '2026-04-09T11:33:34', 'MemName': '王女士', 'MemType': 1, 'MemMobile': '13553046731', 'PlateNumber': None, 'ProductId': 'PI0000501623', 'ProductName': '999保养套餐（20周年庆）', 'TerminalType': 'DT0000000388', 'BuyChannel': 'DT0000000345', 'BuyChannelName': '到店购买', 'PayType': 'DT0000000316', 'PayTypeName': '微信', 'ProductCost': 55.0, 'ProductPrice': 999.0, 'ActualPrice': 999.0, 'GiftIntegralAmount': 99, 'ExpiryTime': '2029-04-09T23:59:59', 'IsSurplus': True, 'IsRevoke': False, 'Remark': '', 'BuyProductItemName': '洗车;更换火花塞工时费;倒轮平衡;节气门清洗;活动变速箱油;布雷博刹车油;二合一除碳清洗剂;活动空调滤;活动空滤;保养工时费;活动机滤;睿烁活动机油', 'BuyProductItemAmount': '3.00;1.00;1.00;1.00;1.00;1.00;1.00;1.00;1.00;3.00;3.00;12.00', 'BuyProductItemExAmount': '2.00;1.00;1.00;1.00;1.00;1.00;1.00;0.00;0.00;2.00;2.00;8.00', 'BonusEmployId': 'EP0000024462', 'CreatedById': '0f40c19e-9d49-43a7-86a9-541e7673e3a4', 'BonusEmployName': '丁宓', 'ProductDesc': '', 'IId': 1}], 'HasErrors': False, 'Success': True, 'AllMessages': '', 'Messages': []}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import requests\n",
|
|
"\n",
|
|
"headers = {\n",
|
|
" 'accept': 'application/json, text/plain, */*',\n",
|
|
" 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
|
|
" 'appkey': '8e240000-3e12-0016-1e0f-08d58267a484',\n",
|
|
" 'audl_user': 'a9980000-3e10-0016-3126-08d46c195899',\n",
|
|
" 'authtoken': '9852c674-d229-45ca-8688-7616b121da29',\n",
|
|
" 'openchainsign': 'fPhhJnH7gwXJE9x+WgCsIplLwTRqB63/07K4/EidDLJEyqI9BMZULkYsKGMnr8Zqwka1LDP+EeSNM6gtEfLWCT49UhvumHmcqhaFym+Fccl+qMdm810yU5mQkcyhcJGM',\n",
|
|
" 'origin': 'https://fos.lunz.cn',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'sec-ch-ua': '\"Microsoft Edge\";v=\"147\", \"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"147\"',\n",
|
|
" 'sec-ch-ua-mobile': '?0',\n",
|
|
" 'sec-ch-ua-platform': '\"Windows\"',\n",
|
|
" 'sec-fetch-dest': 'empty',\n",
|
|
" 'sec-fetch-mode': 'cors',\n",
|
|
" 'sec-fetch-site': 'same-site',\n",
|
|
" 'signstring': 'LFytfFXpoVAHFfjaNXFprQ==',\n",
|
|
" 'ucuserid': '8e240000-3e12-0016-8992-08d46c17a418',\n",
|
|
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0',\n",
|
|
"}\n",
|
|
"\n",
|
|
"params = {\n",
|
|
" 'merStoreId': 'CS0000044172',\n",
|
|
" 'memberId': 'MM9995471853',\n",
|
|
"}\n",
|
|
"\n",
|
|
"response = requests.get('https://fos-api.lunz.cn/api/memberProduc/GetMemProductByMemId', params=params, headers=headers)\n",
|
|
"print(response.json())\n"
|
|
]
|
|
}
|
|
],
|
|
"metadata": {
|
|
"kernelspec": {
|
|
"display_name": "F6+宜搭+其它",
|
|
"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.13.11"
|
|
}
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 5
|
|
}
|