extracting of ORDER BY info from $_GET moved from packages/index.php to function in lib/style.php

1 files changed, 24 insertions, 0 deletions

diff --git a/lib/style.php b/lib/style.php
index ff2d364..99d9840 100644
--- a/lib/style.php
+++ b/lib/style.php
@@ -124,6 +124,30 @@ $pkglist_sorts = array(
   )
 );
 
+function package_listing_query_order_by() {
+  global $pkglist_sorts;
+  if (!array_key_exists('sort', $_GET))
+    return;
+  $criterium = $_GET['sort'];
+  if (
+    array_key_exists($criterium, $pkglist_sorts) &&
+    array_key_exists('mysql', $pkglist_sorts[$criterium])
+  )
+    return $pkglist_sorts[$criterium]['mysql'] . ',';
+
+  if (substr($criterium, 0, 1) != '-')
+    return;
+  $criterium = substr($criterium, 1);
+
+  if (
+    array_key_exists($criterium, $pkglist_sorts) &&
+    array_key_exists('mysql', $pkglist_sorts[$criterium])
+  )
+    return $pkglist_sorts[$criterium]['mysql'] . ' DESC,';
+
+  return;
+}
+
 function query_package_listing($filter_and_order, $float_columns, $count_only) {
   if ($count_only)
     $columns = "COUNT(DISTINCT `binary_packages`.`id`)";