/**
*
* @service banner_stats read
* @param $data
*/
public function loadFullStatistics(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->from->add(Pap_Db_Table_Banners::getName());
$select->select->add("COUNT(".Pap_Db_Table_Banners::ID.")", "count");
$select->select->add(Pap_Db_Table_Banners::TYPE, 'type');
$select->groupBy->add(Pap_Db_Table_Banners::TYPE);
Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyWhere',
new Gpf_Common_SelectBuilderCompoundRecord($select, new Gpf_Data_Record(array(), array())));
$result = $select->getAllRowsIndexedBy('type');
$bannerTypes = explode(',', $data->getParam('bannerTypes'));
$bannersCount = 0;
foreach ($bannerTypes as $bannerType) {
$bannerTypeCount = 0;
try {
$bannerTypeCount = $result->getRecord($bannerType)->get('count');
} catch (Gpf_Data_RecordSetNoRowException $e) {
}
$data->setValue($bannerType, "$bannerTypeCount");
$bannersCount += $bannerTypeCount;
}
$data->setValue("bannersCount", "$bannersCount");
return $data;
}
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);
}
private function updateWrapper($bannerTypes, $dataField) {
$update = new Gpf_SqlBuilder_UpdateBuilder();
$update->from->add(Pap_Db_Table_Banners::getName());
$update->set->add(Pap_Db_Table_Banners::WRAPPER_ID, 'script');
$update->where->add(Pap_Db_Table_Banners::TYPE, 'IN', $bannerTypes);
$update->where->add($dataField, '=', Gpf::YES);
$update->execute();
}
protected function buildFrom() {
parent::buildFrom();
$onCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
$onCondition->add('c.'.Pap_Db_Table_Campaigns::ID, '=', 'b.'.Pap_Db_Table_Banners::CAMPAIGN_ID, 'AND', false);
$onCondition->add('b.'.Pap_Db_Table_Banners::STATUS, '=', Pap_Db_Banner::STATUS_ACTIVE);
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', $onCondition->toString());
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Affiliates.Campaigns.buildFrom', $this->_selectBuilder);
}
protected function buildFrom() {
$this->_selectBuilder->from->add(Pap_Db_Table_DirectLinkUrls::getName(), "l");
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), "pu", "l.userid = pu.userid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "pu.accountuserid = gu.accountuserid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Channels::getName(), "ch", "ch.channelid = l.channelid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), "b", "b.bannerid = l.bannerid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Campaigns::getName(), "c", "c.campaignid = l.campaignid");
}
/**
* Returns banner object
*
* @throws Gpf_DbEngine_NoRowException
* @param string $bannerId banner ID
* @return Pap_Common_Banner
*/
public function getBanner($bannerId) {
if ($bannerId == '') {
throw new Pap_Common_Banner_NotFound($bannerId);
}
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->from->add(Pap_Db_Table_Banners::getName());
$select->select->addAll(Pap_Db_Table_Banners::getInstance());
$select->where->add(Pap_Db_Table_Banners::ID, '=', $bannerId);
return $this->getBannerFromRecord($select->getOneRow());
}
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);
}
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createSelectBuilder() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('SUBSTRING('.Pap_Db_Table_Banners::SIZE.',2)', self::ID);
$selectBuilder->select->add('SUBSTRING('.Pap_Db_Table_Banners::SIZE.',2)', self::VALUE);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName());
$selectBuilder->where->add(Pap_Db_Table_Banners::SIZE, '!=', Pap_Db_Banner::SIZE_NOTAPPLICABLE);
$selectBuilder->groupBy->add(self::VALUE);
return $selectBuilder;
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createSelectBuilder() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::ID, self::ID);
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::NAME, self::VALUE);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName(), 'b');
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.BannerListbox.getBannerSelect', $selectBuilder);
return $selectBuilder;
}
protected function buildFrom() {
$this->_selectBuilder->from->addSubselect($this->rawClicksSelect, "rc");
$onCondition = "rc.".Pap_Db_Table_RawClicks::CAMPAIGNID." = c.".Pap_Db_Table_Campaigns::ID;
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', $onCondition);
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', "rc.bannerid = b.bannerid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'pb', "rc.parentbannerid = pb.bannerid");
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), "pu", "rc.userid = pu.userid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "pu.accountuserid = gu.accountuserid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Channels::getName(), 'ch', 'ch.channelid=rc.channel');
}
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));
}
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createSelectBuilder() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('DISTINCT('.'b.'.Pap_Db_Table_Banners::DESTINATION_URL.')', self::ID);
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::DESTINATION_URL, self::VALUE);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName(), 'b');
$selectBuilder->where->add('b.'.Pap_Db_Table_Banners::DESTINATION_URL, '<>', 'NULL');
$selectBuilder->where->add('b.'.Pap_Db_Table_Banners::DESTINATION_URL, '<>', '');
if (Gpf_Session::getAuthUser()->getRoleTypeId() == Pap_Application::ROLETYPE_AFFILIATE) {
$selectBuilder->where->add('b.'.Pap_Db_Table_Banners::STATUS, '<>', Pap_Db_Banner::STATUS_HIDDEN);
}
$selectBuilder->orderBy->add(Pap_Db_Table_Banners::DESTINATION_URL);
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.BannerListbox.getBannerSelect', $selectBuilder);
return $selectBuilder;
}
public function getPendingDirectLinksCount() {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add('l.'.Pap_Db_Table_DirectLinkUrls::ID);
$select->from->add(Pap_Db_Table_DirectLinkUrls::getName(), 'l');
$select->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', 'b.'.Pap_Db_Table_Banners::ID.' = l.'.Pap_Db_Table_DirectLinkUrls::BANNER_ID);
$select->from->addLeftJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'c.'.Pap_Db_Table_Campaigns::ID.' = l.'.Pap_Db_Table_DirectLinkUrls::CAMPAIGN_ID);
$select->where->add('l.'.Pap_Db_Table_DirectLinkUrls::STATUS, "=", self::PENDING);
Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.directLinksModifyWhere', $select);
$result = $select->getAllRows();
return $result->getSize();
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createBannersSelect(Gpf_Rpc_Params $params) {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::ID, self::ID);
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::NAME, self::VALUE);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName(), 'b');
$cond = new Gpf_SqlBuilder_CompoundWhereCondition();
$cond->add('b.'.Pap_Db_Table_Banners::STATUS, '=', 'A');
$cond->add('b.'.Pap_Db_Table_Banners::STATUS, '=', 'H','OR');
$selectBuilder->where->addCondition($cond,'AND');
if ($params->get('campaignid') != '') {
$selectBuilder->where->add('b.'.Pap_Db_Table_Banners::CAMPAIGN_ID, '=', $params->get('campaignid'));
}
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.BannerListbox.getBannerSelect', $selectBuilder);
return $selectBuilder;
}
private function getBanners() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add(Pap_Db_Table_Banners::ID, Pap_Db_Table_Banners::ID);
$selectBuilder->select->add(Pap_Db_Table_Banners::ACCOUNT_ID, Pap_Db_Table_Banners::ACCOUNT_ID);
$selectBuilder->select->add(Pap_Db_Table_Banners::CAMPAIGN_ID, Pap_Db_Table_Banners::CAMPAIGN_ID);
$selectBuilder->select->add(Pap_Db_Table_Banners::TYPE, Pap_Db_Table_Banners::TYPE);
$selectBuilder->select->add(Pap_Db_Table_Banners::STATUS, Pap_Db_Table_Banners::STATUS);
$selectBuilder->select->add(Pap_Db_Table_Banners::NAME, Pap_Db_Table_Banners::NAME);
$selectBuilder->select->add(Pap_Db_Table_Banners::DESTINATION_URL, Pap_Db_Table_Banners::DESTINATION_URL);
$selectBuilder->select->add(Pap_Db_Table_Banners::DATEINSERTED, Pap_Db_Table_Banners::DATEINSERTED);
$selectBuilder->select->add(Pap_Db_Table_Banners::SIZE, Pap_Db_Table_Banners::SIZE);
$selectBuilder->select->add(Pap_Db_Table_Banners::DATA1, Pap_Db_Table_Banners::DATA1);
$selectBuilder->select->add(Pap_Db_Table_Banners::DATA2, Pap_Db_Table_Banners::DATA2);
$selectBuilder->select->add(Pap_Db_Table_Banners::DATA3, Pap_Db_Table_Banners::DATA3);
$selectBuilder->select->add(Pap_Db_Table_Banners::DATA4, Pap_Db_Table_Banners::DATA4);
$selectBuilder->select->add(Pap_Db_Table_Banners::ORDER, Pap_Db_Table_Banners::ORDER);
$selectBuilder->select->add(Pap_Db_Table_Banners::DESCRIPTION, Pap_Db_Table_Banners::DESCRIPTION);
$selectBuilder->select->add(Pap_Db_Table_Banners::SEOSTRING, Pap_Db_Table_Banners::SEOSTRING);
$selectBuilder->select->add(Pap_Db_Table_Banners::WRAPPER_ID, Pap_Db_Table_Banners::WRAPPER_ID);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName());
return $selectBuilder;
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createSelectBuilder() {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::ID, self::ID);
$selectBuilder->select->add('b.'.Pap_Db_Table_Banners::NAME, self::VALUE);
$selectBuilder->from->add(Pap_Db_Table_Banners::getName(), 'b');
$selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'camp', 'b.'.Pap_Db_Table_Banners::CAMPAIGN_ID.'=camp.'.Pap_Db_Table_Campaigns::ID);
$cond = new Gpf_SqlBuilder_CompoundWhereCondition();
$cond->add('b.'.Pap_Db_Table_Banners::STATUS, '=', 'A');
$cond->add('b.'.Pap_Db_Table_Banners::STATUS, '=', 'H','OR');
$selectBuilder->where->addCondition($cond,'AND');
$selectBuilder->where->add('camp.'.Pap_Db_Table_Campaigns::STATUS, 'IN',
array(Pap_Db_Campaign::CAMPAIGN_STATUS_ACTIVE, Pap_Db_Campaign::CAMPAIGN_STATUS_STOPPED));
if ($this->params->get('campaignid') != '') {
$selectBuilder->where->add('b.'.Pap_Db_Table_Banners::CAMPAIGN_ID, '=', $this->params->get('campaignid'));
}
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.BannerListbox.getBannerSelect', $selectBuilder);
$this->onBannerSelectBuilderCreated($selectBuilder);
return $selectBuilder;
}
public function onDeactivate() {
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_Banners::getName());
$delete->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_SiteReplication_Config::BannerTypeSite);
$delete->execute();
}
protected function init()
{
$this->setTable(Pap_Db_Table_Banners::getInstance());
parent::init();
}
/**
* @return Gpf_SqlBuilder_SelectBuilder
*/
private function getCouponBannersSelect() {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(Pap_Db_Table_Banners::ID, "id");
$select->select->add(Pap_Db_Table_Banners::NAME, "name");
$select->from->add(Pap_Db_Table_Banners::getName());
$select->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_Coupon_Coupon::TYPE_COUPON);
$select->orderBy->add(Pap_Db_Table_Banners::NAME);
return $select;
}
public static function getInstance() {
if(self::$instance === null) {
self::$instance = new self;
}
return self::$instance;
}
protected function buildFrom() {
$this->_selectBuilder->from->add(Pap_Db_Table_BannersInRotators::getName());
$condition = Pap_Db_Table_BannersInRotators::getName().".".Pap_Db_Table_BannersInRotators::ROTATED_BANNER_ID." = ".Pap_Db_Table_Banners::getName().".".Pap_Db_Table_Banners::ID;
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Banners::getName(), '', $condition);
}
public function onDeactivate() {
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_Banners::getName());
$delete->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_PagePeelBanner_Handler::TYPE);
$delete->execute();
}
protected function buildFrom() {
$this->_selectBuilder->from->add(Pap_Db_Table_VisitorAffiliates::getName(), "va");
$onCondition = "va.".Pap_Db_Table_VisitorAffiliates::CAMPAIGNID." = c.".Pap_Db_Table_Campaigns::ID;
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Campaigns::getName(), 'c', $onCondition);
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), "pu", "va.userid = pu.userid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "pu.accountuserid = gu.accountuserid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Channels::getName(), "ch", "va.channelid = ch.channelid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', 'b.bannerid = va.bannerid');
Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyFrom',
new Gpf_Common_SelectBuilderCompoundRecord($this->_selectBuilder,
new Gpf_Data_Record(array('joinedAlias', 'onJoinAlias'), array('a', 'va'))));
}
function buildFrom() {
$this->_selectBuilder->from->add(Pap_Db_Table_Transactions::getName(), "t");
$onCondition = "t.".Pap_Db_Table_Transactions::CAMPAIGN_ID." = c.".Pap_Db_Table_Campaigns::ID;
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Campaigns::getName(), 'c', $onCondition);
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), "pu", "t.userid = pu.userid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "pu.accountuserid = gu.accountuserid");
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Channels::getName(), "ch", "t.channel = ch.channelid");
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_CommissionTypes::getName(), "ct", "t.commtypeid = ct.commtypeid");
$this->_selectBuilder->from->addLeftJoin(Gpf_Db_Table_Currencies::getName(), 'cs', 't.originalcurrencyid = cs.currencyid');
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', 'b.bannerid = t.bannerid');
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_PayoutsHistory::getName(), 'ph',
'ph.'.Pap_Db_Table_PayoutsHistory::ID.' = t.'.Pap_Db_Table_Transactions::PAYOUTHISTORY_ID);
}
/**
* @params $preffix table preffix (without .)
*/
public function addTo(Gpf_SqlBuilder_SelectBuilder $select, $preffix = '') {
$preffix = rtrim($preffix, '.');
if ($preffix == 'b') {
throw new Gpf_Exception('Table preffix in Pap_Stats_Params::addTo() can not be \'b\'');
}
if ($preffix != '') {
$preffix .= '.';
}
if ($this->isCampaignIdDefined()) {
$select->where->add($preffix.Pap_Stats_Table::CAMPAIGNID, '=', $this->getCampaignId());
}
if ($this->isOrderIdDefined()) {
if (is_array($this->getOrderId())) {
$select->where->add($preffix.Pap_Stats_Table::ORDERID, 'IN', $this->getOrderId());
} else {
$select->where->add($preffix.Pap_Stats_Table::ORDERID, '=', $this->getOrderId());
}
}
if($this->isAffiliateIdDefined()) {
$select->where->add($preffix.Pap_Stats_Table::USERID, '=', $this->getAffiliateId());
}
if ($this->isCountryCodeDefined()) {
$select->where->add($preffix.Pap_Stats_Table::COUNTRYCODE, '=', $this->getCountryCode());
}
if($this->isBannerIdDefined()) {
$select->where->addCondition($this->createBannerCondition($preffix));
}
if($this->isChannelDefined()) {
$select->where->add($preffix.Pap_Stats_Table::CHANNEL, '=', $this->getChannel());
}
if ($this->isDestinationURLDefined()) {
$select->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', $preffix.Pap_Stats_Table::BANNERID.'=b.'.Pap_Db_Table_Banners::ID);
$select->where->add('b.'.Pap_Db_Table_Banners::DESTINATION_URL, '=', $this->getDestinationURL());
}
if ($this->isDateFromDefined()) {
$select->where->add($preffix.Pap_Stats_Table::DATEINSERTED, '>=', $this->getDateFrom()->toDateTime());
}
if ($this->isDateToDefined()) {
$select->where->add($preffix.Pap_Stats_Table::DATEINSERTED, '<=', $this->getDateTo()->toDateTime());
}
if ($this->isDateApprovedFromDefined()) {
$select->where->add($preffix.Pap_Stats_Table::DATEAPPROVED, '>=', $this->getDateApprovedFrom()->toDateTime());
}
if ($this->isDateApprovedToDefined()) {
$select->where->add($preffix.Pap_Stats_Table::DATEAPPROVED, '<=', $this->getDateApprovedTo()->toDateTime());
}
if ($this->isAccountIdDefined()) {
$select->where->add($preffix.Pap_Stats_Table::ACCOUNTID, '=', $this->getAccountId());
}
}
public function onDeactivate() {
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_Banners::getName());
$delete->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_RebrandPdfBanner_Config::TYPE);
$delete->execute();
}
/**
* @return Pap_Features_SiteReplication_Site
*/
private function loadSite($siteId) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->from->add(Pap_Db_Table_Banners::getName());
$select->select->addAll(Pap_Db_Table_Banners::getInstance());
$whereCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
$whereCondition->add(Pap_Db_Table_Banners::ID, '=', $siteId, 'OR');
$whereCondition->add(Pap_Db_Table_Banners::DATA1, '=', 'D'.$siteId, 'OR');
$select->where->addCondition($whereCondition);
$select->where->add(Pap_Db_Table_Banners::TYPE, '=', Pap_Features_SiteReplication_Config::BannerTypeSite);
try {
$bannerFactory = new Pap_Common_Banner_Factory();
return $bannerFactory->getBannerFromRecord($select->getOneRow());
} catch (Gpf_Exception $e) {
throw new Gpf_Exception($this->_sys('Replicated site \'%s\' does not exist', $siteId));
}
}
