Changeset 9 for types/PointerOneToOne.php

Timestamp:

Oct 11, 2008, 11:06:21 PM (16 years ago)

Author:

george

Message:

• Přidáno: Částečná podpora pro historii všech záznamů. Editace vytváří nový záznam. Zobrazení historie dané položky.

File:

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

types/PointerOneToOne.php

@@ -1 +1 @@
 <?php
 
-function TypePointerOneToOneViewHtml($Type, $Item)
+function GetTablePointerName($Type, $Item)
 {
   global $Database, $Lists;
 
-  //print_r($Type);
-  $Output = '';
   $Columns = '';
   $ItemType = explode(':', $Item['Type']);
@@ -18 +16 @@
   if($DbResult->num_rows > 0)
   {
-    $DbRow = $DbResult->fetch_array();
-    $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$DbRow['Id'].'">'.$DbRow['Name'].'</a>';
-  }
+    return($DbResult->fetch_assoc());
+  } else return('');
+}
+
+function GetTablePointerNameList($Type, $Item)
+{
+  global $Database, $Lists;
+
+  $Columns = '';
+  $ItemType = explode(':', $Item['Type']);
+  $TargetTable = $ItemType[1];
+
+  foreach($Lists[$TargetTable]['Items'] as $ListItem)
+    if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
+  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, Id';
+  $DbResult = $Database->select($TargetTable, $Columns);
+  //echo($Database->LastQuery);
+  if($DbResult->num_rows > 0)
+  {
+    $Result = array();
+    while($DbRow = $DbResult->fetch_assoc())
+      $Result[] = $DbRow;
+    return($Result);
+  } else return(array());
+}
+
+function TypePointerOneToOneViewHtml($Type, $Item)
+{
+  global $Database, $Lists;
+
+  $ItemType = explode(':', $Item['Type']);
+  $TargetTable = $ItemType[1];
+  $TargetName = GetTablePointerName($Type, $Item);
+  $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName['Id'].'">'.$TargetName['Name'].'</a>';
   return($Output);
 }
@@ -29 +58 @@
 
   $Output = '<select name="'.$Item['Name'].'">';
-  $Columns = '';
-  $ItemType = explode(':', $Item['Type']);
-  $TargetTable = $ItemType[1];
-  foreach($Lists[$TargetTable]['Items'] as $ListItem)
-    if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
-  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, Id';
-  $DbResult = $Database->select($TargetTable, $Columns);
+  $TargetNameList = GetTablePointerNameList($Type, $Item);
   //echo($Database->LastQuery);
-  while($DbRow = $DbResult->fetch_array())
+  foreach($TargetNameList as $TargetName)
   {
-    if($Parameter == $DbRow['Id']) $Selected = ' selected="1"'; else $Selected = '';
-    $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Name'].'</option>';
+    if($Item['Value'] == $TargetName['Id']) $Selected = ' selected="1"'; else $Selected = '';
+    $Output .= '<option value="'.$TargetName['Id'].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
   }
   $Output .= '</select>';