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