# HG changeset patch
# User ymh <ymh.work@gmail.com>
# Date 1268418141 -3600
# Node ID 28c8f4908e3f3698d5a671937f0ce35674b43b6f
# Parent  8f7f6284556267ae61825daad3844358e96af6ba
add solr search

diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/config/app.yml
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/thdProject/apps/frontend/config/app.yml	Fri Mar 12 19:22:21 2010 +0100
@@ -0,0 +1,11 @@
+# default values
+all:
+   storage:
+      #segmentation files
+      uploads: "/Users/ymh/dev/workspace/mosatags/web/thdProject/web/uploads"
+      format: ".csv"
+    
+   player:
+     videoPath: "videos/"
+
+#dev:
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/modules/homepage/actions/actions.class.php
--- a/web/thdProject/apps/frontend/modules/homepage/actions/actions.class.php	Wed Mar 10 17:19:00 2010 +0100
+++ b/web/thdProject/apps/frontend/modules/homepage/actions/actions.class.php	Fri Mar 12 19:22:21 2010 +0100
@@ -21,5 +21,17 @@
   {      
   return sfView::SUCCESS;
   }
- 
+  
+/**
+ * Execute search action
+ * 
+ * @param sfRequest $request A request object
+ */  
+  public function executeSearch(sfWebRequest $request)
+  {
+    return sfView::SUCCESS;
+    
+  }
+  
+  
 }
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/modules/homepage/actions/components.class.php
--- a/web/thdProject/apps/frontend/modules/homepage/actions/components.class.php	Wed Mar 10 17:19:00 2010 +0100
+++ b/web/thdProject/apps/frontend/modules/homepage/actions/components.class.php	Fri Mar 12 19:22:21 2010 +0100
@@ -39,4 +39,46 @@
     $this->mostTaggedFilms = $query->execute();
     $this->videoPath = sfConfig::get('app_player_videoPath');
   }
+  
+  public function executeResultList(sfWebRequest $request) {
+  	
+  	$text = $request->getParameter('text');
+  	
+  	$event = $this->dispatcher->notify(new sfEvent($this, 'uvmc_solr.search', array('query' => $text)));
+    $response = $event->getReturnValue();
+    // solr is configured to give you back a serialized php array
+    $rawResp = $response->getRawResponse();
+    $results = unserialize($rawResp);
+
+    
+
+    $primaryKeys = array();
+    foreach($results['response']['docs'] as $doc)
+    {
+    	if($doc['uniqueid'])
+    	{
+            $primaryKeys[] = $doc['uniqueid'];
+    	}
+    }
+
+    if(!empty($primaryKeys))
+    {
+      $this->searchResult = Doctrine::getTable('ThdFilm')->findByScoredId($primaryKeys);
+      $this->searchCount = $this->searchResult->count();
+    }
+    else
+    {
+      $this->searchResult = array();
+      $this->searchCount = 0;
+    }
+  	
+  	
+    /*$query = Doctrine_Query::create()
+      ->from('ThdFilm F')
+      ->leftJoin('F.images I ')
+      ->leftJoin('F.videos V')
+      ->orderBy('F.id DESC')
+      ->limit(0,10);
+    $this->searchResult = $query->execute();*/
+  }
 }
