获取消费列表
请求地址(POST)
https://openapi.1card1.cn/OpenApi/Get_ConsumeNotePagedV2?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":" 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 | 是 | 查询失败及原因 |