From 0e92e81650e36bb25e4b8cb274dd8d1f6f0c662d Mon Sep 17 00:00:00 2001 From: Sophie Meynieux Date: Wed, 26 Dec 2012 17:36:45 +0100 Subject: [PATCH] BZ 9320 : Pending reserves report (circ/pendingreserves.pl) should not show items on hold waiting to be picked up Test plan : * chose an item reserved by multiple patrons. * return the item and confirm reservation => item is waiting to be picked up * run circ/pendingreserves.pl => without patch, this item is shown in the list => with the patch, only really available items are show. --- circ/pendingreserves.pl | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index e532faf..0893396 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 -- 1.7.5.4