#!/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.1 (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 , # Terry Weissman , # Dawn Endico # Bryce Nesbitt , # Added -All- report, change "nobanner" to "banner" (it is strange to have a # list with 2 positive and 1 negative choice), default links on, add show # sql comment. # Joe Robins , # If using the usebuggroups parameter, users shouldn't be able to see # reports for products they don't have access to. use diagnostics; use strict; use GD; eval "use Chart::Lines"; require "CGI.pl"; require "globals.pl"; use vars @::legal_product; my $dir = "data/mining"; my $week = 60 * 60 * 24 * 7; my @status = qw (NEW ASSIGNED REOPENED); my %bugsperperson; # while this looks odd/redundant, it allows us to name # functions differently than the value passed in my %reports = ( "most_doomed" => \&most_doomed, "most_doomed_for_milestone" => \&most_doomed_for_milestone, "most_recently_doomed" => \&most_recently_doomed, "show_chart" => \&show_chart, ); # If we're using bug groups for products, we should apply those restrictions # to viewing reports, as well. Time to check the login in that case. ConnectToDatabase(1); quietly_check_login(); print "Content-type: text/html\n"; #Changing attachment to inline to resolve 46897 #zach@zachlipton.com print "Content-disposition: inline; filename=bugzilla_report.html\n\n"; # If we're here for the first time, give a banner. Else respect the banner flag. if ( (!defined $::FORM{'product'}) || ($::FORM{'banner'}) ) { PutHeader ("Bug Reports") } else { print("Bug Reports"); } GetVersionTable(); # If the usebuggroups parameter is set, we don't want to list all products. # We only want those products that the user has permissions for. my @myproducts; if(Param("usebuggroups")) { push( @myproducts, "-All-"); foreach my $this_product (@::legal_product) { if(GroupExists($this_product) && !UserInGroup($this_product)) { next; } else { push( @myproducts, $this_product ) } } } else { push( @myproducts, "-All-", @::legal_product ); } $::FORM{'output'} = $::FORM{'output'} || "most_doomed"; # a reasonable default if (! defined $::FORM{'product'}) { &choose_product; } else { # If usebuggroups is on, we don't want people to be able to view # reports for products they don't have permissions for... if(Param("usebuggroups") && GroupExists($::FORM{'product'}) && !UserInGroup($::FORM{'product'})) { print "

Permission denied.

\n"; print "Sorry; you do not have the permissions necessary to view\n"; print "reports for this product.\n"; print "

\n"; PutFooter(); exit; } # we want to be careful about what subroutines # can be called from outside. modify %reports # accordingly when a new report type is added if (! exists $reports{$::FORM{'output'}}) { $::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.

\n"; foreach (keys %::FORM) { print "$_ : " . ($::FORM{$_} ? $::FORM{$_} : "undef") . "
\n"; } PutFooter() if $::FORM{banner}; exit; } &{$f}; } print < FIN PutFooter() if $::FORM{banner}; ################################## # user came in with no form data # ################################## sub choose_product { my $product_popup = make_options (\@myproducts, $myproducts[0]); my $charts = defined $Chart::Lines::VERSION && -d $dir ? "

Welcome to the Bugzilla Query Kitchen

Product:
Output:
Switches:  Links to Bugs
 Banner
