Changeset 1500

Timestamp:

Jul 26, 2006, 2:51:08 AM (18 years ago)

Author:

rvelices

Message:

feature 169: each category can have its own image order

Location:

trunk

Files:

• admin/cat_modify.php (modified) (3 diffs)
• include/functions_category.inc.php (modified) (1 diff)
• include/section_init.inc.php (modified) (1 diff)
• install/db/29-database.php (added)
• install/phpwebgallery_structure.sql (modified) (1 diff)
• language/en_UK.iso-8859-1/admin.lang.php (modified) (2 diffs)
• language/fr_FR.iso-8859-1/admin.lang.php (modified) (2 diffs)
• template/yoga/admin/cat_modify.tpl (modified) (6 diffs)

trunk/admin/cat_modify.php

@@ -81 +81 @@
   }
 
+  $image_order = '';
+  if ( !isset($_POST['image_order_default']) )
+  {
+    for ($i=1; $i<=3; $i++)
+    {
+      if ( !empty($_POST['order_field_'.$i]) )
+      {
+        if (! empty($image_order) )
+        {
+          $image_order .= ',';
+        }
+        $image_order .= $_POST['order_field_'.$i];
+        if ($_POST['order_direction_'.$i]=='DESC')
+        {
+          $image_order .= ' DESC';
+        }
+      }
+    }
+  }
+  $image_order = empty($image_order) ? 'null' : "'$image_order'";
+  $query = '
+UPDATE '.CATEGORIES_TABLE.' SET image_order='.$image_order.'
+WHERE ';
+  if (isset($_POST['image_order_subcats']))
+  {
+    $query .= 'uppercats REGEXP \'(^|,)'.$_GET['cat_id'].'(,|$)\'';
+  }
+  else
+  {
+    $query .= 'id='.$_GET['cat_id'].';';
+  }
+  pwg_query($query);
+
   array_push($page['infos'], $lang['editcat_confirm']);
 }
@@ -226 +259 @@
     $commentable         => 'checked="checked"',
     $uploadable          => 'checked="checked"',
+
+    'IMG_ORDER_DEFAULT'  => empty($category['image_order']) ?
+                              'checked="checked"' : '',
 
     'L_EDIT_NAME'        => $lang['name'],
@@ -278 +314 @@
 }
 
+// image order management
+$matches = array();
+if ( !empty( $category['image_order'] ) )
+{
+  preg_match_all('/([a-z_]+) *(?:(asc|desc)(?:ending)?)? *(?:, *|$)/i',
+    $category['image_order'], $matches);
+}
+
+$sort_fields = array(
+  '' => '',
+  'date_creation' => l10n('Creation date'),
+  'date_available' => l10n('Post date'),
+  'average_rate' => l10n('Average rate'),
+  'hit' => l10n('most_visited_cat'),
+  'file' => l10n('File name'),
+  'id' => 'Id',
+  );
+
+for ($i=0; $i<3; $i++) // 3 fields
+{
+  $template->assign_block_vars('image_order', array('NUMBER'=>$i+1) );
+  foreach ($sort_fields as $sort_field => $name)
+  {
+    $selected='';
+    if ( isset($matches[1][$i]) and $matches[1][$i]==$sort_field )
+    {
+      $selected='selected="selected"';
+    }
+    elseif ( empty($sort_field) )
+    {
+      $selected='selected="selected"';
+    }
+
+    $template->assign_block_vars('image_order.field',
+      array(
+        'SELECTED' => $selected,
+        'VALUE' => $sort_field,
+        'OPTION' => $name
+        )
+      );
+  }
+
+  $template->assign_block_vars('image_order.order',
+    array(
+      'SELECTED' =>
+        ( empty($matches[2][$i]) or strcasecmp($matches[2][$i],'ASC')==0 )
+          ? 'selected="selected"' : '',
+      'VALUE' => 'ASC',
+      'OPTION' => 'Ascending'
+      )
+    );
+
+  $template->assign_block_vars('image_order.order',
+    array(
+      'SELECTED' =>
+        ( isset($matches[2][$i]) and strcasecmp($matches[2][$i],'DESC')==0 )
+          ? 'selected="selected"' : '',
+      'VALUE' => 'DESC',
+      'OPTION' => 'Descending'
+      )
+    );
+}
+
+
 // representant management
 if ($category['nb_images'] > 0

trunk/include/functions_category.inc.php

@@ -111 +111 @@
   $infos = array('nb_images','id_uppercat','comment','site_id'
                  ,'dir','date_last','uploadable','status','visible'
-                 ,'representative_picture_id','uppercats','commentable');
+                 ,'representative_picture_id','uppercats','commentable'
+                 ,'image_order');
 
   $query = '

trunk/include/section_init.inc.php

