Changeset 268 for trunk/network/dostupnost.php

Timestamp:

Jan 6, 2010, 1:43:24 PM (15 years ago)

Author:

george

Message:

• Opraveno: Vypisování dostupnosti počítačů v časových periodách.

File:

• trunk/network/dostupnost.php (modified) (3 diffs)

trunk/network/dostupnost.php

@@ -1 +1 @@
 <?php
-
-die();
 
 include_once('../global.php');
@@ -9 +7 @@
   var $FullTitle = 'Dostupnost aktivních prvků sítě';
   var $ShortTitle = 'Dostupnost sítě';
+  var $Period = array(
+    array('Column' => 'Hour', 'Title' => 'Hodina', 'Period' => 1), 
+    array('Column' => 'Day', 'Title' => 'Den', 'Period' => 24), 
+    array('Column' => 'Week', 'Title' => 'Týden', 'Period' => 168), // 24 * 7  
+    array('Column' => 'Month', 'Title' => 'Měsíc', 'Period' => 720), // 24 * 30
+    array('Column' => 'Year', 'Title' => 'Rok', 'Period' => 8760), // 365 * 24
+    array('Column' => 'TenYear', 'Title' => 'Desetiletí', 'Period' => 87600), // 365 * 24 * 10
+  );
 
   function Show()
@@ -23 +29 @@
     // Zařízení
     $Output .= '<br /><table class="WideTable" style="font-size: small;">';
-    $Output .= '<tr><th>Jméno</th><th>Hodina [%]</th><th>Den [%]</th><th>Týden [%]</th><th>Měsíc [%]</th><th>Rok [%]</th></tr>';
-    $DbResult = $this->Database->query('SELECT NetworkDevice.Id, NetworkDevice.Type, NetworkDevice.Name FROM NetworkDevice WHERE NetworkDevice.Used = 1 AND NetworkDevice.Type IN (1, 4, 5) ORDER BY Name');
-    while($Device = $DbResult->fetch_assoc())
+    $Output .= '<tr><th>Jméno</th>';
+    foreach($this->Period as $Period)
+      $Output .= '<th>'.$Period['Title'].' [%]</th>';
+    $Output .= '</tr>';
+    
+    $Join = '';
+    $Columns = '';
+    foreach($this->Period as $Period)
     {
-       $DbResult2 = $this->Database->query('SELECT NetworkInterface.Name, PeriodHour.Percent AS Hour, PeriodDay.Percent AS Day, PeriodWeek.Percent AS Week, PeriodMonth.Percent AS Month, PeriodYear.Percent AS Year FROM NetworkInterface 
-    LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat. PingCount) / 1 / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 1 HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) as PeriodHour ON PeriodHour.NetworkInterface = NetworkInterface.Id 
-    LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat.PingCount) / 24 / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) AS PeriodDay ON PeriodDay.NetworkInterface = NetworkInterface.Id 
-    LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat.PingCount) / 24 / 7 / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 7 HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) AS PeriodWeek ON PeriodWeek.NetworkInterface = NetworkInterface.Id 
-    LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat.PingCount) / 24 / 30 / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 30 HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) AS PeriodMonth ON PeriodMonth.NetworkInterface = NetworkInterface.id 
-    LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat.PingCount) / 24 / 365 / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 365 HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) AS PeriodYear ON PeriodYear.NetworkInterface = NetworkInterface.Id 
-   WHERE NetworkInterface.Device = '.$Device['Id']);
-      while($Interface = $DbResult2->fetch_assoc())
-      {
-        $Name = $Device['Name'];
-        if($Interface['Name'] != '') $Name .= '-'.$Interface['Name'];
-        $Output .= '<tr><td>'.$Name.'</td><td style="text-align: right;">'.sprintf('%01.2f', $Interface['Hour']).'</td><td style="text-align: right;">'.sprintf('%01.2f', $Interface['Day']).'</td><td style="text-align: right;">'.sprintf('%01.2f', $Interface['Week']).'</td><td style="text-align: right;">'.sprintf('%01.2f', $Interface['Month']).'</td><td style="text-align: right;">'.sprintf('%01.2f', $Interface['Year']).'</td></tr>';
-      }
+      $Join .= ' LEFT JOIN (SELECT NetworkInterfaceStat.NetworkInterface, (SUM(NetworkInterfaceStat. PingCount) / '.$Period['Period'].' / 60 * 100) AS Percent FROM NetworkInterfaceStat WHERE (Time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL '.$Period['Period'].' HOUR)) AND (Time < DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY NetworkInterface) AS Period'.$Period['Column'].' ON Period'.$Period['Column'].'.NetworkInterface = NetworkInterface.Id';
+      $Columns .= ', Period'.$Period['Column'].'.Percent AS '.$Period['Column'];
+    }
+      
+    $DbResult2 = $this->Database->query('SELECT NetworkInterface.Name'.$Columns.', NetworkDevice.Name AS DeviceName FROM NetworkInterface '.$Join.' JOIN NetworkDevice ON NetworkInterface.Device = NetworkDevice.Id WHERE NetworkDevice.Used = 1 AND NetworkDevice.Type IN (1, 4, 5) ORDER BY Name');
+    while($Interface = $DbResult2->fetch_assoc())
+    {
+      $Name = $Interface['DeviceName'];
+      if($Interface['Name'] != '') $Name .= '-'.$Interface['Name'];
+      $Output .= '<tr><td>'.$Name.'</td>';
+      foreach($this->Period as $Period)
+        $Output .= '<td style="text-align: right;">'.sprintf('%01.2f', $Interface[$Period['Column']]).'</td>';
+      $Output .= '</tr>';
     }
     $Output .= '</table></div>';