Action 44: Search for details of transactions (By House)
Function Description
- Search for a single house ID’s details of settled transaction for all game in a given time range. (search by lastModifyTime)
- We query transactions of specified game types if request contains
gTypes
.
- We query transactions of specified game types if request contains
- The values of ss(seconds) in start time and end time must be 00.
- The maximum time range for each search is 1 minute, and the display time of the latest information is 3 minutes from request time.
- For example, if you search at 15:00:00, the latest information available is between 14:56:00 and 14:57:00.
- The function searches for the data according to the last modified time of the game record. Therefore, if the number of transactions found and transaction data on the win/loss statement are not matching, that is because the record has not cleared yet in the time range you searched.
- Provide game history transaction information within 2 hours. For transaction information older than 2 hours, please use “Action64”.
- Each gambling game is considered as a transaction. When “hasGamble” is 1, it means that this is a transaction in gambling games. Only JDB Bar(gType=9) games have gambling game.
- Example:
- If a player bets 10 and wins 100 points in the game
bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0 - Same as above, if a player uses winning points to play gambling games and wins
bet = 0, gambleBet = -100, win = 200, total = 100, hasGamble = 1
- If a player bets 10 and wins 100 points in the game
- Example:
Parameter
Parameter | Format | Mandatory | Description |
---|---|---|---|
action | Integer | Y | 44 |
ts | Long | Y | Current system time |
parent | String(50) | Y | House ID |
starttime | String(19) | Y | Start time of the searching range (dd-MM-yyyy HH:mm:ss) |
endtime | String(19) | Y | End time of the searching range (dd-MM-yyyy HH:mm:ss) |
gTypes | Integer Array | N | Game types See Game Provider |
Example
{
"action": 44,
"ts": 1447452951820,
"parent": "testhse",
"starttime": "08-12-2016 17:45:00",
"endtime": "08-12-2016 17:46:00",
"gTypes": [0,7]
}
Return Results
Parameter | Format | Description |
---|---|---|
status | String(4) | Success: 0000 <br/ ><br/ > Error: See Error Codes in Appendix No Data: 0000 |
data | JSON Object | The returned data will take Agent ID from next row as key. Each Agent ID has an array of data as value. |
parent | JSON Array | Agent ID <br/ >The returned data will vary by gType, listed in the following tables. |
err_text | String(255) | Error message |
Betting records in slot games: gType = 0, 66, 90
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
jackpot | Double | The amount of the jackpot won |
jackpotContribute | Double | Jackpot contributions |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device. |
hasFreegame | Integer | Free game 0: No 1: Yes |
systemTakeWin | Integer | Mark this as the interruption if the game and it will be settled by the system. 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in fishing game: gType = 7, 67, 91
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
roomType | Integer | Game Room -1: Lobby (Achievement Game) 0: Small Bet 1: Medium sized bet 2: Large bet Real naming of game room differentiated by Machine Type |
currency | String(10) | Currency types See Currency Code |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
denom | Double | Bet denomination |
beforeBalance | Double | Balance before playing |
afterBalance | Double | Balance after playing |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
transferId | Long | Transfer IDIf the fish game pay mode is PrepayBalance, the transaction number will be the same as the transferId of action 14 |
Betting records in Arcade games: gType = 9, 92
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
gambleBet | Double | Bet amount in Gambling games |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
hasBonusGame | Integer | Bonus game 0: No 1: Yes |
hasGamble | Integer | Gambling Game 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in Lottery Game: gType = 12
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
hasBonusGame | Integer | Bonus game 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in Card Games: gType = 18, 93
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
roundSeqNo | Long | Game round sequence number |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
tax | Double | Player pay winning tax in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
validBet | Double | Valid Bet Amount |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in SPRIBE, FC, AMB, SWG, MANCALA, YB, Onlyplay, CreedRoomz, ZestPlay, SmartSoft: gType = SPRIBE(22), FC(30, 31, 32), AMB(50), SWG(55, 56, 70), MANCALA(57, 75), YB(58, 59, 60), Onlyplay(80, 81), CreedRoomz(101), ZestPlay(120), SmartSoft(130, 131, 132)
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in HRG: gType = 41
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
roundSeqNo | String(30) | Game round sequence number |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
validBet | Double | Valid Bet Amount |
commission | Double | Rebate |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
Operation Sample
// Http Request
http://{API_Address}/apiRequest.do?dc=jb&x=udbFVt_xv0tsAmLDpz5Z3Ct4-p0gedUPdQOUWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnpK0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzbWKEddANjAAbxF0s=
// Http Response (success)
{
"status":"0000",
"data":
{
"testag0": [],
"testag1": [
{
"historyId":"5250568864735",
"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,
"transferId":100001,
"beforeBalance": "8477.975",
"afterBalance": "8477.925"
},
{
"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,
"transferId":100002,
"beforeBalance": "8477.975",
"afterBalance": "8477.973"
}
],
"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",
"transferId":100003
},
{
"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,
"transferId":100004,
"beforeBalance": "8477.975",
"afterBalance": "8476.975"
},
{
"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":100005,
"beforeBalance": "8472.275",
"afterBalance": "8477.975"
},
{
"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",
"playerIp": "1.2.3.4",
"clientType": "desktop",
"roundSeqNo":"1159054520",
"beforeBalance": "8477.425",
"afterBalance": "8477.125",
"transferId":100006
},
{
"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": "8472.675",
"afterBalance": "8472.275",
"transferId":100007
},
{
"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": "8472.675",
"afterBalance": "8376.275",
"transferId":100008
},
{
"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": "8472.675",
"afterBalance": "8472.175",
"transferId":100009
},
{
"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": "8472.675",
"afterBalance": "8471.475",
"transferId":100010
},
{
"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": "8472.675",
"afterBalance": "8471.475",
"transferId":100011
},
{
"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": "8472.675",
"afterBalance": "8471.475",
"transferId":100012
},
{
"historyId": "AAA-212256709",
"gameRoundSeqNo": "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": "8972.675",
"afterBalance": "8472.675"
},
{
"historyId":"57762",
"playerId": "ybtest01",
"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":100013
},
{
"historyId":"fc4647bd-8fff-4858-9904-94a5bbefc77c",
"playerId": "smartsoft01",
"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",
"transferId":100014
}
]
}
}
// Http Response (error)
{
"status": "9005",
"err_text":"Assertion(SAML) didn't pass the timestamp validation."
}