/** * 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)); } }