Automattic\WooCommerce\Internal\Admin\Schedulers

CustomersScheduler::exclude_existing_customers_from_query() │ public static │ WC 1.0

Exclude users that already exist in our customer lookup table.

Meant to be hooked into pre_user_query

Method of the class: CustomersScheduler{}

No Hooks.

Return

null. Nothing (null).

Usage

$result = CustomersScheduler::exclude_existing_customers_from_query( $wp_user_query );

$wp_user_query(WP_User_Query) (required)

WP_User_Query to modify.

CustomersScheduler::exclude_existing_customers_from_query() CustomersScheduler::exclude existing customers from query code ^{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
	)";
}