#woocommerce #metadata #orders
#woocommerce #метаданные #заказы
Вопрос:
Я хочу вернуть все метаданные для каждого заказа по идентификатору продукта, связанному с текущим пользователем. Я пробовал различные методы, которые возвращают пустые массивы. Я ищу доступ к метаданным идентификатора, ключа и значения
Кто-нибудь подсказывает, где я ошибаюсь? Спасибо
$table_posts = $wpdb->prefix . "posts";
$table_items = $wpdb->prefix . "woocommerce_order_items";
$table_itemmeta = $wpdb->prefix . "woocommerce_order_itemmeta";
$orders_statuses = "'wc-completed', 'wc-processing', 'wc-on-hold'";
$orders_ids = $wpdb->get_col("
SELECT $table_items.order_id
FROM $table_itemmeta, $table_items, $table_posts
WHERE $table_items.order_item_id = $table_itemmeta.order_item_id
AND $table_items.order_id = $table_posts.ID
AND $table_posts.post_status IN ( $orders_statuses )
AND $table_itemmeta.meta_key LIKE '_product_id'
AND $table_itemmeta.meta_value LIKE '$product_id'
ORDER BY $table_items.order_item_id DESC"
);
Приведенный выше запрос возвращает правильные идентификаторы заказа, указанные ниже.
Array
(
[0] => 881
[1] => 708
)
Мой цикл по всем заказам
foreach ($orders_ids as $key => $value) {
$orders = wc_get_order($value);
foreach ($orders->get_items() as $item ){
$item_meta = $item->get_meta();
$item_meta_data = $item->get_meta_data();
$item_formatted_data = $item->get_formatted_meta_data();
$item_formatted_data_true = $item->get_formatted_meta_data( '_', true );
print_r($item_meta); // returns empty array
print_r($item_meta_data); // returns example below
print_r($item_formatted_data); // returns empty array
print_r($item_formatted_data_true); // returns empty array
}
}
Это мой вывод с использованием этого кода выше
Array
(
[0] => WC_Meta_Data Object
(
[current_data:protected] => Array
(
[id] => 646
[key] => yith_booking_data
[value] => Array
(
[from] => 1603152000
[to] => 1603411200
[duration] => 3
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1602161920
)
)
[data:protected] => Array
(
[id] => 646
[key] => yith_booking_data
[value] => Array
(
[from] => 1603152000
[to] => 1603411200
[duration] => 3
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1602161920
)
)
)
[1] => WC_Meta_Data Object
(
[current_data:protected] => Array
(
[id] => 647
[key] => _booking_id
[value] => 882
)
[data:protected] => Array
(
[id] => 647
[key] => _booking_id
[value] => 882
)
)
)
Array
(
[0] => WC_Meta_Data Object
(
[current_data:protected] => Array
(
[id] => 451
[key] => yith_booking_data
[value] => Array
(
[from] => 1600905600
[to] => 1600992000
[duration] => 1
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1600955166
)
)
[data:protected] => Array
(
[id] => 451
[key] => yith_booking_data
[value] => Array
(
[from] => 1600905600
[to] => 1600992000
[duration] => 1
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1600955166
)
)
)
[1] => WC_Meta_Data Object
(
[current_data:protected] => Array
(
[id] => 452
[key] => _booking_id
[value] => 709
)
[data:protected] => Array
(
[id] => 452
[key] => _booking_id
[value] => 709
)
)
)
Ответ №1:
Нашел ответ. Используйте этот код в цикле
foreach ($orders_ids as $key => $value) {
$orders = wc_get_order($value);
foreach ($orders->get_items() as $item ){
$item_meta_data = $item->get_meta_data();
$item_key_meta = $item_meta_data[0]->value; <- add code
print_r($item_key_meta);
}
}
ВОЗВРАТ
Array
(
[from] => 1603152000
[to] => 1603411200
[duration] => 3
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1602161920
)
Array
(
[from] => 1600905600
[to] => 1600992000
[duration] => 1
[person_types] => Array
(
)
[booking_services] => Array
(
)
[booking_service_quantities] => Array
(
)
[_added-to-cart-timestamp] => 1600955166
)