diff options
Diffstat (limited to 'schedule.php')
| -rw-r--r-- | schedule.php | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/schedule.php b/schedule.php new file mode 100644 index 0000000..14fba26 --- /dev/null +++ b/schedule.php @@ -0,0 +1,91 @@ +<?php + +/* * ******************************************************\ + | Scheduled Jobs | + | | + | This script checks for pending scheduled notifications | + | and sends them at the right time. | + | | + | Setup a cronjob that calls this file on a regular basis| + | (crontab -l to view, crontab -e to edit on linux) + | Example for a cronjob entry: | + | | + | 7 * * * * php flyspray/schedule.php | + | | + | Similiar setup possible with Windows Task Scheduler(MS)| + \****************************************************** */ + +define('IN_FS', true); + +if (PHP_SAPI !== 'cli') { + die("Scheduler must be called from the CLI SAPI only, for instance by a cronjob."); +} + +require_once 'header.php'; +include_once BASEDIR . '/includes/class.notify.php'; + +function send_reminders() { + global $db, $fs, $proj; + + $notify = new Notifications; + $user = new User(0); + $now = time(); + + $get_reminders = $db->query("SELECT r.*, t.*, u.* + FROM {reminders} r + INNER JOIN {users} u ON u.user_id = r.to_user_id + INNER JOIN {tasks} t ON r.task_id = t.task_id + INNER JOIN {projects} p ON t.project_id = p.project_id + WHERE t.is_closed = '0' + AND r.start_time < ? + AND r.last_sent + r.how_often < ? + ORDER BY r.reminder_id", array($now, $now) + ); + + while ($row = $db->fetchRow($get_reminders)) { + // So that the sender in emails will is the right project, not 'Default project' + // and also to get the projects default language, if needed. + $proj = new Project($row['project_id']); + $jabber_users = array(); + $email_users = array(); + + if (( $fs->prefs['user_notify'] == 1 || $fs->prefs['user_notify'] == 2 ) && ($row['notify_type'] == 1 || $row['notify_type'] == 3 )) { + $email_users[] = $row['email_address']; + } + + if (( $fs->prefs['user_notify'] == 1 || $fs->prefs['user_notify'] == 3 ) && ($row['notify_type'] == 2 || $row['notify_type'] == 3 )) { + $jabber_users[] = $row['jabber_id']; + } + + if (!empty($row['lang_code'])) { + $lang = $row['lang_code']; + } else if (!empty($proj->prefs['lang_code'])) { + $lang = $proj->prefs['lang_code']; + } else { + $lang = $fs->prefs['lang_code']; + } + + $subject = tL('notifyfromfs', $lang); + $message = $row['reminder_message']; + + // Pass the recipients and message onto the notification function + $notify->sendEmail($email_users, $subject, $message); + $notify->storeJabber($jabber_users, $subject, $message); + + // Update the database with the time sent + $update_db = $db->query("UPDATE {reminders} + SET last_sent = ? + WHERE reminder_id = ?", array(time(), $row['reminder_id'])); + } + + // send those stored notifications + $notify->sendJabber(); + unset($notify, $user); +} + +if (isset($conf['general']['reminder_daemon']) && ($conf['general']['reminder_daemon'] == 1)) { + send_reminders(); +} else { + die("Scheduled Reminding is disabled."); +} +?> |