/** * Returns an instance of class (singleton pattern implementation). * * @return ADS_BOL_BannerLocationDao */ public static function getInstance() { if (self::$classInstance === null) { self::$classInstance = new self(); } return self::$classInstance; }
public function findPlaceBannerList($pluginKey, $position, $location = null) { $query = "SELECT `b`.* FROM `" . $this->getTableName() . "` AS `b`\n LEFT JOIN `" . ADS_BOL_BannerPositionDao::getInstance()->getTableName() . "` AS `bp` ON (`b`.`id` = `bp`.`" . ADS_BOL_BannerPositionDao::BANNER_ID . "`)\n LEFT JOIN `" . ADS_BOL_BannerLocationDao::getInstance()->getTableName() . "` AS `bl` ON (`b`.`id` = `bl`.`" . ADS_BOL_BannerLocationDao::BANNER_ID . "`)\n WHERE `bp`.`" . ADS_BOL_BannerPositionDao::POSITION . "` = :position AND `bp`.`" . ADS_BOL_BannerPositionDao::PLUGIN_KEY . "` IN ( :pluginKey, 'base' )\n AND ( `bl`.`" . ADS_BOL_BannerLocationDao::LOCATION . "` IS NULL" . ($location === null ? ')' : " OR `bl`.`" . ADS_BOL_BannerLocationDao::LOCATION . "` = :location)"); $params = array('pluginKey' => $pluginKey, 'position' => $position); if ($location != null) { $params['location'] = $location; } return $this->dbo->queryForObjectList($query, $this->getDtoClassName(), $params, 3600 * 24, array(self::CACHE_TAG_ADS_BANNERS, OW_CacheManager::TAG_OPTION_INSTANT_LOAD)); }
public function deleteBanner($bannerId) { $this->bannerDao->deleteById($bannerId); $this->bannerLocationDao->deleteByBannerId($bannerId); $this->bannerPositionDao->deleteByBannerId($bannerId); }