thd/apps/frontend/modules/homepage/actions/components.class.php
changeset 35 94a1dc255022
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/thd/apps/frontend/modules/homepage/actions/components.class.php	Tue Sep 22 16:40:38 2009 +0200
@@ -0,0 +1,42 @@
+<?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');
+  }
+}
\ No newline at end of file