Skip to content

bugzilla
bugzilla
Switch branch/tag
Find file
Normal viewHistoryPermalink
reports.cgi 9.57 KB
Newer Older
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 
#!/usr/bonsaitools/bin/perl -w
# -*- Mode: perl; indent-tabs-mode: nil -*-
#
# The contents of this file are subject to the Mozilla Public License
# Version 1.0 (the "License"); you may not use this file except in
# compliance with the License. You may obtain a copy of the License at
# http://www.mozilla.org/MPL/
#
# Software distributed under the License is distributed on an "AS IS"
# basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
# License for the specific language governing rights and limitations
# under the License.
#
# The Original Code is the Bugzilla Bug Tracking System.
#
# The Initial Developer of the Original Code is Netscape Communications
# Corporation. Portions created by Netscape are Copyright (C) 1998
# Netscape Communications Corporation. All Rights Reserved.
#
# Contributor(s): Harrison Page <harrison@netscape.com>,
# Terry Weissman <terry@mozilla.org>

use diagnostics;
use strict;
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
25 
use Chart::Lines;
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
26 27 28 29 30 31 

require "CGI.pl";
require "globals.pl";

use vars @::legal_product;
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
32 
my $dir = "data/mining";
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
33 34 35 
my $week = 60 * 60 * 24 * 7;
my @status = qw (NEW ASSIGNED REOPENED);
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
36 37 
# while this looks odd/redundant, it allows us to name
# functions differently than the value passed in
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
38
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
39 40 41 42 43 44 
my %reports = 
	( 
	"most_doomed" => \&most_doomed,
	"show_chart" => \&show_chart,
	);
terry%netscape.com's avatar
Patch from Sam Ziegler <sam@ziegler.org>: fix some typos.
67a9cd49
 
terry%netscape.com committed
45 
# patch from Sam Ziegler <sam@ziegler.org>:
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
46 47 48 49 
#
# "reports.cgi currently has it's own idea of what 
# the header should be. This patch sets it to the 
# system wide header."
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
50
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
51 52 53 54 55 
print "Content-type: text/html\n\n";

if (defined $::FORM{'nobanner'})
	{
print <<FIN;
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
56 
<html>
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
57 
<head><title>Bug Reports</title></head>
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
58 59 
<body bgcolor="#FFFFFF">
FIN
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
60 61 62 63 64 65 66 
	}
else
	{
	PutHeader ("Bug Reports") unless (defined $::FORM{'nobanner'});
	}

ConnectToDatabase();
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
67 
GetVersionTable();
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
68
harrison%netscape.com's avatar
output key no longer required, silently defaults to most_doomed.
26a9b7cb
 
harrison%netscape.com committed
69 70 
$::FORM{'output'} = $::FORM{'output'} || "most_doomed"; # a reasonable default
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
71 72 73 74 75 76 
if (! defined $::FORM{'product'})
	{
	&choose_product;
	}
else
	{
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
77 78 79 80 
	# we want to be careful about what subroutines 
	# can be called from outside. modify %reports
	# accordingly when a new report type is added
harrison%netscape.com's avatar
output key no longer required, silently defaults to most_doomed.
26a9b7cb
 
harrison%netscape.com committed
81 
	if (! exists $reports{$::FORM{'output'}})
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
		{
		$::FORM{'output'} = "most_doomed"; # a reasonable default
		}
	
	my $f = $reports{$::FORM{'output'}};

	if (! defined $f)
		{
		print "start over, your form data was all messed up.<p>\n";
		foreach (keys %::FORM)
			{
			print "<font color=blue>$_</font> : " . 
				($::FORM{$_} ? $::FORM{$_} : "undef") . "<br>\n";
			}
		exit;
		}

	&{$f};
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
100 101 102 103 104 105 106 107 108 109 110 111 112 113 
	}

print <<FIN;
<p>
</body>
</html>
FIN

##################################
# user came in with no form data #
##################################

sub choose_product
	{
harrison%netscape.com's avatar
added required second argument to make_options call, should keep
65dff73e
 
harrison%netscape.com committed
114 
	my $product_popup = make_options (\@::legal_product, $::legal_product[0]);
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
115 
	my $charts = (-d $dir) ? "<option value=\"show_chart\">Bug Charts" : "";
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 

	print <<FIN;
<center>
<h1>Welcome to the Bugzilla Query Kitchen</h1>
<form method=get action=reports.cgi>
<table border=1 cellpadding=5>
<tr>
<td align=center><b>Product:</b></td>
<td align=center>
<select name="product">
$product_popup
</select>
</td>
</tr>
<tr>
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
131 132 133 134 
<td align=center><b>Output:</b></td>
<td align=center>
<select name="output">
<option value="most_doomed">Bug Counts
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
135 
$charts
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
136 137 
</select>
<tr>
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
138 139 140 141 
<td align=center><b>Switches:</b></td>
<td align=left>
<input type=checkbox name=links value=1>&nbsp;Links to Bugs<br>
<input type=checkbox name=nobanner value=1>&nbsp;No Banner<br>
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
142 
<input type=checkbox name=quip value=1>&nbsp;Include Quip<br>
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 
</td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit value=Continue>
</td>
</tr>
</table>
</form>
<p>
FIN
	}

