From 03516d639df2d3126f67670f7844b81f428d8640 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 23 Aug 2012 10:56:41 -0400 Subject: [PATCH] Add Leddy to the list of libraries for circ_date_to_expire Signed-off-by: Dan Scott --- tools/daily-scripts/circ_date_to_expire_date.pl | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/tools/daily-scripts/circ_date_to_expire_date.pl b/tools/daily-scripts/circ_date_to_expire_date.pl index 50492edb25..d4da5c4373 100644 --- a/tools/daily-scripts/circ_date_to_expire_date.pl +++ b/tools/daily-scripts/circ_date_to_expire_date.pl @@ -16,6 +16,9 @@ use OpenSRF::Utils::SettingsClient; my ($config, $set_due_time) = ('/openils/conf/opensrf_core.xml', 0); +# list of patron home_ous to check for expiry dates +my $libraries = "103, 109, 110, 122, 126"; + GetOptions( "bootstrap=s" => \$config, "set_due_time" => \$set_due_time, @@ -49,7 +52,7 @@ sub end_of_day { WHERE aoc.due_date > au.expire_date AND au.expire_date > NOW() AND au.expire_date < NOW() + '2 years'::interval - AND au.home_ou IN (103, 110, 126) + AND au.home_ou IN ($libraries) ORDER BY au.expire_date STMT @@ -60,7 +63,7 @@ STMT AND ac.due_date > au.expire_date AND au.expire_date > NOW() AND au.expire_date < NOW() + '2 years'::interval - AND au.home_ou IN (103, 110, 126) + AND au.home_ou IN ($libraries) AND ac.checkin_time IS NULL UPDATE -- 2.11.0