开放平台

获取消费列表

请求地址(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", "CouponPreferential": 0, "ActivityPreferential": 0, "PointPreferential": 9.5, "PayMentPreferential": 0, "TotalPreferential": 9.5 }, { "Guid":"be21a368-6fcc-e211-81c9-90b11c47e696", "CardId": "cardIdTest2", "IsUndo": "true", "BillNumber": "XF20140524000015", "Way":2, "WayDesc": "消费收银", "Meno": "会员网站订购", "TrueName": "cardIdTest2", "OriginalTotalMoney": 100.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", "CouponPreferential": 0, "ActivityPreferential": 20, "PointPreferential": 0, "PayMentPreferential": 0, "TotalPreferential": 20 } ] }

字段 是否必须 说明
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开头),此字段表示其所关联的原单据
CouponPreferential 是 优惠券优惠金额
ActivityPreferential 是 活动优惠金额
PointPreferential 是 积分优惠金额
PayMentPreferential 是 收款优惠金额
TotalPreferential 是 总优惠金额

失败时返回:

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

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

获取消费列表 调试