From 4fc6759d0c3ce4e0d936db6a9b728ef1125a2717 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Thu, 8 Mar 2012 14:45:56 -0500
Subject: [PATCH] Bug 7408 - Don't cancel found reserves.

At the moment, a reserve will be canceled if it has passed its
expiration date, even if the item is waiting or in the process
of being transferred. The situation could arise where someone
has a hold filled, but it is canceled while in transit, or before
the borrower can pick it up.
---
 C4/Reserves.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/C4/Reserves.pm b/C4/Reserves.pm
index 44a82bd3b3..a63e30ff8e 100644
--- a/C4/Reserves.pm
+++ b/C4/Reserves.pm
@@ -866,6 +866,7 @@ sub CancelExpiredReserves {
     my $sth = $dbh->prepare( "
         SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) 
         AND expirationdate IS NOT NULL
+        AND found IS NULL
     " );
     $sth->execute();
 
-- 
2.39.2