X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=cron.php;h=7be547d6195113a984a526b91fcc11f042cbc1b2;hb=a07b6f8bccda226991ced6fe25f1c9c508e423e5;hp=908c890c06e60e992927266452c1154c8c69e916;hpb=5ef582473f6b329be18ad83c61e053fdcd9c6ed5;p=timetracker.git diff --git a/cron.php b/cron.php index 908c890c..7be547d6 100644 --- a/cron.php +++ b/cron.php @@ -48,18 +48,18 @@ $mdb2 = getConnection(); $now = mktime(); $sql = "select * from tt_cron where $now >= next - and status = 1 and report_id is not null and email is not null"; + and status = 1 and report_id is not null and email is not null"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) - exit; + exit(); while ($val = $res->fetchRow()) { // We have jobs to execute in user language. - + // Get favorite report details. $report = ttFavReportHelper::getReport($val['report_id']); if (!$report) continue; - + // Recycle global $user and $i18n objects, as user settings and language are specific for each report. $user = new ttUser(null, $report['user_id']); $i18n->load($user->lang); @@ -69,9 +69,10 @@ while ($val = $res->fetchRow()) { echo "Report ".$val['report_id']. " sent to ".$val['email']."
"; else echo "Error while emailing report...
"; - + // Calculate next execution time. - $next = tdCron::getNextOccurrence($val['cron_spec'], $now); + $next = tdCron::getNextOccurrence($val['cron_spec'], $now + 60); // +60 sec is here to get us correct $next when $now is close to existing "next". + // This is because the accuracy of tdcron class appears to be 1 minute. // Update last and next values in tt_cron. $sql = "update tt_cron set last = $now, next = $next where id = ".$val['id'];