From fd00316cfe8eee5ac236fbe35a9182c6c79d3e9b Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 28 Aug 2006 16:22:06 +0000 Subject: [PATCH] better date range support for surveys git-svn-id: svn://svn.open-ils.org/ILS/trunk@5734 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../OpenILS/Application/Storage/Publisher/action.pm | 10 +++++----- 1 file changed, 5 insertions(+), 5 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 69cdd93415..35729a3506 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm @@ -250,7 +250,7 @@ sub find_local_surveys { SELECT s.* FROM $s_table s JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner) - WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date + WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date SQL my $sth = action::survey->db_Main->prepare_cached($select); @@ -280,7 +280,7 @@ sub find_opac_surveys { SELECT s.* FROM $s_table s JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner) - WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date + WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date AND s.opac IS TRUE; SQL @@ -355,7 +355,7 @@ sub find_optional_surveys { SELECT s.* FROM $s_table s JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner) - WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date + WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date AND s.required IS FALSE; SQL @@ -385,7 +385,7 @@ sub find_required_surveys { SELECT s.* FROM $s_table s JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner) - WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date + WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date AND s.required IS TRUE; SQL @@ -415,7 +415,7 @@ sub find_usr_summary_surveys { SELECT s.* FROM $s_table s JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner) - WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date + WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date AND s.usr_summary IS TRUE; SQL -- 2.43.2