文档
测试

消费记录查询接口

websocket测试
POST
http://crm.houcaller.com/htest/openapi/v1/queryMemberScoRecordForShop

请求参数

参数名
类型
描述
必填
queryType
String
查询类型 不传的话默认是memberId 可选参数 openId;//微信openId；unionId;//微信unionId；phone;//手机号码；memberId;//会员主键id；id;//会员主键id
可选
phone
String
可选
memberId
String
可选
id
String
可选
unionId
String
可选
openId
String
可选
month
String
查询月份
必填
scoType
String
积分类型（0：积分初始化转入；1：积分累计；2：积分清理；3：积分兑换；4：积分补送；5：积分商城支出；6：积分商城收入；7：积分商城游戏；8：积分过期；9：开放平台支出；10 ：开放平台收入）
可选
hbsBusiType
String
积分商城业务类别（0：非积分商城业务；1：积分商城兑券消费支出；2：游戏扣除；3：大转盘游戏记录；-1：积分商城签到活动收入；-2：游戏增加；-3：积分商城任务奖励收入；-4：积分兑换豪币收入；-5：会员消费返还豪币；-6：积分商城新用户奖励；-7：积分商城签到活动收入；-8：营销活动收入；）
可选
page
object
分页条件
必填
offset
String
起始位置
必填
limit
String
分页长度
必填

响应参数

参数名
类型
描述
必填
msg
string
示例：操作成功
必填
code
int
示例：0
必填
data
object
数据字典
必填
totalIncScore
BigDecimal
某月积分总收入
必填
totalExpScore
BigDecimal
某月积分总支出
必填
records
array
记录列表
必填
amount
int
订单金额
必填
bizDate
string
业务日期
必填
cardNo
string
会员卡号
必填
consAmt
int
累计消费的金额 ,计算积分等级用
必填
expScore
int
减少（花费）的积分
必填
incScore
int
收入的积分数额
必填
orgCode
string
餐厅编码
必填
remark
string
备注 示例：轻烹商城兑券(反结账)(反结账)
必填
scoreAmt
int
计算积分的金额，算积分用
必填
page
object
分页结果
必填
next
boolean
是否有下一分页
必填
pages
int
总页数
必填
offset
int
起始位置
必填
limit
int
分页长度
必填
count
int
查询总数
必填
index
int
当前页数
必填
nextOffset
int
下一分页起始位置
必填

说明 / 示例

<pre>{ "msg": "操作成功", "code": 0, "data": { "totalIncScore": 14.00, "totalExpScore": 100.00, "records": [ { "amount": 0, "bizDate": "2023-08-08 00:00:00", "bizDate1": "", "bizDate2": "", "cardNo": "9014046364676", "checktime": "", "consAmt": 0, "ctime": "", "cuser": "", "ectid": "", "ectnum": 0, "encryption": "", "expHbbal": 0, "expScore": 0, "gradeId": "", "hbsBusiType": "", "id": "", "incHbbal": 0, "incScore": 14, "mmbId": "", "openid": "", "ordertime": "", "orgCode": "1", "oriId": "", "payAmt": 0, "pmtid": "", "posScore": 0, "realRate": 0, "remark": "08月轻烹商城签到记录", "scoRate": 0, "scoType": 0, "scoreAmt": 0, "scoreBalance": 914, "srcId": "", "srcObj": "", "status": 0 }, { "amount": 0, "bizDate": "2023-08-08 00:00:00", "bizDate1": "", "bizDate2": "", "cardNo": "9014046364676", "checktime": "", "consAmt": 0, "ctime": "", "cuser": "", "ectid": "", "ectnum": 0, "encryption": "", "expHbbal": 0, "expScore": -200, "gradeId": "", "hbsBusiType": "", "id": "", "incHbbal": 0, "incScore": 0, "mmbId": "", "openid": "", "ordertime": "", "orgCode": "1", "oriId": "", "payAmt": 0, "pmtid": "", "posScore": 0, "realRate": 0, "remark": "轻烹商城积分兑换(反结账)(反结账)", "scoRate": 0, "scoType": 0, "scoreAmt": 0, "scoreBalance": 900, "srcId": "", "srcObj": "", "status": 0 }, { "amount": 0, "bizDate": "2023-08-08 00:00:00", "bizDate1": "", "bizDate2": "", "cardNo": "9014046364676", "checktime": "", "consAmt": 0, "ctime": "", "cuser": "", "ectid": "", "ectnum": 0, "encryption": "", "expHbbal": 0, "expScore": -200, "gradeId": "", "hbsBusiType": "", "id": "", "incHbbal": 0, "incScore": 0, "mmbId": "", "openid": "", "ordertime": "", "orgCode": "1", "oriId": "", "payAmt": 0, "pmtid": "", "posScore": 0, "realRate": 0, "remark": "轻烹商城积分兑换(反结账)", "scoRate": 0, "scoType": 0, "scoreAmt": 0, "scoreBalance": 700, "srcId": "", "srcObj": "", "status": 0 }, { "amount": 0, "bizDate": "2023-08-08 00:00:00", "bizDate1": "", "bizDate2": "", "cardNo": "9014046364676", "checktime": "", "consAmt": 0, "ctime": "", "cuser": "", "ectid": "", "ectnum": 0, "encryption": "", "expHbbal": 0, "expScore": 500, "gradeId": "", "hbsBusiType": "", "id": "", "incHbbal": 0, "incScore": 0, "mmbId": "", "openid": "", "ordertime": "", "orgCode": "1", "oriId": "", "payAmt": 0, "pmtid": "", "posScore": 0, "realRate": 0, "remark": "轻烹商城积分兑换", "scoRate": 0, "scoType": 0, "scoreAmt": 0, "scoreBalance": 500, "srcId": "", "srcObj": "", "status": 0 } ], "page": { "next": false, "pages": 1, "offset": 0, "limit": 10, "count": 4, "index": 1, "nextOffset": 4 } } }
上一篇 用户成长经验值
nextDoc 消费记录查询接口 没有分页 查询所有
本文档使用易文档编写, 更新时间: 2023-08-15 17:35