Changeset 547 for trunk/Modules/User/UserList.php

Timestamp:

Jun 18, 2013, 6:58:22 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Uživatelská podpora přepracována na aplikační modul.

Location:

trunk/Modules/User

Files:

• . (added)
• UserList.php (moved) (moved from trunk/userlist.php ) (1 diff)

trunk/Modules/User/UserList.php

@@ -1 +1 @@
 <?php
 
-include('includes/global.php');
+
 include_once('img_level.php');
 
-ImgLevelUpdate();
-
-$Output = '';
-if(array_key_exists('search', $_GET))
+class PageUserList extends Page
 {
-  $_SESSION['Where'] = ' WHERE `User`.`Name` LIKE "%'.$_GET['search'].'%"'; 
+        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);
+        }       
 }
-if(array_key_exists('team', $_GET))
-{
-        $DbResult = $System->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 = $System->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 = $System->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'];
-          
-ShowPage($Output);
-
-?>