订单查询及导出
<h5>简要描述</h5>
<ul>
<li>订单查询及导出</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>/admin/searchOrder</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST</li>
</ul>
<h5>请求格式</h5>
<pre><code class="language-json">{
"header": {
"tokenId": "fagUSvNtBS2pukaxgtAoHMyqt76xRDef"
},
"body": {
"pageSize": 20,
"startIndex": 0,
"orderDateStart": "2022-01-31T08:06:04.340Z",
"orderDateEnd": "2022-02-07T08:06:04.340Z",
"merchantUuid": null,
"phone": null,
"userPhone": null,
"orderNo": null,
"name": null,
"orderStatus": null,
"channel": null,
"exported":true,
"forExport":true,
"videoChannel":"xxx"
}
}</code></pre>
<h5>请求参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">exported</td>
<td style="text-align: left;">boolean</td>
<td>查询条件:查询已导出(true)或未导出(false)或全部(null)的记录</td>
</tr>
<tr>
<td style="text-align: left;">forExport</td>
<td style="text-align: left;">boolean</td>
<td>在导出功能中使用(即传递true),查询时忽略该项</td>
</tr>
<tr>
<td style="text-align: left;">videoChannel</td>
<td style="text-align: left;">string</td>
<td>视频号直播渠道来源id</td>
</tr>
</tbody>
</table>
<blockquote>
<p>其它参数与查询时一致</p>
</blockquote>
<h5>返回示例</h5>
<pre><code class="language-json">{
"header": {
"tokenId": "fagUSvNtBS2pukaxgtAoHMyqt76xRDef"
},
"body": {
"status": {
"statusCode": "0",
"errorCode": null,
"errorDesc": null
},
"data": {
"totalToConfirm": 0,
"totalAmount": 15.0300,
"total": 6,
"totalPoint": 0,
"orders": [
{
"orderUuid": "6336363433b34cb4ae44efe56f8c91a6",
"orderNo": "GM20220207926181",
"stbId": "",
"isDeleted": "0",
"dateCreate": "2022-02-07T07:49:10.000+00:00",
"createBy": "25",
"dateUpdate": "2022-02-07T07:49:10.000+00:00",
"updateBy": "25",
"orderType": "0",
"orderStatus": "2",
"productUnit": null,
"productPoint": null,
"productCostAmount": null,
"productAmount": 0.0100,
"deductAmount": 0.0000,
"freightAmount": 0.0000,
"actualAmount": 0.0100,
"actualPoint": null,
"orderTime": "2022-02-07 15:49",
"deliveryTime": null,
"userUuid": "e12b62ad61bc459281af96a61c27899c",
"deliveryType": "1",
"deliveryAddressUuid": "29015aae00b04a70b2e735719219b84c",
"deliveryProvince": "天津市",
"deliveryCity": "天津市",
"deliveryArea": "和平区",
"deliveryStreet": "曲阜道",
"deliveryName": "张",
"deliveryContactNo": "15834485130",
"deliveryZipcode": null,
"deliveryLatitude": null,
"deliveryLongitude": null,
"memo": null,
"formId": null,
"courierName": null,
"courierNo": null,
"orderComment": null,
"paymentMethod": "1",
"orderChannel": "minipro",
"paymentTime": "2022-02-07T07:49:25.000+00:00",
"cancelTime": null,
"cancelReason": null,
"afterSaleDeadlineTime": null,
"isAfterSale": null,
"afterSaleNo": null,
"userCouponUuid": "",
"confirmTime": null,
"merchantUuid": null,
"pOrderNo": "MN20220207857772",
"transactionId": "4200001413202202076706511754",
"isAccounted": null,
"refundId": null,
"refundMsg": null,
"shopperName": null,
"shopperMobileno": null,
"shopperPhoto": null,
"shopperSex": null,
"groupBuyUuid": null,
"pActualAmount": 0.01,
"exported": null,
"merchantMobileNo": null,
"merchantName": null,
"channelName": "小程序",
"userDTO": {
"userUUID": "e12b62ad61bc459281af96a61c27899c",
"isdeleted": "0",
"dateCreate": "2022-01-18T04:36:21.000+00:00",
"createBy": "Consumer",
"dateUpdate": "2022-01-18T04:36:21.000+00:00",
"updateBy": "Consumer",
"id": "25",
"photoUrl": null,
"name": null,
"idCardNo": null,
"sex": null,
"personalEmail": null,
"personalPhone": "15834485130",
"personalPhoneCountryCode": null,
"openId": "ohttb46u7MPmxaP1wswJwxQzGnis",
"registerDate": "2022-01-18T04:36:21.000+00:00",
"memo": null,
"openIdOfc": null,
"unionId": null,
"supervisorUUID": null,
"invitationUUID": null,
"userLevelUUID": "",
"trainerUUID": null,
"userTokenUUID": null,
"active": true,
"notificationEnabled": false,
"profitWelfareReceived": false
},
"merchantDTO": {
"merchantUuid": null,
"isDeleted": null,
"dateCreate": null,
"createBy": null,
"dateUpdate": null,
"updateBy": null,
"logo": null,
"merchantdescription": null,
"referrer": null,
"registerDate": null,
"memo": null,
"exchangeRate": null,
"province": null,
"city": null,
"district": null,
"latitude": null,
"longitude": null,
"merchantId": null,
"weight": null,
"score": null,
"soldUnit": null,
"saleUnit": null,
"mobileNo": null,
"merchantName": null,
"merchantAddress": null,
"contactName": null,
"closed": null
},
"groupBuyDTO": {
"id": null
},
"orderProductDTOList": [
{
"orderProductUuid": "7588ee73445949d2a9a0c9f4afd31ede",
"orderUuid": "6336363433b34cb4ae44efe56f8c91a6",
"isDeleted": "0",
"dateCreate": "2022-02-07T07:49:10.000+00:00",
"createBy": "25",
"dateUpdate": "2022-02-07T07:49:10.000+00:00",
"updateBy": "25",
"actualAmount": 0.0100,
"actualPoint": 0,
"productUuid": "16d96a0d164b4385ad47f82e92bae8b5",
"productskuUuid": "306a57ca5b69491790323997a54d4258007",
"productName": "h测试咖啡",
"productCode": "kafei001",
"productImageUrl": "http://49.232.49.101:8085/getAtt/771a1f14f18143f6b4575185054d3b08.jpg",
"productSkuDesc": "规格:重度烘焙",
"productAmount": 0.0100,
"productPoint": 0,
"productUnit": 1,
"productUnitPoint": null,
"productUnitPrice": 0.0100,
"pointProductUuid": null,
"pointProductSkuUuid": null,
"groupBuyProductUuid": null,
"secKillProductUuid": null,
"productDTO": {
"productUuid": "16d96a0d164b4385ad47f82e92bae8b5",
"isDeleted": "0",
"dateCreate": "2022-01-17T02:12:30.000+00:00",
"createBy": "admin",
"dateUpdate": "2022-01-24T06:54:06.000+00:00",
"updateBy": "admin",
"productType": "1",
"productName": "h测试咖啡",
"productCode": "kafei001",
"productBrief": "",
"productWeight": 0.00,
"unitPrice": 0.00,
"unitPriceStandard": 0.00,
"productcateUuid": "8e468105082f49e58f157fd57ba7fb46",
"productbrandUuid": null,
"productMainImageUuid": "e71baa2d5485403c8ea2093fb9343457",
"productfreightUuid": "03c5c46c2e934d2eaa8c00b31558677f",
"productdeliveryUuid": null,
"promoteUnitPrice": null,
"membershipUnitPrice": null,
"marketUnitPrice": null,
"promoteStartDate": null,
"promoteEndDate": null,
"warnUnit": 0,
"unitPoint": null,
"unitPointStandard": null,
"memo": "",
"productCostPrice": null,
"supplierUuid": null,
"merchantUuid": "01b0b95c23c84237ad01573a1060e211",
"verifyStatus": "1",
"verifyMsg": null,
"validType": null,
"validDays": null,
"validStartDate": null,
"validEndDate": null,
"productDesc": "咖啡测试",
"merchantName": null,
"productCateDTO": null,
"productMainImage": null,
"totalUnit": -12,
"soldUnit": 12,
"skuEnabled": true,
"new": false,
"hot": false,
"promote": null,
"recommend": true,
"onSale": true,
"shipping": true,
"deliveryExpressEnabled": true,
"deliveryCityEnabled": false,
"deliveryPickEnabled": false
},
"productSkuDTO": {
"productskuUuid": "306a57ca5b69491790323997a54d4258007",
"isDeleted": "0",
"dateCreate": "2022-01-19T07:18:36.000+00:00",
"createBy": "admin",
"dateUpdate": "2022-01-24T06:53:09.000+00:00",
"updateBy": "admin",
"productUuid": "16d96a0d164b4385ad47f82e92bae8b5",
"skuUnitPoint": null,
"skuUnitPointStandard": null,
"skuCode": null,
"skuTotalUnit": 9,
"skuSoldUnit": 7,
"skuWarnUnit": 0,
"skuUnitPrice": 0.01,
"skuUnitPriceStandard": 25.00,
"skuImageUrl": "http://49.232.49.101:8085/getAtt/4dfe0023d8f44ed19442f9fa95be872c.jpg",
"productSkuAttrValueUuids": "[2b8e7c89654c486b8d519a8953cf41ea004]",
"skuCostPrice": 65.00,
"skuWeight": 1.45
}
}
],
"awardList": [],
"images": [],
"shoppingCartUuidList": [],
"suscribeMsgList": [],
"deliveryTypeDesc": "快递配送",
"videoChannel":"xx直播",
"afterSale": true,
"afterSaleItems": [
{
"afOrderNo": "AF20220222849836",
"productName": "h-测试巧克力",
"skuName": "400g(盒装)"
}
]
}
],
"totalToDeliver": 1,
"totalToEvaluate": 0,
"totalToPay": 0
}
}
}</code></pre>
<h5>返回参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">exported</td>
<td style="text-align: left;">boolean</td>
<td>true-已导出过<br/>false或null-未导出过</td>
</tr>
<tr>
<td style="text-align: left;">videoChannel</td>
<td style="text-align: left;">string</td>
<td>视频号来源名称</td>
</tr>
</tbody>
</table>