From 38eb8d2a3ab0b7f35618d151613211d45f6ec4d8 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer 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 --- web/lib/pkgfuncs.inc.php | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'web/lib/pkgfuncs.inc.php') 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-70-g09d2