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

Timestamp:

Sep 23, 2014, 9:56:07 PM (10 years ago)

Author:

chronos

Message:

• Upraveno: Dobu trvání v tabulce NetworkInterfaceUpDown ukládat jako pevné číslo ihned při vkládání. Tím dojde ke zpomalení vkládání, ale zrychlení prohlížení tabulky stavu dostupnosti.

File:

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

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -57 +57 @@
     {
         // Online state changed
-      $System->Database->insert('NetworkInterfaceUpDown', array(
-        'Interface' => $Interface['Id'], 'State' => $Interface['NewOnline'],
-           'Time' => TimeToMysqlDateTime($StartTime)));
+      $System->Database->query('INSERT INTO `NetworkInterfaceUpDown` (`Interface`,
+        `State`, `Time`, `Duration`) VALUES ('.$Interface['Id'].', '.$Interface['NewOnline'].', "'.
+         TimeToMysqlDateTime($StartTime).'", IFNULL(TIMESTAMPDIFF(SECOND, '.
+         '(SELECT `Time` FROM `NetworkInterfaceUpDown` AS `TA` WHERE (`TA`.`Time` < "'.TimeToMysqlDateTime($StartTime).'") '.
+         'AND (`TA`.`Interface`='.$Interface['Id'].') ORDER BY `TA`.`Time` DESC LIMIT 1), "'.TimeToMysqlDateTime($StartTime).'"), 0))');
+      echo($System->Database->LastQuery."\n");
       $System->Database->update('NetworkInterface', '`Id` = "'.$Interface['Id'].'"',
         array('Online' => $Interface['NewOnline']));