protected function loadItems($itemId, $lastTier = false) {
$result = new Gpf_Data_RecordSet();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Users::getInstance(), 'u');
$selectBuilder->select->add('au.username', 'username');
$selectBuilder->select->add('au.firstname', 'firstname');
$selectBuilder->select->add('au.lastname', 'lastname');
$selectBuilder->select->add('au.'.Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL, Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL);
$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.rtype', '=', Pap_Application::ROLETYPE_AFFILIATE);
$selectBuilder->limit->set(0, 50);
$this->filterCollection->addTo($selectBuilder->where);
$this->addWhereCondition($selectBuilder, $itemId);
$result->load($selectBuilder);
$result->addColumn("subaffiliates", 0);
if (!$lastTier) {
$record = $this->addSubaffiliatesCount($result);
}
return $result;
}
/**
* @return array
*/
public function getChildren(Pap_Common_User $parent, $offset = '', $limit = '') {
$children = array();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Users::getInstance(), 'pu');
$selectBuilder->select->addAll(Gpf_Db_Table_AuthUsers::getInstance(), 'au');
$selectBuilder->from->add(Pap_Db_Table_Users::getName(), 'pu');
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'pu.accountuserid = gu.accountuserid');
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'gu.authid = au.authid');
$selectBuilder->where->add(Pap_Db_Table_Users::PARENTUSERID, '=', $parent->getId());
$selectBuilder->where->add(Gpf_Db_Table_Users::STATUS, 'IN', array(Pap_Common_Constants::STATUS_APPROVED, Pap_Common_Constants::STATUS_PENDING));
$selectBuilder->orderBy->add(Pap_Db_Table_Users::DATEINSERTED);
$selectBuilder->limit->set($offset, $limit);
foreach ($selectBuilder->getAllRowsIterator() as $userRecord) {
$user = new Pap_Common_User();
$user->fillFromRecord($userRecord);
$children[] = $user;
}
return $children;
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
private function getAffiliatesToPaySelect($payoutOptionId = null) {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Users::getInstance(), 'pu');
$selectBuilder->select->addAll(Gpf_Db_Table_AuthUsers::getInstance(), 'au');
$selectBuilder->select->add('SUM('.Pap_Db_Table_Transactions::COMMISSION.')', 'amountRaw');
$selectBuilder->from->add(Pap_Db_Table_Transactions::getName(), 't');
$selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 't.userid = pu.userid');
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'pu.accountuserid = gu.accountuserid');
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'gu.authid = au.authid');
if ($payoutOptionId != null) {
$selectBuilder->where->add('pu.'.Pap_Db_Table_Users::PAYOUTOPTION_ID, '=', $payoutOptionId);
}
$selectBuilder->where->add('t.'.Pap_Db_Table_Transactions::PAYOUTHISTORY_ID, '=', Pap_Common_Transaction::PAYMENT_PENDING_ID);
$selectBuilder->groupBy->add(Pap_Db_Table_Transactions::USER_ID);
return $selectBuilder;
}
function init() {
$this->setTable(Pap_Db_Table_Users::getInstance());
parent::init();
}
/**
* Get recordset of merchants recipients
*
* @param $from
* @return Gpf_Data_RecordSet
*/
private function getMerchantsRecipients($from) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Gpf_Db_Table_AuthUsers::getInstance(), 'au');
$select->select->addAll(Gpf_Db_Table_Accounts::getInstance(), 'a');
$select->select->addAll(Gpf_Db_Table_Users::getInstance(), 'gu');
$select->select->addAll(Pap_Db_Table_Users::getInstance(), 'u');
$select->from->add(Pap_Db_Table_Users::getName(), 'u');
$select->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'u.'.Pap_Db_Table_Users::ACCOUNTUSERID.'=gu.'.Gpf_Db_Table_Users::ID.
' AND u.'.Pap_Db_Table_Users::DELETED . ' = \'' . Gpf::NO . '\''.
' AND u.' .Pap_Db_Table_Users::TYPE . ' = \'' . Pap_Application::ROLETYPE_MERCHANT . '\'');
$select->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'au.'.Gpf_Db_Table_AuthUsers::ID.'=gu.'.Gpf_Db_Table_Users::AUTHID);
$select->from->addInnerJoin(Gpf_Db_Table_Accounts::getName(), 'a', 'a.'.Gpf_Db_Table_Accounts::ID.'=gu.'.Gpf_Db_Table_Users::ACCOUNTID);
$select->limit->set($from, Pap_Mail_MassMailAffiliatesGrid::MAX_ROWS_PER_SQL);
return $select->getAllRows();
}
protected function loadResultData() {
if (!$this->isStatsColumnRequired()) {
$this->doMossoHack(Pap_Db_Table_Users::getInstance(), 'u', Pap_Db_Table_Users::ID);
}
return parent::loadResultData();
}
private function getAffiliateCount() {
$banner = new Pap_Db_Banner();
$banner->setId($this->form->getFieldValue(Pap_Features_Coupon_CreateCoupons::BANNER_ID));
try {
$banner->load();
$campaignId = $banner->getCampaignId();
} catch (Gpf_DbEngine_NoRowException $e) {
$campaignId = null;
}
$campaign = new Pap_Db_Campaign();
$campaign->setId($campaignId);
try {
$campaign->load();
$campaignType = $campaign->getCampaignType();
} catch (Gpf_DbEngine_NoRowException $e) {
$campaignType = null;
}
if ($campaignType != Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC) {
return Pap_Db_Table_UserInCommissionGroup::getUsersInCommissionGroupCount($campaignId);
}
return Pap_Db_Table_Users::getInstance()->getAffiliateCount();
}
