public function index()
{
// Get all active scheduled items
foreach (ORM::factory('scheduler')->where('scheduler_active', '1')->find_all() as $scheduler) {
$scheduler_id = $scheduler->id;
$scheduler_last = $scheduler->scheduler_last;
// Next run time
$scheduler_weekday = $scheduler->scheduler_weekday;
// Day of the week
$scheduler_day = $scheduler->scheduler_day;
// Day of the month
$scheduler_hour = $scheduler->scheduler_hour;
// Hour
$scheduler_minute = $scheduler->scheduler_minute;
// Minute
// Controller that performs action
$scheduler_controller = $scheduler->scheduler_controller;
if ($scheduler_day <= -1) {
// Ran every day?
$scheduler_day = "*";
}
if ($scheduler_weekday <= -1) {
// Ran every day?
$scheduler_weekday = "*";
}
if ($scheduler_hour <= -1) {
// Ran every hour?
$scheduler_hour = "*";
}
if ($scheduler_minute <= -1) {
// Ran every minute?
$scheduler_minute = "*";
}
$scheduler_cron = $scheduler_minute . " " . $scheduler_hour . " " . $scheduler_day . " * " . $scheduler_weekday;
//Start new cron parser instance
$cron = new CronParser($scheduler_cron);
$lastRan = $cron->getLastRan();
//Array (0=minute, 1=hour, 2=dayOfMonth, 3=month, 4=week, 5=year)
$cronRan = mktime($lastRan[1], $lastRan[0], 0, $lastRan[3], $lastRan[2], $lastRan[5]);
if (!($scheduler_last > $cronRan - 45) || $scheduler_last == 0) {
// within 45 secs of cronRan time, so Execute control
$site_url = "http://" . $_SERVER['SERVER_NAME'] . "/";
$scheduler_status = remote::status($site_url . "scheduler/" . $scheduler_controller);
// Set last time of last execution
$schedule_time = time();
$scheduler->scheduler_last = $schedule_time;
$scheduler->save();
// Record Action to Log
$scheduler_log = new Scheduler_Log_Model();
$scheduler_log->scheduler_id = $scheduler_id;
$scheduler_log->scheduler_name = $scheduler->scheduler_name;
$scheduler_log->scheduler_status = $scheduler_status;
$scheduler_log->scheduler_date = $schedule_time;
$scheduler_log->save();
}
}
Header("Content-Type: image/gif");
// Transparent GIF
echo base64_decode("R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==");
}
function getLastScheduledRunTime($job)
{
global $debug;
$cron_string = $job[PC_MINUTE] . ' ' . $job[PC_HOUR] . ' ' . $job[PC_DOM] . ' ' . $job[PC_MONTH] . ' ' . $job[PC_DOW];
$cronPars = new CronParser();
$cronPars->calcLastRan($cron_string);
if ($debug) {
print_r($cronPars->getLastRan());
}
return $cronPars->getLastRanUnix();
}
public function index()
{
// Debug
$debug = "";
// @todo abstract most of this into a library, especially locking
// Ensure settings entry for `scheduler_lock` exists
Database::instance()->query("INSERT IGNORE INTO `" . Kohana::config('database.default.table_prefix') . "settings`\n\t\t\t(`key`, `value`) VALUES ('scheduler_lock', 0)");
// Now try and update the scheduler_lock
$result = Database::instance()->query("UPDATE `" . Kohana::config('database.default.table_prefix') . "settings`\n\t\t\tSET `value` = UNIX_TIMESTAMP() + 180\n\t\t\tWHERE `value` < UNIX_TIMESTAMP() AND `key` = 'scheduler_lock';");
// If no entries were changed, scheduler is already running
if ($result->count() <= 0) {
Kohana::log('info', 'Could not acquire scheduler lock');
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
echo 'Could not acquire scheduler lock';
}
return;
}
// Get all active scheduled items
foreach (ORM::factory('scheduler')->where('scheduler_active', '1')->find_all() as $scheduler) {
$scheduler_id = $scheduler->id;
$scheduler_last = $scheduler->scheduler_last;
// Next run time
$scheduler_weekday = $scheduler->scheduler_weekday;
// Day of the week
$scheduler_day = $scheduler->scheduler_day;
// Day of the month
$scheduler_hour = $scheduler->scheduler_hour;
// Hour
$scheduler_minute = $scheduler->scheduler_minute;
// Minute
// Controller that performs action
$scheduler_controller = $scheduler->scheduler_controller;
if ($scheduler_day <= -1) {
// Ran every day?
$scheduler_day = "*";
}
if ($scheduler_weekday <= -1) {
// Ran every day?
$scheduler_weekday = "*";
}
if ($scheduler_hour <= -1) {
// Ran every hour?
$scheduler_hour = "*";
}
if ($scheduler_minute <= -1) {
// Ran every minute?
$scheduler_minute = "*";
}
$scheduler_cron = $scheduler_minute . " " . $scheduler_hour . " " . $scheduler_day . " * " . $scheduler_weekday;
//Start new cron parser instance
$cron = new CronParser();
if (!$cron->calcLastRan($scheduler_cron)) {
echo "Error parsing CRON";
}
$lastRan = $cron->getLastRan();
//Array (0=minute, 1=hour, 2=dayOfMonth, 3=month, 4=week, 5=year)
$cronRan = mktime($lastRan[1], $lastRan[0], 0, $lastRan[3], $lastRan[2], $lastRan[5]);
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR />RUNNING: " . $scheduler->scheduler_name . "<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR /> LAST RUN: " . date("r", $scheduler_last) . "<BR /> LAST DUE AT: " . date('r', $cron->getLastRanUnix()) . "<BR /> SCHEDULE: <a href=\"http://en.wikipedia.org/wiki/Cron\" target=\"_blank\">" . $scheduler_cron . "</a>";
}
if ($scheduler_controller and (!($scheduler_last > $cronRan) or $scheduler_last == 0)) {
$run = FALSE;
// Catch errors from missing scheduler or other bugs
try {
$dispatch = Dispatch::controller($scheduler_controller, "scheduler/");
if ($dispatch instanceof Dispatch && method_exists($dispatch, 'method')) {
$run = $dispatch->method('index', '');
}
} catch (Exception $e) {
// Nada.
}
// @todo allow tasks to save state between runs.
if ($run !== FALSE) {
// Set last time of last execution
$schedule_time = time();
$scheduler->scheduler_last = $schedule_time;
$scheduler->save();
// Record Action to Log
$scheduler_log = new Scheduler_Log_Model();
$scheduler_log->scheduler_id = $scheduler_id;
$scheduler_log->scheduler_status = "200";
$scheduler_log->scheduler_date = $schedule_time;
$scheduler_log->save();
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ EXECUTED }}";
}
} else {
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ SCHEDULER NOT FOUND! }}";
}
}
} else {
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ NOT RUN }}";
}
}
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
//$debug .= "<BR /><BR />CRON DEBUG:<BR />".nl2br($cron->getDebug());
$debug .= "<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR /><BR /><BR />";
}
}
if (Kohana::config('cdn.cdn_gradual_upgrade') != FALSE) {
cdn::gradual_upgrade();
}
// If DEBUG is TRUE echo DEBUG info instead of transparent GIF
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
echo $debug;
if (isset($this->profiler)) {
echo $this->profiler->render(TRUE);
}
} else {
// Transparent GIF
Header("Content-type: image/gif");
Header("Expires: Wed, 11 Nov 1998 11:11:11 GMT");
Header("Cache-Control: no-cache");
Header("Cache-Control: must-revalidate");
Header("Content-Length: 49");
echo pack('H*', '47494638396101000100910000000000ffffffff' . 'ffff00000021f90405140002002c000000000100' . '01000002025401003b');
}
// Release lock
$result = Database::instance()->query("UPDATE `" . Kohana::config('database.default.table_prefix') . "settings`\n\t\t\tSET `value` = 0\n\t\t\tWHERE `key` = 'scheduler_lock';");
}
public function index()
{
// Debug
$debug = "";
// Get all active scheduled items
foreach (ORM::factory('scheduler')->where('scheduler_active', '1')->find_all() as $scheduler) {
$scheduler_id = $scheduler->id;
$scheduler_last = $scheduler->scheduler_last;
// Next run time
$scheduler_weekday = $scheduler->scheduler_weekday;
// Day of the week
$scheduler_day = $scheduler->scheduler_day;
// Day of the month
$scheduler_hour = $scheduler->scheduler_hour;
// Hour
$scheduler_minute = $scheduler->scheduler_minute;
// Minute
// Controller that performs action
$scheduler_controller = $scheduler->scheduler_controller;
if ($scheduler_day <= -1) {
// Ran every day?
$scheduler_day = "*";
}
if ($scheduler_weekday <= -1) {
// Ran every day?
$scheduler_weekday = "*";
}
if ($scheduler_hour <= -1) {
// Ran every hour?
$scheduler_hour = "*";
}
if ($scheduler_minute <= -1) {
// Ran every minute?
$scheduler_minute = "*";
}
$scheduler_cron = $scheduler_minute . " " . $scheduler_hour . " " . $scheduler_day . " * " . $scheduler_weekday;
//Start new cron parser instance
$cron = new CronParser();
if (!$cron->calcLastRan($scheduler_cron)) {
echo "Error parsing CRON";
}
$lastRan = $cron->getLastRan();
//Array (0=minute, 1=hour, 2=dayOfMonth, 3=month, 4=week, 5=year)
$cronRan = mktime($lastRan[1], $lastRan[0], 0, $lastRan[3], $lastRan[2], $lastRan[5]);
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR />RUNNING: " . $scheduler->scheduler_name . "<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~" . "<BR /> LAST RUN: " . date("r", $scheduler_last) . "<BR /> LAST DUE AT: " . date('r', $cron->getLastRanUnix()) . "<BR /> SCHEDULE: <a href=\"http://en.wikipedia.org/wiki/Cron\" target=\"_blank\">" . $scheduler_cron . "</a>";
}
if (!($scheduler_last > $cronRan) || $scheduler_last == 0) {
$run = Dispatch::controller("{$scheduler_controller}", "scheduler/")->method('index', '');
if ($run !== FALSE) {
// Set last time of last execution
$schedule_time = time();
$scheduler->scheduler_last = $schedule_time;
$scheduler->save();
// Record Action to Log
$scheduler_log = new Scheduler_Log_Model();
$scheduler_log->scheduler_id = $scheduler_id;
$scheduler_log->scheduler_name = $scheduler->scheduler_name;
$scheduler_log->scheduler_status = "200";
$scheduler_log->scheduler_date = $schedule_time;
$scheduler_log->save();
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ EXECUTED }}";
}
} else {
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ SCHEDULER NOT FOUND! }}";
}
}
} else {
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
$debug .= "<BR /> STATUS: {{ NOT RUN }}";
}
}
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
//$debug .= "<BR /><BR />CRON DEBUG:<BR \>".nl2br($cron->getDebug());
$debug .= "<BR \\>~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR />~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR /><BR /><BR />";
}
}
// If DEBUG is TRUE echo DEBUG info instead of transparent GIF
if (isset($_GET['debug']) and $_GET['debug'] == 1) {
echo $debug;
} else {
// Transparent GIF
Header("Content-type: image/gif");
Header("Expires: Wed, 11 Nov 1998 11:11:11 GMT");
Header("Cache-Control: no-cache");
Header("Cache-Control: must-revalidate");
Header("Content-Length: 49");
echo pack('H*', '47494638396101000100910000000000ffffffff' . 'ffff00000021f90405140002002c000000000100' . '01000002025401003b');
}
}
function getLastScheduledRunTime($job)
{
global $debug;
//DL+ DEBUG - USE PHP CRON CLASS
//COMPLETELY REPLACED IT BY THE PHP CRON CLASS BY MICK SEAR (see www.phpclasses.org)
//---------
/*
$extjob = Array();
parseElement($job[PC_MINUTE], $extjob[PC_MINUTE], 60);
parseElement($job[PC_HOUR], $extjob[PC_HOUR], 24);
parseElement($job[PC_DOM], $extjob[PC_DOM], 31);
parseElement($job[PC_MONTH], $extjob[PC_MONTH], 12);
parseElement($job[PC_DOW], $extjob[PC_DOW], 7);
//DL+- ADD ARGUMENTS TO JOB CALL
//$dateArr = getdate(getLastActualRunTime($job[PC_CMD]));
$dateArr = getdate(getLastActualRunTime($job));
$minutesAhead = 0;
while (
$minutesAhead<525600 AND
(!$extjob[PC_MINUTE][$dateArr["minutes"]] OR
!$extjob[PC_HOUR][$dateArr["hours"]] OR
(!$extjob[PC_DOM][$dateArr["mday"]] OR !$extjob[PC_DOW][$dateArr["wday"]]) OR
!$extjob[PC_MONTH][$dateArr["mon"]])
) {
if (!$extjob[PC_DOM][$dateArr["mday"]] OR !$extjob[PC_DOW][$dateArr["wday"]]) {
incDate($dateArr,1,"mday");
$minutesAhead+=1440;
continue;
}
if (!$extjob[PC_HOUR][$dateArr["hours"]]) {
incDate($dateArr,1,"hour");
$minutesAhead+=60;
continue;
}
if (!$extjob[PC_MINUTE][$dateArr["minutes"]]) {
incDate($dateArr,1,"minute");
$minutesAhead++;
continue;
}
}
return mktime($dateArr["hours"],$dateArr["minutes"],0,$dateArr["mon"],$dateArr["mday"],$dateArr["year"]);
*/
$cron_string = $job[PC_MINUTE] . ' ' . $job[PC_HOUR] . ' ' . $job[PC_DOM] . ' ' . $job[PC_MONTH] . ' ' . $job[PC_DOW];
$cronPars = new CronParser();
$cronPars->calcLastRan($cron_string);
if ($debug) {
print_r($cronPars->getLastRan());
}
return $cronPars->getLastRanUnix();
//DL- DEBUG - USE PHP CRON CLASS
}
