WC_REST_Products_Controller::add_search_criteria_to_wp_query_join() │ public │ WC 1.0

Join wc_product_meta_lookup table when SKU search query is present.

Method of the class: WC_REST_Products_Controller{}

No Hooks.

Return

String.

Usage

$WC_REST_Products_Controller = new WC_REST_Products_Controller();
$WC_REST_Products_Controller->add_search_criteria_to_wp_query_join( $join );

$join(string) (required)

Join clause used to search posts.

WC_REST_Products_Controller::add_search_criteria_to_wp_query_join() WC REST Products Controller::add search criteria to wp query join code ^{WC 8.7.0}

public function add_search_criteria_to_wp_query_join( $join ) {
	global $wpdb;
	if ( ! empty( $this->search_sku_in_product_lookup_table ) && ! strstr( $join, 'wc_product_meta_lookup' ) ) {
		$join .= " LEFT JOIN $wpdb->wc_product_meta_lookup wc_product_meta_lookup
					ON $wpdb->posts.ID = wc_product_meta_lookup.product_id ";
	}
	return $join;
}