Example #1
0
	<TR><TD>
		<B>Assigned To:</B><BR>
		<?php 
    /*
    	List of people that can be assigned this bug
    */
    echo bug_technician_box('assigned_to', $group_id, db_result($result, 0, 'assigned_to'));
    ?>
	</TD>
	<TD>
		<B>Status:</B><BR>
		<?php 
    /*
    	Status of this bug
    */
    echo bug_status_box('status_id', db_result($result, 0, 'status_id'));
    ?>
	</TD></TR>

	<TR><TD COLSPAN="2"><B>Summary:</B><BR>
		<INPUT TYPE="TEXT" NAME="summary" SIZE="45" VALUE="<?php 
    echo db_result($result, 0, 'summary');
    ?>
" MAXLENGTH="60">
	</TD></TR>

	<TR><TD COLSPAN="2"><B>Use a Canned Response:</B><BR>
		<?php 
    echo bug_canned_response_box($group_id, 'canned_response');
    echo '
			<P>
Example #2
0
function show_buglist($result, $offset, $set = 'open')
{
    global $sys_datefmt, $group_id, $PHP_SELF;
    /*
    	Accepts a result set from the bugs table. Should include all columns from
    	the table, and it should be joined to USER to get the user_name.
    */
    $IS_BUG_ADMIN = user_ismember($group_id, 'B2');
    echo '
		<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
		<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
		<INPUT TYPE="HIDDEN" NAME="func" VALUE="massupdate">';
    $rows = db_numrows($result);
    $url = "/bugs/?group_id={$group_id}&set={$set}&order=";
    $title_arr = array();
    $title_arr[] = 'Bug ID';
    $title_arr[] = 'Summary';
    $title_arr[] = 'Category';
    $title_arr[] = 'Group';
    $title_arr[] = 'Status';
    $title_arr[] = 'Date';
    $title_arr[] = 'Assigned To';
    $title_arr[] = 'Submitted By';
    $links_arr = array();
    $links_arr[] = $url . 'bug_id';
    $links_arr[] = $url . 'summary';
    $links_arr[] = $url . 'category_id';
    $links_arr[] = $url . 'bug_group_id';
    $links_arr[] = $url . 'status_id';
    $links_arr[] = $url . 'date';
    $links_arr[] = $url . 'assigned_to_user';
    $links_arr[] = $url . 'submitted_by';
    echo html_build_list_table_top($title_arr, $links_arr);
    //see if the bugs are too old - so we can highlight them
    $then = time() - 2592000;
    for ($i = 0; $i < $rows && $i < 50; $i++) {
        echo '
		<TR BGCOLOR="' . get_priority_color(db_result($result, $i, 'priority')) . '">' . '<TD NOWRAP>' . ($IS_BUG_ADMIN ? '<INPUT TYPE="CHECKBOX" NAME="bug_id[]" VALUE="' . db_result($result, $i, 'bug_id') . '"> ' : '') . sprintf("%06d", db_result($result, $i, 'bug_id')) . '</TD>' . '<TD><A HREF="/bugs/?func=detailbug&bug_id=' . db_result($result, $i, 'bug_id') . '&group_id=' . db_result($result, $i, 'group_id') . '">' . db_result($result, $i, 'summary') . '</A></TD>' . '<TD>' . db_result($result, $i, 'category_name') . '</TD>' . '<TD>' . db_result($result, $i, 'group_name') . '</TD>' . '<TD>' . db_result($result, $i, 'status_name') . '</TD>' . '<TD>' . ($set != 'closed' && db_result($result, $i, 'date') < $then ? '<B>* ' : '&nbsp; ') . date($sys_datefmt, db_result($result, $i, 'date')) . '</TD>' . '<TD>' . db_result($result, $i, 'assigned_to_user') . '</TD>' . '<TD>' . db_result($result, $i, 'submitted_by') . '</TD></TR>';
    }
    /*
    	Show extra rows for <-- Prev / Next -->
    */
    echo '
		<TR><TD COLSPAN="2">';
    if ($offset > 0) {
        echo '<A HREF="' . $PHP_SELF . '?func=browse&group_id=' . $group_id . '&set=' . $set . '&offset=' . ($offset - 50) . '"><B><-- Previous 50</B></A>';
    } else {
        echo '&nbsp;';
    }
    echo '</TD><TD>&nbsp;</TD><TD COLSPAN="2">';
    if ($rows > 50) {
        echo '<A HREF="' . $PHP_SELF . '?func=browse&group_id=' . $group_id . '&set=' . $set . '&offset=' . ($offset + 50) . '"><B>Next 50 --></B></A>';
    } else {
        echo '&nbsp;';
    }
    echo '</TD></TR>';
    /*
    	Mass Update Code
    */
    if ($IS_BUG_ADMIN) {
        echo '<TR><TD COLSPAN="5">
		<FONT COLOR="#FF0000"><B>Bug Admin:</B></FONT>  If you wish to apply changes to all bugs selected above, use these controls to change their properties and click once on "Mass Update".
		<TABLE WIDTH="100%" BORDER="0">

		<TR><TD><B>Category:</B><BR>' . bug_category_box('bug_category_id', $group_id, 'xyz', 'No Change') . '</TD>
		<TD><B>Priority:</B><BR>';
        echo build_priority_select_box('priority', '5', true);
        echo '</TD></TR>

		<TR><TD><B>Bug Group:</B><BR>' . bug_group_box('bug_group_id', $group_id, 'xtz', 'No Change') . '</TD>
		<TD><B>Resolution:</B><BR>' . bug_resolution_box('resolution_id', 'xyz', 'No Change') . '</TD></TR>

		<TR><TD><B>Assigned To:</B><BR>' . bug_technician_box('assigned_to', $group_id, 'xyz', 'No Change') . '</TD>
		<TD><B>Status:</B><BR>' . bug_status_box('status_id', 'xyz', 'No Change') . '</TD></TR>

		<TR><TD COLSPAN="2" ALIGN="MIDDLE"><INPUT TYPE="SUBMIT" name="submit" VALUE="Mass Update"></TD></TR>

		</TABLE>	
		</TD></TR>';
    }
    echo '</TABLE>';
}
Example #3
0
$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 . '">
	<INPUT TYPE="HIDDEN" NAME="set" VALUE="custom">
	<H2>Browse Bug Requests by</H2>
	<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="6">
	<TR><TD><b>Assigned User:</b></TD><TD><b>Status:</b></TD><TD><b>Category:</b></TD><TD><b>Group:</b></TD></TR>
	<TR><TD><FONT SIZE="-1">' . $tech_box . '</TD>' . '<TD><FONT SIZE="-1">' . bug_status_box('_status', $_status, 'Any') . '</TD>' . '<TD><FONT SIZE="-1">' . bug_category_box('_category', $group_id, $_category, 'Any') . '</TD>' . '<TD><FONT SIZE="-1">' . bug_group_box('_bug_group', $group_id, $_bug_group, 'Any') . '</TD>' . '<TD><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Browse"></TD></TR></TABLE></FORM>';
