wc_update_product_lookup_tables_rating_count_batch() WC 3.6.2

Populate a batch of rating count lookup table data for products.

Хуков нет.

Возвращает

Null. Ничего.

Использование

wc_update_product_lookup_tables_rating_count_batch( $offset, $limit );

$offset(массив)

Offset to query.
По умолчанию: 0

$limit(массив)

Limit to query.
По умолчанию: 0

Список изменений

Код wc_update_product_lookup_tables_rating_count_batch() wc update product lookup tables rating count batch ^{WC 4.5.2}

<?php
function wc_update_product_lookup_tables_rating_count_batch( $offset = 0, $limit = 0 ) {
	global $wpdb;

	if ( ! $limit ) {
		return;
	}

	$rating_count_rows = $wpdb->get_results(
		$wpdb->prepare(
			"
			SELECT post_id, meta_value FROM {$wpdb->postmeta}
			WHERE meta_key = '_wc_rating_count'
			AND meta_value != ''
			AND meta_value != 'a:0:{}'
			ORDER BY post_id ASC
			LIMIT %d, %d
			",
			$offset,
			$limit
		),
		ARRAY_A
	);

	if ( $rating_count_rows ) {
		wc_update_product_lookup_tables_rating_count( $rating_count_rows );
		WC()->queue()->schedule_single(
			time() + 1,
			'wc_update_product_lookup_tables_rating_count_batch',
			array(
				'offset' => $offset + $limit,
				'limit'  => $limit,
			),
			'wc_update_product_lookup_tables'
		);
	}
}