如何显示单个产品的所有订单,显示最新订单?Woocommerce

以下是我根据这些文章提出的解决方案:

• http://www.wpbeginner.com/wp-themes/how-to-create-a-custom-page-in-wordpress/#
• https://wordpress.org/support/topic/how-to-show-all-orders-details-for-specific-or-particular-product-in-woocommerce-1/
• https://www.gavick.com/blog/wp_query-woocommerce-products

解决方案

<?php /* Template Name: CustomPageT1 */ ?>
<?php
global $wpdb;
$produto_id = 41; // Product ID
$consulta = "SELECT order_id " .
            "FROM {$wpdb->prefix}woocommerce_order_itemmeta woim " .
            "LEFT JOIN {$wpdb->prefix}woocommerce_order_items oi " .
            "ON woim.order_item_id = oi.order_item_id " .
            "WHERE meta_key = '_product_id' AND meta_value = %d " .
            "GROUP BY order_id;";

$order_ids = $wpdb->get_col( $wpdb->prepare( $consulta, $produto_id ) );

foreach( $order_ids as $order_id ) {
    var_dump($order_id);
}

if( $order_ids ) {
    $args = array(
        'post_type' => 'shop_order',
        'post__in' => $order_ids,
        'post_status' => 'publish',
        'posts_per_page' => 20,
        'order' => 'DESC',
        'tax_query' => array(
            array(
                'taxonomy' => 'shop_order_status',
                'field' => 'slug',
                'terms' => array (
                    'Pending' , 'Failed' , 'Processing' , 'Completed', 'On-Hold' , 'Cancelled' , 'Refunded'
                )
            )
        )
    );
    $wc_query = new WP_Query( $args );
}

?>

// Display products
<div>
    <?php if ($wc_query->have_posts()) : ?>
    <?php while ($wc_query->have_posts()) : // (4)
                    $wc_query->the_post(); // (4.1) ?>

    <ul>
        <li>
            <?php the_title(); // (4.2) ?>
        </li>
    </ul>

    <?php endwhile; ?>
    <?php wp_reset_postdata(); // (5) ?>
    <?php else:  ?>
    <p>
         <?php _e( 'No Orders' ); // (6) ?>
    </p>
    <?php endif; ?>
</div>