You appear to be a bot. Output may be restricted

Description

Search the customers database via AJAX

Usage

$void = edd_ajax_customer_search();

Parameters

Returns

void

Source

File name: easy-digital-downloads/includes/ajax-functions.php
Lines:

function edd_ajax_customer_search() {
  global $wpdb;

  $search  = esc_sql( sanitize_text_field( $_GET['s'] ) );
  $results = array();
  $customer_view_role = apply_filters( 'edd_view_customers_role', 'view_shop_reports' );
  if ( ! current_user_can( $customer_view_role ) ) {
    $customers = array();
  } else {
    $select = "SELECT id, name, email FROM {$wpdb->prefix}edd_customers ";
    if ( is_numeric( $search ) ) {
      $where = "WHERE `id` LIKE '%$search%' OR `user_id` LIKE '%$search%' ";
    } else {
      $where = "WHERE `name` LIKE '%$search%' OR `email` LIKE '%$search%' ";
    }
    $limit = "LIMIT 50";

    $customers = $wpdb->get_results( $select . $where . $limit );
  }

  if( $customers ) {

    foreach( $customers as $customer ) {

      $results[] = array(
        'id'   => $customer->id,
        'name' => $customer->name . '(' .  $customer->email . ')'
      );
    }

  } else {

    $customers[] = array(
      'id'   => 0,
      'name' => __( 'No results found', 'easy-digital-downloads' )
    );

  }

  echo json_encode( $results );

  edd_die();
}
 

 View on GitHub View on Trac