WC_REST_Products_V4_Controller::add_search_criteria_to_wp_query_where │ public │ WC 1.0

Add a where clause for matching the SKU field.

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

Хуков нет.

Возвращает

Строку.

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

$WC_REST_Products_V4_Controller = new WC_REST_Products_V4_Controller();
$WC_REST_Products_V4_Controller->add_search_criteria_to_wp_query_where( $where );

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

Where clause used to search posts.

Код WC_REST_Products_V4_Controller::add_search_criteria_to_wp_query_where() WC REST Products V4 Controller::add search criteria to wp query where ^{WC 10.3.4}

public function add_search_criteria_to_wp_query_where( $where ) {
	global $wpdb;

	if ( $this->search_fields_tokens ) {
		$where .= $this->build_dynamic_search_clauses(
			$this->search_fields_tokens['tokens'],
			$this->search_fields_tokens['fields']
		);
	} elseif ( $this->search_name_or_sku_tokens ) {
		$searchable_fields = wc_product_sku_enabled() ? array( 'name', 'sku' ) : array( 'name' );
		$where            .= $this->build_dynamic_search_clauses(
			$this->search_name_or_sku_tokens,
			$searchable_fields
		);
	} elseif ( ! empty( $this->search_sku_arg_value ) ) {
		$like_search = '%' . $wpdb->esc_like( $this->search_sku_arg_value ) . '%';
		$where      .= ' AND ' . $wpdb->prepare( '(wc_product_meta_lookup.sku LIKE %s)', $like_search );
	}
	return $where;
}