Automattic\WooCommerce\Admin\API\Reports\Customers

DataStore::get_oldest_orders │ public static │ WC 1.0

Retrieve the oldest orders made by a customer.

Method of the class: DataStore{}

No Hooks.

Returns

Array. Orders.

Usage

$result = DataStore::get_oldest_orders( $customer_id );
$customer_id(int) (required)
Customer ID.

DataStore::get_oldest_orders() code WC 10.3.3

woocommerce/src/Admin/API/Reports/Customers/DataStore.php 
public static function get_oldest_orders( $customer_id ) {
	global $wpdb;
	$orders_table                = $wpdb->prefix . 'wc_order_stats';
	$excluded_statuses           = array_map( array( __CLASS__, 'normalize_order_status' ), self::get_excluded_report_order_statuses() );
	$excluded_statuses_condition = '';
	if ( ! empty( $excluded_statuses ) ) {
		$excluded_statuses_str       = implode( "','", $excluded_statuses );
		$excluded_statuses_condition = "AND status NOT IN ('{$excluded_statuses_str}')";
	}

	return $wpdb->get_results(
		$wpdb->prepare(
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			"SELECT order_id, date_created FROM {$orders_table} WHERE customer_id = %d {$excluded_statuses_condition} ORDER BY date_created, order_id ASC LIMIT 2",
			$customer_id
		)
	);
}