Changeset 3360:66bc2ca93d56 for admin/posts.php

Timestamp:

10/12/16 18:27:29 (9 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Use lexicographic sort if possible in admin lists sort order

File:

• admin/posts.php (modified) (2 diffs)

admin/posts.php

@@ -136 +136 @@
      __('Number of trackbacks') => 'nb_trackback'
      );
+
+     $sortby_lex = array(
+          // key in sorty_combo (see above) => field in SQL request
+          'post_title' => 'post_title',
+          'cat_title' => 'cat_title',
+          'user_id' => 'P.user_id');
 
      $order_combo = array(
@@ -275 +281 @@
 # - Sortby and order filter
 if ($sortby !== '' && in_array($sortby,$sortby_combo)) {
+     if (array_key_exists($sortby,$sortby_lex)) {
+          $params['order'] = $core->con->lexFields($sortby_lex[$sortby]);
+     } else {
+          $params['order'] = $sortby;
+     }
      if ($order !== '' && in_array($order,$order_combo)) {
-          $params['order'] = $sortby.' '.$order;
+          $params['order'] .= ' '.$order;
      } else {
           $order='desc';