X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=C4%2FTags.pm;h=06c1e1db6de4153d94e4ff80359f1eaae87f55db;hb=0ffd765824644e9975b6854616b745922eee393c;hp=ecd9758b30cec67736987bd3747c4877b61d3227;hpb=28718d254db996189bdd3bc987b1a076ac1742ce;p=koha_gimpoz

diff --git a/C4/Tags.pm b/C4/Tags.pm
index ecd9758b30..06c1e1db6d 100644
--- a/C4/Tags.pm
+++ b/C4/Tags.pm
@@ -40,6 +40,7 @@ BEGIN {
 		&whitelist
 		&is_approved
 		&approval_counts
+		&get_count_by_tag_status
 		&get_filters
 	);
 	# %EXPORT_TAGS = ();
@@ -92,6 +93,24 @@ sub approval_counts () {
 	return $result;
 }
 
+=head2 get_count_by_tag_status
+
+  get_count_by_tag_status($status);
+
+Takes a status and gets a count of tags with that status
+
+=cut
+
+sub get_count_by_tag_status  {
+    my ($status) = @_;
+    my $dbh            = C4::Context->dbh;
+    my $query          =
+      "SELECT count(*) FROM tags_approval WHERE approved=?";
+    my $sth = $dbh->prepare($query);
+    $sth->execute( $status );
+  return $sth->fetchrow;
+}
+
 sub remove_tag ($;$) {
 	my $tag_id  = shift or return undef;
 	my $user_id = (@_) ? shift : undef;
@@ -581,6 +600,8 @@ More verose debugging messages are sent in the presence of non-zero $ENV{"DEBUG"
 
 =head3 TO DO: Add real perldoc
 
+=cut
+
 =head2 External Dictionary (Ispell) [Recommended]
 
 An external dictionary can be used as a means of "pre-populating" and tracking