From 38eb8d2a3ab0b7f35618d151613211d45f6ec4d8 Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
Date: Sat, 26 Apr 2014 14:21:43 +0200
Subject: Display package groups on the details page
The groups field is hidden if a package doesn't belong to any group.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
web/lib/pkgfuncs.inc.php | 26 ++++++++++++++++++++++++++
1 file changed, 26 insertions(+)
(limited to 'web/lib')
diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index f80d4b4..6811767 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -104,6 +104,32 @@ function pkg_from_name($name="") {
return $row[0];
}
+/**
+ * Get package groups for a specific package
+ *
+ * @param int $pkgid The package to get groups for
+ *
+ * @return array All package groups for the package
+ */
+function pkg_groups($pkgid) {
+ $grps = array();
+ $pkgid = intval($pkgid);
+ if ($pkgid > 0) {
+ $dbh = DB::connect();
+ $q = "SELECT g.Name FROM Groups g ";
+ $q.= "INNER JOIN PackageGroups pg ON pg.GroupID = g.ID ";
+ $q.= "WHERE pg.PackageID = ". $pkgid;
+ $result = $dbh->query($q);
+ if (!$result) {
+ return array();
+ }
+ while ($row = $result->fetch(PDO::FETCH_COLUMN, 0)) {
+ $grps[] = $row;
+ }
+ }
+ return $grps;
+}
+
/**
* Get package dependencies for a specific package
*
--
cgit v1.2.3-54-g00ecf