3.6 Get Transactions By Update Time (依更新时间获得下注纪录)

Does not support non-accounting currencies
不支援不计入帐务的币别

Description (说明)

This function allows Operator to get Baccarat transactions by last update date.
此接口允许运营商按注單更新日期获取玩家下注记录。

Purpose (用途)

Get the latest player's settled bet history.
取得当前最新的玩家已结算下注纪录。

Restrict (限制)

1.A maximum of 2000 records are returned per API call.
2.Only supports query of records within two days (48 hours).
3.The request interval is limited to 3 seconds.

1.每次API调用最多返回2000条记录。
2.仅支持查询两天(48小时)内的纪录。
3.请求间隔时间限制为3秒。

How to use (如何使用)

lastUpdateDate Please fill in the update time of the bet you want to inquire, and we will send back a maximum of 2000 bets starting from the update time. The next time you make a query, use the updateTime in the latest one in these bets (according to updateTime), Fill in the lastUpdateDate to call the API, then you can get up to 2000 future bets. And so on to keep getting the latest bet.

lastUpdateDate 请填入欲查询的注单更新时间，我方将回传以该更新时间为起始后最多2000笔注单。
下次进行查询時，再将这些注单中最新的一笔(依updateTime)中的updateTime，
填入lastUpdateDate以进行调用API，则可再取得往后最多2000笔注单，
依此类推，以不断取得最新注单。

Notice (注意)

Be sure to refer to the billing process see 2.2 Get Transactions Flow
请务必参阅拉帐流程 詳見2.2 拉帐流程

URL (网址)

https://{host}/api/get_transactions_by_update_time

Request Method

POST

Request Parameters (请求参数)

Field (栏位)	Type (型态)	Required (必要)	Description (说明)
agentId	String	Y	Agent ID <= 50 characters 代理帐号
userId	String	N	User ID <= 50 characters 玩家帐号 Query all user transactions if user name is empty 如果用户名为空，则查询所有玩家
lastUpdateDate	String	Y	Update date fixed 28 characters 欲查询的注单更新时间 format 格式 yyyy-MM-dd'T'HH:mm:ss.SSSZ timezone 时区 GMT+8
gameType	String	N	Game Type <= 10 characters 游戏类型 Please refer to 5.1 Game for details. 详情请参考 5.1 游戏 v23.11.2.1 update
gameCode	String	N	Game Code <= 20 characters 游戏代码 Please refer to 5.1 Game for details. 详情请参考 5.1 游戏 v23.11.2.1 update
page	Number	N	Query page 查询页码 default: 1
pageSize	Number	N	Qurey result size (max: 2000) 指定一页带有多少笔资料 (上限: 2000) default: 2000

{
  "agentId": "hrgag",
  "lastUpdateDate": "2022-07-20T14:34:00.000+0800"
}

Return Result (返回结果)

