public function getPaymentHistory()
{
$paymentHistory = array();
$urls = array();
$urls[] = new \Oara\Curl\Request('http://affiliates.affiliatefuture.com/myaccount/invoices.aspx', array());
$exportReport = $this->_client->get($urls);
$doc = new \DOMDocument();
@$doc->loadHTML($exportReport[0]);
$xpath = new \DOMXPath($doc);
$tableList = $xpath->query('//table');
$registerTable = $tableList->item(12);
if ($registerTable == null) {
throw new \Exception('Fail getting the payment History');
}
$registerLines = $registerTable->childNodes;
for ($i = 1; $i < $registerLines->length; $i++) {
$registerLine = $registerLines->item($i)->childNodes;
$obj = array();
$date = \DateTime::createFromFormat("d/m/Y", trim($registerLine->item(1)->nodeValue));
$date->setTime(0, 0);
$obj['date'] = $date->format("Y-m-d H:i:s");
$obj['pid'] = trim($registerLine->item(0)->nodeValue);
$value = trim(substr(trim($registerLine->item(4)->nodeValue), 4));
$obj['value'] = \Oara\Utilities::parseDouble($value);
$obj['method'] = 'BACS';
$paymentHistory[] = $obj;
}
return $paymentHistory;
}