/** * 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; }