/**
* Total paid to affiliates
*/
public function paidToAffiliates()
{
return "0";
$from = strtotime("midnight", strtotime($this->_search_params['from']));
$to = strtotime("tomorrow", strtotime($this->_search_params['to'])) - 1;
if ($this->_search_params['affiliate'] and $this->_search_params['affiliate'] != "no-affiliate") {
$cache_key = "paidToAffiliates_" . $from . "_" . $to . "_" . $this->_search_params['affiliate'];
} else {
$cache_key = "paidToAffiliates_" . $from . "_" . $to;
}
if (Cache::has($cache_key)) {
return Cache::get($cache_key);
}
$amount = 0;
$start = date('Ymd\\TH:i:s', $from);
$finish = date('Ymd\\TH:i:s', $to);
// Get all affilaites from DK DB
$affiliates = Affiliate::get();
// Add InfusionSoft Library
require_once app_path() . "/libraries/infusionsoft/isdk.php";
$isapp = new iSDK();
// Create Connection
if ($isapp->cfgCon("comissionTracker")) {
if ($this->_search_params['affiliate'] and $this->_search_params['affiliate'] != "no-affiliate") {
$pays = $isapp->affPayouts($this->_search_params['affiliate'], $start, $finish);
foreach ($pays as $payout) {
$amount = $amount + $payout['PayAmt'];
}
} else {
foreach ($affiliates as $affiliate) {
$affiliateId = $affiliate->id;
$pays = $isapp->affPayouts($affiliateId, $start, $finish);
foreach ($pays as $payout) {
$amount = $amount + $payout['PayAmt'];
}
}
}
}
$amount = number_format($amount);
Cache::put($cache_key, $amount, 10);
return $amount;
}
