From 1ea9f2876c618cdbff33073e69c3d005f95b9f36 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 7 Nov 2016 14:00:21 -0500 Subject: [PATCH] fix for day search --- models/front/events/list.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/models/front/events/list.php b/models/front/events/list.php index 82f9b3f..63ddb6d 100644 --- a/models/front/events/list.php +++ b/models/front/events/list.php @@ -212,8 +212,9 @@ class GlmMembersFront_events_list extends GlmMembersFront_events_baseAction $from = $to = date( 'Y-m-d', strtotime( $eventDay ) ); } } - $this->dateRange = "start_time BETWEEN CAST('{$from}' AS DATE) AND CAST('{$to}' as DATE)"; + $this->dateRange = "start_time <= CAST('{$from}' AS DATE) AND start_time >= CAST('{$to}' as DATE)"; } + //echo '
dateRange: ' . print_r( $this->dateRange, true ) . '
'; if ( isset( $_REQUEST['event_name'] ) && $eventNameSearch = filter_var( $_REQUEST['event_name'], FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES ) ) { -- 2.17.1