Changeset 754

Timestamp:

Oct 21, 2015, 11:05:08 PM (9 years ago)

Author:

chronos

Message:

• Added: New module Notify for sending periodic system notification for monitoring various states to user.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Common/Setup/Updates.php (modified) (2 diffs)
• Modules/Notify (added)
• Modules/Notify/Notify.php (added)
• Modules/Scheduler/Scheduler.php (modified) (1 diff)
• Modules/Subject/Subject.php (modified) (1 diff)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 751; // Subversion revision
-$DatabaseRevision = 748; // SQL structure revision
-$ReleaseTime = strtotime('2015-10-04');
+$Revision = 752; // Subversion revision
+$DatabaseRevision = 752; // SQL structure revision
+$ReleaseTime = strtotime('2015-10-21');

trunk/Common/Setup/Updates.php

@@ -1517 +1517 @@
   }
 }
+
+function UpdateTo752($Manager)
+{
+  $Manager->Database->query('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) '.
+    'VALUES (NULL, "Kontrola změn stavů", "SchedulerNotifyCheck");');
+
+  $this->Database->query('
+  CREATE TABLE IF NOT EXISTS `NotifyUser` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) NOT NULL,
+  `Contact` int(11) NOT NULL,
+  `Period` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `User` (`User`),
+  KEY `Contact` (`Contact`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
+  $this->Database->query('ALTER TABLE `NotifyUser`
+ADD CONSTRAINT `NotifyUser_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
+ADD CONSTRAINT `NotifyUser_ibfk_2` FOREIGN KEY (`Contact`) REFERENCES `Contact` (`Id`);');
+
+  $this->Database->query('CREATE TABLE IF NOT EXISTS `NotifyCategory` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `SysName` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+
+  $this->Database->query("INSERT INTO `NotifyCategory` (`Id`, `Name`, `SysName`) VALUES
+    (1, 'Dostupnost zařízení (ping)', 'NetworkReachability'),
+    (2, 'Dostupnost URL', 'URL'),
+    (3, 'Minimální úroveň signálu', 'WirelessSignal'),
+    (4, 'Dostupnost síťového portu', 'NetworkPort'),
+    (5, 'Minimální odezva', 'NetworkLatency'),
+    (6, 'Minimální propustnost', 'NetworkBandwidth');");
+}
+
 
 class Updates
@@ -1590 +1626 @@
       742 => array('Revision' => 747, 'Function' => 'UpdateTo747'),
       747 => array('Revision' => 748, 'Function' => 'UpdateTo748'),
+      748 => array('Revision' => 752, 'Function' => 'UpdateTo752'),
     ));
   }

trunk/Modules/Scheduler/Scheduler.php

@@ -75 +75 @@
           $Class = new $DbRow['Class']($this->System);
           $Output = $Class->Execute();
+          echo($Output);
         } else echo('Class '.$DbRow['Class'].' not found'."\n");
         $this->Database->update('Scheduler', 'Id='.$DbRow['Id'],

trunk/Modules/Subject/Subject.php

@@ -112 +112 @@
       ),
     ));
+    $this->System->FormManager->RegisterFormType('TContact', array(
+      'Type' => 'Reference',
+      'Table' => 'Contact',
+      'Id' => 'Id',
+      'Name' => 'Value',
+      'Filter' => '1',
+    ));
     $this->System->FormManager->RegisterFormType('TSubject', array(
       'Type' => 'Reference',