private function updateAccountOfBanners(Pap_Db_Campaign $dbCampaign) {
$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::CAMPAIGN_ID, '=', $dbCampaign->getId());
$banner = new Pap_Db_Banner();
$bannersCollection = $banner->loadCollectionFromRecordset($select->getAllRows());
foreach ($bannersCollection as $banner) {
$banner->update(array(Pap_Db_Table_Banners::ACCOUNT_ID));
}
}
private function disableActionCommissionInCampaigns() {
$campaign = new Pap_Db_Campaign();
$campaigns = $campaign->loadCollection();
foreach ($campaigns as $campaign) {
$commissionType = new Pap_Db_CommissionType();
$commissionType->setCampaignId($campaign->getId());
$commissionType->setType(Pap_Common_Constants::TYPE_ACTION);
$commTypeCollection = $commissionType->loadCollection();
foreach ($commTypeCollection as $commTypeRow) {
$commTypeRow->setStatus(Pap_Db_CommissionType::STATUS_DISABLED);
$commTypeRow->save();
}
}
}
private function addCpmCommissionToCampaigns() {
$campaign = new Pap_Db_Campaign();
$campaigns = $campaign->loadCollection();
foreach ($campaigns as $campaign) {
$commissionType = new Pap_Db_CommissionType();
$commissionType->setCampaignId($campaign->getId());
$commissionType->setType(Pap_Common_Constants::TYPE_CPM);
try {
$commissionType->loadFromData();
} catch (Gpf_DbEngine_NoRowException $e) {
$commissionType->setStatus(Pap_Db_CommissionType::STATUS_DISABLED);
$commissionType->setRecurrencePresetId(Pap_Db_CommissionType::RECURRENCE_NONE);
$commissionType->setApproval(Pap_Db_CommissionType::APPROVAL_AUTOMATIC);
$commissionType->setZeroOrdersCommission(Gpf::NO);
$commissionType->setSaveZeroCommission(Gpf::NO);
$commissionType->insert();
}
}
}
public static function getDefaultCampaignId($accountId = null) {
if ($accountId == null) {
$accountId = Gpf_Db_Account::DEFAULT_ACCOUNT_ID;
}
$campaign = new Pap_Db_Campaign();
$campaign->setAccountId($accountId);
$campaign->setIsDefault();
try {
$campaign->loadFromData(array(self::ACCOUNTID, self::IS_DEFAULT));
return $campaign->getId();
} catch (Gpf_Exception $e) {
}
return null;
}
private function setSplitCommissionsBonus(Pap_Db_Campaign $campaign) {
$commissionType = new Pap_Db_CommissionType();
$commissionType->setCampaignId($campaign->getId());
$commissionType->setType(Pap_Common_Constants::TYPE_SALE);
$commissionType->loadFromData(array(Pap_Db_Table_CommissionTypes::CAMPAIGNID, Pap_Db_Table_CommissionTypes::TYPE));
$overwriteCookie = $campaign->getOverwriteCookie();
if ($overwriteCookie != Gpf::YES && $overwriteCookie != Gpf::NO) {
$overwriteCookie = $this->isGeneralOverwriteAllowed();
}
if ($overwriteCookie == Gpf::YES) {
$firstClickBonus = 0;
$lastClickBonus = 100;
} else {
$firstClickBonus = 100;
$lastClickBonus = 0;
}
Pap_Db_Table_CommissionTypeAttributes::getInstance()->setCommissionTypeAttributeValue($commissionType->getId(), Pap_Features_SplitCommissions_SplitCommissionsForm::FIRST_AFF_BONUS, $firstClickBonus);
Pap_Db_Table_CommissionTypeAttributes::getInstance()->setCommissionTypeAttributeValue($commissionType->getId(), Pap_Features_SplitCommissions_SplitCommissionsForm::LAST_AFF_BONUS, $lastClickBonus);
}
