账单获取

1、功能名称：账单获取

2、功能描述：账单获取

3、请求地址：https://ssl.glitzcloud.com/agent/v1/api/invoice/query

      测试地址：http://gztest.glitzcloud.com/agent/v1/api/invoice/query

4、请求方式：POST

5、请求参数

名称 类型 必填 示例值 描述
store_name String 是 The Warehouse USA 仓库名称
time_from Integer 是 1487606400 开始时间时间戳
time_to Integer 是 1487606400 结束时间时间戳

6、请求示例

           array(
                    'format'=>'json',
                    'apikey'=>'85082f5f62a811e684f500163e06045f',
                    'randoms'=>1234,
                    'sign'=>'656d6fbe6b7dec6c2e77ffe27f04bd6d',
                    'store_name' => 'The Warehouse USA',
                    'time_from' => '1487606400',
                    'time_to' => '1487606400',
             );

7、返回格式：JSON

8、返回示例：

正确时的返回JSON数据包如下：

{"status":200,"reqMsg":"ok","result":[{"billing_sn":"GCB17071300001","pay_status":"10","due_time":"2017-07-28","confirm_time":"","pay_time":"","start_time":"2017-07-10","end_time":"2017-07-16","create_time":"2017-07-13 16:59:18","total_amount_all":5.95,"details":[{"charge_name":"Shipping","total_amount":77.71,"details":[{"order_sn":"Amy Yao-523452345fefed1","order_type":"1","charge_name":"Shipping","charge_price":null,"charge_amount":"1","charge_discount":"1.00","charge_total":"1.00","charge_currency":"usd","pay_status":"0","create_time":"2017-05-23 14:12:40"},{"order_sn":"Amy Yao-20170510002","order_type":"1","charge_name":"Shipping","charge_price":null,"charge_amount":"1","charge_discount":"1.00","charge_total":"1.00","charge_currency":"usd","pay_status":"0","create_time":"2017-05-23 14:13:01"},{"order_sn":"Amy Yao-20170510002","order_type":"1","charge_name":"Shipping","charge_price":"18.62","charge_amount":"1","charge_discount":"1.30","charge_total":"21.79","charge_currency":"usd","pay_status":"0","create_time":"2017-05-27 11:08:36"},{"order_sn":"Amy Yao-Ronnie777","order_type":"1","charge_name":"Shipping","charge_price":"9.08","charge_amount":"1","charge_discount":"1.30","charge_total":"10.62","charge_currency":"usd","pay_status":"0","create_time":"2017-06-09 13:56:52"},{"order_sn":"GCO16092600006-01","order_type":"1","charge_name":"Shipping","charge_price":"10.49","charge_amount":"1","charge_discount":"1.30","charge_total":"12.27","charge_currency":"usd","pay_status":"0","create_time":"2017-06-09 14:20:22"},{"order_sn":"GCO16092600006-02","order_type":"1","charge_name":"Shipping","charge_price":"10.49","charge_amount":"1","charge_discount":"1.30","charge_total":"12.27","charge_currency":"usd","pay_status":"0","create_time":"2017-06-09 14:27:45"},{"order_sn":"Amy Yao-312312312","order_type":"1","charge_name":"Shipping","charge_price":"6.71","charge_amount":"1","charge_discount":"1.30","charge_total":"9.38","charge_currency":"usd","pay_status":"0","create_time":"2017-07-03 13:14:28"},{"order_sn":"Amy Yao-20170510001","order_type":"1","charge_name":"Shipping","charge_price":"6.71","charge_amount":"1","charge_discount":"1.30","charge_total":"9.38","charge_currency":"usd","pay_status":"0","create_time":"2017-07-03 13:22:00"}]},{"charge_name":"FBA return receiving 1","total_amount":1,"details":[{"order_sn":"GCI17052300002","order_type":"1","charge_name":"FBA return receiving 1","charge_price":"1.00","charge_amount":"1","charge_discount":"1.00","charge_total":"1.00","charge_currency":"usd","pay_status":"0","create_time":"2017-05-23 14:50:11"}]},{"charge_name":"FBA return receiving 2","total_amount":8,"details":[{"order_sn":"GCI17052300002","order_type":"1","charge_name":"FBA return receiving 2","charge_price":"2.00","charge_amount":"2","charge_discount":"2.00","charge_total":"8.00","charge_currency":"usd","pay_status":"0","create_time":"2017-05-23 14:50:11"}]},{"charge_name":"Material","total_amount":1.3,"details":[{"order_sn":"Amy Yao-Ronnie777","order_type":"1","charge_name":"Material","charge_price":"1.00","charge_amount":"1","charge_discount":"1.30","charge_total":"1.30","charge_currency":"usd","pay_status":"0","create_time":"2017-06-09 13:56:52"}]},{"charge_name":"Relabel","total_amount":23.4,"details":[{"order_sn":"REL17031300003","order_type":"1","charge_name":"Relabel","charge_price":"0.40","charge_amount":"1","charge_discount":"1.30","charge_total":"0.52","charge_currency":"USD","pay_status":"0","create_time":"2017-06-19 14:35:47"},{"order_sn":"REL17061900001","order_type":"1","charge_name":"Relabel","charge_price":"0.40","charge_amount":"19","charge_discount":"1.30","charge_total":"9.88","charge_currency":"USD","pay_status":"0","create_time":"2017-06-19 14:52:04"},{"order_sn":"REL17031300001","order_type":"1","charge_name":"Relabel","charge_price":"0.40","charge_amount":"8","charge_discount":"1.30","charge_total":"4.16","charge_currency":"USD","pay_status":"0","create_time":"2017-07-06 14:47:00"},{"order_sn":"REL17031300002","order_type":"1","charge_name":"Relabel","charge_price":"0.40","charge_amount":"2","charge_discount":"1.30","charge_total":"1.04","charge_currency":"USD","pay_status":"0","create_time":"2017-07-06 14:48:11"},{"order_sn":"REL17070500001","order_type":"1","charge_name":"Relabel","charge_price":"0.40","charge_amount":"15","charge_discount":"1.30","charge_total":"7.80","charge_currency":"USD","pay_status":"0","create_time":"2017-07-06 16:48:27"}]},{"charge_name":"Discount","total_amount":-105.46,"details":[{"order_sn":"","order_type":"1","charge_name":"Discount","charge_price":"-8.91","charge_amount":"1","charge_discount":null,"charge_total":"-8.91","charge_currency":"usd","pay_status":"0","create_time":"2017-07-14 17:12:09"},{"order_sn":"","charge_name":"Discount","order_type":"1","charge_price":"-1.27","charge_amount":"1","charge_discount":null,"charge_total":"-1.27","charge_currency":"usd","pay_status":"0","create_time":"2017-07-14 17:12:10"},{"order_sn":"","order_type":"1","charge_name":"Discount","charge_price":"-22.23","charge_amount":"1","charge_discount":null,"charge_total":"-22.23","charge_currency":"usd","pay_status":"0","create_time":"2017-07-14 17:12:10"},{"order_sn":"","order_type":"1","charge_name":"Discount","charge_price":"-73.05","charge_amount":"1","charge_discount":null,"charge_total":"-73.05","charge_currency":"usd","pay_status":"0","create_time":"2017-07-14 17:12:10"}]}]}]}

