Bug 5549 : Add Extra Perl Dependencies

[koha_gimpoz] / C4 / Tags.pm

diff --git a/C4/Tags.pm b/C4/Tags.pm
index 5f2ff69..06c1e1d 100644 (file)
--- 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;
@@ -261,7 +280,7 @@ sub get_tags (;$) {         # i.e., from tags_index
 
 sub get_approval_rows (;$) {           # i.e., from tags_approval
        my $hash = shift || {};
-       my @ok_fields = qw(term approved date_approved approved_by weight_total limit sort);
+       my @ok_fields = qw(term approved date_approved approved_by weight_total limit sort borrowernumber);
        my $wheres;
        my $limit  = "";
        my $order  = "";
@@ -279,7 +298,7 @@ sub get_approval_rows (;$) {                # i.e., from tags_approval
                if ($key eq 'limit') {
                        my $val = $hash->{$key};
                        unless ($val =~ /^(\d+,)?\d+$/) {
-                               carp "Non-nuerical limit value '$val' ignored!";
+                               carp "Non-numerical limit value '$val' ignored!";
                                next;
                        }
                        $limit = " LIMIT $val\n";
@@ -288,6 +307,7 @@ sub get_approval_rows (;$) {                # i.e., from tags_approval
                                unless (
                                        $by =~ /^([-+])?(term)/            or
                                        $by =~ /^([-+])?(biblionumber)/    or
+                    $by =~ /^([-+])?(borrowernumber)/  or
                                        $by =~ /^([-+])?(weight_total)/    or
                                        $by =~ /^([-+])?(approved(_by)?)/  or
                                        $by =~ /^([-+])?(date_approved)/
@@ -580,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