summaryrefslogtreecommitdiffstats
path: root/web/lib/pkgreqfuncs.inc.php
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-07-02 08:18:15 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-07-02 08:23:27 +0200
commita149fc493f62f31e3806f353dde0c4dc812be6b2 (patch)
treee2e45340717bca33f80631bdc7ddd5956d7d9590 /web/lib/pkgreqfuncs.inc.php
parent64c4e51698c23b59121c94eb501ab2d4f97128e8 (diff)
downloadaurweb-a149fc493f62f31e3806f353dde0c4dc812be6b2.tar.xz
Fix pagination in the package request list
This was not implemented properly in commit 8260111 (Add a package request list, 2014-06-24). Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/pkgreqfuncs.inc.php')
-rw-r--r--web/lib/pkgreqfuncs.inc.php19
1 files changed, 17 insertions, 2 deletions
diff --git a/web/lib/pkgreqfuncs.inc.php b/web/lib/pkgreqfuncs.inc.php
index 852554b..a79677e 100644
--- a/web/lib/pkgreqfuncs.inc.php
+++ b/web/lib/pkgreqfuncs.inc.php
@@ -3,11 +3,25 @@ include_once("config.inc.php");
include_once("pkgbasefuncs.inc.php");
/**
+ * Get the number of package requests
+ *
+ * @return int The total number of package requests
+ */
+function pkgreq_count() {
+ $dbh = DB::connect();
+ $q = "SELECT COUNT(*) FROM PackageRequests";
+ return $dbh->query($q)->fetchColumn();
+}
+
+/**
* Get a list of all package requests
*
+ * @param int $offset The index of the first request to return
+ * @param int $limit The maximum number of requests to return
+ *
* @return array List of pacakge requests with details
*/
-function pkgreq_list() {
+function pkgreq_list($offset, $limit) {
$dbh = DB::connect();
$q = "SELECT PackageRequests.ID, ";
@@ -20,7 +34,8 @@ function pkgreq_list() {
$q.= "FROM PackageRequests INNER JOIN RequestTypes ON ";
$q.= "RequestTypes.ID = PackageRequests.ReqTypeID ";
$q.= "INNER JOIN Users ON Users.ID = PackageRequests.UsersID ";
- $q.= "ORDER BY Status ASC, RequestTS DESC";
+ $q.= "ORDER BY Status ASC, RequestTS DESC ";
+ $q.= "LIMIT " . $limit . " OFFSET " . $offset;
return $dbh->query($q)->fetchAll();
}