/**
* @param String $campaignId
* @return Gpf_SqlBuilder_SelectIterator
*/
private function getRules($campaignId) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Pap_Db_Table_Rules::getInstance());
$select->from->add(Pap_Db_Table_Rules::getName());
$select->where->add(Pap_Db_Table_Rules::CAMPAIGN_ID, '=', $campaignId);
return $select->getAllRowsIterator();
}
/**
* @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;
}
/**
* @param $bannerID
* @return Iterator
*/
protected function getCoupons($bannerID, $userID) {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Coupons::getInstance());
$selectBuilder->from->add(Pap_Db_Table_Coupons::getName());
$selectBuilder->where->add(Pap_Db_Table_Coupons::BANNERID, '=', $bannerID);
$selectBuilder->where->add(Pap_Db_Table_Coupons::USERID, '=', $userID);
$selectBuilder->limit->set(0, 1);
return $selectBuilder->getAllRowsIterator();
}
private function deactivateInRebrand() {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Pap_Db_Table_Banners::getInstance());
$select->from->add(Pap_Db_Table_Banners::getName());
$select->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_RebrandPdfBanner_Config::TYPE);
foreach ($select->getAllRowsIterator() as $rebrandData) {
$this->removeCouponConstants($rebrandData);
}
}
protected function processAllRows(Gpf_SqlBuilder_SelectBuilder $select) {
$this->isComputed = true;
if (!$select->select->existsAlias(self::ACTIONS_COMMISSIONTYPEID)) {
$select->select->add('s.'.self::ACTIONS_COMMISSIONTYPEID);
$select->groupBy->add('s.'.self::ACTIONS_COMMISSIONTYPEID);
}
foreach ($select->getAllRowsIterator() as $resultRow) {
$this->processRow($resultRow, $resultRow->get(self::ACTIONS_COMMISSIONTYPEID));
}
}
public function loadChannels() {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(Pap_Db_Table_Channels::VALUE);
$select->select->add(Pap_Db_Table_Channels::NAME);
$select->from->add(Pap_Db_Table_Channels::getName());
$select->where->add(Pap_Db_Table_Channels::USER_ID, '=', Gpf_Session::getAuthUser()->getPapUserId());
$this->channels = array();
foreach ($select->getAllRowsIterator() as $row) {
$this->channels[$row->get(Pap_Db_Table_Channels::VALUE)] = $row->get(Pap_Db_Table_Channels::NAME);
}
}
private function getCampaignCategories($cmpid) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(Pap_Db_Table_CampaignsInCategory::CATEGORYID);
$select->from->add(Pap_Db_Table_CampaignsInCategory::getName());
$select->where->add(Pap_Db_Table_CampaignsInCategory::CAMPAIGNID,'=', $cmpid);
$select->groupBy->add(Pap_Db_Table_CampaignsInCategory::CATEGORYID);
$rows = $select->getAllRowsIterator();
$categories = array();
foreach ($rows as $row) {
$categories[] = $row->get(Pap_Db_Table_CampaignsInCategory::CATEGORYID);
}
return $categories;
}
public function firstTimeApproved(Pap_Affiliates_User $user){
$userInCommision = new Pap_Db_UserInCommissionGroup();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Campaigns::getInstance(), 'ca');
$selectBuilder->from->add('qu_pap_commissiongroups', 'c');
$selectBuilder->from->addInnerJoin('qu_pap_userincommissiongroup', 'u', 'u.commissiongroupid=c.commissiongroupid');
$selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'ca', 'ca.'.Pap_Db_Table_Campaigns::ID.'=c.campaignid');
$selectBuilder->where->add('u.userid','=',$user->getId());
foreach ($selectBuilder->getAllRowsIterator() as $row){
$campaign = new Pap_Common_Campaign();
$campaign->fillFromRecord($row);
$userInCommision->sendInviteMail($campaign,$user->getId());
}
}
protected function buildData(Gpf_Data_RecordSet $fields, Gpf_Rpc_Params $params) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add("name", "payoutFieldName", "ff");
$select->select->add(Pap_Db_Table_UserPayoutOptions::VALUE, Pap_Db_Table_UserPayoutOptions::VALUE, "upo");
$select->select->add(Pap_Db_Table_UserPayoutOptions::FORMFIELDID, Pap_Db_Table_UserPayoutOptions::FORMFIELDID, "upo");
$select->from->add(Pap_Db_Table_Users::getName(), "pu");
$select->from->addInnerJoin(Gpf_Db_Table_FormFields::getName(), "ff", "(ff.formid = CONCAT('payout_option_', pu.payoutoptionid))");
$select->from->addInnerJoin(Pap_Db_Table_UserPayoutOptions::getName(), "upo", "(pu.userid = upo.userid AND ff.formfieldid = upo.formfieldid)");
$select->where->add("pu.userid", "=", $params->get('userid'));
$i = 1;
foreach ($select->getAllRowsIterator() as $payoutField) {
$fields->add(array($payoutField->get(Pap_Db_Table_UserPayoutOptions::FORMFIELDID),
'data' . $i,
$this->_($payoutField->get('payoutFieldName')), 'T', 'M', null, ''));
$this->fieldValues['data' . $i++] = $payoutField->get(Pap_Db_Table_UserPayoutOptions::VALUE);
}
}
/**
* @return array<Pap_Db_UserPayoutOption>
*/
public function getValues($formName, $userId) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add('ff.'.Gpf_Db_Table_FormFields::ID, Gpf_Db_Table_FormFields::ID);
$select->select->add('ff.'.Gpf_Db_Table_FormFields::CODE, Gpf_Db_Table_FormFields::CODE);
$select->select->add('upo.'.self::VALUE, self::VALUE);
$select->select->add('upo.'.self::USERID, self::USERID);
$select->from->add(Gpf_Db_Table_FormFields::getName(), 'ff');
$select->from->addInnerJoin(self::getName(), 'upo', 'upo.formfieldid=ff.formfieldid');
$select->where->add('upo.'.self::USERID, '=', $userId);
$select->where->add('ff.'.Gpf_Db_Table_FormFields::FORMID, '=', $formName);
$values = array();
foreach ($select->getAllRowsIterator() as $row) {
$payoutOption = new Pap_Db_UserPayoutOption();
$payoutOption->fillFromRecord($row);
$values[$row->get('code')] = $payoutOption;
}
return $values;
}
protected function execute() {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Pap_Db_Table_RecurringCommissions::getInstance());
$select->from->add(Pap_Db_Table_RecurringCommissions::getName());
foreach ($select->getAllRowsIterator() as $row) {
$recurringCommission = new Pap_Features_RecurringCommissions_RecurringCommission();
$recurringCommission->fillFromRecord($row);
$recurringCommission->setPersistent(true);
if ($this->isDone($recurringCommission->getId())) {
continue;
}
$recurrencePreset = $recurringCommission->getRecurrencePreset();
$lastCommissionDate = $recurringCommission->getLastCommissionDate();
if ($lastCommissionDate == null) {
$lastCommissionDate = $recurringCommission->getTransaction()->getDateInserted();
}
$nextTimestamp = $recurrencePreset->getNextDate(Gpf_Common_DateUtils::mysqlDateTime2Timestamp($lastCommissionDate));
if ($nextTimestamp == null || $nextTimestamp > time()) {
continue;
}
$recurringCommission->setLastCommissionDate(Gpf_Common_DateUtils::getDateTime($nextTimestamp));
if ($recurringCommission->getStatus() == Pap_Common_Constants::STATUS_APPROVED) {
try {
$recurringCommission->createCommissions();
} catch (Gpf_Exception $e) {
Gpf_Log::critical('Recurring commissions - error create commissions: ' . $e->getMessage());
$this->setDone();
}
}
$recurringCommission->save();
$this->setDone();
}
}
/**
*
* @param $params
*/
protected function sendNotificationEmail(array $linkIds, $deleted = false) {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_DirectLinkUrls::getInstance());
$selectBuilder->from->add(Pap_Db_Table_DirectLinkUrls::getName());
$selectBuilder->where->add(Pap_Db_Table_DirectLinkUrls::ID, 'IN', $linkIds);
$usersMailTemplates = $this->getLinks($selectBuilder->getAllRowsIterator(), $deleted);
foreach ($usersMailTemplates as $userId => $mail) {
try {
$user = $this->loadUser($userId);
} catch (Gpf_DbEngine_NoRowException $e) {
Gpf_Log::warning($this->_('Error load affiliate with userid=' . $userId . ', mail will not be send.'));
continue;
}
$attribute = $this->loadAttributes($user->getAccountUserId());
if (Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_DIRECT_LINK_ENABLED) == Gpf::YES) {
$isNotify = $attribute->getAttributeWithDefaultValue(Pap_Settings::AFF_NOTIFICATION_ON_DIRECT_LINK_ENABLED,
Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_DIRECT_LINK_DEFAULT));
} else {
$isNotify = Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_DIRECT_LINK_DEFAULT);
}
if ($isNotify == Gpf::YES) {
$mail->setUser($user);
$mail->addRecipient($user->getEmail());
try {
$mail->send();
} catch (Exception $e) {
Gpf_Log::error($this->_('Error sending direct link changed status notification email to affiliate: %s', $e->getMessage()));
}
}
}
}
private function chooseSomeCampaignAsDefault() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('*');
$selectBuilder->from->add('qu_pap_campaigns', 'c');
foreach($selectBuilder->getAllRowsIterator() as $record) {
if($record->get('rtype') == Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC
&& $record->get('rstatus') == Pap_Db_Campaign::CAMPAIGN_STATUS_ACTIVE)
{
return $record->get('campaignid');
}
}
// no active and public campaign found
foreach($selectBuilder->getAllRowsIterator() as $record) {
if($record->get('rstatus') == Pap_Db_Campaign::CAMPAIGN_STATUS_ACTIVE) {
return $record->get('campaignid');
}
}
// no active campaign found
return '';
}
protected function migrateUsersInCampaigns() {
Pap3Compatibility_Migration_OutputWriter::log(" Migrating users in campaigns.....");
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('*');
$selectBuilder->from->add('wd_pa_affiliatescampaigns');
$count = 0;
foreach($selectBuilder->getAllRowsIterator() as $record) {
if($record->get('affiliateid') == '' || $record->get('campcategoryid') == '') {
continue;
}
$count++;
try {
$obj = new Pap_Db_UserInCommissionGroup();
$obj->setUserId($record->get('affiliateid'));
$obj->setCommissionGroupId($record->get('campcategoryid'));
$obj->setStatus(Pap3Compatibility_Migration_Pap3Constants::translateStatus($record->get('rstatus')));
$obj->setDateAdded(Gpf_Common_DateUtils::now());
$obj->save();
} catch(Gpf_Exception $e) {
// non important error, don't display it
}
}
Pap3Compatibility_Migration_OutputWriter::log(" ($count) ..... DONE<br/>");
}
/**
* @param $selectBuilder
* @return Gpf_SqlBuilder_SelectIterator
*/
protected function getImpressions(Gpf_SqlBuilder_SelectBuilder $selectBuilder)
{
return $selectBuilder->getAllRowsIterator();
}
private function processVisitsFrom($tableIndex) {
$this->updateRowsToBeProcessed($tableIndex);
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->addAll(Pap_Db_Table_Visits::getInstance($tableIndex));
$selectBuilder->from->add(Pap_Db_Table_Visits::getName($tableIndex));
$selectBuilder->where->add(Pap_Db_Table_Visits::RSTATUS, '=', Pap_Db_Visit::INPROCESSING);
$this->initVisitsWhere($selectBuilder->where);
foreach ($selectBuilder->getAllRowsIterator() as $visitRecord) {
$visit = new Pap_Db_Visit($tableIndex);
$visit->fillFromRecord($visitRecord);
$this->processAndUpdateVisit($visit);
}
}
private function migratePayouts() {
echo " Migrating payous.....";
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('sum(commission)', 'commission');
$selectBuilder->select->add('affiliateid');
$selectBuilder->select->add('accountingid');
$selectBuilder->from->add('wd_pa_transactions');
$selectBuilder->where->add('rstatus', '=', Pap3Compatibility_Migration_Pap3Constants::STATUS_APPROVED);
$selectBuilder->where->add('payoutstatus', '=', Pap3Compatibility_Migration_Pap3Constants::STATUS_APPROVED);
$selectBuilder->where->add('accountingid', '!=', null);
$selectBuilder->groupBy->add('accountingid');
$selectBuilder->groupBy->add('affiliateid');
$count = 0;
foreach($selectBuilder->getAllRowsIterator() as $record) {
$obj = new Pap_Db_Payout();
$obj->setUserId($record->get('affiliateid'));
$obj->set('payouthistoryid', $record->get('accountingid'));
$obj->set('amount', $record->get('commission'));
$obj->save();
$count++;
}
echo " ($count) ..... DONE<br/>";
}
protected function processAllRows(Gpf_SqlBuilder_SelectBuilder $select) {
foreach ($select->getAllRowsIterator() as $resultRow) {
$this->processRow($resultRow);
}
}
private function loadPayoutFields() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('payfieldid');
$selectBuilder->select->add('code');
$selectBuilder->select->add('payoptid');
$selectBuilder->from->add('wd_pa_payoutfields');
$this->pap3PayoutFields = array();
foreach ($selectBuilder->getAllRowsIterator() as $payoutField) {
$this->pap3PayoutFields[$payoutField->get('code') . '_' . $payoutField->get('payoptid')] = $payoutField->get('payfieldid');
}
}
/**
* @return Gpf_View_GridService_RowsIterator
*/
protected function createRowsIterator() {
if($this instanceof Gpf_View_Grid_HasRowFilter) {
return new Gpf_View_GridService_RowsIterator($this->_selectBuilder->getAllRowsIterator(), $this);
}
return new Gpf_View_GridService_RowsIterator($this->_selectBuilder->getAllRowsIterator());
}
