X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;ds=inline;f=circ%2Fview_holdsqueue.pl;h=41db32bce96b41e28bf58f298551ade4442743a3;hb=08382876306cfda839637c5f72a107b304458a8e;hp=1b8c09bf9d147bbaf5bb1e745bd9496b5f266d8c;hpb=5ae7d4ea9738ab0c2ca499a578fdd3d23efdd836;p=koha.git diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl index 1b8c09bf9d..41db32bce9 100755 --- a/circ/view_holdsqueue.pl +++ b/circ/view_holdsqueue.pl @@ -23,14 +23,15 @@ This script displays items in the tmp_holdsqueue table =cut use strict; +use warnings; use CGI; use C4::Auth; use C4::Output; use C4::Biblio; use C4::Items; -use C4::Koha; # GetItemTypes +use C4::Koha; # GetItemTypes use C4::Branch; # GetBranches -use C4::Dates qw/format_date/; +use C4::HoldsQueue qw(GetHoldsQueueItems); my $query = new CGI; my ( $template, $loggedinuser, $cookie ) = get_template_and_user( @@ -39,70 +40,41 @@ my ( $template, $loggedinuser, $cookie ) = get_template_and_user( query => $query, type => "intranet", authnotrequired => 0, - flagsrequired => { circulate => 1 }, + flagsrequired => { circulate => "circulate_remaining_permissions" }, debug => 1, } ); my $params = $query->Vars; -my $run_report = $params->{'run_report'}; -my $branchlimit = $params->{'branchlimit'}; +my $run_report = $params->{'run_report'}; +my $branchlimit = $params->{'branchlimit'}; my $itemtypeslimit = $params->{'itemtypeslimit'}; if ( $run_report ) { - my $items = GetHoldsQueueItems( $branchlimit,$itemtypeslimit ); + # XXX GetHoldsQueueItems() does not support $itemtypeslimit! + my $items = GetHoldsQueueItems($branchlimit, $itemtypeslimit); $template->param( - branch => $branchlimit, - total => scalar @$items, - itemsloop => $items, - run_report => $run_report, - dateformat => C4::Context->preference("dateformat"), - ); -} - -# getting all branches. -my $branches = GetBranches; -my $branch = C4::Context->userenv->{"branchname"}; -my @branchloop; -foreach my $thisbranch ( keys %$branches ) { - my $selected = 1 if $thisbranch eq $branch; - my %row = ( - value => $thisbranch, - selected => $selected, - branchname => $branches->{$thisbranch}->{'branchname'}, + branchlimit => $branchlimit, + total => scalar @$items, + itemsloop => $items, + run_report => $run_report, ); - push @branchloop, \%row; } # getting all itemtypes my $itemtypes = &GetItemTypes(); my @itemtypesloop; foreach my $thisitemtype ( sort keys %$itemtypes ) { - my %row = ( + push @itemtypesloop, { value => $thisitemtype, description => $itemtypes->{$thisitemtype}->{'description'}, - ); - push @itemtypesloop, \%row; + }; } -$template->param( branchloop => \@branchloop, - itemtypeloop => \@itemtypesloop, +$template->param( + branchloop => GetBranchesLoop(C4::Context->userenv->{'branch'}), + itemtypeloop => \@itemtypesloop, ); -sub GetHoldsQueueItems { - my ($branchlimit,$itemtypelimit) = @_; - my $dbh = C4::Context->dbh; - my $query = "SELECT * FROM tmp_holdsqueue"; - $query.=" WHERE holdingbranch = \"$branchlimit\"" if $branchlimit; - my $sth = $dbh->prepare($query); - $sth->execute(); - my $items = []; - while ( my $row = $sth->fetchrow_hashref ){ - $row->{reservedate} = format_date($row->{reservedate}); - push @$items, $row; - } - return $items; - -} # writing the template output_html_with_http_headers $query, $cookie, $template->output;