Alexander Nicolaysen Sørnes : Allow users to delete/edit their queued test reports

[Chris Morgan]

Module: appdb
Branch: master
Commit: 214de5a459d22b6f17ddf51ee4d4f42dd9a22bc8
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=214de5a459d22b6f17ddf51ee...

Author: Alexander Nicolaysen Sørnes 
Date:   Sat Dec 22 00:11:55 2007 +0100

Allow users to delete/edit their queued test reports

---

include/testData.php |   55 ++++++++++++++++++++++++++++++++++---------------
 1 files changed, 38 insertions(+), 17 deletions(-)

diff --git a/include/testData.php b/include/testData.php
index 022459c..aafeb71 100644
--- a/include/testData.php
+++ b/include/testData.php
@@ -916,30 +916,51 @@ class testData{
     /* List test data submitted by a given user.  Ignore test results for queued applications/versions */
     function listSubmittedBy($iUserId, $bQueued = true)
     {
-        $hResult = query_parameters("SELECT testResults.versionId, testResults.testedDate, testResults.testedRelease, testResults.testedRating, testResults.submitTime, appFamily.appName, appVersion.versionName from testResults, appFamily, appVersion WHERE testResults.versionId = appVersion.versionId AND appVersion.appId = appFamily.appId  AND testResults.submitterId = '?' AND testResults.state = '?' ORDER BY testResults.testingId", $iUserId, $bQueued ? 'queued' : 'accepted');
+        $hResult = query_parameters("SELECT testResults.versionId, testResults.testedDate, testResults.testedRelease, testResults.testedRating, testResults.submitTime, testResults.testingId, appFamily.appName, appVersion.versionName from testResults, appFamily, appVersion WHERE testResults.versionId = appVersion.versionId AND appVersion.appId = appFamily.appId  AND testResults.submitterId = '?' AND testResults.state = '?' ORDER BY testResults.testingId", $iUserId, $bQueued ? 'queued' : 'accepted');

if(!$hResult || !query_num_rows($hResult))
             return false;

-        $sReturn = html_table_begin("width="100%" align="center"");
-        $sReturn .= html_tr(array(
-            "Version",
-            "Rating",
-            "Wine version",
-            "Submission Date"),
-            "color4");
+        $oTable = new Table();
+        $oTable->SetWidth("100%");
+        $oTable->SetAlign("center");
+
+        // setup the table header
+        $oTableRow = new TableRow();
+        $oTableRow->AddTextCell('Version');
+        $oTableRow->AddTextCell('Rating');
+        $oTableRow->AddTextCell('Wine version');
+        $oTableRow->AddTextCell('Submission date');
+
+        if($bQueued)
+            $oTableRow->addTextCell('Action');
+
+        $oTableRow->SetClass('color4');
+        $oTable->AddRow($oTableRow);

for($i = 1; $oRow = query_fetch_object($hResult); $i++)
-            $sReturn .= html_tr(array(
-                version::fullNameLink($oRow->versionId),
-                $oRow->testedRating,
-                $oRow->testedRelease,
-                print_date(mysqldatetime_to_unixtimestamp($oRow->submitTime))),
-                $oRow->testedRating);
+        {
+            $oTableRow = new TableRow();
+
+            $oTableRow->AddTextCell(version::fullNameLink($oRow->versionId));
+            $oTableRow->AddTextCell($oRow->testedRating);
+            $oTableRow->AddTextCell($oRow->testedRelease);
+            $oTableRow->AddTextCell(print_date(mysqldatetime_to_unixtimestamp($oRow->submitTim)));

-        $sReturn .= html_table_end();
+            if($bQueued)
+            {
+                $oM = new objectManager('testData_queue');
+                $oM->setReturnTo(array_key_exists('REQUEST_URI', $_SERVER) ? $_SERVER['REQUEST_URI'] : "");
+                $shDeleteLink = '<a href="'.$oM->makeUrl('delete', $oRow->testingId, 'Delete entry').'">delete</a>';
+                $shEditLink = '<a href="'.$oM->makeUrl('edit', $oRow->testingId, 'Edit entry').'">edit</a>';
+                $oTableRow->addTextCell("[ $shEditLink ] &nbsp; [ $shDeleteLink ]");
+            }
+
+            $oTableRow->SetClass($oRow->testedRating);
+            $oTable->AddRow($oTableRow);
+        }

-        return $sReturn;
+        return $oTable->GetString();
     }

// return the number of test data entries for a particular version id
@@ -1143,7 +1164,7 @@ class testData{
         else if($this->iVersionId)
         {
             if($this->iSubmitterId == $_SESSION['current']->iUserId &&
-               $this->sState == 'rejected')
+               $this->sState != 'accepted')
                 return TRUE;

$oVersion = new version($this->iVersionId);