Changeset 729 for trunk/Common

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.

Location:

trunk/Common

Files:

• Global.php (modified) (1 diff)
• Page.php (modified) (1 diff)
• Setup/Updates.php (modified) (2 diffs)

trunk/Common/Global.php

@@ -443 +443 @@
   if(substr($PathString, -1, 1) == '/') $PathString = substr($PathString, 0, -1);
   $PathItems = explode('/', $PathString);
-  if(strpos($_SERVER['REQUEST_URI'], '?') !== false)
+  if(array_key_exists('REQUEST_URI', $_SERVER) and (strpos($_SERVER['REQUEST_URI'], '?') !== false))
     $_SERVER['QUERY_STRING'] = substr($_SERVER['REQUEST_URI'], strpos($_SERVER['REQUEST_URI'], '?') + 1);
     else $_SERVER['QUERY_STRING'] = '';

trunk/Common/Page.php

@@ -50 +50 @@
   function ShowHeader($Title, $Path)
   {
-    $ScriptName = $_SERVER['REQUEST_URI'];
+        if(array_key_exists('REQUEST_URI', $_SERVER))
+      $ScriptName = $_SERVER['REQUEST_URI'];
+          else $ScriptName = '';
     while(strpos($ScriptName, '//') !== false)
       $ScriptName = str_replace('//', '/', $ScriptName);

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'),
     ));
   }