Changeset 581 for trunk/Common/Form

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.

Location:

trunk/Common/Form

Files:

• Form.php (modified) (2 diffs)
• Types/Base.php (modified) (1 diff)

trunk/Common/Form/Form.php

@@ -136 +136 @@
             $UseType = 'Enumeration';
         } else $UseType = $Item['Type'];
+      if(!array_key_exists('SQL', $Item)) $Item['SQL'] = '';
+        else $Item['SQL'] = str_replace('#Id', $Id, $Item['SQL']);
       $Columns[] = $this->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterNameQuery',
-        array('Name' => $Index, 'Type' => $Item['Type']));
+        array('Name' => $Index, 'Type' => $Item['Type'], 'SQL' => $Item['SQL']));
     }
     $Columns = implode(',', $Columns);
@@ -227 +229 @@
             $this->FormManager->Type->RegisterType($Item['Type'], '', 
               $this->FormManager->FormTypes[$Item['Type']]);
-          if($this->FormManager->FormTypes[$Item['Type']]['Type'] == 'Reference') 
-            $UseType = 'OneToMany';
-          else if($this->FormManager->FormTypes[$Item['Type']]['Type'] == 'Enumeration') 
+          $CustomType = $this->FormManager->FormTypes[$Item['Type']]['Type'];
+          if($CustomType == 'Reference') 
+            $UseType = 'OneToMany';
+          else if($CustomType == 'Enumeration') 
             $UseType = 'Enumeration';
         } else $UseType = $Item['Type'];

trunk/Common/Form/Types/Base.php

@@ -47 +47 @@
   function OnFilterName($Item)
   {
-    return('`'.$Item['Name'].'`');
+    if($Item['SQL'] != '') $SQL = '('.$Item['SQL'].') AS ';
+      else $SQL = '';
+    return($SQL.'`'.$Item['Name'].'`');
   }
 
   function OnFilterNameQuery($Item)
   {
-    return('`'.$Item['Name'].'`, `'.$Item['Name'].'` AS `'.$Item['Name'].'_Filter`');
+    if($Item['SQL'] != '') 
+      $Output = '('.$Item['SQL'].') AS `'.$Item['Name'].'`, ('.$Item['SQL'].') AS `'.$Item['Name'].'_Filter`';
+      else $Output = '`'.$Item['Name'].'`, `'.$Item['Name'].'` AS `'.$Item['Name'].'_Filter`';
+    return($Output);
   }
 }