开放平台

获取消费列表

请求地址(POST)

https://openapi.1card1.cn/OpenApi/Get_ConsumeNotePagedV2?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":2, "data":[ { "Guid":"be21a368-6fcc-e211-81c9-90b11c47e696", "CardId": "cardIdTest", "IsUndo": "false", "BillNumber": "XF20140524000016", "Meno": "熟客消费", "TrueName":"cardIdTest", "TotalMoney": 99.50, "TotalPaid": 99.50, "PaidMoney": 40, "PaidValue": 50, "PaidPoint": 9.5, "Point": 99.5, "StoreName": "永乐门店", "UserAccount": "10000", "OperateTime": "2014-05-28 16:11:45" }, { "Guid":"be21a368-6fcc-e211-81c9-90b11c47e696", "CardId": "cardIdTest2", "IsUndo": "true", "BillNumber": "XF20140524000015", "Meno": "会员网站订购", "TrueName": "cardIdTest2", "TotalMoney": 80.0, "TotalPaid": 80.0, "PaidMoney": 80.0, "PaidValue": 0.0, "PaidPoint": 0.0, "Point": 80.0, "StoreName": "长安街店", "UserAccount": "10000", "OperateTime": "2014-05-28 16:11:45" } ] }

字段 是否必须 说明
Guid 单据唯一标识
CardId 卡号
IsUndo 是否撤销
BillNumber 单据号
Meno 备注
TrueName 会员姓名
TotalMoney 应付金额
TotalPaid 实付金额
PaidMoney 现金支付
PaidValue 储值支付
PaidPoint 积分支付
Point 获得积分
StoreName 操作店面
UserAccount 操作工号
OperateTime 操作时间

失败时返回:

{"status":-1,"message":"查询失败及原因"}

字段 是否必须 说明
status 状态(0,成功;-1,失败)
message 查询失败及原因

获取消费列表 调试