/**
* 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;
}
