WC_Tracker::get_review_counts │ private static │ WC 1.0

Get review counts for different statuses.

Method of the class: WC_Tracker{}

No Hooks.

Returns

Array.

Usage

$result = WC_Tracker::get_review_counts();

WC_Tracker::get_review_counts() WC Tracker::get review counts code ^{WC 10.5.0}

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;
}