From f1a7cbd6115de4f6904a2c8df31b0136ec85462d Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 18 Nov 2008 15:45:10 +0000 Subject: [PATCH] forward-porting longoverdue fixes from 1.4 after testing git-svn-id: svn://svn.open-ils.org/ILS/trunk@11254 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm index 721a937949..8068e45416 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm @@ -186,12 +186,12 @@ sub mark_longoverdue { SET stop_fines = 'LONGOVERDUE', stop_fines_time = now() WHERE id IN ( - SELECT id + SELECT circ.id FROM $circ circ LEFT JOIN $setting setting ON (circ.circ_lib = setting.org_unit AND setting.name = 'circ.long_overdue.interval') WHERE circ.checkin_time IS NULL AND (stop_fines IS NULL OR stop_fines NOT IN ('LOST','LONGOVERDUE')) - AND AGE(circ.due_date) > CAST( COALESCE( BTRIM( FIRST(setting.value),'"' ), ? ) AS INTERVAL) + AND AGE(circ.due_date) > CAST( COALESCE( BTRIM( setting.value,'"' ), ? ) AS INTERVAL) ) SQL -- 2.11.0