Automattic\WooCommerce\Internal\Admin\Schedulers

CustomersScheduler::exclude_existing_customers_from_query()public staticWC 1.0

Exclude users that already exist in our customer lookup table.

Meant to be hooked into pre_user_query

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

Хуков нет.

Возвращает

null. Ничего (null).

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

$result = CustomersScheduler::exclude_existing_customers_from_query( $wp_user_query );
$wp_user_query(WP_User_Query) (обязательный)
WP_User_Query to modify.

Код CustomersScheduler::exclude_existing_customers_from_query() WC 8.7.0

public static function exclude_existing_customers_from_query( $wp_user_query ) {
	global $wpdb;

	$wp_user_query->query_where .= " AND NOT EXISTS (
		SELECT ID FROM {$wpdb->prefix}wc_customer_lookup
		WHERE {$wpdb->prefix}wc_customer_lookup.user_id = {$wpdb->users}.ID
	)";
}