تابع ووکامرسی wc_get_customer_last_order دریافت آخرین سفارشات مشتری

تابع ووکامرسی wc_get_customer_last_order – دریافت اطلاعات آخرین سفارشات مشتری

(WC_Order) wc_get_customer_last_order( (int) $customer_id ); 

if ( !function_exists( 'wc_get_customer_last_order' ) ) { 
    require_once ABSPATH . PLUGINDIR . 'woocommerce/includes/wc-user-functions.php'; 
} 
  
// The customer id. 
$customer_id = -1; 
  
// NOTICE! Understand what this does before running. 
$result = wc_get_customer_last_order($customer_id); 
    

function wc_get_customer_last_order( $customer_id ) { 
    global $wpdb; 
 
    $customer_id = absint( $customer_id ); 
 
    $id = $wpdb->get_var( "SELECT 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 = {$customer_id} 
        AND   posts.post_type = 'shop_order' 
        AND   posts.post_status IN ( '" . implode( "', '", array_keys( wc_get_order_statuses() ) ) . "' ) 
        ORDER BY posts.ID DESC 
    " ); 
 
    return wc_get_order( $id ); 
}