qzBannerPlugin - components.class.php

<?php
/**
 * qzBanner Component
 *
 * @author Enkuso
 */
class qzBannerComponents extends sfComponents{
    public function executeBanner(){
        if($this->location){
            $this->banner = Doctrine_Core::getTable('qzBanner')
                    ->createQuery('b')
                    ->leftJoin('b.qzBannerLocation l')
                    ->where('l.location = ?', $this->location)
                    ->orderBy('b.created_at DESC')
                    ->limit(1)
                    ->fetchOne();
        }
    }
}