\ No newline at end of file
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/modules/homepage/templates/_resultList.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/thdProject/apps/frontend/modules/homepage/templates/_resultList.php	Fri Mar 12 19:22:21 2010 +0100
@@ -0,0 +1,53 @@
+<div id="resultList">
+	<h3 class="head">Films resultats de la recherche</h3>
+	<h3 class="head">Search length : <?php echo $searchCount ?></h3>
+	<ul>
+	<?php 
+	foreach($searchResult as $item): 
+		$ref = $item->getRef();
+		$slug = $item->getSlugUrl();
+		$title = $item->getTitle();
+		
+		// image file
+		$image_file = $item->getImages();
+		// image file
+		$video_file = $item->getVideos();
+		// directors list
+		$directors = json_decode($item->getDirectors(), true);
+	?>
+	<li>	
+		<div id="playerMostTagged-<?php echo $ref; ?>" class="player-item" style="background:transparent url('posters/<?php echo $image_file[0]['file'].".jpg"; ?>') no-repeat;" href="<?php echo 	$videoPath.$video_file[0]['file'].".f4v";?>"">
+			<div class="infos">
+		    	<a href="<?php echo url_for('@editor?ref='.$ref.'&film_slug='.$slug); ?>" class="title"><?php echo $title; ?></a> <span class="film-infos">De <?php echo $directors['name']; ?></span><
+		    </div>
+		    <a href="#"><img src="images/buttons/btn_play.png"/ id="play"></a>
+		     <div class="tags">		    	
+				<ul class="item-list tag-list">   
+				<li><span class="head">
+			    <i>Tags liés au film :</i>
+				</span></li>
+				 <li class="tag-score-1">
+				    <a href="">anna</a>
+				  </li><li class="tag-score-5">
+				    <a href="">Jalousie</a>
+				  </li><li class="tag-score-3">
+				    <a href="">erotomanie</a>
+				  </li><li class="tag-score-2">
+				    <a href="">violence</a>
+				  </li>
+				  <li class="tag-score-2">
+				    <a href="">anna</a>
+				  </li><li class="tag-score-5">
+				    <a href="">Jalousie</a>
+				  </li><li class="tag-score-3">
+				    <a href="">erotomanie</a>
+				  </li><li class="tag-score-2">
+				    <a href="">violence</a>
+				  </li>				 
+				</ul>
+		    </div>	    
+		</div>	
+	</li>
+	<?php endforeach; ?>
+	</ul>	
+</div>	
\ No newline at end of file
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/modules/homepage/templates/_search.php
--- a/web/thdProject/apps/frontend/modules/homepage/templates/_search.php	Wed Mar 10 17:19:00 2010 +0100
+++ b/web/thdProject/apps/frontend/modules/homepage/templates/_search.php	Fri Mar 12 19:22:21 2010 +0100
@@ -2,7 +2,7 @@
 	<h3 class="head">
     Recherche classique :
 	</h3>
-  <form name="search-form" id="search-form" method="get" action="">
+  <form name="search-form" id="search-form" method="get" action="<?php echo url_for('homepage/search') ?>">
     <input type="text" name="text" value="tapez votre recherche..." class="field help search" />
     <button type="submit" class="submit">chercher</button>
   </form>
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/apps/frontend/modules/homepage/templates/searchSuccess.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/thdProject/apps/frontend/modules/homepage/templates/searchSuccess.php	Fri Mar 12 19:22:21 2010 +0100
@@ -0,0 +1,27 @@
+
+<div id="homepage">
+	<?php include_partial('partials/navigation')?>
+	<div id="document-sidebar">
+		<?php include_component( "homepage", "leftPanel" ) ?>
+	</div>
+	<div id="document">
+		<?php include_component( "homepage", "randomFilm" ) ?>
+		<?php include_component( "homepage", "resultList" ) ?>		
+	</div>
+</div>
+<script language="JavaScript">
+	// a very simple setup
+	flowplayer("div.player-item", "flashes/flowplayer-3.1.3.swf",
+	{
+		// configuration for a clip
+			clip: {
+				autoPlay: true,
+		    	autoBuffering: true,
+		    	scaling: 'fit',
+			},
+			// setup controlbar to use skins
+			plugins: {
+			  	controls: conf.skins.universcine
+			}
+	});
+</script>
\ No newline at end of file
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/config/databases.yml
--- a/web/thdProject/config/databases.yml	Wed Mar 10 17:19:00 2010 +0100
+++ b/web/thdProject/config/databases.yml	Fri Mar 12 19:22:21 2010 +0100
@@ -4,4 +4,4 @@
     param:
       dsn: 'mysql:host=localhost;dbname=thd'
       username: root
-      password: null
+      password: root
diff -r 8f7f62845562 -r 28c8f4908e3f web/thdProject/lib/model/doctrine/ThdFilmTable.class.php
--- a/web/thdProject/lib/model/doctrine/ThdFilmTable.class.php	Wed Mar 10 17:19:00 2010 +0100
+++ b/web/thdProject/lib/model/doctrine/ThdFilmTable.class.php	Fri Mar 12 19:22:21 2010 +0100
@@ -5,4 +5,17 @@
 class ThdFilmTable extends Doctrine_Table
 {
 
+    public function findByScoredId($ids)
+    {
+      $query = $this->createQuery('p');
+      $query->select('p.*')
+            ->whereIn('p.uniqueid', $ids)
+            // Keep scoring
+            // http://groups.google.com/group/symfony-users/browse_thread/thread/92adb0332dfe1065/ee7b8c0d27208368?lnk=gst&q=zend+search+sort#ee7b8c0d27208368
+            ->addSelect('FIELD(p.uniqueid,\''.implode('\', \'', $ids).'\') AS field')
+            ->orderBy('field');
+
+      return $query->execute();
+    }
+	
 }
\ No newline at end of file