Re: [aur-dev] [PATCH] add subitter, first submitted and last modified to json output

10 May 2011

On 10/05/11 21:20, kachelaqa wrote:
...
this patch is a follow up to my earlier feature request (FS#24183).
amended patch with correct line lengths.

---
  web/lib/aurjson.class.php |   13 +++++++++----
  1 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index 50cf6d0..97793cc 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -19,7 +19,7 @@ class AurJSON {
      );
      private static $fields = array(
          'Packages.ID', 'Name', 'Version', 'CategoryID',
-        'Description', 'URL', 'License',
+        'Description', 'URL', 'License', 'SubmittedTS', 'ModifiedTS',
          'NumVotes', '(OutOfDateTS IS NOT NULL) AS OutOfDate'
      );

@@ -85,9 +85,14 @@ class AurJSON {

      private function process_query($type, $where_condition) {
          $fields = implode(',', self::$fields);
-        $query = "SELECT Users.Username as Maintainer, {$fields} " .
-            "FROM Packages LEFT JOIN Users " .
-            "ON Packages.MaintainerUID = Users.ID " .
+        $query = "SELECT {$fields}, " .
+            "mUsers.Username AS Maintainer, " .
+            "sUsers.Username AS Submitter " .
+            "FROM Packages " .
+            "LEFT JOIN Users AS mUsers " .
+            "ON Packages.MaintainerUID = mUsers.ID " .
+            "LEFT JOIN Users AS sUsers " .
+            "ON Packages.SubmitterUID = sUsers.ID " .
              "WHERE ${where_condition}";
          $result = db_query($query, $this->dbh);

-- 
1.7.5.1

    