wordpress - 通过自定义字段（元数据）获取订单

Question

我想遍历我的订单并仅获取具有特定自定义字段和值的订单。

function lwb_5483845() {

    $args = array(
        'limit' => 9999,
        'return' => 'ids',
        'meta_query' => array(

            'key' => 'lwb_pickup_time_email_notification',
            'value' => '31-07-2022',
            'compare' => '=',
        ),
    );
    
    $query = new WC_Order_Query( $args );
    $orders = $query->get_orders();
    
    foreach( $orders as $order_id ) {
        echo $order_id . '<br />';
    }

}
add_filter( 'woocommerce_before_cart', 'lwb_5483845', 10, 2 );

标签： wordpresswoocommercemeta-query

Answer 1

meta_query索引需要是数组数组，因为您可以设置多个 where 语句：

function lwb_5483845() {

    $args = array(
        'limit' => 9999,
        'return' => 'ids',
        'meta_query' => array(
            array(
                'key' => 'lwb_pickup_time_email_notification',
                'value' => '31-07-2022',
                'compare' => '=',
            ),
        ),
    );
    
    $query = new WC_Order_Query( $args );
    $orders = $query->get_orders();
    
    foreach( $orders as $order_id ) {
        echo $order_id . '<br />';
    }

}
add_filter( 'woocommerce_before_cart', 'lwb_5483845', 10, 2 );