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

Timestamp:

Oct 14, 2013, 12:26:30 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Možnost určovat položky formulářových typů jako virtuální zadané jako SQL poddotaz.

File:

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

trunk/Modules/IS/IS.php

@@ -282 +282 @@
           else $Value = '';        
         if($ItemIndex == 'Id') unset($Columns['Id']);
+        
+        if(!array_key_exists('SQL', $FormItem)) $FormItem['SQL'] = '';
+          else $FormItem['SQL'] = str_replace('#Id', '`'.$FormClass['Table'].'`.`Id`', $FormItem['SQL']);
         $Columns[] = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterNameQuery',
           array('Value' => $Value, 'Name' => $ItemIndex,
-              'Type' => $FormItem['Type']));
+            'Type' => $FormItem['Type'], 'SQL' => $FormItem['SQL']));
       }
       
@@ -332 +335 @@
     
     // Load and show items
-    $Query = 'SELECT * FROM (SELECT '.$Columns.' FROM `'.$FormClass['Table'].'`) AS `TS` '.$Filter.' '.$Order['SQL'].$PageList['SQLLimit'];    
+    $Query = 'SELECT * FROM (SELECT '.$Columns.' FROM `'.$FormClass['Table'].'`) AS `TS` '.
+      $Filter.' '.$Order['SQL'].$PageList['SQLLimit'];    
     $VisibleItemCount = 0;
     $DbResult = $this->Database->query($Query);
@@ -465 +469 @@
       }
       if($MenuItem['IconName'] != '') $Image = '<img src="../images/favicons/'.$MenuItem['IconName'].'"/>&nbsp;';
-        else $Image = '';
+        else $Image = '<img src="../images/favicons/blank.png"/>&nbsp;';
       $Output .= '<li>'.$Image.$LinkTitle.'</li>';
       $Output .= $this->ShowMenuItem($MenuItem['Id']);