3.7 Get Transactions By Update Time Interval (依更新时间區間获得下注纪录)

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

Description (说明)

This function is used when something wrong with transaction records sync process. Operator may specify start date and end date to get transaction data during this period.
运营商可以指定开始日期和结束日期以获取此期间的下注紀錄。

Purpose (用途)

When there are omissions in 3.6 Get Transactions By Update Time, you can use this function to make up the betting record.
当 3.6 依更新时间获得下注纪录有遗漏时，可使用此功能将下注纪录补齐。

Restrict (限制)

1.Returns up to 20000 records per API call.
2.Only supports query records within 40 days.
3.The time interval for each query shall not exceed 30 minutes.
4.The request interval is limited to 3 seconds.

1.每次API调用最多返回20000条记录。
2.仅支持查询40天内的纪录。
3.每次查询时间区间不得超过30分钟。
4.请求间隔时间限制为3秒。

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_interval

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 如果用户名为空，则查询所有玩家
startTime	String	Y	Start time fixed 28 characters 欲查询注单的起始时间(注单更新时间) format 格式 yyyy-MM-dd'T'HH:mm:ss.SSSZ timezone 时区 GMT+8
endTime	String	Y	End time 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

{
  "agentId": "hrgag",
  "startTime": "2022-07-03T00:00:00.000+0800",
  "endTime": "2022-07-04T00:00: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

{
  "code": "0000",
  "data": {
    "list": [
      {
        "txId": "AAA-212048043",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 10.0,
        "realCredit": 10.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-04T14:07:53.914+0800",
        "betTime": "2022-07-03T22:07:51.864+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00001",
        "category": "Player",
        "tableId": 1,
        "roundId": "RND-08310057",
        "roundStartTime": "2022-07-03T22:07:43.217+0800",
        "result": [
          "H03",
          "C01",
          "C01",
          "C05",
          "S05",
          "C06"
        ],
        "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-212048045",
        "gameType": "LIVE",
        "gameCode": "BACCARAT",
        "betAmount": 100.0,
        "realCredit": 100.0,
        "freeCredit": 0.0,
        "promotionCredit": 0.0,
        "updateTime": "2022-07-04T14:07:54.302+0800",
        "betTime": "2022-07-03T22:07:53.092+0800",
        "agentId": "hrgag",
        "userId": "hrgpl00001",
        "category": "Banker",
        "tableId": 1,
        "roundId": "RND-08310057",
        "roundStartTime": "2022-07-03T22:07:43.217+0800",
        "result": [
          "H03",
          "C01",
          "C01",
          "C05",
          "S05",
          "C06"
        ],
        "odds": 0.95,
        "winLoss": 95.0,
        "validBet": 5.0,
        "status": "WIN",
        "commission": 0.0,
        "realCreditWinLoss": 95.0,
        "freeCreditWinLoss": 0.0,
        "promotionCreditWinLoss": 0.0
      }
    ]
  }
}

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

OkHttpClient client = new OkHttpClient().newBuilder()
  .build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\"agentId\":\"hrgag\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00:00.000+0800\"}");
Request request = new Request.Builder()
  .url("https://{host}/api/get_transactions_by_update_time_interval")
  .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_interval");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1");
request.AddHeader("Content-Type", "application/json");
var body = @"{\"agentId\":\"hrgag\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00: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\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00:00.000+0800\"}";

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

fetch("https://{host}/api/get_transactions_by_update_time_interval", 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\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00:00.000+0800\"}"
headers = {
  'Authorization': 'Basic TWpNQ0JSM1NFYnBrYXdSNTpNak1DQlIzU0VicGthd1I1',
  'Content-Type': 'application/json'
}
conn.request("POST", "https://{host}/api/get_transactions_by_update_time_interval", 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_interval"
  method := "POST"

  payload := "{\"agentId\":\"hrgag\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00: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_interval');
$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\",\"startTime\":\"2022-07-03T00:00:00.000+0800\",\"endTime\":\"2022-07-04T00:00: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();
}

# 3.7 Get Transactions By Update Time Interval (依更新时间區間获得下注纪录)

# Description (说明)

# Purpose (用途)

# Restrict (限制)

# Notice (注意)

# URL (网址)

# Request Method

# Request Parameters (请求参数)

# Return Result (返回结果)

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