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

Timestamp:

Apr 8, 2018, 7:40:10 PM (6 years ago)

Author:

chronos

Message:

• Added: New table NetworkDeviceLog to store log messages received from network devices.

File:

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

trunk/Modules/Network/Network.php

@@ -142 +142 @@
     $this->System->RegisterPage(array('network', 'frequency-plan'), 'PageFrequencyPlan');
 
+    $this->System->RegisterCommandLine('config', array($this, 'ImportNetworkLog'));
+
     $this->System->FormManager->RegisterClass('NetworkDomainAlias', array(
       'Title' => 'Alias domény',
@@ -178 +180 @@
         'LoginPassword' => array('Type' => 'String', 'Caption' => 'Přihlašovací heslo', 'Default' => '', 'Null' => true, 'NotInList' => true),
         'API' => array('Type' => 'TDeviceAPIType', 'Caption' => 'API', 'Default' => '', 'Null' => true),
+        'Logs' => array('Type' => 'TDeviceLogList', 'Caption' => 'Záznamy', 'Default' => ''),
       ),
       'AfterInsert' => array($this, 'AfterInsertNetworkDevice'),
@@ -190 +193 @@
         'ShowOnline' => array('Type' => 'Boolean', 'Caption' => 'Ukázat online', 'Default' => '0'),
         'IconName' => array('Type' => 'String', 'Caption' => 'Jméno ikony', 'Default' => '0'),
+      ),
+    ));
+    $this->System->FormManager->RegisterClass('NetworkDeviceLog', array(
+      'Title' => 'Zprávy zařízení',
+      'Table' => 'NetworkDeviceLog',
+      'DefaultSortColumn' => 'Time',
+      'DefaultSortOrder' => 1,
+      'Items' => array(
+        'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => ''),
+        'Device' => array('Type' => 'TNetworkDevice', 'Caption' => 'Zařízení', 'Default' => ''),
+        'Message' => array('Type' => 'String', 'Caption' => 'Zpáva', 'Default' => ''),
+        'Tags' => array('Type' => 'String', 'Caption' => 'Značky', 'Default' => ''),
       ),
     ));
@@ -650 +665 @@
       'Filter' => '1',
     ));
+    $this->System->FormManager->RegisterFormType('TDeviceLogList', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'NetworkDeviceLog',
+      'Id' => 'Id',
+      'Ref' => 'Device',
+      'Filter' => '1',
+    ));
     $this->System->FormManager->RegisterFormType('TNetworkLinkListInterface', array(
       'Type' => 'ManyToOne',
@@ -725 +747 @@
     $this->Database->query('DELETE FROM `NetworkInterfaceWireless` WHERE `NetworkInterface`='.$Id);
     $this->Database->query('DELETE FROM `NetworkInterfaceLatency` WHERE `Interface`='.$Id);
+  }
+  
+  function ImportNetworkLog($Parameters)
+  {
+    global $Config;
+    
+    $DbResult = $this->System->Database->select('NetworkDeviceLog', 'Time',
+      '1 ORDER BY Time DESC LIMIT 1');
+    if ($DbResult->num_rows > 0)
+    {
+      $DbRow = $DbResult->fetch_assoc();
+      $WhereTime = ' AND (`Time` > "'.$DbRow['Time'].'")';
+    } else $WhereTime = '';
+
+    $RemoteDb = new Database();
+    $RemoteDb->Connect($Config['NetworkLog']['Host'], $Config['NetworkLog']['User'], 
+      $Config['NetworkLog']['Password'], $Config['NetworkLog']['Database']);
+    $DbResult = $RemoteDb->select('SystemEvents', '*', '`ReceivedAt`>"'. TimeToMysqlDate($StartTime).'"'.$WhereTime.' ORDER BY `Time` DESC');
+    while ($DbRow = $DbResult->fetch_array())
+    {
+      $DbResult2 = $this->System->Database->select('NetworkInterface', 'Device, CONCAT(CONCAT_WS("-", `NetworkDevice`.`Name`, NULLIF(`NetworkInterface`.`Name`, "")), ".") AS `Name` ', '`Name` LIKE "'.$DbRow['FromHost'].'"');
+      if ($DbResult2->num_rows > 0)              
+      {
+        $DbRow2 = $DbResult2->fetch_assoc();
+        $DeviceID = $DbRow2['Device'];
+        $this->System->Database->insert('NetworkDeviceLog', array('Time' => $DbRow['ReceivedAt'], 
+          'Device' => $DeviceId, 'Message' => $DbRow['Message'], 'Tags' => $DbRow['SysLogTag']));
+      } else echo('Host '.$DbRow['Host'].' not paired with network device.'."\n");
+    }
   }