Changeset 31 for types/PointerOneToOne.php

Timestamp:

Dec 16, 2008, 1:47:05 PM (16 years ago)

Author:

george

Message:

• Upraveno: Nezobrazovat vybraný sloupec v podseznamech.

File:

• types/PointerOneToOne.php (modified) (6 diffs)

types/PointerOneToOne.php

@@ -23 +23 @@
         {
           //print_r($Type);
-          $DbResult = $Database->select(array('Database' => $List['Database'], 'Table' => $List['TableName'], 'Condition' => 'Id='.$Item['Value']));
+          $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);
@@ -32 +32 @@
     }
     $Columns = substr($Columns, 0, -1);
-    if($Columns == '') $Columns = 'Id AS Name, Id';
-      else $Columns = 'CONCAT('.$Columns.') AS Name, Id';
-    $DbResult = $Database->select(array('Database' => $List['Database'], 'Table' => $TargetTable, 'Columns' => $Columns, 'Condition' => 'Id='.$Item['Value']));
+    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)
@@ -51 +51 @@
     foreach($List['Items'] as $ListItem)
       if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
-    $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, Id';
-    $DbResult = $Database->query('SELECT '.$Columns.' FROM `'.$TargetTable.'`');
+    $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)
@@ -69 +69 @@
 
     $Type = GetTypeDefinition($Item['Type']);
+    $List = GetListDefinition($Type['Parameters'][0]);
     $TargetTable = $Type['Parameters'][0];
     $TargetName = $this->GetTablePointerName($Type, $Item);
-    $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName['Id'].'">'.$TargetName['Name'].'</a>';
+    $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName[$List['IdName']].'">'.$TargetName['Name'].'</a>';
     return($Output);
   }
@@ -80 +81 @@
 
     $Type = $Types[$Item['Type']];
+    $List = GetListDefinition($Type['Parameters'][0]);
     $Output = '<select name="'.$Item['Name'].'">';
     $TargetNameList = $this->GetTablePointerNameList($Type, $Item);
@@ -85 +87 @@
     foreach($TargetNameList as $TargetName)
     {
-      if($Item['Value'] == $TargetName['Id']) $Selected = ' selected="1"'; else $Selected = '';
-      $Output .= '<option value="'.$TargetName['Id'].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
+      if($Item['Value'] == $TargetName[$List['IdName']]) $Selected = ' selected="1"'; else $Selected = '';
+      $Output .= '<option value="'.$TargetName[$List['IdName']].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
     }
     $Output .= '</select>';