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

Method of the class: CustomersScheduler{}

No Hooks.

Return

null. Nothing.

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() code WC 7.3.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
	)";
}