Automattic\WooCommerce\Admin\API
ProductVariations::add_wp_query_join
Join posts meta tables when variation search query is present.
Метод класса: ProductVariations{}
Хуков нет.
Возвращает
Строку.
Использование
$result = ProductVariations::add_wp_query_join( $join, $wp_query );
- $join(строка) (обязательный)
- Join clause used to search posts.
- $wp_query(объект) (обязательный)
- WP_Query object.
Код ProductVariations::add_wp_query_join() ProductVariations::add wp query join WC 11.0.1
public static function add_wp_query_join( $join, $wp_query ) {
global $wpdb;
$search = $wp_query->get( 'search' );
if ( $search ) {
$join .= " LEFT JOIN {$wpdb->postmeta} AS attr_search_meta
ON {$wpdb->posts}.ID = attr_search_meta.post_id
AND attr_search_meta.meta_key LIKE 'attribute_%' ";
}
if ( wc_product_sku_enabled() && ! 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;
}