Changeset 182 for trunk/LogShow.php

Timestamp:

Mar 25, 2009, 3:08:48 PM (16 years ago)

Author:

george

Message:

• Opraveno: Stránkování na stránce zobrazání záznamů.
• Opraveno: Zobrazování stránky seznamu subjektů.

File:

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

trunk/LogShow.php

@@ -17 +17 @@
 
     $Output = '<div align="center"><table class="WideTable" style="font-size: small;">';
-    $Output .= '<tr><th>Čas</th><th>Modul</th><th>Uživatel</th><th>Operace</th><th>Hodnota</th></tr>';
-    $DbResult = $this->Database->query('SELECT *, `User`.`Name` as UserName FROM `is`.`Log` JOIN `is`.`User` ON `User`.`Id` = `Log`.`User` ORDER BY Time DESC LIMIT '.$Page.','.$this->RowPerPage);
+    $Output .= '<tr><th>Čas</th><th>Uživatel</th><th>Modul</th><th>Operace</th><th>Hodnota</th></tr>';
+    $DbResult = $this->Database->query('SELECT *, `User`.`Name` as UserName FROM `is`.`Log` LEFT JOIN `is`.`User` ON `User`.`Id` = `Log`.`User` ORDER BY Time DESC LIMIT '.$Page * $this->RowPerPage.','.$this->RowPerPage);
     while($DbRow = $DbResult->fetch_array())
     {
-      $Output .= '<tr><td>'.$DbRow['Time'].'</td><td>'.$DbRow['Module'].'</td><td>'.$DbRow['UserName'].'</td><td>'.$DbRow['Operation'].'</td><td>'.$DbRow['Value'].'</td></tr>';
+      $Output .= '<tr><td>'.$DbRow['Time'].'</td><td>'.$DbRow['UserName'].'</td><td>'.$DbRow['Module'].'</td><td>'.$DbRow['Operation'].'</td><td>'.$DbRow['Value'].'</td></tr>';
     }
     $Output .= '</table>';
@@ -30 +30 @@
 }
 
-
 $System->AddModule(new LogShow());
 $System->Modules['LogShow']->GetOutput();