source: trunk/userlist.php@ 208

<?php
include_once('global.php');

class UserListPage extends Page
{
  var $FullTitle = 'Seznam registrovaných uživatelů';
  var $ShortTitle = 'Seznam uživatelů';

  function Show()
  {
    $Output = '<table class="WideTable" style="font-size: small;"><tr><th>Jméno uživatele</th><th>E-mail</th><th>ICQ</th><th>Telefon</th><th>Počítače</th></tr>';

    $DbResult = $this->Database->select('User', '*', 'Login != "Anonym" ORDER BY Name');
    while($User = $DbResult->fetch_assoc())
    {
      if($User['ICQ'] > 0) $ICQ = $User['ICQ']; else $ICQ = '&nbsp;';
      if($User['PhoneNumber'] > 0) $Phone = $User['PhoneNumber']; else $Phone = '&nbsp;';

      $DbResult2 = $this->Database->query('SELECT Name, Id FROM NetworkDevice WHERE Member = (SELECT Id FROM Member WHERE Member.ResponsibleUser = '.$User['Id'].') ORDER BY Name');
      $Devices = array();
      while($Device = $DbResult2->fetch_assoc())
      {
        $Devices[] = $Device['Name'];
      }
      $Devices = implode(', ', $Devices);
      $Output .= '<tr><td>'.$User['Name'].'</td><td>'.$User['Email'].'&nbsp;</td><td>'.$ICQ.'</td><td>'.$Phone.'</td><td>'.$Devices.'</td></tr>';
    }
    $Output .= '</table>';
    return($Output);
  }
}

$System->AddModule(new UserListPage());
$System->Modules['UserListPage']->GetOutput();

?>