diff options
| -rw-r--r-- | Bugzilla/Search/Saved.pm | 23 | ||||
| -rw-r--r-- | template/en/default/account/prefs/saved-searches.html.tmpl | 4 |
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> |