Automattic\WooCommerce\Internal\Customers

SearchService::find_user_ids_by_billing_email_for_coupons_usage_lookup │ public │ WC 1.0

Searches users having the billing email (when applicable lookup orders as well) as specified and returns their id.

Method of the class: SearchService{}

No Hooks.

Returns

Int[].

Usage

$SearchService = new SearchService();
$SearchService->find_user_ids_by_billing_email_for_coupons_usage_lookup( $emails ): array;
$emails(string[]) (required)
Emails to search for.

SearchService::find_user_ids_by_billing_email_for_coupons_usage_lookup() code WC 10.3.6

woocommerce/src/Internal/Customers/SearchService.php 
public function find_user_ids_by_billing_email_for_coupons_usage_lookup( array $emails ): array {
	$emails = array_unique( array_map( 'strtolower', array_map( 'sanitize_email', $emails ) ) );

	$include_user_ids = array();
	if ( OrderUtil::custom_orders_table_usage_is_enabled() ) {
		global $wpdb;

		// phpcs:disable WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		$placeholders     = implode( ', ', array_fill( 0, count( $emails ), '%s' ) );
		$include_user_ids = $wpdb->get_col(
			$wpdb->prepare(
				"SELECT DISTINCT customer_id FROM %i WHERE billing_email IN ($placeholders)",
				OrdersTableDataStore::get_orders_table_name(),
				...$emails
			)
		);
		// phpcs:enable

		if ( array() === $include_user_ids ) {
			return array();
		}
	}

	$users_query = new \WP_User_Query(
		array(
			'fields'     => 'ID',
			'include'    => $include_user_ids,
			'meta_query' => array( // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query
				array(
					'key'     => 'billing_email',
					'value'   => $emails,
					'compare' => 'IN',
				),
			),
		)
	);
	return array_map( 'intval', array_unique( $users_query->get_results() ) );
}