Get protected custom order item meta data array from WooCommerce order

MusicMan62
October 4, 2020
216 views
0 votes
2 Answers

I’am trying to use woocommerce_get_order_item_totals filter hook to add some extra information into the order totals (on orders and email notifications).

add_filter( 'woocommerce_get_order_item_totals', 'display_email_topay', 10, 2 );
function display_email_topay( $total_rows, $order ) {
    $total_rows['recurr_not'] = array(
       'label' => __( '2nd Installment:', 'woocommerce' ),
       'value'   => 'DATA NEEDS TO GO HERE' // <===
    );
    return $total_rows;
}

I have access to $order which contains the data I want to display but I have no idea how to get it.

Below is a var_dump (formatted) of $order variable:

I want to access:

[id] => 1499
[key] => _event_ticket_info
[value] => Array
    (
        [0] => Array
            (
                [ticket_name] => Adult
                [ticket_price] => 10
                [ticket_qty] => 1
                [max_qty] => 
                [event_date] => 2020-10-02 10:00:00
            )
    )

To calculate and get the cost from ticket_price by ticket_qty.

Is this possible? Any idea on how to get this specific order item meta data?

Answers

Chosen as BEST ANSWER

The answer of LoicTheAztec helped me solve the problem. This custom meta data array requires a 2nd foreach loop as $event_ticket_data is a multi dimensional array.

This is the working code:

add_filter( 'woocommerce_get_order_item_totals', 'display_email_topay', 10, 2 );
function display_email_topay( $total_rows, $order ) {
 
    $total_ticket=0;
    $total_service=0;
    
        // Loop through order items: get ticket costs
        foreach( $order->get_items() as $ticket ) {
            // Try to get "_event_ticket_info" item meta value (array)
            $event_ticket_data =  $ticket->get_meta('_event_ticket_info'); 
//          echo'<pre>';var_dump($event_ticket_data);echo '</pre><br><br>';
            
            foreach($event_ticket_data as $item) {
                extract($item);
                $total_ticket += $ticket_price * $ticket_qty;
//              echo '<br>'.$ticket_price.' x '.$ticket_qty;
            }
            
            $event_ticket_data =  $ticket->get_meta('_event_extra_service'); 
//          echo'<pre>';var_dump($event_ticket_data);echo '</pre><br><br>';
            
            foreach($event_ticket_data as $item) {
                extract($item);
                $total_service += $service_price * $service_qty;
//              echo '<br>'.$service_price.' x '.$service_qty;
            }           
        }
        
        // work out the cart_total and amount left to pay
        $cart_total = $total_ticket+$total_service;
        $second_installment_cost = $cart_total - $order->get_total();
        
        if ( $second_installment_cost > 0 ) {
            $total_rows['order_total'] = array(
               'label' => __( 'Order Total', 'woocommerce' ),
               'value'   => wp_strip_all_tags( wc_price($cart_total) )
            );
            $total_rows['order_topay'] = array(
               'label' => __( '2nd Installment', 'woocommerce' ),
               'value'   => wp_strip_all_tags( wc_price($second_installment_cost) )
            );
            $total_rows['cart_subtotal'] = array(
               'label' => __( 'To Pay', 'woocommerce' ),
               'value'   => wp_strip_all_tags( wc_price($order->get_total() ) )
            );
        }
        return $total_rows;

}

(Edit)

To get order item custom meta data, first you need to loop through order items, to be able to get that complex custom protected meta data using WC_Data method get_meta(). Then you will be able to get and calculate your "2nd installment cost as follows:

add_filter( 'woocommerce_get_order_item_totals', 'display_email_topay', 10, 2 );
function display_email_topay( $total_rows, $order ) {
    $second_installment_cost = 0; // Initializing

    // Loop through order items
    foreach( $order->get_items() as $item ) {
        // Try to get "_event_ticket_info" item meta value (array)
        $event_ticket_data =  $item->get_meta('_event_ticket_info');

        // Get the data from the array
        if( ! empty($event_ticket_data) ) {
            // extract / Import variables into the current symbol table from an array
            extract($event_ticket_data);
        }

        // if cost and quantity variables exist and have a value more than zero
        if( isset($ticket_price) && $ticket_price > 0 && isset($ticket_qty) && $ticket_qty > 0 ) {
            // Calculating and adding 2nd Installment cost item
            $second_installment_cost += $ticket_price * $ticket_qty;
        }
    }

    if ( $second_installment_cost > 0 ) {
        $total_rows['recurr_not'] = array(
           'label' => __( '2nd Installment', 'woocommerce' ),
           'value'   => wp_strip_all_tags( wc_price($second_installment_cost) )
        );
    }
    return $total_rows;
}

Code goes in functions.php file of your active child theme (or active theme). It should works.

Please signup or login to give your own answer.

Click here to cancel reply.