From 3720bdf6b264cb4bb603e4199f2758598c260ed4 Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
Date: Sat, 26 Apr 2014 13:17:28 +0200
Subject: Display package relations on the details page

This adds information from the following three fields to the package
details page:

* conflicts
* provides
* replaces

If either of these fields is empty, it is not displayed.

Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 web/lib/pkgfuncs.inc.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)

(limited to 'web/lib/pkgfuncs.inc.php')

diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index 2eb0be4..a04f525 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -132,6 +132,34 @@ function pkg_dependencies($pkgid) {
 	return $deps;
 }
 
+/**
+ * Get package relations for a specific package
+ *
+ * @param int $pkgid The package to get relations for
+ *
+ * @return array All package relations for the package
+ */
+function pkg_relations($pkgid) {
+	$rels = array();
+	$pkgid = intval($pkgid);
+	if ($pkgid > 0) {
+		$dbh = DB::connect();
+		$q = "SELECT pr.RelName, rt.Name, pr.RelCondition, p.ID FROM PackageRelations pr ";
+		$q.= "LEFT JOIN Packages p ON pr.RelName = p.Name ";
+		$q.= "LEFT JOIN RelationTypes rt ON rt.ID = pr.RelTypeID ";
+		$q.= "WHERE pr.PackageID = ". $pkgid . " ";
+		$q.= "ORDER BY pr.RelName";
+		$result = $dbh->query($q);
+		if (!$result) {
+			return array();
+		}
+		while ($row = $result->fetch(PDO::FETCH_NUM)) {
+			$rels[] = $row;
+		}
+	}
+	return $rels;
+}
+
 /**
  * Get the ID of a dependency type given its name
  *
-- 
cgit v1.2.3-54-g00ecf