查询挂起的订单

Question

我想要一个mysql查询，以获得我所有的订单挂起状态。有人知道怎么做。

我在WoodPress网站上使用woocommerce，但我只希望mysql查询不带wordpress函数。

谢啦

Answer 1

我花了一个周末的时间在查询上，结果如下：

select
nombre,apellido,direccion,direccion2,codigo,poblacion,provincia,correo, telefono
from (
    select
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_first_name") as nombre,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_last_name") as apellido,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_address_1") as direccion,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_address_2") as direccion2,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_customer_user") as codigo,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_city") as poblacion,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_state") as provincia,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_email") as correo,
(select meta_value from wp_postmeta pm1 where p.ID = pm1.post_id and meta_key = "_billing_phone") as telefono

from
wp_posts AS p
    WHERE post_type = "shop_order" and id in (SELECT object_id
FROM wp_posts 
LEFT OUTER JOIN wp_term_relationships ON wp_posts.ID=wp_term_relationships.object_id 
WHERE post_type = "shop_order" 
AND term_taxonomy_id=9
)

) A

Answer 2

好吧，伙计们，这是一个奇怪的问题，但我通过简单地使用自定义查询来修复它。以某种方式添加“post\u status”=

所以我所做的是使用自定义查询并将挂起修改为wc挂起。

Answer 3

你真的应该使用内置的数据库函数，因为这符合Wordpress编码标准。

您可以查看WC_查询类。

或者你可以尝试下面这样的方法。您需要将元密钥更改为他们正在使用的任何元密钥。此外，元值可能不同于挂起，post_type可能不同于shop_order。

    $pending = new WP_Query(
        array(
            'post_type' => array('shop_order'),
            'meta_query' => array(
                array(
                    'key'   => 'status',
                    'value' => array('pending'),
                )
            )
        )
    );

下面是一个关于如何对WooCommerce订单进行元查询的示例。