Changeset 528

Timestamp:

Apr 21, 2013, 11:51:38 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Rychlé filtrování výpisu položek v tabulkách dle zadané hodnoty v jednotlivých sloupcích.

Location:

trunk

Files:

• Common/Version.php (modified) (1 diff)
• Modules/IS/IS.php (modified) (2 diffs)

trunk/Common/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 527; // Subversion revision
+$Revision = 528; // Subversion revision
 $DatabaseRevision = 527; // SQL structure revision
 $ReleaseTime = '2013-04-21';

trunk/Modules/IS/IS.php

@@ -170 +170 @@
     if($Table != '') $FormClass = $this->System->FormManager->Classes[$Table];
       else return($this->SystemMessage('Chyba', 'Tabulka nenalezena'));
-    if($Filter != '') $Filter = ' WHERE '.$Filter;
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM `'.$FormClass['Table'].'`'.$Filter);
     $DbRow = $DbResult->fetch_row();
@@ -191 +190 @@
     $Order = GetOrderTableHeader($TableColumns, $FormClass['DefaultSortColumn'], 0);
     $Output .= $Order['Output'];
-
+    
+    // Show search fields
+    $UserFilter = '';
+    if(array_key_exists('filter', $_GET) and ($_GET['filter'] == 1))
+    {
+      foreach($FormClass['Items'] as $ItemIndex => $FormItem)
+      if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
+          (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
+              ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne')))
+      {
+        if(array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != ''))
+          $UserFilter .= ' AND (`'.$ItemIndex.'` LIKE "%'.$_POST['Filter'.$ItemIndex].'%")';
+      }
+    }      
+    $Output .= '<tr><form action="?a=list&amp;filter=1" method="post">';
+    foreach($FormClass['Items'] as $ItemIndex => $FormItem)
+      if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
+          (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
+              ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne')))
+    {
+      if(array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != ''))
+        $Value = $_POST['Filter'.$ItemIndex];
+        else $Value = '';  
+      $Output .= '<td><input type="text" name="Filter'.$ItemIndex.'" value="'.$Value.'" style="width: 100%"/></td>';    
+    }
+    $Output .= '<td><input type="Submit" value="Hledat"/></td></form></tr>';
+
+    if(($Filter == '') and ($UserFilter != '')) $Filter = '1 '.$UserFilter; 
+    if($Filter != '') $Filter = ' WHERE '.$Filter;
     $Query = 'SELECT * FROM `'.$FormClass['Table'].'`'.$Filter.' '.$Order['SQL'].$PageList['SQLLimit'];