1 <?php 

     2 

     3 class homepageComponents extends sfComponents

     4 {

     5   public function executeLeftPanel() {

     6 

     7   }

     8   public function executeSearch() {

     9 

    10   }

    11   public function executeTagList() {

    12 	

    13   }

    14   

    15   public function executeRandomFilm() {

    16 	

    17   }

    18   

    19   public function executeLastTaggedList() {

    20 	$query = Doctrine_Query::create()

    21       ->from('ThdFilm F')

    22       ->leftJoin('F.images I ')

    23       ->leftJoin('F.videos V')

    24       //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'")

    25       ->orderBy('F.id DESC')

    26       ->limit(0,10);

    27     $this->lastTaggedFilms = $query->execute();

    28     $this->videoPath = sfConfig::get('app_player_videoPath');

    29     

    30   }

    31   public function executeMostTaggedList() {

    32 	$query = Doctrine_Query::create()

    33       ->from('ThdFilm F')

    34       ->leftJoin('F.images I ')

    35       ->leftJoin('F.videos V')

    36       //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'")

    37       ->orderBy('F.ref ASC')

    38       ->limit(0,10);

    39     $this->mostTaggedFilms = $query->execute();

    40     $this->videoPath = sfConfig::get('app_player_videoPath');

    41   }

    42 }