public function getNumberOfSubaffiliates($userid = null) {
$result = new Gpf_Data_RecordSet();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('COUNT(u.userid)', 'amount');
$selectBuilder->from->add(Pap_Db_Table_Users::getName(), "u");
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "u.accountuserid = gu.accountuserid");
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$selectBuilder->where->add('u.deleted', '=', Gpf::NO);
if ($userid === null) {
$selectBuilder->where->add('u.parentuserid', '=', Gpf_Session::getAuthUser()->getPapUserId());
} else {
$selectBuilder->where->add('u.parentuserid', '=', $userid);
}
$selectBuilder->where->add('gu.rstatus', '<>', 'D');
if ($this->params->isDateFromDefined()) {
$selectBuilder->where->add('u.' . Pap_Stats_Table::DATEINSERTED, '>=', $this->params->getDateFrom()->toDateTime());
}
if ($this->params->isDateToDefined()) {
$selectBuilder->where->add('u.' . Pap_Stats_Table::DATEINSERTED, '<=', $this->params->getDateTo()->toDateTime());
}
$selectBuilder->limit->set(0, 1);
$result->load($selectBuilder);
if($result->getSize() == 0) {
return 0;
}
foreach($result as $record) {
return $record->get('amount');
}
}
/**
* @return Gpf_Rpc_Params
*/
private function getParams($limit) {
$params = new Gpf_Rpc_Params();
$params->add('sort_col', 'dateinserted');
$params->add('sort_asc', false);
$params->add('offset', 0);
$params->add('limit', $limit);
$params->add('columns', array(array("id"),array("id"),array("id"),array("commission"),array("totalcost"),array("orderid"),array("productid"),array("dateinserted"),array("name"),array("rtype"),array("tier"),array("commissionTypeName"),array("rstatus"),array("payoutstatus"),array("userid"),array("username"),array("firstname"),array("lastname"),array("channel")));
$filters = array();
if ($this->statsparams->isDateFromDefined()) {
$filters[] = array('dateinserted', 'D>=', Gpf_Common_DateUtils::getDateTime($this->statsparams->getDateFrom()->toTimeStamp() + $this->timeOffset));
}
if ($this->statsparams->isDateToDefined()) {
$filters[] = array('dateinserted', 'D<=', Gpf_Common_DateUtils::getDateTime($this->statsparams->getDateTo()->toTimeStamp() + $this->timeOffset));
}
if ($this->statsparams->isTypeDefined()) {
$filters[] = array('rtype', 'IN', $this->statsparams->getType());
}
if ($this->statsparams->isAffiliateIdDefined()) {
$filters[] = array('userid', 'E', $this->statsparams->getAffiliateId());
}
if ($this->statsparams->isAccountIdDefined()) {
$filters[] = array('accountid', 'E', $this->statsparams->getAccountId());
}
if (count($filters) > 0) {
$params->add('filters', $filters);
}
return $params;
}
private function initStatParams(Gpf_Rpc_FilterCollection $filterCollection) {
$this->statsParameters = new Pap_Stats_Params();
$this->statsParameters->initFrom($filterCollection);
if (!$this->statsParameters->isDateFromDefined() || !$this->statsParameters->isDateToDefined()) {
throw new Gpf_Exception("Date filter must be set in StatisticsBase class");
}
if (!$this->statsParameters->isStatusDefined()) {
$this->statsParameters->setStatus(Pap_Common_Constants::STATUS_APPROVED);
}
}
/**
*
* Pap alert application handle, do not modify this source!
*
* @param String $dateFrom
* @param String $dateTo
* @param String $userId
* @return Gpf_Data_RecordSet
*/
public static function getTransactions(Pap_Stats_Params $statsParams) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add('tr.'.Pap_Db_Table_Transactions::USER_ID, 'userid');
$select->select->add('au.'.Gpf_Db_Table_AuthUsers::FIRSTNAME, 'name');
$select->select->add('au.'.Gpf_Db_Table_AuthUsers::LASTNAME, 'surname');
$select->select->add('au.'.Gpf_Db_Table_AuthUsers::USERNAME, 'username');
$select->select->add('pu.data1', 'weburl');
$select->select->add('tr.'.Pap_Db_Table_Transactions::TRANSACTION_ID, 'transid');
$select->select->add('tr.'.Pap_Db_Table_Transactions::TOTAL_COST, 'totalcost');
$select->select->add('tr.'.Pap_Db_Table_Transactions::FIXED_COST, 'fixedcost');
$select->select->add('tr.'.Pap_Db_Table_Transactions::ORDER_ID, 'orderid');
$select->select->add('tr.'.Pap_Db_Table_Transactions::PRODUCT_ID, 'productid');
$select->select->add('tr.'.Pap_Db_Table_Transactions::DATE_INSERTED, 'dateinserted');
$select->select->add('tr.'.Pap_Db_Table_Transactions::R_STATUS, 'rstatus');
$select->select->add('tr.'.Pap_Db_Table_Transactions::R_TYPE, 'transtype');
$select->select->add('tr.'.Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, 'transkind');
$select->select->add('tr.'.Pap_Db_Table_Transactions::PAYOUT_STATUS, 'payoutstatus');
$select->select->add('tr.'.Pap_Db_Table_Transactions::DATE_APPROVED, 'dateapproved');
$select->select->add('tr.'.Pap_Db_Table_Transactions::COMMISSION, 'commission');
$select->select->add('tr.'.Pap_Db_Table_Transactions::REFERER_URL, 'refererurl');
$select->select->add('c.'.Pap_Db_Table_Campaigns::ID, 'campcategoryid');
$select->select->add('c.'.Pap_Db_Table_Campaigns::NAME, 'campaign');
$select->select->add('tr.data1', 'data1');
$select->select->add('tr.data2', 'data2');
$select->select->add('tr.data3', 'data3');
$select->select->add('tr.'.Pap_Db_Table_Transactions::COUNTRY_CODE, 'countrycode');
$select->from->add(Pap_Db_Table_Transactions::getName(), 'tr');
$select->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c',
'tr.'.Pap_Db_Table_Transactions::CAMPAIGN_ID.'=c.'.Pap_Db_Table_Campaigns::ID);
$select->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu',
'tr.'.Pap_Db_Table_Transactions::USER_ID.'=pu.'.Pap_Db_Table_Users::ID);
$select->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu',
'gu.'.Gpf_Db_Table_Users::ID.'=pu.'.Pap_Db_Table_Users::ACCOUNTUSERID);
$select->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au',
'gu.'.Gpf_Db_Table_Users::AUTHID.'=au.'.Gpf_Db_Table_AuthUsers::ID);
if ($statsParams->isDateFromDefined()) {
$select->where->add('tr.'.Pap_Db_Table_Transactions::DATE_INSERTED, '>=', $statsParams->getDateFrom()->toDateTime());
}
if ($statsParams->isDateToDefined()) {
$select->where->add('tr.'.Pap_Db_Table_Transactions::DATE_INSERTED, '<=', $statsParams->getDateTo()->toDateTime());
}
if ($statsParams->getAffiliateId() != '') {
$select->where->add('tr.'.Pap_Db_Table_Transactions::USER_ID, '=', $statsParams->getAffiliateId());
}
return $select->getAllRows();
}
