Action 29：查询游戏详细交易信息

功能说明

整合所有游戏详细交易信息，以 gType 区分游戏类型。
- 若参数包含 gTypes，则查询指定的游戏类型交易信息。
查询单一代理在特定时间区段内的已结算的详细交易信息。
开始时间与结束时间中，ss（秒数）的值必须为 00。
每次查询时间范围最多为 15 分钟，最新信息为 3 分钟前。例如，在 15:00:00 时的查询，最晚只能查到 14:56:00 ~ 14:57:00 的信息。
建议每次查询范围不超过1分钟，以获得较佳效果。
此功能查询出来的数据是以该笔游戏纪录的 最后修改时间（lastModifyTime）为准，因此查询出来的笔数与输赢报表的全部交易资料不合，则是因为该笔纪录于查询之时间区间内并未结算。
提供 2 小时内的交易信息，超过 1 小时的交易信息请至 Action 64 查询。
每次的博取游戏皆为一笔交易信息，当 hasGamble 为 1 时，代表此笔交易信息为博取游戏。只有JDB的Bar类型（gType=9）游戏, 才有博取游戏。
- Example:
  1. 当玩家进行游戏，下注 10，赢分 100
    bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0
  2. 同上，当玩家将赢分进行博取游戏，并且获得胜利
    bet = 0, gambleBet = -100, win = 200, total = 100, hasGamble = 1
数据量大时，建议使用 HTTP 压缩取回数据

参数

参数	格式	强制	说明
action	Integer	Y	29
ts	Long	Y	当前系统时间
parent	String(50)	Y	代理账号
starttime	String(19)	Y	查询区段起始时间（dd-MM-yyyy HH:mm:ss）
endtime	String(19)	Y	查询区段结束时间（dd-MM-yyyy HH:mm:ss）
gTypes	Integer Array	N	游戏类型参照附录游戏提供商

Example

{
  "action": 29,
  "ts": 1447452951820,
  "parent": "testag",
  "starttime": "08-12-2016 17:45:00",
  "endtime": "08-12-2016 17:46:00",
  "gTypes": [0,7]
}

返回结果

参数	格式	说明
status	String(4)	成功：0000 错误：参照附录错误代码 `查无资料：0000`
data	JSON Array	`回传的数据组将依据 gType 有不同内容，分别列于下列表中`
err_text	String(255)	错误讯息

老虎机下注记录：gType = 0, 66, 90

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	老虎机押注金额
win	Double	游戏赢分
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
jackpot	Double	赢得彩金金额
jackpotContribute	Double	彩金贡献值
denom	Double	投注面值
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIp	String(50)	玩家登入 IP
clientType	String(20)	玩家从网页或行动装置登入
hasFreegame	Integer	免费游戏 0：否 1：是
systemTakeWin	Integer	标记该笔为游戏中断线，由系统结算 0：否 1：是
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

捕鱼机下注记录：gType = 7, 67, 91

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
roomType	Integer	游戏区域 -1：大厅（成就游戏） 0：小压码区 1：中压码区 2：大压码区 `各压码区称号会依据机台类型有所不同`
currency	String(10)	货币别参照附录货币代码
bet	Double	押注金额
win	Double	游戏赢分
total	Double	总输赢
denom	Double	投注面值
beforeBalance	Double	进场金额
afterBalance	Double	离场金额
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIp	String(50)	玩家登入 IP
clientType	String(20)	玩家从网页或行动装置登入

街机下注记录：gType = 9, 92

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	押注金额
gambleBet	Double	博取游戏押注金额
win	Double	游戏赢分
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
denom	Double	投注面值
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIp	String(50)	玩家登入 IP
clientType	String(20)	玩家从网页或行动装置登入
hasBonusGame	Integer	奖金游戏 0：否 1：是
hasGamble	Integer	博取游戏 0：否 1：是
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

电子彩票下注记录：gType = 12

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	押注金额
win	Double	游戏赢分
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
denom	Double	投注面值
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIp	String(50)	玩家登入 IP
clientType	String(20)	玩家从网页或行动装置登入
hasBonusGame	Integer	奖金游戏 0：否 1：是
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

