<?php 

class homepageComponents extends sfComponents
{
  public function executeLeftPanel() {

  }
  public function executeSearch() {

  }
  public function executeTagList() {
	
  }
  
  public function executeRandomFilm() {
	
  }
  
  public function executeLastTaggedList() {
	$query = Doctrine_Query::create()
      ->from('ThdFilm F')
      ->leftJoin('F.images I ')
      ->leftJoin('F.videos V')
      //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'")
      ->orderBy('F.id DESC')
      ->limit(0,10);
    $this->lastTaggedFilms = $query->execute();
    $this->videoPath = sfConfig::get('app_player_videoPath');
    
  }
  public function executeMostTaggedList() {
	$query = Doctrine_Query::create()
      ->from('ThdFilm F')
      ->leftJoin('F.images I ')
      ->leftJoin('F.videos V')
      //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'")
      ->orderBy('F.ref ASC')
      ->limit(0,10);
    $this->mostTaggedFilms = $query->execute();
    $this->videoPath = sfConfig::get('app_player_videoPath');
  }
}