Bug 22521: Increase varchar size for accounttype
[koha-equinox.git] / mainpage.pl
index 258a9d5..49f46fc 100755 (executable)
@@ -30,6 +30,7 @@ use C4::Tags qw/get_count_by_tag_status/;
 use Koha::Patron::Modifications;
 use Koha::Patron::Discharge;
 use Koha::Reviews;
+use Koha::ArticleRequests;
 
 my $query = new CGI;
 
@@ -62,11 +63,17 @@ my $branch =
   ? C4::Context->userenv()->{'branch'}
   : undef;
 
-my $pendingcomments    = Koha::Reviews->search({ approved => 0 })->count;
+my $pendingcomments    = Koha::Reviews->search_limited({ approved => 0 })->count;
 my $pendingtags        = get_count_by_tag_status(0);
 my $pendingsuggestions = CountSuggestion("ASKED");
 my $pending_borrower_modifications = Koha::Patron::Modifications->pending_count( $branch );
 my $pending_discharge_requests = Koha::Patron::Discharge::count({ pending => 1 });
+my $pending_article_requests = Koha::ArticleRequests->search_limited(
+    {
+        status => Koha::ArticleRequest::Status::Pending,
+        $branch ? ( 'me.branchcode' => $branch ) : (),
+    }
+)->count;
 
 $template->param(
     pendingcomments                => $pendingcomments,
@@ -74,13 +81,7 @@ $template->param(
     pendingsuggestions             => $pendingsuggestions,
     pending_borrower_modifications => $pending_borrower_modifications,
     pending_discharge_requests     => $pending_discharge_requests,
+    pending_article_requests       => $pending_article_requests,
 );
 
-#
-# warn user if he is using mysql/admin login
-#
-unless ($loggedinuser) {
-    $template->param(adminWarning => 1);
-}
-
 output_html_with_http_headers $query, $cookie, $template->output;