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.

Метод класса: WC_REST_Products_Controller{}

Хуков нет.

Возвращает

Строку.

Использование

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

$join(строка) (обязательный)

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 ^{WC 9.9.4}

public function add_search_criteria_to_wp_query_join( $join ) {
	if ( $this->search_name_or_sku_tokens ) {
		if ( ! wc_product_sku_enabled() ) {
			// The argument is effectively a tokenized name search: we don't need to join the meta lookup table.
			return $join;
		}
	} elseif ( empty( $this->search_sku_arg_value ) || strstr( $join, 'wc_product_meta_lookup' ) ) {
		return;
	}

	global $wpdb;

	$join .= " LEFT JOIN $wpdb->wc_product_meta_lookup wc_product_meta_lookup
					ON $wpdb->posts.ID = wc_product_meta_lookup.product_id ";

	return $join;
}