add rating feature

git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 154 insertions, 59 deletions

diff --git a/picture.php b/picture.php
index 891510b9f..9e15f5ce3 100644
--- a/picture.php
+++ b/picture.php
@@ -25,7 +25,8 @@
 // | USA.                                                                  |
 // +-----------------------------------------------------------------------+
 
-//----------------------------------------------------------- include
+$rate_items = array(0,1,2,3,4,5);
+//--------------------------------------------------------------------- include
 define('PHPWG_ROOT_PATH','./');
 include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );    
 //-------------------------------------------------- access authorization check
@@ -191,16 +192,9 @@ foreach (array('prev', 'current', 'next') as $i)
     $picture[$i]['name'] = str_replace('_', ' ', $file_wo_ext);
   }
 
-  $picture[$i]['url'] = PHPWG_ROOT_PATH.'picture.php?image_id='.$row['id'];
-  $picture[$i]['url'].= '&cat='.$page['cat'];
-  if ( $page['cat'] == 'search' )
-  {
-    $picture[$i]['url'].= '&search='.$_GET['search'];
-  }
-  if (isset($_GET['show_metadata']))
-  {
-    $picture[$i]['url'].= '&show_metadata=1';
-  }
+  $picture[$i]['url'] = PHPWG_ROOT_PATH.'picture.php';
+  $picture[$i]['url'].= get_query_string_diff(array('image_id','add_fav'));
+  $picture[$i]['url'].= '&image_id='.$row['id'];
 }
 
 $url_home = PHPWG_ROOT_PATH.'category.php?cat='.$page['cat'].'&';
@@ -213,7 +207,41 @@ if ( $page['cat'] == 'search' )
 $url_admin = PHPWG_ROOT_PATH.'admin.php?page=picture_modify';
 $url_admin.= '&cat_id='.$page['cat'];
 $url_admin.= '&image_id='.$_GET['image_id'];
