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

Timestamp:

Oct 2, 2013, 8:26:20 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Nastavení online stavu rozhraní a zařízení na nedostupné pokud čas LastOnline je starší než perioda. Pokud se neprováděla aktualizace, tak zařízení se tvářila falešně jako online.

File:

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

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -12 +12 @@
   $StartTime = time();
 
+  // 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');
-  //echo($DbResult3->num_rows);
   while($Subnet = $DbResult3->fetch_assoc())
   {
@@ -24 +24 @@
     foreach($List as $Properties)
     {
-      //echo($Properties['host'].', ');
       if($Properties['status'] == 'up')
       {
-        $Online = 1;
-        $Values = array('Online' => $Online, 'LastOnline' => 'NOW()');
-        //echo($Properties['host']." up\n");
-      } else 
-      {
-        $Online = 0;
-        $Values = array('Online' => $Online);
-        //echo($Properties['host']." down\n");
-      }
-
-      $DbResult = $System->Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"', $Values);
+        $DbResult = $System->Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"', 
+          array('Online' => $Online, 'LastOnline' => TimeToMysqlDateTime($StartTime)));
+      } 
     }
-  }
+  } 
+  $DbResult = $System->Database->update('NetworkInterface', '`LastOnline` < "'.TimeToMysqlDateTime($StartTime).'"', array('Online' => 0));
 
   // Update device online state
-  $DbResult = $System->Database->select('NetworkDevice', 'Id', '`Used`=1');
+  $DbResult = $System->Database->select('NetworkInterface', '`Device`, SUM(`Online`) AS `SumOnline`', '`Online` = 1 GROUP BY `Device`');
   while($Device = $DbResult->fetch_assoc())
   {
-    $DbResult2 = $System->Database->select('NetworkInterface', 'SUM(`Online`) AS `SumOnline`', '`Device`='.$Device['Id']);
-    $DbRow = $DbResult2->fetch_array();
-    if($DbRow['SumOnline'] > 0) $Online = 1; 
-      else $Online = 0;  
-    $Values = array('Online' => $Online);
-    if($Online == 1) $Values['LastOnline'] = 'NOW()';
-    $System->Database->update('NetworkDevice', 'Id='.$Device['Id'], $Values);
+    if($Device['SumOnline'] > 0)
+      $System->Database->update('NetworkDevice', 'Id='.$Device['Device'], array('LastOnline' => TimeToMysqlDateTime($StartTime)));
   }
+  $DbResult = $System->Database->update('NetworkDevice', '`LastOnline` < "'.TimeToMysqlDateTime($StartTime).'"', array('Online' => 0));
 
   // Update interface online statistics