function show_bughistory($bug_id) { /* show the bug_history rows that are relevant to this bug_id, excluding details */ global $sys_datefmt; $result = bug_data_get_history($bug_id); $rows = db_numrows($result); if ($rows > 0) { echo ' <H3>Bug Change History</H3> <P>'; $title_arr = array(); $title_arr[] = 'Field'; $title_arr[] = 'Old Value'; $title_arr[] = 'Date'; $title_arr[] = 'By'; echo html_build_list_table_top($title_arr); for ($i = 0; $i < $rows; $i++) { $field = db_result($result, $i, 'field_name'); echo ' <TR BGCOLOR="' . html_get_alt_row_color($i) . '"><TD>' . $field . '</TD><TD>'; if ($field == 'status_id') { echo bug_data_get_status_name(db_result($result, $i, 'old_value')); } else { if ($field == 'category_id') { echo bug_data_get_category_name(db_result($result, $i, 'old_value')); } else { if ($field == 'assigned_to') { echo user_getname(db_result($result, $i, 'old_value')); } else { if ($field == 'close_date') { echo date($sys_datefmt, db_result($result, $i, 'old_value')); } else { if ($field == 'resolution_id') { echo bug_data_get_resolution_name(db_result($result, $i, 'old_value')); } else { if ($field == 'bug_group_id') { echo bug_data_get_group_name(db_result($result, $i, 'old_value')); } else { echo db_result($result, $i, 'old_value'); } } } } } } echo '</TD>' . '<TD>' . date($sys_datefmt, db_result($result, $i, 'date')) . '</TD>' . '<TD>' . db_result($result, $i, 'user_name') . '</TD></TR>'; } echo ' </TABLE>'; } else { echo ' <H3>No Changes Have Been Made to This Bug</H3>'; } }
$category_str = "AND bug.category_id='{$_category}' "; } else { //no category to was chosen, so don't add it to where clause $category_str = ''; } //if bug_group selected, add to where clause if ($_bug_group && $_bug_group != 100) { $bug_group_str = "AND bug.bug_group_id='{$_bug_group}' "; } else { //no bug_group was chosen, so don't add it to where clause $bug_group_str = ''; } //build page title to make bookmarking easier //if a user was selected, add the user_name to the title //same for status bug_header(array('title' => 'Browse Bugs' . ($_assigned_to ? ' For: ' . user_getname($_assigned_to) : '') . ($_status && $_status != 100 ? ' By Status: ' . bug_data_get_status_name($_status) : ''))); /* creating a custom technician box which includes "any" and "unassigned" */ $res_tech = bug_data_get_technicians($group_id); $tech_id_arr = util_result_column_to_array($res_tech, 0); $tech_id_arr[] = '0'; //this will be the 'any' row $tech_name_arr = util_result_column_to_array($res_tech, 1); $tech_name_arr[] = 'Any'; $tech_box = html_build_select_box_from_arrays($tech_id_arr, $tech_name_arr, '_assigned_to', $_assigned_to, true, 'Unassigned'); /* Show the new pop-up boxes to select assigned to and/or status */ echo '<FORM ACTION="' . $PHP_SELF . '" METHOD="GET"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">