获取商品订单列表
请求地址(POST)
https://openapi.1card1.cn/BusinessApi/Get_GoodsBillPaged?openId=[OpenId]&signature=[Signature]×tamp=[TimeStamp]
字段 | 说明 |
---|---|
OpenId | 登陆开放平台生成的OpenId |
Signature | 签名=md5(OpenId+Secret+Timestamp+data),格式:32位md5大写加密 |
TimeStamp | 发起请求的时间戳,查看标准timestamp |
请求说明
data={"userAccount":"10003","where":" 1=1 and cardId='13632651195' ", "pageIndex":0,"pageSize":10,"orderBy":" cardId desc"}
字段 | 是否必须 | 说明 |
---|---|---|
userAccount | 是 | 工号 |
where | 否 | 查询条件 |
pageIndex | 是 | 页码 |
pageSize | 是 | 页大小 |
orderBy | 否 | 排序规则 |
返回说明
成功时返回:
{"status":0,"total":1,"data":[ { "Guid":"9b28bbf8-2c38-e611-a1d6-7c0507895043", "BillNumber":"DG20160622000002", "Status":0, "SubmitTime":"2016-06-22 11:54:08", "TotalMoney":170.0000, "PaidMoney":70.0000, "PaidValue":100.0000, "PaidPoint":0.0000, "PaidCoupon":0.0000, "PaidOther":0.0000, "PaidThirdpay":0.0000, "ThirdpayType":0, "ConsumeBillNumber":null, "IsCashOnDeliver":false, "IsSelfPickUp":false, "SelfPickUpTime":null, "SelfPickUpStoreName":null, "AssignChainStoreGuid":"3E964D41-7B6B-E711-A46B-7C0507895043", "AssignStoreName":"龙园店", "StatusName":"待审核", "CardId":"q", "TrueName":"1111", "Address":null, "Postcode":"", "Mobile":"13632651195", "Meno":"", "Receiver":null, "ReceiverMobile":null, "ThirdPayStatus":-3, "ItemList":[{"BarCode":"000003","Name":"碟","Number":"5","Price":"20.0000"}, {"BarCode":"111111","Name":"111","Number":"1","Price":"100.0000","GoodsItemSkuDesc":"颜色:天空蓝,版本:纯电版","SkuCode":"1234TKLEV"}, {"BarCode":"000002","Name":"图书","Number":"1","Price":"20.0000","GoodsItemSkuDesc":"","SkuCode":""}] }]}
字段 | 是否必须 | 说明 |
---|---|---|
BillNumber | 是 | 订单号 |
CardId | 是 | 卡号 |
TrueName | 是 | 姓名 |
Mobile | 是 | 手机号 |
Status | 是 | 订单状态(-1:已关闭,0:待审核,1:已完成,2:待支付,3:待发货,4:待自提,5:待收货,其他:不通过) |
AssignChainStoreGuid | 否 | 指派店面唯一标识 |
AssignStoreName | 否 | 指派店面名称 |
StatusName | 是 | 订单状态名称 |
SubmitTime | 是 | 提交时间 |
TotalMoney | 是 | 订单总金额 |
PaidMoney | 是 | 现金支付金额 |
PaidValue | 是 | 储值支付金额 |
PaidPoint | 是 | 积分支付金额 |
PaidCoupon | 是 | 优惠券支付金额 |
PaidOther | 是 | 其他支付金额 |
PaidThirdpay | 是 | 第三方支付金额 |
ThirdpayType | 是 | 第三方支付方式(1、微信支付,2、支付宝支付,0:非第三方支付) |
ConsumeBillNumber | 是 | 审核通过后的单据号(可在“获取消费列表”中查到) |
IsCashOnDeliver | 是 | 支付方式(true:货到付款,false:在线支付 ) |
IsSelfPickUp | 是 | 配送方式(true :上门自提,false:商家配送) |
SelfPickUpTime | 是 | 自提门店 |
SelfPickUpStoreName | 是 | 自提门店 |
Province | 是 | 送货地址-省 |
City | 是 | 送货地址-市 |
County | 是 | 送货地址-区 |
Address | 是 | 送货地址-详细地址 |
Postcode | 是 | 邮编 |
Receiver | 是 | 收货人(为空时参考TrueName) |
ReceiverMobile | 是 | 联系方式(为空时参考Mobile) |
Meno | 是 | 备注 |
ThirdPayStatus | 是 | 支付状态( -6,退款处理中;-5,退款失败;-4,支付失败;-3,退款成功;-2,取消订单;-1,支付失败;0,等待付款;1,支付成功;2,处理中) |
ItemList | 是 | 订单明细(BarCode:商品编码,Name:商品名称,Number:数量,Price:单价,GoodsItemSkuDesc:SKU描述,SkuCode:SKU编码) |
失败时返回:
{"status":-1,"message":"查询失败及原因"}
字段 | 是否必须 | 说明 |
---|---|---|
status | 是 | 状态(0,成功;-1,失败) |
message | 是 | 查询失败及原因 |