Changeset 766 for trunk/Modules/Download/Download.php

Timestamp:

Jan 27, 2014, 10:28:05 PM (11 years ago)

Author:

chronos

Message:

• Modified: Table in download page made sortable with paging support.
• Modified: Translation texts updated.

File:

• trunk/Modules/Download/Download.php (modified) (5 diffs)

trunk/Modules/Download/Download.php

@@ -32 +32 @@
         function ShowFiles()
         {
-    $this->Title = T('Download');               
     $fileslink = $this->System->Link('/files');
 $Output = '<h3>Doplňky pro klienta</h3>'.
@@ -79 +78 @@
         }
         
-        function ShowDownload() {
-          global $System;
+        function ShowDownload() 
+        {
     $Output = '<h3>Stažení češtiny</h3><br />';
     
@@ -89 +88 @@
     $Output .= '<br /><br />';
     
-                $Output .= '<table class="BaseTable">';
-                $Output .= '<tr><th>Stáhnout</th><th>Název</th><th>Datum vytvoření</th><th>Popis</th></tr>';
-                $DbRows = $this->System->Database->query('SELECT `ClientVersion`.`Version` as Version, `Export`.`Id`,`Export`.`ClientVersion`,`Export`.`OutputType`,`Export`.`Title`,`Export`.`Description` FROM `Export` JOIN `ClientVersion` as `ClientVersion` ON `ClientVersion`.`Id`=`Export`.`ClientVersion` WHERE `Featured`=1 ORDER BY `ClientVersion`.`BuildNumber` DESC');
-      while ($DbExport = $DbRows->fetch_assoc()) {
-      //  echo $DbExport['BuildNumber'].'<br />';
+    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `Featured`=1');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);    
+
+    $Output .= $PageList['Output'];
+    $TableColumns = array(
+      array('Name' => 'Id', 'Title' => T('Download')), 
+      array('Name' => 'Title', 'Title' => T('Name2')), 
+      array('Name' => 'TimeCreate', 'Title' => T('Creation date')), 
+      array('Name' => 'Description', 'Title' => T('Description')),
+    );    
+    $Order = GetOrderTableHeader($TableColumns, 'Id', 1);
+    $Output .= '<table class="BaseTable">'.
+      $Order['Output'];                 
+        $DbRows = $this->Database->query('SELECT `ClientVersion`.`Version` AS `Version`, '.
+      '`Export`.`Id`, `Export`.`ClientVersion`, `Export`.`OutputType`, `Export`.`Title`, '.
+      '`Export`.`Description` FROM `Export` '.
+      'JOIN `ClientVersion` as `ClientVersion` ON `ClientVersion`.`Id`=`Export`.`ClientVersion` '.
+      'WHERE `Featured`=1 '.$Order['SQL'].$PageList['SQLLimit']);
+    while ($DbExport = $DbRows->fetch_assoc()) 
+    {
         $ExportId = $DbExport['Id'];
                     
-                    $filename = $System->Config['Web']['TempFolder'].'Export/'.$ExportId.'/'.'Instalace_CzechWoW_'.$DbExport['Version'].'.exe';
+                    $filename = $this->System->Config['Web']['TempFolder'].'Export/'.$ExportId.'/'.'Instalace_CzechWoW_'.$DbExport['Version'].'.exe';
                             
                           if ($DbExport['OutputType'] == 10)
-          $Output .= '<tr><td><a href="'.$System->Link('/'.$filename).'">CzechWoW_'.$DbExport['Version'].'.exe</a><br /> <a href="'.$System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">Export '.$ExportId.'</a></td>';
+          $Output .= '<tr><td><a href="'.$this->System->Link('/'.$filename).
+            '">CzechWoW_'.$DbExport['Version'].'.exe</a><br /> <a href="'.
+            $this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">Export '.$ExportId.'</a></td>';
         else
-          $Output .= '<tr><td><a href="'.$System->Link('/export/?Action=View&amp;ExportId='.$ExportId.'&amp;Tab=7').'">Exportovat</a><br /> <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">Export '.$ExportId.'</a></td>';
+          $Output .= '<tr><td><a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.
+            $ExportId.'&amp;Tab=7').'">Exportovat</a><br /> <a href="'.
+            $this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">Export '.$ExportId.'</a></td>';
                                 
         $Output .= '<td>'.$DbExport['Title'].'</td>'; //.'<td>'.$DbExport['ClientVersion'].'</td>';
@@ -108 +127 @@
           $Output .= '<td>'.date('d.m.y H:i',filemtime($filename)).'</td>';
         else
-          $Output .= '<td></td>';
+          $Output .= '<td>&nbsp;</td>';
 
-                        //              '<td>'.$Export['OutputType'].'</td>'.
                                         $Output .= 
                                         '<td>'.str_replace("\n", '<br />',$DbExport['Description']).'</td>'.
-//                                      '<td><a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">Export '.$ExportId.'</a></td>'.
           '</tr>';
-      }
-                $Output .= '</table>';
-     
-    
+    }
+    $Output .= '</table>'.
+      $PageList['Output'];
+       
     return($Output);
   }
         
-        function Show() {
+        function Show() 
+        {
+                $this->Title = T('Download');
           $Output = '';
     if (isset($_GET['Files'])) $Output .= $this->ShowFiles();
@@ -128 +147 @@
   
     return($Output);
-  }
-        
+  }     
 }