/**
* Custom SQL conditional for event duration meta field
*
* @param string $where_sql
* @param wp_query $query
* @return string
*/
public static function posts_where($where_sql, $query)
{
global $wpdb;
// if it's a true event query then we to setup where conditions
if ($query->tribe_is_event || $query->tribe_is_event_category) {
$start_date = !empty($query->start_date) ? $query->start_date : $query->get('start_date');
$end_date = !empty($query->end_date) ? $query->end_date : $query->get('end_date');
// we can't store end date directly because it messes up the distinc clause
$event_end_date = apply_filters('tribe_events_query_end_date_column', 'tribe_event_end_date.meta_value');
// event start date
$event_start_date = "{$wpdb->postmeta}.meta_value";
// build where conditionals for events if date range params are set
if ($start_date != '' && $end_date != '') {
$start_clause = $wpdb->prepare("({$event_start_date} >= %s AND {$event_start_date} <= %s)", $start_date, $end_date);
$end_clause = $wpdb->prepare("({$event_end_date} >= %s AND {$event_start_date} <= %s )", $start_date, $end_date);
$within_clause = $wpdb->prepare("({$event_start_date} < %s AND {$event_end_date} >= %s )", $start_date, $end_date);
$where_sql .= " AND ({$start_clause} OR {$end_clause} OR {$within_clause})";
} else {
if ($start_date != '') {
$start_clause = $wpdb->prepare("{$wpdb->postmeta}.meta_value >= %s", $start_date);
$within_clause = $wpdb->prepare("({$wpdb->postmeta}.meta_value <= %s AND {$event_end_date} >= %s )", $start_date, $start_date);
$where_sql .= " AND ({$start_clause} OR {$within_clause})";
if ($query->is_singular() && $query->get('eventDate')) {
$tomorrow = date('Y-m-d', strtotime($query->get('eventDate') . ' +1 day'));
$tomorrow_clause = $wpdb->prepare("{$wpdb->postmeta}.meta_value < %s", $tomorrow);
$where_sql .= " AND {$tomorrow_clause}";
}
} else {
if ($end_date != '') {
$where_sql .= " AND " . $wpdb->prepare("{$event_end_date} < %s", $end_date);
}
}
}
}
return $where_sql;
}
