Alexander Nicolaysen Sørnes : application: Allow sorting by vendor name
Chris Morgan
cmorgan at winehq.org
Tue Nov 13 23:22:57 CST 2007
Module: appdb
Branch: master
Commit: 43af0708c9347e8e40911ff1696d128b5b7f784a
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=43af0708c9347e8e40911ff1696d128b5b7f784a
Author: Alexander Nicolaysen Sørnes <alex at 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;
}
More information about the wine-cvs
mailing list