Action 64：查询历史游戏详细交易信息

功能说明

查询单一代理在特定时间区段内的已结算的详细交易信息。
整合所有游戏详细交易信息，以 gType 区分游戏类型。
- 若参数包含 gTypes，则查询指定的游戏类型交易信息。
仅提供 1 小時前 ~ 60 天内的资料
- 1 小时内的数据，请至 action 29 查询。
资料时间范围说明
- 开始时间(starttime) 与结束时间(endtime)，其 ss（秒数）的值必须为 00。
- 开始时间(starttime) 与结束时间(endtime)，范围不得超过 5 分钟。建议每次查询范围不超过1分钟，以获得较佳效果。
此功能查询出来的数据是以该笔游戏纪录的 游戏时间（gameDate）为准。
每次的博取游戏皆为一笔交易信息，当 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

参数

参数	格式	强制	说明
action	Integer	Y	64
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": 64,
  "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(200)	游戏序号参照附录 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(200)	游戏序号参照附录 historyId 说明
playerId	String(50)	玩家账号
gType	Integer	游戏类型参照附录游戏提供商
mtype	Integer	机台类型
gameDate	String(19)	游戏时间（dd-MM-yyyy HH:mm:ss）
roomType	Integer	游戏区域 -2：非房间制 -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(200)	游戏序号参照附录 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(200)	游戏序号参照附录 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(200)	游戏序号参照附录 historyId 说明
roundSeqNo	String(200)	游戏局号
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、SPINGO、SWG、MANCALA、YB、Onlyplay、CreedRoomz、SmartSoft、FunkyGames、Aviatrix、SWGS、CP、VP 下注记录：gType = SPRIBE(22), FC(30, 31, 32), SPINGO(50), SWG(55, 56, 70), MANCALA(57, 75), YB(58, 59, 60), Onlyplay(80, 81), CreedRoomz(101), SmartSoft(130, 131, 132), FunkyGames(140, 141, 142), Aviatrix(150), SWGS(160, 161, 162), CP(200, 201), VP(220)

参数	格式	说明
historyId	String(200)	游戏序号参照附录 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(200)	游戏序号参照附录 historyId 说明
roundSeqNo	String(200)	游戏局号
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-p0gedUPdQOUWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnpK0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzb
WKEddANjAAbxF0s=
 
// 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,
      "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": "test01",
      "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": "test01",
      "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": "test01",
      "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": "test01",
      "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": "58436132",
      "playerId": "test01",
      "gType": 22,
      "mtype": 22004,
      "gameDate": "07-12-2021 17:46:18",
      "bet": -50,
      "win": 60,
      "total": 10,
      "currency": "TB",
      "lastModifyTime": "07-12-2021 17:46:18",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.125"
    },
    {
       "historyId": "8643315",
       "playerId": "test01",
       "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": "984313",
       "playerId": "test01",
       "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": "asf135456b4gt",
      "playerId": "test01",
      "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": "iu4541gf6v",
      "playerId": "test01",
      "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": "y74u6854v1a",
      "playerId": "test01",
      "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": "8543321651",
      "playerId": "test01",
      "gType": 50,
      "mtype": 50001,
      "gameDate": "02-05-2023 15:33:41",
      "bet": -0.4,
      "win": 0.0,
      "total": -0.4,
      "currency": "RB",
      "lastModifyTime": "02-05-2023 15:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.025"
    },
    {
      "historyId": "uy4i654132x",
      "playerId": "test01",
      "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": "qwr1531fb",
      "playerId": "test01",
      "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": "erwt14651vd35",
      "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": "53818221",
        "playerId": "testpl01",
        "gType": 101,
        "mtype": 101001,
        "gameDate": "27-06-2024 18:15:24",
        "bet": -2.0,
        "win": 4.0,
        "total": 2.0,
        "currency": "RB",
        "lastModifyTime": "27-06-2024 18:15:24",
        "afterBalance": "100009.9993",
        "beforeBalance": "100007.9993"
    },
    {
      "historyId": "02b1446f-b6a6-4f1f-8859-ca78545228fd",
      "playerId": "test01",
      "gType": 130,
      "mtype": 130001,
      "gameDate": "18-11-2024 16:23:15",
      "bet": -5.0,
      "win": 0.0,
      "total": -5.0,
      "currency": "RB",
      "lastModifyTime": "18-11-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8472.425"
    },
    {
      "historyId": "02b1446f-b6a6-4f1f-8859-ca78545228fd",
      "playerId": "test01",
      "gType": 160,
      "mtype": 160001,
      "gameDate": "18-11-2024 16:23:15",
      "bet": -5.0,
      "win": 0.0,
      "total": -5.0,
      "currency": "RB",
      "lastModifyTime": "18-11-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8472.425"
    }
  ]
}
 
// Http Response (error)
{
  "status":"9005",
  "err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
 
// Http Response (no data)
{
  "status":"0000",
  "data":[]
}