Field (栏位)	Type (型态)	Description (说明)
code	String	Status Code fixed 4 characters 状态码 Please refer to 5.4 Status Code for details. 详情请参考 5.4 状态代码
data	Object
list	Array of Object	Each record
txId	String	Transaction ID <= 20 characters 注单号
gameType	String	Game Type <= 10 characters 游戏类型 Please refer to 5.1 Game for details. 详情请参考 5.1 游戏
gameCode	String	Game Code <= 20 characters 游戏代码 Please refer to 5.1 Game for details. 详情请参考 5.1 游戏
betAmount	Number	How much did user bet,equal to the sum of real credit, free credit and promotion credit decimal places <= 4 下注总额，相等于现金码与泥码及活动码下注额度的总和 If fee-type game, this field includes the fee amount. 若为手续费类型游戏，此栏位包含手续费金额 v24.7.3 update
realCredit	Number	How much did user bet with realCredit. decimal places <= 4 现金码下注额度 If fee-type game, this field includes the fee amount. 若为手续费类型游戏，此栏位包含手续费金额 v24.7.3 update
freeCredit	Number	How much did user bet with freeCredit. decimal places <= 4 泥码下注额度 if your company has not enabled the free credit function, then please ignore this attribute. 若贵司未开启泥码功能，则请忽略此属性 If fee-type game, this field includes the fee amount. 若为手续费类型游戏，此栏位包含手续费金额 v24.7.3 update
promotionCredit	Number	How much did user bet with promotionCredit. decimal places <= 4 活动码下注额度 if your company has not enabled the promotion credit function, then please ignore this attribute. 若贵司未开活动码功能，则请忽略此属性 If fee-type game, this field includes the fee amount. 若为手续费类型游戏，此栏位包含手续费金额 v24.7.3 update
updateTime	String	Update time when bet has changed fixed 28 characters 注单更新时间 format 格式 yyyy-MM-dd'T'HH:mm:ss.SSSZ timezone 时区 GMT+8
betTime	String	Place bet time fixed 28 characters 下注时间 format 格式 yyyy-MM-dd'T'HH:mm:ss.SSSZ timezone 时区 GMT+8
agentId	String	Agent ID <= 50 characters 代理帐号
userId	String	User ID <= 50 characters 玩家帐号
category	String	Bet type <= 20 characters 下注类型 Please refer to 5.5 Category for details. 详情请参考 5.5 下注类型
tableId	Number	Table ID 桌号
roundId	String	Round ID <= 20 characters 局编号
roundStartTime	String	Round start time fixed 28 characters 牌局开始时间 format 格式 yyyy-MM-dd'T'HH:mm:ss.SSSZ timezone 时区 GMT+8
result	Array of String	Card results 开牌结果 Please refer to 5.7 Card Result for details. 详情请参考 5.7 开牌结果
odds	Number	Odds decimal places <= 4 赔率
winLoss	Number	Amount of win/lose money decimal places <= 4 输赢金额(不含本金) win/loss equals to the sum of real credit、free credit and promotion credit win/loss 输赢金额，相等于现金码、泥码与活动码的输赢金额总和 If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
validBet	Number	Amount of valid bet decimal places <= 4 有效投注额 If there have mutiple orders in one round then the sum of validBet will be listed in the row which the txId is smallest, others will shown 0. 若一局中有多笔下注，则有效投注总额将列在 txId 最小的行中，其他行将显示 0。 If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
status	String	Transaction win/loss result <= 10 characters 注单输赢结果 Please refer to 5.6 Transaction Win/Loss Result for details. 详情请参考 5.6 注单输赢结果 v25.2.4.1 update
commission	Number	Rebate decimal places <= 4 现金回馈 if your company has not enabled the promotion credit function, then please ignore this attribute.if your company has not enabled the rebate function, then please ignore this attribute. 若贵司未开现金回馈功能，则请忽略此属性 If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
realCreditWinLoss	Number	Amount of real credit win/lose money decimal places <= 4 现金码输赢金额(不含本金) If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
freeCreditWinLoss	Number	Amount of free credit win/lose money decimal places <= 4 泥码输赢金额(不含本金) if your company has not enabled the free credit function, then please ignore this attribute. 若贵司未开启泥码功能，则请忽略此属性 If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
promotionCreditWinLoss	Number	Amount of promotion credit win/lose money decimal places <= 4 活动码输赢金额(不含本金) if your company has not enabled the promotion credit function, then please ignore this attribute. 若贵司未开活动码功能，则请忽略此属性 If fee-type game, the fee is included in the calculation. 若为手续费类型游戏，手续费并入计算 v24.7.3 update
pagination	Object	Pagination info 分页信息
page	Number	Current query page 当前页码
pageSize	Number	Qurey result size 指定一页几笔资料
totalSize	Number	Total result size 此次查询总共有几笔资料