FIN if (Param('usequip')) { print " Quip
"; } else { print ""; } print <

FIN #Add this above to get a control for showing the SQL query: # Show SQL
PutFooter(); } sub most_doomed { my $when = localtime (time); print <

Bug Report for $::FORM{'product'}

$when

FIN # Build up $query string my $query; $query = <$query

\n" unless (! exists $::FORM{'showsql'}); SendSQL ($query); my $c = 0; my $quip = "Summary"; 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} ++; } if ($::FORM{'quip'}) { if (open (COMMENTS, ") { push @cdata, $_; } close COMMENTS; $quip = "" . $cdata[int(rand($#cdata + 1))] . ""; } } ######################### # start painting report # ######################### $bugs_status{'NEW'} ||= '0'; $bugs_status{'ASSIGNED'} ||= '0'; $bugs_status{'REOPENED'} ||= '0'; print <$quip
New Bugs This Week $bugs_new_this_week
Bugs Marked New $bugs_status{'NEW'}
Bugs Marked Assigned $bugs_status{'ASSIGNED'}
Bugs Marked Reopened $bugs_status{'REOPENED'}
Total Bugs $bugs_count

FIN if ($bugs_count == 0) { print "No bugs found!\n"; PutFooter() if $::FORM{banner}; exit; } print <Bug Count by Engineer FIN foreach my $who (sort keys %bugs_summary) { my $bugz = 0; print < FIN foreach my $st (@status) { $bugs_totals{$who}{$st} += 0; print <$bugs_totals{$who}{$st} FIN $bugz += $#{$bugs_summary{$who}{$st}} + 1; } print <$bugz FIN } print <

FIN ############################### # individual bugs by engineer # ############################### print <Individual Bugs by Engineer

Owner New Assigned Reopened Total
$who
FIN foreach my $who (sort keys %bugs_summary) { print < FIN foreach my $st (@status) { my @l; foreach (sort { $a <=> $b } @{$bugs_summary{$who}{$st}}) { if ($::FORM{'links'}) { push @l, "$_\n"; } else { push @l, $_; } } my $bugz = join ' ', @l; $bugz = " " unless ($bugz); print <$bugz FIN } print < FIN } print <

FIN } sub is_legal_product { my $product = shift; return grep { $_ eq $product} @myproducts; } sub show_chart { my $when = localtime (time); if (! is_legal_product ($::FORM{'product'})) { &die_politely ("Unknown product: $::FORM{'product'}"); } print < FIN my @dates; my @open; my @assigned; my @reopened; my @resolved; my @verified; my @closed; my $prodname = $::FORM{'product'}; $prodname =~ s/\//-/gs; my $testimg = Chart::Lines->new(2,2); my $x = '$testimg->gif()'; eval $x; my $type = ($@ =~ /Can't locate object method/) ? "png" : "gif"; my $file = join '/', $dir, $prodname; my $image = "$file.$type"; my $url_image = $dir . "/" . url_quote($prodname) . ".$type"; if (! open FILE, $file) { &die_politely ("The tool which gathers bug counts has not been run yet."); } while () { chomp; next if ($_ =~ /^#/ or ! $_); my ($date, $open, $assigned, $reopened, $resolved, $verified, $closed) = 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; push @resolved, $resolved; push @verified, $verified; push @closed, $closed; } 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 Resolved Verified Closed); my @when; my $i = 0; my @data; push @data, \@dates; push @data, \@open; push @data, \@assigned; push @data, \@reopened; push @data, \@resolved; push @data, \@verified; push @data, \@closed; my $MAXTICKS = 20; # Try not to show any more x ticks than this. my $skip = 1; if (@dates > $MAXTICKS) { $skip = int((@dates + $MAXTICKS - 1) / $MAXTICKS); } my %settings = ( "title" => "Status Counts for $::FORM{'product'}", "x_label" => "Dates", "y_label" => "Bug Counts", "legend_labels" => \@labels, "skip_x_ticks" => $skip, "y_grid_lines" => "true", "grey_background" => "false" ); $img->set (%settings); open IMAGE, ">$image" or die "$image: $!"; $img->$type (*IMAGE, \@data); close IMAGE; print <

FIN } sub die_politely { my $msg = shift; print <

Owner New Assigned Reopened
$who
Sorry, but ...

There is no graph available for $::FORM{'product'}

$msg

FIN PutFooter() if $::FORM{banner}; exit; } sub bybugs { $bugsperperson{$a} <=> $bugsperperson{$b} } sub most_doomed_for_milestone { my $when = localtime (time); my $ms = "M" . Param("curmilestone"); my $quip = "Summary"; print "

\n

"; if( $::FORM{'product'} ne "-All-" ) { print "Most Doomed for $ms ($::FORM{'product'})"; } else { print "Most Doomed for $ms"; } print "

\n$when

\n"; ######################### # start painting report # ######################### if ($::FORM{'quip'}) { if (open (COMMENTS, ") { push @cdata, $_; } close COMMENTS; $quip = "" . $cdata[int(rand($#cdata + 1))] . ""; } } # Build up $query string my $query; $query = "select distinct assigned_to from bugs where target_milestone=\"$ms\""; if( $::FORM{'product'} ne "-All-" ) { $query .= "and bugs.product=".SqlQuote($::FORM{'product'}); } $query .= <\n"; print "\n"; print "$totalpeople engineers have $bugtotal $ms bugs and features.\n"; print "\n"; while (@people) { $person = pop @people; print "\n"; SendSQL("select login_name from profiles where userid=$person"); my $login_name= FetchSQLData(); print("\n"); print("$bugsperperson{$person} bugs and features"); print(""); print(" for \n"); print(""); print("$login_name"); print("\n"); print("\n"); $person = pop @people; if ($person) { SendSQL("select login_name from profiles where userid=$person"); my $login_name= FetchSQLData(); print("\n"); print("$bugsperperson{$person} bugs and features"); print(""); print(" for \n"); print(""); print("$login_name"); print("\n"); print("\n\n"); } } print "\n"; } sub most_recently_doomed { my $when = localtime (time); my $ms = "M" . Param("curmilestone"); my $quip = "Summary"; print "

\n

"; if( $::FORM{'product'} ne "-All-" ) { print "Most Recently Doomed ($::FORM{'product'})"; } else { print "Most Recently Doomed"; } print "

\n$when

\n"; ######################### # start painting report # ######################### if ($::FORM{'quip'}) { if (open (COMMENTS, ") { push @cdata, $_; } close COMMENTS; $quip = "" . $cdata[int(rand($#cdata + 1))] . ""; } } # Build up $query string my $query; $query = "select distinct assigned_to from bugs where bugs.bug_status='NEW' and target_milestone='' and bug_severity!='enhancement' and status_whiteboard='' and (product='Browser' or product='MailNews')"; if( $::FORM{'product'} ne "-All-" ) { $query .= "and bugs.product=".SqlQuote($::FORM{'product'}); } # End build up $query string SendSQL ($query); my @people = (); while (my ($person) = FetchSQLData()) { push @people, $person; } ############################# # suck contents of database # ############################# my $person = ""; my $bugtotal = 0; foreach $person (@people) { my $query = "select count(bug_id) from bugs,profiles where bugs.bug_status='NEW' and userid=assigned_to and userid='$person' and target_milestone='' and bug_severity!='enhancement' and status_whiteboard='' and (product='Browser' or product='MailNews')"; if( $::FORM{'product'} ne "-All-" ) { $query .= "and bugs.product='$::FORM{'product'}'"; } SendSQL ($query); my $bugcount = FetchSQLData(); $bugsperperson{$person} = $bugcount; $bugtotal += $bugcount; } # sort people by the number of bugs they have assigned to this milestone @people = sort bybugs @people; my $totalpeople = @people; if ($totalpeople > 20) { splice @people, 0, $totalpeople-20; } print "\n"; print "\n"; while (@people) { $person = pop @people; print "\n\n"); } } print "
\n"; print "$totalpeople engineers have $bugtotal untouched new bugs.\n"; if ($totalpeople > 20) { print "These are the 20 most doomed."; } print "
\n"; SendSQL("select login_name from profiles where userid=$person"); my $login_name= FetchSQLData(); print("\n"); print("$bugsperperson{$person} bugs"); print(""); print(" for \n"); print(""); print("$login_name"); print("\n"); print("\n"); $person = pop @people; if ($person) { SendSQL("select login_name from profiles where userid=$person"); my $login_name= FetchSQLData(); print("\n"); print("$bugsperperson{$person} bugs"); print(""); print(" for \n"); print(""); print("$login_name"); print("\n"); print("
\n"; }