$res = Reminder_Condition::update(); Misc::mapMessages($res, array(1 => array(ev_gettext('Thank you, the condition was updated successfully.'), Misc::MSG_INFO), -1 => array(ev_gettext('An error occurred while trying to update the condition.'), Misc::MSG_ERROR), -2 => array(ev_gettext('Please enter the title for this condition.'), Misc::MSG_ERROR))); } elseif (@$_POST['cat'] == 'delete') { Reminder_Condition::remove(); } if (@$_GET['cat'] == 'edit') { $info = Reminder_Condition::getDetails($_GET['id']); if (!empty($_GET['field'])) { $info['rlc_rmf_id'] = $_GET['field']; } else { $_GET['field'] = $info['rlc_rmf_id']; } $tpl->assign('info', $info); } if (!empty($_GET['field'])) { $field_title = Reminder_Condition::getFieldTitle($_GET['field']); if (Reminder_Condition::canFieldBeCompared($_GET['field'])) { $tpl->assign(array('show_field_options' => 'yes', 'comparable_fields' => Reminder_Condition::getFieldAdminList(true))); } elseif (strtolower($field_title) == 'status') { $prj_id = Reminder::getProjectID($rem_id); $tpl->assign(array('show_status_options' => 'yes', 'statuses' => Status::getAssocStatusList($prj_id))); } elseif (strtolower($field_title) == 'category') { $prj_id = Reminder::getProjectID($rem_id); $tpl->assign(array('show_category_options' => 'yes', 'categories' => Category::getAssocList($prj_id))); } elseif (strtolower($field_title) == 'group' || strtolower($field_title) == 'active group') { $prj_id = Reminder::getProjectID($rem_id); $tpl->assign(array('show_group_options' => 'yes', 'groups' => Group::getAssocList($prj_id))); } else { $tpl->assign('show_status_options', 'no'); } if (@$_GET['cat'] != 'edit') {
} elseif (@$HTTP_POST_VARS["cat"] == "update") { $tpl->assign("result", Reminder_Condition::update()); } elseif (@$HTTP_POST_VARS["cat"] == "delete") { Reminder_Condition::remove(); } if (@$HTTP_GET_VARS["cat"] == "edit") { $info = Reminder_Condition::getDetails($HTTP_GET_VARS["id"]); if (!empty($HTTP_GET_VARS['field'])) { $info['rlc_rmf_id'] = $HTTP_GET_VARS['field']; } else { $HTTP_GET_VARS['field'] = $info['rlc_rmf_id']; } $tpl->assign("info", $info); } if (!empty($HTTP_GET_VARS['field'])) { $field_title = Reminder_Condition::getFieldTitle($HTTP_GET_VARS['field']); if (Reminder_Condition::canFieldBeCompared($HTTP_GET_VARS['field'])) { $tpl->assign(array('show_field_options' => 'yes', 'comparable_fields' => Reminder_Condition::getFieldAdminList(true))); } elseif (strtolower($field_title) == 'status') { $prj_id = Reminder::getProjectID($rem_id); $tpl->assign(array('show_status_options' => 'yes', 'statuses' => Status::getAssocStatusList($prj_id))); } elseif (strtolower($field_title) == 'category') { $prj_id = Reminder::getProjectID($rem_id); $tpl->assign(array('show_category_options' => 'yes', 'categories' => Category::getAssocList($prj_id))); } else { $tpl->assign('show_status_options', 'no'); } if (@$HTTP_GET_VARS["cat"] != "edit") { $tpl->assign('info', array('rlc_rmf_id' => $HTTP_GET_VARS['field'], 'rlc_rmo_id' => '', 'rlc_value' => '')); } }
/** * Method used to get the list of reminder conditions to be displayed in the * administration section. * * @access public * @param integer $rma_id The reminder action ID * @return array The list of reminder conditions */ function getAdminList($rma_id) { $stmt = "SELECT\n rlc_id,\n rlc_value,\n rlc_comparison_rmf_id,\n rmf_title,\n rmo_title\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "reminder_level_condition,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "reminder_field,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "reminder_operator\n WHERE\n rlc_rmf_id=rmf_id AND\n rlc_rmo_id=rmo_id AND\n rlc_rma_id=" . Misc::escapeInteger($rma_id) . "\n ORDER BY\n rlc_id ASC"; $res = $GLOBALS["db_api"]->dbh->getAll($stmt, DB_FETCHMODE_ASSOC); if (PEAR::isError($res)) { Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__); return array(); } else { for ($i = 0; $i < count($res); $i++) { if (!empty($res[$i]['rlc_comparison_rmf_id'])) { $res[$i]['rlc_value'] = 'Field: ' . Reminder_Condition::getFieldTitle($res[$i]['rlc_comparison_rmf_id']); } elseif (strtolower($res[$i]['rmf_title']) == 'status') { $res[$i]['rlc_value'] = Status::getStatusTitle($res[$i]['rlc_value']); } elseif (strtolower($res[$i]['rmf_title']) == 'category') { $res[$i]['rlc_value'] = Category::getTitle($res[$i]['rlc_value']); } elseif (strtoupper($res[$i]['rlc_value']) != 'NULL') { $res[$i]['rlc_value'] .= ' hours'; } } return $res; } }