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'); } }
private function getCampaignRecordSetForAffiliate() { $selectBuilder = $this->createSelectBuilder(); $selectBuilder->select->add('c.'.Pap_Db_Table_Campaigns::STATUS, 'rstatus'); $selectBuilder->select->add('c.'.Pap_Db_Table_Campaigns::TYPE, 'rtype'); Gpf_Plugins_Engine::extensionPoint('Pap_Common_Campaign_CampaignForAffiliateRichListBox.getCampaignRecordSetForAffiliate', new Pap_Affiliates_Promo_SelectBuilderCompoundFilter($selectBuilder)); $result = new Gpf_Data_RecordSet(); $result->load($selectBuilder); return $result; }
/** * @param string $roleId * @return Gpf_Data_RecordSet */ public function getAllPrivileges($roleId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(self::ID, 'id'); $select->select->add(self::OBJECT, 'object'); $select->select->add(self::PRIVILEGE, 'privilege'); $select->from->add(self::getName()); $select->where->add(self::ROLE_ID, "=", $roleId); $privileges = new Gpf_Data_RecordSet(); $privileges->load($select); return $privileges; }
/** * @param String $viewtype * * @return Gpf_Data_RecordSet */ public function getAllWallpapers() { $result = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(self::ID, 'id'); $selectBuilder->select->add(self::NAME, 'name'); $selectBuilder->select->add(self::URL, 'url'); $selectBuilder->select->add(self::FILEID, 'fileid'); $selectBuilder->from->add(self::getName()); $selectBuilder->where->add(self::ACCOUNTUSERID, '=', Gpf_Session::getAuthUser()->getAccountUserId()); $result->load($selectBuilder); return $result; }
/** * @param String commissionTypeId * * @return Gpf_Data_RecordSet */ public function getAllCommissionTypeAttributes($commissionTypeId) { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(self::ID, 'attributeid'); $selectBuilder->select->add(self::COMMISSION_TYPE_ID, 'commtypeid'); $selectBuilder->select->add(self::NAME, 'name'); $selectBuilder->select->add(self::VALUE, 'value'); $selectBuilder->from->add(self::getName()); $selectBuilder->where->add(self::ID, '=', $commissionTypeId); $result->load($selectBuilder); return $result; }
/** * @param String $viewtype * * @return Gpf_Data_RecordSet */ public function getAllViews($viewtype) { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(self::ID, 'id'); $selectBuilder->select->add(self::NAME, self::NAME); $selectBuilder->select->add(self::ROWSPERPAGE, self::ROWSPERPAGE); $selectBuilder->select->add(self::ACCOUNTUSERID, self::ACCOUNTUSERID); $selectBuilder->from->add(self::getName()); $selectBuilder->where->add(self::VIEWTYPE, '=', $viewtype); $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add(self::ACCOUNTUSERID, '=', Gpf_Session::getAuthUser()->getAccountUserId(), 'OR'); $condition->add(self::ACCOUNTUSERID, '=', '', 'OR'); $selectBuilder->where->addCondition($condition); $selectBuilder->orderBy->add(self::ACCOUNTUSERID, false); $result->load($selectBuilder); return $result; }
private function loadAffiliateSettings() { $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('code', 'code'); $selectBuilder->select->add('value', 'value'); $selectBuilder->from->add('wd_g_settings'); $selectBuilder->where->add('code', 'LIKE', 'Aff_signup_%'); $selectBuilder->where->add('code', '=', 'Aff_initial_min_payout', 'OR'); $result = new Gpf_Data_RecordSet(); $result->load($selectBuilder); $count = 0; foreach($result as $record) { $this->pap3AffSettings[$record->get('code')] = $record->get('value'); $count++; } }
private function loadCampaigns() { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(Pap_Db_Table_Campaigns::ID, 'id'); $selectBuilder->select->add(Pap_Db_Table_Campaigns::NAME, 'name'); $selectBuilder->select->add(Pap_Db_Table_Campaigns::STATUS, 'status'); $selectBuilder->select->add(Pap_Db_Table_Campaigns::DESCRIPTION, 'description'); $selectBuilder->select->add(Pap_Db_Table_Campaigns::LOGO_URL, 'logourl'); $selectBuilder->from->add(Pap_Db_Table_Campaigns::getName()); $selectBuilder->where->add(Pap_Db_Table_Campaigns::STATUS, 'IN', Pap_Affiliates_Promo_Campaigns::getCampaignAllowedStatuses()); $selectBuilder->orderBy->add(Pap_Db_Table_Campaigns::ORDER); $result->load($selectBuilder); return $result; }
/** * @return Gpf_Data_IndexedRecordSet */ public function fillViewColumns(Gpf_Data_IndexedRecordSet $allColumns, $viewid) { $viewColumns = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('name', 'name'); $selectBuilder->select->add('sorted', 'sorted'); $selectBuilder->select->add('width', 'width'); $selectBuilder->from->add(self::getName()); $selectBuilder->where->add('viewid', '=', $viewid); $selectBuilder->orderBy->add('rorder'); $viewColumns->load($selectBuilder); foreach ($viewColumns as $viewColumn) { try { $column = $allColumns->getRecord($viewColumn->get('name')); $column->set('sorted', $viewColumn->get('sorted')); $column->set('width', $viewColumn->get('width')); $column->set('visible', Gpf::YES); } catch (Exception $e) { } } return $allColumns; }
public function checkUserApprovedDirectLinks($userId) { $result = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('COUNT('.Pap_Db_Table_DirectLinkUrls::ID.')', 'count'); $selectBuilder->from->add(Pap_Db_Table_DirectLinkUrls::getName()); $selectBuilder->where->add(Pap_Db_Table_DirectLinkUrls::USER_ID, '=', $userId); $selectBuilder->where->add(Pap_Db_Table_DirectLinkUrls::STATUS, '=', Pap_Common_Constants::STATUS_APPROVED); $result->load($selectBuilder); if($result->getSize() == 0) { return false; } foreach($result as $record) { if($record->get('count') > 0) { return true; } break; } return false; }
public function regenerateDirectLinksFile() { $rs = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('userid', 'userid'); $selectBuilder->select->add('url', 'url'); $selectBuilder->select->add('channelid', 'channelid'); $selectBuilder->select->add('campaignid', 'campaignid'); $selectBuilder->select->add('bannerid', 'bannerid'); $selectBuilder->from->add(Pap_Db_Table_DirectLinkUrls::getName()); $selectBuilder->where->add('rstatus', '=', Pap_Common_Constants::STATUS_APPROVED); $selectBuilder->orderBy->add(Pap_Db_Table_DirectLinkUrls::MATCHES, false); $rs->load($selectBuilder); $this->createTemporaryFile(); foreach($rs as $record) { $this->addUrl($record->get('userid'), $record->get('url'), $record->get('channelid'), $record->get('campaignid'), $record->get('bannerid')); } $this->commitTemporaryFile(); }
/** * checks if user is in campaign, if yes, it will return valid commissionGroupID, * otherwise it returns false * * @param string $userId * @return string or false */ public function checkUserIsInCampaign($userId) { $result = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('u.usercommgroupid', 'usercommgroupid'); $selectBuilder->select->add('u.commissiongroupid', 'commissiongroupid'); $selectBuilder->select->add('u.rstatus', 'rstatus'); $selectBuilder->from->add('qu_pap_userincommissiongroup', 'u'); $selectBuilder->from->addInnerJoin('qu_pap_commissiongroups', 'g', 'u.commissiongroupid=g.commissiongroupid'); $selectBuilder->where->add('g.campaignid', '=', $this->getId()); $selectBuilder->where->add('u.userid', '=', $userId); $selectBuilder->limit->set(0, 1); $result->load($selectBuilder); if($result->getSize() == 0) { return false; } foreach($result as $record) { if($this->isUserCommissionGroupStatusAllowed($record->get('rstatus'))) { return $record->get('commissiongroupid'); } break; } return false; }
/** * @param filterType * @service filter read */ public function getFilterNames(Gpf_Rpc_Params $params) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('f.userid', '=', Gpf_Session::getAuthUser()->getUserId(), 'OR'); $condition->add('f.userid', '=', null, 'OR'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('f.filterid', 'id'); $selectBuilder->select->add('f.name', 'name'); $selectBuilder->from->add(Gpf_Db_Table_Filters::getName(), 'f'); $selectBuilder->where->add('f.filtertype', '=', $params->get('filterType')); $selectBuilder->where->addCondition($condition); $selectBuilder->orderBy->add('f.name'); $response = new Gpf_Data_RecordSet(); $response->load($selectBuilder); return $response; }
/** * @param String $campaignId * @param String $commissionType * @return Gpf_Data_RecordSet */ public function getAllCommissionTypes($campaignId = null, $commissionType = null) { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = $this->getAllCommissionTypesSelect($campaignId, $commissionType); $result->load($selectBuilder); return $result; }
public function getNumberOfUsersFromSameIP($ip, $periodInSeconds) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add("count(au.authid)", "count"); $select->from->add(Pap_Db_Table_Users::getName(),'pu'); $select->from->addInnerJoin(Gpf_Db_Table_Users::getName(),'qu','pu.'.Pap_Db_Table_Users::ACCOUNTUSERID.'=qu.'.Gpf_Db_Table_Users::ID); $select->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(),'au','au.'.Gpf_Db_Table_AuthUsers::ID.'=qu.'.Gpf_Db_Table_Users::AUTHID. ' and qu.'.Gpf_Db_Table_Users::ROLEID."='".Pap_Application::DEFAULT_ROLE_AFFILIATE."'"); $select->where->add('au.'.Gpf_Db_Table_AuthUsers::IP, "=", $ip); $dateFrom = new Gpf_DateTime(); $dateFrom->addSecond(-1*$periodInSeconds); $select->where->add(Pap_Db_Table_Users::DATEINSERTED, ">", $dateFrom->toDateTime()); $recordSet = new Gpf_Data_RecordSet(); $recordSet->load($select); foreach($recordSet as $record) { return $record->get("count"); } return 0; }
/** * returns latest undeclined click from the given IP address * * @param string $ip * @param int $periodInSeconds * @return unknown */ public function getLatestClickFromIP($ip, $periodInSeconds) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Pap_Db_Table_RawClicks::USERID, "userid"); $select->select->add(Pap_Db_Table_RawClicks::CHANNEL, "channel"); $select->from->add(Pap_Db_Table_RawClicks::getName()); $select->where->add(Pap_Db_Table_RawClicks::IP, "=", $ip); $select->where->add(Pap_Db_Table_RawClicks::RTYPE, "<>", Pap_Db_ClickImpression::STATUS_DECLINED); $dateFrom = new Gpf_DateTime(); $dateFrom->addSecond(-1*$periodInSeconds); $select->where->add(Pap_Db_Table_RawClicks::DATETIME, ">", $dateFrom->toDateTime()); $select->orderBy->add(Pap_Db_Table_RawClicks::DATETIME, false); $select->limit->set(0, 1); $recordSet = new Gpf_Data_RecordSet(); $recordSet->load($select); foreach($recordSet as $record) { return array('userid' => $record->get("userid"), 'channel' => $record->get("channel")); } return null; }
/** * Gets currency names for CurrencySearchListBox * * @service currency read * @param $search */ public function getCurrencies(Gpf_Rpc_Params $params) { $searchString = $params->get('search'); $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Gpf_Db_Table_Currencies::ID, "id"); $select->select->add(Gpf_Db_Table_Currencies::NAME, "name"); $select->from->add(Gpf_Db_Table_Currencies::getName()); $select->where->add(Gpf_Db_Table_Currencies::NAME, "LIKE", "%" . $searchString . "%"); $result = new Gpf_Data_RecordSet(); $result->load($select); return $result; }
/** * checks if banner name is unique * * @return unknown */ public function checkUniqueName($name, $bannerId, $accountId) { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(self::ID, 'bannerid'); $selectBuilder->select->add('name', 'name'); $selectBuilder->from->add(self::getName()); $selectBuilder->where->add('name', '=', $name); $selectBuilder->where->add('accountid', '=', $accountId); if ($bannerId != '') { $selectBuilder->where->add('bannerid', '<>', $bannerId); } $result->load($selectBuilder); return $result; }
private function getNumberOfSalesActions($userId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add('count(transid)', 'countColumn'); $select->from->add(Pap_Db_Table_Transactions::getName()); $select->where->add(Pap_Db_Table_Transactions::USER_ID, '=', $userId); $select->where->add(Pap_Db_Table_Transactions::TIER, '=', '1'); $select->where->add(Pap_Db_Table_Transactions::R_STATUS, '=', Pap_Common_Constants::STATUS_APPROVED); $compoundWhere = new Gpf_SqlBuilder_CompoundWhereCondition(); $compoundWhere->add(Pap_Db_Table_Transactions::R_TYPE, '=', Pap_Common_Constants::TYPE_SALE, 'OR'); $compoundWhere->add(Pap_Db_Table_Transactions::R_TYPE, '=', Pap_Common_Constants::TYPE_ACTION, 'OR'); $select->where->addCondition($compoundWhere); $recordSet = new Gpf_Data_RecordSet(); $recordSet->load($select); foreach($recordSet as $record) { return $record->get('countColumn'); } return 0; }
private function getPayoutsForHistoryIds($payoutHistoryIds) { $result = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(Pap_Db_Table_Payouts::PAYOUT_HISTORY_ID, Pap_Db_Table_Payouts::PAYOUT_HISTORY_ID); $selectBuilder->select->add(Pap_Db_Table_Payouts::AMOUNT, Pap_Db_Table_Payouts::AMOUNT); $selectBuilder->select->add(Gpf_Db_Table_AuthUsers::USERNAME, Gpf_Db_Table_AuthUsers::USERNAME, 'au'); $selectBuilder->select->add(Gpf_Db_Table_AuthUsers::FIRSTNAME, Gpf_Db_Table_AuthUsers::FIRSTNAME, 'au'); $selectBuilder->select->add(Gpf_Db_Table_AuthUsers::LASTNAME, Gpf_Db_Table_AuthUsers::LASTNAME, 'au'); $selectBuilder->select->add(Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL, Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL, 'au'); $selectBuilder->select->add(Pap_Db_Table_Users::ID, Pap_Db_Table_Users::ID, 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(3), Pap_Db_Table_Users::getDataColumnName(3), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(4), Pap_Db_Table_Users::getDataColumnName(4), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(5), Pap_Db_Table_Users::getDataColumnName(5), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(6), Pap_Db_Table_Users::getDataColumnName(6), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(7), Pap_Db_Table_Users::getDataColumnName(7), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(8), Pap_Db_Table_Users::getDataColumnName(8), 'pu'); $selectBuilder->select->add(Pap_Db_Table_Users::getDataColumnName(9), Pap_Db_Table_Users::getDataColumnName(9), 'pu'); $selectBuilder->select->add(Gpf_Db_Table_Currencies::SYMBOL, Gpf_Db_Table_Currencies::SYMBOL, 'c'); $selectBuilder->select->add(Gpf_Db_Table_Currencies::WHEREDISPLAY, Gpf_Db_Table_Currencies::WHEREDISPLAY, 'c'); $selectBuilder->from->add(Pap_Db_Table_Payouts::getName(), 'p'); $selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 'p.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'); $selectBuilder->from->addLeftJoin(Gpf_Db_Table_Currencies::getName(), 'c', 'p.currencyid = c.currencyid'); $selectBuilder->where->add(Pap_Db_Table_Payouts::PAYOUT_HISTORY_ID, 'IN', $payoutHistoryIds); $result->load($selectBuilder); return $result; }
private function getSubaffiliatesCounts($ids) { $results = array(); $condition = ''; $rs = new Gpf_Data_RecordSet(); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('count(u.'.Pap_Db_Table_Users::ID.')', 'count'); $selectBuilder->select->add('u.'.Pap_Db_Table_Users::PARENTUSERID, Pap_Db_Table_Users::PARENTUSERID); $selectBuilder->from->add(Pap_Db_Table_Users::getName(), 'u'); $selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'u.'.Pap_Db_Table_Users::ACCOUNTUSERID.' = gu.'.Gpf_Db_Table_Users::ID); $selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'gu.'.Gpf_Db_Table_Users::AUTHID .' = au.'.Gpf_Db_Table_AuthUsers::ID); $selectBuilder->where->add('u.'.Pap_Db_Table_Users::PARENTUSERID, 'in', $ids); $selectBuilder->where->add('u.'.Pap_Db_Table_Users::DELETED, '=', Gpf::NO); $selectBuilder->where->add('gu.'.Gpf_Db_Table_Users::STATUS, 'in', array(Gpf_Db_User::APPROVED, Gpf_Db_User::PENDING)); $this->filterCollection->addTo($selectBuilder->where); $selectBuilder->groupBy->add('u.'.Pap_Db_Table_Users::PARENTUSERID); $rs->load($selectBuilder); foreach($rs as $record) { $results[$record->get(Pap_Db_Table_Users::PARENTUSERID)] = $record->get('count'); } return $results; }
protected function loadCampaignSettings() { Pap3Compatibility_Migration_OutputWriter::log(" Loading PAP3 campaign settings....."); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('code', 'code'); $selectBuilder->select->add('value', 'value'); $selectBuilder->select->add('id1', 'campaignid'); $selectBuilder->from->add('wd_g_settings'); $selectBuilder->where->add('code', 'LIKE', 'Aff_camp_%'); $selectBuilder->where->add('id1', '!=', 'null'); $result = new Gpf_Data_RecordSet(); $result->load($selectBuilder); $count = 0; foreach($result as $record) { $this->pap3CampaignSettings[$record->get('campaignid')][$record->get('code')] = $record->get('value'); $count++; } Pap3Compatibility_Migration_OutputWriter::log(" ($count) ..... DONE<br/>"); }
/** * * @param $campaignId * @param $tier * @return Gpf_Data_RecordSet */ public function getAllCommissionsInCampaign($campaignId = '', $tier = '1') { $result = new Gpf_Data_RecordSet(); $selectBuilder = $this->getAllCommissionsInCampaignSelectBuilder($campaignId, $tier); $selectBuilder->orderBy->add(self::VALUE); $result->load($selectBuilder); return $result; }
public static function getAllPayoutOptionNames() { $result = new Gpf_Data_RecordSet('id'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(Gpf_Db_Table_FieldGroups::ID, 'id'); $selectBuilder->select->add(Gpf_Db_Table_FieldGroups::NAME, 'name'); $selectBuilder->from->add(Gpf_Db_Table_FieldGroups::getName()); $selectBuilder->where->add(Gpf_Db_Table_FieldGroups::TYPE, '=', Pap_Common_Constants::FIELDGROUP_TYPE_PAYOUTOPTION); $result->load($selectBuilder); $resultArray = array(); foreach($result as $record) { $resultArray[$record->get('id')] = Gpf_Lang::_localizeRuntime($record->get('name')); } return $resultArray; }
public function getNumberOfRecordsWithSameOrderId($orderId, $transType, $periodInHours, $parentTransId, $visitDateTime) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add("count(transid)", "count"); $select->from->add(Pap_Db_Table_Transactions::getName()); if($orderId == '') { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add(Pap_Db_Table_Transactions::ORDER_ID, '=', '', 'OR'); $condition->add(Pap_Db_Table_Transactions::ORDER_ID, '=', null, 'OR'); $select->where->addCondition($condition); } else { $select->where->add(Pap_Db_Table_Transactions::ORDER_ID, "=", $orderId); } $select->where->add(Pap_Db_Table_Transactions::R_TYPE, "=", $transType); $select->where->add(Pap_Db_Table_Transactions::TIER, "=", "1"); $select->where->add(Pap_Db_Table_Transactions::R_STATUS, "<>", Pap_Common_Constants::STATUS_DECLINED); if($periodInHours > 0) { $dateFrom = new Gpf_DateTime($visitDateTime); $dateFrom->addHour(-1*$periodInHours); $select->where->add(Pap_Db_Table_Transactions::DATE_INSERTED, ">", $dateFrom->toDateTime()); } if($parentTransId != null && $parentTransId != '') { $select->where->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, "<>", $parentTransId); } $recordSet = new Gpf_Data_RecordSet(); $recordSet->load($select); foreach($recordSet as $record) { return $record->get("count"); } return 0; }