Changeset 22 for trunk/www/types/PointerOneToOne.php

Timestamp:

Jun 12, 2009, 8:56:03 PM (15 years ago)

Author:

george

Message:

• Opraveno: Obnovena funkčnost formulářové položky typu PointerOneToOne a možnost volby databáze serveru.

File:

• trunk/www/types/PointerOneToOne.php (modified) (3 diffs)

trunk/www/types/PointerOneToOne.php

@@ -3 +3 @@
 class TypePointerOneToOne extends TypeBase
 {
-  function GetTablePointerName($Type, $Item)
-  {
-    global $Database;
-
-    //print_r($Item);
-    $Columns = '';
-    $List = GetListDefinition($Type['Parameters'][0]);
-    $TargetTable = $List['TableName'];
-    //echo($TargetTable.'<');
-    //print_r($List);
-    foreach($List['Items'] as $Index => $ListItem)
-    {
-      //echo('ListItem');
-      //print_r($ListItem);
-      $Type = GetTypeDefinition($ListItem['Type']);
-      if($ListItem['VisibleInPointer'] == 1)
-      {
-        if($Type['ParentType'] == TypePointerOneToOneId)
-        {
-          //print_r($Type);
-          $DbResult = $Database->select(array('Database' => $List['Database'], 'Table' => $List['TableName'], 'Condition' => $List['IdName'].'='.$Item['Value']));
-          $DbRow = $DbResult->fetch_assoc();
-          $DefinitionItem = array('Name' => $Index, 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'], 'Value' => $DbRow[$Index], 'SourceTable' => $List['Id'], 'SourceItemId' => 0);
-          $SubTarget = $this->GetTablePointerName($Type, $DefinitionItem);
-          $Columns .= '"'.$SubTarget['Name'].' ",';
-        } else $Columns .= '`'.$ListItem['Name'].'`," ",';
-      }
-    }
-    $Columns = substr($Columns, 0, -1);
-    if($Columns == '') $Columns = '`'.$List['IdName'].'` AS `Name`, `'.$List['IdName'].'`';
-      else $Columns = 'CONCAT('.$Columns.') AS `Name`, `'.$List['IdName'].'`';
-    $DbResult = $Database->select(array('Database' => $List['Database'], 'Table' => $TargetTable, 'Columns' => $Columns, 'Condition' => $List['IdName'].'='.$Item['Value']));
-    //echo($Database->LastQuery);
-    if($DbResult->num_rows > 0)
-    {
-      return($DbResult->fetch_assoc());
-    } else return('');
-  }
-
-  function GetTablePointerNameList($Type, $Item)
-  {
-    global $Database;
-
-    $Columns = '';
-    $List = GetListDefinition($Type['Parameters'][0]);
-    $TargetTable = $List['TableName'];
-    foreach($List['Items'] as $ListItem)
-      if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
-    $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, `'.$List['IdName'].'`';
-    $DbResult = $Database->select(array('Database' => $List['Database'], 'Table' => $TargetTable, 'Columns' => $Columns));
-    //echo($Database->LastQuery);
-    if($DbResult->num_rows > 0)
-    {
-
-      $Result = array(array('Name' => 'Žádný', 'Id' => 0));
-      while($DbRow = $DbResult->fetch_assoc())
-        $Result[] = $DbRow;
-      return($Result);
-    } else return(array());
-  }
-
   function OnView($Item)
   {
-    global $Database;
+    global $Database, $TypeDefinitionList;
 
-    $Type = GetTypeDefinition($Item['Type']);
+    $Type = $TypeDefinitionList[$Item['Type']];
+    $DbResult = $Database->query('SELECT '.$Type['Parameters']['Name'].' AS Name FROM `'.$Type['Parameters']['Table'].'` WHERE `'.$Type['Parameters']['Id'].'`='.$Item['Value']);
+    $DbRow = $DbResult->fetch_assoc();
+    $Output = $DbRow['Name'];
+    
+/*    $Type = GetTypeDefinition($Item['Type']);
     $List = GetListDefinition($Type['Parameters'][0]);
     $TargetTable = $Type['Parameters'][0];
@@ -74 +18 @@
     if($TargetName != '') $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName[$List['IdName']].'">'.$TargetName['Name'].'</a>';
     else $Output = '';
+    */
     return($Output);
   }
@@ -79 +24 @@
   function OnEdit($Item)
   {
-    global $Database, $Types;
+    global $Database, $TypeDefinitionList;
 
-    $Type = $Types[$Item['Type']];
-    $List = GetListDefinition($Type['Parameters'][0]);
     $Output = '<select name="'.$Item['Name'].'">';
-    $TargetNameList = $this->GetTablePointerNameList($Type, $Item);
-    //echo($Database->LastQuery);
-    foreach($TargetNameList as $TargetName)
+    $Type = $TypeDefinitionList[$Item['Type']];
+    $DbResult = $Database->query('SELECT '.$Type['Parameters']['Name'].' AS Name,'.$Type['Parameters']['Id'].' AS Id FROM `'.$Type['Parameters']['Table'].'`');
+    while($DbRow = $DbResult->fetch_assoc())
     {
-      if($Item['Value'] == $TargetName[$List['IdName']]) $Selected = ' selected="1"'; else $Selected = '';
-      $Output .= '<option value="'.$TargetName[$List['IdName']].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
+      if($Item['Value'] == $DbRow['Id']) $Selected = ' selected="1"'; else $Selected = '';
+      $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Name'].'</option>';
     }
     $Output .= '</select>';