Alexander Nicolaysen Sørnes : application: Allow sorting by vendor name

[Chris Morgan]

Module: appdb
Branch: master
Commit: 43af0708c9347e8e40911ff1696d128b5b7f784a
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=43af0708c9347e8e40911ff16...

Author: Alexander Nicolaysen Sørnes <alex(a)thehandofagony.com>
Date:   Tue Nov 13 19:51:23 2007 +0100

application: Allow sorting by vendor name

---

 include/application.php |   14 ++++++++------
 1 files changed, 8 insertions(+), 6 deletions(-)

diff --git a/include/application.php b/include/application.php
index 9d723dd..7f46efc 100644
--- a/include/application.php
+++ b/include/application.php
@@ -899,7 +899,9 @@ class Application {
                 $iRows = maintainer::objectGetEntriesCount($bQueued, $bRejected);
         }
 
-        $sQuery = "SELECT * FROM appFamily WHERE
+        $sQuery = "SELECT appFamily.*, vendor.vendorName AS vendorName FROM appFamily, user_list, vendor WHERE
+                     appFamily.vendorId = vendor.vendorId
+                     AND
                      appFamily.queued = '?'";
 
         $sQueued = objectManager::getQueueString($bQueued, $bRejected);
@@ -943,16 +945,16 @@ class Application {
 
     public static function objectGetSortableFields()
     {
-        return array('submitTime', 'appName', 'appId');
+        return array('submitTime', 'appName', 'appId', 'userName', 'vendorName');
     }
 
     public static function objectGetHeader()
     {
         $oTableRow = new TableRowSortable();
-        $oTableRow->AddSortableTextCell("Submission Date", "submitTime");
-        $oTableRow->AddTextCell("Submitter");
-        $oTableRow->AddTextCell("Vendor");
-        $oTableRow->AddSortableTextCell("Application", "appName");
+        $oTableRow->AddSortableTextCell('Submission Date', 'submitTime');
+        $oTableRow->AddTextCell('Submitter');
+        $oTableRow->AddSortableTextCell('Vendor', 'vendorName');
+        $oTableRow->AddSortableTextCell('Application', 'appName');
         return $oTableRow;
     }