WC_REST_Products_Controller::add_search_criteria_to_wp_query_joinpublicWC 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 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;
}