function summary_helper_count_bugs( $query_part ) {
	$resolved_result = db_query( $query_part .' AND status='. RESOLVED );
	$resolved_arr = db_fetch_array( $resolved_result );
	list(, $resolved) = each( $resolved_arr );
	
	$closed_result = db_query( $query_part .' AND status='. CLOSED );
	$closed_arr = db_fetch_array( $closed_result );
	list(, $closed) = each( $closed_arr );
	
	$total_result = db_query( $query_part );
	$total_arr = db_fetch_array( $total_result );
	list(, $total) = each( $total_arr );
	
	return Array( 'open' => $total - $closed - $resolved,
		'resolved' => $resolved,
		'closed' => $closed,
		'total' => $total); 
}

# --------------------
# print a bug count per category
function summary_print_by_category() {
	$t_mantis_bug_table = config_get( 'mantis_bug_table' );
	$t_mantis_project_table = config_get( 'mantis_project_table' );
	$t_mantis_project_category_table = config_get( 'mantis_project_category_table' );
	$t_summary_category_include_project = config_get( 'summary_category_include_project' );
	
	$t_project_id = helper_get_current_project();
	$t_user_id = auth_get_current_user_id();
	
	$specific_where = helper_project_specific_where( $t_project_id );
	if ( ' 1<>1' == $specific_where ) {
		return;
	}
	
	# Sum up the bugs in each category
	$query = "SELECT DISTINCT category
		FROM $t_mantis_project_category_table
		WHERE $specific_where
		ORDER BY category";
	$category_result = db_query( $query );
	# Start with empty category
	$category_row = array( "category" => "" );
	do {
		extract( $category_row, EXTR_PREFIX_ALL, 'v' );
		$query_part = "SELECT COUNT(id)
			FROM $t_mantis_bug_table
			WHERE $specific_where
			AND category='". db_prepare_string( $v_category )."'";
		$bugs = summary_helper_count_bugs( $query_part );
		$t_bug_link = '<a class="subtle" href="' . config_get( 'bug_count_hyperlink_prefix' ) . '&amp;show_category=' . $v_category;
		summary_helper_print_row( $v_category,
			$t_bug_link. '&amp;hide_status=' .RESOLVED. '">' .$bugs['open']. '</a>',
			$t_bug_link. '&amp;show_status=' .RESOLVED. '&amp;hide_status=' .CLOSED. '">' .$bugs['resolved']. '</a>',
			$t_bug_link. '&amp;show_status=' .CLOSED. '&amp;hide_status=">' .$bugs['closed']. '</a>',
			$t_bug_link. '&amp;hide_status=">' .$bugs['total']. '</a>' );
	} while ( $category_row = db_fetch_array( $category_result ) );
}