Changeset 729 for trunk/Common/Setup/Updates.php

Timestamp:

Jan 12, 2015, 12:20:30 AM (10 years ago)

Author:

chronos

Message:

• Added: Generic Scheduler module for running tasks on specified time and with specified period.
• Added: System execution from command line using cmd.php entry point.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -1170 +1170 @@
         
         $Manager->Execute('ALTER TABLE `MemberPayment` DROP `NetworkDevice`;');
+}
+
+function UpdateTo729($Manager)
+{
+ $Manager->Execute('ALTER TABLE `FinanceBankAccount` ADD `AutoImport` INT NOT NULL ;');
+  
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `Scheduler` (
+  `Id` int(11) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `Enabled` int(11) NOT NULL,
+  `Class` varchar(255) NOT NULL,
+  `Log` mediumtext NOT NULL,
+  `LastExecutedTime` datetime DEFAULT NULL,
+  `ScheduledTime` datetime NOT NULL,
+  `Period` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `Scheduler`
+ ADD PRIMARY KEY (`Id`);');
+  
+  $Manager->Execute('ALTER TABLE `Scheduler`
+MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Plánovač", "1", "/is/?t=Scheduler&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Systém"');
+  if($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+      "VALUES (NULL , 'Plánovač', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
+  
+  $Manager->Execute('INSERT INTO `Module` (`Id`, `Name`, `Title`) VALUES (NULL, "Plánovač", "Scheduler");');
 }
 
@@ -1233 +1270 @@
         722 => array('Revision' => 725, 'Function' => 'UpdateTo725'),
         725 => array('Revision' => 726, 'Function' => 'UpdateTo726'),
+        726 => array('Revision' => 729, 'Function' => 'UpdateTo729'),
     ));
   }