Tribe__Events__Pro__Repositories__Event::get_in_series_where_sql( mixed $in_series )

Will generate the WHERE clause for the in series param.

Contents

Parameters

$in_series

(mixed) (Required) The series to filter by.

Top ↑

Return

(string) The WHERE clause to filter by this series.

Top ↑

Source

File: src/Tribe/Repositories/Event.php 

	public static function get_in_series_where_sql( $in_series ): string {
		global $wpdb;

		if ( is_numeric( $in_series ) || $in_series instanceof WP_Post ) {
			$parent_post_id  = $in_series instanceof WP_Post ? $in_series->ID : absint( $in_series );
			$children_clause = $wpdb->prepare( "{$wpdb->posts}.post_parent = %d", $parent_post_id );
			$parent_clause   = $wpdb->prepare( "{$wpdb->posts}.ID = %d", $parent_post_id );
		} else {
			$children_clause = "{$wpdb->posts}.post_parent != 0";
			$parent_clause   = "{$wpdb->posts}.post_parent = 0";
		}

		return "{$children_clause}
				OR (
					{$parent_clause}
					AND in_series_meta.meta_key = '_EventRecurrence'
					AND in_series_meta.meta_value IS NOT NULL
				)";

	}

Expand full source code Collapse full source code

Top ↑

Changelog

Changelog
Version Description
6.0.5 Introduced.