Changeset 19 for types/PointerOneToOne.php

Timestamp:

Oct 22, 2008, 9:12:20 AM (16 years ago)

Author:

george

Message:

• Upraveno: Typy přepsány z procedurálního zápisu na objektový.
• Přidáno: Zobrazení špičky použité paměti.
• Opraveno: Needitovat položky s neaktivním příznakem Editovatelné.

File:

• types/PointerOneToOne.php (modified) (1 diff)

types/PointerOneToOne.php

@@ -1 +1 @@
 <?php
 
-function GetTablePointerName($Type, $Item)
+class TypePointerOneToOne
 {
-  global $Database, $Lists;
+  function GetTablePointerName($Type, $Item)
+  {
+    global $Database, $Lists;
 
-  //print_r($Item);
-  $Columns = '';
-  $TargetTable = $Type['Parameters'][0];
+    //print_r($Item);
+    $Columns = '';
+    $TargetTable = $Type['Parameters'][0];
 
-  foreach($Lists[$TargetTable]['Items'] as $ListItem)
-    if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
-  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, ItemId, Id';
-  $DbResult = $Database->select($TargetTable, $Columns, 'ItemId='.$Item['Value'].' AND (DeletionTime IS NULL) ORDER BY Id DESC LIMIT 1');
-  //echo($Database->LastQuery);
-  if($DbResult->num_rows > 0)
+    foreach($Lists[$TargetTable]['Items'] as $ListItem)
+      if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
+    $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, ItemId, Id';
+    $DbResult = $Database->select($TargetTable, $Columns, 'ItemId='.$Item['Value'].' AND (DeletionTime IS NULL) ORDER BY Id DESC LIMIT 1');
+    //echo($Database->LastQuery);
+    if($DbResult->num_rows > 0)
+    {
+      return($DbResult->fetch_assoc());
+    } else return('');
+  }
+
+  function GetTablePointerNameList($Type, $Item)
   {
-    return($DbResult->fetch_assoc());
-  } else return('');
+    global $Database, $Lists;
+
+    $Columns = '';
+    $TargetTable = $Type['Parameters'][0];
+
+    foreach($Lists[$TargetTable]['Items'] as $ListItem)
+      if($ListItem['VisibleInPointer'] == 1) $Columns .= 't1.`'.$ListItem['Name'].'`," ",';
+    $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, t1.Id, t1.ItemId, t1.DeletionTime';
+    $DbResult = $Database->query('SELECT t3.* FROM (SELECT '.$Columns.' FROM `'.$TargetTable.'` AS t1 LEFT JOIN `'.$TargetTable.'` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL)) AS t3 WHERE t3.DeletionTime IS NULL');
+    //echo($Database->LastQuery);
+    if($DbResult->num_rows > 0)
+    {
+      $Result = array(array('Name' => 'Žádný', 'Id' => 0, 'ItemId' => 0));
+      while($DbRow = $DbResult->fetch_assoc())
+        $Result[] = $DbRow;
+      return($Result);
+    } else return(array());
+  }
+
+  function OnView($Item)
+  {
+    global $Database, $Lists, $Types;
+
+    $Type = $Types[$Item['Type']];
+    $TargetTable = $Type['Parameters'][0];
+    $TargetName = $this->GetTablePointerName($Type, $Item);
+    $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName['ItemId'].'">'.$TargetName['Name'].'</a>';
+    return($Output);
+  }
+
+  function OnEdit($Item)
+  {
+    global $Database, $Lists, $Types;
+
+    $Type = $Types[$Item['Type']];
+    $Output = '<select name="'.$Item['Name'].'">';
+    $TargetNameList = $this->GetTablePointerNameList($Type, $Item);
+    //echo($Database->LastQuery);
+    foreach($TargetNameList as $TargetName)
+    {
+      if($Item['Value'] == $TargetName['ItemId']) $Selected = ' selected="1"'; else $Selected = '';
+      $Output .= '<option value="'.$TargetName['ItemId'].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
+    }
+    $Output .= '</select>';
+    return($Output);
+  }
+
+  function OnLoad($Item)
+  {
+    return($_POST[$Item['Name']]);
+  }
 }
 
-function GetTablePointerNameList($Type, $Item)
-{
-  global $Database, $Lists;
-
-  $Columns = '';
-  $TargetTable = $Type['Parameters'][0];
-
-  foreach($Lists[$TargetTable]['Items'] as $ListItem)
-    if($ListItem['VisibleInPointer'] == 1) $Columns .= 't1.`'.$ListItem['Name'].'`," ",';
-  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, t1.Id, t1.ItemId, t1.DeletionTime';
-  $DbResult = $Database->query('SELECT t3.* FROM (SELECT '.$Columns.' FROM `'.$TargetTable.'` AS t1 LEFT JOIN `'.$TargetTable.'` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL)) AS t3 WHERE t3.DeletionTime IS NULL');
-  //echo($Database->LastQuery);
-  if($DbResult->num_rows > 0)
-  {
-    $Result = array(array('Name' => 'Žádný', 'Id' => 0, 'ItemId' => 0));
-    while($DbRow = $DbResult->fetch_assoc())
-      $Result[] = $DbRow;
-    return($Result);
-  } else return(array());
-}
-
-function TypePointerOneToOneOnView($Item)
-{
-  global $Database, $Lists, $Types;
-
-  $Type = $Types[$Item['Type']];
-  $TargetTable = $Type['Parameters'][0];
-  $TargetName = GetTablePointerName($Type, $Item);
-  $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName['ItemId'].'">'.$TargetName['Name'].'</a>';
-  return($Output);
-}
-
-function TypePointerOneToOneOnEdit($Item)
-{
-  global $Database, $Lists, $Types;
-
-  $Type = $Types[$Item['Type']];
-  $Output = '<select name="'.$Item['Name'].'">';
-  $TargetNameList = GetTablePointerNameList($Type, $Item);
-  //echo($Database->LastQuery);
-  foreach($TargetNameList as $TargetName)
-  {
-    if($Item['Value'] == $TargetName['ItemId']) $Selected = ' selected="1"'; else $Selected = '';
-    $Output .= '<option value="'.$TargetName['ItemId'].'"'.$Selected.'>'.$TargetName['Name'].'</option>';
-  }
-  $Output .= '</select>';
-  return($Output);
-}
-
-function TypePointerOneToOneOnLoad($Item)
-{
-  return($_POST[$Item['Name']]);
-}
+$TypeDefinitionList['PointerOneToOne'] = new TypePointerOneToOne;
 
 ?>