导出Excel

POST

/cmc/esSalesOrder/exportExcel

导出Excel

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Query 参数

clientId

string

clientId

必需

userId

string

userId

必需

Header 参数

Authorization

string

必需

Body 参数application/json

状态分页签分页查询条件

barcode

string

商品条码

可选

card_no

string

卡号

可选

channels

array[string]

渠道

可选

client_id

string

商户Id

可选

consignee

string

收货人

可选

consignee_mobile

string

收货人手机号

可选

coupon_no

string

券号

可选

delivery_type

string

配送类型

可选

end_complete_time

string <date-time>

截止完成时间

可选

end_confirm_time

string <date-time>

截止接单时间

可选

end_create_time

string <date-time>

截止下单时间

可选

end_delivery_time

string <date-time>

截止发货时间

可选

end_etd_date

string <date>

截止预约日期

可选

end_ready_time

string <date-time>

截止备货完成时间

可选

es_store_menu_group_ids

array[string]

分组Id

可选

es_store_menu_group_name

string

分组名

可选

exclude_states

array[string]

排除状态

可选

franchisee_id

string

加盟商ID

可选

string

订单ID

可选

item_types

array[string]

多个商品类型

可选

member_id

string

会员Id

可选

member_mobile

string

会员手机号

可选

member_name

string

会员姓名

可选

merchandise_ids

array[string]

商品Id

可选

merchandise_name

string

商品品名

可选

merchandise_q

string

商品模糊查询

可选

order_by

array[object (BaseOrderVO) {2}]

排序

可选

key

string

排序字段

可选

type

enum<string>

排序方式

可选

枚举值:

ASCDESC

page_no

integer <int32>

页次

可选

page_size

integer <int32>

每页记录数

可选

pay_state

string

付款状态

可选

string

模糊查询条件

可选

refund

boolean

已退单

可选

refund_states

array[string]

退单状态

可选

sku_ids

array[string]

单品Id

可选

sku_name

string

单品名

可选

start_complete_time

string <date-time>

起始完成时间

可选

start_confirm_time

string <date-time>

起始接单时间

可选

start_create_time

string <date-time>

起始下单时间

可选

start_delivery_time

string <date-time>

起始发货时间

可选

start_etd_date

string <date>

起始预约日期

可选

start_ready_time

string <date-time>

起始备货完成时间

可选

state

string

状态

可选

store_id

string

门店

可选

store_id_q

string

下单门店/提货门店

可选

store_ids

array[string]

门店

可选

tourist_id

string

访客Id

可选

user_id

string

用户Id

可选

示例

{
    "barcode": "string",
    "card_no": "string",
    "channels": [
        "string"
    ],
    "client_id": "string",
    "consignee": "string",
    "consignee_mobile": "string",
    "coupon_no": "string",
    "delivery_type": "string",
    "end_complete_time": "2019-08-24T14:15:22Z",
    "end_confirm_time": "2019-08-24T14:15:22Z",
    "end_create_time": "2019-08-24T14:15:22Z",
    "end_delivery_time": "2019-08-24T14:15:22Z",
    "end_etd_date": "2019-08-24",
    "end_ready_time": "2019-08-24T14:15:22Z",
    "es_store_menu_group_ids": [
        "string"
    ],
    "es_store_menu_group_name": "string",
    "exclude_states": [
        "string"
    ],
    "franchisee_id": "string",
    "id": "string",
    "item_types": [
        "string"
    ],
    "member_id": "string",
    "member_mobile": "string",
    "member_name": "string",
    "merchandise_ids": [
        "string"
    ],
    "merchandise_name": "string",
    "merchandise_q": "string",
    "order_by": [
        {
            "key": "string",
            "type": "ASC"
        }
    ],
    "page_no": 0,
    "page_size": 0,
    "pay_state": "string",
    "q": "string",
    "refund": true,
    "refund_states": [
        "string"
    ],
    "sku_ids": [
        "string"
    ],
    "sku_name": "string",
    "start_complete_time": "2019-08-24T14:15:22Z",
    "start_confirm_time": "2019-08-24T14:15:22Z",
    "start_create_time": "2019-08-24T14:15:22Z",
    "start_delivery_time": "2019-08-24T14:15:22Z",
    "start_etd_date": "2019-08-24",
    "start_ready_time": "2019-08-24T14:15:22Z",
    "state": "string",
    "store_id": "string",
    "store_id_q": "string",
    "store_ids": [
        "string"
    ],
    "tourist_id": "string",
    "user_id": "string"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/cmc/esSalesOrder/exportExcel?clientId=&userId=' \
--header 'Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
    "barcode": "string",
    "card_no": "string",
    "channels": [
        "string"
    ],
    "client_id": "string",
    "consignee": "string",
    "consignee_mobile": "string",
    "coupon_no": "string",
    "delivery_type": "string",
    "end_complete_time": "2019-08-24T14:15:22Z",
    "end_confirm_time": "2019-08-24T14:15:22Z",
    "end_create_time": "2019-08-24T14:15:22Z",
    "end_delivery_time": "2019-08-24T14:15:22Z",
    "end_etd_date": "2019-08-24",
    "end_ready_time": "2019-08-24T14:15:22Z",
    "es_store_menu_group_ids": [
        "string"
    ],
    "es_store_menu_group_name": "string",
    "exclude_states": [
        "string"
    ],
    "franchisee_id": "string",
    "id": "string",
    "item_types": [
        "string"
    ],
    "member_id": "string",
    "member_mobile": "string",
    "member_name": "string",
    "merchandise_ids": [
        "string"
    ],
    "merchandise_name": "string",
    "merchandise_q": "string",
    "order_by": [
        {
            "key": "string",
            "type": "ASC"
        }
    ],
    "page_no": 0,
    "page_size": 0,
    "pay_state": "string",
    "q": "string",
    "refund": true,
    "refund_states": [
        "string"
    ],
    "sku_ids": [
        "string"
    ],
    "sku_name": "string",
    "start_complete_time": "2019-08-24T14:15:22Z",
    "start_confirm_time": "2019-08-24T14:15:22Z",
    "start_create_time": "2019-08-24T14:15:22Z",
    "start_delivery_time": "2019-08-24T14:15:22Z",
    "start_etd_date": "2019-08-24",
    "start_ready_time": "2019-08-24T14:15:22Z",
    "state": "string",
    "store_id": "string",
    "store_id_q": "string",
    "store_ids": [
        "string"
    ],
    "tourist_id": "string",
    "user_id": "string"
}'

返回响应

🟢200OK

application/json

Body

code

string

可选

data

boolean

可选

message

string

可选

示例

{
    "code": "string",
    "data": true,
    "message": "string"
}

🟢201Created

🟠401Unauthorized

🟠403Forbidden

🟠404Not Found

修改于 2025-04-10 12:13:40

编辑卖家备注

查询商城订单详情