[aur-dev] [PATCH 3/4] Show package popularity in search results

[Lukas Fleischer]

Display the popularity index (weighted votes) in the package search
results.

Signed-off-by: Lukas Fleischer <lfleischer at archlinux.org>
---
 web/lib/pkgfuncs.inc.php            | 7 +++++--
 web/template/pkg_search_form.php    | 1 +
 web/template/pkg_search_results.php | 2 ++
 3 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index a5f24ba..f527578 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -545,8 +545,8 @@ function pkg_search_page($SID="") {
 	$q_select .= "Users.Username AS Maintainer,
 	PackageCategories.Category,
 	Packages.Name, Packages.Version, Packages.Description,
-	PackageBases.NumVotes, Packages.ID, Packages.PackageBaseID,
-	PackageBases.OutOfDateTS ";
+	PackageBases.NumVotes, PackageBases.Popularity, Packages.ID,
+	Packages.PackageBaseID, PackageBases.OutOfDateTS ";
 
 	$q_from = "FROM Packages
 	LEFT JOIN PackageBases ON (PackageBases.ID = Packages.PackageBaseID)
@@ -663,6 +663,9 @@ function pkg_search_page($SID="") {
 	case 'v':
 		$q_sort .= "NumVotes " . $order . ", ";
 		break;
+	case 'p':
+		$q_sort .= "Popularity " . $order . ", ";
+		break;
 	case 'w':
 		if ($SID) {
 			$q_sort .= "Voted " . $order . ", ";
diff --git a/web/template/pkg_search_form.php b/web/template/pkg_search_form.php
index 7428250..b4b88bd 100644
--- a/web/template/pkg_search_form.php
+++ b/web/template/pkg_search_form.php
@@ -21,6 +21,7 @@ $sortby = array(
 	'n' => __('Name'),
 	'c' => __('Category'),
 	'v' => __('Votes'),
+	'p' => __('Popularity'),
 	'w' => __('Voted'),
 	'o' => __('Notify'),
 	'm' => __('Maintainer'),
diff --git a/web/template/pkg_search_results.php b/web/template/pkg_search_results.php
index 7ab3eb9..5289b78 100644
--- a/web/template/pkg_search_results.php
+++ b/web/template/pkg_search_results.php
@@ -36,6 +36,7 @@ if (!$result): ?>
 					<th><a href="?<?= mkurl('SB=n&SO=' . $SO_next) ?>"><?= __("Name") ?></a></th>
 					<th><?= __("Version") ?></th>
 					<th><a href="?<?= mkurl('SB=v&SO=' . $SO_next) ?>"><?= __("Votes") ?></a></th>
+					<th><a href="?<?= mkurl('SB=p&SO=' . $SO_next) ?>"><?= __("Popularity") ?></a></th>
 					<?php if ($SID): ?>
 					<th><a href="?<?= mkurl('SB=w&SO=' . $SO_next) ?>"><?= __("Voted") ?></a></th>
 					<th><a href="?<?= mkurl('SB=o&SO=' . $SO_next) ?>"><?= __("Notify") ?></a></th>
@@ -55,6 +56,7 @@ if (!$result): ?>
 		<td><a href="<?= htmlspecialchars(get_pkg_uri($row["Name"]), ENT_QUOTES); ?>"><?= htmlspecialchars($row["Name"]) ?></a></td>
 		<td<?php if ($row["OutOfDateTS"]): ?> class="flagged"<?php endif; ?>><?= htmlspecialchars($row["Version"]) ?></td>
 		<td><?= $row["NumVotes"] ?></td>
+		<td><?= $row["Popularity"] ?></td>
 		<?php if ($SID): ?>
 		<td>
 		<?php if (isset($row["Voted"])): ?>
-- 
2.4.2