Automattic\WooCommerce\Blocks\StoreApi\Schemas

ProductCategorySchema::get_category_review_count() protected WC 1.0

Get total number of reviews for products in a category.

{} Это метод класса: ProductCategorySchema{}

Хуков нет.

Возвращает

int.

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

// protected - в коде основоного (родительского) или дочернего класса
$result = $this->get_category_review_count( $term );

$term(\WP_Term) (обязательный)

Term object.

Код ProductCategorySchema::get_category_review_count() ProductCategorySchema::get category review count ^{WC 5.5.2}

<?php
protected function get_category_review_count( $term ) {
	global $wpdb;

	$products_of_category_sql = $wpdb->prepare(
		"SELECT SUM( DISTINCT comment_count) as review_count
		FROM {$wpdb->posts} AS posts
		INNER JOIN {$wpdb->term_relationships} AS term_relationships ON posts.ID = term_relationships.object_id
		WHERE term_relationships.term_taxonomy_id=%d",
		$term->term_id
	);

	$review_count = $wpdb->get_var( $products_of_category_sql ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

	return (int) $review_count;
}