Changeset 795 for trunk/Modules/IS/IS.php

Timestamp:

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

Author:

chronos

Message:

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

File:

• trunk/Modules/IS/IS.php (modified) (3 diffs)

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)