source: trunk/Packages/Common/Table.php

<?php

class Control
{
  public string $Name;

  function Show(): string
  {
    return '';
  }
}

class Table
{
  function GetCell($Y, $X): string
  {
    return '';
  }

  function BeginRead()
  {
  }

  function EndRead()
  {
  }

  function RowsCount(): int
  {
    return 0;
  }
}

class TableMemory extends Table
{
  public array $Cells;

  function GetCell($Y, $X): string
  {
    return $this->Cells[$Y][$X];
  }

  function RowsCount(): int
  {
    return count($this->Cells);
  }
}

class TableSQL extends Table
{
  public string $Query;
  public Database $Database;
  public array $Cells;

  function GetCell($Y, $X): string
  {
    return $this->Cells[$Y][$X];
  }

  function BeginRead()
  {
    $this->Cells = array();
    $DbResult = $this->Database->query($this->Query);
    while ($DbRow = $DbResult->fetch_row())
    {
      $this->Cells[] = $DbRow;
    }
  }

  function EndRead()
  {
    $this->Cells = array();
  }

  function RowsCount(): int
  {
    return count($this->Cells);
  }
}

class TableColumn
{
  public string $Name;
  public string $Title;
}

class VisualTable extends Control
{
  public array $Cells;
  public array $Columns;
  public string $OrderSQL;
  public string $OrderColumn;
  public int $OrderDirection;
  public array $OrderArrowImage;
  public string $DefaultColumn;
  public int $DefaultOrder;
  public TableMemory $Table;
  public string $Style;

  function __construct()
  {
    global $System;

    $this->Columns = array();
    $this->Table = new TableMemory();
    $this->OrderDirSQL = array('ASC', 'DESC');
    $this->OrderArrowImage = array($System->Link('/images/sort_asc.png'),
      $System->Link('/images/sort_desc.png'));
    $this->DefaultOrder = 0;
    $this->Style = 'BaseTable';
  }

  function SetColumns($Columns)
  {
    $this->Columns = array();
    foreach ($Columns as $Column)
    {
      $NewCol = new TableColumn();
      $NewCol->Name = $Column['Name'];
      $NewCol->Title = $Column['Title'];
      $this->Columns[] = $NewCol;
    }
    if (count($this->Columns) > 0)
      $this->DefaultColumn = $this->Columns[0]->Name;
      else $this->DefaultColumn = '';
  }

  function Show(): string
  {
    $Output = '<table class="'.$this->Style.'">';
    $Output .= $this->GetOrderHeader();
    $this->Table->BeginRead();
    for ($Y = 0; $Y < $this->Table->RowsCount(); $Y++)
    {
      $Output .= '<tr>';

      for ($X = 0; $X < count($this->Columns); $X++)
      {
        $Cell = $this->Table->GetCell($Y, $X);
        if ($Cell == '') $Output .= '<td>&nbsp;</td>';
          else $Output .= '<td>'.$Cell.'</td>';
      }
      $Output .= '</tr>';
    }
    $this->Table->EndRead();
    $Output .= '</table>';
    return $Output;
  }

  function GetOrderHeader(): string
  {
    if (array_key_exists('OrderCol', $_GET)) $_SESSION['OrderCol'] = $_GET['OrderCol'];
    if (array_key_exists('OrderDir', $_GET)) $_SESSION['OrderDir'] = $_GET['OrderDir'];
    if (!array_key_exists('OrderCol', $_SESSION)) $_SESSION['OrderCol'] = $this->DefaultColumn;
    if (!array_key_exists('OrderDir', $_SESSION)) $_SESSION['OrderDir'] = $this->DefaultOrder;

    // Check OrderCol
    $Found = false;
    foreach ($this->Columns as $Column)
    {
      if ($Column->Name == $_SESSION['OrderCol'])
      {
        $Found = true;
        break;
      }
    }
    if ($Found == false)
    {
      $_SESSION['OrderCol'] = $this->DefaultColumn;
      $_SESSION['OrderDir'] = $this->DefaultOrder;
    }
    // Check OrderDir
    if (($_SESSION['OrderDir'] != 0) and ($_SESSION['OrderDir'] != 1))
      $_SESSION['OrderDir'] = 0;

    $Result = '';
    $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
    foreach ($this->Columns as $Index => $Column)
    {
      $QueryItems['OrderCol'] = $Column->Name;
      $QueryItems['OrderDir'] = 1 - $_SESSION['OrderDir'];
      if ($Column->Name == $_SESSION['OrderCol'])
        $ArrowImage = '<img style="vertical-align: middle; border: 0px;" src="'.$this->OrderArrowImage[$_SESSION['OrderDir']].'" alt="order arrow">';
        else $ArrowImage = '';
      if ($Column->Name == '') $Result .= '<th>'.$Column->Title.'</th>';
        else $Result .= '<th><a href="?'.SetQueryStringArray($QueryItems).'">'.$Column->Title.$ArrowImage.'</a></th>';
    }
    $this->OrderSQL = ' ORDER BY `'.$_SESSION['OrderCol'].'` '.$this->OrderDirSQL[$_SESSION['OrderDir']];
    $this->OrderColumn = $_SESSION['OrderCol'];
    $this->OrderDirection = $_SESSION['OrderDir'];

    return '<tr>'.$Result.'</tr>';
  }
}