Alert: This function’s access is marked private. This means it is not intended for use by plugin or theme developers, only in other core functions. It is listed here for completeness.
WC_Tracker::get_review_counts()
Get review counts for different statuses.
Description Description
Return Return
(array)
Source Source
File: 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;
}