[aur-dev] [PATCH 1/4] Add an option to filter by user to pkgreq_list()

[Lukas Fleischer]

When a user is specified, the function only returns package requests
which are either opened by the given user or affecting packages
maintained by the given user.

Signed-off-by: Lukas Fleischer <lfleisc...@archlinux.org>
---
 web/lib/pkgreqfuncs.inc.php | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/web/lib/pkgreqfuncs.inc.php b/web/lib/pkgreqfuncs.inc.php
index 7a171ed..7dcab13 100644
--- a/web/lib/pkgreqfuncs.inc.php
+++ b/web/lib/pkgreqfuncs.inc.php
@@ -19,10 +19,11 @@ function pkgreq_count() {
  *
  * @param int $offset The index of the first request to return
  * @param int $limit The maximum number of requests to return
+ * @param int $uid Only return packages affecting the given user
  *
  * @return array List of pacakge requests with details
  */
-function pkgreq_list($offset, $limit) {
+function pkgreq_list($offset, $limit, $uid=false) {
        $dbh = DB::connect();
 
        $q = "SELECT PackageRequests.ID, ";
@@ -35,6 +36,12 @@ function pkgreq_list($offset, $limit) {
        $q.= "FROM PackageRequests INNER JOIN RequestTypes ON ";
        $q.= "RequestTypes.ID = PackageRequests.ReqTypeID ";
        $q.= "INNER JOIN Users ON Users.ID = PackageRequests.UsersID ";
+
+       if ($uid) {
+               $q.= "WHERE PackageRequests.UsersID = " . intval($uid). " ";
+               $q.= "OR Users.ID = " . intval($uid) . " ";
+       }
+
        $q.= "ORDER BY Open DESC, RequestTS DESC ";
        $q.= "LIMIT " . $limit . " OFFSET " . $offset;
 
-- 
2.11.1