示例#1
0
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>';
    }
}
示例#2
0
    $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 . '">