How to get latest note on the order at woocommerce?

Watson

I need to send SMS to the customer when the order is placed in the (processing) position , How to get the last note in the order and put it in the ( %comment% ) key?

 if ( isset( $this->options['wc_notify_customer_payment_successful_enable'] ) ) {
        add_action( 'woocommerce_order_status_processing', array( &$this, 'successful_payment_notification_client' ) );
    }



* WooCommerce Successful payment notification client 
 *
 * @param $checkout
 */
public function successful_payment_notification_client ( $order_id ) {
    // Check the mobile field is empty
    if ( empty( $_REQUEST['mobile'] ) ) {
        return;
    }

    $order          = new WC_Order( $order_id );
    $this->sms->to  = array( $_REQUEST['mobile'] );
    $template_vars  = array(
        '%order_id%'           => $order_id,
        '%order_number%'       => $order->get_order_number(),
        '%status%'             => $order->get_status(),
        '%billing_first_name%' => $_REQUEST['billing_first_name'],
        '%billing_last_name%'  => $_REQUEST['billing_last_name'],
        '%comment%'            => **What I say is here**
    );
    $message        = str_replace( array_keys( $template_vars ), array_values( $template_vars ), $this->options['wc_notify_customer_payment_successful_message'] );
    $this->sms->msg = $message;
    $this->sms->SendSMS();
}

anderson

I would suggest you to use the WordPress function get_comments() to get the last note

$args = array(
    'post_id' => $order_id,
    'orderby' => 'comment_ID',
    'order'   => 'DESC',
    'approve' => 'approve',
    'type'    => 'order_note',
    'number'  => 1
);

remove_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10, 1 );

$notes = get_comments( $args );

add_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10, 1 );

While calling the get_comments function woocommerce removes order notes by default. For avoiding this you need to remove the filter, call get_comments()and add the filter again.