| Server IP : 185.124.137.183 / Your IP : 216.73.216.135 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /proc/./self/root/var/cache/hostinger-wp-cli-packages/src/Woocommerce/ |
Upload File : |
<?php
namespace Hostinger\WPCLI\Woocommerce;
/**
* Shared helpers for streaming WooCommerce orders in batches.
*
* Fetching orders with 'limit' => -1 loads every matching order object into memory at
* once, which makes peak memory grow with the shop's order history. These helpers keep
* memory proportional to the batch size instead.
*/
trait PaginatesOrders {
/**
* Yield orders matching $query_args one batch at a time.
*
* Orders are sorted by ID so that offset based paging stays stable — sorting by a
* non-unique column allows rows with equal values to move between batches, which
* would silently skip or double count orders.
*
* @return \Generator<\WC_Order>
*/
protected function iterate_orders( array $query_args, int $batch_size = 100 ): \Generator {
$offset = 0;
do {
$orders = wc_get_orders(
array_merge(
$query_args,
[
'limit' => $batch_size,
'offset' => $offset,
'orderby' => 'ID',
'order' => 'ASC',
'paginate' => false,
]
)
);
if ( ! is_array( $orders ) ) {
return;
}
$fetched = count( $orders );
foreach ( $orders as $order ) {
if ( $order instanceof \WC_Order ) {
yield $order;
}
}
unset( $orders, $order );
$offset += $batch_size;
$this->free_memory();
} while ( $fetched === $batch_size );
}
/**
* Drop the caches WordPress and WooCommerce fill up while loading orders.
*
* Without this the object cache keeps every order, order item and meta row from
* previous batches alive, so paging alone would not bound memory usage.
*/
protected function free_memory(): void {
if ( function_exists( '\WP_CLI\Utils\wp_clear_object_cache' ) ) {
\WP_CLI\Utils\wp_clear_object_cache();
return;
}
global $wpdb, $wp_object_cache;
if ( isset( $wpdb ) ) {
$wpdb->queries = [];
}
if ( ! is_object( $wp_object_cache ) ) {
return;
}
foreach ( [ 'group_ops', 'stats', 'memcache_debug', 'cache' ] as $property ) {
if ( property_exists( $wp_object_cache, $property ) ) {
$wp_object_cache->$property = [];
}
}
if ( is_callable( [ $wp_object_cache, '__remoteset' ] ) ) {
$wp_object_cache->__remoteset();
}
}
}