开放平台

获取消费列表

请求地址(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":" OperateTime desc"}

字段 是否必须 说明
userAccount 工号
where 查询条件
pageIndex 页码
pageSize 页大小
orderBy 排序规则

返回说明

成功时返回:

{ "status":0, "total":2, "data":[ { "Guid":"be21a368-6fcc-e211-81c9-90b11c47e696", "CardId": "cardIdTest", "IsUndo": "false", "BillNumber": "XF20140524000016", "Way":2, "WayDesc": "消费收银", "Meno": "熟客消费", "TrueName":"cardIdTest", "OriginalTotalMoney": 99.50, "TotalMoney": 99.50, "TotalPaid": 99.50, "PaidMoney": 40, "PaidValue": 50, "PaidCoupon": 0, "PaidPoint": 9.5, "PaidCard": 0.0000, "PaidThirdpay": 0.0000, "ThirdpayType": 0, "Point": 99.5, "ChainStoreGuid": "be21a368-6fcc-e211-81c9-90b11c47e697", "StoreName": "永乐门店", "UserAccount": "10000", "OperateTime": "2014-05-28 16:11:45", "RelationBillNumber":"TH20191018000001" }, { "Guid":"be21a368-6fcc-e211-81c9-90b11c47e696", "CardId": "cardIdTest2", "IsUndo": "true", "BillNumber": "XF20140524000015", "Way":2, "WayDesc": "消费收银", "Meno": "会员网站订购", "TrueName": "cardIdTest2", "OriginalTotalMoney": 80.0, "TotalMoney": 80.0, "TotalPaid": 80.0, "PaidMoney": 80.0, "PaidValue": 0.0, "PaidCoupon": 0, "PaidPoint": 0.0, "PaidCard": 0.0000, "PaidThirdpay": 0.0000, "ThirdpayType": 0, "Point": 80.0, "ChainStoreGuid": "be21a368-6fcc-e211-81c9-90b11c47e698", "StoreName": "长安街店", "UserAccount": "10000", "OperateTime": "2014-05-28 16:11:45", "RelationBillNumber":"TH20191018000001" } ] }

字段 是否必须 说明
Guid 单据唯一标识
CardId 卡号
IsUndo 是否撤销
BillNumber 单据号
Way 业务类型枚举(1;快速消费,2:消费收银,3:储值扣费,4:计次消费 等等)
WayDesc 业务类型描述
Meno 备注
TrueName 会员姓名
TotalMoney 应付金额
OriginalTotalMoney 原价总金额
TotalPaid 实付金额
PaidMoney 现金支付
PaidValue 储值支付
PaidCoupon 优惠券支付
PaidPoint 积分支付
PaidCard 银行卡记账
PaidThirdpay 移动支付金额
ThirdpayType 移动支付类型(0:支付宝,1:拉卡拉,2:微信)
Point 获得积分
ChainStoreGuid 操作店面唯一标识
StoreName 操作店面
UserAccount 操作工号
OperateTime 操作时间
RelationBillNumber 该单据为退单单据时(TH开头),此字段表示其所关联的原单据

失败时返回:

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

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

获取消费列表 调试