我需要显示一个特定类别的所有产品的审查计数.下面的代码计算所有产品的所有 comments (作为 comments )，但是似乎没有设置get_comments()来允许分类查询……
function rnr_colors_review_count() {
$args = array(
'post_type' => 'product', //Post type
'status' => 'approve',
'count' => 'true'
//I would like to insert a taxonomy arg here, but may need another solution.
);
$comments_count = get_comments($args);
echo 'Total Comments= ' . $comments_count;
}
您需要使用定制的轻量级SQL查询.我已经将该SQL查询嵌入到下面的函数中，并带有一个参数:产品类别term slug.
功能:
function get_products_reviews_count_from_category( $term_slug ){
global $wpdb;
return $wpdb->get_var( $wpdb->prepare( "
SELECT COUNT(c.comment_post_ID)
FROM {$wpdb->prefix}comments as c
LEFT JOIN {$wpdb->prefix}posts as p ON c.comment_post_ID = p.ID
LEFT JOIN {$wpdb->prefix}term_relationships as tr ON p.ID = tr.object_id
LEFT JOIN {$wpdb->prefix}term_taxonomy as tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN {$wpdb->prefix}terms as t ON tt.term_id = t.term_id
WHERE c.comment_type = 'review' AND c.comment_approved = '1'
AND p.post_type = 'product' AND p.post_status = 'publish'
AND tt.taxonomy = 'product_cat' AND t.slug = '%s'
", $term_slug ) );
}
代码位于您的子主题的unctions.php文件中(或在插件中).经过测试和工作.
Usage example显示"附件"产品类别术语Slug的 comments 计数:
printf(
'<p class="reviews-count">'.__('Reviews count for %s category: %d', 'woocommerce').'<p>',
__('Accessories', 'woocommerce'),
get_products_reviews_count_from_category( 'accessories' )
);