source: trunk/Modules/User/UserList.php@ 577

<?php

include_once(dirname(__FILE__).'/../../img_level.php');

class PageUserList extends Page
{
        function Show()
        {
                ImgLevelUpdate();
        
                $Output = '';
                if(array_key_exists('search', $_GET))
                {
                        $_SESSION['Where'] = ' WHERE `User`.`Name` LIKE "%'.$_GET['search'].'%"';
                }
                if(array_key_exists('team', $_GET))
                {
                        $DbResult = $this->Database->select('Team', 'Name', 'Id='.$_GET['team']);
                        if($DbResult->num_rows > 0)
                        {
                                $Team = $DbResult->fetch_assoc();
                                $Output .= '<h3>Seznam uživatelů v týmu '.$Team['Name'].'</h3>';
                                $_SESSION['Where'] = ' WHERE `Team`='.$_GET['team'];
                                if($_GET['team'] == '') $_SESSION['Where'] = '';
                        } else {
                  $Output .= ShowMessage('Tým '.$_GET['team'].' nenalezen', MESSAGE_CRITICAL);
                  $_SESSION['Where'] = ' WHERE FALSE';
                        }
                } else
                {
                        $Output .= '<h3>Seznam uživatelů</h3>';
                        if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';
                }
        
                if(array_key_exists('action', $_GET))
                {
                        if($_GET['action'] == 'nofilter') $_SESSION['Where'] = '';
                }
                //if($_SESSION['Where'] <> '') $Output .= ' <a href="?action=nofilter">Zrušit filtr uživatelů</a><br />';
        
                $DbResult = $this->Database->query('SELECT COUNT(*) FROM `User`'.$_SESSION['Where']);
                $DbRow = $DbResult->fetch_row();
                $PageList = GetPageList($DbRow[0]);
        
                $Output .= $PageList['Output'].
                '<table class="BaseTable">';
        
                $TableColumns = array(
                        array('Name' => 'Name', 'Title' => 'Jméno'),
                        array('Name' => 'TranslatedCount', 'Title' => 'Překladů'),
                        array('Name' => 'XP', 'Title' => 'Úroveň'),
                        array('Name' => 'XP', 'Title' => 'Zkušenost'),
                        //array('Name' => 'GM', 'Title' => 'Oprávnění'),
                        array('Name' => 'LastLogin', 'Title' => 'Naposledy přítomen'),
                        array('Name' => 'RegistrationTime', 'Title' => 'Čas registrace'),
                );
                $Order = GetOrderTableHeader($TableColumns, 'TranslatedCount', 1);
                $Output .= $Order['Output'];
        
        
                $Query = 'SELECT `User`.`ID`, `User`.`Name`, `LastLogin`, `GM`, `XP`, `TranslatedCount`, `RegistrationTime` '.
                                'FROM `User` '.
                                'LEFT JOIN `UserTrace` ON `UserTrace`.`User` = `User`.`Id` '.
                                $_SESSION['Where'].$Order['SQL'].$PageList['SQLLimit'];
        
                $DbResult = $this->Database->query($Query);
                while($Line = $DbResult->fetch_assoc())
                {
                        $XP = GetLevelMinMax($Line['XP']);
                        $Output .= '<tr><td><a href="user.php?user='.$Line['ID'].'">'.$Line['Name'].'</a></td>'.
                                        '<td style="text-align: center;"><a href="TranslationList.php?user='.$Line['ID'].'&amp;group=0&amp;state=2" title="Zobrazit Všechny jeho přeložené texty">'.$Line['TranslatedCount'].'</a></td>'.
                                        '<td>'.$XP['Level'].'</td>'.
                                        '<td>'.ProgressBar(150, round($XP['XP'] / $XP['MaxXP'] * 100, 2), $XP['XP'].' / '.$XP['MaxXP']).'</td>'.
                                        //<td>'.$Moderators[$Line['GM']].'</td>
                        '<td>'.HumanDate($Line['LastLogin']).'</td>'.
                        '<td>'.HumanDate($Line['RegistrationTime']).'</td></tr>';
                }
                $Output .= '</table>'.
                                $PageList['Output'];
        
                return($Output);
        }       
}