@@ -343 +343 @@
     if (!isset($page['chronology_field']))
     {
+      if ( !empty($result['image_order']) and !isset($page['super_order_by']) )
+      {
+        $conf[ 'order_by' ] = ' ORDER BY '.$result['image_order'];
+      }
+
       $query = '
 SELECT image_id

trunk/install/phpwebgallery_structure.sql

@@ -38 +38 @@
   `commentable` enum('true','false') NOT NULL default 'true',
   `global_rank` varchar(255) default NULL,
+  `image_order` varchar(128) default NULL,
   PRIMARY KEY  (`id`),
   KEY `categories_i2` (`id_uppercat`)

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

@@ -46 +46 @@
 $lang['Add selected elements to caddie'] = 'Add selected elements to caddie';
 $lang['Add'] = 'Add';
+$lang['Apply to subcategories'] = 'Apply to subcategories';
 $lang['Are you sure?'] = 'Are you sure?';
 $lang['Associated'] = 'Associated';
@@ -166 +167 @@
 $lang['The %d following tags were deleted : %s'] = 'The %d following tags were deleted : %s';
 $lang['Unable to check for upgrade since allow_url_fopen is disabled.'] = 'Unable to check for upgrade since allow_url_fopen is disabled.';
+$lang['Use default sort order']='Use the default image sort order (defined in the configuration file)';
 $lang['User comments validation'] = 'User comments validation';
 $lang['Users'] = 'Users';

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

@@ -46 +46 @@
 $lang['Add selected elements to caddie'] = 'Ajouter les éléments sélectionnés au panier';
 $lang['Add'] = 'Ajouter';
+$lang['Apply to subcategories'] = 'Appliquer au sous-catégories';
 $lang['Are you sure?'] = 'Etes-vous sur?';
 $lang['Associated'] = 'Associée à';
@@ -166 +167 @@
 $lang['The %d following tags were deleted : %s'] = 'Les %d tags suivants ont été supprimés : %s';
 $lang['Unable to check for upgrade since allow_url_fopen is disabled.'] = 'Impossible de connaître la dernière version cat la fonction allow_url_fopen est désactivée.';
+$lang['Use default sort order']='Utiliser l\'ordre de tri des images par défaut (défini dans le fichier de configuration)';
 $lang['User comments validation'] = 'Validation des commentaires utilisateur';
 $lang['Users'] = 'Utilisateurs';

trunk/template/yoga/admin/cat_modify.tpl

@@ -63 +63 @@
     <option class="{move.parent_option.CLASS}" {move.parent_option.SELECTED} value="{move.parent_option.VALUE}">{move.parent_option.OPTION}</option>
     <!-- END parent_option -->
-  </select>  
+  </select>
 </fieldset>
 <!-- END move -->
@@ -101 +101 @@
     <!-- END upload -->
   </table>
+</fieldset>
+
+<fieldset id="image_order">
+  <legend>{lang:Sort order}</legend>
+  <input type="checkbox" name="image_order_default" id="image_order_default" {IMG_ORDER_DEFAULT} />
+  <label for="image_order_default">{lang:Use default sort order}</label>
+  <br/>
+  <input type="checkbox" name="image_order_subcats" id="image_order_subcats" />
+  <label for="image_order_subcats">{lang:Apply to subcategories}</label>
+  <br/>
+  <!-- BEGIN image_order -->
+    <select name="order_field_{image_order.NUMBER}">
+    <!-- BEGIN field -->
+      <option value="{image_order.field.VALUE}" {image_order.field.SELECTED}>{image_order.field.OPTION}</option>
+    <!-- END field -->
+    </select>
+    <select name="order_direction_{image_order.NUMBER}">
+    <!-- BEGIN order -->
+      <option value="{image_order.order.VALUE}" {image_order.order.SELECTED}>{image_order.order.OPTION}</option>
+    <!-- END order -->
+    </select><br/>
+  <!-- END image_order -->
 </fieldset>
 
@@ -123 +145 @@
       </td>
       <td>
-        <!-- BEGIN set_random --> 
+        <!-- BEGIN set_random -->
         <p><input type="submit" name="set_random_representant" value="{L_SET_RANDOM_REPRESENTANT}" {TAG_INPUT_ENABLED}/></p>
         <!-- END set_random -->
@@ -139 +161 @@
 
 <form action="{F_ACTION}" method="POST" id="links">
-  
+
 <fieldset id="linkAllNew">
   <legend>{lang:Link all category elements to a new category}</legend>
@@ -164 +186 @@
     <input type="submit" value="{lang:Submit}" name="submitAdd" {TAG_INPUT_ENABLED}/>
     <input type="reset" value="{lang:Reset}" name="reset" />
-  </p>  
+  </p>
 
 </fieldset>
@@ -187 +209 @@
     <input type="submit" value="{lang:Submit}" name="submitDestinations" {TAG_INPUT_ENABLED}/>
     <input type="reset" value="{lang:Reset}" name="reset" />
-  </p>  
+  </p>
 
 </fieldset>