WC_Customer_Data_Store::get_last_order( WC_Customer $customer )
Gets the customers last order.
Description Description
Parameters Parameters
- $customer
-
(Required) Customer object.
Return Return
(WC_Order|false)
Source Source
File: includes/data-stores/class-wc-customer-data-store.php
public function get_last_order( &$customer ) { global $wpdb; $last_order = $wpdb->get_var( // phpcs:disable WordPress.DB.PreparedSQL.NotPrepared "SELECT posts.ID FROM $wpdb->posts AS posts LEFT JOIN {$wpdb->postmeta} AS meta on posts.ID = meta.post_id WHERE meta.meta_key = '_customer_user' AND meta.meta_value = '" . esc_sql( $customer->get_id() ) . "' AND posts.post_type = 'shop_order' AND posts.post_status IN ( '" . implode( "','", array_map( 'esc_sql', array_keys( wc_get_order_statuses() ) ) ) . "' ) ORDER BY posts.ID DESC" // phpcs:enable ); if ( ! $last_order ) { return false; } return wc_get_order( absint( $last_order ) ); }
Changelog Changelog
Version | Description |
---|---|
3.0.0 | Introduced. |