开放平台

获取商品订单列表

请求地址(POST)

https://openapi.1card1.cn/BusinessApi/Get_GoodsBillPaged?openId=[OpenId]&signature=[Signature]&timestamp=[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 查询失败及原因

获取商品订单列表 调试