Automattic\WooCommerce\Admin\API

ProductVariations::add_wp_query_filter() │ public static │ WC 1.0

Add in conditional search filters for variations.

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

Хуков нет.

Возвращает

Строку.

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

$result = ProductVariations::add_wp_query_filter( $where, $wp_query );
$where(строка) (обязательный)
Where clause used to search posts.
$wp_query(объект) (обязательный)
WP_Query object.

Код ProductVariations::add_wp_query_filter() WC 8.7.0

woocommerce/src/Admin/API/ProductVariations.php 
public static function add_wp_query_filter( $where, $wp_query ) {
	global $wpdb;

	$search = $wp_query->get( 'search' );
	if ( $search ) {
		$like       = '%' . $wpdb->esc_like( $search ) . '%';
		$conditions = array(
			$wpdb->prepare( "{$wpdb->posts}.post_title LIKE %s", $like ), // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			$wpdb->prepare( 'attr_search_meta.meta_value LIKE %s', $like ), // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		);

		if ( wc_product_sku_enabled() ) {
			$conditions[] = $wpdb->prepare( 'wc_product_meta_lookup.sku LIKE %s', $like );
		}

		$where .= ' AND (' . implode( ' OR ', $conditions ) . ')';
	}

	return $where;
}