X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/62330e789110be03d89dae3b12c28c52a904b2c1..0092d0f0e70b66795f5ab0fcff4bfcef89842f3d:/cron.php diff --git a/cron.php b/cron.php index eb7965a2..473f27ef 100644 --- a/cron.php +++ b/cron.php @@ -47,7 +47,7 @@ import('ttReportHelper'); $mdb2 = getConnection(); $now = time(); - $sql = "select c.id, c.cron_spec, c.report_id, c.email, c.report_condition from tt_cron c + $sql = "select c.id, c.cron_spec, c.report_id, c.email, c.cc, c.subject, c.report_condition from tt_cron c left join tt_fav_reports fr on (c.report_id = fr.id) where $now >= c.next and fr.status = 1 and c.status = 1 and c.report_id is not null and c.email is not null"; @@ -59,24 +59,51 @@ 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; // Skip not found report. + $options = ttFavReportHelper::getReportOptions($val['report_id']); + if (!$options) continue; // Skip not found report. // Recycle global $user object, as user settings are specific for each report. - $user = new ttUser(null, $report['user_id']); + $user = new ttUser(null, $options['user_id']); if (!$user->id) continue; // Skip not found user. + + // Special handling of the NULL $options['users'] field (this used to mean "all users"). + if (!$options['users']) { + if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) { + if ($user->can('view_reports') || $user->can('view_all_reports')) { + $max_rank = $user->rank-1; + if ($user->can('view_all_reports')) $max_rank = 512; + if ($user->can('view_own_reports')) + $user_options = array('max_rank'=>$max_rank,'include_self'=>true); + else + $user_options = array('max_rank'=>$max_rank); + $users = $user->getUsers($user_options); // Active and inactive users. + } elseif ($user->isClient()) { + $users = ttTeamHelper::getUsersForClient(); // Active and inactive users for clients. + } + foreach ($users as $single_user) { + $user_ids[] = $single_user['id']; + } + $options['users'] = implode(',', $user_ids); + } + } else { + // TODO: add checking the existing user list for potentially changed access rights for user. + } + + // Skip users with disabled Notifications plugin. + if (!$user->isPluginEnabled('no')) continue; + // Recycle $i18n object because language is user-specific. $i18n->load($user->lang); // Check condition on a report. $condition_ok = true; if ($val['report_condition']) - $condition_ok = ttReportHelper::checkFavReportCondition($report, $val['report_condition']); + $condition_ok = ttReportHelper::checkFavReportCondition($options, $val['report_condition']); // Email report if condition is okay. if ($condition_ok) { - if (ttReportHelper::sendFavReport($report, $val['email'])) - echo "Report ".$val['report_id']. " sent to ".$val['email']."
"; + if (ttReportHelper::sendFavReport($options, $val['subject'], $val['email'], $val['cc'])) + echo "Report ".$val['report_id']. " sent.
"; else echo "Error while emailing report...
"; }