Changeset 3360:66bc2ca93d56

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

Location:

admin

Files:

• comments.php (modified) (2 diffs)
• posts.php (modified) (2 diffs)
• users.php (modified) (2 diffs)

admin/comments.php

@@ -48 +48 @@
 );
 
+$sortby_lex = array(
+     // key in sorty_combo (see above) => field in SQL request
+     'post_title' => 'post_title',
+     'comment_author' => 'comment_author',
+     'comment_spam_filter' => 'comment_spam_filter');
+
 $order_combo = array(
 __('Descending') => 'desc',
@@ -134 +140 @@
 # 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';

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';

admin/users.php

@@ -23 +23 @@
 __('Number of entries') => 'nb_post'
 );
+
+$sortby_lex = array(
+     // key in sorty_combo (see above) => field in SQL request
+     'user_id' => 'U.user_id',
+     'user_name' => 'user_name',
+     'user_firstname' => 'user_firstname',
+     'user_displayname' => 'user_displayname');
 
 $order_combo = array(
@@ -66 +73 @@
 # - 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='asc';