WC_Tracker::get_review_counts() │ private static │ WC 1.0

Get review counts for different statuses.

Метод класса: WC_Tracker{}

Хуков нет.

Возвращает

Массив.

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

$result = WC_Tracker::get_review_counts();

Код WC_Tracker::get_review_counts() WC 9.6.0

woocommerce/includes/class-wc-tracker.php 
private static function get_review_counts() {
	global $wpdb;
	$review_count = array( 'total' => 0 );
	$status_map   = array(
		'0'     => 'pending',
		'1'     => 'approved',
		'trash' => 'trash',
		'spam'  => 'spam',
	);
	$counts       = $wpdb->get_results(
		"
		SELECT comment_approved, COUNT(*) AS num_reviews
		FROM {$wpdb->comments}
		WHERE comment_type = 'review'
		GROUP BY comment_approved
		",
		ARRAY_A
	);

	if ( ! $counts ) {
		return $review_count;
	}

	foreach ( $counts as $count ) {
		$status = $count['comment_approved'];
		if ( array_key_exists( $status, $status_map ) ) {
			$review_count[ $status_map[ $status ] ] = $count['num_reviews'];
		}
		$review_count['total'] += $count['num_reviews'];
	}

	return $review_count;
}