/**
* Used by createEvent and updateEvent - saves all the various event meta
*/
public static function saveEventMeta($event_id, $data, $event = null)
{
$tribe_ecp = TribeEvents::instance();
if (isset($data['EventAllDay']) && ($data['EventAllDay'] == 'yes' || $data['EventAllDay'] == true || !isset($data['EventStartDate']))) {
$data['EventStartDate'] = TribeDateUtils::beginningOfDay($data['EventStartDate']);
$data['EventEndDate'] = TribeDateUtils::endOfDay($data['EventEndDate']);
} else {
delete_post_meta($event_id, '_EventAllDay');
if (isset($data['EventStartMeridian'])) {
$data['EventStartDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventStartDate'] . " " . $data['EventStartHour'] . ":" . $data['EventStartMinute'] . ":00 " . $data['EventStartMeridian']));
$data['EventEndDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventEndDate'] . " " . $data['EventEndHour'] . ":" . $data['EventEndMinute'] . ":00 " . $data['EventEndMeridian']));
} else {
$data['EventStartDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventStartDate'] . " " . $data['EventStartHour'] . ":" . $data['EventStartMinute'] . ":00"));
$data['EventEndDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventEndDate'] . " " . $data['EventEndHour'] . ":" . $data['EventEndMinute'] . ":00"));
}
}
if (!isset($data['EventHideFromUpcoming']) || !$data['EventHideFromUpcoming']) {
delete_post_meta($event_id, '_EventHideFromUpcoming');
}
// sanity check that start date < end date
$startTimestamp = strtotime($data['EventStartDate']);
$endTimestamp = strtotime($data['EventEndDate']);
if ($startTimestamp > $endTimestamp) {
$data['EventEndDate'] = $data['EventStartDate'];
}
if (!isset($data['EventShowMapLink'])) {
update_post_meta($event_id, '_EventShowMapLink', 'false');
}
if (!isset($data['EventShowMap'])) {
update_post_meta($event_id, '_EventShowMap', 'false');
}
if (isset($data['post_status'])) {
$post_status = $data['post_status'];
} else {
//print_r($data);
if (isset($data["Organizer"]["OrganizerID"])) {
$post_status = get_post($data["Organizer"]['OrganizerID'])->post_status;
}
if (isset($data['Venue']["VenueID"])) {
$post_status = get_post($data['Venue']['VenueID'])->post_status;
}
}
if (isset($data["Organizer"])) {
$data['EventOrganizerID'] = TribeEventsAPI::saveEventOrganizer($data["Organizer"], $event, $post_status);
}
if (isset($data["Venue"])) {
$data['EventVenueID'] = TribeEventsAPI::saveEventVenue($data["Venue"], $event, $post_status);
}
$tribe_ecp->do_action('tribe_events_event_save', $event_id);
//update meta fields
foreach ($tribe_ecp->metaTags as $tag) {
$htmlElement = ltrim($tag, '_');
if (isset($data[$htmlElement]) && $tag != TribeEvents::EVENTSERROROPT) {
if (is_string($data[$htmlElement])) {
$data[$htmlElement] = filter_var($data[$htmlElement], FILTER_SANITIZE_STRING);
}
update_post_meta($event_id, $tag, $data[$htmlElement]);
}
}
$tribe_ecp->do_action('tribe_events_update_meta', $event_id, false, $data, $event);
}
public function where($where, $wp_query)
{
global $ecp_apm, $wpdb;
// run once
remove_filter('posts_where', array($this, 'where'), 10, 2);
foreach ($this->active as $key => $active) {
$field = '';
if ($key === 'ecp_start_date') {
$field = "{$wpdb->postmeta}.meta_value";
}
if ($key === 'ecp_end_date') {
$field = "IFNULL(DATE_ADD(CAST({$wpdb->postmeta}.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value)";
}
if (empty($field)) {
continue;
}
$value = $active['value'];
switch ($active['is']) {
case "is":
$where .= $wpdb->prepare(" AND {$field} BETWEEN %s AND %s ", TribeDateUtils::beginningOfDay($value), TribeDateUtils::endOfDay($value));
break;
case "not":
$where .= $wpdb->prepare(" AND {$field} NOT BETWEEN %s AND %s ", TribeDateUtils::beginningOfDay($value), TribeDateUtils::endOfDay($value));
break;
case "gte":
$where .= $wpdb->prepare(" AND {$field} >= %s ", TribeDateUtils::beginningOfDay($value));
break;
case "lte":
$where .= $wpdb->prepare(" AND {$field} <= %s ", TribeDateUtils::endOfDay($value));
break;
}
}
return $where;
}
public static function addEventConditions($where, $cur_query)
{
global $wpdb;
if ($cur_query->get('start_date')) {
$start_date = TribeDateUtils::beginningOfDay($cur_query->get('start_date'));
}
if ($cur_query->get('end_date')) {
$end_date = TribeDateUtils::endOfDay($cur_query->get('end_date'));
}
// we can't store end date directly because it messes up the distinc clause
$endDate = " IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) ";
if (!empty($start_date) && !empty($end_date)) {
$start_clause = $wpdb->prepare("(eventStart.meta_value >= %s AND eventStart.meta_value <= %s)", $start_date, $end_date);
$end_clause = $wpdb->prepare("({$endDate} >= %s AND eventStart.meta_value <= %s )", $start_date, $end_date);
$within_clause = $wpdb->prepare("(eventStart.meta_value < %s AND {$endDate} >= %s )", $start_date, $end_date);
$where .= " AND ({$start_clause} OR {$end_clause} OR {$within_clause})";
} else {
if (!empty($end_date)) {
$start_clause = $wpdb->prepare("{$endDate} < %s", $end_date);
$where .= " AND {$start_clause}";
} else {
if (!empty($start_date)) {
$end_clause = $wpdb->prepare("eventStart.meta_value > %s", $start_date);
$within_clause = $wpdb->prepare("(eventStart.meta_value <= %s AND {$endDate} >= %s )", $start_date, $start_date);
$where .= " AND ({$end_clause} OR {$within_clause})";
}
}
}
if ($cur_query->get('hide_upcoming')) {
$where .= " AND (hideUpcoming.meta_value != 'yes' OR hideUpcoming.meta_value IS null) ";
}
return $where;
}
/**
* Used by createEvent and updateEvent - saves all the various event meta
*
* @param int $event_id The event ID we are modifying meta for.
* @param array $data The meta fields we want saved.
* @param WP_Post The event itself.
* @return void
*/
public static function saveEventMeta($event_id, $data, $event = null)
{
$tribe_ecp = TribeEvents::instance();
if (isset($data['EventAllDay']) && ($data['EventAllDay'] == 'yes' || $data['EventAllDay'] == true || !isset($data['EventStartDate']))) {
$data['EventStartDate'] = TribeDateUtils::beginningOfDay($data['EventStartDate']);
$data['EventEndDate'] = TribeDateUtils::endOfDay($data['EventEndDate']);
} else {
delete_post_meta($event_id, '_EventAllDay');
if (isset($data['EventStartMeridian'])) {
$data['EventStartDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventStartDate'] . " " . $data['EventStartHour'] . ":" . $data['EventStartMinute'] . ":00 " . $data['EventStartMeridian']));
$data['EventEndDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventEndDate'] . " " . $data['EventEndHour'] . ":" . $data['EventEndMinute'] . ":00 " . $data['EventEndMeridian']));
} else {
$data['EventStartDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventStartDate'] . " " . $data['EventStartHour'] . ":" . $data['EventStartMinute'] . ":00"));
$data['EventEndDate'] = date(TribeDateUtils::DBDATETIMEFORMAT, strtotime($data['EventEndDate'] . " " . $data['EventEndHour'] . ":" . $data['EventEndMinute'] . ":00"));
}
}
if (!isset($data['EventHideFromUpcoming']) || !$data['EventHideFromUpcoming']) {
delete_post_meta($event_id, '_EventHideFromUpcoming');
}
// sanity check that start date < end date
$startTimestamp = strtotime($data['EventStartDate']);
$endTimestamp = strtotime($data['EventEndDate']);
if ($startTimestamp > $endTimestamp) {
$data['EventEndDate'] = $data['EventStartDate'];
}
$data['EventDuration'] = strtotime($data['EventEndDate']) - $startTimestamp;
$old_data['EventStartDate'] = TribeEvents::get_series_start_date($event_id);
update_post_meta($event_id, '_EventShowMapLink', isset($data['venue']['EventShowMapLink']));
update_post_meta($event_id, '_EventShowMap', isset($data['venue']['EventShowMap']));
if (isset($data['post_status'])) {
$post_status = $data['post_status'];
} else {
//print_r($data);
if (isset($data["Organizer"]["OrganizerID"])) {
$post_status = get_post($data["Organizer"]['OrganizerID'])->post_status;
}
if (isset($data['Venue']["VenueID"])) {
$post_status = get_post($data['Venue']['VenueID'])->post_status;
}
}
if (isset($data["Organizer"])) {
$data['EventOrganizerID'] = TribeEventsAPI::saveEventOrganizer($data["Organizer"], $event, $post_status);
}
if (isset($data["Venue"])) {
$data['EventVenueID'] = TribeEventsAPI::saveEventVenue($data["Venue"], $event, $post_status);
}
$cost = isset($data['EventCost']) ? $data['EventCost'] : '';
$data['EventCost'] = $cost;
do_action('tribe_events_event_save', $event_id);
$cost = isset($data['EventCost']) ? $data['EventCost'] : '';
$data['EventCost'] = $cost;
//update meta fields
foreach ($tribe_ecp->metaTags as $tag) {
$htmlElement = ltrim($tag, '_');
if (isset($data[$htmlElement]) && $tag != TribeEvents::EVENTSERROROPT) {
if (is_string($data[$htmlElement])) {
$data[$htmlElement] = filter_var($data[$htmlElement], FILTER_SANITIZE_STRING);
}
if (isset($old_data[$htmlElement])) {
update_post_meta($event_id, $tag, $data[$htmlElement], $old_data[$htmlElement]);
} else {
update_post_meta($event_id, $tag, $data[$htmlElement]);
}
}
}
// Set sticky state for calendar view.
if (isset($data['EventShowInCalendar']) && $data['EventShowInCalendar'] == 'yes' && $event->menu_order != '-1') {
$update_event = array('ID' => $event_id, 'menu_order' => '-1');
wp_update_post($update_event);
} elseif ((!isset($data['EventShowInCalendar']) || $data['EventShowInCalendar'] != 'yes') && $event->menu_order == '-1') {
$update_event = array('ID' => $event_id, 'menu_order' => '0');
wp_update_post($update_event);
}
do_action('tribe_events_update_meta', $event_id, $data);
}