棋牌下注记录：gType = 18, 93

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
roundSeqNo	Long	游戏局号
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	押注金额
win	Double	游戏赢分
tax	Double	税
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIp	String(50)	玩家登入 IP
clientType	String(20)	玩家从网页或行动装置登入
validBet	Double	有效押注金额
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

SPRIBE、FC、AMB、YB、Mancala、Onlyplay、CreedRoomz、ZestPlay、SmartSoft 下注记录：gType = SPRIBE(22), FC(30, 31, 32), AMB(50), YB(58, 59, 60), Mancala(57, 75), Onlyplay(80, 81), CreedRoomz(101), ZestPlay(120), SmartSoft(130, 131, 132)

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	押注金额
win	Double	游戏赢分
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

HRG 下注记录：gType = 41

参数	格式	说明
historyId	String(100)	游戏序号参照附录 historyId 说明
roundSeqNo	String(30)	游戏局号
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
bet	Double	押注金额
win	Double	游戏赢分
validBet	Double	有效押注金额
commission	Double	回馈金
total	Double	总输赢
currency	String(10)	货币别参照附录货币代码
lastModifyTime	String(19)	最后修改时间（dd-MM-yyyy HH:mm:ss）
beforeBalance	String(20)	进场金额
afterBalance	String(20)	离场金额

操作范例

