/** * @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; }
/** * * @service * @anonym * @return Gpf_Rpc_Data */ public function ping(Gpf_Rpc_Params $params) { $sql = new Gpf_SqlBuilder_SelectBuilder(); $sql->select->addAll(Gpf_Db_Table_AuthUsers::getInstance()); $sql->from->add(Gpf_Db_Table_AuthUsers::getName()); $count = $sql->getAllRows()->getSize(); if ($count == 0) { throw new Gpf_Exception($this->_('Ping failed')); } $data = new Gpf_Rpc_Data(); $data->setValue('status', 'OK'); return $data; }
/** * @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; }
/** * 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(); }
function init() { $this->setTable(Gpf_Db_Table_AuthUsers::getInstance()); parent::init(); }