Changeset 1066 for trunk/admin/cat_list.php

Timestamp:

Mar 7, 2006, 12:28:51 AM (18 years ago)

Author:

plg

Message:

request 302: order categories alphanumerically

alphanumerically sort of language keys in admin.lang.php

File:

• trunk/admin/cat_list.php (modified) (1 diff)

trunk/admin/cat_list.php

@@ -98 +98 @@
   }
 }
+// save manual category ordering
 else if (isset($_POST['submitOrder']))
 {
   asort($_POST['catOrd'], SORT_NUMERIC);
   save_categories_order(array_keys($_POST['catOrd']));
-}
+
+  array_push(
+    $page['infos'],
+    l10n('Categories manual order was saved')
+    );
+}
+// sort categories alpha-numerically
+else if (isset($_POST['submitOrderAlphaNum']))
+{
+  $query = '
+SELECT id, name
+  FROM '.CATEGORIES_TABLE.'
+  WHERE id_uppercat '.
+    (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).'
+;';
+  $result = pwg_query($query);
+  while ($row = mysql_fetch_assoc($result))
+  {
+    $categories[ $row['id'] ] = $row['name'];
+  }
+
+  asort($categories, SORT_REGULAR);
+  save_categories_order(array_keys($categories));
+
+  array_push(
+    $page['infos'],
+    l10n('Categories ordered alphanumerically')
+    );
+}
+
 // +-----------------------------------------------------------------------+
 // |                           Cache management                            |