source: trunk/www/Base/Types/PointerOneToOne.php

<?php

class TypePointerOneToOne extends TypeBase
{
  function OnView($Item)
  {
    global $TypeDefinitionList;

    $Type = $TypeDefinitionList[$Item['Type']];
    $DbResult = $this->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];
    $TargetName = $this->GetTablePointerName($Type, $Item);
    if($TargetName != '') $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName[$List['IdName']].'">'.$TargetName['Name'].'</a>';
    else $Output = '';
    */
    return($Output);
  }

  function OnEdit($Item)
  {
    global $TypeDefinitionList;

    $Output = '<select name="'.$Item['Name'].'">';
    $Type = $TypeDefinitionList[$Item['Type']];
    if(array_key_exists('Condition', $Type['Parameters'])) $Where = ' WHERE '.$Type['Parameters']['Condition'];
      else $Where = '';
    $DbResult = $this->Database->query('SELECT '.$Type['Parameters']['Name'].' AS Name,'.$Type['Parameters']['Id'].' AS Id FROM `'.$Type['Parameters']['Table'].'`'.$Where.' ORDER BY Name DESC');
    while($DbRow = $DbResult->fetch_assoc())
    {
      if($Item['Value'] == $DbRow['Id']) $Selected = ' selected="1"'; else $Selected = '';
      $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Name'].'</option>';
    }
    $Output .= '</select>';
    return($Output);
  }

  function OnLoad($Item)
  {
    return($_POST[$Item['Name']]);
  }
}