Changeset 639 for trunk/includes/Page.php

Timestamp:

Dec 11, 2013, 10:21:12 PM (11 years ago)

Author:

chronos

Message:

• Added: Make server list more general to cover also non-translated servers.
• Added: Partialy implemented generic view named PageEdit which serve as template to present item lists, add, delete and modify items.

File:

• trunk/includes/Page.php (modified) (1 diff)

trunk/includes/Page.php

@@ -26 +26 @@
   }
 }
+
+class PageEdit extends Page
+{
+        var $Table;
+        var $Definition;
+        
+        function __construct($System)
+        {
+    parent::__construct($System);
+    $this->Table = '';
+    $this->Definition = array();
+        }
+        
+        function Show()
+        {
+                $Output = '';
+        if(array_key_exists('action', $_GET)) 
+    {
+      if($_GET['action'] == 'add') $Output .= $this->AddItem(); 
+      else if($_GET['action'] == 'view') $Output .= $this->ViewItem();
+      else if($_GET['action'] == 'remove') $Output .= $this->RemoveItem();
+      else if($_GET['action'] == 'delete') $Output .= $this->DeleteItem();
+      else $Output .= ShowMessage(T('Unknown action'), MESSAGE_CRITICAL);
+    } else $Output .= $this->ViewList();       
+    return($Output); 
+  }
+  
+  function ViewItem()
+  {
+        $Output = '';
+        return($Output);
+  }
+
+  function ViewList()
+  {
+                $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$this->TableSQL.') AS `T`');
+                $DbRow = $DbResult->fetch_row();
+                $PageList = GetPageList($DbRow[0]);
+                $Output = $PageList['Output'];
+        
+                $Output .= '<table class="BaseTable">';
+                $TableColumns = array();
+                foreach($this->Definition as $Index => $Def)
+                  $TableColumns[] = array('Name' => $Index, 'Title' => $Def['Title']);
+        
+                $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
+                $Output .= $Order['Output'];
+        
+                $DbResult = $this->Database->query('SELECT * FROM ('.$this->Table.') '.$Order['SQL'].$PageList['SQLLimit']);
+                while($Item = $DbResult->fetch_assoc())
+                {
+                        $Output .= '<tr>';
+      foreach($this->Definition as $Index => $Def)
+      {
+        if($Def['Type'] == 'URL') $Output .= '<td><a href="'.$Item[$Index].'">'.$Item[$Index].'</a></td>';
+                else $Output .= '<td>'.$Item[$Index].'</td>';
+      }
+                  $Output .= '</tr>';   
+                }
+                $Output .= '</table>';          
+                return($Output);
+  }
+        
+        function AddItem()
+  {
+    $Output = '';
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+        if(array_key_exists('finish', $_GET))
+        {
+                $Items = array();
+                foreach($this->Definition as $Index => $Def)
+                {
+                        $Items[$Index] = $_POST[$Index]; 
+                }
+                $this->Database->insert($this->Table, $Items);
+          $Output = ShowMessage(T('Item added'), MESSAGE_INFORMATION);  
+        } else 
+        {
+      $Output .= '<form action="?action=add&amp;finish=1" method="post">'.
+        '<fieldset><legend>'.T('New item').'</legend>'.
+        '<table>';
+      foreach($this->Definition as $DefIndex => $Def)
+      {
+              $Output .= '<tr><td>'.$Def['Title'].'</td><td>'.$this->GetControl($Def['Type'], $DefIndex).'</tr>';
+      }        
+      $Output .= '<tr><td colspan="2"><input type="submit" value="'.T('Add').'" /></td></tr>'.
+        '</table>'.
+        '</fieldset>'.
+        '</form>';
+        }
+    } else $Output .= ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output); 
+  }
+        
+        
+        function DeleteItem()
+  {
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      $this->Database->query('DELETE FROM `'.$this->Table.'` WHERE (`User`='.$this->System->User->Id.') AND (`Id`='.($_GET['id'] * 1).')');
+      $Output = ShowMessage(T('Record removed'));
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+  
+  function GetControl($Type, $Name)
+  {
+        if($Type == 'Text') $Output = '<input type="text" name="'.$Name.'"/>';
+        else if($Type == 'Boolean') $Output = '<input type="checkbox" name="'.$Name.'"/>';
+        else $Output = '<input type="text" name="'.$Name.'"/>';
+  }     
+}