<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 encoding=utf-8: */
// +----------------------------------------------------------------------+
// | Eventum - Issue Tracking System |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003, 2004, 2005, 2006, 2007, 2008 MySQL AB |
// | |
// | This program is free software; you can redistribute it and/or modify |
// | it under the terms of the GNU General Public License as published by |
// | the Free Software Foundation; either version 2 of the License, or |
// | (at your option) any later version. |
// | |
// | This program is distributed in the hope that it will be useful, |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
// | GNU General Public License for more details. |
// | |
// | You should have received a copy of the GNU General Public License |
// | along with this program; if not, write to: |
// | |
// | Free Software Foundation, Inc. |
// | 59 Temple Place - Suite 330 |
// | Boston, MA 02111-1307, USA. |
// +----------------------------------------------------------------------+
// | Authors: João Prado Maia <hide@address.com> |
// +----------------------------------------------------------------------+
//
// @(#) $Id: check_reminders.php 3555 2008-03-15 16:45:34Z glen $
require_once(dirname(__FILE__) . "/../init.php");
require_once(APP_INC_PATH . "db_access.php");
require_once(APP_INC_PATH . "class.lock.php");
require_once(APP_INC_PATH . "class.reminder.php");
require_once(APP_INC_PATH . "class.reminder_action.php");
require_once(APP_INC_PATH . "class.reminder_condition.php");
// if requested, clear the lock
if (in_array('--fix-lock', $argv)) {
Lock::release('check_reminders');
echo "The lock file was removed successfully.\n";
exit;
}
// acquire a lock to prevent multiple scripts from
// running at the same time
if (!Lock::acquire('check_reminders')) {
echo "Error: Another instance of the script is still running. " .
"If this is not accurate, you may fix it by running this script with '--fix-lock' " .
"as the only parameter.\n";
exit;
}
/*
1 - Get list of reminders with all of its actions
2 - Loop through each reminder level and build the SQL query
3 - If query returns TRUE, then run the appropriate action
4 - Get the list of actions
5 - Calculate which action need to be performed, if any
6 - Avoid repeating reminder actions, so first check if the last triggered action is the same one as "now"
7 - Perform action
8 - Continue to next reminder level
**/
$triggered_issues = array();
$reminders = Reminder::getList();
for ($i = 0; $i < count($reminders); $i++) {
// if this is the weekend and this reminder isn't supposed to run on weekends skip
if (($reminders[$i]['rem_skip_weekend'] == 1) && (in_array(date("w"), array(0,6)))) {
if (Reminder::isDebug()) {
echo "Skipping Reminder '" . $reminders[$i]['rem_title'] . "' due to weekend exclusion\n";
}
continue;
}
// for each action, get the conditions and see if it triggered any issues
$found = 0;
for ($y = 0; $y < count($reminders[$i]['actions']); $y++) {
if (Reminder::isDebug()) {
echo "Processing Reminder Action '" . $reminders[$i]['actions'][$y]['rma_title'] . "'\n";
}
$conditions = Reminder_Condition::getList($reminders[$i]['actions'][$y]['rma_id']);
if (count($conditions) == 0) {
if (Reminder::isDebug()) {
echo " - Skipping Reminder because there were no reminder conditions found\n";
}
continue;
}
$issues = Reminder::getTriggeredIssues($reminders[$i], $conditions);
// avoid repeating reminder actions, so get the list of issues
// that were last triggered with this reminder action ID
$repeat_issues = Reminder_Action::getRepeatActions($issues, $reminders[$i]['actions'][$y]['rma_id']);
if (count($repeat_issues) > 0) {
// add the repeated issues to the list of already triggered
// issues, so they get ignored for the next reminder actions
for ($w = 0; $w < count($repeat_issues); $w++) {
if (Reminder::isDebug()) {
echo " - Adding repeated issue '" . $repeat_issues[$w] . "' to the list of already triggered issues\n";
}
$triggered_issues[] = $repeat_issues[$w];
}
}
if (count($issues) > 0) {
for ($z = 0; $z < count($issues); $z++) {
if (Reminder::isDebug()) {
echo " - Processing issue '" . $issues[$z] . "'\n";
}
// only perform one action per issue id
if (in_array($issues[$z], $triggered_issues)) {
if (Reminder::isDebug()) {
echo " - Ignoring issue '" . $issues[$z] . "' because it was found in the list of already triggered issues\n";
}
continue;
}
$triggered_issues[] = $issues[$z];
if (Reminder::isDebug()) {
echo " - Triggered Action '" . $reminders[$i]['actions'][$y]['rma_title'] . "' for issue #" . $issues[$z] . "\n";
}
Reminder_Action::perform($issues[$z], $reminders[$i], $reminders[$i]['actions'][$y]);
}
} else {
if (Reminder::isDebug()) {
echo " - No triggered issues for action '" . $reminders[$i]['actions'][$y]['rma_title'] . "'\n";
}
}
}
}
// release the lock
Lock::release('check_reminders');