From 18366bfc65096883510d8b14449a763c804a2250 Mon Sep 17 00:00:00 2001
From: Byron Jones <bjones@mozilla.com>
Date: Thu, 9 May 2013 14:42:47 +0800
Subject: Bug 863686: "Congratulations" email received for first approval+
 instead of first review+ (part two)

---
 extensions/ContributorEngagement/Extension.pm | 88 +++++++--------------------
 1 file changed, 23 insertions(+), 65 deletions(-)

(limited to 'extensions/ContributorEngagement/Extension.pm')

diff --git a/extensions/ContributorEngagement/Extension.pm b/extensions/ContributorEngagement/Extension.pm
index 13956c3e8..e41635e69 100644
--- a/extensions/ContributorEngagement/Extension.pm
+++ b/extensions/ContributorEngagement/Extension.pm
@@ -19,22 +19,20 @@ use Bugzilla::Install::Util qw(indicate_progress);
 
 use Bugzilla::Extension::ContributorEngagement::Constants;
 
-our $VERSION = '1.0';
+our $VERSION = '2.0';
 
 BEGIN {
-    *Bugzilla::User::first_patch_approved_id = \&_first_patch_approved_id;
+    *Bugzilla::User::first_patch_reviewed_id = \&_first_patch_reviewed_id;
 }
 
-sub _first_patch_approved_id { return $_[0]->{'first_patch_approved_id'}; }
+sub _first_patch_reviewed_id { return $_[0]->{'first_patch_reviewed_id'}; }
 
 sub install_update_db {
     my ($self) = @_;
     my $dbh = Bugzilla->dbh;
 
-    if (!$dbh->bz_column_info('profiles', 'first_patch_approved_id')) {
-        $dbh->bz_add_column('profiles', 'first_patch_approved_id', 
-                            { TYPE => 'INT3' });
-        _migrate_first_approved_ids();
+    if ($dbh->bz_column_info('profiles', 'first_patch_approved_id')) {
+        $dbh->bz_drop_column('profiles', 'first_patch_approved_id');
     }
     if (!$dbh->bz_column_info('profiles', 'first_patch_reviewed_id')) {
         $dbh->bz_add_column('profiles', 'first_patch_reviewed_id', { TYPE => 'INT3' });
@@ -66,42 +64,11 @@ sub _populate_first_reviewed_ids {
     print "done\n";
 }
 
-sub _migrate_first_approved_ids {
-    my $dbh = Bugzilla->dbh;
-
-    my $sth = $dbh->prepare('UPDATE profiles SET first_patch_approved_id = ? WHERE userid = ?');
-    my $ra = $dbh->selectall_arrayref("SELECT attachments.submitter_id, 
-                                              attachments.attach_id, 
-                                              flagtypes.name 
-                                         FROM attachments 
-                                              INNER JOIN flags ON attachments.attach_id = flags.attach_id
-                                              INNER JOIN flagtypes ON flags.type_id = flagtypes.id
-                                        WHERE flags.status = '+'
-                                     ORDER BY flags.modification_date");
-    my $count = 1;
-    my $total = scalar @$ra;
-    my %user_seen;
-    foreach my $ra_row (@$ra) {
-        my ($user_id, $attach_id, $flag_name) = @$ra_row;
-        next if $user_seen{$user_id};
-        my $found_flag = 0;
-        foreach my $flag_re (FLAG_REGEXES) {
-            $found_flag = 1 if ($flag_name =~ $flag_re);
-        }
-        next if !$found_flag;
-        indicate_progress({ current => $count++, total => $total, every => 25 });
-        $sth->execute($attach_id, $user_id);
-        $user_seen{$user_id} = 1;
-    } 
-
-    print "done\n";   
-}
-
 sub object_columns {
     my ($self, $args) = @_;
     my ($class, $columns) = @$args{qw(class columns)};
     if ($class->isa('Bugzilla::User')) {
-        push(@$columns, 'first_patch_approved_id');
+        push(@$columns, 'first_patch_reviewed_id');
     }
 }
 
@@ -109,42 +76,37 @@ sub flag_end_of_update {
     my ($self, $args) = @_;
     my ($object, $timestamp, $new_flags) = @$args{qw(object timestamp new_flags)};
 
-    if ($object->isa('Bugzilla::Attachment') 
-        && @$new_flags 
-        && grep($_ eq $object->bug->product, ENABLED_PRODUCTS)
-        && !$object->attacher->first_patch_approved_id) 
+    if ($object->isa('Bugzilla::Attachment')
+        && @$new_flags
+        && !$object->attacher->first_patch_reviewed_id
+        && grep($_ eq $object->bug->product, ENABLED_PRODUCTS))
     {
         my $attachment = $object;
 
-        # Glob: Borrowed this code from your push extension :)
         foreach my $change (@$new_flags) {
             $change =~ s/^[^:]+://; # get rid of setter
             $change =~ s/\([^\)]+\)$//; # get rid of requestee
             my ($name, $value) = $change =~ /^(.+)(.)$/;
 
-            # Only interested in flags set to +
-            next if $value ne '+';
-
-            my $found_flag = 0; 
-            foreach my $flag_re (FLAG_REGEXES) {
-                $found_flag = 1 if ($name =~ $flag_re);
-            }
-            next if !$found_flag;
-        
-            _send_approval_mail($attachment, $timestamp);
-            
+            # Only interested in review flags set to +
+            next unless $name =~ /^review/ && $value eq '+';
+
+            _send_mail($attachment, $timestamp);
+
+            Bugzilla->dbh->do("UPDATE profiles SET first_patch_reviewed_id = ? WHERE userid = ?",
+                              undef, $attachment->id, $attachment->attacher->id);
             last;
         }
     }
 }
 
-sub _send_approval_mail {
+sub _send_mail {
     my ($attachment, $timestamp) = @_;
-    
-    my $vars = { 
-        date      => format_time($timestamp, '%a, %d %b %Y %T %z', 'UTC'), 
-        to_user   => $attachment->attacher->email, 
-        from_user => EMAIL_FROM,  
+
+    my $vars = {
+        date      => format_time($timestamp, '%a, %d %b %Y %T %z', 'UTC'),
+        to_user   => $attachment->attacher->email,
+        from_user => EMAIL_FROM,
     };
 
     my $msg;
@@ -153,10 +115,6 @@ sub _send_approval_mail {
         || ThrowTemplateError($template->error());
 
     MessageToMTA($msg);
-
-    # Make sure we don't do this again
-    Bugzilla->dbh->do("UPDATE profiles SET first_patch_approved_id = ? WHERE userid = ?", 
-                      undef, $attachment->id, $attachment->attacher->id);
 }
 
 __PACKAGE__->NAME;
-- 
cgit v1.2.3-24-g4f1b