通过文件上传物流数据

# 通过文件上传物流数据

## 支持场景
>支持第三方物码物流数据（订单和数码),通过文件传递到中商系统,传输完成后可以再中商系统查询该数码的流向等物流信息。

## API描述
>1. 请先按订单梳理订单信息数据和订单对应的数据数据。
>2. 将梳理完成的数据形成DB3文件，并上传至中商OSS存储服务,得到文件地址。
>3. 将订单信息和DB3文件地址通过该接口上传至中商系统。
>4. 中商系统接收文件后，会排队处理，请等待处理完成后即可查询数码物流信息。

DB3 格式
![](/media/202403/2024-03-29_150954_8125530.04890961949903638.png)

## 请求流程
> 参阅 [API开放平台接入指南](https://developers.yesno.com.cn/doc/56/)

## 请求信息
>域名：请参阅 [环境信息](https://developers.yesno.com.cn/doc/56/)

## 公共参数
**通用请求头**
>请参阅 [通用请求头](https://developers.yesno.com.cn/doc/56/)

## 请求参数

<table>
 <thead class="ant-table-thead">
 <tr>
 <th key=name>名称</th><th key=type>类型</th><th key=required>是否必须</th><th key=default>默认值</th><th key=desc>备注</th><th key=sub>其他信息</th>
 </tr>
 </thead><tbody className="ant-table-tbody"><tr key=0-0><td key=0> completedTime</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>订单完成时间 - 格式yyyy-MM-ddTHH:mm:ss:Z</td><td key=5>format: date-time</td></tr><tr key=0-1><td key=0> createTime</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>订单创建时间 - 格式yyyy-MM-ddTHH:mm:ss:Z</td><td key=5>format: date-time</td></tr><tr key=0-2><td key=0> dbUrl</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>数码db3文件oss url</td><td key=5></td></tr><tr key=0-3><td key=0> enterpriseNo</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>企业号</td><td key=5></td></tr><tr key=0-4><td key=0> finished</td><td key=1>boolean</td><td key=2>必须</td><td key=3></td><td key=4>订单是否已结束</td><td key=5></td></tr><tr key=0-5><td key=0> middlemanList</td><td key=1>integer []</td><td key=2>非必须</td><td key=3></td><td key=4>中间商 - 用于直发时数码的流向组织，数组顺序为流向的顺序</td><td key=5>item 类型: integer</td></tr><tr key=array-8><td key=0>├─ </td><td key=1></td><td key=2>非必须</td><td key=3></td><td key=4></td><td key=5></td></tr><tr key=0-6><td key=0> receiptNo</td><td key=1>string</td><td key=2>非必须</td><td key=3></td><td key=4>订单编号, 不传则自动生成</td><td key=5></td></tr><tr key=0-7><td key=0> receiptSource</td><td key=1>integer</td><td key=2>必须</td><td key=3></td><td key=4>单据来源: 1 - 客户新建</td><td key=5>format: int32</td></tr><tr key=0-8><td key=0> receiptType</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>单据类型，196720-销售出库，131149 - 收货入库， 196731 - 退货出库， 131140 - 退货入库， 196723 - 调拨出库， 131138 - 调拨入库</td><td key=5></td></tr><tr key=0-9><td key=0> receiverNo</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>收货方编号</td><td key=5></td></tr><tr key=0-10><td key=0> receiverType</td><td key=1>integer</td><td key=2>必须</td><td key=3></td><td key=4>收货方类型<a href="https://developers.yesno.com.cn/doc/66"/> 组织类型</td><td key=5>format: int64</td></tr><tr key=0-11><td key=0> requestId</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>每次订单上传的唯一值， 同一订单上传多次requestId不能相同</td><td key=5></td></tr><tr key=0-12><td key=0> senderNo</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>发货方编号</td><td key=5></td></tr><tr key=0-13><td key=0> senderType</td><td key=1>integer</td><td key=2>必须</td><td key=3></td><td key=4>发货方类型<a href="https://developers.yesno.com.cn/doc/66"/> 组织类型</td><td key=5>format: int64</td></tr><tr key=0-14><td key=0> taskId</td><td key=1>string</td><td key=2>必须</td><td key=3></td><td key=4>订单的唯一值， 同一订单上传多次taskId必须相同</td><td key=5></td></tr>
 </tbody>
 </table>

## 响应参数
<table class=""><colgroup><col style="width: 200px; min-width: 200px;"><col style="width: 100px; min-width: 100px;"><col style="width: 80px; min-width: 80px;"><col style="width: 80px; min-width: 80px;"><col><col style="width: 180px; min-width: 180px;"></colgroup><thead class="ant-table-thead"><tr><th class="">名称</th><th class="">类型</th><th class="">是否必须</th><th class="">默认值</th><th class="">备注</th><th class="">其他信息</th></tr></thead><tbody class="ant-table-tbody"><tr class="ant-table-row ant-table-row-level-0"><td class="">code</td><td class="">integer</td><td class=""><div>非必须</div></td><td class=""><div></div></td><td class="">错误码</td><td class="">format: int32</td></tr><tr class="ant-table-row ant-table-row-level-0"><td class="">data</td><td class="">boolean</td><td class=""><div>非必须</div></td><td class=""><div></div></td><td class="">数据</td><td class=""></td></tr><tr class="ant-table-row ant-table-row-level-0"><td class="">message</td><td class="">string</td><td class=""><div>非必须</div></td><td class=""><div></div></td><td class="">消息内容</td><td class=""></td></tr><tr class="ant-table-row ant-table-row-level-0"><td class="">timestamp</td><td class="">integer</td><td class=""><div>非必须</div></td><td class=""><div></div></td><td class="">时间戳</td><td class="">format: int64</td></tr><tr class="ant-table-row ant-table-row-level-0"><td class="">traceId</td><td class="">string</td><td class=""><div>非必须</div></td><td class=""><div></div></td><td class="">链路追踪ID</td><td class=""></td></tr></tbody></table>

## 请求示例
```
https://open-test.yesno.com.cn/trace/service/v1/open/wms/order/offline/receiptWithNo

POST BODY:
{
	"enterpriseNo": "151961007505",
	"taskId": "12345",
    "requestId": "00009",
	"senderId": 4,
    "middlemanList": [5, 7],
	"receiverId": 6,
	"businessType": 2,
	"receiptType": "196720",
	"receiptSource": 1,
	"completedTime": "2023-06-07T05:06:04Z",
	"dbUrl": "ABC123456789"
}
```
## 出参示例
```
{
    "code": 200,
    "message": "success",
    "data": false,
    "timestamp": 1686707487537,
    "traceId": ""
}
```

## db3文件：
```
create table tb_wms_code(
    id bigint not null primary key,
    code varchar(64) not null,
    product_id varchar(64) not null,
    scan_time datetime not null,
    scan_user varchar(64) not null
)

insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(1, '080908664161', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(2, '080908536644', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(3, '080908634603', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(4, '080908977163', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(5, '080908342837', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(6, '080908748086', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(7, '080908937434', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(8, '080908349681', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(9, '080908176422', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
insert into tb_wms_code (id, code, product_id, scan_time, scan_user) values(10, '080908454211', 'c9e8fafe7cad4da6baa7c984c442c353', '2024-05-06T07:52:00Z', '1787389661159563264');
```