优选订单列表按分类导出
<p><strong>简要描述:</strong> </p>
<ul>
<li>优选订单列表按分类导出(JDK1.8的代码暂时无法部署)</li>
</ul>
<p><strong>请求URL:</strong> </p>
<ul>
<li><code>xtwl_read_interface/cmd/</code></li>
</ul>
<p><strong>请求方式:</strong></p>
<ul>
<li>POST </li>
</ul>
<p><strong>参数:</strong> </p>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">必选</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">custId</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">String</td>
<td>客户id</td>
</tr>
<tr>
<td style="text-align: left;">exprotType</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">String</td>
<td>导出类型:1按分类导出,2按商品导出,3普通导出</td>
</tr>
<tr>
<td style="text-align: left;">searchType</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>查询的是哪个状态的订单 1待支付,2待自提,3待配送,4配送中,5已完成,6已取消</td>
</tr>
<tr>
<td style="text-align: left;">orderNo</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>订单编号</td>
</tr>
<tr>
<td style="text-align: left;">userAccount</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>用户账号</td>
</tr>
<tr>
<td style="text-align: left;">pickupPhone</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>自提者手机号</td>
</tr>
<tr>
<td style="text-align: left;">pickupPointName</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>自提点名称</td>
</tr>
<tr>
<td style="text-align: left;">timeStart</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>提交订单开始时间</td>
</tr>
<tr>
<td style="text-align: left;">timeEnd</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>提交订单结束时间</td>
</tr>
<tr>
<td style="text-align: left;">payPort</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>交易平台 4 IOS,5 Android,6Wap,8小程序,9优选独立小程序</td>
</tr>
<tr>
<td style="text-align: left;">isPresale</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>是否预售:1是0否</td>
</tr>
<tr>
<td style="text-align: left;">payMethod</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>支付方式(1支付宝,2微信)</td>
</tr>
<tr>
<td style="text-align: left;">dispatchMode</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">String</td>
<td>配送方式:1平台配送,2自提</td>
</tr>
<tr>
<td style="text-align: left;">secondTypeList</td>
<td style="text-align: left;">否</td>
<td style="text-align: left;">List<String></td>
<td>二级类目集合(普通导出为空)</td>
</tr>
<tr>
<td style="text-align: left;">excelTitleList</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">List<String></td>
<td>导出表头名</td>
</tr>
<tr>
<td style="text-align: left;">excelKeyList</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">List<String></td>
<td>导出字段名</td>
</tr>
</tbody>
</table>
<p><strong>请求示例</strong></p>
<pre><code>按分类导出/普通导出:
{
"modular": "yxorder",
"param": {
"authKey": "0",
"dtype": "1",
"secretKey": "6EBAB53F020B02CA497BB158566ADB88",
"timeStamp": "1507596424076",
"userKey": "1234567890",
"uuid": "6bc9f931-f8b2-41d7-bb1d-b4a312844133",
"custId": "A82DFB7E10864B85A4E9136143DABECB",
"searchType": "0",
"exprotType": "1",
"orderNo": "82",
"userAccount": "18",
"pickupPhone": "1",
"pickupPointName": "",
"timeStart": "2022-11-01",
"timeEnd": "2022-11-30",
"payPort": "8",
"dispatchMode": "2",
"isPresale": "0",
"payMethod": "2",
"secondTypeList": [
"3C8F3E3D2591408685A8ADDDAD782DF4",
"02250FA5F169405DBEB55026CEF20CEF",
"A17F909BE84C480ABF8ADA4975E0408C"
],
"excelTitleList": [
"序号",
"订单编号",
"手机号",
"姓名",
"自提店铺名称",
"自提时间/配送时间",
"一级类目",
"二级类目",
"商品",
"规格",
"市场价(元)",
"优选价(元)",
"数量",
"总价"
],
"excelKeyList": [
"rn",
"orderNo",
"cneeTel",
"cneeName",
"shopName",
"selectTime",
"firstTypeName",
"secondTypeName",
"goodsName",
"spec",
"originalPrice",
"price",
"quantity",
"goodsAmount"
]
},
"requestname": "exportYxOrderByType",
"version": "1.0"
}
按商品导出:
{
"modular": "yxorder",
"param": {
"authKey": "0",
"dtype": "1",
"secretKey": "6EBAB53F020B02CA497BB158566ADB88",
"timeStamp": "1507596424076",
"userKey": "1234567890",
"uuid": "6bc9f931-f8b2-41d7-bb1d-b4a312844133",
"custId": "A82DFB7E10864B85A4E9136143DABECB",
"searchType": "0",
"exprotType": "2",
"orderNo": "82",
"userAccount": "18",
"pickupPhone": "1",
"pickupPointName": "",
"timeStart": "2022-11-01",
"timeEnd": "2022-11-30",
"payPort": "8",
"dispatchMode": "2",
"isPresale": "0",
"payMethod": "2",
"excelTitleList": [
"序号",
"商品",
"规格",
"一级类目",
"二级类目",
"市场价(元)",
"优选价(元)",
"数量"
],
"excelKeyList": [
"rn",
"goodsName",
"spec",
"firstTypeName",
"secondTypeName",
"originalPrice",
"price",
"quantity"
]
},
"requestname": "exportYxOrderByType",
"version": "1.0"
}</code></pre>
<p><strong>返回参数说明</strong> </p>
<p>excel表格</p>