Changeset 636 for trunk/Common/Table.php

Timestamp:

Jan 21, 2014, 12:02:53 AM (11 years ago)

Author:

chronos

Message:

• Upraveno: Tabulka měsíčních přehledů přepracována s použitím obecných tříd. Nyní podporuje řazení a stránkování. Celkové součty byly odebrány.

File:

• trunk/Common/Table.php (modified) (5 diffs)

trunk/Common/Table.php

@@ -11 +11 @@
 }
 
+class Table
+{
+        function GetCell($Y, $X)
+        {
+                return('');
+        }
+
+        function BeginRead()
+        {
+        }
+        
+        function EndRead()
+        {
+        }
+        
+  function RowsCount()
+  {
+        return(0);
+  }
+}
+
+class TableMemory extends Table
+{
+        var $Cells;
+        
+        function GetCell($Y, $X)
+        {
+                return($this->Cells[$Y][$X]);
+        }
+
+  function RowsCount()
+  {
+        return(count($this->Cells));
+  }
+}
+
+class TableSQL extends Table
+{
+        var $Query;
+        var $Database;
+        var $Cells;     
+        
+        function GetCell($Y, $X)
+        {
+                return($this->Cells[$Y][$X]);
+        }
+        
+        function BeginRead()
+        {
+                $this->Cells = array();
+                $DbResult = $this->Database->query($this->Query);
+                while($DbRow = $DbResult->fetch_row())
+                {
+                        $this->Cells[] = $DbRow;
+                }
+        }
+        
+        function EndRead()
+        {
+                $this->Cells = array();
+        }
+
+  function RowsCount()
+  {
+        return(count($this->Cells));
+  }
+}
+
 class TableColumn
 {
@@ -17 +85 @@
 }
 
-class Table extends Control
+class VisualTable extends Control
 {
   var $Cells;
   var $Columns;
-  var $OrderDirSQL;
+  var $OrderSQL;
+  var $OrderColumn;
+  var $OrderDirection;
   var $OrderArrowImage;
   var $DefaultColumn;
   var $DefaultOrder;
+  var $Table;
   
   function __construct()
@@ -31 +102 @@
         
         $this->Columns = array();
-        $this->Cells = array();
+        $this->Table = new TableMemory();
     $this->OrderDirSQL = array('ASC', 'DESC');
     $this->OrderArrowImage = array($System->Link('/images/sort_asc.png'), 
@@ -57 +128 @@
           $Output = '<table class="WideTable">';
           $Output .= $this->GetOrderHeader();
-        foreach($this->Cells as $Row)
+          $this->Table->BeginRead();
+        for($Y = 0; $Y < $this->Table->RowsCount(); $Y++)
         {
             $Output .= '<tr>';
-            foreach($Row as $Cell)
+            
+            for($X = 0; $X < count($this->Columns); $X++)
             {
+                $Cell = $this->Table->GetCell($Y, $X);
                 if($Cell == '') $Output .= '<td>&nbsp;</td>'; 
                     else $Output .= '<td>'.$Cell.'</td>';
-            }
+            }       
             $Output .= '</tr>';
           }
+          $this->Table->EndRead();
           $Output .= '</table>';
     return($Output);
@@ -109 +184 @@
         else $Result .= '<th><a href="?'.SetQueryStringArray($QueryItems).'">'.$Column->Title.$ArrowImage.'</a></th>';
     }
-    $this->SQL = ' ORDER BY `'.$_SESSION['OrderCol'].'` '.$this->OrderDirSQL[$_SESSION['OrderDir']];
-    $this->Column = $_SESSION['OrderCol'];
-    $this->Direction = $_SESSION['OrderDir'];
+    $this->OrderSQL = ' ORDER BY `'.$_SESSION['OrderCol'].'` '.$this->OrderDirSQL[$_SESSION['OrderDir']];
+    $this->OrderColumn = $_SESSION['OrderCol'];
+    $this->OrderDirection = $_SESSION['OrderDir'];
  
     return($Result);