/**
* 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);
}
}
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));
}
}
protected function init()
{
$this->setTable(Pap_Db_Table_Banners::getInstance());
parent::init();
}
/**
* @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));
}
}
