BugMail.pm 26.1 KB
Newer Older
1
# -*- Mode: perl; indent-tabs-mode: nil -*-
terry%netscape.com's avatar
terry%netscape.com committed
2
#
3 4 5 6 7 8 9 10 11 12
# 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.
#
terry%netscape.com's avatar
terry%netscape.com committed
13
# The Original Code is the Bugzilla Bug Tracking System.
14
#
terry%netscape.com's avatar
terry%netscape.com committed
15
# The Initial Developer of the Original Code is Netscape Communications
16 17 18 19
# Corporation. Portions created by Netscape are
# Copyright (C) 1998 Netscape Communications Corporation. All
# Rights Reserved.
#
20
# Contributor(s): Terry Weissman <terry@mozilla.org>,
21 22
#                 Bryce Nesbitt <bryce-mozilla@nextbus.com>
#                 Dan Mosedale <dmose@mozilla.org>
23
#                 Alan Raetz <al_raetz@yahoo.com>
24
#                 Jacob Steenhagen <jake@actex.net>
25
#                 Matthew Tuck <matty@chariot.net.au>
26 27
#                 Bradley Baetz <bbaetz@student.usyd.edu.au>
#                 J. Paul Reed <preed@sigkill.com>
28
#                 Gervase Markham <gerv@gerv.net>
29
#                 Byron Jones <bugzilla@glob.com.au>
30

31
use strict;
terry%netscape.com's avatar
terry%netscape.com committed
32

33
package Bugzilla::BugMail;
terry%netscape.com's avatar
terry%netscape.com committed
34

35
use Bugzilla::Error;
36
use Bugzilla::User;
37
use Bugzilla::Constants;
38
use Bugzilla::Util;
39
use Bugzilla::Bug;
40
use Bugzilla::Classification;
41
use Bugzilla::Product;
42
use Bugzilla::Component;
43
use Bugzilla::Status;
44
use Bugzilla::Mailer;
45

46 47
use Date::Parse;
use Date::Format;
48

49 50 51 52 53
use constant FORMAT_TRIPLE => "%19s|%-28s|%-28s";
use constant FORMAT_3_SIZE => [19,28,28];
use constant FORMAT_DOUBLE => "%19s %-55s";
use constant FORMAT_2_SIZE => [19,55];

54 55 56
use constant BIT_DIRECT    => 1;
use constant BIT_WATCHING  => 2;

57 58
# We need these strings for the X-Bugzilla-Reasons header
# Note: this hash uses "," rather than "=>" to avoid auto-quoting of the LHS.
59
use constant REL_NAMES => {
60 61 62 63 64 65
    REL_ASSIGNEE      , "AssignedTo", 
    REL_REPORTER      , "Reporter",
    REL_QA            , "QAcontact",
    REL_CC            , "CC",
    REL_VOTER         , "Voter",
    REL_GLOBAL_WATCHER, "GlobalWatcher"
66 67
};

68 69 70 71 72 73
# We use this instead of format because format doesn't deal well with
# multi-byte languages.
sub multiline_sprintf {
    my ($format, $args, $sizes) = @_;
    my @parts;
    my @my_sizes = @$sizes; # Copy this so we don't modify the input array.
74
    foreach my $string (@$args) {
75 76 77 78 79 80 81 82 83 84 85 86 87 88
        my $size = shift @my_sizes;
        my @pieces = split("\n", wrap_hard($string, $size));
        push(@parts, \@pieces);
    }

    my $formatted;
    while (1) {
        # Get the first item of each part.
        my @line = map { shift @$_ } @parts;
        # If they're all undef, we're done.
        last if !grep { defined $_ } @line;
        # Make any single undef item into ''
        @line = map { defined $_ ? $_ : '' } @line;
        # And append a formatted line
89 90 91 92 93
        $formatted .= sprintf($format, @line);
        # Remove trailing spaces, or they become lots of =20's in 
        # quoted-printable emails.
        $formatted =~ s/\s+$//;
        $formatted .= "\n";
94 95
    }
    return $formatted;
96
}
97 98 99

sub three_columns {
    return multiline_sprintf(FORMAT_TRIPLE, \@_, FORMAT_3_SIZE);
100 101
}

