/** * updateDateFieldReminderSettings - use this to update the date-fields reminder settings in the database. * * @param $field_id The date field concerned by the notification. * @param $group_artifact_id The tracker id * @param $start When will the notification start taking effect, with regards to date occurence (in days) * @param $type What is the type of the notification (after date occurence, before date occurence) * @param $frequency At which frequency (in days) the notification wil occur * @param $recurse How many times the notification mail will be sent * @param $submitter Is submitter notified ? * @param $assignee Is assignee notified ? * @param $cc Is cc notified ? * @param $commenter Is commetner notified ? * * @return true on success, false on failure. */ function updateDateFieldReminderSettings(ArtifactType $at, ArtifactField $field, $group_artifact_id, $start, $notif_type, $frequency, $recurse, $people_notified) { $res = $this->getDateFieldReminderSettings($field->getID(), $group_artifact_id); if ($res && !db_error($res)) { $notified_users = implode(",", $people_notified); if (db_numrows($res) == 0) { // No reminder, create it $insert = 'INSERT INTO artifact_date_reminder_settings' . '(field_id, group_artifact_id, notification_start, notification_type, frequency, recurse, notified_people)' . ' VALUES' . ' (' . db_ei($field->getId()) . ',' . db_ei($group_artifact_id) . ',' . db_ei($start) . ',' . db_ei($notif_type) . ',' . db_ei($frequency) . ',' . db_ei($recurse) . ',"' . db_es($notified_users) . '")'; $inserted = db_query($insert); if ($inserted) { $this->populateProcessingForField($at, $field->getId(), $group_artifact_id); return true; } return false; } else { //update reminder settings $update = sprintf('UPDATE artifact_date_reminder_settings' . ' SET notification_start=%d' . ' , notification_type=%d' . ' , frequency=%d' . ' , recurse=%d' . ' , notified_people="%s"' . ' WHERE group_artifact_id=%d' . ' AND field_id=%d', db_ei($start), db_ei($notif_type), db_ei($frequency), db_ei($recurse), db_es($notified_users), db_ei($group_artifact_id), db_ei($field->getId())); $result = db_query($update); return $result; } } else { return false; } }
/** * Display Date Field Notification Settings form * * @param * @return void */ function displayDateFieldNotificationSettings(ArtifactType $at, ArtifactField $field) { //get date field reminder settings from database $tdrArtifactField = new TrackerDateReminder_ArtifactField(); $res = $tdrArtifactField->getDateFieldReminderSettings($field->getID(), $at->getID()); $enabled = db_numrows($res) == 1; $start = db_result($res, 0, 'notification_start'); $frequency = db_result($res, 0, 'frequency'); $recurse = db_result($res, 0, 'recurse'); $notified_people = db_result($res, 0, 'notified_people'); $notified_groups = array(); $notified_users = array(); if (trim($notified_people) != "") { $notif = explode(",", $notified_people); foreach ($notif as $value) { if (preg_match("/^g/", $value)) { array_push($notified_groups, $value); } else { array_push($notified_users, $value); } } } if (count($notified_groups) == 0) { $notified_groups[] = '100'; } if (count($notified_users) == 0) { $notified_users[] = '100'; } $notif_type = db_result($res, 0, 'notification_type'); if ($notif_type == 1) { $after = "selected"; $before = ""; } else { $after = ""; $before = "selected"; } $out = ''; $baseActionUrl = '/tracker/admin/index.php?func=date_field_notification&group_id=' . $at->Group->getID() . '&atid=' . $at->getID() . '&field_id=' . $field->getID(); if ($enabled) { $out .= '<H3>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notif_settings_del_title') . '</H3>'; $out .= '<FORM ACTION="' . $baseActionUrl . '&delete_reminder=true" METHOD="POST">'; $out .= '<P>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notif_settings_del_desc') . '</P>'; $out .= '<INPUT TYPE="SUBMIT" NAME="reminder" VALUE="' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notif_settings_del_button') . '" />'; $out .= '</FORM>'; } $out .= '<FORM ACTION="' . $baseActionUrl . '" METHOD="POST" name="date_field_notification_settings_form"> <INPUT TYPE="HIDDEN" NAME="field_id" VALUE="' . $field->getID() . '"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $at->Group->getID() . '"> <INPUT TYPE="HIDDEN" NAME="atid" VALUE="' . $at->getID() . '">'; $out .= '<h3>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notif_settings_field', array($field->getLabel())) . '</h3>'; $out .= '<fieldset> <TABLE BORDER="0" WIDTH="930px"><TR height="30"><TD>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part1', array($field->getLabel())) . '</TD><TD> <INPUT TYPE="TEXT" NAME="start" SIZE="5" VALUE="' . $start . '"> ' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'days') . '</TD><TD colspan=3"> <SELECT NAME="notif_type"> <OPTION VALUE="0" ' . $before . '>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notify_before') . ' <OPTION VALUE="1" ' . $after . '>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'notify_after') . ' </SELECT> ' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part2') . '</TD></TR><TR><TD valign="top">' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part3') . ' <INPUT TYPE="TEXT" NAME="recurse" SIZE="5" VALUE="' . $recurse . '"> ' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part4') . '</TD><TD valign="top"> '; $artRoleNames = array(array('value' => '1', 'text' => $GLOBALS['Language']->getText('tracker_common_types', 'role_SUBMITTER_short_desc')), array('value' => '2', 'text' => $GLOBALS['Language']->getText('tracker_common_types', 'role_ASSIGNEE_short_desc')), array('value' => '3', 'text' => $GLOBALS['Language']->getText('tracker_common_types', 'role_CC_short_desc')), array('value' => '4', 'text' => $GLOBALS['Language']->getText('tracker_common_types', 'role_COMMENTER_short_desc'))); $out .= html_build_multiple_select_box_from_array($artRoleNames, 'notified_users[]', $notified_users, 4, true, '', false, '', false, '', false); $out .= '</TD><TD valign="top">' . $GLOBALS['Language']->getText('global', 'and') . ' </TD> <TD valign="top">'; $qry = sprintf('SELECT ugroup_id, name FROM ugroup' . ' WHERE (group_id = %d || group_id = 100)' . ' AND ugroup_id <> 1' . ' AND ugroup_id <> 2' . ' AND ugroup_id <> 100', db_ei($at->Group->getID())); $res = db_query($qry); while ($rows = db_fetch_array($res)) { $groupNames[] = array('value' => 'g' . $rows['ugroup_id'], 'text' => util_translate_name_ugroup($rows['name'])); } $out .= html_build_multiple_select_box_from_array($groupNames, 'notified_groups[]', $notified_groups, 8, true, '', false, '', false, '', false); $out .= '</SELECT></TD><TD valign="top">' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part5') . ' <INPUT TYPE="TEXT" NAME="frequency" SIZE="5" VALUE="' . $frequency . '"> ' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'days') . '.</TD></TR></TABLE><INPUT TYPE="SUBMIT" NAME="submit_notif_settings" value="' . $GLOBALS['Language']->getText('global', 'btn_update') . '"></P></FORM></fieldset><P>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part6', array($field->getLabel())) . '<P>' . $GLOBALS['Language']->getText('plugin_tracker_date_reminder', 'reminder_form_part7', array($field->getLabel())) . '</P>' . '<P>'; echo $out; }