if ($set == 'open') {
    /*
    	For open or default, see if the user has a filter set up
    */
    if (user_isloggedin()) {
        $sql = "SELECT sql_clause FROM bug_filter WHERE user_id='" . user_getid() . "' AND group_id='{$group_id}' AND is_active='1'";
        $result = db_query($sql);
    } else {
        $result = false;
    }
    if ($result && db_numrows($result) > 0) {
        $sql = "SELECT bug.group_id,bug.priority,bug.bug_id,bug.summary,bug.date,users.user_name AS submitted_by," . "user2.user_name AS assigned_to_user," . "bug.category_id," . "bug.bug_group_id," . "bug_category.category_name," . "bug_group.group_name," . "bug_status.status_name " . "FROM bug,bug_category,bug_group,bug_status,users,users user2 " . "WHERE (" . stripslashes(db_result($result, 0, 'sql_clause')) . ") " . "AND users.user_id=bug.submitted_by " . "AND user2.user_id=bug.assigned_to " . "AND bug_category.bug_category_id=bug.category_id " . "AND bug_group.bug_group_id=bug.bug_group_id " . "AND bug_status.status_id=bug.status_id " . "AND bug_id!='100'" . $order_by;
        //        	echo "<p>Default Query: $sql\n";
        $statement = "Using Your Filter";
    } else {