Changeset 781 for trunk/Modules/NetworkConfigRouterOS/Generators/Signal.php

Timestamp:

Jan 8, 2016, 11:00:11 PM (9 years ago)

Author:

chronos

Message:

• Modified: Network configure actions now can be executed through cmd.php interface using "php cmd.php config <action>".

File:

• trunk/Modules/NetworkConfigRouterOS/Generators/Signal.php (modified) (1 diff)

trunk/Modules/NetworkConfigRouterOS/Generators/Signal.php

@@ -1 +1 @@
 <?php
 
-if(array_key_exists('REMOTE_ADDR', $_SERVER)) die();
-include_once(dirname(__FILE__).'/../../../Application/System.php');
-$System = new System();
-$System->ShowPage = false;
-$System->Run();
+class ConfigRouterOSSignal extends NetworkConfigItem
+{
+  function ReadWirelessRegistration()
+  {
+    $Time = time();
 
-function ReadWirelessRegistration()
-{
-  global $System, $Config;
+    // Load netwatch status from all DHCP routers
+    $DbResult3 = $this->Database->query('SELECT `Id`, '.
+        '(SELECT `LocalIP` FROM `NetworkInterface` WHERE `NetworkInterface`.`Device` = `NetworkDevice`.`Id` LIMIT 1) AS `LocalIP` '.
+        'FROM `NetworkDevice` WHERE (`API` = 1) AND (`Used` = 1)');
+    while($Device = $DbResult3->fetch_assoc())
+    {
+      echo($Device['LocalIP']."\n");
+      $Routerboard = new RouterosAPI();
+      //$Routerboard->SSL = true;
+      //$Routerboard->Port = 8729;
+      $Routerboard->Connect($Device['LocalIP'], $this->System->Config['API']['UserName'], $this->System->Config['API']['Password']);
+      if(!$Routerboard->Connected) continue;
+      $Routerboard->Write('/interface/wireless/registration-table/getall', false);
+      $Routerboard->Write('=.proplist=signal-strength,mac-address,rx-rate,tx-rate', false);
+      $Routerboard->Write('=stats=');
+      $Read = $Routerboard->Read(false);
+      $Array = $Routerboard->ParseResponse($Read);
+      foreach($Array as $Properties)
+      {
+        $DbResult = $this->Database->select('NetworkInterface', 'Id', 'MAC="'.$Properties['mac-address'].'"');
+        if($DbResult->num_rows > 0)
+        {
+          $DbRow = $DbResult->fetch_assoc();
+          $Interface = $DbRow['Id'];
+        } else $Interface = null;
 
-  $Time = time();
-
-  // Load netwatch status from all DHCP routers
-  $DbResult3 = $System->Database->query('SELECT `Id`, '.
-    '(SELECT `LocalIP` FROM `NetworkInterface` WHERE `NetworkInterface`.`Device` = `NetworkDevice`.`Id` LIMIT 1) AS `LocalIP` '.
-    'FROM `NetworkDevice` WHERE (`API` = 1) AND (`Used` = 1)');
-  while($Device = $DbResult3->fetch_assoc())
-  {
-    echo($Device['LocalIP']."\n");
-    $Routerboard = new RouterosAPI();
-    //$Routerboard->SSL = true;
-    //$Routerboard->Port = 8729;
-    $Routerboard->Connect($Device['LocalIP'], $Config['API']['UserName'], $Config['API']['Password']);
-    if(!$Routerboard->Connected) continue;
-    $Routerboard->Write('/interface/wireless/registration-table/getall', false);
-    $Routerboard->Write('=.proplist=signal-strength,mac-address,rx-rate,tx-rate', false);
-    $Routerboard->Write('=stats=');
-    $Read = $Routerboard->Read(false);
-    $Array = $Routerboard->ParseResponse($Read);
-    foreach($Array as $Properties)
-    {
-      $DbResult = $System->Database->select('NetworkInterface', 'Id', 'MAC="'.$Properties['mac-address'].'"');
-      if($DbResult->num_rows > 0)
-      {
-        $DbRow = $DbResult->fetch_assoc();
-        $Interface = $DbRow['Id'];
-      } else $Interface = null;
-
-      if(strpos($Properties['signal-strength'], '@') === false)
-      {
-        $Strength = $Properties['signal-strength'];
-      } else {
-        $Parts = explode('@', $Properties['signal-strength']);
-        if(substr($Parts[0], -3) == 'dBm')
-          $Strength = substr($Parts[0], 0, -3); // without dBm
-          else $Strength = $Parts[0];
+        if(strpos($Properties['signal-strength'], '@') === false)
+        {
+          $Strength = $Properties['signal-strength'];
+        } else {
+          $Parts = explode('@', $Properties['signal-strength']);
+          if(substr($Parts[0], -3) == 'dBm')
+            $Strength = substr($Parts[0], 0, -3); // without dBm
+            else $Strength = $Parts[0];
+        }
+        $RateRx = substr($Properties['rx-rate'], 0, -3); // without MHz
+        $RateTx = substr($Properties['tx-rate'], 0, -3); // without MHz
+        $this->Database->insert('NetworkSignal', array('MAC' => $Properties['mac-address'],
+            'Value' => $Strength, 'RateRx' => $RateRx, 'RateTx' => $RateTx,
+            'Time' => TimeToMysqlDateTime($Time), 'Interface' => $Interface, 'Device' => $Device['Id']));
+        /*
+         $DbResult = $this->Database->select('Measure', 'Id', '`Name` = "'.$Properties['mac-address'].'"');
+         if($DbResult->num_rows > 0)
+         {
+         $this->Database->insert('Measure', array('Name' => $Properties['mac-address']));
+         $Id = $this->Database->LastInsertId;
+         } else {
+         $DbRow = $DbResult->fetch_assoc();
+         $Id = $DbRow['Id'];
+         }
+         $Measure = new Measure($Id);
+         $Measure->Load($Id);
+         $Measure->AddValue($Properties['signal-strength']);
+         */
       }
-      $RateRx = substr($Properties['rx-rate'], 0, -3); // without MHz
-      $RateTx = substr($Properties['tx-rate'], 0, -3); // without MHz
-      $System->Database->insert('NetworkSignal', array('MAC' => $Properties['mac-address'],
-        'Value' => $Strength, 'RateRx' => $RateRx, 'RateTx' => $RateTx,
-        'Time' => TimeToMysqlDateTime($Time), 'Interface' => $Interface, 'Device' => $Device['Id']));
-      /*
-      $DbResult = $System->Database->select('Measure', 'Id', '`Name` = "'.$Properties['mac-address'].'"');
-      if($DbResult->num_rows > 0)
-      {
-        $System->Database->insert('Measure', array('Name' => $Properties['mac-address']));
-        $Id = $System->Database->LastInsertId;
-      } else {
-        $DbRow = $DbResult->fetch_assoc();
-        $Id = $DbRow['Id'];
-      }
-      $Measure = new Measure($Id);
-      $Measure->Load($Id);
-      $Measure->AddValue($Properties['signal-strength']);
-      */
     }
   }
+
+  function Run()
+  {
+    RepeatFunction(60 * 60, array($this, 'ReadWirelessRegistration'));
+  }
 }
-
-RepeatFunction(60 * 60, 'ReadWirelessRegistration');