[Koha-patches] [PATCH 3/4] future hold request followup 3 - build_holdsqueue

Galen Charlton gmcharlt at gmail.com
Wed Aug 12 01:23:26 CEST 2009


Fixed the holds queue job so that it correctly
ignores hold requests that are not yet scheduled
to be filled.
---
 misc/cronjobs/holds/build_holds_queue.pl |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/misc/cronjobs/holds/build_holds_queue.pl b/misc/cronjobs/holds/build_holds_queue.pl
index 4aca28d..4f9549f 100755
--- a/misc/cronjobs/holds/build_holds_queue.pl
+++ b/misc/cronjobs/holds/build_holds_queue.pl
@@ -83,7 +83,8 @@ sub GetBibsWithPendingHoldRequests {
     my $bib_query = "SELECT DISTINCT biblionumber
                      FROM reserves
                      WHERE found IS NULL
-                     AND priority > 0";
+                     AND priority > 0
+                     AND reservedate <= CURRENT_DATE()";
     my $sth = $dbh->prepare($bib_query);
 
     $sth->execute();
@@ -129,6 +130,7 @@ sub GetPendingHoldRequestsForBib {
                          WHERE biblionumber = ?
                          AND found IS NULL
                          AND priority > 0
+                         AND reservedate <= CURRENT_DATE()
                          ORDER BY priority";
     my $sth = $dbh->prepare($request_query);
     $sth->execute($biblionumber);
-- 
1.5.6.5




More information about the Koha-patches mailing list