public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null)
{
$totalTransactions = array();
$valuesFromExport = array();
$valuesFromExport[] = new \Oara\Curl\Parameter('FromDate', $dStartDate->format("d/m/Y"));
$valuesFromExport[] = new \Oara\Curl\Parameter('ToDate', $dEndDate->format("d/m/Y"));
$valuesFromExport[] = new \Oara\Curl\Parameter('ReportType', 'dailyReport');
$valuesFromExport[] = new \Oara\Curl\Parameter('Link', '-1');
$urls = array();
$urls[] = new \Oara\Curl\Request('https://www.bet365affiliates.com/Members/Members/Statistics/Print.aspx?', $valuesFromExport);
$exportReport = $this->_client->get($urls);
$doc = new \DOMDocument();
@$doc->loadHTML($exportReport[0]);
$xpath = new \DOMXPath($doc);
$tableList = $xpath->query('//*[contains(concat(" ", normalize-space(@id), " "), " Results ")]');
if (!\preg_match("/No results exist/", $exportReport[0])) {
$exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->current()));
$num = \count($exportData);
for ($i = 2; $i < $num - 1; $i++) {
$transactionExportArray = \str_getcsv($exportData[$i], ";");
$transaction = array();
$transaction['merchantId'] = 1;
$transactionDate = \DateTime::createFromFormat("d-m-Y", $transactionExportArray[1]);
$transaction['date'] = $transactionDate->format("Y-m-d 00:00:00");
$transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED;
$transaction['amount'] = \Oara\Utilities::parseDouble($transactionExportArray[27]);
$transaction['commission'] = \Oara\Utilities::parseDouble($transactionExportArray[32]);
if ($transaction['amount'] != 0 && $transaction['commission'] != 0) {
$totalTransactions[] = $transaction;
}
}
}
return $totalTransactions;
}