/** * Build where conditions * @return array */ public function buildWhereConditions() { $form = \CPFCMembers\ReportingFilter::getInstance(); $whereConditions = array(); $whereConditionsFriendly = array(); switch (true) { case Input::request('cpfc_filter_member_submit'): case Input::request('cpfc_filter_member_export'): if (Input::request('registered_after')) { $whereConditions['registered_date >='] = date('Y-m-d H:i:s', strtotime(Input::request('registered_after'))); $whereConditionsFriendly[] = 'Members were registered at or after ' . date('H:i \o\n jS F Y', strtotime(Input::request('registered_after'))); } if (Input::request('registered_before')) { $whereConditions['registered_date <'] = date('Y-m-d H:i:s', strtotime(Input::request('registered_before'))); $whereConditionsFriendly[] = 'Members were registered before ' . date('H:i \o\n jS F Y', strtotime(Input::request('registered_before'))); } if (Input::request('country')) { $whereConditions['country ='] = Input::request('country'); $countries = $form->getCountryOptions(); $whereConditionsFriendly[] = 'Members\' country is "' . $countries[Input::request('country')] . '"'; } if (Input::request('membership_level')) { $whereConditions['membership_level ='] = Input::request('membership_level'); $membershipLevels = $form->getMembershipLevelOptions(); $whereConditionsFriendly[] = 'Members\' membership level is "' . $membershipLevels[Input::request('membership_level')] . '"'; } break; case Input::request('cpfc_filter_see_tickets_account_holder_submit'): case Input::request('cpfc_filter_see_tickets_account_holder_export'): if (Input::request('see_tickets_account_number')) { $whereConditions['see_tickets_account_number ='] = Input::request('see_tickets_account_number'); $whereConditionsFriendly[] = 'Member\'s SEE Tickets Account Number is "' . Input::request('see_tickets_account_number') .'"'; } break; case Input::post('cpfc_logged_in_filter_submit'): case Input::post('cpfc_logged_in_filter_export'): if (Input::request('logged_in_after')) { $whereConditions['login_date >='] = date('Y-m-d H:i:s', strtotime(Input::request('logged_in_after'))); $whereConditionsFriendly[] = 'Members logged-in at or after ' . date('H:i \o\n jS F Y', strtotime(Input::request('logged_in_after'))); } if (Input::request('logged_in_before')) { $whereConditions['login_date <'] = date('Y-m-d H:i:s', strtotime(Input::request('logged_in_before'))); $whereConditionsFriendly[] = 'Members logged-in before ' . date('H:i \o\n jS F Y', strtotime(Input::request('logged_in_before'))); } break; } return array($whereConditions, $whereConditionsFriendly); }
/** * Load Video Carousel content * @return [type] [description] */ public function homepageVideoCarousel() { global $wp_query; $videoId = Input::request('id', false); // Vimeo Videos for Carousel $vimeo = new \CPFCMembers\Vimeo(); if ($videoId) { $video = $vimeo->fetchVideoInfoFromCache($videoId); if ($video) { get_partial('partials/homepage_carousel/vimeo_overlay', array('video'=>$video,'videoId'=>$videoId)); exit; } } header("HTTP/1.0 404 Not Found - Archive Empty"); $wp_query->set_404(); require TEMPLATEPATH.'/404.php'; exit; }