X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/098a79f0819ebb89b7d48df4a6b154af4560f68e..aa9a80e15526b4b70cdf8360e35a0d44de43cf66:/cron.php

diff --git a/cron.php b/cron.php
index 22b4991d..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']."<br>";
   else
     echo "Error while emailing report...<br>";
-    
+
   // 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'];
@@ -80,5 +81,3 @@ while ($val = $res->fetchRow()) {
 }
 
 echo "Done!";
-
-?>
\ No newline at end of file