102 103 104 105 106 107 108 109 110
# This is a bit of a hack, basically keeping the old system()
# cmd line interface. Should clean this up at some point.
#
# args: bug_id, and an optional hash ref which may have keys for:
# changer, owner, qa, reporter, cc
# Optional hash contains values of people which will be forced to those
# roles when the email is sent.
# All the names are email addresses, not userids
# values are scalars, except for cc, which is a list
111
# This hash usually comes from the "mailrecipients" var in a template call.
112
sub Send {
113
    my ($id, $forced) = (@_);
114 115 116 117 118 119 120

    my @headerlist;
    my %defmailhead;
    my %fielddescription;

    my $msg = "";

121
    my $dbh = Bugzilla->dbh;
122

123 124 125 126 127 128 129
    # XXX - These variables below are useless. We could use field object
    # methods directly. But we first have to implement a cache in
    # Bugzilla->get_fields to avoid querying the DB all the time.
    foreach my $field (Bugzilla->get_fields({obsolete => 0})) {
        push(@headerlist, $field->name);
        $defmailhead{$field->name} = $field->in_new_bugmail;
        $fielddescription{$field->name} = $field->description;
130
    }
131 132

    my %values = %{$dbh->selectrow_hashref(
133
        'SELECT ' . join(',', editable_bug_fields()) . ', reporter,
134
                lastdiffed AS start_time, LOCALTIMESTAMP(0) AS end_time
135 136
           FROM bugs WHERE bug_id = ?',
        undef, $id)};
137 138 139

    my $product = new Bugzilla::Product($values{product_id});
    $values{product} = $product->name;
140 141 142
    if (Bugzilla->params->{'useclassification'}) {
        $values{classification} = Bugzilla::Classification->new($product->classification_id)->name;
    }
143 144
    my $component = new Bugzilla::Component($values{component_id});
    $values{component} = $component->name;
145

146
    my ($start, $end) = ($values{start_time}, $values{end_time});
147

148 149 150 151 152
    # User IDs of people in various roles. More than one person can 'have' a 
    # role, if the person in that role has changed, or people are watching.
    my $reporter = $values{'reporter'};
    my @assignees = ($values{'assigned_to'});
    my @qa_contacts = ($values{'qa_contact'});
153 154 155 156 157 158 159 160 161 162 163 164 165 166 167

    my $cc_users = $dbh->selectall_arrayref(
           "SELECT cc.who, profiles.login_name
              FROM cc
        INNER JOIN profiles
                ON cc.who = profiles.userid
             WHERE bug_id = ?",
           undef, $id);

    my (@ccs, @cc_login_names);
    foreach my $cc_user (@$cc_users) {
        my ($user_id, $user_login) = @$cc_user;
        push (@ccs, $user_id);
        push (@cc_login_names, $user_login);
    }
168 169 170 171 172 173

    # Include the people passed in as being in particular roles.
    # This can include people who used to hold those roles.
    # At this point, we don't care if there are duplicates in these arrays.
    my $changer = $forced->{'changer'};
    if ($forced->{'owner'}) {
174
        push (@assignees, login_to_id($forced->{'owner'}, THROW_ERROR));
175
    }
176
    
177
    if ($forced->{'qacontact'}) {
178
        push (@qa_contacts, login_to_id($forced->{'qacontact'}, THROW_ERROR));
179
    }
180 181 182
    
    if ($forced->{'cc'}) {
        foreach my $cc (@{$forced->{'cc'}}) {
183
            push(@ccs, login_to_id($cc, THROW_ERROR));
184 185 186 187
        }
    }
    
    # Convert to names, for later display
188
    $values{'changer'} = $changer;
189 190 191 192
    # If no changer is specified, then it has no name.
    if ($changer) {
        $values{'changername'} = Bugzilla::User->new({name => $changer})->name;
    }
193 194
    $values{'assigned_to'} = user_id_to_login($values{'assigned_to'});
    $values{'reporter'} = user_id_to_login($values{'reporter'});
195
    if ($values{'qa_contact'}) {
196
        $values{'qa_contact'} = user_id_to_login($values{'qa_contact'});
197
    }
198
    $values{'cc'} = join(', ', @cc_login_names);
199
    $values{'estimated_time'} = format_time_decimal($values{'estimated_time'});
200

201 202 203
    if ($values{'deadline'}) {
        $values{'deadline'} = time2str("%Y-%m-%d", str2time($values{'deadline'}));
    }
204

205 206 207 208
    my $dependslist = $dbh->selectcol_arrayref(
        'SELECT dependson FROM dependencies
         WHERE blocked = ? ORDER BY dependson',
        undef, ($id));
209

210 211 212 213 214 215
    $values{'dependson'} = join(",", @$dependslist);

    my $blockedlist = $dbh->selectcol_arrayref(
        'SELECT blocked FROM dependencies
         WHERE dependson = ? ORDER BY blocked',
        undef, ($id));
216

217 218
    $values{'blocked'} = join(",", @$blockedlist);

219 220 221 222 223 224 225 226 227
    my $grouplist = $dbh->selectcol_arrayref(
        '    SELECT name FROM groups
         INNER JOIN bug_group_map
                 ON groups.id = bug_group_map.group_id
                    AND bug_group_map.bug_id = ?',
        undef, ($id));

    $values{'bug_group'} = join(', ', @$grouplist);
 
228
    my @args = ($id);
229

230
    # If lastdiffed is NULL, then we don't limit the search on time.
231 232 233 234
    my $when_restriction = '';
    if ($start) {
        $when_restriction = ' AND bug_when > ? AND bug_when <= ?';
        push @args, ($start, $end);
235
    }
236 237
    
    my $diffs = $dbh->selectall_arrayref(
238
           "SELECT profiles.login_name, profiles.realname, fielddefs.description,
239 240 241 242
                   bugs_activity.bug_when, bugs_activity.removed, 
                   bugs_activity.added, bugs_activity.attach_id, fielddefs.name
              FROM bugs_activity
        INNER JOIN fielddefs
243
                ON fielddefs.id = bugs_activity.fieldid
244 245 246 247 248
        INNER JOIN profiles
                ON profiles.userid = bugs_activity.who
             WHERE bugs_activity.bug_id = ?
                   $when_restriction
          ORDER BY bugs_activity.bug_when", undef, @args);
249

250
    my @new_depbugs;
251
    my $difftext = "";
252 253
    my $diffheader = "";
    my @diffparts;
254
    my $lastwho = "";
255
    my $fullwho;
256
    my @changedfields;
257
    foreach my $ref (@$diffs) {
258
        my ($who, $whoname, $what, $when, $old, $new, $attachid, $fieldname) = (@$ref);
259
        my $diffpart = {};
260 261
        if ($who ne $lastwho) {
            $lastwho = $who;
262
            $fullwho = $whoname ? "$whoname <$who>" : $who;
263
            $diffheader = "\n$fullwho changed:\n\n";
264
            $diffheader .= three_columns("What    ", "Removed", "Added");
265
            $diffheader .= ('-' x 76) . "\n";
266
        }
267
        $what =~ s/^(Attachment )?/Attachment #$attachid / if $attachid;
268 269
        if( $fieldname eq 'estimated_time' ||
            $fieldname eq 'remaining_time' ) {
270 271
            $old = format_time_decimal($old);
            $new = format_time_decimal($new);
272
        }
273 274 275
        if ($fieldname eq 'dependson') {
            push(@new_depbugs, grep {$_ =~ /^\d+$/} split(/[\s,]+/, $new));
        }
276
        if ($attachid) {
277 278 279
            ($diffpart->{'isprivate'}) = $dbh->selectrow_array(
                'SELECT isprivate FROM attachments WHERE attach_id = ?',
                undef, ($attachid));
280
        }
281
        $difftext = three_columns($what, $old, $new);
282 283 284 285
        $diffpart->{'header'} = $diffheader;
        $diffpart->{'fieldname'} = $fieldname;
        $diffpart->{'text'} = $difftext;
        push(@diffparts, $diffpart);
286
        push(@changedfields, $what);
287
    }
288
    $values{'changed_fields'} = join(' ', @changedfields);
289

290
    my @depbugs;
291
    my $deptext = "";
292 293 294 295 296 297 298 299 300
    # Do not include data about dependent bugs when they have just been added.
    # Completely skip checking for dependent bugs on bug creation as all
    # dependencies bugs will just have been added.
    if ($start) {
        my $dep_restriction = "";
        if (scalar @new_depbugs) {
            $dep_restriction = "AND bugs_activity.bug_id NOT IN (" .
                               join(", ", @new_depbugs) . ")";
        }
301

302
        my $dependency_diffs = $dbh->selectall_arrayref(
303 304 305 306 307 308 309 310
           "SELECT bugs_activity.bug_id, bugs.short_desc, fielddefs.name, 
                   bugs_activity.removed, bugs_activity.added
              FROM bugs_activity
        INNER JOIN bugs
                ON bugs.bug_id = bugs_activity.bug_id
        INNER JOIN dependencies
                ON bugs_activity.bug_id = dependencies.dependson
        INNER JOIN fielddefs
311
                ON fielddefs.id = bugs_activity.fieldid
312 313 314 315
             WHERE dependencies.blocked = ?
               AND (fielddefs.name = 'bug_status'
                    OR fielddefs.name = 'resolution')
                   $when_restriction
316
                   $dep_restriction
317 318
          ORDER BY bugs_activity.bug_when, bugs.bug_id", undef, @args);

319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334
        my $thisdiff = "";
        my $lastbug = "";
        my $interestingchange = 0;
        foreach my $dependency_diff (@$dependency_diffs) {
            my ($depbug, $summary, $what, $old, $new) = @$dependency_diff;

            if ($depbug ne $lastbug) {
                if ($interestingchange) {
                    $deptext .= $thisdiff;
                }
                $lastbug = $depbug;
                my $urlbase = Bugzilla->params->{"urlbase"};
                $thisdiff =
                  "\nBug $id depends on bug $depbug, which changed state.\n\n" .
                  "Bug $depbug Summary: $summary\n" .
                  "${urlbase}show_bug.cgi?id=$depbug\n\n";
335
                $thisdiff .= three_columns("What    ", "Old Value", "New Value");
336 337
                $thisdiff .= ('-' x 76) . "\n";
                $interestingchange = 0;
338
            }
339
            $thisdiff .= three_columns($fielddescription{$what}, $old, $new);
340
            if ($what eq 'bug_status'
341
                && is_open_state($old) ne is_open_state($new))
342 343 344 345
            {
                $interestingchange = 1;
            }
            push(@depbugs, $depbug);
346 347
        }

348 349 350 351
        if ($interestingchange) {
            $deptext .= $thisdiff;
        }
        $deptext = trim($deptext);
352

353 354 355 356 357
        if ($deptext) {
            my $diffpart = {};
            $diffpart->{'text'} = "\n" . trim("\n\n" . $deptext);
            push(@diffparts, $diffpart);
        }
358 359
    }

360
    my ($raw_comments, $anyprivate, $count) = get_comments_by_bug($id, $start, $end);
361

362
    ###########################################################################
363
    # Start of email filtering code
364
    ###########################################################################
365
    
366 367
    # A user_id => roles hash to keep track of people.
    my %recipients;
368
    my %watching;
369 370 371 372 373 374
    
    # Now we work out all the people involved with this bug, and note all of
    # the relationships in a hash. The keys are userids, the values are an
    # array of role constants.
    
    # Voters
375 376
    my $voters = $dbh->selectcol_arrayref(
        "SELECT who FROM votes WHERE bug_id = ?", undef, ($id));
377
        
378
    $recipients{$_}->{+REL_VOTER} = BIT_DIRECT foreach (@$voters);
379

380
    # CCs
381
    $recipients{$_}->{+REL_CC} = BIT_DIRECT foreach (@ccs);
382 383
    
    # Reporter (there's only ever one)
384
    $recipients{$reporter}->{+REL_REPORTER} = BIT_DIRECT;
385 386
    
    # QA Contact
387
    if (Bugzilla->params->{'useqacontact'}) {
388 389
        foreach (@qa_contacts) {
            # QA Contact can be blank; ignore it if so.
390
            $recipients{$_}->{+REL_QA} = BIT_DIRECT if $_;
391
        }
392
    }
393

394
    # Assignee
395
    $recipients{$_}->{+REL_ASSIGNEE} = BIT_DIRECT foreach (@assignees);
396

397 398
    # The last relevant set of people are those who are being removed from 
    # their roles in this change. We get their names out of the diffs.
399
    foreach my $ref (@$diffs) {
400
        my ($who, $whoname, $what, $when, $old, $new) = (@$ref);
401 402 403
        if ($old) {
            # You can't stop being the reporter, and mail isn't sent if you
            # remove your vote.
404
            # Ignore people whose user account has been deleted or renamed.
405
            if ($what eq "CC") {
406
                foreach my $cc_user (split(/[\s,]+/, $old)) {
407
                    my $uid = login_to_id($cc_user);
408
                    $recipients{$uid}->{+REL_CC} = BIT_DIRECT if $uid;
409
                }
410 411
            }
            elsif ($what eq "QAContact") {
412
                my $uid = login_to_id($old);
413
                $recipients{$uid}->{+REL_QA} = BIT_DIRECT if $uid;
414 415
            }
            elsif ($what eq "AssignedTo") {
416
                my $uid = login_to_id($old);
417
                $recipients{$uid}->{+REL_ASSIGNEE} = BIT_DIRECT if $uid;
418
            }
419
        }
420 421
    }
    
422 423 424 425 426 427 428 429 430 431 432 433 434
    # Find all those user-watching anyone on the current list, who is not
    # on it already themselves.
    my $involved = join(",", keys %recipients);

    my $userwatchers =
        $dbh->selectall_arrayref("SELECT watcher, watched FROM watch
                                  WHERE watched IN ($involved)");

    # Mark these people as having the role of the person they are watching
    foreach my $watch (@$userwatchers) {
        while (my ($role, $bits) = each %{$recipients{$watch->[1]}}) {
            $recipients{$watch->[0]}->{$role} |= BIT_WATCHING
                if $bits & BIT_DIRECT;
435
        }
436
        push(@{$watching{$watch->[0]}}, $watch->[1]);
437
    }
438 439 440 441 442 443 444 445 446

    # Global watcher
    my @watchers = split(/[,\s]+/, Bugzilla->params->{'globalwatchers'});
    foreach (@watchers) {
        my $watcher_id = login_to_id($_);
        next unless $watcher_id;
        $recipients{$watcher_id}->{+REL_GLOBAL_WATCHER} = BIT_DIRECT;
    }

447 448 449 450 451
    # We now have a complete set of all the users, and their relationships to
    # the bug in question. However, we are not necessarily going to mail them
    # all - there are preferences, permissions checks and all sorts to do yet.
    my @sent;
    my @excluded;
452

453 454 455
    # Some comments are language specific. We cache them here.
    my %comments;

456
    foreach my $user_id (keys %recipients) {
457
        my %rels_which_want;
458
        my $sent_mail = 0;
459

460
        my $user = new Bugzilla::User($user_id);
461 462 463
        # Deleted users must be excluded.
        next unless $user;

464 465 466 467 468 469 470 471 472 473 474
        # What's the language chosen by this user for email?
        my $lang = $user->settings->{'lang'}->{'value'};

        if ($user->can_see_bug($id)) {
            # It's time to format language specific comments.
            unless (exists $comments{$lang}) {
                Bugzilla->template_inner($lang);
                $comments{$lang} = prepare_comments($raw_comments, $count);
                Bugzilla->template_inner("");
            }

475 476
            # Go through each role the user has and see if they want mail in
            # that role.
477
            foreach my $relationship (keys %{$recipients{$user_id}}) {
478 479
                if ($user->wants_bug_mail($id,
                                          $relationship, 
480
                                          $diffs, 
481
                                          $comments{$lang},
482
                                          $deptext,
483 484
                                          $changer,
                                          !$start))
485
                {
486 487
                    $rels_which_want{$relationship} = 
                        $recipients{$user_id}->{$relationship};
488 489
                }
            }
490
        }
491
        
492
        if (scalar(%rels_which_want)) {
493 494 495 496 497 498
            # So the user exists, can see the bug, and wants mail in at least
            # one role. But do we want to send it to them?

            # If we are using insiders, and the comment is private, only send 
            # to insiders
            my $insider_ok = 1;
499
            $insider_ok = 0 if $anyprivate && !$user->is_insider;
500 501 502 503 504 505 506 507 508 509 510 511 512 513 514

            # We shouldn't send mail if this is a dependency mail (i.e. there 
            # is something in @depbugs), and any of the depending bugs are not 
            # visible to the user. This is to avoid leaking the summaries of 
            # confidential bugs.
            my $dep_ok = 1;
            foreach my $dep_id (@depbugs) {
                if (!$user->can_see_bug($dep_id)) {
                   $dep_ok = 0;
                   last;
                }
            }

            # Make sure the user isn't in the nomail list, and the insider and 
            # dep checks passed.
515
            if ($user->email_enabled &&
516 517 518 519 520 521
                $insider_ok &&
                $dep_ok)
            {
                # OK, OK, if we must. Email the user.
                $sent_mail = sendMail($user, 
                                      \@headerlist,
522
                                      \%rels_which_want, 
523 524 525 526
                                      \%values,
                                      \%defmailhead, 
                                      \%fielddescription, 
                                      \@diffparts,
527
                                      $comments{$lang},
528
                                      $anyprivate, 
529
                                      ! $start, 
530 531 532
                                      $id,
                                      exists $watching{$user_id} ?
                                             $watching{$user_id} : undef);
533
            }
534
        }
535 536 537 538 539 540 541 542
       
        if ($sent_mail) {
            push(@sent, $user->login); 
        } 
        else {
            push(@excluded, $user->login); 
        } 
    }
543
    
544 545
    $dbh->do('UPDATE bugs SET lastdiffed = ? WHERE bug_id = ?',
             undef, ($end, $id));
546

547
    return {'sent' => \@sent, 'excluded' => \@excluded};
548 549
}

550
sub sendMail {
551 552
    my ($user, $hlRef, $relRef, $valueRef, $dmhRef, $fdRef,
        $diffRef, $newcomments, $anyprivate, $isnew,
553
        $id, $watchingRef) = @_;
554

555 556
    my %values = %$valueRef;
    my @headerlist = @$hlRef;
557
    my %mailhead = %$dmhRef;
558
    my %fielddescription = %$fdRef;
559
    my @diffparts = @$diffRef;    
560
    
561 562 563 564
    # Build difftext (the actions) by verifying the user should see them
    my $difftext = "";
    my $diffheader = "";
    my $add_diff;
565

566 567 568
    foreach my $diff (@diffparts) {
        $add_diff = 0;
        
569
        if (exists($diff->{'fieldname'}) && 
570 571
            ($diff->{'fieldname'} eq 'estimated_time' ||
             $diff->{'fieldname'} eq 'remaining_time' ||
572
             $diff->{'fieldname'} eq 'work_time' ||
573 574 575 576 577 578
             $diff->{'fieldname'} eq 'deadline'))
        {
            $add_diff = 1 if $user->is_timetracker;
        } elsif ($diff->{'isprivate'} 
                 && !$user->is_insider)
        {
579
            $add_diff = 0;
580 581 582
        } else {
            $add_diff = 1;
        }
583

584
        if ($add_diff) {
585 586
            if (exists($diff->{'header'}) && 
             ($diffheader ne $diff->{'header'})) {
587 588 589 590 591 592
                $diffheader = $diff->{'header'};
                $difftext .= $diffheader;
            }
            $difftext .= $diff->{'text'};
        }
    }
593
 
594
    if ($difftext eq "" && $newcomments eq "" && !$isnew) {
595
      # Whoops, no differences!
596
      return 0;
597 598
    }
    
599 600 601 602 603 604
    # If an attachment was created, then add an URL. (Note: the 'g'lobal
    # replace should work with comments with multiple attachments.)

    if ( $newcomments =~ /Created an attachment \(/ ) {

        my $showattachurlbase =
605
            Bugzilla->params->{'urlbase'} . "attachment.cgi?id=";
606

607
        $newcomments =~ s/(Created an attachment \(id=([0-9]+)\))/$1\n --> \(${showattachurlbase}$2\)/g;
608 609
    }

610
    my $diffs = $difftext . "\n\n" . $newcomments;
611
    if ($isnew) {
612 613 614 615 616 617 618 619 620 621 622 623 624
        my $head = "";
        foreach my $f (@headerlist) {
            next unless $mailhead{$f};
            my $value = $values{$f};
            # If there isn't anything to show, don't include this header.
            next unless $value;
            # Only send estimated_time if it is enabled and the user is in the group.
            if (($f ne 'estimated_time' && $f ne 'deadline') || $user->is_timetracker) {
                my $desc = $fielddescription{$f};
                $head .= multiline_sprintf(FORMAT_DOUBLE, ["$desc:", $value],
                                           FORMAT_2_SIZE);
            }
        }
625
        $diffs = $head . ($difftext ? "\n\n" : "") . $diffs;
626
    }
627

628 629 630 631
    my (@reasons, @reasons_watch);
    while (my ($relationship, $bits) = each %{$relRef}) {
        push(@reasons, $relationship) if ($bits & BIT_DIRECT);
        push(@reasons_watch, $relationship) if ($bits & BIT_WATCHING);
632
    }
633 634 635 636 637

    my @headerrel   = map { REL_NAMES->{$_} } @reasons;
    my @watchingrel = map { REL_NAMES->{$_} } @reasons_watch;
    push(@headerrel,   'None') unless @headerrel;
    push(@watchingrel, 'None') unless @watchingrel;
638
    push @watchingrel, map { user_id_to_login($_) } @$watchingRef;
639

640
    my $vars = {
641
        isnew => $isnew,
642 643
        to => $user->email,
        bugid => $id,
644 645
        alias => Bugzilla->params->{'usebugaliases'} ? $values{'alias'} : "",
        classification => $values{'classification'},
646 647 648 649 650 651 652
        product => $values{'product'},
        comp => $values{'component'},
        keywords => $values{'keywords'},
        severity => $values{'bug_severity'},
        status => $values{'bug_status'},
        priority => $values{'priority'},
        assignedto => $values{'assigned_to'},
653
        assignedtoname => Bugzilla::User->new({name => $values{'assigned_to'}})->name,
654 655 656
        targetmilestone => $values{'target_milestone'},
        changedfields => $values{'changed_fields'},
        summary => $values{'short_desc'},
657 658
        reasons => \@reasons,
        reasons_watch => \@reasons_watch,
659 660 661 662
        reasonsheader => join(" ", @headerrel),
        reasonswatchheader => join(" ", @watchingrel),
        changer => $values{'changer'},
        changername => $values{'changername'},
663 664
        reporter => $values{'reporter'},
        reportername => Bugzilla::User->new({name => $values{'reporter'}})->name,
665
        diffs => $diffs,
666
        threadingmarker => build_thread_marker($id, $user->id, $isnew),
667 668 669
    };

    my $msg;
670
    my $template = Bugzilla->template_inner($user->settings->{'lang'}->{'value'});
671 672
    $template->process("email/newchangedmail.txt.tmpl", $vars, \$msg)
      || ThrowTemplateError($template->error());
673
    Bugzilla->template_inner("");
674

675 676 677 678 679
    MessageToMTA($msg);

    return 1;
}

680
# Get bug comments for the given period.
681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697
sub get_comments_by_bug {
    my ($id, $start, $end) = @_;
    my $dbh = Bugzilla->dbh;

    my $result = "";
    my $count = 0;
    my $anyprivate = 0;

    # $start will be undef for new bugs, and defined for pre-existing bugs.
    if ($start) {
        # If $start is not NULL, obtain the count-index
        # of this comment for the leading "Comment #xxx" line.
        $count = $dbh->selectrow_array('SELECT COUNT(*) FROM longdescs
                                        WHERE bug_id = ? AND bug_when <= ?',
                                        undef, ($id, $start));
    }

698 699 700 701 702 703 704 705 706 707 708 709 710
    my $raw = 1; # Do not format comments which are not of type CMT_NORMAL.
    my $comments = Bugzilla::Bug::GetComments($id, "oldest_to_newest", $start, $end, $raw);

    if (Bugzilla->params->{'insidergroup'}) {
        $anyprivate = 1 if scalar(grep {$_->{'isprivate'} > 0} @$comments);
    }

    return ($comments, $anyprivate, $count);
}

# Prepare comments for the given language.
sub prepare_comments {
    my ($raw_comments, $count) = @_;
711

712 713
    my $result = "";
    foreach my $comment (@$raw_comments) {
714
        if ($count) {
715 716
            $result .= "\n\n--- Comment #$count from " . $comment->{'author'}->identity .
                       "  " . format_time($comment->{'time'}) . " ---\n";
717
        }
718 719 720 721 722
        # Format language specific comments. We don't update $comment->{'body'}
        # directly, otherwise it would grow everytime you call format_comment()
        # with a different language as some text may be appended to the existing one.
        my $body = Bugzilla::Bug::format_comment($comment);
        $result .= ($comment->{'already_wrapped'} ? $body : wrap_comment($body));
723 724
        $count++;
    }
725
    return $result;
726 727
}

728
1;