-  
+//----------------------------------------------------------- rate registration
+if (isset($_GET['rate'])
+    and $conf['rate']
+    and !$user['is_the_guest']
+    and in_array($_GET['rate'], $rate_items))
+{
+  $query = '
+DELETE
+  FROM '.RATE_TABLE.'
+  WHERE user_id = '.$user['id'].'
+    AND element_id = '.$_GET['image_id'].'
+;';
+  mysql_query($query);
+  $query = '
+INSERT INTO '.RATE_TABLE.'
+  (user_id,element_id,rate)
+  VALUES
+  ('.$user['id'].','.$_GET['image_id'].','.$_GET['rate'].')
+;';
+  mysql_query($query);
+
+  // update of images.average_rate field
+  $query = '
+SELECT ROUND(AVG(rate),2) AS average_rate
+  FROM '.RATE_TABLE.'
+  WHERE element_id = '.$_GET['image_id'].'
+;';
+  $row = mysql_fetch_array(mysql_query($query));
+  $query = '
+UPDATE '.IMAGES_TABLE.'
+  SET average_rate = '.$row['average_rate'].'
+  WHERE id = '.$_GET['image_id'].'
+;';
+  mysql_query($query);
+}
 //--------------------------------------------------------- favorite management
 if ( isset( $_GET['add_fav'] ) )
 {
@@ -536,7 +564,7 @@ $template->assign_block_vars('info_line', array(
 // filesize
 if (empty($picture['current']['filesize']))
 {
-  if (!$picture[$i]['is_picture'])
+  if (!$picture['current']['is_picture'])
   {
     $filesize = floor(filesize($picture['current']['download'])/1024);
   }
@@ -572,10 +600,43 @@ if ( !empty($picture['current']['keywords']))
     ));
 }
 // number of visits
-$template->assign_block_vars('info_line', array(
+$template->assign_block_vars(
+  'info_line',
+  array(
     'INFO'=>$lang['visited'],
     'VALUE'=>$picture['current']['hit'].' '.$lang['times']
     ));
+// rate results
+if ($conf['rate'])
+{
+  $query = '
+SELECT COUNT(rate) AS count
+     , ROUND(AVG(rate),2) AS average
+     , ROUND(STD(rate),2) AS STD
+  FROM '.RATE_TABLE.'
+  WHERE element_id = '.$picture['current']['id'].'
+;';
+  $row = mysql_fetch_array(mysql_query($query));
+  if ($row['count'] == 0)
+  {
+    $value = $lang['no_rate'];
+  }
+  else
+  {
+    $value = $row['average'];
+    $value.= ' (';
+    $value.= $row['count'].' '.$lang['rates'];
+    $value.= ', '.$lang['standard_deviation'].' : '.$row['STD'];
+    $value.= ')';
+  }
+  
+  $template->assign_block_vars(
+    'info_line',
+    array(
+      'INFO'  => $lang['element_rate'],
+      'VALUE' => $value
+      ));
+}
 //-------------------------------------------------------------------- metadata
 if ($conf['show_exif'] or $conf['show_iptc'])
 {
@@ -596,26 +657,7 @@ if ($metadata_showable and !isset($_GET['show_metadata']))
 if ($metadata_showable and isset($_GET['show_metadata']))
 {
   $url = PHPWG_ROOT_PATH.'picture.php';
-  
-  $str = $_SERVER['QUERY_STRING'];
-  parse_str($str, $get_vars);
-  $is_first = true;
-  foreach ($get_vars as $key => $value)
-  {
-    if ($key != 'show_metadata')
-    {
-      if ($is_first)
-      {
-        $url.= '?';
-        $is_first = false;
-      }
-      else
-      {
-        $url.= '&';
-      }
-      $url.= $key.'='.$value;
-    }
-  }
+  $url.= get_query_string_diff(array('show_metadata','add_fav'));
   
   $template->assign_block_vars('hide_metadata', array('URL' => $url));
   
@@ -708,6 +750,57 @@ if ($metadata_showable and isset($_GET['show_metadata']))
     }
   }
 }
+//------------------------------------------------------------------- rate form
+if ($conf['rate'])
+{
+  $query = '
+SELECT rate
+  FROM '.RATE_TABLE.'
+  WHERE user_id = '.$user['id'].'
+    AND element_id = '.$_GET['image_id'].'
+;';
+  $result = mysql_query($query);
+  if (mysql_num_rows($result) > 0)
+  {
+    $row = mysql_fetch_array($result);
+    $sentence = $lang['already_rated'];
+    $sentence.= ' ('.$row['rate'].'). ';
+    $sentence.= $lang['update_rate'];
+  }
+  else
+  {
+    $sentence = $lang['never_rated'].'. '.$lang['to_rate'];
+  }
+  $template->assign_block_vars(
+    'rate',
+    array('SENTENCE' => $sentence)
+    );
+  
+  
+  foreach ($rate_items as $num => $mark)
+  {
+    if ($num > 0)
+    {
+      $separator = '|';
+    }
+    else
+    {
+      $separator = '';
+    }
+
+    $url = PHPWG_ROOT_PATH.'picture.php';
+    $url.= get_query_string_diff(array('rate','add_fav'));
+    $url.= '&rate='.$mark;
+    
+    $template->assign_block_vars(
+      'rate.rate_option',
+      array(
+        'OPTION' => $mark,
+        'URL' => $url,
+        'SEPARATOR' => $separator
+        ));
+  }
+}
 //------------------------------------------------------- favorite manipulation
 if ( !$user['is_the_guest'] )
 {
@@ -719,29 +812,33 @@ if ( !$user['is_the_guest'] )
   $row = mysql_fetch_array( $result );
   if (!$row['nb_fav'])
   {
-    $url = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'].'&image_id='.$_GET['image_id'];
-    $url.='&add_fav=1';
-    if ( $page['cat'] == 'search' )
-    {
-      $url.= '&search='.$_GET['search'];
-    }
-	$template->assign_block_vars('favorite', array(
-      'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/favorite.gif',
-	  'FAVORITE_HINT' =>$lang['add_favorites_hint'],
-	  'FAVORITE_ALT' =>'[ '.$lang['add_favorites_alt'].' ]',
-      'U_FAVORITE'=> add_session_id( $url )
-    ));
+    $url = PHPWG_ROOT_PATH.'picture.php';
+    $url.= get_query_string_diff(array('rate','add_fav'));
+    $url.= '&add_fav=1';
+
+    $template->assign_block_vars(
+      'favorite',
+      array(
+        'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/favorite.gif',
+        'FAVORITE_HINT' =>$lang['add_favorites_hint'],
+        'FAVORITE_ALT' =>'[ '.$lang['add_favorites_alt'].' ]',
+        'U_FAVORITE' => $url
+        ));
   }
   else
   {
-    $url = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'].'&image_id='.$_GET['image_id'];
+    $url = PHPWG_ROOT_PATH.'picture.php';
+    $url.= get_query_string_diff(array('rate','add_fav'));
     $url.= '&add_fav=0';
-	$template->assign_block_vars('favorite', array(
-      'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/del_favorite.gif',
-	  'FAVORITE_HINT' =>$lang['del_favorites_hint'],
-	  'FAVORITE_ALT' =>'[ '.$lang['del_favorites_alt'].' ]',
-      'U_FAVORITE'=> add_session_id( $url )
-    ));
+    
+    $template->assign_block_vars(
+      'favorite',
+      array(
+        'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/del_favorite.gif',
+        'FAVORITE_HINT' =>$lang['del_favorites_hint'],
+        'FAVORITE_ALT' =>'[ '.$lang['del_favorites_alt'].' ]',
+        'U_FAVORITE'=> $url
+        ));
   }
 }
 //------------------------------------ admin link for information modifications
@@ -761,12 +858,10 @@ if ( $conf['show_comments'] )
   $row = mysql_fetch_array( mysql_query( $query ) );
   
   // navigation bar creation
-  $url = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'].'&image_id='.$_GET['image_id'];
-  if ( $page['cat'] == 'search' )
-  {
-    $url.= '&search='.$_GET['search'];
-  }
-  if( !isset( $_GET['start'] )
+  $url = PHPWG_ROOT_PATH.'picture.php';
+  $url.= get_query_string_diff(array('rate','add_fav'));
+
+  if (!isset( $_GET['start'] )
       or !is_numeric( $_GET['start'] )
       or ( is_numeric( $_GET['start'] ) and $_GET['start'] < 0 ) )
   {