function project_get_all_user_rows($p_project_id = ALL_PROJECTS, $p_access_level = ANYBODY, $p_include_global_users = true) { $c_project_id = db_prepare_int($p_project_id); # Optimization when access_level is NOBODY if (NOBODY == $p_access_level) { return array(); } $t_user_table = db_get_table('user'); $t_project_user_list_table = db_get_table('project_user_list'); $t_project_table = db_get_table('project'); $t_on = ON; $t_users = array(); $t_global_access_level = $p_access_level; if ($c_project_id != ALL_PROJECTS && $p_include_global_users) { # looking for specific project if (VS_PRIVATE == project_get_field($p_project_id, 'view_state')) { /** @todo (thraxisp) this is probably more complex than it needs to be * When a new project is created, those who meet 'private_project_threshold' are added * automatically, but don't have an entry in project_user_list_table. * if they did, you would not have to add global levels. */ $t_private_project_threshold = config_get('private_project_threshold'); if (is_array($t_private_project_threshold)) { if (is_array($p_access_level)) { # both private threshold and request are arrays, use intersection $t_global_access_level = array_intersect($p_access_level, $t_private_project_threshold); } else { # private threshold is an array, but request is a number, use values in threshold higher than request $t_global_access_level = array(); foreach ($t_private_project_threshold as $t_threshold) { if ($p_access_level <= $t_threshold) { $t_global_access_level[] = $t_threshold; } } } } else { if (is_array($p_access_level)) { // private threshold is a number, but request is an array, use values in request higher than threshold $t_global_access_level = array(); foreach ($p_access_level as $t_threshold) { if ($t_threshold >= $t_private_project_threshold) { $t_global_access_level[] = $t_threshold; } } } else { // both private threshold and request are numbers, use maximum $t_global_access_level = max($p_access_level, $t_private_project_threshold); } } } } if (is_array($t_global_access_level)) { if (0 == count($t_global_access_level)) { $t_global_access_clause = '>= ' . NOBODY . ' '; } else { if (1 == count($t_global_access_level)) { $t_global_access_clause = '= ' . array_shift($t_global_access_level) . ' '; } else { $t_global_access_clause = 'IN (' . implode(',', $t_global_access_level) . ')'; } } } else { $t_global_access_clause = ">= {$t_global_access_level} "; } if ($p_include_global_users) { $query = "SELECT id, username, realname, access_level\n\t\t\t\tFROM {$t_user_table}\n\t\t\t\tWHERE enabled = " . db_param() . "\n\t\t\t\t\tAND access_level {$t_global_access_clause}"; $result = db_query_bound($query, array($t_on)); $t_row_count = db_num_rows($result); for ($i = 0; $i < $t_row_count; $i++) { $row = db_fetch_array($result); $t_users[$row['id']] = $row; } } if ($c_project_id != ALL_PROJECTS) { // Get the project overrides $query = "SELECT u.id, u.username, u.realname, l.access_level\n\t\t\t\tFROM {$t_project_user_list_table} l, {$t_user_table} u\n\t\t\t\tWHERE l.user_id = u.id\n\t\t\t\tAND u.enabled = " . db_param() . "\n\t\t\t\tAND l.project_id = " . db_param(); $result = db_query_bound($query, array($t_on, $c_project_id)); $t_row_count = db_num_rows($result); for ($i = 0; $i < $t_row_count; $i++) { $row = db_fetch_array($result); if (is_array($p_access_level)) { $t_keep = in_array($row['access_level'], $p_access_level); } else { $t_keep = $row['access_level'] >= $p_access_level; } if ($t_keep) { $t_users[$row['id']] = $row; } else { # If user's overridden level is lower than required, so remove # them from the list if they were previously there unset($t_users[$row['id']]); } } } user_cache_array_rows(array_keys($t_users)); return array_values($t_users); }
$t_user_id = auth_get_current_user_id(); #precache access levels if (isset($g_project_override)) { access_cache_matrix_project($g_project_override); } else { access_cache_matrix_project(helper_get_current_project()); } # get the bugnote data $t_bugnote_order = current_user_get_pref('bugnote_order'); $t_bugnotes = bugnote_get_all_visible_bugnotes($f_bug_id, $t_bugnote_order, 0, $t_user_id); #precache users $t_bugnote_users = array(); foreach ($t_bugnotes as $t_bugnote) { $t_bugnote_users[] = $t_bugnote->reporter_id; } user_cache_array_rows($t_bugnote_users); $num_notes = count($t_bugnotes); ?> <?php # Bugnotes BEGIN ?> <a id="bugnotes"></a><br /> <?php collapse_open('bugnotes'); ?> <table class="bugnotes width100" cellspacing="1"> <tr> <td class="form-title" colspan="2"> <?php
function create_reporter_summary() { global $reporter_name, $reporter_count; $t_project_id = helper_get_current_project(); $t_user_table = db_get_table('user'); $t_bug_table = db_get_table('bug'); $t_user_id = auth_get_current_user_id(); $specific_where = helper_project_specific_where($t_project_id, $t_user_id); $query = "SELECT reporter_id\n\t\t\t\t FROM {$t_bug_table}\n\t\t\t\t WHERE {$specific_where}"; $result = db_query_bound($query); $t_total_reported = db_num_rows($result); $t_reporter_arr = array(); $t_reporters = array(); for ($i = 0; $i < $t_total_reported; $i++) { $row = db_fetch_array($result); if (isset($t_reporter_arr[$row['reporter_id']])) { $t_reporter_arr[$row['reporter_id']]++; } else { $t_reporter_arr[$row['reporter_id']] = 1; $t_reporters[] = $row['reporter_id']; } } if (count($t_reporter_arr) == 0) { return array(); } user_cache_array_rows($t_reporters); foreach ($t_reporter_arr as $t_reporter => $t_count) { $t_metrics[user_get_name($t_reporter)] = $t_count; } ksort($t_metrics); # end for return $t_metrics; }
/** * print bug counts by reporter id * @return void */ function summary_print_by_reporter() { $t_reporter_summary_limit = config_get('reporter_summary_limit'); $t_project_id = helper_get_current_project(); $t_specific_where = helper_project_specific_where($t_project_id); if (' 1<>1' == $t_specific_where) { return; } $t_query = 'SELECT reporter_id, COUNT(*) as num FROM {bug} WHERE ' . $t_specific_where . ' GROUP BY reporter_id ORDER BY num DESC'; $t_result = db_query($t_query, array(), $t_reporter_summary_limit); $t_reporters = array(); while ($t_row = db_fetch_array($t_result)) { $t_reporters[] = $t_row['reporter_id']; } user_cache_array_rows($t_reporters); foreach ($t_reporters as $t_reporter) { $v_reporter_id = $t_reporter; $t_query = 'SELECT COUNT(id) as bugcount, status FROM {bug} WHERE reporter_id=' . db_param() . ' AND ' . $t_specific_where . ' GROUP BY status ORDER BY status'; $t_result2 = db_query($t_query, array($v_reporter_id)); $t_bugs_open = 0; $t_bugs_resolved = 0; $t_bugs_closed = 0; $t_bugs_total = 0; $t_resolved_val = config_get('bug_resolved_status_threshold'); $t_closed_val = config_get('bug_closed_status_threshold'); while ($t_row2 = db_fetch_array($t_result2)) { $t_bugs_total += $t_row2['bugcount']; if ($t_closed_val <= $t_row2['status']) { $t_bugs_closed += $t_row2['bugcount']; } else { if ($t_resolved_val <= $t_row2['status']) { $t_bugs_resolved += $t_row2['bugcount']; } else { $t_bugs_open += $t_row2['bugcount']; } } } if (0 < $t_bugs_total) { $t_user = string_display_line(user_get_name($v_reporter_id)); $t_bug_link = '<a class="subtle" href="' . config_get('bug_count_hyperlink_prefix') . '&' . FILTER_PROPERTY_REPORTER_ID . '=' . $v_reporter_id; if (0 < $t_bugs_open) { $t_bugs_open = $t_bug_link . '&' . FILTER_PROPERTY_HIDE_STATUS . '=' . $t_resolved_val . '">' . $t_bugs_open . '</a>'; } if (0 < $t_bugs_resolved) { $t_bugs_resolved = $t_bug_link . '&' . FILTER_PROPERTY_STATUS . '=' . $t_resolved_val . '&' . FILTER_PROPERTY_HIDE_STATUS . '=' . $t_closed_val . '">' . $t_bugs_resolved . '</a>'; } if (0 < $t_bugs_closed) { $t_bugs_closed = $t_bug_link . '&' . FILTER_PROPERTY_STATUS . '=' . $t_closed_val . '&' . FILTER_PROPERTY_HIDE_STATUS . '=">' . $t_bugs_closed . '</a>'; } if (0 < $t_bugs_total) { $t_bugs_total = $t_bug_link . '&' . FILTER_PROPERTY_HIDE_STATUS . '=">' . $t_bugs_total . '</a>'; } summary_helper_print_row($t_user, $t_bugs_open, $t_bugs_resolved, $t_bugs_closed, $t_bugs_total); } } }
$t_page_count = null; $rows = filter_get_bug_rows($f_page_number, $t_per_page, $t_page_count, $t_bug_count, null, null, null, true); if ($rows === false) { print_header_redirect('view_all_set.php?type=0'); } $t_bugslist = array(); $t_users_handlers = array(); $t_project_ids = array(); $t_row_count = count($rows); for ($i = 0; $i < $t_row_count; $i++) { array_push($t_bugslist, $rows[$i]->id); $t_users_handlers[] = $rows[$i]->handler_id; $t_project_ids[] = $rows[$i]->project_id; } $t_unique_users_handlers = array_unique($t_users_handlers); $t_unique_project_ids = array_unique($t_project_ids); user_cache_array_rows($t_unique_users_handlers); project_cache_array_rows($t_unique_project_ids); gpc_set_cookie(config_get('bug_list_cookie'), implode(',', $t_bugslist)); compress_enable(); # don't index view issues pages html_robots_noindex(); html_page_top1(lang_get('view_bugs_link')); if (current_user_get_pref('refresh_delay') > 0) { html_meta_redirect('view_all_bug_page.php?page_number=' . $f_page_number, current_user_get_pref('refresh_delay') * 60); } html_page_top2(); print_recently_visited(); define('VIEW_ALL_INC_ALLOW', true); include dirname(__FILE__) . DIRECTORY_SEPARATOR . 'view_all_inc.php'; html_page_bottom();
/** * Returns the list of users monitoring the specified bug * * @param int $p_bug_id */ function bug_get_monitors($p_bug_id) { if (!access_has_bug_level(config_get('show_monitor_list_threshold'), $p_bug_id)) { return array(); } $c_bug_id = db_prepare_int($p_bug_id); $t_bug_monitor_table = db_get_table('mantis_bug_monitor_table'); $t_user_table = db_get_table('mantis_user_table'); # get the bugnote data $query = "SELECT user_id, enabled\n\t\t\tFROM {$t_bug_monitor_table} m, {$t_user_table} u\n\t\t\tWHERE m.bug_id=" . db_param() . " AND m.user_id = u.id\n\t\t\tORDER BY u.realname, u.username"; $result = db_query_bound($query, array($c_bug_id)); $num_users = db_num_rows($result); $t_users = array(); for ($i = 0; $i < $num_users; $i++) { $row = db_fetch_array($result); $t_users[$i] = $row['user_id']; } user_cache_array_rows($t_users); return $t_users; }
function summary_print_by_reporter() { $t_mantis_bug_table = db_get_table('mantis_bug_table'); $t_mantis_user_table = db_get_table('mantis_user_table'); $t_reporter_summary_limit = config_get('reporter_summary_limit'); $t_project_id = helper_get_current_project(); $t_user_id = auth_get_current_user_id(); $specific_where = helper_project_specific_where($t_project_id); if (' 1<>1' == $specific_where) { return; } $query = "SELECT reporter_id, COUNT(*) as num\n\t\t\t\tFROM {$t_mantis_bug_table}\n\t\t\t\tWHERE {$specific_where}\n\t\t\t\tGROUP BY reporter_id\n\t\t\t\tORDER BY num DESC"; $result = db_query($query, $t_reporter_summary_limit); $t_reporters = array(); while ($row = db_fetch_array($result)) { $t_reporters[] = $row['reporter_id']; } user_cache_array_rows($t_reporters); foreach ($t_reporters as $t_reporter) { $v_reporter_id = $t_reporter; $query = "SELECT COUNT(id) as bugcount, status FROM {$t_mantis_bug_table}\n\t\t\t\t\tWHERE reporter_id={$v_reporter_id}\n\t\t\t\t\tAND {$specific_where}\n\t\t\t\t\tGROUP BY status\n\t\t\t\t\tORDER BY status"; $result2 = db_query($query); $last_reporter = -1; $t_bugs_open = 0; $t_bugs_resolved = 0; $t_bugs_closed = 0; $t_bugs_total = 0; $t_resolved_val = config_get('bug_resolved_status_threshold'); $t_closed_val = config_get('bug_closed_status_threshold'); while ($row2 = db_fetch_array($result2)) { $t_bugs_total += $row2['bugcount']; if ($t_closed_val <= $row2['status']) { $t_bugs_closed += $row2['bugcount']; } else { if ($t_resolved_val <= $row2['status']) { $t_bugs_resolved += $row2['bugcount']; } else { $t_bugs_open += $row2['bugcount']; } } } if (0 < $t_bugs_total) { $t_user = string_display_line(user_get_name($v_reporter_id)); $t_bug_link = '<a class="subtle" href="' . config_get('bug_count_hyperlink_prefix') . '&' . FILTER_PROPERTY_REPORTER_ID . '=' . $v_reporter_id; if (0 < $t_bugs_open) { $t_bugs_open = $t_bug_link . '&' . FILTER_PROPERTY_HIDE_STATUS_ID . '=' . $t_resolved_val . '">' . $t_bugs_open . '</a>'; } if (0 < $t_bugs_resolved) { $t_bugs_resolved = $t_bug_link . '&' . FILTER_PROPERTY_STATUS_ID . '=' . $t_resolved_val . '&' . FILTER_PROPERTY_HIDE_STATUS_ID . '=' . $t_closed_val . '">' . $t_bugs_resolved . '</a>'; } if (0 < $t_bugs_closed) { $t_bugs_closed = $t_bug_link . '&' . FILTER_PROPERTY_STATUS_ID . '=' . $t_closed_val . '&' . FILTER_PROPERTY_HIDE_STATUS_ID . '=">' . $t_bugs_closed . '</a>'; } if (0 < $t_bugs_total) { $t_bugs_total = $t_bug_link . '&' . FILTER_PROPERTY_HIDE_STATUS_ID . '=">' . $t_bugs_total . '</a>'; } summary_helper_print_row($t_user, $t_bugs_open, $t_bugs_resolved, $t_bugs_closed, $t_bugs_total); } } }
$t_parent_version = $t_row['parent_version']; if (!helper_call_custom_function('changelog_include_issue', array($t_issue_id))) { continue; } if (0 === strcasecmp($t_parent_version, $t_version)) { $t_issue_ids[] = $t_issue_id; $t_issue_parents[] = $t_issue_parent; } else { if (!in_array($t_issue_id, $t_issue_ids)) { $t_issue_ids[] = $t_issue_id; $t_issue_parents[] = null; } } $t_issue_handlers[] = $t_row['handler_id']; } user_cache_array_rows(array_unique($t_issue_handlers)); $t_issues_resolved = count(array_unique($t_issue_ids)); if ($t_issues_resolved > 0) { if (!$t_project_header_printed) { print_project_header_changelog($t_project_name); $t_project_header_printed = true; } if (!$t_version_header_printed) { print_version_header($t_version_id); $t_version_header_printed = true; } if (!is_blank($t_description)) { echo string_display("<br />{$t_description}<br /><br />"); } } else { continue;
/** * Returns the list of users monitoring the specified bug * * @param integer $p_bug_id Integer representing bug identifier. * @return array */ function bug_get_monitors( $p_bug_id ) { if( ! access_has_bug_level( config_get( 'show_monitor_list_threshold' ), $p_bug_id ) ) { return array(); } # get the bugnote data $t_query = 'SELECT user_id, enabled FROM {bug_monitor} m, {user} u WHERE m.bug_id=' . db_param() . ' AND m.user_id = u.id ORDER BY u.realname, u.username'; $t_result = db_query( $t_query, array( $p_bug_id ) ); $t_users = array(); while( $t_row = db_fetch_array( $t_result ) ) { $t_users[] = $t_row['user_id']; } user_cache_array_rows( $t_users ); return $t_users; }
/** * @todo yarick123: email_collect_recipients(...) will be completely rewritten to provide additional information such as language, user access,.. * @todo yarick123:sort recipients list by language to reduce switches between different languages * @param int $p_bug_id * @param string $p_notify_type * @param array $p_extra_user_ids_to_email * @return array */ function email_collect_recipients($p_bug_id, $p_notify_type, $p_extra_user_ids_to_email = array()) { $c_bug_id = db_prepare_int($p_bug_id); $t_recipients = array(); # add explicitly specified users if (ON == email_notify_flag($p_notify_type, 'explicit')) { foreach ($p_extra_user_ids_to_email as $t_user_id) { $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add explicitly specified user = @U%d', $p_bug_id, $t_user_id)); } } # add Reporter if (ON == email_notify_flag($p_notify_type, 'reporter')) { $t_reporter_id = bug_get_field($p_bug_id, 'reporter_id'); $t_recipients[$t_reporter_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add Reporter = @U%d', $p_bug_id, $t_reporter_id)); } # add Handler if (ON == email_notify_flag($p_notify_type, 'handler')) { $t_handler_id = bug_get_field($p_bug_id, 'handler_id'); if ($t_handler_id > 0) { $t_recipients[$t_handler_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add Handler = @U%d', $p_bug_id, $t_handler_id)); } } $t_project_id = bug_get_field($p_bug_id, 'project_id'); # add users monitoring the bug $t_bug_monitor_table = db_get_table('mantis_bug_monitor_table'); if (ON == email_notify_flag($p_notify_type, 'monitor')) { $query = "SELECT DISTINCT user_id\n\t\t\t\t\t FROM {$t_bug_monitor_table}\n\t\t\t\t\t WHERE bug_id=" . db_param(); $result = db_query_bound($query, array($c_bug_id)); $count = db_num_rows($result); for ($i = 0; $i < $count; $i++) { $t_user_id = db_result($result, $i); $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add Monitor = @U%d', $p_bug_id, $t_user_id)); } } # add users who contributed bugnotes $t_bugnote_id = bugnote_get_latest_id($p_bug_id); $t_bugnote_view = bugnote_get_field($t_bugnote_id, 'view_state'); $t_bugnote_date = bugnote_get_field($t_bugnote_id, 'last_modified'); $t_bug = bug_get($p_bug_id); $t_bug_date = $t_bug->last_updated; $t_bugnote_table = db_get_table('mantis_bugnote_table'); if (ON == email_notify_flag($p_notify_type, 'bugnotes')) { $query = "SELECT DISTINCT reporter_id\n\t\t\t\t\t FROM {$t_bugnote_table}\n\t\t\t\t\t WHERE bug_id = " . db_param(); $result = db_query_bound($query, array($c_bug_id)); $count = db_num_rows($result); for ($i = 0; $i < $count; $i++) { $t_user_id = db_result($result, $i); $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add Note Author = @U%d', $p_bug_id, $t_user_id)); } } # add project users who meet the thresholds $t_bug_is_private = bug_get_field($p_bug_id, 'view_state') == VS_PRIVATE; $t_threshold_min = email_notify_flag($p_notify_type, 'threshold_min'); $t_threshold_max = email_notify_flag($p_notify_type, 'threshold_max'); $t_threshold_users = project_get_all_user_rows($t_project_id, $t_threshold_min); foreach ($t_threshold_users as $t_user) { if ($t_user['access_level'] <= $t_threshold_max) { if (!$t_bug_is_private || access_compare_level($t_user['access_level'], config_get('private_bug_threshold'))) { $t_recipients[$t_user['id']] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, add Project User = @U%d', $p_bug_id, $t_user['id'])); } } } # add users as specified by plugins $t_recipients_include_data = event_signal('EVENT_NOTIFY_USER_INCLUDE', array($p_bug_id, $p_notify_type)); foreach ($t_recipients_include_data as $t_plugin => $t_recipients_include_data2) { foreach ($t_recipients_include_data2 as $t_callback => $t_recipients_included) { # only handle if we get an array from the callback if (is_array($t_recipients_included)) { foreach ($t_recipients_included as $t_user_id) { $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, %s plugin added user @U%d', $p_bug_id, $t_plugin, $t_user_id)); } } } } # FIXME: the value of $p_notify_type could at this stage be either a status # or a built-in actions such as 'owner and 'sponsor'. We have absolutely no # idea whether 'new' is indicating a new bug has been filed, or if the # status of an existing bug has been changed to 'new'. Therefore it is best # to just assume built-in actions have precedence over status changes. switch ($p_notify_type) { case 'new': case 'feedback': # This isn't really a built-in action (delete me!) # This isn't really a built-in action (delete me!) case 'reopened': case 'resolved': case 'closed': case 'bugnote': $t_pref_field = 'email_on_' . $p_notify_type; break; case 'owner': # The email_on_assigned notification type is now effectively # email_on_change_of_handler. $t_pref_field = 'email_on_assigned'; break; case 'deleted': case 'updated': case 'sponsor': case 'relation': case 'monitor': case 'priority': # This is never used, but exists in the database! # FIXME: these notification actions are not actually implemented # in the database and therefore aren't adjustable on a per-user # basis! The exception is 'monitor' that makes no sense being a # customisable per-user preference. $t_pref_field = false; break; default: # Anything not built-in is probably going to be a status $t_pref_field = 'email_on_status'; break; } # @@@ we could optimize by modifiying user_cache() to take an array # of user ids so we could pull them all in. We'll see if it's necessary $t_final_recipients = array(); $t_user_ids = array_keys($t_recipients); user_cache_array_rows($t_user_ids); user_pref_cache_array_rows($t_user_ids); user_pref_cache_array_rows($t_user_ids, $t_bug->project_id); # Check whether users should receive the emails # and put email address to $t_recipients[user_id] foreach ($t_recipients as $t_id => $t_ignore) { # Possibly eliminate the current user if (auth_get_current_user_id() == $t_id && OFF == config_get('email_receive_own')) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (own)', $p_bug_id, $t_id)); continue; } # Eliminate users who don't exist anymore or who are disabled if (!user_exists($t_id) || !user_is_enabled($t_id)) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (disabled)', $p_bug_id, $t_id)); continue; } # Exclude users who have this notification type turned off if ($t_pref_field) { $t_notify = user_pref_get_pref($t_id, $t_pref_field); if (OFF == $t_notify) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (pref %s off)', $p_bug_id, $t_id, $t_pref_field)); continue; } else { # Users can define the severity of an issue before they are emailed for # each type of notification $t_min_sev_pref_field = $t_pref_field . '_min_severity'; $t_min_sev_notify = user_pref_get_pref($t_id, $t_min_sev_pref_field); $t_bug_severity = bug_get_field($p_bug_id, 'severity'); if ($t_bug_severity < $t_min_sev_notify) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (pref threshold)', $p_bug_id, $t_id)); continue; } } } # exclude users who don't have at least viewer access to the bug, # or who can't see bugnotes if the last update included a bugnote if (!access_has_bug_level(VIEWER, $p_bug_id, $t_id) || $t_bug_date == $t_bugnote_date && !access_has_bugnote_level(VIEWER, $t_bugnote_id, $t_id)) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (access level)', $p_bug_id, $t_id)); continue; } # check to exclude users as specified by plugins $t_recipient_exclude_data = event_signal('EVENT_NOTIFY_USER_EXCLUDE', array($p_bug_id, $p_notify_type, $t_id)); $t_exclude = false; foreach ($t_recipient_exclude_data as $t_plugin => $t_recipient_exclude_data2) { foreach ($t_recipient_exclude_data2 as $t_callback => $t_recipient_excluded) { # exclude if any plugin returns true (excludes the user) if ($t_recipient_excluded) { $t_exclude = true; log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, %s plugin dropped user @U%d', $p_bug_id, $t_plugin, $t_id)); } } } # user was excluded by a plugin if ($t_exclude) { continue; } # Finally, let's get their emails, if they've set one $t_email = user_get_email($t_id); if (is_blank($t_email)) { log_event(LOG_EMAIL_RECIPIENT, sprintf('Issue = #%d, drop @U%d (no email)', $p_bug_id, $t_id)); } else { # @@@ we could check the emails for validity again but I think # it would be too slow $t_final_recipients[$t_id] = $t_email; } } return $t_final_recipients; }
/** * Create summary table of reporters * @return array */ function create_reporter_summary() { $t_project_id = helper_get_current_project(); $t_user_id = auth_get_current_user_id(); $t_specific_where = helper_project_specific_where($t_project_id, $t_user_id); $t_query = 'SELECT reporter_id FROM {bug} WHERE ' . $t_specific_where; $t_result = db_query($t_query); $t_reporter_arr = array(); $t_reporters = array(); while ($t_row = db_fetch_array($t_result)) { if (isset($t_reporter_arr[$t_row['reporter_id']])) { $t_reporter_arr[$t_row['reporter_id']]++; } else { $t_reporter_arr[$t_row['reporter_id']] = 1; $t_reporters[] = $t_row['reporter_id']; } } if (count($t_reporter_arr) == 0) { return array(); } user_cache_array_rows($t_reporters); foreach ($t_reporter_arr as $t_reporter => $t_count) { $t_metrics[user_get_name($t_reporter)] = $t_count; } ksort($t_metrics); return $t_metrics; }
print_header_redirect('view_all_set.php?type=0'); } $t_bugslist = array(); $t_unique_user_ids = array(); $t_unique_project_ids = array(); $t_row_count = count($t_rows); for ($i = 0; $i < $t_row_count; $i++) { array_push($t_bugslist, $t_rows[$i]->id); $t_handler_id = $t_rows[$i]->handler_id; $t_unique_user_ids[$t_handler_id] = $t_handler_id; $t_reporter_id = $t_rows[$i]->reporter_id; $t_unique_user_ids[$t_reporter_id] = $t_reporter_id; $t_project_id = $t_rows[$i]->project_id; $t_unique_project_ids[$t_project_id] = $t_project_id; } user_cache_array_rows($t_unique_user_ids); project_cache_array_rows($t_unique_project_ids); gpc_set_cookie(config_get('bug_list_cookie'), implode(',', $t_bugslist)); compress_enable(); # don't index view issues pages html_robots_noindex(); html_page_top1(lang_get('view_bugs_link')); if (current_user_get_pref('refresh_delay') > 0) { $t_query = '?'; if ($f_page_number > 1) { $t_query .= 'page_number=' . $f_page_number . '&'; } $t_query .= 'refresh=true'; html_meta_redirect('view_all_bug_page.php' . $t_query, current_user_get_pref('refresh_delay') * 60); } html_page_top2();
/** * notify the selected group a new user has signup * @param string $p_username Username of new user. * @param string $p_email Email address of new user. * @return void */ function email_notify_new_account($p_username, $p_email) { log_event(LOG_EMAIL, 'New account for user %s', $p_username); $t_threshold_min = config_get('notify_new_user_created_threshold_min'); $t_threshold_users = project_get_all_user_rows(ALL_PROJECTS, $t_threshold_min); $t_user_ids = array_keys($t_threshold_users); user_cache_array_rows($t_user_ids); user_pref_cache_array_rows($t_user_ids); foreach ($t_threshold_users as $t_user) { lang_push(user_pref_get_language($t_user['id'])); $t_recipient_email = user_get_email($t_user['id']); $t_subject = '[' . config_get('window_title') . '] ' . lang_get('new_account_subject'); $t_message = lang_get('new_account_signup_msg') . "\n\n" . lang_get('new_account_username') . ' ' . $p_username . "\n" . lang_get('new_account_email') . ' ' . $p_email . "\n" . lang_get('new_account_IP') . ' ' . $_SERVER['REMOTE_ADDR'] . "\n" . config_get_global('path') . "\n\n" . lang_get('new_account_do_not_reply'); if (!is_blank($t_recipient_email)) { email_store($t_recipient_email, $t_subject, $t_message); log_event(LOG_EMAIL, 'New Account Notify for email = \'%s\'', $t_recipient_email); } lang_pop(); } }
require_api('print_api.php'); require_api('user_api.php'); if (access_has_bug_level(config_get('show_monitor_list_threshold'), $f_bug_id)) { $c_bug_id = db_prepare_int($f_bug_id); $t_bug_monitor_table = db_get_table('bug_monitor'); $t_user_table = db_get_table('user'); # get the bugnote data $query = "SELECT user_id, enabled\n\t\t\tFROM {$t_bug_monitor_table} m, {$t_user_table} u\n\t\t\tWHERE m.bug_id=" . db_param() . " AND m.user_id = u.id\n\t\t\tORDER BY u.realname, u.username"; $result = db_query_bound($query, array($c_bug_id)); $num_users = db_num_rows($result); $t_users = array(); for ($i = 0; $i < $num_users; $i++) { $row = db_fetch_array($result); $t_users[$i] = $row['user_id']; } user_cache_array_rows($t_users); echo '<a id="monitors"></a><br />'; collapse_open('monitoring'); ?> <table class="width100" cellspacing="1"> <tr> <td class="form-title" colspan="2"> <?php collapse_icon('monitoring'); ?> <?php echo lang_get('users_monitoring_bug'); ?> </td> </tr> <tr class="row-1">
/** * Returns the list of users monitoring the specified bug * * @param int $p_bug_id * @return array */ function bug_get_monitors($p_bug_id) { if (!access_has_bug_level(config_get('show_monitor_list_threshold'), $p_bug_id)) { return array(); } $t_bug_monitor_table = db_get_table('bug_monitor'); $t_user_table = db_get_table('user'); # get the bugnote data $t_query = "SELECT user_id, enabled\n\t\t\tFROM {$t_bug_monitor_table} m, {$t_user_table} u\n\t\t\tWHERE m.bug_id=" . db_param() . " AND m.user_id = u.id\n\t\t\tORDER BY u.realname, u.username"; $t_result = db_query_bound($t_query, array($p_bug_id)); $t_users = array(); while ($t_row = db_fetch_array($t_result)) { $t_users[] = $t_row['user_id']; } user_cache_array_rows($t_users); return $t_users; }