From 50710406eb51daf33cee76acfca1338356067ca8 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 12 Dec 2018 13:53:50 -0500 Subject: [PATCH] Setup for check on month in request filter the events by month year query for uptravel --- models/front/events/list.php | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) diff --git a/models/front/events/list.php b/models/front/events/list.php index ea77ae4..2e23349 100644 --- a/models/front/events/list.php +++ b/models/front/events/list.php @@ -308,10 +308,22 @@ class GlmMembersFront_events_list extends GlmMembersFront_events_baseAction } } - if ( $fromDate && $toDate && !(isset($_REQUEST['event_name']) && $_REQUEST['event_name'])) { + if ( isset( $_REQUEST['month'] ) && $_REQUEST['month'] && !( isset( $_REQUEST['event_name'] ) && $_REQUEST['event_name'] ) ) { + list($month, $year) = explode(" ", $_REQUEST['month']); + $startingTime = mktime(0, 0, 0, $month, 1, $year); + $lastday = date("t", $startingTime); + $endingTime = mktime(0, 0, 0, $month, $lastday, $year); + $fromDate = date("Y-m-d", $startingTime); + $toDate = date("Y-m-d", $endingTime); + $this->dateRange = "id IN ( + SELECT id + FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times + WHERE DATE(start_time) BETWEEN '{$fromDate}' AND '{$toDate}' + )"; + } else if ( $fromDate && $toDate && !( isset( $_REQUEST['event_name'] ) && $_REQUEST['event_name'] ) ) { $from = date('Y-m-d', strtotime($fromDate)); $to = date('Y-m-d', strtotime($toDate)); - $this->dateRange = "start_time BETWEEN CAST('{$from}' AS DATE) AND CAST('{$to}' as DATE)"; + // $this->dateRange = "start_time BETWEEN CAST('{$from}' AS DATE) AND CAST('{$to}' as DATE)"; $this->dateRange = "id IN ( SELECT id FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times -- 2.17.1