Changeset 633

Timestamp:

Dec 4, 2004, 6:42:07 PM (19 years ago)

Author:

plg

Message:

• shows the element representing a non empty category in cat_modify

• possibility to set a random representing element for a category

• bug fixed : update_category function could not update nb_images

• bug fixed : mass_updates was inserting in the wrong table

Location:

trunk

Files:

• admin/cat_modify.php (modified) (2 diffs)
• admin/include/functions.php (modified) (5 diffs)
• admin/update.php (modified) (1 diff)
• language/en_UK.iso-8859-1/admin.lang.php (modified) (1 diff)
• template/default/admin/cat_modify.tpl (modified) (1 diff)

trunk/admin/cat_modify.php

@@ -80 +80 @@
 
   $template->assign_block_vars('confirmation' ,array());
+}
+else if (isset($_POST['set_random_representant']))
+{
+  set_random_representant(array($_GET['cat_id']));
 }
 
@@ -158 +162 @@
   'L_NO'=>$lang['no'],
   'L_SUBMIT'=>$lang['submit'],
+  'L_SET_RANDOM_REPRESENTANT'=>$lang['set_random_representant'],
    
   'F_ACTION'=>add_session_id($form_action)
   ));
-  
+
+if ($category['nb_images'] > 0)
+{
+  $query = '
+SELECT tn_ext,path
+  FROM '.IMAGES_TABLE.'
+  WHERE id = '.$category['representative_picture_id'].'
+;';
+  $row = mysql_fetch_array(pwg_query($query));
+  $src = get_thumbnail_src($row['path'], @$row['tn_ext']);
+  $url = PHPWG_ROOT_PATH.'admin.php?page=picture_modify';
+  $url.= '&image_id='.$category['representative_picture_id'];
+  $template->assign_block_vars('representant',
+                               array('SRC' => $src,
+                                     'URL' => $url));
+}
+
 if (!empty($category['dir']))
 {

trunk/admin/include/functions.php

@@ -454 +454 @@
   
   $query = '
-SELECT category_id, COUNT(image_id) AS count, max(date_available) AS date_last
+SELECT category_id,
+       COUNT(image_id) AS nb_images,
+       MAX(date_available) AS date_last
   FROM '.IMAGES_TABLE.'
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
@@ -472 +474 @@
     array_push($datas, array('id' => $row['category_id'],
                              'date_last' => $row['date_last'],
-                             'count' => $row['count']));
+                             'nb_images' => $row['nb_images']));
   }
   $fields = array('primary' => array('id'),
-                  'update'  => array('date_last', 'count'));
+                  'update'  => array('date_last', 'nb_images'));
   mass_updates(CATEGORIES_TABLE, $fields, $datas);
 
@@ -840 +842 @@
   $query = 'SELECT VERSION() AS version;';
   $row = mysql_fetch_array(pwg_query($query));
-  if (version_compare($row['version'],'4.0.4') < 0)
+  if (count($datas) < 10 or version_compare($row['version'],'4.0.4') < 0)
   {
     // MySQL is prior to version 4.0.4, multi table update feature is not
     // available
-    echo 'MySQL is prior to version 4.0.4, multi table update feature is not available<br />';
     foreach ($datas as $data)
     {
@@ -915 +916 @@
 ;';
     pwg_query($query);
-    mass_inserts($tablename, $all_fields, $datas);
+    mass_inserts($tablename.'_temporary', $all_fields, $datas);
     // update of images table by joining with temporary table
     $query = '
@@ -1093 +1094 @@
   }
 }
+
+/**
+ * set a new random representant to the categories
+ *
+ * @param array categories
+ */
+function set_random_representant($categories)
+{
+  $datas = array();
+  foreach ($categories as $category_id)
+  {
+    $query = '
+SELECT image_id
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE category_id = '.$category_id.'
+  ORDER BY RAND()
+  LIMIT 0,1
+;';
+    list($representative) = mysql_fetch_array(pwg_query($query));
+    $data = array('id' => $category_id,
+                  'representative_picture_id' => $representative);
+    array_push($datas, $data);
+  }
+
+  $fields = array('primary' => array('id'),
+                  'update' => array('representative_picture_id'));
+  mass_updates(CATEGORIES_TABLE, $fields, $datas);
+}
 ?>

trunk/admin/update.php

@@ -516 +516 @@
     pwg_query($query);
 
-    // set a new representative element for this category
-    $query = '
-SELECT image_id
-  FROM '.IMAGE_CATEGORY_TABLE.'
-  WHERE category_id = '.$category_id.'
-  ORDER BY RAND()
-  LIMIT 0,1
-;';
-    list($representative) = mysql_fetch_array(pwg_query($query));
-    $query = '
-UPDATE '.CATEGORIES_TABLE.'
-  SET representative_picture_id = '.$representative.'
-  WHERE id = '.$category_id.'
-;';
-    pwg_query($query);
+    set_random_representant(array($category_id));
   }
   return $output;

trunk/language/en_UK.iso-8859-1/admin.lang.php

@@ -345 +345 @@
 $lang['cat_list_virtual_category_added'] = 'virtual category added';
 $lang['cat_list_virtual_category_deleted'] = 'virtual category deleted';
+$lang['set_random_representant'] = 'set new random representant';
 ?>

trunk/template/default/admin/cat_modify.tpl

@@ -6 +6 @@
 <form action="{F_ACTION}" method="POST">
 <table style="width:100%;">
+    <!-- BEGIN representant -->
+    <tr>
+      <td style="width:50%;" align="center">
+        <a href="{representant.URL}"><img src="{representant.SRC}" alt="" class="miniature" /></a>
+      </td>
+      <td class="row1"><input type="submit" name="set_random_representant" value="{L_SET_RANDOM_REPRESENTANT}" class="bouton" /></td>
+    </tr>
+    <!-- END representant -->
     <!-- BEGIN server -->
     <tr>