Changeset 809 for trunk/admin/cat_options.php

Timestamp:

Aug 14, 2005, 1:09:54 AM (19 years ago)

Author:

plg

Message:

• new : maintenance screen in administration. There you can update categories informations (number of images, date of the last added element), update images informations (path, average rate), purge obsolete sessions, purge history.

• new : ability to have random representative for categories. This configuration parameter is set to false by default.

• new : ability to set an element as representative of a category without belonging to the category. Thus, administrator can choose representative even for empty categories.

• improvement : semantically superior design for category edition screen by regrouping fields in fieldsets. The improved screen contains action buttons as in category list screen.

• new : ability to move a virtual category (ie change its parent category).

• bug fixed : the sync_users function checks all user children tables (access, cache, group association).

File:

• trunk/admin/cat_options.php (modified) (6 diffs)

trunk/admin/cat_options.php

@@ -73 +73 @@
       break;
     }
+    case 'representative' :
+    {
+      $query = '
+UPDATE '.CATEGORIES_TABLE.'
+  SET representative_picture_id = NULL
+  WHERE id IN ('.implode(',', $_POST['cat_true']).')
+;';
+      pwg_query($query);
+      break;
+    }
   }
 }
@@ -109 +119 @@
     {
       set_cat_status($_POST['cat_false'], 'public');
+      break;
+    }
+    case 'representative' :
+    {
+      // theoretically, all categories in $_POST['cat_false'] contain at
+      // least one element, so PhpWebGallery can find a representant.
+      set_random_representant($_POST['cat_false']);
       break;
     }
@@ -179 +196 @@
         )
       );
-    $template->assign_block_vars('upload', array());
     break;
   }
@@ -202 +218 @@
         )
       );
-    $template->assign_block_vars('comments', array());
     break;
   }
@@ -225 +240 @@
         )
       );
-    $template->assign_block_vars('visible', array());
     break;
   }
@@ -248 +262 @@
         )
       );
-    $template->assign_block_vars('status', array());
+    break;
+  }
+  case 'representative' :
+  {
+    $query_true = '
+SELECT id,name,uppercats,global_rank
+  FROM '.CATEGORIES_TABLE.'
+  WHERE representative_picture_id IS NOT NULL
+;';
+    $query_false = '
+SELECT id,name,uppercats,global_rank
+  FROM '.CATEGORIES_TABLE.'
+  WHERE nb_images != 0
+    AND representative_picture_id IS NULL
+;';
+    $template->assign_vars(
+      array(
+        'L_CAT_TITLE' => l10n('Representative'),
+        'L_CAT_OPTIONS_TRUE' => l10n('singly represented'),
+        'L_CAT_OPTIONS_FALSE' => l10n('randomly represented'),
+        'L_CAT_OPTIONS_INFO' => l10n('')
+        )
+      );
     break;
   }