protected function buildFrom() { $this->_selectBuilder->from->add(Pap_Db_Table_Rules::getName(), 'r'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'c.'.Pap_Db_Table_Campaigns::ID.'=r.'.Pap_Db_Table_Rules::CAMPAIGN_ID); $this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'r.'.Pap_Db_Table_Rules::COMMISSION_GROUP_ID.'=cg.'.Pap_Db_Table_CommissionGroups::ID); }
public function run() { $time1 = microtime(); Pap3Compatibility_Migration_OutputWriter::logOnce("Deleting migrated data from existing PAP4 tables<br/>"); try { $this->deleteTable(Pap_Db_Table_Campaigns::getName()); $this->deleteTable(Pap_Db_Table_CommissionGroups::getName()); $this->deleteTable(Pap_Db_Table_CommissionTypes::getName()); $this->deleteTable(Pap_Db_Table_Commissions::getName()); $this->deleteTable(Pap_Db_Table_UserInCommissionGroup::getName()); $this->deleteTable(Gpf_Db_Table_FormFields::getName()); $this->deleteTable(Gpf_Db_Table_FieldGroups::getName()); $this->deleteTable(Pap_Db_Table_Transactions::getName()); $this->deleteTable(Pap_Db_Table_Clicks::getName()); $this->deleteTable(Pap_Db_Table_RawClicks::getName()); $this->deleteTable(Pap_Db_Table_Impressions::getName()); $this->deleteTable(Pap_Db_Table_Banners::getName()); $this->deleteTable(Gpf_Db_Table_FieldGroups::getName()); $this->deleteTable(Pap_Db_Table_PayoutsHistory::getName()); $this->deleteTable(Pap_Db_Table_Payouts::getName()); $this->deleteTable(Gpf_Db_Table_Currencies::getName()); $this->deleteTable(Gpf_Db_Table_MailAccounts::getName()); } catch(Exception $e) { Pap3Compatibility_Migration_OutputWriter::log(" Errror: ".$e->getMessage()."<br/>"); } $time2 = microtime(); Pap3Compatibility_Migration_OutputWriter::logDone($time1, $time2); }
protected function buildFrom() { $this->_selectBuilder->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), "uicg"); $onCondition = "uicg.".Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID." = cg.".Pap_Db_Table_CommissionGroups::ID; $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_CommissionGroups::getName(), "cg", $onCondition); $onCondition = "cg.".Pap_Db_Table_CommissionGroups::CAMPAIGN_ID. " = c." .Pap_Db_Table_Campaigns::ID; $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), "c", $onCondition); }
private function setCommissionGroupId(Gpf_Data_Row $row) { if (!is_null(($commissionGroupId = $this->commissionsGroupTable->getUserCommissionGroup($row->get(Pap_Db_Table_Campaigns::ID), $this->getUserID())))) { $row->set('commissiongroupid', $commissionGroupId); return; } try { $row->set('commissiongroupid', $this->commissionsTable->getDefaultCommissionGroup($row->get(Pap_Db_Table_Campaigns::ID))); } catch (Gpf_DbEngine_NoRowException $e) { } }
private function removeCommissionGroups() { $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->delete->add('cg'); $delete->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg'); $delete->from->addRightJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID.'=cg.'.Pap_Db_Table_CommissionGroups::ID); $delete->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID.'=c.'.Pap_Db_Table_Campaigns::ID); $delete->where->add('cg.'.Pap_Db_Table_CommissionGroups::IS_DEFAULT, '=', Gpf::NO); $delete->delete(); }
protected function buildFrom() { $this->_selectBuilder->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'cg.'.Pap_Db_Table_CommissionGroups::ID.'=ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'u', 'ucg.userid=u.userid'); $this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'u.accountuserid=gu.accountuserid'); $this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'au.authid=gu.authid'); }
/** * @return Gpf_SqlBuilder_SelectBuilder */ protected function createSelectBuilder() { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add("cg.".Pap_Db_Table_CommissionGroups::ID, self::ID); $select->select->add("cg.".Pap_Db_Table_CommissionGroups::NAME, self::VALUE); $select->from->add(Pap_Db_Table_CommissionGroups::getName(), 'cg'); if ($this->params->exists('campaignid')) { $select->where->add('cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $this->params->get('campaignid')); } return $select; }
private function createApproveDeclineTask(Gpf_Tasks_QuickTaskGroup $quickTaskGroup, $newStatus) { $actionRequest = new Gpf_Rpc_ActionRequest('Pap_Features_Common_AffiliateGroupForm', 'changeStatus'); $commissionGroup = Pap_Db_Table_CommissionGroups::getInstance(); $userInCommissionGroupId = $commissionGroup->getUserInCommissionGroup($this->campaign->getId(), $this->user->getId()); $actionRequest->addParam('status', $newStatus); $actionRequest->addParam('ids', new Gpf_Rpc_Array(array($userInCommissionGroupId))); $quickTask = new Gpf_Tasks_QuickTask($actionRequest); $quickTaskGroup->add($quickTask); return $quickTask->getUrl(); }
/** * @service commission read * * @param $campaignid * @return Gpf_Data_RecordSet <commissiongroupid, name, isdefault> */ public function loadCommissionGroups(Gpf_Rpc_Params $params) { $campaignId = $params->get("campaignid"); if($campaignId == "") { throw new Gpf_Exception($this->_("loadCommissionGroups: campaignId is empty")); } $commissionsGroupTable = Pap_Db_Table_CommissionGroups::getInstance(); $groups = $commissionsGroupTable->getAllCommissionGroups($campaignId); if($groups->getSize() == 0) { $this->insertDefaultCommissionGroup($campaignId); $groups = $commissionsGroupTable->getAllCommissionGroups($campaignId); } return $groups; }
private function saveCommissionGroup($campaignId, $userId, $newCommissionGroupId) { $cgTable = Pap_Db_Table_CommissionGroups::getInstance(); $oldCommissionGroupId = $cgTable->getUserCommissionGroup($campaignId, $userId); $status = Pap_Common_Constants::STATUS_APPROVED; if ($oldCommissionGroupId != null) { try { $status = Pap_Db_Table_UserInCommissionGroup::getStatus($campaignId, $userId); } catch (Gpf_DbEngine_NoRowException $e) { Gpf_Log::debug('Row in userincommissiongroup should exist for userId: '.$userId.' and campaignId: '.$campaignId); } $this->deleteUserInCommissionGroups($oldCommissionGroupId, $userId); } $commissionGroup = new Pap_Db_CommissionGroup(); $commissionGroup->setPrimaryKeyValue($newCommissionGroupId); $commissionGroup->load(); if ($commissionGroup->getIsDefault() != Gpf::YES) { $this->addUserInCommissionGroup($newCommissionGroupId, $userId, $status); } }
/** * * @param $campaignId * @param $commissionType * @param $affiliateId * @return Gpf_Data_RecordSet */ public function getAllUserCommissionTypes($campaignId = null, $commissionType = null, $affiliateId = null) { $selectBuilder = $this->getAllCommissionTypesSelect($campaignId, $commissionType); $selectBuilder->select->add(Pap_Db_Table_Campaigns::NAME, 'campaignname', 'c'); $selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'ct.'.self::CAMPAIGNID.'=c.'.Pap_Db_Table_Campaigns::ID); if (Gpf_Session::getAuthUser()->getAccountId() != Gpf_Db_Account::DEFAULT_ACCOUNT_ID) { $selectBuilder->where->add(Pap_Db_Table_Campaigns::ACCOUNTID, '=', Gpf_Session::getAuthUser()->getAccountId()); } if ($affiliateId !== null && $affiliateId !== '') { $selectBuilder->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'ct.'.self::CAMPAIGNID.'=cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID); $selectBuilder->from->addLeftJoin(Pap_Db_Table_UserInCommissionGroup::getName(), 'uicg', 'cg.'.Pap_Db_Table_CommissionGroups::ID.'=uicg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID); $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $subCondition = new Gpf_SqlBuilder_CompoundWhereCondition(); $subCondition->add('uicg.'.Pap_Db_Table_UserInCommissionGroup::USER_ID, '=', $affiliateId); $subCondition->add('uicg.'.Pap_Db_Table_UserInCommissionGroup::STATUS, '=', 'A'); $condition->addCondition($subCondition, 'OR'); $condition->add('c.'.Pap_Db_Table_Campaigns::TYPE, '=', 'P', 'OR'); $selectBuilder->where->addCondition($condition); $selectBuilder->groupBy->add('ct.'.self::ID); } return $selectBuilder->getAllRows(); }
function init() { $this->setTable(Pap_Db_Table_CommissionGroups::getInstance()); parent::init(); }
private function getCommissionGroupsSelect($campaignId = null) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add('ca.'.Pap_Db_Table_Campaigns::ID); $select->select->add('cg.'.Pap_Db_Table_CommissionGroups::ID); $select->select->add('cg.'.Pap_Db_Table_CommissionGroups::NAME); $select->from->add(Pap_Db_Table_Campaigns::getName(), 'ca'); $select->from->addInnerJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'ca.'.Pap_Db_Table_Campaigns::ID.'=cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID); if ($campaignId != null) { $select->where->add('cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $campaignId); } return $select; }
private function getCommissionGroups() { $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(Pap_Db_Table_CommissionGroups::ID, Pap_Db_Table_CommissionGroups::ID); $selectBuilder->select->add(Pap_Db_Table_CommissionGroups::IS_DEFAULT, Pap_Db_Table_CommissionGroups::IS_DEFAULT); $selectBuilder->select->add(Pap_Db_Table_CommissionGroups::NAME, Pap_Db_Table_CommissionGroups::NAME); $selectBuilder->select->add(Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, Pap_Db_Table_CommissionGroups::CAMPAIGN_ID); $selectBuilder->from->add(Pap_Db_Table_CommissionGroups::getName()); return $selectBuilder; }
private function addCampaignFilterToSelect(Gpf_Common_SelectBuilderCompoundRecord $selectRecord, $campaignId){ $select = $selectRecord->getSelectBuilder(); $select->where->add('cg.campaignid','=',$campaignId); $select->from->addLeftJoin(Pap_Db_Table_UserInCommissionGroup::getName(),'uic','uic.userid=u.userid'); $select->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(),'cg','cg.commissiongroupid=uic.commissiongroupid'); $select->groupBy->add('u.userid'); }
protected function buildFrom(){ $this->_selectBuilder->from->add(Pap_Db_Table_CommissionGroups::getName(), 'cg'); }
public static function getStatus($campaignId, $userId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Pap_Db_Table_UserInCommissionGroup::STATUS); $select->from->add(Pap_Db_Table_CommissionGroups::getName(), 'cg'); $select->from->addInnerJoin(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg', 'cg.'.Pap_Db_Table_CommissionGroups::ID.'=ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID); $select->where->add('cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $campaignId); $select->where->add('ucg.'.Pap_Db_Table_UserInCommissionGroup::USER_ID, '=', $userId); $row = $select->getOneRow(); return $row->get(Pap_Db_Table_UserInCommissionGroup::STATUS); }
protected function getAffiliateID($offset) { $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add(Pap_Db_Table_Users::ID, '', 'pu'); if ($this->campaignType != Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC) { $selectBuilder->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg'); $selectBuilder->from->addInnerJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'cg.'.Pap_Db_Table_CommissionGroups::ID.'=ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID); $selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 'pu.'.Pap_Db_Table_Users::ID.'=ucg.'.Pap_Db_Table_UserInCommissionGroup::USER_ID); $selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'u', 'u.'.Gpf_Db_Table_Users::ID.'=pu.'.Pap_Db_Table_Users::ACCOUNTUSERID); $selectBuilder->where->add('cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $this->campaignId); } else { $selectBuilder->from->add(Pap_Db_Table_Users::getName(), 'pu'); $selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'u', 'u.'.Gpf_Db_Table_Users::ID.'=pu.'.Pap_Db_Table_Users::ACCOUNTUSERID); $selectBuilder->where->add('pu.' . Pap_Db_Table_Users::TYPE, '=', Pap_Application::ROLETYPE_AFFILIATE); $selectBuilder->where->add('u.'.Gpf_Db_Table_Users::STATUS, '=', Gpf_Db_User::APPROVED); $selectBuilder->where->add('pu.'.Pap_Db_Table_Users::DELETED, '=', Gpf::NO); } $selectBuilder->where->add('pu.' . Pap_Db_Table_Users::TYPE, '=', Pap_Application::ROLETYPE_AFFILIATE); $selectBuilder->where->add('u.'.Gpf_Db_Table_Users::STATUS, '=', Gpf_Db_User::APPROVED); $selectBuilder->where->add('pu.'.Pap_Db_Table_Users::DELETED, '=', Gpf::NO); $selectBuilder->limit->set($offset, 1); return $selectBuilder->getOneRow()->get(Pap_Db_Table_Users::ID); }