From 28f074140370a8c2a11b995271e4c135b2cc1c7f Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 18 Feb 2019 21:34:07 +0100 Subject: extracting of ORDER BY info from $_GET moved from packages/index.php to function in lib/style.php --- lib/style.php | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'lib') 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`)"; -- cgit v1.2.3