Changeset 657 for trunk/Modules/NetworkConfigRouterOS

Timestamp:

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

Author:

chronos

Message:

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

Location:

trunk/Modules/NetworkConfigRouterOS

Files:

• Generators/NetwatchImport.php (modified) (2 diffs)
• NetworkConfigRouterOS.php (modified) (1 diff)

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'].'"', 

trunk/Modules/NetworkConfigRouterOS/NetworkConfigRouterOS.php

@@ -27 +27 @@
   function DoStart()
   {
+    $this->System->FormManager->RegisterClass('NetworkInterfaceUpDown', array(
+      'Title' => 'Změny stavu rozhraní',
+      'Table' => 'NetworkInterfaceUpDown',
+      'Items' => array(
+        'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => '', 'ReadOnly' => true),
+        'Interface' => array('Type' => 'TNetworkInterface', 'Caption' => 'Rozhraní', 'Default' => '', 'ReadOnly' => true),
+        'State' => array('Type' => 'Boolean', 'Caption' => 'Stav', 'Default' => '', 'ReadOnly' => true),
+      ),
+    ));
   }
 }