source: trunk/www/table.php@ 15

<?php

class Table 
{
  var $Id;
  var $Definition;
  var $Values;
  var $Header;
  var $OnRow;
  var $QueryParameters;
  
  function __construct($ClassName)
  {
    global $FormClasses;

    $this->Definition = &$FormClasses[$ClassName];    
    $this->QueryParameters = array();
  }
  
  function Show()
  {
    $Header = array();
    if(!array_key_exists('Order', $_GET)) $_GET['Order'] = 0;
    if(!array_key_exists('Column', $_GET)) $_GET['Column'] = 0;
    $QueryParts = explode('&', $_SERVER['QUERY_STRING']);
    foreach($QueryParts as $Part)
    {
      $Part2 = explode('=', $Part);
      $QueryItems[$Part2[0]] = $Part2[1];
    }
    $QueryItems['Order'] = $_GET['Order'];
    foreach($this->Definition['Items'] as $Index => $Item)
    {
      $QueryItems['Column'] = $Index;
      if($_GET['Column'] == $Index) $QueryItems['Order'] = 1 - $_GET['Order'];
        else $QueryItems['Order'] = $_GET['Order'];
      $QueryParts = array();
      foreach($QueryItems as $Index2 => $Item2)
      {
        $QueryParts[] = $Index2.'='.$Item2;
      }
      $Header[] = '<a href="?'.implode('&amp;', $QueryParts).'">'.$Item['Caption'].'</a>';
    }
    $Table = array(
      'Header' => $Header,
      'Rows' => $this->Values,
    );
    $Output = Table($Table, 'WideTable');
    return($Output);
  }  
  
  function LoadValuesFromDatabase($Database)
  {   
    $OrderType = array('ASC', 'DESC');
    if(!array_key_exists('Order', $_GET)) $_GET['Order'] = 0;
    else if($_GET['Order'] == 'Asc') $_GET['Order'] = 1;
    if(!array_key_exists('Column', $_GET))
    {
      $Keys = array_keys($this->Definition['Items']);
      $_GET['Column'] = $Keys[0];
    }
    $this->Header = array();
    foreach($this->Definition['Items'] as $Index => $Item)
    {
      $this->Header[] = $Item['Caption'];
    }
    $this->Values = array();
    $Table = $this->Definition['Table'];
    foreach($this->QueryParameters as $Index => $Item)
      $Table = str_replace('%'.$Index, $Item, $Table);
    $DbResult = $Database->query('SELECT * FROM '.$Table.' ORDER BY T.'.$_GET['Column'].' '.$OrderType[$_GET['Order']]);
    while($DbRow = $DbResult->fetch_assoc())
    {
      if(method_exists($this->OnRow[0], $this->OnRow[1]))
      {
        $Object = $this->OnRow[0];
        $Method = $this->OnRow[1];
        $DbRow = $Object->$Method($DbRow);
      }
      $Row = array();
      foreach($this->Definition['Items'] as $Index => $Item)
      {
        $Row[] = $DbRow[$Index];
      }
      $this->Values[] = $Row;
    }
  }
}

?>