// Http Request
http://{API_Address}/apiRequest.do?dc=jb&x=udbFVt_xv0tsAmLDpz5Z3Ct4-p0gedUPdQO-UWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnp-K0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzbWKEddANjAAbxF0s=
 
 
// Http Response (success)
{
  "status":"0000",
  "data":[
    {
      "historyId":"5250145823902",
      "playerId":"test01",
      "gType":0,
      "mtype":8001,
      "gameDate":"06-06-2017 09:56:09",
      "bet":-0.4,"win":0.4,
      "total":0,
      "currency":"RB",
      "jackpot":0,
      "jackpotContribute":-0.002,
      "denom":0.02,
      "lastModifyTime":"06-06-2017 09:56:09",
      "playerIp":"10.20.6.86",
      "clientType":"WEB",
      "hasFreegame":0,
      "systemTakeWin":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"5250228066060",
      "playerId": "test01",
      "gType": 0,
      "mtype": 14001,
      "gameDate": "18-07-2023 14:24:22",
      "bet": -1,
      "win": 2.3,
      "total": 1.3,
      "currency": "RB",
      "jackpot": 0,
      "jackpotContribute": -0.005,
      "denom": 0.05,
      "lastModifyTime": "18-07-2023 14:24:22",
      "playerIp": "10.20.6.86",
      "clientType": "WEB",
      "hasFreegame": 0,
      "hasGamble": 0,
      "gambleBet": 0,
      "systemTakeWin": 0,
      "beforeBalance": "8477.425",
      "afterBalance": "8478.725"
    },
    {
      "historyId":"43579741",
      "playerId":"test01",
      "gameDate":"07-06-2017 16:21:48",
      "gType":7,
      "mtype":7001,
      "roomType":1,
      "currency":"RB",
      "bet":-62.5,
      "win":19.75,
      "total":-42.75,
      "denom":5,
      "beforeBalance":200095.6,
      "afterBalance":200052.85,
      "lastModifyTime":"07-06-2017 16:21:55",
      "playerIp":"10.20.6.86",
      "clientType":"WEB"
    },
    {
      "historyId":"5250152072553",
      "playerId":"sbtmppl01",
      "gType":9,
      "mtype":9001,
      "gameDate":"25-07-2018 18:49:01",
      "bet":-90,
      "gambleBet":0,
      "win":20,
      "total":-70,
      "currency":"RB",
      "denom":1,
      "lastModifyTime":"25-07-2018 18:49:06",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "hasGamble":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8407.425"
    },
    {
      "historyId":"5250152072557",
      "playerId":"sbtmppl01",
      "gType":9,
      "mtype":9001,
      "gameDate":"25-07-2018 18:49:10",
      "bet":0,
      "gambleBet":-20,
      "win":40,
      "total":20,
      "currency":"RB",
      "denom":1,
      "lastModifyTime":"25-07-2018 18:49:15",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "hasGamble":1,
      "beforeBalance": "8477.425",
      "afterBalance": "8497.425"
    },
    {
      "historyId":"5250147282661",
      "playerId":"gh2alice1",
      "gType":12,
      "mtype":12001,
      "gameDate":"14-05-2018 14:53:53",
      "bet":-0.08,
      "win":0.05,
      "total":-0.03,
      "currency":"TB",
      "denom":0.01,
      "lastModifyTime":"14-05-2018 14:53:53",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.395"
    },
    {
      "historyId":"5250147282662",
      "playerId":"gh2alice1",
      "gType":12,
      "mtype":12001,
      "gameDate":"14-05-2018 14:53:57",
      "bet":-0.08,
      "win":0.05,
      "total":-0.03,
      "currency":"TB",
      "denom":0.01,
      "lastModifyTime":"14-05-2018 14:53:57",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.395"
    },
    {
      "historyId":"5250155819867",
      "roundSeqNo":5558,
      "playerId":"test888",
      "gType":18,
      "mtype":18001,
      "gameDate":"13-07-2018 14:07:33",
      "bet":-2,
      "win":6,
      "tax":-0.3,
      "total":5.7,
      "currency":"TB",
      "lastModifyTime":"13-07-2018 14:07:33",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "validBet":-2,
      "beforeBalance": "8477.425",
      "afterBalance": "8483.125"
    },
    {
      "historyId":"5250155819872",
      "roundSeqNo":5559,
      "playerId":"test888",
      "gType":18,
      "mtype":18001,
      "gameDate":"13-07-2018 14:07:47",
      "bet":-8,
      "win":-8,
      "tax":0,
      "total":-8,
      "currency":"TB",
      "lastModifyTime":"13-07-2018 14:07:47",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "validBet":-8,
      "beforeBalance": "8477.425",
      "afterBalance": "8469.425"
    },
    {
      "historyId":"703514510",
      "playerId": "sbcpl03",
      "gType": 22,
      "mtype": 22001,
      "gameDate": "01-12-2021 17:12:16",
      "bet": -0.3,
      "win": 0,
      "total": -0.3,
      "currency": "TB",
      "lastModifyTime": "01-12-2021 17:12:16",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.125"
    },
    {
      "historyId":"21231513",
      "playerId": "sbcpl03",
      "gType": 26,
      "mtype": 26001,
      "gameDate": "07-06-2022 13:56:52",
      "bet": -3.0,
      "win": 0.0,
      "total": -3.0,
      "currency": "RB",
      "lastModifyTime": "07-06-2022 13:56:52",
      "beforeBalance": "8477.425",
      "afterBalance": "8474.425"
    },
    {
      "historyId":"212315583",
      "playerId": "sbcpl03",
      "gType": 27,
      "mtype": 27017,
      "gameDate": "07-06-2022 15:25:21",
      "bet": -70.0,
      "win": 70.0,
      "total": 0.0,
      "currency": "RB",
      "lastModifyTime": "07-06-2022 15:25:21",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"a45621c58wd",
      "playerId": "sbcpl03",
      "gType": 30,
      "mtype": 30001,
      "gameDate": "20-10-2022 15:33:41",
      "bet": -0.4,
      "win": 0.0,
      "total": -0.4,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.025"
    },
    {
      "historyId":"we1451fa3s1d",
      "playerId": "sbcpl03",
      "gType": 31,
      "mtype": 31003,
      "gameDate": "20-10-2022 15:34:15",
      "bet": -4.0,
      "win": 100.0,
      "total": 96.0,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:34:15",
      "beforeBalance": "8477.425",
      "afterBalance": "9453.425"
    },
    {
      "historyId":"yc1451fa3s1d",
      "playerId": "sbcpl03",
      "gType": 32,
      "mtype": 32016,
      "gameDate": "20-10-2022 15:34:58",
      "bet": -0.5,
      "win": 0.0,
      "total": -0.5,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:34:58",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.925"
    },
    {
      "historyId":"584654231",
      "playerId": "sbcpl03",
      "gType": 50,
      "mtype": 50001,
      "gameDate": "03-05-2023 15:33:41",
      "bet": -0.4,
      "win": 0.0,
      "total": -0.4,
      "currency": "RB",
      "lastModifyTime": "03-05-2023 15:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.025"
    },
    {
      "historyId":"tr458466a5we",
      "playerId": "sbcpl03",
      "gType": 55,
      "mtype": 55001,
      "gameDate": "08-06-2023 17:33:41",
      "bet": -0.8,
      "win": 0.0,
      "total": -0.8,
      "currency": "RB",
      "lastModifyTime": "08-06-2023 17:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.825"
    },
    {
      "historyId":"wr451fd321g56",
      "playerId": "sbcpl03",
      "gType": 56,
      "mtype": 56001,
      "gameDate": "08-06-2023 17:33:41",
      "bet": -0.7,
      "win": 0.0,
      "total": -0.7,
      "currency": "RB",
      "lastModifyTime": "08-06-2023 17:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.725"
    },
    {
      "historyId":"wer154s1cfq",
      "playerId": "mancalatest01",
      "gType": 57,
      "mtype": 57001,
      "gameDate": "08-08-2023 16:23:11",
      "bet": -1.75,
      "win": 1.75,
      "total": 0,
      "currency": "RB",
      "lastModifyTime": "08-08-2023 16:23:11",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"1846626470",
      "playerId": "ybtest01",
      "gType": 58,
      "mtype": 58001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"1846626471",
      "playerId": "ybtest01",
      "gType": 59,
      "mtype": 59001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"1846626472",
      "playerId": "ybtest01",
      "gType": 60,
      "mtype": 60001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"525056886488",
      "playerId":"testpl01",
      "gType":66,
      "mtype":66001,
      "gameDate":"03-05-2019 16:34:29",
      "bet":-0.05,
      "win":0,
      "total":-0.05,
      "currency":"TB",
      "jackpot":0,
      "jackpotContribute":-0.00025,
      "denom":0.001,
      "lastModifyTime":"03-05-2019 16:34:29",
      "gameName":"",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasFreegame":0,
      "systemTakeWin":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.375"
    },
    {
      "historyId":"5250568864780",
      "playerId":"testpl01",
      "gameDate":"03-05-2019 16:32:42",
      "gType":67,
      "mtype":67001,
      "roomType":0,
      "gameName":"",
      "currency":"TB",
      "bet":-0.22,
      "win":0,
      "total":-0.22,
      "denom":1,
      "beforeBalance":111656.22,
      "afterBalance":111656,
      "lastModifyTime":"03-05-2019 16:32:42",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.205"
    },
    {
        "historyId": "AAA-212256709",
        "roundSeqNo": "RND-0020107870010",
        "playerId": "testpl01",
        "gType": 41,
        "mtype": 41001,
        "gameDate": "14-11-2023 16:13:16",
        "bet": -500,
        "win": 0,
        "validBet": 0,
        "commission": 0,
        "total": -500,
        "currency": "RB",
        "lastModifyTime": "14-11-2023 16:14:04",
        "beforeBalance": "8477.425",
        "afterBalance": "7977.425"
    },
    {
      "historyId":"57762",
      "playerId": "zestplaytest01",
      "gType": 120,
      "mtype": 120001,
      "gameDate": "18-10-2024 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "18-10-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"caa819bb-9a3f-40eb-8367-0271397037f3",
      "playerId": "smartsofttest01",
      "gType": 130,
      "mtype": 130001,
      "gameDate": "18-11-2024 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "18-11-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    }
  ]
}
 
// Http Response (error)
{
  "status":"9005",
  "err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
 
// Http Response (no data)
{
  "status":"0000",
  "data":[]
}

Action 61：现金转账历史（含奖金）Action 42：每日对帐报表