From 840c98b36a2a8a30d26ac032aea4aa4e69368f39 Mon Sep 17 00:00:00 2001 From: dbs Date: Thu, 2 Jul 2009 19:36:32 +0000 Subject: [PATCH] Add NOSME and NOSMW to the mix for due_date <= expire_date git-svn-id: svn://svn.open-ils.org/ILS-Contrib/conifer/trunk@559 6d9bc8c9-1ec2-4278-b937-99fde70a366f --- tools/circ_date_to_expire_date.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/tools/circ_date_to_expire_date.pl b/tools/circ_date_to_expire_date.pl index 93b2ce93eb..36a3bc655d 100644 --- a/tools/circ_date_to_expire_date.pl +++ b/tools/circ_date_to_expire_date.pl @@ -49,7 +49,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 = 103 + AND au.home_ou IN (103, 110, 126) ORDER BY au.expire_date STMT @@ -63,7 +63,7 @@ STMT WHERE aoc.due_date > au.expire_date AND au.expire_date > NOW() AND au.expire_date < NOW() + '2 years'::interval - AND au.home_ou = 103 + AND au.home_ou IN (103, 110, 126) AND aoc.checkin_time IS NULL ) UPDATE -- 2.11.0