From d8e71548510557bbe7102c8c54c8522d2922de8c Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Mon, 7 Nov 2016 14:11:40 -0500
Subject: [PATCH] Fix dateRange for one day search.

Fix the sql for times as sub select.
---
 models/front/events/baseAction.php | 1 -
 models/front/events/list.php       | 6 ++++--
 2 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/models/front/events/baseAction.php b/models/front/events/baseAction.php
index 4e48495..b1853de 100644
--- a/models/front/events/baseAction.php
+++ b/models/front/events/baseAction.php
@@ -298,7 +298,6 @@ abstract class GlmMembersFront_events_baseAction extends GlmDataEvents
         if ( isset( $whereParts ) && !empty( $whereParts ) ) {
             $where = implode( ' AND ', $whereParts);
         }
-        //echo '<pre>$where: ' . print_r( $where, true ) . '</pre>';
 
         $events = $this->getList( $where, $order );
 
diff --git a/models/front/events/list.php b/models/front/events/list.php
index 63ddb6d..5c3c779 100644
--- a/models/front/events/list.php
+++ b/models/front/events/list.php
@@ -210,11 +210,13 @@ class GlmMembersFront_events_list extends GlmMembersFront_events_baseAction
                 if ( $eventDay ) {
                     $fromDate = $toDate = $eventDay;
                     $from = $to = date( 'Y-m-d', strtotime( $eventDay ) );
+                    $this->dateRange = "id IN (
+                        SELECT id
+                          FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times
+                         WHERE DATE(start_time) = '{$from}')";
                 }
             }
-            $this->dateRange = "start_time <= CAST('{$from}' AS DATE) AND start_time >= CAST('{$to}' as DATE)";
         }
-        //echo '<pre>dateRange: ' . print_r( $this->dateRange, true ) . '</pre>';
 
         if ( isset( $_REQUEST['event_name'] )
             && $eventNameSearch = filter_var( $_REQUEST['event_name'], FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES ) ) {
-- 
2.17.1