导出Excel

导出Excel

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

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

Query 参数

clientId

string

clientId

必需

franchiseeId

string

必需

franchiseeId

userId

string

userId

必需

Header 参数

Authorization

string

必需

Body 参数application/json

分页查询POS销售订单资料

barcode

string

商品条码

可选

card_no

string

卡号

可选

cashier_ids

array[string]

多个收银员ID

可选

cert

boolean

只显示认证店

可选

channels

array[string]

渠道

可选

client_id

string

商户Id

可选

consignee_mobile

string

收货人手机号

可选

coupon_no

string

券号

可选

delivery_types

array[string]

多个发货方式

可选

end_create_time

string <date-time>

截止下单时间

可选

end_delivery_time

string <date-time>

截止发货时间

可选

end_etd_date

string <date>

截止需求日期

可选

end_payable

number <double>

截止实付金额

可选

franchisee_id

string

加盟商ID

可选

string

可选

item_types

array[string]

多个商品类型

可选

member_mobile

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_states

array[string]

多个支付状态

可选

payment_channel_order_id

string

支付交易流水号

可选

payment_ids

array[string]

支付方式ID

可选

payment_name

string

支付方式名称

可选

pick_up_code

string

取餐码

可选

string

模糊查询条件

可选

refund

boolean

已退款

可选

refund_states

array[string]

退货状态

可选

sales_asst_ids

array[string]

多个导购员ID

可选

sku_ids

array[string]

单品Id

可选

sku_name

string

单品名

可选

start_create_time

string <date-time>

起始下单时间

可选

start_delivery_time

string <date-time>

起始发货时间

可选

start_etd_date

string <date>

起始需求日期

可选

start_payable

number <double>

起始实付金额

可选

states

array[string]

多个状态

可选

store_id

string

门店id

可选

store_ids

array[string]

多个门店id

可选

supply_sources

array[string]

多个供货来源

可选

table_id

string

桌台ID

可选

table_ids

array[string]

多个桌台ID

可选

table_name

string

桌台名称

可选

takeout_store_ids

array[string]

多个取货门店ID

可选

types

array[string]

多个订单类型

可选

user_id

string

用户Id

可选

示例

{
    "barcode": "string",
    "card_no": "string",
    "cashier_ids": [
        "string"
    ],
    "cert": true,
    "channels": [
        "string"
    ],
    "client_id": "string",
    "consignee_mobile": "string",
    "coupon_no": "string",
    "delivery_types": [
        "string"
    ],
    "end_create_time": "2019-08-24T14:15:22Z",
    "end_delivery_time": "2019-08-24T14:15:22Z",
    "end_etd_date": "2019-08-24",
    "end_payable": 0,
    "franchisee_id": "string",
    "id": "string",
    "item_types": [
        "string"
    ],
    "member_mobile": "string",
    "merchandise_ids": [
        "string"
    ],
    "merchandise_name": "string",
    "merchandise_q": "string",
    "order_by": [
        {
            "key": "string",
            "type": "ASC"
        }
    ],
    "page_no": 0,
    "page_size": 0,
    "pay_states": [
        "string"
    ],
    "payment_channel_order_id": "string",
    "payment_ids": [
        "string"
    ],
    "payment_name": "string",
    "pick_up_code": "string",
    "q": "string",
    "refund": true,
    "refund_states": [
        "string"
    ],
    "sales_asst_ids": [
        "string"
    ],
    "sku_ids": [
        "string"
    ],
    "sku_name": "string",
    "start_create_time": "2019-08-24T14:15:22Z",
    "start_delivery_time": "2019-08-24T14:15:22Z",
    "start_etd_date": "2019-08-24",
    "start_payable": 0,
    "states": [
        "string"
    ],
    "store_id": "string",
    "store_ids": [
        "string"
    ],
    "supply_sources": [
        "string"
    ],
    "table_id": "string",
    "table_ids": [
        "string"
    ],
    "table_name": "string",
    "takeout_store_ids": [
        "string"
    ],
    "types": [
        "string"
    ],
    "user_id": "string"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/fcm/posSales/exportExcel?clientId=&franchiseeId=&userId=' \
--header 'Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
    "barcode": "string",
    "card_no": "string",
    "cashier_ids": [
        "string"
    ],
    "cert": true,
    "channels": [
        "string"
    ],
    "client_id": "string",
    "consignee_mobile": "string",
    "coupon_no": "string",
    "delivery_types": [
        "string"
    ],
    "end_create_time": "2019-08-24T14:15:22Z",
    "end_delivery_time": "2019-08-24T14:15:22Z",
    "end_etd_date": "2019-08-24",
    "end_payable": 0,
    "franchisee_id": "string",
    "id": "string",
    "item_types": [
        "string"
    ],
    "member_mobile": "string",
    "merchandise_ids": [
        "string"
    ],
    "merchandise_name": "string",
    "merchandise_q": "string",
    "order_by": [
        {
            "key": "string",
            "type": "ASC"
        }
    ],
    "page_no": 0,
    "page_size": 0,
    "pay_states": [
        "string"
    ],
    "payment_channel_order_id": "string",
    "payment_ids": [
        "string"
    ],
    "payment_name": "string",
    "pick_up_code": "string",
    "q": "string",
    "refund": true,
    "refund_states": [
        "string"
    ],
    "sales_asst_ids": [
        "string"
    ],
    "sku_ids": [
        "string"
    ],
    "sku_name": "string",
    "start_create_time": "2019-08-24T14:15:22Z",
    "start_delivery_time": "2019-08-24T14:15:22Z",
    "start_etd_date": "2019-08-24",
    "start_payable": 0,
    "states": [
        "string"
    ],
    "store_id": "string",
    "store_ids": [
        "string"
    ],
    "supply_sources": [
        "string"
    ],
    "table_id": "string",
    "table_ids": [
        "string"
    ],
    "table_name": "string",
    "takeout_store_ids": [
        "string"
    ],
    "types": [
        "string"
    ],
    "user_id": "string"
}'

请求参数

示例代码

返回响应