Changeset 657 for trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

Timestamp:

May 25, 2014, 8:29:03 PM (10 years ago)

Author:

chronos

Message:

• Přidáno: Záznam změn online stavu dostupnosti rozhraní do tabulky.

File:

• trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php (modified) (2 diffs)

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -15 +15 @@
 
   // Load netwatch status from all DHCP routers 
-  $DbResult3 = $System->Database->query('SELECT DHCP, AddressRange, Mask FROM `NetworkSubnet` WHERE (`Configure` = 1) AND (`Member` IS NULL) GROUP BY DHCP');
+  $DbResult3 = $System->Database->query('SELECT `DHCP`, `AddressRange`, `Mask` FROM `NetworkSubnet` '.
+                'WHERE (`Configure` = 1) AND (`Member` IS NULL) GROUP BY DHCP');
   while($Subnet = $DbResult3->fetch_assoc())
   {
@@ -26 +27 @@
     foreach($List as $Properties)
     {
-      if($Properties['status'] == 'up')
+      if($Properties['status'] == 'up') $Online = 1;
+        else $Online = 0;
+        
+      $DbResult = $System->Database->select('NetworkInterface', 'Online', '`LocalIP` = "'.$Properties['host'].'";');
+      while($DbRow = $DbResult->fetch_assoc())
+      {
+        $LastOnline = $DbRow['Online'];
+        $Interface = $DbRow['NetworkInterface']; 
+        
+        // Record state changes
+        if($Online != $LastOnline)
+        {      
+          $System->Database->insert('NetworkInterfaceUpDown', array(
+                  'Interface' => $Interface, 'State' => $Online, 'Time' => TimeToMysqlDateTime($StartTime)));
+        }
+      };
+        
+      if($Online)
       {
         $DbResult = $System->Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"',