Action 44：查询游戏详细交易信息（依董事层级）

功能说明

查询单一董事（House）在特定时间区段内，全游戏类型已结案详细交易信息（依 lastModifyTime 查询）
- 若参数包含 gTypes，则查询指定的游戏类型交易信息。
开始时间与结束时间中，ss（秒数）的值必须为 00
每次查询时间范围最多为 1 分钟，最新信息为 3 分钟前。
例如，在 15:00:00 时的查询，最晚只能查到 14:56:00~14:57:00 的信息。
此功能查询出来的数据是以该笔游戏纪录的最后修改时间为准，因此若查询出来的笔数与输赢报表的全部交易资料不合，则是因为该笔纪录于查询之时间区间内并未结算。
提供 2 小时内的交易信息，超过 2 小时的交易信息请至 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

参数

参数	格式	强制	说明
action	Integer	Y	44
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": 44,
  "ts": 1447452951820,
  "parent": "testhse",
  "starttime": "08-12-2016 17:45:00",
  "endtime": "08-12-2016 17:46:00",
  "gTypes": [0,7]
}

返回结果

参数	格式	说明
status	String(4)	成功：0000 错误：参照附录错误代码
data	JSON Object	`回传的数据将依据下一列的代理账号作为键，每个代理账号对应一个数组`
parent	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)	离场金额

集成游戏下注记录

集成游戏包含以下游戏商，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-p0gedUPdQO-UWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnp-K0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzbWKEddANjAAbxF0s=
 
// Http Response (success)
{
  "status":"0000",
  "data":
  {
    "testag0": [],
    "testag1": [
      {
        "historyId":"5250145823902",
        "playerId":"testpl01",
        "gType":0,
        "mtype":8018,
        "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.475"
      },
      {
        "historyId":"5250568864736",
        "playerId":"testpl01",
        "gType":12,
        "mtype":12001,
        "gameDate":"03-05-2019 16:34:50",
        "bet":-0.008,"win":0.006,
        "total":-0.002,
        "currency":"TB",
        "denom":0.001,
        "lastModifyTime":"03-05-2019 16:34:50",
        "playerIp":"10.20.9.250",
        "clientType":"WEB",
        "hasBonusGame":0,
        "beforeBalance": "8477.425",
        "afterBalance": "8477.423"
      }
    ],
    "testag2": [
      {
        "historyId":"5250568864731",
        "playerId":"testpl01",
        "gameDate":"03-05-2019 16:32:42",
        "gType":7,
        "mtype":7003,
        "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"
      },
      {
        "historyId":"5250568864743",
        "playerId":"testpl02",
        "gType":9,
        "mtype":9001,
        "gameDate":"03-05-2019 16:36:36",
        "bet":-1,
        "gambleBet":0,
        "win":0,
        "total":-1,
        "currency":"TB",
        "denom":0.1,
        "lastModifyTime":"03-05-2019 16:36:36",
        "playerIp":"10.20.9.250",
        "clientType":"WEB",
        "hasBonusGame":0,
        "hasGamble":0,
        "beforeBalance": "8477.425",
        "afterBalance": "8476.425"
      },
      {
        "historyId":"5250568864737",
        "roundSeqNo":382342469,
        "playerId":"testpl02",
        "gType":18,
        "mtype":18013,
        "gameDate":"03-05-2019 16:35:12",
        "bet":-12,
        "win":-12,
        "tax":0,
        "total":-12,
        "currency":"TB",
        "lastModifyTime":"03-05-2019 16:35:17",
        "playerIp":"10.20.9.250",
        "clientType":"WEB",
        "validBet":-12,
        "beforeBalance": "8477.425",
        "afterBalance": "8465.425"
      },
      {
        "historyId":"4546123413",
        "playerId": "test01",
        "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":"9423154",
        "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":"58415186",
        "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":"aw48543gf1d3",
       "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":"wre255cg1415a",
       "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": "8573.425"
      },
      {
       "historyId":"ty54156as1dc",
       "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.925",
       "afterBalance": "8477.425"
      },
      {
       "historyId":"5955416313",
       "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": "8473.425"
      },
      {
       "historyId":"wr1541cv1",
       "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": "8478.225",
       "afterBalance": "8477.425"
      },
      {
       "historyId":"g4b541bf6541sf",
       "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":"4y5tr6h3h",
       "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.925",
        "afterBalance": "8477.425"
      },
      {
        "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"
      },
      {
        "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": "8977.925",
        "afterBalance": "8477.925"
      },
      {
        "historyId": "1277926490033",
        "playerId": "test01",
        "gType": 101,
        "mtype": 101001,
        "gameDate": "28-06-2024 09:57:06",
        "bet": -20.0,
        "win": 40.0,
        "total": 20.0,
        "currency": "RB",
        "lastModifyTime": "28-06-2024 09:57:06",
        "afterBalance": "99517.94",
        "beforeBalance": "99497.94"
      },
      {
       "historyId":"ea819fbb-8fbc-455e-bc27-be87cc2952db",
       "playerId": "smartsoft01",
       "gType": 130,
       "mtype": 130001,
       "gameDate": "18-11-2024 16:23:15",
       "bet": -10.0,
       "win": 4.8,
       "total": -4.2,
       "currency": "RB",
       "lastModifyTime": "18-11-2024 16:23:15",
       "beforeBalance": "8474.425",
       "afterBalance": "8470.025"
      },
      {
       "historyId":"ea819fbb-8fbc-455e-bc27-be87cc2952db",
       "playerId": "swgs01",
       "gType": 160,
       "mtype": 160001,
       "gameDate": "18-11-2024 16:23:15",
       "bet": -10.0,
       "win": 4.8,
       "total": -4.2,
       "currency": "RB",
       "lastModifyTime": "18-11-2024 16:23:15",
       "beforeBalance": "8474.425",
       "afterBalance": "8470.025"
      }
    ]
  }
}
 
// Http Response (error)
{
  "status": "9005",
  "err_text":"Assertion(SAML) didn't pass the timestamp validation."
}