错误时的返回JSON数据包如下：

{"status":"2590","reqMsg":"Time field.","result":[]}

9、返回参数说明：

参数 类型 示例值 描述
billing_sn String GCB17022100001 账单编号
pay_status Integer 30 支付状态 10:未支付;
20:用户确认;30:支付完成
due_time String 2017-03-08 账单到期日
confirm_time String 2017-02-21 账单确认时间
pay_time String 2017-07-16 支付时间
start_time String 2017-07-10 账单开始时间
end_time String 2017-07-16 账单结束时间
create_time String 2017-02-20 账单创建时间
total_amount_all Float 111.41 账单总金额
charge_name String 费用名称 费用名称 Inbound:入库;
Outbound:出库;Return:退换货;
Storage:仓储费;Relabeling:换标;
total_amount Float 分类费用总金额 77.71
order_sn String 20170703001 入库单号,或者出库平台
订单号或者退换货单号
order_type String 1 订单类型1：入库单；2：出库单; 3:退货单
charge_price Float 10.00 费用单价
charge_amount Float 1 数量
charge_discount Float 0.95 折扣
charge_total Float 9.50 总费用
charge_currency String usd 币种 usd:美元;rmb:人民币
pay_status Integer 0 支付状态 0:未支付 ;1:已支付
create_time String 2017-05-23 14:50:11 费用生成时间

全局返回码说明