function get_enum_to_string($p_enum_string, $p_num)
{
$t_arr = explode_enum_string($p_enum_string);
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
$t_s = explode_enum_arr($t_arr[$i]);
if ($t_s[0] == $p_num) {
return $t_s[1];
}
}
return '@' . $p_num . '@';
}
function get_enum_element($p_enum_name, $p_val)
{
$config_var = config_get($p_enum_name . '_enum_string');
$string_var = lang_get($p_enum_name . '_enum_string');
# use the global enum string to search
$t_arr = explode_enum_string($config_var);
$t_arr_count = count($t_arr);
for ($i = 0; $i < $t_arr_count; $i++) {
$elem_arr = explode_enum_arr($t_arr[$i]);
if ($elem_arr[0] == $p_val) {
# now get the appropriate translation
return get_enum_to_string($string_var, $p_val);
}
}
return '@' . $p_val . '@';
}
function get_capability_row($p_caption, $p_access_level)
{
$t_access_levels = explode_enum_string(config_get('access_levels_enum_string'));
$t_output = '<tr ' . helper_alternate_class() . '><td>' . string_display($p_caption) . '</td>';
foreach ($t_access_levels as $t_access_level) {
$t_entry_array = explode_enum_arr($t_access_level);
if ((int) $t_entry_array[0] >= (int) $p_access_level) {
$t_value = '<img src="images/ok.gif" width="20" height="15" alt="X" title="X" />';
} else {
$t_value = ' ';
}
$t_output .= '<td class="center">' . $t_value . '</td>';
}
$t_output .= '</tr>' . "\n";
return $t_output;
}
function get_string_to_enum($enum_string, $string)
{
/**
* Gets Mantis's integer for the given string
*
* This is the inverse of Mantis's get_enum_to_string(). If the string is
* not found in the enum string, we return -1.
*/
if (preg_match('/^@.*@$/', $string)) {
return substr($string, 1, -1);
}
$enum_array = explode_enum_string($enum_string);
foreach ($enum_array as $pair) {
$t_s = explode_enum_arr($pair);
if ($t_s[1] == $string) {
return $t_s[0];
}
}
return -1;
}
</tr>
<tr valign="top">
<td colspan="2">
<?php
# DEVELOPER / RESOLUTION #
?>
<table class="width100" cellspacing="1">
<tr>
<td class="form-title" colspan="1">
<?php
echo lang_get('developer_by_resolution');
?>
</td>
<?php
$t_arr = explode_enum_string(config_get('resolution_enum_string'));
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
print '<td>';
$t_s = explode_enum_arr($t_arr[$i]);
$c_s[0] = db_prepare_string($t_s[0]);
echo get_enum_element('resolution', $c_s[0]);
print '</td>';
}
print '<td>';
print lang_get('percentage_fixed');
print '</td>';
?>
</tr>
<?php
summary_print_developer_resolution(config_get('resolution_enum_string'));
function get_capability_row_for_email($p_caption, $p_message_type)
{
$t_access_levels = explode_enum_string(config_get('access_levels_enum_string'));
echo '<tr ' . helper_alternate_class() . '><td>' . string_display($p_caption) . '</td>';
echo '<td class="center"' . colour_notify_flag($p_message_type, 'reporter') . '>' . show_notify_flag($p_message_type, 'reporter') . '</td>';
echo '<td class="center"' . colour_notify_flag($p_message_type, 'handler') . '>' . show_notify_flag($p_message_type, 'handler') . '</td>';
echo '<td class="center"' . colour_notify_flag($p_message_type, 'monitor') . '>' . show_notify_flag($p_message_type, 'monitor') . '</td>';
echo '<td class="center"' . colour_notify_flag($p_message_type, 'bugnotes') . '>' . show_notify_flag($p_message_type, 'bugnotes') . '</td>';
foreach ($t_access_levels as $t_access_level) {
$t_entry_array = explode_enum_arr($t_access_level);
echo '<td class="center"' . colour_threshold_flag((int) $t_entry_array[0], $p_message_type) . '>' . show_notify_threshold((int) $t_entry_array[0], $p_message_type) . '</td>';
}
echo '</tr>' . "\n";
}
}
}
if ('' != $t_workflow_row) {
$t_workflow[$t_state] = $t_workflow_row;
}
}
if ($t_workflow != config_get('status_enum_workflow')) {
config_set('status_enum_workflow', $t_workflow, NO_USER, $t_project, $f_access);
}
}
# process the access level changes
if (config_get_access('status_enum_workflow') <= $t_access) {
# get changes to access level to change these values
$f_access = gpc_get('status_access');
# walk through the status labels to set the status threshold
$t_enum_status = explode_enum_string(config_get('status_enum_string'));
$t_set_status = array();
foreach ($t_statuses as $t_status_id => $t_status_label) {
$f_level = gpc_get('access_change_' . $t_status_id);
if (NEW_ == $t_status_id) {
if ((int) $f_level != config_get('report_bug_threshold')) {
config_set('report_bug_threshold', (int) $f_level, ALL_USERS, $t_project, $f_access);
}
} else {
$t_set_status[$t_status_id] = (int) $f_level;
}
}
if ($t_set_status != config_get('set_status_threshold')) {
config_set('set_status_threshold', $t_set_status, ALL_USERS, $t_project, $f_access);
}
}
function file_type_check($p_file_name)
{
global $g_allowed_files, $g_disallowed_files;
# grab extension
$t_ext_array = explode(".", $p_file_name);
$last_position = count($t_ext_array) - 1;
$t_extension = $t_ext_array[$last_position];
# check against disallowed files
$t_disallowed_arr = explode_enum_string($g_disallowed_files);
foreach ($t_disallowed_arr as $t_val) {
if ($t_val == $t_extension) {
return false;
}
}
# check against allowed files
$t_allowed_arr = explode_enum_string($g_allowed_files);
# if the allowed list is populated then the file must be in the list.
if (empty($g_allowed_files)) {
return true;
}
foreach ($t_allowed_arr as $t_val) {
if ($t_val == $t_extension) {
return true;
}
}
return false;
}
function print_project_user_option_list($p_val)
{
global $g_mantis_project_table, $g_access_levels_enum_string;
$t_arr = explode_enum_string($g_access_levels_enum_string);
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
$t_elem = explode_enum_arr($t_arr[$i]);
if ($t_elem[0] >= ADMINISTRATOR) {
continue;
}
$t_access_level = get_enum_element("access_levels", $t_elem[0]);
if ($p_val == $t_elem[0]) {
print "<option value=\"{$t_elem['0']}\" SELECTED>{$t_access_level}</option>";
} else {
print "<option value=\"{$t_elem['0']}\">{$t_access_level}</option>";
}
}
# end for
}
echo lang_get($t_field_name_arr[$i]);
?>
</td>
<?php
}
//if isset
}
//for
}
//if
?>
</tr>
<?php
$field_name_count = $field_name_count;
$f_bug_arr = explode_enum_string($f_export);
# @@debug var_dump($t_field_name_arr);
for ($i = 0; $i < $row_count; $i++) {
# prefix bug data with v_
extract($result[$i], EXTR_PREFIX_ALL, 'v');
if (in_array($v_id, $f_bug_arr) || $f_show_flag == 0) {
$t_last_updated = date($g_short_date_format, $v_last_updated);
# grab the bugnote count
$bugnote_count = bug_get_bugnote_count($v_id);
# grab the project name
$project_name = project_get_field($v_project_id, 'name');
$t_bug_text_table = config_get('mantis_bug_text_table');
$query4 = "SELECT *\r\n FROM {$t_bug_text_table}\r\n WHERE id='{$v_bug_text_id}'";
$result4 = db_query($query4);
$row = db_fetch_array($result4);
extract($row, EXTR_PREFIX_ALL, 'v2');
function summary_print_reporter_effectiveness($p_severity_enum_string, $p_resolution_enum_string)
{
$t_mantis_bug_table = config_get('mantis_bug_table');
$t_mantis_user_table = config_get('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();
# These are our overall "values" for severities and non-bug results
$t_severity_multiplier[FEATURE] = 1;
$t_severity_multiplier[TRIVIAL] = 2;
$t_severity_multiplier[TEXT] = 3;
$t_severity_multiplier[TWEAK] = 2;
$t_severity_multiplier[MINOR] = 5;
$t_severity_multiplier[MAJOR] = 8;
$t_severity_multiplier[CRASH] = 8;
$t_severity_multiplier[BLOCK] = 10;
$t_severity_multiplier['average'] = 5;
$t_notbug_multiplier[UNABLE_TO_DUPLICATE] = 2;
$t_notbug_multiplier[DUPLICATE] = 3;
$t_notbug_multiplier[NOT_A_BUG] = 5;
$t_sev_arr = explode_enum_string($p_severity_enum_string);
$enum_sev_count = count($t_sev_arr);
$c_sev_s = array();
for ($i = 0; $i < $enum_sev_count; $i++) {
$t_sev_s = explode_enum_arr($t_sev_arr[$i]);
$c_sev_s[$i] = db_prepare_string($t_sev_s[0]);
}
$t_res_arr = explode_enum_string($p_resolution_enum_string);
$enum_res_count = count($t_res_arr);
$c_res_s = array();
for ($i = 0; $i < $enum_res_count; $i++) {
$t_res_s = explode_enum_arr($t_res_arr[$i]);
$c_res_s[$i] = db_prepare_string($t_res_s[0]);
}
# Checking if it's a per project statistic or all projects
$specific_where = helper_project_specific_where($t_project_id);
if (' 1<>1' == $specific_where) {
return;
}
# Get all of the bugs and split them up into an array
$query = "SELECT COUNT(id) as count, reporter_id, resolution, severity\n\t\t\t\tFROM {$t_mantis_bug_table}\n\t\t\t\tWHERE {$specific_where}\n\t\t\t\tGROUP BY reporter_id, resolution, severity";
$result = db_query($query);
$t_reporter_ressev_arr = array();
$t_reporter_bugcount_arr = array();
$t_arr = db_fetch_array($result);
while ($t_arr) {
if (!isset($t_reporter_ressev_arr[$t_arr['reporter_id']])) {
$t_reporter_ressev_arr[$t_arr['reporter_id']] = array();
$t_reporter_bugcount_arr[$t_arr['reporter_id']] = 0;
}
if (!isset($t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']])) {
$t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']] = array();
$t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']]['total'] = 0;
}
if (!isset($t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']][$t_arr['resolution']])) {
$t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']][$t_arr['resolution']] = 0;
}
$t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']][$t_arr['resolution']] += $t_arr['count'];
$t_reporter_ressev_arr[$t_arr['reporter_id']][$t_arr['severity']]['total'] += $t_arr['count'];
$t_reporter_bugcount_arr[$t_arr['reporter_id']] += $t_arr['count'];
$t_arr = db_fetch_array($result);
}
# Sort our total bug count array so that the reporters with the highest number of bugs are listed first,
arsort($t_reporter_bugcount_arr);
$t_row_count = 0;
# We now have a multi dimensional array of users, resolutions and severities, with the
# value of each resolution and severity for each user
foreach ($t_reporter_bugcount_arr as $t_reporter_id => $t_total_user_bugs) {
# Limit the number of reporters listed
if ($t_row_count > $t_reporter_summary_limit) {
break;
}
# Only print reporters who have reported at least one bug. This helps
# prevent divide by zeroes, showing reporters not on this project, and showing
# users that aren't actually reporters...
if ($t_total_user_bugs > 0) {
$t_arr2 = $t_reporter_ressev_arr[$t_reporter_id];
print '<tr ' . helper_alternate_class($t_row_count) . '>';
$t_row_count++;
print '<td>';
print user_get_name($t_reporter_id);
print '</td>';
$t_total_severity = 0;
$t_total_errors = 0;
for ($j = 0; $j < $enum_sev_count; $j++) {
if (!isset($t_arr2[$c_sev_s[$j]])) {
continue;
}
$sev_bug_count = $t_arr2[$c_sev_s[$j]]['total'];
$t_sev_mult = $t_severity_multiplier['average'];
if ($t_severity_multiplier[$c_sev_s[$j]]) {
$t_sev_mult = $t_severity_multiplier[$c_sev_s[$j]];
}
if ($sev_bug_count > 0) {
$t_total_severity += $sev_bug_count * $t_sev_mult;
}
# Calculate the "error value" of bugs reported
$t_notbug_res_arr = array(UNABLE_TO_DUPLICATE, DUPLICATE, NOT_A_BUG);
foreach ($t_notbug_res_arr as $t_notbug_res) {
if (isset($t_arr2[$c_sev_s[$j]][$t_notbug_res])) {
$t_notbug_mult = 1;
if ($t_notbug_multiplier[$t_notbug_res]) {
$t_notbug_mult = $t_notbug_multiplier[$t_notbug_res];
}
$t_total_errors += $t_sev_mult * $t_notbug_mult;
}
}
}
print '<td>';
print $t_total_severity;
print '</td>';
print '<td>';
print $t_total_errors;
print '</td>';
print '<td>';
print $t_total_severity - $t_total_errors;
print '</td>';
print '</tr>';
}
}
}
function bug_check_workflow($p_bug_status, $p_wanted_status)
{
$t_status_enum_workflow = config_get('status_enum_workflow');
if (count($t_status_enum_workflow) < 1) {
# workflow not defined, use default enum
return true;
} else {
if ($p_bug_status == $p_wanted_status) {
# no change in state, allow the transition
return true;
} else {
# workflow defined - find allowed states
$t_allowed_states = $t_status_enum_workflow[$p_bug_status];
$t_arr = explode_enum_string($t_allowed_states);
$t_enum_count = count($t_arr);
for ($i = 0; $i < $t_enum_count; $i++) {
# check if wanted status is allowed
$t_elem = explode_enum_arr($t_arr[$i]);
if ($p_wanted_status == $t_elem[0]) {
return true;
}
}
# end for
}
}
return false;
}
function print_project_access_levels_option_list($p_val, $p_project_id = null)
{
$t_current_user_access_level = access_get_project_level($p_project_id);
$t_access_levels_enum_string = config_get('access_levels_enum_string');
# Add [default access level] to add the user to a project
# with his default access level.
print "<option value=\"" . DEFAULT_ACCESS_LEVEL . "\"";
print ">[" . lang_get('default_access_level') . "]</option>";
$t_arr = explode_enum_string($t_access_levels_enum_string);
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
$t_elem = explode_enum_arr($t_arr[$i]);
# a user must not be able to assign another user an access level that is higher than theirs.
if ($t_elem[0] > $t_current_user_access_level) {
continue;
}
$t_access_level = get_enum_element('access_levels', $t_elem[0]);
print "<option value=\"{$t_elem['0']}\"";
check_selected($p_val, $t_elem[0]);
print ">{$t_access_level}</option>";
}
# end for
}
function file_type_check($p_file_name)
{
$t_allowed_files = config_get('allowed_files');
$t_disallowed_files = config_get('disallowed_files');
# grab extension
$t_ext_array = explode('.', $p_file_name);
$last_position = count($t_ext_array) - 1;
$t_extension = $t_ext_array[$last_position];
# check against disallowed files
$t_disallowed_arr = explode_enum_string($t_disallowed_files);
foreach ($t_disallowed_arr as $t_val) {
if (0 == strcasecmp($t_val, $t_extension)) {
return false;
}
}
# if the allowed list is note populated then the file must be allowed
if (is_blank($t_allowed_files)) {
return true;
}
# check against allowed files
$t_allowed_arr = explode_enum_string($t_allowed_files);
foreach ($t_allowed_arr as $t_val) {
if (0 == strcasecmp($t_val, $t_extension)) {
return true;
}
}
return false;
}
function filter_get_bug_rows(&$p_page_number, &$p_per_page, &$p_page_count, &$p_bug_count, $p_custom_filter = null, $p_project_id = null, $p_user_id = null, $p_show_sticky = null)
{
$t_bug_table = config_get('mantis_bug_table');
$t_bug_text_table = config_get('mantis_bug_text_table');
$t_bugnote_table = config_get('mantis_bugnote_table');
$t_custom_field_string_table = config_get('mantis_custom_field_string_table');
$t_bugnote_text_table = config_get('mantis_bugnote_text_table');
$t_project_table = config_get('mantis_project_table');
$t_bug_monitor_table = config_get('mantis_bug_monitor_table');
$t_limit_reporters = config_get('limit_reporters');
$t_bug_relationship_table = config_get('mantis_bug_relationship_table');
$t_report_bug_threshold = config_get('report_bug_threshold');
$t_current_user_id = auth_get_current_user_id();
if (null === $p_user_id) {
$t_user_id = $t_current_user_id;
} else {
$t_user_id = $p_user_id;
}
$c_user_id = db_prepare_int($t_user_id);
if (null === $p_project_id) {
$t_project_id = helper_get_current_project();
} else {
$t_project_id = $p_project_id;
}
if ($p_custom_filter === null) {
# Prefer current_user_get_bug_filter() over user_get_filter() when applicable since it supports
# cookies set by previous version of the code.
if ($t_user_id == $t_current_user_id) {
$t_filter = current_user_get_bug_filter();
} else {
$t_filter = user_get_bug_filter($t_user_id, $t_project_id);
}
} else {
$t_filter = $p_custom_filter;
}
$t_filter = filter_ensure_valid_filter($t_filter);
if (false === $t_filter) {
return false;
# signify a need to create a cookie
#@@@ error instead?
}
$t_where_clauses = array("{$t_project_table}.enabled = 1", "{$t_project_table}.id = {$t_bug_table}.project_id");
$t_select_clauses = array("{$t_bug_table}.*");
$t_join_clauses = array();
$t_from_clauses = array();
if (ALL_PROJECTS == $t_project_id) {
if (!user_is_administrator($t_user_id)) {
$t_topprojects = $t_projects = user_get_accessible_projects($t_user_id);
foreach ($t_topprojects as $t_project) {
$t_projects = array_merge($t_projects, user_get_all_accessible_subprojects($t_user_id, $t_project));
}
$t_projects = array_unique($t_projects);
if (0 == count($t_projects)) {
return array();
# no accessible projects, return an empty array
} else {
if (1 == count($t_projects)) {
$t_project = $t_projects[0];
array_push($t_where_clauses, "( {$t_bug_table}.project_id={$t_project} )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.project_id in (" . implode(', ', $t_projects) . ") )");
}
}
}
} else {
access_ensure_project_level(VIEWER, $t_project_id, $t_user_id);
$t_projects = user_get_all_accessible_subprojects($t_user_id, $t_project_id);
$t_projects[] = $t_project_id;
$t_projects = array_unique($t_projects);
if (1 == count($t_projects)) {
$t_project = $t_projects[0];
array_push($t_where_clauses, "( {$t_bug_table}.project_id={$t_project} )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.project_id in (" . implode(', ', $t_projects) . ") )");
}
}
# private bug selection
if (!access_has_project_level(config_get('private_bug_threshold'), $t_project_id, $t_user_id)) {
$t_public = VS_PUBLIC;
$t_private = VS_PRIVATE;
switch ($t_filter['view_state']) {
case VS_PUBLIC:
array_push($t_where_clauses, "({$t_bug_table}.view_state='{$t_public}')");
break;
case VS_PRIVATE:
array_push($t_where_clauses, "({$t_bug_table}.view_state='{$t_private}' AND {$t_bug_table}.reporter_id='{$t_user_id}')");
break;
case META_FILTER_ANY:
default:
array_push($t_where_clauses, "({$t_bug_table}.view_state='{$t_public}' OR {$t_bug_table}.reporter_id='{$t_user_id}')");
break;
}
} else {
$t_view_state = db_prepare_int($t_filter['view_state']);
if ($t_filter['view_state'] !== META_FILTER_ANY && !is_blank($t_filter['view_state'])) {
array_push($t_where_clauses, "({$t_bug_table}.view_state='{$t_view_state}')");
}
}
# reporter
$t_any_found = false;
foreach ($t_filter['reporter_id'] as $t_filter_member) {
if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['reporter_id']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['reporter_id'] as $t_filter_member) {
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "0");
} else {
$c_reporter_id = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_reporter_id) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_reporter_id);
}
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.reporter_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.reporter_id={$t_clauses['0']} )");
}
}
# limit reporter
# @@@ thraxisp - access_has_project_level checks greater than or equal to,
# this assumed that there aren't any holes above REPORTER where the limit would apply
#
if (ON === $t_limit_reporters && !access_has_project_level(REPORTER + 1, $t_project_id, $t_user_id)) {
$c_reporter_id = $c_user_id;
array_push($t_where_clauses, "({$t_bug_table}.reporter_id='{$c_reporter_id}')");
}
# handler
$t_any_found = false;
foreach ($t_filter['handler_id'] as $t_filter_member) {
if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['handler_id']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['handler_id'] as $t_filter_member) {
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, 0);
} else {
$c_handler_id = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_handler_id) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_handler_id);
}
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.handler_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.handler_id={$t_clauses['0']} )");
}
}
# category
$t_any_found = false;
foreach ($t_filter['show_category'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['show_category']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_category'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_category = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_category}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.category in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.category={$t_clauses['0']} )");
}
}
# severity
$t_any_found = false;
foreach ($t_filter['show_severity'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_severity']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_severity'] as $t_filter_member) {
$c_show_severity = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_severity);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.severity in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.severity={$t_clauses['0']} )");
}
}
# show / hide status
# take a list of all available statuses then remove the ones that we want hidden, then make sure
# the ones we want shown are still available
$t_status_arr = explode_enum_string(config_get('status_enum_string'));
$t_available_statuses = array();
$t_desired_statuses = array();
foreach ($t_status_arr as $t_this_status) {
$t_this_status_arr = explode_enum_arr($t_this_status);
$t_available_statuses[] = $t_this_status_arr[0];
}
if ('simple' == $t_filter['_view_type']) {
# simple filtering: if showing any, restrict by the hide status value, otherwise ignore the hide
$t_any_found = false;
$t_this_status = $t_filter['show_status'][0];
$t_this_hide_status = $t_filter['hide_status'][0];
if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) {
$t_any_found = true;
}
if ($t_any_found) {
foreach ($t_available_statuses as $t_this_available_status) {
if ($t_this_hide_status > $t_this_available_status) {
$t_desired_statuses[] = $t_this_available_status;
}
}
} else {
$t_desired_statuses[] = $t_this_status;
}
} else {
# advanced filtering: ignore the hide
$t_any_found = false;
foreach ($t_filter['show_status'] as $t_this_status) {
$t_desired_statuses[] = $t_this_status;
if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) {
$t_any_found = true;
}
}
if ($t_any_found) {
$t_desired_statuses = array();
}
}
if (count($t_desired_statuses) > 0) {
$t_clauses = array();
foreach ($t_desired_statuses as $t_filter_member) {
$c_show_status = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_status);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.status in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.status={$t_clauses['0']} )");
}
}
# resolution
$t_any_found = false;
foreach ($t_filter['show_resolution'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_resolution']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_resolution'] as $t_filter_member) {
$c_show_resolution = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_resolution);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.resolution in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.resolution={$t_clauses['0']} )");
}
}
# priority
$t_any_found = false;
foreach ($t_filter['show_priority'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_priority']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_priority'] as $t_filter_member) {
$c_show_priority = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_priority);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.priority in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.priority={$t_clauses['0']} )");
}
}
# product build
$t_any_found = false;
foreach ($t_filter['show_build'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['show_build']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_build'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_build = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_build}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.build in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.build={$t_clauses['0']} )");
}
}
# product version
$t_any_found = false;
foreach ($t_filter['show_version'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['show_version']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_version'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_version = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_version}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.version in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.version={$t_clauses['0']} )");
}
}
# profile
$t_any_found = false;
foreach ($t_filter['show_profile'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['show_profile']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_profile'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "0");
} else {
$c_show_profile = db_prepare_int($t_filter_member);
array_push($t_clauses, "{$c_show_profile}");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.profile_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.profile_id={$t_clauses['0']} )");
}
}
# date filter
if ('on' == $t_filter['do_filter_by_date'] && is_numeric($t_filter['start_month']) && is_numeric($t_filter['start_day']) && is_numeric($t_filter['start_year']) && is_numeric($t_filter['end_month']) && is_numeric($t_filter['end_day']) && is_numeric($t_filter['end_year'])) {
$t_start_string = db_prepare_string($t_filter['start_year'] . "-" . $t_filter['start_month'] . "-" . $t_filter['start_day'] . " 00:00:00");
$t_end_string = db_prepare_string($t_filter['end_year'] . "-" . $t_filter['end_month'] . "-" . $t_filter['end_day'] . " 23:59:59");
array_push($t_where_clauses, "({$t_bug_table}.date_submitted BETWEEN '{$t_start_string}' AND '{$t_end_string}' )");
}
# fixed in version
$t_any_found = false;
foreach ($t_filter['fixed_in_version'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['fixed_in_version']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['fixed_in_version'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_fixed_in_version = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_fixed_in_version}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version={$t_clauses['0']} )");
}
}
# users monitoring a bug
$t_any_found = false;
foreach ($t_filter['user_monitor'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['user_monitor']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
$t_table_name = 'user_monitor';
array_push($t_from_clauses, $t_bug_monitor_table);
array_push($t_join_clauses, "LEFT JOIN {$t_bug_monitor_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id");
foreach ($t_filter['user_monitor'] as $t_filter_member) {
$c_user_monitor = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_user_monitor) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_user_monitor);
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_table_name}.user_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_table_name}.user_id={$t_clauses['0']} )");
}
}
# bug relationship
$t_any_found = false;
$c_rel_type = $t_filter['relationship_type'];
$c_rel_bug = $t_filter['relationship_bug'];
if (-1 == $c_rel_type || 0 == $c_rel_bug) {
$t_any_found = true;
}
if (!$t_any_found) {
# use the complementary type
$c_rel_type = relationship_get_complementary_type($c_rel_type);
$t_clauses = array();
$t_table_name = 'relationship';
array_push($t_from_clauses, $t_bug_relationship_table);
array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name} ON {$t_table_name}.destination_bug_id = {$t_bug_table}.id");
// get reverse relationships
if ($c_rel_type == 1) {
array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name}" . "2 ON {$t_table_name}" . "2.source_bug_id = {$t_bug_table}.id");
}
array_push($t_clauses, "({$t_table_name}.relationship_type='{$c_rel_type}' AND {$t_table_name}.source_bug_id='{$c_rel_bug}')");
// get reverse relationships
if ($c_rel_type == 1) {
array_push($t_clauses, "({$t_table_name}" . "2.relationship_type='{$c_rel_type}' AND {$t_table_name}" . "2.destination_bug_id='{$c_rel_bug}')");
}
array_push($t_where_clauses, '(' . implode(' OR ', $t_clauses) . ')');
}
# custom field filters
if (ON == config_get('filter_by_custom_fields')) {
# custom field filtering
$t_custom_fields = custom_field_get_linked_ids($t_project_id);
foreach ($t_custom_fields as $t_cfid) {
$t_first_time = true;
$t_custom_where_clause = '';
# Ignore all custom filters that are not set, or that are set to '' or "any"
$t_any_found = false;
foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (!isset($t_filter['custom_fields'][$t_cfid])) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_def = custom_field_get_definition($t_cfid);
$t_table_name = $t_custom_field_string_table . '_' . $t_cfid;
# We need to filter each joined table or the result query will explode in dimensions
# Each custom field will result in a exponential growth like Number_of_Issues^Number_of_Custom_Fields
# and only after this process ends (if it is able to) the result query will be filtered
# by the WHERE clause and by the DISTINCT clause
$t_cf_join_clause = "LEFT JOIN {$t_custom_field_string_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id AND {$t_table_name}.field_id = {$t_cfid} ";
if ($t_def['type'] == CUSTOM_FIELD_TYPE_DATE) {
switch ($t_filter['custom_fields'][$t_cfid][0]) {
case CUSTOM_FIELD_DATE_ANY:
break;
case CUSTOM_FIELD_DATE_NONE:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.bug_id is null) OR ( ' . $t_table_name . '.value = 0)';
break;
case CUSTOM_FIELD_DATE_BEFORE:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.value != 0 AND (' . $t_table_name . '.value+0) < ' . $t_filter['custom_fields'][$t_cfid][2] . ')';
break;
case CUSTOM_FIELD_DATE_AFTER:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.field_id = ' . $t_cfid . ' AND (' . $t_table_name . '.value+0) > ' . ($t_filter['custom_fields'][$t_cfid][1] + 1) . ')';
break;
default:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.field_id = ' . $t_cfid . ' AND (' . $t_table_name . '.value+0) BETWEEN ' . $t_filter['custom_fields'][$t_cfid][1] . ' AND ' . $t_filter['custom_fields'][$t_cfid][2] . ')';
break;
}
} else {
array_push($t_join_clauses, $t_cf_join_clause);
foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE === $t_filter_member) {
# coerce filter value if selecting META_FILTER_NONE
$t_filter_member = '';
}
if ($t_first_time) {
$t_first_time = false;
$t_custom_where_clause = '(';
} else {
$t_custom_where_clause .= ' OR ';
}
$t_custom_where_clause .= "{$t_table_name}.value ";
switch ($t_def['type']) {
case CUSTOM_FIELD_TYPE_MULTILIST:
case CUSTOM_FIELD_TYPE_CHECKBOX:
$t_custom_where_clause .= "LIKE '%|";
$t_custom_where_clause_closing = "|%'";
break;
default:
$t_custom_where_clause .= "= '";
$t_custom_where_clause_closing = "'";
}
$t_custom_where_clause .= db_prepare_string($t_filter_member);
$t_custom_where_clause .= $t_custom_where_clause_closing;
}
}
if (!is_blank($t_custom_where_clause)) {
array_push($t_where_clauses, $t_custom_where_clause . ')');
}
}
}
}
$t_textsearch_where_clause = '';
$t_textsearch_wherejoin_clause = '';
# Simple Text Search - Thanks to Alan Knowles
if (!is_blank($t_filter['search'])) {
$c_search = db_prepare_string($t_filter['search']);
$c_search_int = db_prepare_int($t_filter['search']);
$t_textsearch_where_clause = "((summary LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.description LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.steps_to_reproduce LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.additional_information LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_table}.id = '{$c_search_int}'))";
$t_textsearch_wherejoin_clause = "((summary LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.description LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.steps_to_reproduce LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_text_table}.additional_information LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bug_table}.id LIKE '%{$c_search}%')\n\t\t\t\t\t\t\t OR ({$t_bugnote_text_table}.note LIKE '%{$c_search}%'))";
array_push($t_where_clauses, "({$t_bug_text_table}.id = {$t_bug_table}.bug_text_id)");
$t_from_clauses = array($t_bug_text_table, $t_project_table, $t_bug_table);
} else {
$t_from_clauses = array($t_project_table, $t_bug_table);
}
$t_select = implode(', ', array_unique($t_select_clauses));
$t_from = 'FROM ' . implode(', ', array_unique($t_from_clauses));
$t_join = implode(' ', $t_join_clauses);
if (count($t_where_clauses) > 0) {
$t_where = 'WHERE ' . implode(' AND ', $t_where_clauses);
} else {
$t_where = '';
}
# Possibly do two passes. First time, grab the IDs of issues that match the filters. Second time, grab the IDs of issues that
# have bugnotes that match the text search if necessary.
$t_id_array = array();
for ($i = 0; $i < 2; $i++) {
$t_id_where = $t_where;
$t_id_join = $t_join;
if ($i == 0) {
if (!is_blank($t_id_where) && !is_blank($t_textsearch_where_clause)) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_where_clause;
}
} else {
if (!is_blank($t_textsearch_wherejoin_clause)) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_wherejoin_clause;
$t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_table} ON {$t_bugnote_table}.bug_id = {$t_bug_table}.id";
$t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_text_table} ON {$t_bugnote_text_table}.id = {$t_bugnote_table}.bugnote_text_id";
}
}
$query = "SELECT DISTINCT {$t_bug_table}.id AS id\n\t\t\t\t\t\t{$t_from}\n\t\t\t\t\t\t{$t_id_join}\n\t\t\t\t\t\t{$t_id_where}";
if ($i == 0 || !is_blank($t_textsearch_wherejoin_clause)) {
$result = db_query($query);
$row_count = db_num_rows($result);
for ($j = 0; $j < $row_count; $j++) {
$row = db_fetch_array($result);
$t_id_array[] = db_prepare_int($row['id']);
}
}
}
$t_id_array = array_unique($t_id_array);
if (count($t_id_array) > 0) {
$t_where = "WHERE {$t_bug_table}.id in (" . implode(", ", $t_id_array) . ")";
} else {
$t_where = "WHERE 1 != 1";
}
$t_from = 'FROM ' . $t_bug_table;
# Get the total number of bugs that meet the criteria.
$bug_count = count($t_id_array);
# write the value back in case the caller wants to know
$p_bug_count = $bug_count;
if (null === $p_per_page) {
$p_per_page = (int) $t_filter['per_page'];
} else {
if (-1 == $p_per_page) {
$p_per_page = $bug_count;
}
}
# Guard against silly values of $f_per_page.
if (0 == $p_per_page) {
$p_per_page = 1;
}
$p_per_page = (int) abs($p_per_page);
# Use $bug_count and $p_per_page to determine how many pages
# to split this list up into.
# For the sake of consistency have at least one page, even if it
# is empty.
$t_page_count = ceil($bug_count / $p_per_page);
if ($t_page_count < 1) {
$t_page_count = 1;
}
# write the value back in case the caller wants to know
$p_page_count = $t_page_count;
# Make sure $p_page_number isn't past the last page.
if ($p_page_number > $t_page_count) {
$p_page_number = $t_page_count;
}
# Make sure $p_page_number isn't before the first page
if ($p_page_number < 1) {
$p_page_number = 1;
}
# Now add the rest of the criteria i.e. sorting, limit.
# if sort is blank then default the sort and direction. This is to fix the
# symptoms of #3953. Note that even if the main problem is fixed, we may
# have to keep this code for a while to handle filters saved with this blank field.
if (is_blank($t_filter['sort'])) {
$t_filter['sort'] = 'last_updated';
$t_filter['dir'] = 'DESC';
}
$t_order_array = array();
$t_sort_fields = split(',', $t_filter['sort']);
$t_dir_fields = split(',', $t_filter['dir']);
if ('on' == $t_filter['sticky_issues'] && NULL !== $p_show_sticky) {
$t_order_array[] = "sticky DESC";
}
for ($i = 0; $i < count($t_sort_fields); $i++) {
$c_sort = db_prepare_string($t_sort_fields[$i]);
if (!in_array($t_sort_fields[$i], array_slice($t_sort_fields, $i + 1))) {
# if sorting by a custom field
if (strpos($c_sort, 'custom_') === 0) {
$t_custom_field = substr($c_sort, strlen('custom_'));
$t_custom_field_id = custom_field_get_id_from_name($t_custom_field);
$t_join .= " LEFT JOIN {$t_custom_field_string_table} ON ( ( {$t_custom_field_string_table}.bug_id = {$t_bug_table}.id ) AND ( {$t_custom_field_string_table}.field_id = {$t_custom_field_id} ) )";
$c_sort = "{$t_custom_field_string_table}.value";
$t_select_clauses[] = "{$t_custom_field_string_table}.value";
}
if ('DESC' == $t_dir_fields[$i]) {
$c_dir = 'DESC';
} else {
$c_dir = 'ASC';
}
$t_order_array[] = "{$c_sort} {$c_dir}";
}
}
# add basic sorting if necessary
if (!in_array('last_updated', $t_sort_fields)) {
$t_order_array[] = 'last_updated DESC';
}
if (!in_array('date_submitted', $t_sort_fields)) {
$t_order_array[] = 'date_submitted DESC';
}
$t_order = " ORDER BY " . implode(', ', $t_order_array);
$t_select = implode(', ', array_unique($t_select_clauses));
$query2 = "SELECT DISTINCT {$t_select}\n\t\t\t\t\t{$t_from}\n\t\t\t\t\t{$t_join}\n\t\t\t\t\t{$t_where}\n\t\t\t\t\t{$t_order}";
# Figure out the offset into the db query
#
# for example page number 1, per page 5:
# t_offset = 0
# for example page number 2, per page 5:
# t_offset = 5
$c_per_page = db_prepare_int($p_per_page);
$c_page_number = db_prepare_int($p_page_number);
$t_offset = ($c_page_number - 1) * $c_per_page;
# perform query
$result2 = db_query($query2, $c_per_page, $t_offset);
$row_count = db_num_rows($result2);
$rows = array();
for ($i = 0; $i < $row_count; $i++) {
$row = db_fetch_array($result2);
$row['date_submitted'] = db_unixtimestamp($row['date_submitted']);
$row['last_updated'] = db_unixtimestamp($row['last_updated']);
array_push($rows, $row);
bug_add_to_cache($row);
}
return $rows;
}
function enum_bug_group($p_enum_string, $p_enum)
{
$t_bug_table = config_get('mantis_bug_table');
$t_project_id = helper_get_current_project();
$t_bug_table = config_get('mantis_bug_table');
$t_user_id = auth_get_current_user_id();
$t_res_val = config_get('bug_resolved_status_threshold');
$t_clo_val = CLOSED;
$specific_where = " AND " . helper_project_specific_where($t_project_id, $t_user_id);
$t_arr = explode_enum_string($p_enum_string);
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
$t_s = explode(':', $t_arr[$i]);
$t_key = get_enum_to_string($p_enum_string, $t_s[0]);
# Calculates the number of bugs opened and puts the results in a table
$query = "SELECT COUNT(*)\n\t\t\t\t\tFROM {$t_bug_table}\n\t\t\t\t\tWHERE {$p_enum}='{$t_s['0']}' AND\n\t\t\t\t\t\tstatus<'{$t_res_val}' {$specific_where}";
$result2 = db_query($query);
$t_metrics['open'][$t_key] = db_result($result2, 0, 0);
# Calculates the number of bugs closed and puts the results in a table
$query = "SELECT COUNT(*)\n\t\t\t\t\tFROM {$t_bug_table}\n\t\t\t\t\tWHERE {$p_enum}='{$t_s['0']}' AND\n\t\t\t\t\t\tstatus='{$t_clo_val}' {$specific_where}";
$result2 = db_query($query);
$t_metrics['closed'][$t_key] = db_result($result2, 0, 0);
# Calculates the number of bugs resolved and puts the results in a table
$query = "SELECT COUNT(*)\n\t\t\t\t\tFROM {$t_bug_table}\n\t\t\t\t\tWHERE {$p_enum}='{$t_s['0']}' AND\n\t\t\t\t\t\tstatus>='{$t_res_val}' AND\n\t\t\t\t\t\tstatus<'{$t_clo_val}' {$specific_where}";
$result2 = db_query($query);
$t_metrics['resolved'][$t_key] = db_result($result2, 0, 0);
}
### end for
return $t_metrics;
}
function access_begin($p_section_name)
{
$t_enum_status = explode_enum_string(config_get('status_enum_string'));
echo '<table class="width100">';
echo '<tr><td class="form-title" colspan=2>' . strtoupper($p_section_name) . '</td></tr>' . "\n";
echo '<tr><td class="form-title" colspan=2>' . lang_get('access_change') . '</td></tr>';
}
/**
* Get the enum id given the enum label.
*
* @param $p_enum_string The enum string to search in.
* @param $p_label The label to search for.
*
* @return The id corresponding to the given label, or 0 if not found.
*/
function mci_get_enum_value_from_label($p_enum_string, $p_label)
{
$t_arr = explode_enum_string($p_enum_string);
$enum_count = count($t_arr);
for ($i = 0; $i < $enum_count; $i++) {
$t_s = explode_enum_arr($t_arr[$i]);
if ($t_s[1] == $p_label) {
return $t_s[0];
}
}
return 0;
}
function html_status_percentage_legend()
{
$t_mantis_bug_table = config_get('mantis_bug_table');
$t_project_id = helper_get_current_project();
$t_user_id = auth_get_current_user_id();
#checking if it's a per project statistic or all projects
$t_specific_where = helper_project_specific_where($t_project_id, $t_user_id);
$query = "SELECT status, COUNT(*) AS number\r\n\t\t\t\tFROM {$t_mantis_bug_table}\r\n\t\t\t\tWHERE {$t_specific_where}\r\n\t\t\t\tGROUP BY status";
$result = db_query($query);
$t_bug_count = 0;
$t_status_count_array = array();
while ($row = db_fetch_array($result)) {
$t_status_count_array[$row['status']] = $row['number'];
$t_bug_count += $row['number'];
}
$t_arr = explode_enum_string(config_get('status_enum_string'));
$enum_count = count($t_arr);
if ($t_bug_count > 0) {
echo '<br />';
echo '<table class="width100" cellspacing="1">';
echo '<tr>';
echo '<td class="form-title" colspan="' . $enum_count . '">' . lang_get('issue_status_percentage') . '</td>';
echo '</tr>';
echo '<tr>';
for ($i = 0; $i < $enum_count; $i++) {
$t_s = explode_enum_arr($t_arr[$i]);
$t_color = get_status_color($t_s[0]);
$t_status = $t_s[0];
if (!isset($t_status_count_array[$t_status])) {
$t_status_count_array[$t_status] = 0;
}
$width = round($t_status_count_array[$t_status] / $t_bug_count * 100);
if ($width > 0) {
echo "<td class=\"small-caption-center\" width=\"{$width}%\" bgcolor=\"{$t_color}\">{$width}%</td>";
}
}
echo '</tr>';
echo '</table>';
}
}
function filter_get_bug_rows(&$p_page_number, &$p_per_page, &$p_page_count, &$p_bug_count, $p_custom_filter = null, $p_project_id = null, $p_user_id = null, $p_show_sticky = null)
{
log_event(LOG_FILTERING, 'FILTERING: START NEW FILTER QUERY');
$t_bug_table = config_get('mantis_bug_table');
$t_bug_text_table = config_get('mantis_bug_text_table');
$t_bugnote_table = config_get('mantis_bugnote_table');
$t_custom_field_string_table = config_get('mantis_custom_field_string_table');
$t_bugnote_text_table = config_get('mantis_bugnote_text_table');
$t_project_table = config_get('mantis_project_table');
$t_bug_monitor_table = config_get('mantis_bug_monitor_table');
$t_limit_reporters = config_get('limit_reporters');
$t_bug_relationship_table = config_get('mantis_bug_relationship_table');
$t_report_bug_threshold = config_get('report_bug_threshold');
$t_current_user_id = auth_get_current_user_id();
if (null === $p_user_id) {
$t_user_id = $t_current_user_id;
} else {
$t_user_id = $p_user_id;
}
$c_user_id = db_prepare_int($t_user_id);
if (null === $p_project_id) {
# @@@ If project_id is not specified, then use the project id(s) in the filter if set, otherwise, use current project.
$t_project_id = helper_get_current_project();
} else {
$t_project_id = $p_project_id;
}
if ($p_custom_filter === null) {
# Prefer current_user_get_bug_filter() over user_get_filter() when applicable since it supports
# cookies set by previous version of the code.
if ($t_user_id == $t_current_user_id) {
$t_filter = current_user_get_bug_filter();
} else {
$t_filter = user_get_bug_filter($t_user_id, $t_project_id);
}
} else {
$t_filter = $p_custom_filter;
}
$t_filter = filter_ensure_valid_filter($t_filter);
if (false === $t_filter) {
return false;
# signify a need to create a cookie
#@@@ error instead?
}
$t_view_type = $t_filter['_view_type'];
$t_where_clauses = array("{$t_project_table}.enabled = 1", "{$t_project_table}.id = {$t_bug_table}.project_id");
$t_select_clauses = array("{$t_bug_table}.*");
$t_join_clauses = array();
$t_from_clauses = array();
// normalize the project filtering into an array $t_project_ids
if ('simple' == $t_view_type) {
log_event(LOG_FILTERING, 'FILTERING: Simple Filter');
$t_project_ids = array($t_project_id);
$t_include_sub_projects = true;
} else {
log_event(LOG_FILTERING, 'FILTERING: Advanced Filter');
if (!is_array($t_filter['project_id'])) {
$t_project_ids = array(db_prepare_int($t_filter['project_id']));
} else {
$t_project_ids = array_map('db_prepare_int', $t_filter['project_id']);
}
$t_include_sub_projects = count($t_project_ids) == 1 && $t_project_ids[0] == META_FILTER_CURRENT;
}
log_event(LOG_FILTERING, 'FILTERING: project_ids = ' . implode(',', $t_project_ids));
log_event(LOG_FILTERING, 'FILTERING: include sub-projects = ' . ($t_include_sub_projects ? '1' : '0'));
// if the array has ALL_PROJECTS, then reset the array to only contain ALL_PROJECTS.
// replace META_FILTER_CURRENT with the actualy current project id.
$t_all_projects_found = false;
$t_new_project_ids = array();
foreach ($t_project_ids as $t_pid) {
if ($t_pid == META_FILTER_CURRENT) {
$t_pid = $t_project_id;
}
if ($t_pid == ALL_PROJECTS) {
$t_all_projects_found = true;
log_event(LOG_FILTERING, 'FILTERING: all projects selected');
break;
}
// filter out inaccessible projects.
if (!access_has_project_level(VIEWER, $t_pid, $t_user_id)) {
continue;
}
$t_new_project_ids[] = $t_pid;
}
$t_projects_query_required = true;
if ($t_all_projects_found) {
if (user_is_administrator($t_user_id)) {
log_event(LOG_FILTERING, 'FILTERING: all projects + administrator, hence no project filter.');
$t_projects_query_required = false;
} else {
$t_project_ids = user_get_accessible_projects($t_user_id);
}
} else {
$t_project_ids = $t_new_project_ids;
}
if ($t_projects_query_required) {
// expand project ids to include sub-projects
if ($t_include_sub_projects) {
$t_top_project_ids = $t_project_ids;
foreach ($t_top_project_ids as $t_pid) {
log_event(LOG_FILTERING, 'FILTERING: Getting sub-projects for project id ' . $t_pid);
$t_project_ids = array_merge($t_project_ids, user_get_all_accessible_subprojects($t_user_id, $t_pid));
}
$t_project_ids = array_unique($t_project_ids);
}
// if no projects are accessible, then return an empty array.
if (count($t_project_ids) == 0) {
log_event(LOG_FILTERING, 'FILTERING: no accessible projects');
return array();
}
log_event(LOG_FILTERING, 'FILTERING: project_ids after including sub-projects = ' . implode(',', $t_project_ids));
// this array is to be populated with project ids for which we only want to show public issues. This is due to the limited
// access of the current user.
$t_public_only_project_ids = array();
// this array is populated with project ids that the current user has full access to.
$t_private_and_public_project_ids = array();
$t_access_required_to_view_private_bugs = config_get('private_bug_threshold');
foreach ($t_project_ids as $t_pid) {
if (access_has_project_level($t_access_required_to_view_private_bugs, $t_pid, $t_user_id)) {
$t_private_and_public_project_ids[] = $t_pid;
} else {
$t_public_only_project_ids[] = $t_pid;
}
}
log_event(LOG_FILTERING, 'FILTERING: project_ids (with public/private access) = ' . implode(',', $t_private_and_public_project_ids));
log_event(LOG_FILTERING, 'FILTERING: project_ids (with public access) = ' . implode(',', $t_public_only_project_ids));
$t_count_private_and_public_project_ids = count($t_private_and_public_project_ids);
if ($t_count_private_and_public_project_ids == 1) {
$t_private_and_public_query = "( {$t_bug_table}.project_id = " . $t_private_and_public_project_ids[0] . " )";
} else {
if ($t_count_private_and_public_project_ids > 1) {
$t_private_and_public_query = "( {$t_bug_table}.project_id in (" . implode(', ', $t_private_and_public_project_ids) . ") )";
} else {
$t_private_and_public_query = null;
}
}
$t_count_public_only_project_ids = count($t_public_only_project_ids);
$t_public_view_state_check = "( ( {$t_bug_table}.view_state = " . VS_PUBLIC . " ) OR ( {$t_bug_table}.reporter_id = {$t_user_id} ) )";
if ($t_count_public_only_project_ids == 1) {
$t_public_only_query = "( ( {$t_bug_table}.project_id = " . $t_public_only_project_ids[0] . " ) AND {$t_public_view_state_check} )";
} else {
if ($t_count_public_only_project_ids > 1) {
$t_public_only_query = "( ( {$t_bug_table}.project_id in (" . implode(', ', $t_public_only_project_ids) . ") ) AND {$t_public_view_state_check} )";
} else {
$t_public_only_query = null;
}
}
// both queries can't be null, so we either have one of them or both.
if ($t_private_and_public_query === null) {
$t_project_query = $t_public_only_query;
} else {
if ($t_public_only_query === null) {
$t_project_query = $t_private_and_public_query;
} else {
$t_project_query = "( {$t_public_only_query} OR {$t_private_and_public_query} )";
}
}
log_event(LOG_FILTERING, 'FILTERING: project query = ' . $t_project_query);
array_push($t_where_clauses, $t_project_query);
}
# view state
$t_view_state = db_prepare_int($t_filter['view_state']);
if ($t_filter['view_state'] !== META_FILTER_ANY && !is_blank($t_filter['view_state'])) {
$t_view_state_query = "({$t_bug_table}.view_state='{$t_view_state}')";
log_event(LOG_FILTERING, 'FILTERING: view_state query = ' . $t_view_state_query);
array_push($t_where_clauses, $t_view_state_query);
} else {
log_event(LOG_FILTERING, 'FILTERING: no view_state query');
}
# reporter
$t_any_found = false;
foreach ($t_filter['reporter_id'] as $t_filter_member) {
if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['reporter_id']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['reporter_id'] as $t_filter_member) {
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "0");
} else {
$c_reporter_id = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_reporter_id) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_reporter_id);
}
}
}
if (1 < count($t_clauses)) {
$t_reporter_query = "( {$t_bug_table}.reporter_id in (" . implode(', ', $t_clauses) . ") )";
} else {
$t_reporter_query = "( {$t_bug_table}.reporter_id={$t_clauses['0']} )";
}
log_event(LOG_FILTERING, 'FILTERING: reporter query = ' . $t_reporter_query);
array_push($t_where_clauses, $t_reporter_query);
} else {
log_event(LOG_FILTERING, 'FILTERING: no reporter query');
}
# limit reporter
# @@@ thraxisp - access_has_project_level checks greater than or equal to,
# this assumed that there aren't any holes above REPORTER where the limit would apply
#
if (ON === $t_limit_reporters && !access_has_project_level(REPORTER + 1, $t_project_id, $t_user_id)) {
$c_reporter_id = $c_user_id;
array_push($t_where_clauses, "({$t_bug_table}.reporter_id='{$c_reporter_id}')");
}
# handler
$t_any_found = false;
foreach ($t_filter['handler_id'] as $t_filter_member) {
if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['handler_id']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['handler_id'] as $t_filter_member) {
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, 0);
} else {
$c_handler_id = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_handler_id) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_handler_id);
}
}
}
if (1 < count($t_clauses)) {
$t_handler_query = "( {$t_bug_table}.handler_id in (" . implode(', ', $t_clauses) . ") )";
} else {
$t_handler_query = "( {$t_bug_table}.handler_id={$t_clauses['0']} )";
}
log_event(LOG_FILTERING, 'FILTERING: handler query = ' . $t_handler_query);
array_push($t_where_clauses, $t_handler_query);
} else {
log_event(LOG_FILTERING, 'FILTERING: no handler query');
}
# category
if (!_filter_is_any($t_filter['show_category'])) {
$t_clauses = array();
foreach ($t_filter['show_category'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_category = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_category}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.category in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.category={$t_clauses['0']} )");
}
}
# severity
$t_any_found = false;
foreach ($t_filter['show_severity'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_severity']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_severity'] as $t_filter_member) {
$c_show_severity = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_severity);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.severity in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.severity={$t_clauses['0']} )");
}
}
# show / hide status
# take a list of all available statuses then remove the ones that we want hidden, then make sure
# the ones we want shown are still available
$t_status_arr = explode_enum_string(config_get('status_enum_string'));
$t_available_statuses = array();
$t_desired_statuses = array();
foreach ($t_status_arr as $t_this_status) {
$t_this_status_arr = explode_enum_arr($t_this_status);
$t_available_statuses[] = $t_this_status_arr[0];
}
if ('simple' == $t_filter['_view_type']) {
# simple filtering: if showing any, restrict by the hide status value, otherwise ignore the hide
$t_any_found = false;
$t_this_status = $t_filter['show_status'][0];
$t_this_hide_status = $t_filter['hide_status'][0];
if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) {
$t_any_found = true;
}
if ($t_any_found) {
foreach ($t_available_statuses as $t_this_available_status) {
if ($t_this_hide_status > $t_this_available_status) {
$t_desired_statuses[] = $t_this_available_status;
}
}
} else {
$t_desired_statuses[] = $t_this_status;
}
} else {
# advanced filtering: ignore the hide
$t_any_found = false;
foreach ($t_filter['show_status'] as $t_this_status) {
$t_desired_statuses[] = $t_this_status;
if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) {
$t_any_found = true;
}
}
if ($t_any_found) {
$t_desired_statuses = array();
}
}
if (count($t_desired_statuses) > 0) {
$t_clauses = array();
foreach ($t_desired_statuses as $t_filter_member) {
$c_show_status = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_status);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.status in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.status={$t_clauses['0']} )");
}
}
# resolution
$t_any_found = false;
foreach ($t_filter['show_resolution'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_resolution']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_resolution'] as $t_filter_member) {
$c_show_resolution = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_resolution);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.resolution in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.resolution={$t_clauses['0']} )");
}
}
# priority
$t_any_found = false;
foreach ($t_filter['show_priority'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['show_priority']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_priority'] as $t_filter_member) {
$c_show_priority = db_prepare_int($t_filter_member);
array_push($t_clauses, $c_show_priority);
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.priority in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.priority={$t_clauses['0']} )");
}
}
# product build
$t_any_found = false;
foreach ($t_filter['show_build'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (count($t_filter['show_build']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
foreach ($t_filter['show_build'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_build = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_build}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.build in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.build={$t_clauses['0']} )");
}
}
# product version
if (!_filter_is_any($t_filter['show_version'])) {
$t_clauses = array();
foreach ($t_filter['show_version'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_show_version = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_show_version}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.version in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.version={$t_clauses['0']} )");
}
}
# profile
if (!_filter_is_any($t_filter['show_profile'])) {
$t_clauses = array();
foreach ($t_filter['show_profile'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "0");
} else {
$c_show_profile = db_prepare_int($t_filter_member);
array_push($t_clauses, "{$c_show_profile}");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.profile_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.profile_id={$t_clauses['0']} )");
}
}
# platform
if (!_filter_is_any($t_filter['platform'])) {
$t_clauses = array();
foreach ($t_filter['platform'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, '');
} else {
$c_platform = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_platform}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.platform in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.platform = {$t_clauses['0']} )");
}
}
# os
if (!_filter_is_any($t_filter['os'])) {
$t_clauses = array();
foreach ($t_filter['os'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, '');
} else {
$c_os = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_os}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.os in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.os = {$t_clauses['0']} )");
}
}
# os_build
if (!_filter_is_any($t_filter['os_build'])) {
$t_clauses = array();
foreach ($t_filter['os_build'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, '');
} else {
$c_os_build = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_os_build}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.os_build in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.os_build = {$t_clauses['0']} )");
}
}
# date filter
if ('on' == $t_filter['do_filter_by_date'] && is_numeric($t_filter['start_month']) && is_numeric($t_filter['start_day']) && is_numeric($t_filter['start_year']) && is_numeric($t_filter['end_month']) && is_numeric($t_filter['end_day']) && is_numeric($t_filter['end_year'])) {
$t_start_string = db_prepare_string($t_filter['start_year'] . "-" . $t_filter['start_month'] . "-" . $t_filter['start_day'] . " 00:00:00");
$t_end_string = db_prepare_string($t_filter['end_year'] . "-" . $t_filter['end_month'] . "-" . $t_filter['end_day'] . " 23:59:59");
array_push($t_where_clauses, "({$t_bug_table}.date_submitted BETWEEN '{$t_start_string}' AND '{$t_end_string}' )");
}
# fixed in version
if (!_filter_is_any($t_filter['fixed_in_version'])) {
$t_clauses = array();
foreach ($t_filter['fixed_in_version'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_fixed_in_version = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_fixed_in_version}'");
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version={$t_clauses['0']} )");
}
}
# target version
if (!_filter_is_any($t_filter['target_version'])) {
$t_clauses = array();
foreach ($t_filter['target_version'] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
array_push($t_clauses, "''");
} else {
$c_target_version = db_prepare_string($t_filter_member);
array_push($t_clauses, "'{$c_target_version}'");
}
}
#echo var_dump( $t_clauses ); exit;
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_bug_table}.target_version in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_bug_table}.target_version={$t_clauses['0']} )");
}
}
# users monitoring a bug
$t_any_found = false;
foreach ($t_filter['user_monitor'] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) {
$t_any_found = true;
}
}
if (count($t_filter['user_monitor']) == 0) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_clauses = array();
$t_table_name = 'user_monitor';
array_push($t_from_clauses, $t_bug_monitor_table);
array_push($t_join_clauses, "LEFT JOIN {$t_bug_monitor_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id");
foreach ($t_filter['user_monitor'] as $t_filter_member) {
$c_user_monitor = db_prepare_int($t_filter_member);
if (META_FILTER_MYSELF == $c_user_monitor) {
array_push($t_clauses, $c_user_id);
} else {
array_push($t_clauses, $c_user_monitor);
}
}
if (1 < count($t_clauses)) {
array_push($t_where_clauses, "( {$t_table_name}.user_id in (" . implode(', ', $t_clauses) . ") )");
} else {
array_push($t_where_clauses, "( {$t_table_name}.user_id={$t_clauses['0']} )");
}
}
# bug relationship
$t_any_found = false;
$c_rel_type = $t_filter['relationship_type'];
$c_rel_bug = $t_filter['relationship_bug'];
if (-1 == $c_rel_type || 0 == $c_rel_bug) {
$t_any_found = true;
}
if (!$t_any_found) {
# use the complementary type
$t_comp_type = relationship_get_complementary_type($c_rel_type);
$t_clauses = array();
$t_table_name = 'relationship';
array_push($t_from_clauses, $t_bug_relationship_table);
array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name} ON {$t_table_name}.destination_bug_id = {$t_bug_table}.id");
array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name}2 ON {$t_table_name}2.source_bug_id = {$t_bug_table}.id");
// get reverse relationships
array_push($t_clauses, "({$t_table_name}.relationship_type='{$t_comp_type}' AND {$t_table_name}.source_bug_id='{$c_rel_bug}')");
array_push($t_clauses, "({$t_table_name}" . "2.relationship_type='{$c_rel_type}' AND {$t_table_name}" . "2.destination_bug_id='{$c_rel_bug}')");
array_push($t_where_clauses, '(' . implode(' OR ', $t_clauses) . ')');
}
# tags
$c_tag_string = trim($t_filter['tag_string']);
if (!is_blank($c_tag_string)) {
$t_tags = tag_parse_filters($c_tag_string);
if (count($t_tags)) {
$t_tags_all = array();
$t_tags_any = array();
$t_tags_none = array();
foreach ($t_tags as $t_tag_row) {
switch ($t_tag_row['filter']) {
case 1:
$t_tags_all[] = $t_tag_row;
break;
case 0:
$t_tags_any[] = $t_tag_row;
break;
case -1:
$t_tags_none[] = $t_tag_row;
break;
}
}
if (0 < $t_filter['tag_select'] && tag_exists($t_filter['tag_select'])) {
$t_tags_any[] = tag_get($t_filter['tag_select']);
}
$t_bug_tag_table = config_get('mantis_bug_tag_table');
if (count($t_tags_all)) {
$t_clauses = array();
foreach ($t_tags_all as $t_tag_row) {
array_push($t_clauses, "{$t_bug_table}.id IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE {$t_bug_tag_table}.tag_id = {$t_tag_row['id']} )");
}
array_push($t_where_clauses, '(' . implode(' AND ', $t_clauses) . ')');
}
if (count($t_tags_any)) {
$t_clauses = array();
foreach ($t_tags_any as $t_tag_row) {
array_push($t_clauses, "{$t_bug_tag_table}.tag_id = {$t_tag_row['id']}");
}
array_push($t_where_clauses, "{$t_bug_table}.id IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE ( " . implode(' OR ', $t_clauses) . ') )');
}
if (count($t_tags_none)) {
$t_clauses = array();
foreach ($t_tags_none as $t_tag_row) {
array_push($t_clauses, "{$t_bug_tag_table}.tag_id = {$t_tag_row['id']}");
}
array_push($t_where_clauses, "{$t_bug_table}.id NOT IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE ( " . implode(' OR ', $t_clauses) . ') )');
}
}
}
# custom field filters
if (ON == config_get('filter_by_custom_fields')) {
# custom field filtering
# @@@ At the moment this gets the linked fields relating to the current project
# It should get the ones relating to the project in the filter or all projects
# if multiple projects.
$t_custom_fields = custom_field_get_linked_ids($t_project_id);
foreach ($t_custom_fields as $t_cfid) {
$t_custom_where_clause = '';
# Ignore all custom filters that are not set, or that are set to '' or "any"
$t_any_found = false;
foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) {
if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) {
$t_any_found = true;
}
}
if (!isset($t_filter['custom_fields'][$t_cfid])) {
$t_any_found = true;
}
if (!$t_any_found) {
$t_def = custom_field_get_definition($t_cfid);
$t_table_name = $t_custom_field_string_table . '_' . $t_cfid;
# We need to filter each joined table or the result query will explode in dimensions
# Each custom field will result in a exponential growth like Number_of_Issues^Number_of_Custom_Fields
# and only after this process ends (if it is able to) the result query will be filtered
# by the WHERE clause and by the DISTINCT clause
$t_cf_join_clause = "LEFT JOIN {$t_custom_field_string_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id AND {$t_table_name}.field_id = {$t_cfid} ";
if ($t_def['type'] == CUSTOM_FIELD_TYPE_DATE) {
switch ($t_filter['custom_fields'][$t_cfid][0]) {
case CUSTOM_FIELD_DATE_ANY:
break;
case CUSTOM_FIELD_DATE_NONE:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.bug_id is null) OR ( ' . $t_table_name . '.value = 0)';
break;
case CUSTOM_FIELD_DATE_BEFORE:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '(( ' . $t_table_name . '.value != 0 AND (' . $t_table_name . '.value+0) < ' . $t_filter['custom_fields'][$t_cfid][2] . ')';
break;
case CUSTOM_FIELD_DATE_AFTER:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '( (' . $t_table_name . '.value+0) > ' . ($t_filter['custom_fields'][$t_cfid][1] + 1);
break;
default:
array_push($t_join_clauses, $t_cf_join_clause);
$t_custom_where_clause = '( (' . $t_table_name . '.value+0) BETWEEN ' . $t_filter['custom_fields'][$t_cfid][1] . ' AND ' . $t_filter['custom_fields'][$t_cfid][2];
break;
}
} else {
array_push($t_join_clauses, $t_cf_join_clause);
$t_filter_array = array();
foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) {
$t_filter_member = stripslashes($t_filter_member);
if (META_FILTER_NONE == $t_filter_member) {
# coerce filter value if selecting META_FILTER_NONE so it will match empty fields
$t_filter_member = '';
# but also add those _not_ present in the custom field string table
array_push($t_filter_array, "{$t_bug_table}.id NOT IN (SELECT bug_id FROM {$t_custom_field_string_table} WHERE field_id={$t_cfid})");
}
switch ($t_def['type']) {
case CUSTOM_FIELD_TYPE_MULTILIST:
case CUSTOM_FIELD_TYPE_CHECKBOX:
array_push($t_filter_array, db_helper_like("{$t_table_name}.value", '%|' . db_prepare_string($t_filter_member) . '|%'));
break;
default:
array_push($t_filter_array, "{$t_table_name}.value = '" . db_prepare_string($t_filter_member) . "'");
}
}
$t_custom_where_clause .= '(' . implode(' OR ', $t_filter_array);
}
if (!is_blank($t_custom_where_clause)) {
array_push($t_where_clauses, $t_custom_where_clause . ')');
}
}
}
}
$t_textsearch_where_clause = '';
$t_textsearch_wherejoin_clause = '';
# Simple Text Search - Thanks to Alan Knowles
if (!is_blank($t_filter['search'])) {
$c_search = db_prepare_string($t_filter['search']);
$c_search_int = db_prepare_int($t_filter['search']);
$t_textsearch_where_clause = '(' . db_helper_like('summary', "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.description", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.steps_to_reproduce", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.additional_information", "%{$c_search}%") . " OR ( {$t_bug_table}.id = '{$c_search_int}' ) )";
$t_textsearch_wherejoin_clause = '(' . db_helper_like('summary', "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.description", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.steps_to_reproduce", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.additional_information", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_table}.id", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bugnote_text_table}.note", "%{$c_search}%") . ' )';
array_push($t_where_clauses, "({$t_bug_text_table}.id = {$t_bug_table}.bug_text_id)");
$t_from_clauses = array($t_bug_text_table, $t_project_table, $t_bug_table);
} else {
$t_from_clauses = array($t_project_table, $t_bug_table);
}
$t_select = implode(', ', array_unique($t_select_clauses));
$t_from = 'FROM ' . implode(', ', array_unique($t_from_clauses));
$t_join = implode(' ', $t_join_clauses);
if (count($t_where_clauses) > 0) {
$t_where = 'WHERE ' . implode(' AND ', $t_where_clauses);
} else {
$t_where = '';
}
# Possibly do two passes. First time, grab the IDs of issues that match the filters. Second time, grab the IDs of issues that
# have bugnotes that match the text search if necessary.
$t_id_array = array();
for ($i = 0; $i < 2; $i++) {
$t_id_where = $t_where;
$t_id_join = $t_join;
if ($i == 0) {
if (!is_blank($t_id_where) && !is_blank($t_textsearch_where_clause)) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_where_clause;
}
} else {
if (!is_blank($t_textsearch_wherejoin_clause)) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_wherejoin_clause;
$t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_table} ON {$t_bugnote_table}.bug_id = {$t_bug_table}.id";
$t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_text_table} ON {$t_bugnote_text_table}.id = {$t_bugnote_table}.bugnote_text_id";
}
}
$query = "SELECT DISTINCT {$t_bug_table}.id AS id\r\n\t\t\t\t\t\t{$t_from}\r\n\t\t\t\t\t\t{$t_id_join}\r\n\t\t\t\t\t\t{$t_id_where}";
if ($i == 0 || !is_blank($t_textsearch_wherejoin_clause)) {
$result = db_query($query);
$row_count = db_num_rows($result);
for ($j = 0; $j < $row_count; $j++) {
$row = db_fetch_array($result);
$t_id_array[] = db_prepare_int($row['id']);
}
}
}
$t_id_array = array_unique($t_id_array);
# Get the total number of bugs that meet the criteria.
$bug_count = count($t_id_array);
$rows = array();
if ($bug_count > 0) {
$t_where = "WHERE {$t_bug_table}.id in (" . implode(", ", $t_id_array) . ")";
} else {
return $rows;
}
$t_from = 'FROM ' . $t_bug_table;
# write the value back in case the caller wants to know
$p_bug_count = $bug_count;
if (null === $p_per_page) {
$p_per_page = (int) $t_filter['per_page'];
} else {
if (-1 == $p_per_page) {
$p_per_page = $bug_count;
}
}
# Guard against silly values of $f_per_page.
if (0 == $p_per_page) {
$p_per_page = $bug_count;
// 0 - means show all
}
$p_per_page = (int) abs($p_per_page);
# Use $bug_count and $p_per_page to determine how many pages
# to split this list up into.
# For the sake of consistency have at least one page, even if it
# is empty.
$t_page_count = ceil($bug_count / $p_per_page);
if ($t_page_count < 1) {
$t_page_count = 1;
}
# write the value back in case the caller wants to know
$p_page_count = $t_page_count;
# Make sure $p_page_number isn't past the last page.
if ($p_page_number > $t_page_count) {
$p_page_number = $t_page_count;
}
# Make sure $p_page_number isn't before the first page
if ($p_page_number < 1) {
$p_page_number = 1;
}
# Now add the rest of the criteria i.e. sorting, limit.
# if sort is blank then default the sort and direction. This is to fix the
# symptoms of #3953. Note that even if the main problem is fixed, we may
# have to keep this code for a while to handle filters saved with this blank field.
if (is_blank($t_filter['sort'])) {
$t_filter['sort'] = 'last_updated';
$t_filter['dir'] = 'DESC';
}
$t_order_array = array();
$t_sort_fields = split(',', $t_filter['sort']);
$t_dir_fields = split(',', $t_filter['dir']);
if ('on' == $t_filter['sticky_issues'] && NULL !== $p_show_sticky) {
$t_order_array[] = "sticky DESC";
}
$t_join = '';
for ($i = 0; $i < count($t_sort_fields); $i++) {
$c_sort = db_prepare_string($t_sort_fields[$i]);
if (!in_array($t_sort_fields[$i], array_slice($t_sort_fields, $i + 1))) {
# if sorting by a custom field
if (strpos($c_sort, 'custom_') === 0) {
$t_custom_field = substr($c_sort, strlen('custom_'));
$t_custom_field_id = custom_field_get_id_from_name($t_custom_field);
$t_join .= " LEFT JOIN {$t_custom_field_string_table} ON ( ( {$t_custom_field_string_table}.bug_id = {$t_bug_table}.id ) AND ( {$t_custom_field_string_table}.field_id = {$t_custom_field_id} ) )";
$c_sort = "{$t_custom_field_string_table}.value";
$t_select_clauses[] = "{$t_custom_field_string_table}.value";
}
if ('DESC' == $t_dir_fields[$i]) {
$c_dir = 'DESC';
} else {
$c_dir = 'ASC';
}
$t_order_array[] = "{$c_sort} {$c_dir}";
}
}
# add basic sorting if necessary
if (!in_array('last_updated', $t_sort_fields)) {
$t_order_array[] = 'last_updated DESC';
}
if (!in_array('date_submitted', $t_sort_fields)) {
$t_order_array[] = 'date_submitted DESC';
}
$t_order = " ORDER BY " . implode(', ', $t_order_array);
$t_select = implode(', ', array_unique($t_select_clauses));
$query2 = "SELECT DISTINCT {$t_select}\r\n\t\t\t\t\t{$t_from}\r\n\t\t\t\t\t{$t_join}\r\n\t\t\t\t\t{$t_where}\r\n\t\t\t\t\t{$t_order}";
# Figure out the offset into the db query
#
# for example page number 1, per page 5:
# t_offset = 0
# for example page number 2, per page 5:
# t_offset = 5
$c_per_page = db_prepare_int($p_per_page);
$c_page_number = db_prepare_int($p_page_number);
$t_offset = ($c_page_number - 1) * $c_per_page;
# perform query
$result2 = db_query($query2, $c_per_page, $t_offset);
$row_count = db_num_rows($result2);
$t_id_array_lastmod = array();
for ($i = 0; $i < $row_count; $i++) {
$row = db_fetch_array($result2);
$t_id_array_lastmod[] = db_prepare_int($row['id']);
$row['date_submitted'] = db_unixtimestamp($row['date_submitted']);
$row['last_updated'] = db_unixtimestamp($row['last_updated']);
array_push($rows, $row);
}
$t_id_array_lastmod = array_unique($t_id_array_lastmod);
// paulr: it should be impossible for t_id_array_lastmod to be array():
// that would imply that $t_id_array is null which aborts this function early
//if ( count( $t_id_array_lastmod ) > 0 ) {
$t_where = "WHERE {$t_bugnote_table}.bug_id in (" . implode(", ", $t_id_array_lastmod) . ")";
$query3 = "SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM {$t_bugnote_table} {$t_where} GROUP BY bug_id";
# perform query
$result3 = db_query($query3);
$row_count = db_num_rows($result3);
for ($i = 0; $i < $row_count; $i++) {
$row = db_fetch_array($result3);
$t_stats[$row['bug_id']] = $row;
}
foreach ($rows as $row) {
if (!isset($t_stats[$row['id']])) {
bug_cache_database_result($row, false);
} else {
bug_cache_database_result($row, $t_stats[$row['id']]);
}
}
return $rows;
}