Bug 902623: show the count of pending reviews next to suggested reviewers

1 files changed, 17 insertions, 0 deletions

diff --git a/extensions/Review/Extension.pm b/extensions/Review/Extension.pm
index 9a19f528c..12aca8065 100644
--- a/extensions/Review/Extension.pm
+++ b/extensions/Review/Extension.pm
@@ -31,6 +31,7 @@ BEGIN {
     *Bugzilla::Component::reviewers       = \&_component_reviewers;
     *Bugzilla::Component::reviewers_objs  = \&_component_reviewers_objs;
     *Bugzilla::Bug::mentor                = \&_bug_mentor;
+    *Bugzilla::User::review_count         = \&_user_review_count;
 }
 
 #
@@ -93,6 +94,22 @@ sub _bug_mentor {
     return $self->{mentor};
 }
 
+sub _user_review_count {
+    my ($self) = @_;
+    if (!exists $self->{review_count}) {
+        ($self->{review_count}) = Bugzilla->dbh->selectrow_array(
+            "SELECT COUNT(*)
+            FROM flags
+                    INNER JOIN flagtypes ON flagtypes.id = flags.type_id
+            WHERE flags.requestee_id = ?
+                    AND flagtypes.name = ?",
+            undef,
+            $self->id, 'review',
+        );
+    }
+    return $self->{review_count};
+}
+
 #
 # reviewer-required
 #