Changeset 284 for trunk/network/dostupnost.php

Timestamp:

Sep 1, 2010, 5:23:18 PM (14 years ago)

Author:

george

Message:

• Upraveno: Zobrazení dostupnosti zařízení filtrováno podle sloupce v databází PermanentOnline. * Upraveno: Zelené zobrazení při dobré dostupnosti, červené při špatné.

File:

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

trunk/network/dostupnost.php

@@ -9 +9 @@
   var $PeriodCount = 12;
   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' => 'Hour', 'Title' => 'Hodina', 'Period' => 1, 'MinPercent' => 100), 
+    array('Column' => 'Day', 'Title' => 'Den', 'Period' => 24, 'MinPercent' => 98), 
+    array('Column' => 'Week', 'Title' => 'Týden', 'Period' => 168, 'MinPercent' => 96), // 24 * 7  
+    array('Column' => 'Month', 'Title' => 'Měsíc', 'Period' => 720, 'MinPercent' => 93), // 24 * 30
+    array('Column' => 'Year', 'Title' => 'Rok', 'Period' => 8760, 'MinPercent' => 92), // 365 * 24
     //array('Column' => 'TenYear', 'Title' => 'Desetiletí', 'Period' => 87600), // 365 * 24 * 10
   );
@@ -67 +67 @@
     $Output .= '</tr>';
       
-    $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 DeviceName, Name');
+    $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.PermanentOnline=1 ORDER BY DeviceName, Name');
     while($Interface = $DbResult2->fetch_assoc())
     {
@@ -76 +76 @@
       {
         foreach($this->Period as $Period)
-          $Output .= '<td style="text-align: right;">'.sprintf('%01.2f', $Interface[$Period['Column']]).'</td>';
+        {
+          if($Interface[$Period['Column']] >= $Period['MinPercent']) $Color = ' color: green;';
+            else $Color = 'color: red';
+          $Output .= '<td style="text-align: right;'.$Color.'">'.sprintf('%01.2f', $Interface[$Period['Column']]).'</td>';
+        }
       } else 
       {
@@ -83 +87 @@
           for($I = 0; $I < $this->PeriodCount; $I++)
           {
-            $Output .= '<td style="text-align: center;">'.sprintf('%01.2f', $Interface['Period'.$I.'Column']).'</td>';
+            if($Interface['Period'.$I.'Column'] >= $Period['MinPercent']) $Color = ' color: green;';
+              else $Color = 'color: red';
+            $Output .= '<td style="text-align: center;'.$Color.'">'.sprintf('%01.2f', $Interface['Period'.$I.'Column']).'</td>';
           }
         } else die('Neznámé id');