public static DOMinnerHTML ( $element ) : string | ||
$element | ||
Résultat | string |
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $urls = array(); $urls[] = new \Oara\Curl\Request('https://www.sportscoverdirect.com/promoters/earn', array()); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//*[contains(concat(" ", normalize-space(@class), " "), " performance ")]'); if (\count($results) > 0) { $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($results->item(0))); $num = \count($exportData) - 1; //the last row is show-more show-less for ($i = 1; $i < $num; $i++) { $overviewExportArray = \str_getcsv($exportData[$i], ";"); $transaction = array(); $transaction['merchantId'] = 1; $date = \DateTime::createFromFormat("d/m/Y", $overviewExportArray[0]); $transaction['date'] = $date->format("Y-m-d H:i:s"); $transaction['amount'] = \Oara\Utilities::parseDouble($overviewExportArray[1]); $transaction['commission'] = \Oara\Utilities::parseDouble($overviewExportArray[1]); $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; $totalTransactions[] = $transaction; } } return $totalTransactions; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array * @throws Exception */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $urls = array(); $url = "https://foxtransfer.eu/index.php?q=prices.en.html&page=affiliate_orders&language=1&basedir=theme2&what=record_time&what=record_time&fy={$dStartDate->format("Y")}&fm={$dStartDate->format("n")}&fd={$dStartDate->format("j")}&ty={$dEndDate->format("Y")}&tm={$dEndDate->format("n")}&td={$dEndDate->format("j")}"; $urls[] = new \Oara\Curl\Request($url, array()); $exportReport = $this->_client->get($urls); $exportReport = \str_replace("<?xml version=\"1.0\" encoding=\"UTF-8\"?>", "", $exportReport[0]); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport); $xpath = new \DOMXPath($doc); $tableList = $xpath->query('//*[contains(concat(" ", normalize-space(@id), " "), " tartalom-hatter ")]'); $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->item(0))); $num = \count($exportData); for ($i = 11; $i < $num - 8; $i++) { $transactionExportArray = \str_getcsv($exportData[$i], ";"); $transaction = array(); $transaction['merchantId'] = 1; $transaction['unique_id'] = $transactionExportArray[0]; $transaction['date'] = "{$dStartDate->format("Y")}-{$dStartDate->format("m")}-01 00:00:00"; if ($transactionExportArray[7] == "Confirmed") { $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; } else { if ($transactionExportArray[7] == "Cancelled") { $transaction['status'] = \Oara\Utilities::STATUS_DECLINED; } else { throw new \Exception("New status found {$transaction['status']}"); } } $transaction['amount'] = \Oara\Utilities::parseDouble($transactionExportArray[10]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionExportArray[13]); $totalTransactions[] = $transaction; } return $totalTransactions; }
/** * @return array */ public function getPaymentHistory() { $paymentHistory = array(); $urls = array(); $urls[] = new \Oara\Curl\Request("{$this->_extension}/affiliate_invoice.html?", array()); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $tableList = $xpath->query('//table[@class="bluetable"]'); $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->item(0))); $num = \count($exportData); for ($i = 4; $i < $num; $i++) { $paymentExportArray = \str_getcsv($exportData[$i], ";"); if (\count($paymentExportArray) > 7) { $obj = array(); $date = \DateTime::createFromFormat("d/m/Y", $paymentExportArray[1]); $obj['date'] = $date->format("Y-m-d H:i:s"); $obj['pid'] = \preg_replace('/[^0-9]/', "", $paymentExportArray[0]); $obj['method'] = 'BACS'; $obj['value'] = \Oara\Utilities::parseDouble($paymentExportArray[4]); $paymentHistory[] = $obj; } } return $paymentHistory; }
/** * @return array */ public function getPaymentHistory() { $paymentHistory = array(); $urls = array(); $urls[] = new \Oara\Curl\Request('http://affiliates.mypcbackup.com/paychecks', array()); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $tableList = $xpath->query('//*[contains(concat(" ", normalize-space(@class), " "), " transtable ")]'); if ($tableList->item(0) != null) { $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->item(0))); $num = \count($exportData); for ($i = 1; $i < $num; $i++) { $paymentExportArray = \str_getcsv($exportData[$i], ";"); try { $obj = array(); $date = \DateTime::createFromFormat("m/d/Y", $paymentExportArray[14]); $date->setTime(0, 0); $obj['date'] = $date->format("Y-m-d H:i:s"); $obj['pid'] = \preg_replace('/[^0-9\\.,]/', "", $paymentExportArray[14]); $obj['method'] = $paymentExportArray[16]; $obj['value'] = \Oara\Utilities::parseDouble($paymentExportArray[12]); $paymentHistory[] = $obj; } catch (\Exception $e) { echo "Payment failed\n"; } } } return $paymentHistory; }
/** * @param $paymentId * @return array * @throws \Exception */ public function paymentTransactions($paymentId) { $transactionList = array(); $urls = array(); $valuesFormExport = array(); $valuesFormExport[] = new \Oara\Curl\Parameter('popup', 'true'); $valuesFormExport[] = new \Oara\Curl\Parameter('payment_id', $paymentId); $urls[] = new \Oara\Curl\Request('http://publisher.tradedoubler.com/pan/reports/Payment.html?', $valuesFormExport); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML(\Oara\Utilities::DOMinnerHTML($exportReport[0])); $xpath = new \DOMXPath($doc); $results = $xpath->query('//a'); $urls = array(); foreach ($results as $result) { $url = $result->getAttribute('href'); $urls[] = new \Oara\Curl\Request("http://publisher.tradedoubler.com" . $url . "&format=CSV", array()); } $exportReportList = $this->_client->get($urls); foreach ($exportReportList as $exportReport) { $exportReportData = \str_getcsv($exportReport, "\r\n"); $num = \count($exportReportData); for ($i = 2; $i < $num - 1; $i++) { $transactionArray = \str_getcsv($exportReportData[$i], ";"); if ($transactionArray[8] != '') { $transactionList[] = $transactionArray[8]; } else { if ($transactionArray[7] != '') { $transactionList[] = $transactionArray[7]; } else { throw new \Exception("No Identifier"); } } } } return $transactionList; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ 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; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $page = 1; $continue = true; while ($continue) { $valuesFormExport = array(); $valuesFormExport[] = new \Oara\Curl\Parameter('dateFrom', $dStartDate->format("d/m/Y")); $valuesFormExport[] = new \Oara\Curl\Parameter('dateTo', $dEndDate->format("d/m/Y")); $valuesFormExport[] = new \Oara\Curl\Parameter('startIndex', $page); $valuesFormExport[] = new \Oara\Curl\Parameter('numberOfPages', '1'); $urls = array(); $urls[] = new \Oara\Curl\Request('https://etrader.kalahari.com/view/affiliate/transactionreport', $valuesFormExport); $exportReport = $this->_client->post($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//table'); $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($results->item(0))); if (\preg_match("/No results found/", $exportData[1])) { break; } else { $page++; } for ($j = 1; $j < \count($exportData); $j++) { $transactionDetail = \str_getcsv($exportData[$j], ";"); $transaction = array(); $transaction['merchantId'] = "1"; if (\preg_match("/Order dispatched: ([0-9]+) /", $transactionDetail[2], $match)) { $transaction['custom_id'] = $match[1]; } $date = \DateTime::createFromFormat("d M Y", $transactionDetail[0]); $transaction['date'] = $date->format("Y-m-d 00:00:00"); $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; if ($transactionDetail[3] != null) { $transaction['amount'] = \Oara\Utilities::parseDouble($transactionDetail[3]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionDetail[3]); } else { if ($transactionDetail[4] != null) { $transaction['amount'] = \Oara\Utilities::parseDouble($transactionDetail[4]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionDetail[4]); } } $totalTransactions[] = $transaction; } } return $totalTransactions; }
/** * @param $html * @return array */ private function htmlToCsv($html) { $html = str_replace(array("\t", "\r", "\n"), "", $html); $csv = ""; $doc = new \DOMDocument(); @$doc->loadHTML($html); $xpath = new \DOMXPath($doc); $results = $xpath->query('//tr'); foreach ($results as $result) { $doc = new \DOMDocument(); @$doc->loadHTML(\Oara\Utilities::DOMinnerHTML($result)); $xpath = new \DOMXPath($doc); $resultsTd = $xpath->query('//td'); $countTd = $resultsTd->length; $i = 0; foreach ($resultsTd as $resultTd) { $value = $resultTd->nodeValue; $doc = new \DOMDocument(); @$doc->loadHTML(\Oara\Utilities::DOMinnerHTML($resultTd)); $xpath = new \DOMXPath($doc); $resultsA = $xpath->query('//a'); foreach ($resultsA as $resultA) { $value = $resultA->getAttribute("href"); } if ($i != $countTd - 1) { $csv .= \trim($value) . ";"; } else { $csv .= \trim($value); } $i++; } $csv .= "\n"; } $exportData = \str_getcsv($csv, "\n"); return $exportData; }
/** * @return bool */ public function checkConnection() { $connection = false; $urls = array(); $urls[] = new \Oara\Curl\Request('http://cli.linksynergy.com/cli/publisher/home.php?', array()); $result = $this->_client->get($urls); // Check if the credentials are right if (\preg_match('/https:\\/\\/cli\\.linksynergy\\.com\\/cli\\/common\\/logout\\.php/', $result[0], $matches)) { $urls = array(); $urls[] = new \Oara\Curl\Request('https://cli.linksynergy.com/cli/publisher/my_account/marketingChannels.php', array()); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//table'); foreach ($results as $table) { $tableCsv = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($table)); } $resultsSites = array(); $num = \count($tableCsv); for ($i = 1; $i < $num; $i++) { $siteArray = \str_getcsv($tableCsv[$i], ";"); if (isset($siteArray[2]) && \is_numeric($siteArray[2])) { $result = array(); $result["id"] = $siteArray[2]; $result["name"] = $siteArray[1]; $result["url"] = "https://cli.linksynergy.com/cli/publisher/common/changeCurrentChannel.php?sid=" . $result["id"]; $resultsSites[] = $result; } } $siteList = array(); foreach ($resultsSites as $resultSite) { $site = new \stdClass(); $site->website = $resultSite["name"]; $site->url = $resultSite["url"]; $parsedUrl = \parse_url($site->url); $attributesArray = \explode('&', $parsedUrl['query']); $attributeMap = array(); foreach ($attributesArray as $attribute) { $attributeValue = \explode('=', $attribute); $attributeMap[$attributeValue[0]] = $attributeValue[1]; } $site->id = $attributeMap['sid']; // Login into the Site ID $urls = array(); $urls[] = new \Oara\Curl\Request($site->url, array()); $this->_client->get($urls); $urls = array(); $urls[] = new \Oara\Curl\Request('https://cli.linksynergy.com/cli/publisher/reports/reporting.php', array()); $result = $this->_client->get($urls); if (preg_match_all('/\\"token_one\\"\\: \\"(.+)\\"/', $result[0], $match)) { $site->token = $match[1][0]; } $urls = array(); $urls[] = new \Oara\Curl\Request('http://cli.linksynergy.com/cli/publisher/links/webServices.php', array()); $result = $this->_client->get($urls); if (preg_match_all('/<div class="token">(.+)<\\/div>/', $result[0], $match)) { $site->secureToken = $match[1][1]; } $siteList[] = $site; } $connection = true; $this->_siteList = $siteList; } return $connection; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $stringToFind = $dStartDate->format("F Y"); $urls = array(); $urls[] = new \Oara\Curl\Request('https://book.terravision.eu/partner/my/payments', array()); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//table'); $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($results->item(0))); $num = \count($exportData); for ($i = 1; $i < $num; $i++) { $transactionArray = \str_getcsv($exportData[$i], ";"); if ($transactionArray[0] == $stringToFind) { $transaction = array(); $transaction['merchantId'] = 1; $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; $transaction['date'] = $dEndDate->format("Y-m-d H:i:s"); $transaction['amount'] = \Oara\Utilities::parseDouble($transactionArray[1]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionArray[1]); $totalTransactions[] = $transaction; } } return $totalTransactions; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $amountDays = $dStartDate->diff($dEndDate)->days; $auxDate = clone $dStartDate; for ($j = 0; $j <= $amountDays; $j++) { $valuesFormExport = array(); $valuesFormExport[] = new \Oara\Curl\Parameter('date1', $auxDate->format("Y-m-d")); $valuesFormExport[] = new \Oara\Curl\Parameter('date2', $auxDate->format("Y-m-d")); $valuesFormExport[] = new \Oara\Curl\Parameter('prerange', '0'); $urls = array(); $urls[] = new \Oara\Curl\Request('https://affiliate.btguard.com/reports?', $valuesFormExport); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//table[@cellspacing="12"]'); if ($results->length > 0) { $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($results->item(0))); for ($z = 1; $z < \count($exportData); $z++) { $transactionLineArray = \str_getcsv($exportData[$z], ";"); $numberTransactions = (int) $transactionLineArray[2]; if ($numberTransactions != 0) { $commission = \Oara\Utilities::parseDouble($transactionLineArray[3]); $commission = (double) $commission / $numberTransactions; for ($y = 0; $y < $numberTransactions; $y++) { $transaction = array(); $transaction['merchantId'] = "1"; $transaction['date'] = $auxDate->format("Y-m-d H:i:s"); $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; $transaction['amount'] = $commission; $transaction['commission'] = $commission; $totalTransactions[] = $transaction; } } } } $auxDate->add(new \DateInterval('P1D')); } return $totalTransactions; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $valuesFormExport = array(); $valuesFormExport[] = new \Oara\Curl\Parameter('periodtype', "fromtolong"); $valuesFormExport[] = new \Oara\Curl\Parameter('fromday', $dStartDate->format("d")); $valuesFormExport[] = new \Oara\Curl\Parameter('frommonth', $dStartDate->format("m")); $valuesFormExport[] = new \Oara\Curl\Parameter('fromyear', $dStartDate->format("Y")); $valuesFormExport[] = new \Oara\Curl\Parameter('today', $dEndDate->format("d")); $valuesFormExport[] = new \Oara\Curl\Parameter('tomonth', $dEndDate->format("m")); $valuesFormExport[] = new \Oara\Curl\Parameter('toyear', $dEndDate->format("Y")); $valuesFormExport[] = new \Oara\Curl\Parameter('Go', 'Go'); $valuesFormExport[] = new \Oara\Curl\Parameter('partnerId', '326'); $valuesFormExport[] = new \Oara\Curl\Parameter('action', 'partnerLeads'); $valuesFormExport[] = new \Oara\Curl\Parameter('subaction', 'RevenueOverTime'); $urls = array(); $urls[] = new \Oara\Curl\Request('https://my.dianomi.com/Campaign-Analysis-378_1.html?', $valuesFormExport); $exportReport = $this->_client->get($urls); $doc = new \DOMDocument(); @$doc->loadHTML($exportReport[0]); $xpath = new \DOMXPath($doc); $results = $xpath->query('//*[contains(concat(" ", normalize-space(@class), " "), " tabular ")]'); if ($results->length > 0) { $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($results->item(0))); $num = count($exportData); for ($i = 1; $i < $num; $i++) { $overviewExportArray = \str_getcsv($exportData[$i], ";"); $transaction = array(); $transaction['merchantId'] = 1; $date = \DateTime::createFromFormat("Y-m-d 00:00:00", $overviewExportArray[0]); $transaction['date'] = $date->format("Y-m-d H:i:s"); $transaction['amount'] = $overviewExportArray[1]; $transaction['commission'] = $overviewExportArray[1]; $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; $totalTransactions[] = $transaction; } } return $totalTransactions; }
/** * @param null $merchantList * @param \DateTime|null $dStartDate * @param \DateTime|null $dEndDate * @return array * @throws Exception */ public function getTransactionList($merchantList = null, \DateTime $dStartDate = null, \DateTime $dEndDate = null) { $totalTransactions = array(); $valuesFromExport = array(new \Oara\Curl\Parameter('AffilUI_Filter', ''), new \Oara\Curl\Parameter('AffilUI_FilterStr', ''), new \Oara\Curl\Parameter('AffilUI_FilterTag', ''), new \Oara\Curl\Parameter('AdvancedFilter_State', '0'), new \Oara\Curl\Parameter('AdvancedFilter_nl_stav_id', '0'), new \Oara\Curl\Parameter('AdvancedFilter_nl_invia_id', '1'), new \Oara\Curl\Parameter('AdvancedFilter_departure', '0'), new \Oara\Curl\Parameter('AdvancedFilter_b_show_invoiced', 'on'), new \Oara\Curl\Parameter('AdvancedFilter_date_from', '01.01.2014'), new \Oara\Curl\Parameter('AdvancedFilter_date_to', '31.10.2014'), new \Oara\Curl\Parameter('AdvancedFilter_nl_rows', ''), new \Oara\Curl\Parameter('AdvancedFilter_sent', '1')); $urls = array(); $urls[] = new \Oara\Curl\Request("http://partner2.invia.cz/ikomunity/index.php?k2MAIN[action]=AFFIL_OBJ", $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), " "), " k2table_AffilUI ")]'); if ($tableList->length > 0) { $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->item(0))); $num = \count($exportData); for ($i = 1; $i < $num - 1; $i++) { $transactionExportArray = \explode(";", $exportData[$i]); $transaction = array(); $transactionDate = \DateTime::createFromFormat("d.m.Y", $transactionExportArray[2]); $transaction['date'] = $transactionDate->format("Y-m-d H:i:s"); $status = $transactionExportArray[4]; if ($status == "Zaplaceno") { $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; } else { if ($status == "Neprod�no") { $transaction['status'] = \Oara\Utilities::STATUS_PENDING; } else { if ($status == "Storno") { $transaction['status'] = \Oara\Utilities::STATUS_DECLINED; } else { throw new \Exception("New status found {$status}"); } } } $transaction['amount'] = \Oara\Utilities::parseDouble($transactionExportArray[6]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionExportArray[6]); $transaction['merchantId'] = 1; $transaction['unique_id'] = $transactionExportArray[0]; $totalTransactions[] = $transaction; } } return $totalTransactions; }
private function readTransactions($html) { $totalTransactions = array(); $doc = new \DOMDocument(); @$doc->loadHTML($html); $xpath = new \DOMXPath($doc); $tableList = $xpath->query('//table[@bgcolor="#003366"][@align="center"][@width="100%"]'); $exportData = \Oara\Utilities::htmlToCsv(\Oara\Utilities::DOMinnerHTML($tableList->item(0))); $num = \count($exportData); for ($i = 3; $i < $num; $i++) { $transactionExportArray = \str_getcsv($exportData[$i], ";"); $transaction = array(); $transaction['merchantId'] = 1; $transaction['date'] = \preg_replace("/[^0-9\\-]/", "", $transactionExportArray[0]) . " 00:00:00"; $transactionExportArray[1] = \trim($transactionExportArray[1]); if (\preg_match("/Paid/", $transactionExportArray[1])) { $transaction['status'] = \Oara\Utilities::STATUS_PAID; } else { if (\preg_match("/Pending/", $transactionExportArray[1])) { $transaction['status'] = \Oara\Utilities::STATUS_PENDING; } else { if (\preg_match("/Approved/", $transactionExportArray[1])) { $transaction['status'] = \Oara\Utilities::STATUS_CONFIRMED; } } } $transaction['amount'] = \Oara\Utilities::parseDouble($transactionExportArray[2]); $transaction['commission'] = \Oara\Utilities::parseDouble($transactionExportArray[2]); $totalTransactions[] = $transaction; } return $totalTransactions; }