Changeset 303 for trunk/userlist.php

Timestamp:

Jan 30, 2011, 8:19:57 AM (14 years ago)

Author:

george

Message:

• Přidáno: Stránka telefonního seznamu.
• Přidáno: Telefonní seznam, televizní kanály a seznam uživatelů nyní využívá stránkování a řazení sloupců.

File:

• trunk/userlist.php (modified) (2 diffs)

trunk/userlist.php

@@ -9 +9 @@
   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->query('SELECT COUNT(*) FROM `User` WHERE (`Login` != "Anonym")');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);    
 
-    $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;';
+    $Output = $PageList['Output'];
+    $Output .= '<table class="WideTable" style="font-size: small;">';
+   
+    $TableColumns = array(
+      array('Name' => 'Name', 'Title' => 'Jméno'), 
+      array('Name' => 'Email', 'Title' => 'E-mail'), 
+      array('Name' => 'ICQ', 'Title' => 'ICQ'), 
+      array('Name' => 'PhoneNumber', 'Title' => 'Telefón'), 
+      array('Name' => '', 'Title' => 'Počítače'), 
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
+    $Output .= $Order['Output'];
+
+    $Query = 'SELECT * FROM `User` WHERE (`Login` != "Anonym") '.$Order['SQL'].$PageList['SQLLimit'];
+
+    $DbResult = $this->Database->query($Query);
+    while($User = $DbResult->fetch_assoc()) 
+    { 
+      if($User['ICQ'] > 0) $User['ICQ'] = $User['ICQ']; 
+        else $User['ICQ'] = '&nbsp;';
+      if($User['PhoneNumber'] > 0) $User['PhoneNumber'] = $User['PhoneNumber']; 
+        else $User['PhoneNumber'] = '&nbsp;';
 
       $DbResult2 = $this->Database->query('SELECT Name, Id FROM NetworkDevice WHERE Member = (SELECT Id FROM Member WHERE Member.ResponsibleUser = '.$User['Id'].') AND Used=1 ORDER BY Name');
@@ -23 +42 @@
         $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>';
+      $User['Devices'] = implode(', ', $Devices);
+      
+      $Output .= '<tr><td>'.$User['Name'].'</td>'.
+      '<td>'.$User['Email'].'</td>'.
+      '<td>'.$User['ICQ'].'</td>'.
+      '<td>'.$User['PhoneNumber'].'</td>'.
+      '<td>'.$User['Devices'].'</td></tr>';
     }
     $Output .= '</table>';
+    $Output .= $PageList['Output'];
+    
     return($Output);
   }