sub most_doomed
	{
	my $when = localtime (time);

	print <<FIN;
<center>
<h1>
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
163 
Bug Report for $::FORM{'product'}
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 
</h1>
$when<p>
FIN

	my $query = <<FIN;
select 
	bugs.bug_id, bugs.assigned_to, bugs.bug_severity,
	bugs.bug_status, bugs.product, 
	assign.login_name,
	report.login_name,
	unix_timestamp(date_format(bugs.creation_ts, '%Y-%m-%d %h:%m:%s'))

from   bugs,
       profiles assign,
       profiles report,
       versions projector
where  bugs.assigned_to = assign.userid
and    bugs.reporter = report.userid
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
182 
and    bugs.product='$::FORM{'product'}'
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 
and 	 
	( 
	bugs.bug_status = 'NEW' or 
	bugs.bug_status = 'ASSIGNED' or 
	bugs.bug_status = 'REOPENED'
	)
FIN

	print "<font color=purple><tt>$query</tt></font><p>\n" 
		unless (! exists $::FORM{'showsql'});

	SendSQL ($query);
	
	my $c = 0;
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
198 
	my $quip = "Summary";
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 
	my $bugs_count = 0;
	my $bugs_new_this_week = 0;
	my $bugs_reopened = 0;
	my %bugs_owners;
	my %bugs_summary;
	my %bugs_status;
	my %bugs_totals;
	my %bugs_lookup;

	#############################
	# suck contents of database # 
	#############################

	while (my ($bid, $a, $sev, $st, $prod, $who, $rep, $ts) = FetchSQLData())
		{
		next if (exists $bugs_lookup{$bid});
		
		$bugs_lookup{$bid} ++;
		$bugs_owners{$who} ++;
		$bugs_new_this_week ++ if (time - $ts <= $week);
		$bugs_status{$st} ++;
		$bugs_count ++;
		
		push @{$bugs_summary{$who}{$st}}, $bid;
		
		$bugs_totals{$who}{$st} ++;
		}
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
227 228 229 230 231 232 233 234 235 236 237 238 239 240 
	if ($::FORM{'quip'})
		{
		if (open (COMMENTS, "<data/comments")) 
			{
    	my @cdata;
			while (<COMMENTS>) 
				{
				push @cdata, $_;
				}
			close COMMENTS;
			$quip = "<i>" . $cdata[int(rand($#cdata + 1))] . "</i>";
			}
		}
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
241 242 243 244 245 
	#########################
	# start painting report #
	#########################

	print <<FIN;
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
246 
<h1>$quip</h1>
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 
<table border=1 cellpadding=5>
<tr>
<td align=right><b>New Bugs This Week</b></td>
<td align=center>$bugs_new_this_week</td>
</tr>

<tr>
<td align=right><b>Bugs Marked New</b></td>
<td align=center>$bugs_status{'NEW'}</td>
</tr>

<tr>
<td align=right><b>Bugs Marked Assigned</b></td>
<td align=center>$bugs_status{'ASSIGNED'}</td>
</tr>

<tr>
<td align=right><b>Bugs Marked Reopened</b></td>
<td align=center>$bugs_status{'REOPENED'}</td>
</tr>

<tr>
<td align=right><b>Total Bugs</b></td>
<td align=center>$bugs_count</td>
</tr>

</table>
<p>
FIN

	if ($bugs_count == 0)
		{
		print "No bugs found!\n";
		exit;
		}
	
	print <<FIN;
<h1>Bug Count by Engineer</h1>
<table border=3 cellpadding=5>
<tr>
<td align=center bgcolor="#DDDDDD"><b>Owner</b></td>
<td align=center bgcolor="#DDDDDD"><b>New</b></td>
<td align=center bgcolor="#DDDDDD"><b>Assigned</b></td>
<td align=center bgcolor="#DDDDDD"><b>Reopened</b></td>
<td align=center bgcolor="#DDDDDD"><b>Total</b></td>
</tr>
FIN

	foreach my $who (sort keys %bugs_summary)
		{
		my $bugz = 0;
	 	print <<FIN;
<tr>
<td align=left><tt>$who</tt></td>
FIN
		
		foreach my $st (@status)
			{
			$bugs_totals{$who}{$st} += 0;
			print <<FIN;
<td align=center>$bugs_totals{$who}{$st}
FIN
			$bugz += $#{$bugs_summary{$who}{$st}} + 1;
			}
		
		print <<FIN;
<td align=center>$bugz</td>
</tr>
FIN
		}
	
	print <<FIN;
</table>
<p>
FIN

	###############################
	# individual bugs by engineer #
	###############################

	print <<FIN;
<h1>Individual Bugs by Engineer</h1>
<table border=1 cellpadding=5>
<tr>
<td align=center bgcolor="#DDDDDD"><b>Owner</b></td>
<td align=center bgcolor="#DDDDDD"><b>New</b></td>
<td align=center bgcolor="#DDDDDD"><b>Assigned</b></td>
<td align=center bgcolor="#DDDDDD"><b>Reopened</b></td>
</tr>
FIN

	foreach my $who (sort keys %bugs_summary)
		{
		print <<FIN;
<tr>
<td align=left><tt>$who</tt></td>
FIN

		foreach my $st (@status)
			{
			my @l;

			foreach (sort { $a <=> $b } @{$bugs_summary{$who}{$st}})
				{
				if ($::FORM{'links'})
					{
					push @l, "<a href=\"show_bug.cgi?id=$_\">$_</a>\n"; 
					}
				else
					{
					push @l, $_;
					}
				}
				
			my $bugz = join ' ', @l;
			$bugz = "&nbsp;" unless ($bugz);
			
			print <<FIN
<td align=left>$bugz</td>
FIN
			}

		print <<FIN;
</tr>
FIN
		}

	print <<FIN;
</table>
<p>
FIN
	}
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
380 381 382 383 384 385 
sub is_legal_product
	{
	my $product = shift;
	return grep { $_ eq $product} @::legal_product;
	}
harrison%netscape.com's avatar
created reports.cgi which provide an overview of active bugs
2b781265
 
harrison%netscape.com committed
386 387 388 389 390 391 392 393 394 
sub header
	{
	print <<FIN;
<TABLE BGCOLOR="#000000" WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR><TD><A HREF="http://www.mozilla.org/"><IMG
 SRC="http://www.mozilla.org/images/mozilla-banner.gif" ALT=""
 BORDER=0 WIDTH=600 HEIGHT=58></A></TD></TR></TABLE>
FIN
	}
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
395
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
396 397 398 
sub show_chart
	{
  my $when = localtime (time);
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
399
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
400 
	if (! is_legal_product ($::FORM{'product'}))
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
401 
		{
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
402 
		&die_politely ("Unknown product: $::FORM{'product'}");
harrison%netscape.com's avatar
security check for legal products in place. bug charts are not
2ce88631
 
harrison%netscape.com committed
403 404 
		}
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
405 406 407 408 409 410 411 
  print <<FIN;
<center>
FIN
	
	my @dates;
	my @open; my @assigned; my @reopened;
terry%netscape.com's avatar
Patch by Sam Ziegler <ziegler@mediaguaranty.com> -- cope with product
1cf02cc7
 
terry%netscape.com committed
412 413 414 415 416 
        my $prodname = $::FORM{'product'};

        $prodname =~ s/\//-/gs;

        my $file = join '/', $dir, $prodname;
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 
	my $image = "$file.gif";

	if (! open FILE, $file)
		{
		&die_politely ("The tool which gathers bug counts has not been run yet.");
		}
	
	while (<FILE>)
		{
		chomp;
		next if ($_ =~ /^#/ or ! $_);
		my ($date, $open, $assigned, $reopened) = split /\|/, $_;
		my ($yy, $mm, $dd) = $date =~ /^\d{2}(\d{2})(\d{2})(\d{2})$/;

		push @dates, "$mm/$dd/$yy";
		push @open, $open;
		push @assigned, $assigned;
		push @reopened, $reopened;
		}
	
	close FILE;

	if ($#dates < 1)
		{
		&die_politely ("We don't have enough data points to make a graph (yet)");
		}
	
	my $img = Chart::Lines->new (800, 600);
	my @labels = qw (New Assigned Reopened);
	my @when;
	my $i = 0;
	my @data;

	push @data, \@dates;
	push @data, \@open;
	push @data, \@assigned;
	push @data, \@reopened;

	my %settings =
		(
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
457 
		"title" => "Bug Charts for $::FORM{'product'}",
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 
		"x_label" => "Dates",
		"y_label" => "Bug Count",
		"legend_labels" => \@labels,
		);
	
	$img->set (%settings);
	
	open IMAGE, ">$image" or die "$image: $!";
	$img->gif (*IMAGE, \@data);
	close IMAGE;

	print <<FIN;
<img src="$image">
<br clear=left>
<br>
FIN
	}

sub die_politely
	{
	my $msg = shift;

	print <<FIN;
<p>
<table border=1 cellpadding=10>
<tr>
<td align=center>
<font color=blue>Sorry, but ...</font>
<p>
terry%netscape.com's avatar
Backed out Andrew's patch -- turns out it was doing quoting sublty wrong.
89eccc9b
 
terry%netscape.com committed
487 
There is no graph available for <b>$::FORM{'product'}</b><p>
harrison%netscape.com's avatar
patch from Sam Ziegler <ziegler@mediaguaranty.com>, bug
e8798555
 
harrison%netscape.com committed
488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 

<font size=-1>
$msg
<p>
</font>
</td>
</tr>
</table>
<p>
FIN
	
	exit;
	}