Changeset 3360:66bc2ca93d56 for admin/comments.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/comments.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';