Changeset 944 for trunk/Modules/Network/Network.php

Timestamp:

Dec 6, 2022, 11:37:32 PM (2 years ago)

Author:

chronos

Message:

• Added: Show offline devices number and link to filtered list from IS dashboard.

File:

• trunk/Modules/Network/Network.php (modified) (3 diffs)

trunk/Modules/Network/Network.php

@@ -853 +853 @@
   {
     $Output = '';
+
+    // Devices
     $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '1');
     $DbRow = $DbResult->fetch_row();
@@ -859 +861 @@
     $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '`Used`=1');
     $DbRow = $DbResult->fetch_row();
-    $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkDevice&amp;filter=1&amp;FilterUsed=1').'">'.$DbRow['0'].'</a><br/>';
-
+    $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkDevice&amp;filter=1&amp;FilterUsed=1').'">'.$DbRow['0'].'</a>';
+
+    $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '`Used`=1 AND `PermanentOnline`=1 AND `Online`=0');
+    $DbRow = $DbResult->fetch_row();
+    $Output .= ' nedostupných: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkDevice&amp;filter=1&amp;FilterUsed=1&amp;FilterOnline=0&amp;FilterPermanentOnline=1').'">'.$DbRow['0'].'</a>';
+
+    $Output .= '<br/>';
+
+    // Interfaces
     $DbResult = $this->Database->select('NetworkInterface', 'COUNT(*)', '1');
     $DbRow = $DbResult->fetch_row();
@@ -867 +876 @@
     $DbResult = $this->Database->select('NetworkInterface', 'COUNT(*)', '`Enabled`=1');
     $DbRow = $DbResult->fetch_row();
-    $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkInterface&amp;filter=1&amp;FilterEnabled=1').'">'.$DbRow['0'].'</a><br/>';
-
+    $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkInterface&amp;filter=1&amp;FilterEnabled=1').'">'.$DbRow['0'].'</a>';
+
+    //$DbResult = $this->Database->select('NetworkInterface', 'COUNT(*)', '`Enabled`=1 AND `PermanentOnline`=1 AND `Online`=0');
+    //$DbRow = $DbResult->fetch_row();
+    //$Output .= ' nedostupných: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkInterface&amp;filter=1&amp;FilterEnabled=1&amp;FilterOnline=0&amp;FilterPermanentOnline=1').'">'.$DbRow['0'].'</a>';
+
+    $Output .= '<br/>';
+
+    // Subnets
     $DbResult = $this->Database->select('NetworkSubnet', 'COUNT(*)', '1');
     $DbRow = $DbResult->fetch_row();
     $Output .= 'Síťových podsítí: <a href="'.$this->System->Link('/is/?a=list&amp;t=NetworkSubnet').'">'.$DbRow['0'].'</a><br/>';
+
     return $Output;
   }