Changeset 795

Timestamp:

Feb 4, 2016, 3:42:03 PM (8 years ago)

Author:

chronos

Message:

• Modified: In module IS use slow HAVING in SQL query for user filter. To show subtables use faster WHERE.

Location:

trunk

Files:

• Application/System.php (modified) (1 diff)
• Application/Version.php (modified) (1 diff)
• Modules/IS/IS.php (modified) (3 diffs)
• Modules/Network/Network.php (modified) (1 diff)

trunk/Application/System.php

@@ -165 +165 @@
       $this->Database->ShowSQLError = $this->Config['Web']['ShowSQLError'];
       $this->Database->ShowSQLQuery = $this->Config['Web']['ShowSQLQuery'];
+      if(isset($this->Config['Web']['LogSQLQuery']))
+        $this->Database->LogSQLQuery = $this->Config['Web']['LogSQLQuery'];
     } catch (Exception $E) {
       //$Output .= 'Nelze se připojit k databázi.';

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 793; // Subversion revision
+$Revision = 794; // Subversion revision
 $DatabaseRevision = 792; // SQL structure revision
-$ReleaseTime = strtotime('2016-02-03');
+$ReleaseTime = strtotime('2016-02-04');

trunk/Modules/IS/IS.php

@@ -414 +414 @@
       else $SourceTable = '`'.$FormClass['Table'].'` AS `TX`';
 
+    $WhereFilter = $Filter;
+    $HavingFilter = '';
+
     // Build form type filter
     $TypeFilter = '';
@@ -427 +430 @@
     if($TypeFilter != '')
     {
-      if($Filter != '') $Filter = ' AND';
-      $Filter .= ' '.$TypeFilter;
+      if($HavingFilter != '') $HavingFilter = ' AND';
+      $HavingFilter .= ' '.$TypeFilter;
     }
 
@@ -465 +468 @@
     if($UserFilter != '')
     {
-      if($Filter != '') $Filter .= ' AND';
-      $Filter .= ' '.$UserFilter;
-    }
-    if($Filter != '') $Filter = ' HAVING '.$Filter;
+      if($HavingFilter != '') $Havingilter .= ' AND';
+      $HavingFilter .= ' '.$UserFilter;
+    }
+    if($WhereFilter != '') $Filter = ' WHERE '.$WhereFilter;
+    if($HavingFilter != '') $Filter = ' HAVING '.$HavingFilter;
+
 
     foreach($FormClass['Items'] as $ItemIndex => $FormItem)

trunk/Modules/Network/Network.php

@@ -192 +192 @@
         'Signal' => array('Type' => 'TNetworkSignalListInterface', 'Caption' => 'Signál', 'Default' => ''),
         'Wireless' => array('Type' => 'TNetworkInterfaceWirelessListInterface', 'Caption' => 'Bezdrátové spoje', 'Default' => ''),
-
       ),
     ));