function bugs_quick_report($group_id, $title, $subtitle1, $sql1, $subtitle2, $sql2)
{
global $bar_colors;
bug_header(array("title" => $title));
bug_reporting_header($group_id);
echo "\n<H2>{$title}</H2>";
reports_quick_graph($subtitle1, $sql1, $sql2, $bar_colors);
bug_footer(array());
}
<P>
<FORM ACTION="<?php
echo $PHP_SELF;
?>
" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodfilters">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="<?php
echo $group_id;
?>
">
<INPUT TYPE="HIDDEN" NAME="subfunc" VALUE="turn_off">
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Deactivate Filters">
</FORM>
<?php
}
bug_header(array('title' => 'Create a Personal Filter'));
if (user_isloggedin()) {
echo "<H2>Create a personal filter for " . user_getname() . "</H2>";
echo "<B>Creating or modifying a filter makes it your active filter</B><P>";
echo "Be sure include 'bug.' before each field name, as in the example, as multiple tables are being joined in the query";
show_filters($group_id);
$sql = "SELECT users.user_id,users.user_name FROM users,user_group WHERE users.user_id=user_group.user_id AND user_group.bug_flags IN (1,2) AND user_group.group_id='{$group_id}'";
$result = db_query($sql);
$sql = "select * from bug_status";
$result2 = db_query($sql);
$sql = "select bug_category_id,category_name from bug_category WHERE group_id='{$group_id}'";
$result3 = db_query($sql);
$sql = "select * from bug_resolution";
$result4 = db_query($sql);
$sql = "select bug_group_id,group_name from bug_group WHERE group_id='{$group_id}'";
$result5 = db_query($sql);
<B>Message Body:</B><BR>
<TEXTAREA NAME="body" ROWS="30" COLS="65" WRAP="HARD"><?php
echo db_result($result, 0, 'body');
?>
</TEXTAREA>
<P>
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
</FORM>
<?php
}
bug_footer(array());
} else {
/*
Show main page
*/
bug_header(array('title' => 'Bug Administration'));
echo '
<H2>Bug Administration</H2>';
echo '<P>
<A HREF="' . $PHP_SELF . '?group_id=' . $group_id . '&bug_cat=1">Add Bug Categories</A><BR>';
echo "\nAdd categories of bugs like, 'mail module','gant chart module','interface', etc<P>";
echo "\n<A HREF=\"{$PHP_SELF}?group_id={$group_id}&bug_group=1\">Add Bug Groups</A><BR>";
echo "\nAdd Groups of bugs like 'future requests','unreproducible', etc<P>";
echo "\n<A HREF=\"{$PHP_SELF}?group_id={$group_id}&create_canned=1\">Add Canned Responses</A><BR>";
echo "\nCreate or Change generic quick response messages for the bug tracking tool.<P>";
bug_footer(array());
}
}
}
}
}
Add the new filter
*/
$sql = "INSERT INTO bug_filter (user_id,group_id,sql_clause,is_active) VALUES ('" . user_getid() . "','{$group_id}','{$sql_clause}','1')";
$result = db_query($sql);
if (!$result) {
bug_header(array("title" => "Filter Add Failed"));
echo "<H1>Add failed</H2>";
echo db_error();
bug_footer(array());
exit;
} else {
$feedback .= " Successfully Added Filter ";
}
} else {
if ($subfunc == "turn_off") {
/*
Set all filters for this user/group to inactive
*/
$toss = db_query("UPDATE bug_filter SET is_active='0' WHERE user_id='" . user_getid() . "' AND group_id='{$group_id}'");
$feedback .= " Turned Off Filters ";
} else {
bug_header(array("title" => "Filter Update Failed"));
echo "<H1>We are in a F.U.B.A.R. state</H2>";
bug_footer(array());
exit;
}
}
}
} else {
exit_not_logged_in();
}
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: mod_bug.php,v 1.2 2003/11/13 11:29:21 helix Exp $
bug_header(array('title' => 'Modify a Bug'));
$sql = "SELECT * FROM bug WHERE bug_id='{$bug_id}' AND group_id='{$group_id}'";
$result = db_query($sql);
if (db_numrows($result) > 0) {
echo "\n<H2>[ Bug #{$bug_id} ] " . db_result($result, 0, "summary") . "</H2>";
echo "<FORM ACTION=\"{$PHP_SELF}\" METHOD=\"POST\">\n" . "<INPUT TYPE=\"HIDDEN\" NAME=\"func\" VALUE=\"postmodbug\">\n" . "<INPUT TYPE=\"HIDDEN\" NAME=\"group_id\" VALUE=\"{$group_id}\">\n" . "<INPUT TYPE=\"HIDDEN\" NAME=\"bug_id\" VALUE=\"{$bug_id}\">";
echo "\n<TABLE WIDTH=\"100%\">\n\t<TR>\n\t\t<TD><B>Submitted By:</B><BR>" . user_getname(db_result($result, 0, "submitted_by")) . "</TD>\n\t\t<TD><B>Date Submitted:</B><BR>" . date($sys_datefmt, db_result($result, 0, 'date')) . "</TD>\n\t</TR>\n\n\t<TR>\n\t\t<TD><B>Move To Project:</B><BR>\n";
/*
List of projects that this user is admin of
*/
echo bug_user_project_box('project_id', user_getid(), $group_id);
echo "\n\t\t</TD>\n\t\t<TD><FONT SIZE=\"-1\"><INPUT TYPE=\"SUBMIT\" NAME=\"SUBMIT\" VALUE=\"Submit Changes\">\n\t\t</TD>\n\t</TR>";
echo "<TR><TD><B>Category:</B><BR>\n";
/*
List of bug_categories for this project.
*/
echo bug_category_box('category_id', $group_id, db_result($result, 0, 'category_id'));
echo "</TD><TD><B>Priority:</B><BR>\n";
/*
Priority of this bug
*/
echo build_priority_select_box('priority', db_result($result, 0, 'priority'));
?>
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: add_bug.php,v 1.2 2003/11/13 11:29:21 helix Exp $
bug_header(array('title' => 'Submit a Bug'));
echo '<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="func" VALUE="postaddbug">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
<TABLE>
<TR><TD VALIGN="TOP" COLSPAN="2"><B>Group:</B><BR>' . group_getname($group_id) . '</TD></TR>
<TR><TD VALIGN="TOP"><B>Category:</B><BR>';
/*
List of possible categories for this project
*/
echo bug_category_box('category_id', $group_id);
echo '</TD>
<TD><B>Bug Group:</B><BR>';
/*
List of possible bug_groups for this project
*/
echo bug_group_box('bug_group_id', $group_id);
echo '</TD></TR>';
if (user_ismember($group_id, 'A')) {
echo '
<TR><TD><B>Priority:</B><BR>';
/*
Priority of this bug
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: detail_bug.php,v 1.2 2003/11/13 11:29:21 helix Exp $
bug_header(array('title' => 'Bug Detail: ' . $bug_id));
$project =& project_get_object($group_id);
$sql = "SELECT bug_group.group_name,bug_resolution.resolution_name,bug.details,bug.summary,users.user_name AS submitted_by," . "user2.user_name AS assigned_to,bug.priority,bug_status.status_name,bug.date,bug_category.category_name " . "FROM bug,users,users user2,bug_group,bug_resolution,bug_category,bug_status WHERE bug.submitted_by=users.user_id AND bug.assigned_to=user2.user_id AND " . "bug.status_id=bug_status.status_id AND bug.category_id=bug_category.bug_category_id AND bug.bug_id='{$bug_id}' " . "AND bug.bug_group_id=bug_group.bug_group_id AND bug.resolution_id=bug_resolution.resolution_id";
$result = db_query($sql);
if (db_numrows($result) > 0) {
echo '
<H2>[ Bug #' . $bug_id . ' ] ' . db_result($result, 0, 'summary') . '</H2>
<TABLE CELLPADDING="0" WIDTH="100%">
<TR><TD COLSPAN="2"><B>Date:</B><BR>' . date($sys_datefmt, db_result($result, 0, 'date')) . '</TD></TR>
<TR>
<TD><B>Submitted By:</B><BR>' . db_result($result, 0, 'submitted_by') . '</TD>
<TD><B>Assigned To:</B><BR>' . db_result($result, 0, 'assigned_to') . '</TD>
</TR>
<TR>
<TD><B>Category:</B><BR>' . db_result($result, 0, 'category_name') . '</TD>
<TD><B>Priority:</B><BR>' . db_result($result, 0, 'priority') . '</TD>
</TR>
<TR>
<TD><B>Bug Group:</B><BR>' . db_result($result, 0, 'group_name') . '</TD>
$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 . '">
