X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;ds=sidebyside;f=circ%2Fpendingreserves.pl;h=9a60ec187bb5b4b88db18bd4448ddab46c2a8ed3;hb=3285261d0150113e597d48a5a78aee5fdc1ebd94;hp=0f5d3da78a61afa4a4f5ed485abc5effb6a26673;hpb=243cfbe7cebb8f90225a4b72f7ffb63c3f9b8ca0;p=koha.git diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 0f5d3da78a..9a60ec187b 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -141,6 +141,7 @@ if ( $run_report ) { $sqldatewhere AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) + AND items.itemnumber NOT IN (select itemnumber FROM reserves where found='W') AND issues.itemnumber IS NULL AND reserves.priority <> 0 AND reserves.suspend = 0 @@ -150,7 +151,7 @@ if ( $run_report ) { # multiple patrons have a hold on an item - if (C4::Context->preference('IndependantBranches')){ + if (C4::Context->preference('IndependentBranches')){ $strsth .= " AND items.holdingbranch=? "; push @query_params, C4::Context->userenv->{'branch'}; }