交易查询接口
接口名称
openapi.payment.order.bill
请求方式
POST
请求头
application/json; charset=utf-8
请求业务参数
| 参数 | 类型 | 是否必填 | 最大长度 | 描述 |
|---|---|---|---|---|
| start_time | string | 是 | 20 | 查询开始时间：2018-08-01 00:00:00 |
| end_time | string | 是 | 20 | 查询结束时间：2018-08-01 23:59:59 |
| store_id | int | 否 | 10 | 门店ID |
| cashier_id | int | 否 | 10 | 收银员ID |
| device_no | string | 否 | 32 | 设备终端号 |
| page | int | 否 | 10 | 默认第一页 |
| limit | int | 否 | 3 | 每页数量 默认10条 最大100 |
- 请求示例:
{
"biz_content": "{\"start_time\":\"2018-08-02 00:00:00\",\"end_time\":\"2018-08-02 23:59:59\"}",
"method": "openapi.payment.order.bill",
"format": "json",
"sign_method": "md5",
"sign": "D84C042504F1A0FF177414BC8E533834",
"app_id": "20161206150707772500",
"nonce": "pp2kiwi",
"version": "1.0"
}
成功响应data参数
| 参数 | 类型 | 是否必填 | 最大长度 | 描述 |
|---|---|---|---|---|
| summary_num | int | 是 | 10 | 交易笔数汇总(订单总数) |
| summary_total_fee | float | 是 | 10 | 交易收入汇总 |
| refund_num | int | 是 | 10 | 退款笔数汇总 |
| refund_money | float | 是 | 10 | 退款金额汇总 |
| fee_sum | float | 是 | 10 | 手续费汇总[收款手续费减去退款手续费] |
| list | array | 是 | 不定 | 订单数据 |
成功响应list参数
| 参数 | 类型 | 是否必填 | 最大长度 | 描述 |
|---|---|---|---|---|
| order_sn | string | 是 | 32 | 付呗订单号 |
| merchant_order_sn | string | 是 | 32 | 第三方订单号 |
| create_time | int | 是 | 10 | 创建时间 |
| order_price | float | 是 | 10 | 订单金额，精确到2位小数 |
| total_fee | float | 是 | 10 | 实收金额 |
| fee | float | 是 | 10 | 手续费 |
| income | float | 是 | 10 | 净收入 |
| store_id | int | 是 | 10 | 门店ID |
| cashier_id | int | 是 | 10 | 收银员ID |
| pay_time | int | 是 | 10 | 支付时间(秒) |
| pay_type | int | 是 | 1 | 支付方式 1 微信支付 2支付宝 5银联 |
| discount_money | float | 是 | 10 | 折扣金额 |
| no_cash_coupon_fee | float | 否 | 10 | 免充值代金券金额 |
| cash_coupon_fee | float | 否 | 10 | 预充值代金券金额 |
| device_no | string | 否 | 32 | 设备终端号 |
- 响应示例:
{ "result_message": "成功", "data": { "summary_num": "3", "summary_total_fee": "0.03", "refund_num": "0", "refund_money": "0.00", "fee_sum": "1.11", "list": [ { "order_sn": "20180802174620178931", "merchant_order_sn": "20180802174603898951", "order_price": "0.02", "create_time": "1533203180", "total_fee": "0.01", "fee": 0, "store_id": "3980", "cashier_id": "0", "pay_time": "1533203191", "pay_type": "1", "discount_money": "0.00", "income": 0.01, "coupon_fee":0.01 }, { "order_sn": "20180802174714841600", "merchant_order_sn": "20180802174702166607", "order_price": "0.01", "create_time": "1533203234", "total_fee": "0.01", "fee": 0, "store_id": "3980", "cashier_id": "0", "pay_time": "1533203243", "pay_type": "1", "discount_money": "0.00", "income": 0.01 }, { "order_sn": "20180802190536386250", "merchant_order_sn": "20180802190529670255", "order_price": "0.01", "create_time": "1533207936", "total_fee": "0.01", "fee": 0, "store_id": "3980", "cashier_id": "0", "pay_time": "1533207955", "pay_type": "1", "discount_money": "0.00", "income": 0.01 } ] }, "result_code": 200 }