Changeset 483 for trunk/Common/Types/OneToMany.php

Timestamp:

Feb 7, 2013, 11:01:56 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: OneToMany vazba ve formulářích nyní využívá rozšířenou definici tabulky pomocí pole 'View'.
• Přidáno: Zobrazení síťových propojení ve správě dat.

File:

• trunk/Common/Types/OneToMany.php (modified) (2 diffs)

trunk/Common/Types/OneToMany.php

@@ -10 +10 @@
     if($Item['Value'] != '')
     {
+      if(array_key_exists('View', $Type['Parameters'])) $Table = $Type['Parameters']['View'];
+        else $Table = $Type['Parameters']['Table'];
       $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].
-        ' AS `Name` FROM `'.$Type['Parameters']['Table'].'` WHERE `'.
+        ' AS `Name` FROM '.$Table.' WHERE `'.
         $Type['Parameters']['Id'].'`='.$Item['Value']);
       $DbRow = $DbResult->fetch_assoc();
@@ -31 +33 @@
       $Output .= '<option value=""'.$Selected.'></option>';
     }
-    $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].' AS `Name`,'.$Type['Parameters']['Id'].' AS `Id` FROM `'.$Type['Parameters']['Table'].'`'.$Where.' ORDER BY `Name`');
+    if(array_key_exists('View', $Type['Parameters'])) $Table = $Type['Parameters']['View'];
+      else $Table = $Type['Parameters']['Table'];
+    $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].' AS `Name`,'.$Type['Parameters']['Id'].' AS `Id` FROM '.$Table.''.$Where.' ORDER BY `Name`');
     while($DbRow = $DbResult->fetch_assoc())
     {