Bug 383935: Display how many other users have chosen to see your saved search in their footer - Patch by Frédéric Buclin <LpSolit@gmail.com> r=timeless a=LpSolit

2 files changed, 27 insertions, 0 deletions

diff --git a/Bugzilla/Search/Saved.pm b/Bugzilla/Search/Saved.pm
index 83528405f..3c1ad6651 100644
--- a/Bugzilla/Search/Saved.pm
+++ b/Bugzilla/Search/Saved.pm
@@ -170,6 +170,23 @@ sub shared_with_group {
     return $self->{shared_with_group};
 }
 
+sub shared_with_users {
+    my $self = shift;
+    my $dbh = Bugzilla->dbh;
+
+    if (!exists $self->{shared_with_users}) {
+        $self->{shared_with_users} =
+          $dbh->selectrow_array('SELECT COUNT(*)
+                                   FROM namedqueries_link_in_footer
+                             INNER JOIN namedqueries
+                                     ON namedquery_id = id
+                                  WHERE namedquery_id = ?
+                                    AND user_id != userid',
+                                  undef, $self->id);
+    }
+    return $self->{shared_with_users};
+}
+
 ####################
 # Simple Accessors #
 ####################
@@ -208,6 +225,7 @@ __END__
  my $edit_link  = $query->edit_link;
  my $search_url = $query->url;
  my $owner      = $query->user;
+ my $num_subscribers = $query->shared_with_users;
 
 =head1 DESCRIPTION
 
@@ -262,4 +280,9 @@ True if the search contains only a list of Bug IDs.
 The L<Bugzilla::Group> that this search is shared with. C<undef> if
 this search isn't shared.
 
+=item C<shared_with_users>
+
+Returns how many users (besides the author of the saved search) are
+using the saved search, i.e. have it displayed in their footer.
+
 =back
diff --git a/template/en/default/account/prefs/saved-searches.html.tmpl b/template/en/default/account/prefs/saved-searches.html.tmpl
index 9af0efef5..52c4ded30 100644
--- a/template/en/default/account/prefs/saved-searches.html.tmpl
+++ b/template/en/default/account/prefs/saved-searches.html.tmpl
@@ -112,6 +112,10 @@
                 >[% group.name FILTER html %]</option>
               [% END %]
             </select>
+            [% IF q.shared_with_users %]
+              (shared with [% q.shared_with_users FILTER html %]
+              [%+ q.shared_with_users > 1 ? "users" : "user" %])
+            [% END %]
           </td>
         [% END %]
       </tr>