protected function initAllSubAffStats() {
$statParams = new Pap_Stats_Params();
$statParams->initFrom($this->filters);
$statParams->setType(Pap_Common_Constants::TYPE_SALE . ',' . Pap_Common_Constants::TYPE_CLICK);
$transactionStats = new Pap_Stats_Computer_TransactionsStatsBuilder($statParams, Pap_Db_Table_Transactions::USER_ID, Pap_Db_Table_Transactions::USERID, false);
$transactionStats->getTransactionsWhereClause()->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '!=', null);
$transactionStats->getTransactionsWhereClause()->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '<>', '');
$allSubStats = $transactionStats->getStatsSelect();
try {
$allSubStatsRow = $allSubStats->getOneRow();
$this->subAffCommissions = $allSubStatsRow->get(Pap_Db_Table_Transactions::COMMISSION);
$this->subAffSaleCount = $allSubStatsRow->get('count');
} catch (Gpf_DbEngine_NoRowException $e) {
$this->subAffCommissions = 0;
$this->subAffSaleCount = 0;
}
}
/**
* @return Pap_Stats_Params
*/
protected function getStatsParameters() {
$this->getStatsParametersFromFilter();
$statsParameters = new Pap_Stats_Params();
if($this->statsChannel != null) {
$statsParameters->setChannel($this->statsChannel->getId());
}
$statsParameters->setAffiliateId(Gpf_Session::getAuthUser()->getPapUserId());
$statsParameters->setDateRange($this->statsDateFrom, $this->statsDateTo);
$statsParameters->setType(Pap_Common_Constants::TYPE_SALE);
$statsParameters->setStatus(Pap_Common_Constants::STATUS_APPROVED);
return $statsParameters;
}
