Changeset 383 for trunk/Common/ViewList.php

Timestamp:

Jan 23, 2012, 10:37:31 AM (13 years ago)

Author:

chronos

Message:

• Přidáno: Kostra základního systémového modulu System.
• Přidáno: Obsluha datových typů pro HTML kód a HTTP protokol.
• Upraveno: Do ViewList zkopírování generování tabulky se stránkováním a řazením.

File:

• trunk/Common/ViewList.php (modified) (1 diff)

trunk/Common/ViewList.php

@@ -3 +3 @@
 class ViewList extends View
 {
-  function __construct($Database)
+  var $DefaultOrder;
+  var $Columns;
+  var $SQL;
+  var $SQLJoin;
+  var $Rows;
+  var $Actions;
+  var $PageList;
+  var $TableHeader;
+  var $FilterColumn;
+  var $Module;
+  var $PanelAction;
+
+  function __construct($System)
   {
-    $this->Database = &$Database;    
+    parent::__construct($System);
+    $this->FilterColumn = '';
+    $this->FilterId = 0;
+    $this->PageList = new PageList($this->System);
+    $this->TableHeader = new TableHeader($this->System);
+    $this->Rows = array();
+    $this->PanelAction = 'ListPanel';
+    $this->DefaultOrder = array();
   }
 
+  function Show()
+  {
+    $Output = $this->PageList->Output;
+    $Output .= '<table class="WideTable">';
+    $Output .= $this->TableHeader->Output;
+    foreach($this->Rows as $Row2)
+    {
+      $Row = array();
+      foreach($Row2 as $Index => $Item)
+        $Row[$Index]['Value'] = $Item;
+      $Row = $this->ProcessRow($Row);
+
+      $Output .= '<tr>';
+      foreach($this->Columns as $ColumnName => $Column)
+      if($Column['Type'] != 'Hidden')
+      {
+        if(array_key_exists('Class', $Row[$ColumnName]) and ($Row[$ColumnName]['Class'] != ''))
+          $Style = ' class="'.$Row[$ColumnName]['Class'].'"'; else $Style ='';
+        $Output .= '<td'.$Style.'>';
+        $Output .= $this->System->Type->ExecuteTypeEvent($Column['Type'],
+          'OnView', array('Name' => $ColumnName, 'Value' => $Row[$ColumnName]['Value'], 'Type' => $Column['Type']));
+        $Output .= '</td>';
+      }
+      if(is_array($this->Actions))
+      {
+        $Output .= '<td>';
+        foreach($this->Actions as $Action)
+        {
+          if(array_key_exists('Confirm', $Action)) $Confirm = ' onclick="return confirmAction(\''.$this->System->Localization->Translate($Action['Confirm']).'\');"';
+            else $Confirm = '';
+          if(strpos($Action['Name'], '<') !== false) $ActionName = $Action['Name'];
+            else $ActionName = $this->System->Localization->Translate($Action['Name']);
+          $Output .= '<a'.$Confirm.' href="'.$this->System->Navigation->MakeLink($Action['Module'], $Action['Action'], array('Id' => $Row['Id']['Value'])).'">'.
+            $ActionName.'</a> ';
+        }
+        $Output .= '</td>';
+      }
+      $Output .= '</tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $this->PageList->Output;
+    return($Output);
+  }
+
+  function LoadFromDatabase()
+  {
+    // Get total item count
+    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM '.$this->Name.
+      ' '.$this->SQLJoin);
+    $DbRow = $DbResult->fetch_row();
+    $this->PageList->TotalCount = $DbRow[0];
+    $this->PageList->HTMLId = $this->Module;
+    $this->PageList->QueryItems->Data['M'] = $this->Module;
+    $this->PageList->QueryItems->Data['A'] = $this->PanelAction;
+    $this->PageList->QueryItems->Data['FilterColumn'] = $this->FilterColumn;
+    $this->PageList->Process();
+
+    // Build table header and ordering
+    $this->TableHeader->QueryItems = $this->PageList->QueryItems;
+    $this->TableHeader->HTMLId = $this->Module;
+    $this->TableHeader->Columns = array();
+    foreach($this->Columns as $Item)
+    {
+      $this->TableHeader->Columns[$Item['Name']] = array('Title' => $Item['Title'], 
+        'Type' => $Item['Type'], 'SQL' => $Item['SQL']);
+    }
+    if(is_array($this->Actions))
+      $this->TableHeader->Columns['Actions'] = array('Type' => 'String', 'SQL' => '');
+    $this->TableHeader->DefaultOrder = $this->DefaultOrder;
+    $this->TableHeader->Process();
+
+    //$this->System->Navigation->UnsetParameter('Panel');
+
+    // Build column list
+    $Columns = $this->Name.'.Id';
+    foreach($this->Columns as $ColumnName => $Column)
+      $Columns .= ', '.$Column['SQL'].' AS `'.$ColumnName.'`';
+
+    $this->DbRows = array();
+    $DbResult = $this->System->Database->query('SELECT '.$Columns.' FROM '.$this->Name.
+      ' '.$this->SQLJoin.$this->TableHeader->SQL.$this->PageList->SQLLimit);
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $this->Rows[] = $DbRow;
+    }
+  }
+
+  function ProcessRow($Row)
+  {
+    return($Row);
+  }
+  
   function AddItemString($Name, $Title)
   {
-    $this->Items[$Name] = array('Name' => $Name, 'Title' => $Title, 
-      'Type' => ViewItemTypeString);
-  } 
-  
+    $this->Columns[$Name] = array('Name' => $Name, 'Title' => $Title, 
+      'Type' => ViewItemTypeString, 'SQL' => $Name);
+  }   
 }