Seamless
JDB 平台 API
功能项目
报表相关
Action 29：查询游戏详细交易信息

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 压缩取回数据

参数

参数格式强制说明
actionIntegerY29
tsLongY当前系统时间
parentString(50)Y代理账号
starttimeString(19)Y查询区段起始时间（dd-MM-yyyy HH:mm:ss）
endtimeString(19)Y查询区段结束时间（dd-MM-yyyy HH:mm:ss）
gTypesInteger ArrayN游戏类型
参照附录 游戏提供商

Example

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

返回结果

参数格式说明
statusString(4)成功：0000

错误：参照附录 错误代码
查无资料：0000
dataJSON Array回传的数据组将依据 gType 有不同内容，分别列于下列表中
err_textString(255)错误讯息

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


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble老虎机押注金额
winDouble游戏赢分
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

jackpotDouble赢得彩金金额
jackpotContributeDouble彩金贡献值
denomDouble投注面值
lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIpString(50)玩家登入 IP
clientTypeString(20)玩家从网页或行动装置登入
hasFreegameInteger免费游戏
0：否
1：是
systemTakeWinInteger标记该笔为游戏中断线，由系统结算
0：否
1：是
beforeBalanceString(20)进场金额
afterBalanceString(20)离场金额
transferIdLong交易序号

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


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
roomTypeInteger游戏区域
-1：大厅（成就游戏）
0：小压码区
1：中压码区
2：大压码区
各压码区称号会依据机台类型有所不同
currencyString(10)货币别

参照附录 货币代码

betDouble押注金额
winDouble游戏赢分
totalDouble总输赢
denomDouble投注面值
beforeBalanceDouble进场金额
afterBalanceDouble离场金额
lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIpString(50)玩家登入 IP
clientTypeString(20)玩家从网页或行动装置登入
transferIdLong交易序号
如果鱼机单钱包扣款方式为充值，交易序号会和 action 14 的 transferId 相同

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


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble押注金额
gambleBetDouble博取游戏押注金额
winDouble游戏赢分
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

denomDouble投注面值
lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIpString(50)玩家登入 IP
clientTypeString(20)玩家从网页或行动装置登入
hasBonusGameInteger奖金游戏
0：否
1：是
hasGambleInteger博取游戏
0：否
1：是
beforeBalanceString(20)进场金额
afterBalanceString(20)离场金额
transferIdLong交易序号

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


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble押注金额
winDouble游戏赢分
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

denomDouble投注面值
lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIpString(50)玩家登入 IP
clientTypeString(20)玩家从网页或行动装置登入
hasBonusGameInteger奖金游戏
0：否
1：是
beforeBalanceString(20)进场金额
afterBalanceString(20)离场金额
transferIdLong交易序号

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


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

roundSeqNoLong游戏局号
playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble押注金额
winDouble游戏赢分
taxDouble税
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
playerIpString(50)玩家登入 IP
clientTypeString(20)玩家从网页或行动装置登入
validBetDouble有效押注金额
beforeBalanceString(20)进场金额
afterBalanceString(20)离场金额
transferIdLong交易序号

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)


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble押注金额
winDouble游戏赢分
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
beforeBalanceString(20)进场金额
afterBalanceString(20)离场金额
transferIdLong交易序号

HRG 下注记录：gType = 41


参数格式说明
historyIdString(100)游戏序号

参照附录 historyId 说明

roundSeqNoString(30)游戏局号
playerIdString(50)玩家账号
gTypeInteger游戏类型

参照附录 游戏提供商

mtypeInteger机台类型
gameDateString(19)游戏时间（dd-MM-yyyy HH:mm:ss）
betDouble押注金额
winDouble游戏赢分
validBetDouble有效押注金额
commissionDouble回馈金
totalDouble总输赢
currencyString(10)货币别

参照附录 货币代码

lastModifyTimeString(19)最后修改时间（dd-MM-yyyy HH:mm:ss）
beforeBalanceString(20)进场金额
afterBalanceString(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,
      "transferId":100001,
      "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,
      "transferId":100002,
      "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",
      "transferId":100003
    },
    {
      "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,
      "transferId":100004,
      "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,
      "transferId":100005,
      "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,
      "transferId":100006,
      "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,
      "transferId":100007,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.395"
    },
    {
      "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,
      "transferId":100008,
      "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",
      "transferId":100009,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.205"
    },
    {
      "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,
      "transferId":100010,
      "beforeBalance": "8477.425",
      "afterBalance": "8483.125"
    },
    {
      "historyId":"5250189212426",
      "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",
      "transferId":100011
    },
    {
       "historyId":"a45621c58wd",
       "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",
       "transferId":100012
    },
    {
       "historyId":"we1451fa3s1d",
       "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",
       "transferId":100013
    },
    {
       "historyId":"yc1451fa3s1d",
       "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",
       "transferId":100014
    },
    {
      "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",
      "transferId":100015
    },
    {
      "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",
      "transferId":100016
    },
    {
      "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",
      "transferId":100017
    },
    {
       "historyId": "AAA-212256709",
       "roundSeqNo": "RND-0020107870010",
       "playerId": "test01",
       "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": "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",
      "transferId":100018
    },
    {
      "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",
      "transferId":100019
    },
    {
      "historyId":"57762",
      "playerId": "smartsofttest01",
      "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": "8404.425",
      "afterBalance": "8400.225",
      "transferId":100020
    }
  ]
}
 
// Http Response (error)
{
  "status":"9005",
    "err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
 
// Http Response (no data)
{
  "status":"0000",
    "data":[]
}
Action 67：修改游戏商 HRG 投注设定Action 42：每日对帐报表