{
  "code": "0000",
  "data": {
    "list": [
      {
        "txId": "AAA-212068227",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 100.0,
        "realCredit": 100.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-20T14:34:09.271+0800",
        "betTime": "2022-07-20T14:33:50.861+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00003",
        "category": "Player",
        "tableId": 1,
        "roundId": "RND-09770049",
        "roundStartTime": "2022-07-20T14:33:43.078+0800",
        "result": [
          "S04",
          "S04",
          "",
          "H08",
          "H10",
          ""
        ],
        "odds": 0.0,
        "winLoss": 0.0,
        "validBet": 0.0,
        "status": "TIE",
        "commission": 0.0,
        "realCreditWinLoss": 0.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      },
      {
        "txId": "AAA-212068228",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 100.0,
        "realCredit": 100.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-20T14:34:09.311+0800",
        "betTime": "2022-07-20T14:33:51.602+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00003",
        "category": "Banker",
        "tableId": 1,
        "roundId": "RND-09770049",
        "roundStartTime": "2022-07-20T14:33:43.078+0800",
        "result": [
          "S04",
          "S04",
          "",
          "H08",
          "H10",
          ""
        ],
        "odds": 0.0,
        "winLoss": 0.0,
        "validBet": 0.0,
        "status": "TIE",
        "commission": 0.0,
        "realCreditWinLoss": 0.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      },
      {
        "txId": "AAA-212068229",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 10.0,
        "realCredit": 10.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-20T14:34:49.738+0800",
        "betTime": "2022-07-20T14:34:36.928+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00004",
        "category": "Tie",
        "tableId": 1,
        "roundId": "RND-09770050",
        "roundStartTime": "2022-07-20T14:34:19.800+0800",
        "result": [
          "S10",
          "S09",
          "",
          "C13",
          "D12",
          ""
        ],
        "odds": -1.0,
        "winLoss": -10.0,
        "validBet": 10.0,
        "status": "LOSE",
        "commission": 0.0,
        "realCreditWinLoss": -10.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      },
      {
        "txId": "AAA-212068230",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 20.0,
        "realCredit": 20.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-20T14:34:49.782+0800",
        "betTime": "2022-07-20T14:34:37.347+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00004",
        "category": "Player",
        "tableId": 1,
        "roundId": "RND-09770050",
        "roundStartTime": "2022-07-20T14:34:19.800+0800",
        "result": [
          "S10",
          "S09",
          "",
          "C13",
          "D12",
          ""
        ],
        "odds": 1.0,
        "winLoss": 20.0,
        "validBet": 0.0,
        "status": "WIN",
        "commission": 0.0,
        "realCreditWinLoss": 20.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      },
      {
        "txId": "AAA-212068231",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 20.0,
        "realCredit": 20.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-20T14:34:49.852+0800",
        "betTime": "2022-07-20T14:34:37.885+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00004",
        "category": "Banker",
        "tableId": 1,
        "roundId": "RND-09770050",
        "roundStartTime": "2022-07-20T14:34:19.800+0800",
        "result": [
          "S10",
          "S09",
          "",
          "C13",
          "D12",
          ""
        ],
        "odds": -1.0,
        "winLoss": -20.0,
        "validBet": 0.0,
        "status": "LOSE",
        "commission": 0.0,
        "realCreditWinLoss": -20.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      }
    ],
    "pagination": {
      "page": 1,
      "pageSize": 5,
      "totalSize": 5
    }
  }
}

Sample Request For Each Language (各语言请求范例)

OkHttpClient client = new OkHttpClient().newBuilder()
  .build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}");
Request request = new Request.Builder()
  .url("https://{host}/api/get_transactions_by_update_time")
  .method("POST", body)
  .addHeader("Authorization", "Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1")
  .addHeader("Content-Type", "application/json")
  .build();
Response response = client.newCall(request).execute();

var client = new RestClient("https://{host}/api/get_transactions_by_update_time");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1");
request.AddHeader("Content-Type", "application/json");
var body = @"{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}";
request.AddParameter("application/json", body,  ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);

var myHeaders = new Headers();
myHeaders.append("Authorization", "Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1");
myHeaders.append("Content-Type", "application/json");

var raw = "{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}";

var requestOptions = {
  method: 'POST',
  headers: myHeaders,
  body: raw,
  redirect: 'follow'
};

fetch("https://{host}/api/get_transactions_by_update_time", requestOptions)
  .then(response => response.text())
  .then(result => console.log(result))
  .catch(error => console.log('error', error));

import http.client
import json

conn = http.client.HTTPSConnection("{host}")
payload = "{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}"
headers = {
  'Authorization': 'Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1',
  'Content-Type': 'application/json'
}
conn.request("POST", "https://{host}/api/get_transactions_by_update_time", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))

package main

import (
  "fmt"
  "strings"
  "net/http"
  "io/ioutil"
)

func main() {

  url := "https://{host}/api/get_transactions_by_update_time"
  method := "POST"

  payload := "{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}"

  client := &http.Client {
  }
  req, err := http.NewRequest(method, url, payload)

  if err != nil {
    fmt.Println(err)
    return
  }
  req.Header.Add("Authorization", "Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1")
  req.Header.Add("Content-Type", "application/json")

  res, err := client.Do(req)
  if err != nil {
    fmt.Println(err)
    return
  }
  defer res.Body.Close()

  body, err := ioutil.ReadAll(res.Body)
  if err != nil {
    fmt.Println(err)
    return
  }
  fmt.Println(string(body))
}

<?php
require_once 'HTTP/Request2.php';
$request = new HTTP_Request2();
$request->setUrl('https://{host}/api/get_transactions_by_update_time');
$request->setMethod(HTTP_Request2::METHOD_POST);
$request->setConfig(array(
  'follow_redirects' => TRUE
));
$request->setHeader(array(
  'Authorization' => 'Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1',
  'Content-Type' => 'application/json'
));
$request->setBody("{\"agentId\":\"hrgag\",\"lastUpdateDate\":\"2022-07-20T14:34:00.000+0800\"}");
try {
  $response = $request->send();
  if ($response->getStatus() == 200) {
    echo $response->getBody();
  }
  else {
    echo 'Unexpected HTTP status: ' . $response->getStatus() . ' ' .
    $response->getReasonPhrase();
  }
}
catch(HTTP_Request2_Exception $e) {
  echo 'Error: ' . $e->getMessage();
}