Function Reference: geodir_function_widget_listings_join

Summary

Listing query join clause SQL part for widgets.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

$plugin_prefix

(string) (required) Geodirectory plugin table prefix.

Default: None

Package

GeoDirectory

Parameters

$join

(string) (required) Join clause SQL.

Default: None

Return Values

(string)

• Modified join clause SQL.

Change Log

Since: 1.0.0

Source File

geodir_function_widget_listings_join() is located in geodirectory-functions/general_functions.php [Line: 2475]

Source Code

function geodir_function_widget_listings_join( $join ) {
	global $wpdb, $plugin_prefix, $gd_query_args_widgets;

	$query_args = $gd_query_args_widgets;
	if ( empty( $query_args ) || empty( $query_args['is_geodir_loop'] ) ) {
		return $join;
	}

	$post_type = empty( $query_args['post_type'] ) ? 'gd_place' : $query_args['post_type'];
	$table     = $plugin_prefix . $post_type . '_detail';

	if ( ! empty( $query_args['with_pics_only'] ) ) {
		$join .= " LEFT JOIN " . GEODIR_ATTACHMENT_TABLE . " ON ( " . GEODIR_ATTACHMENT_TABLE . ".post_id=" . $table . ".post_id AND " . GEODIR_ATTACHMENT_TABLE . ".mime_type LIKE '%image%' )";
	}

	if ( ! empty( $query_args['tax_query'] ) ) {
		$tax_queries = get_tax_sql( $query_args['tax_query'], $wpdb->posts, 'ID' );
		if ( ! empty( $tax_queries['join'] ) && ! empty( $tax_queries['where'] ) ) {
			$join .= $tax_queries['join'];
		}
	}

	return $join;
}