Howto sort posts by rating

Do you place this all in functions.php?

i did place it in my themes function.php but you can add it to any file that gets included inside a theme or customizations plugin as well.

@netzgestaltung Hello, I see your code. It will help me for sorting. But I need 3 sort method, like below
1. sort by most rating(max total rating count)
2. sort by highest avg rating
3. sort by lowest avg rating.

I am adding some query var for check condition. like if query var (mrr) then sort post by 1, then (har) for 2, then (lar) for 3.

can you please do something for it?
thanks

Update :

I am now using your function to set post meta , like avg, total and rating count
when a new comment is posted post meta value is updated but. when I delete the comment it is again updated post meta but the value increases not downgrade. can you please tell me where is my problem? Below is my modified code. I have put all into function PHP. I display post meta value in single.php for show result.


//new rating data save
// calculates average rating based on comment_meta 'rating'
function myPlugin_calculate_avg_rating($post_id = false){
if ( !function_exists('wpcr_avg_rating') ) {
return 0;
}
if ( !$post_id ) {
$post_id = get_the_ID();
}
$comments = get_approved_comments($post_id);
$sum = 0;
$avg = 0;
$count_rated = 0;
$oldavg = get_post_meta($post_id, '_kksr_avg',true);
$countold = get_post_meta($post_id, '_kksr_casts',true);
$oldtotal = get_post_meta($post_id, '_kksr_ratings',true);
foreach ( $comments as $comment ) {
$rating = get_comment_meta($comment->comment_ID, 'rating', true);
//var_dump($checkc);
if ( $rating ) {
$sum = $oldtotal + (int)$rating;
$count_rated++;
}

@netzgestaltung


• This reply was modified 5 years, 4 months ago by Faisal Ahmed.

hi, i will look into it tomorrow and post an update.

i took the calculation from the original shortcode, but maybe i put a bug into it.

thanks for the reply. I am fixed my abode code, it is now working for insert and delete a comment, but working avg and reviews count. not working for total star count. SO I have to commit total star count and do star count manually where I display the rating data. Here is my updated working code for avg and review count.


//new rating data save
// calculates average rating based on comment_meta 'rating'
function myPlugin_calculate_avg_rating($post_id = false){
if ( !function_exists('wpcr_avg_rating') ) {
return 0;
}
if ( !$post_id ) {
$post_id = get_the_ID();
}
$comments = get_approved_comments($post_id);
$sum = 0;
$avg = 0;
$count_rated = 0;
$oldavg = get_post_meta($post_id, '_kksr_avg',true);
$countold = get_post_meta($post_id, '_kksr_casts',true);
//$oldtotal = get_post_meta($post_id, '_kksr_ratings',true);
foreach ( $comments as $comment ) {
$rating = get_comment_meta($comment->comment_ID, 'rating', true);
if ( $rating ) {
$sum = $sum + (int)$rating;
$count_rated++;
}
}
if ($countold && $oldavg ){
$count_rated = $count_rated;
$sum = $sum;
$avg =round(($sum/$count_rated),2);
}
if ( $count_rated > 0 ) {
$count_rated = $count_rated;
$sum = $sum;
$avg = round(($sum/$count_rated),2);
}
return array($avg,$count_rated);
}
// add own rating avg function for better displaying
function myPlugin_avg_rating($atts) {
if ( !function_exists('wpcr_avg_rating') ) {
return '';
}
$a = shortcode_atts(array('title' => 'Rating',), $atts); // what is this good for?
$output = '';
$post_id = get_the_ID();
$avg = myPlugin_calculate_avg_rating($post_id); // now stored to post
$comment_count = wp_count_comments($post_id)->approved;
$wpcr_options = get_option('wpcr_settings');
$tooltip_inline = $wpcr_options['tooltip_inline'];
$avgrating_text = $wpcr_options['wpcravg_text'];
$avg_text = $avgrating_text == '' ? __( 'Average', 'wp-post-comment-rating' ) : $avgrating_text;
$avgText = __('average', 'wp-post-comment-rating');
$outOf = __('out of 5. Total', 'wp-post-comment-rating');
if ( $avg > 0 ) {
if ( $tooltip_inline == 1 ) {
$output = '<div class="wpcr_aggregate t"><span class="wpcr_stars" title="">'.$avg_text.':</span>';
$output .= '<span class="wpcr_averageStars" id="'.$avg.'"></span></div>';
}
if ( $tooltip_inline == 0 ) {
$output = '<div class="wpcr_aggregate ta"><span class="wpcr_stars" title="">'.$avg_text.':</span>';
$output .= '<span class="wpcr_averageStars" id="'.$avg.'"></span><span class="avg-inline">('.$avgText.': '.round($avg, 2).' '.$outOf.': '.$comment_count.')</span></div>';
}
}
return $output;
}
// add avg rating to post meta after a comment was written
// sets post_meta '_wpcr_rating' when new approved comment is posted
function myPlugin_comment_post($id, $approved){
if ($approved == 1){
myPlugin_post_meta_avg_rating(get_comment($id)->comment_post_ID);
//update_rrating_count(get_comment($id)->comment_post_ID);
//update_rrating_total(get_comment($id)->comment_post_ID);
}
}
add_action('comment_post', 'myPlugin_comment_post', 10, 2);
// sets post_meta '_wpcr_rating' when wp_set_comment_status is called
function myPlugin_wp_set_comment_status($id, $status){
//if($status =='approve'){
myPlugin_post_meta_avg_rating(get_comment($id)->comment_post_ID);
//update_rrating_count(get_comment($id)->comment_post_ID);
//update_rrating_total(get_comment($id)->comment_post_ID);
//}
}
add_action('wp_set_comment_status', 'myPlugin_wp_set_comment_status', 10, 2);
// sets post_meta '_wpcr_rating' when approved or deleted
function myPlugin_transition_comment_status($new_status, $old_status, $comment){
//if($new_status != $old_status){
myPlugin_post_meta_avg_rating($comment->comment_post_ID);
//update_rrating_count($comment->comment_post_ID);
//update_rrating_total($comment->comment_post_ID);
//}
}
add_action('transition_comment_status', 'myPlugin_transition_comment_status', 10, 3);
// sets post_meta '_wpcr_rating'
function myPlugin_post_meta_avg_rating($post_id){
$avg = myPlugin_calculate_avg_rating($post_id);
//if ( $action == 'insert') {
update_post_meta($post_id, '_kksr_avg', $avg[0]);
//update_post_meta($post_id, '_kksr_ratings', $avg[2]);
update_post_meta($post_id, '_kksr_casts', $avg[1]);
// }
}
// function update_rrating_count ($post_id) {
// $rcount = myPlugin_calculate_avg_rating($post_id);
// update_post_meta($post_id, '_kksr_casts', $rcount[1]);
// }
// function update_rrating_total ($post_id) {
// $rtt = myPlugin_calculate_avg_rating($post_id);
// update_post_meta($post_id, '_kksr_ratings', $rtt[2]);
// }


like avg, total and rating count
when a new comment is posted post meta value is updated but. when I delete the comment it is again updated post meta but the value increases not downgrade

i think that the behaviour you are describing ist OK when the comment you have deleted had low stars.

the new values are then being calculated on the rest of the approved comments because it only gets data from them.

maybe its questionable if all ever given stars should be kept but i thought it should only represent whats in the database right now.

if you like to keep the number of all ever posted comments (why deletion?) then you need another post_meta field that gets counted up whenever a comment gets postet

for more sort options one also will need more fields to store the data in

i added the code to my snippets repository here:
https://github.com/netzgestaltung/wordpress-snippets/blob/master/wp-post-rating_order-posts.php

i added documentation to it

i dont know if i will have time until friday to check the other orderby suggestions

i now added 2 functions + 1 action within

the hooked function at ‘save_post’ now saves the zero value of ‘_wpcr_rating’ to every post that gets saved.

it was neccesarry because WP_Query also filters posts when using orderby on meta_key/meta_value/meta_query arguments and sorting was not possible when having two clauses with EXISTS and NOT EXISTS compare operators

// sets post_meta '_wpcr_rating' to zero when not having comments
function myPlugin_save_post($post_id, $post, $update){
  if ( !$post->_wpcr_rating ) {
    update_post_meta($post_id, '_wpcr_rating', 0);
  }
}
add_action( 'save_post', 'myPlugin_save_post', 10, 3);

for an initial handling i added a function that saves the zero value once to all posts that does not have it.

// sets all existing posts '_wpcr_rating' meta field to zero, 
// customize the query args, only use once
function myPlugin_set_rating(){
  $args = array(
    'post_type' => 'my_post_type',
    'posts_per_page' => -1,
    'meta_query' => array(
      'rating_all' => array(
        'key' => '_wpcr_rating',
        'compare' => 'NOT EXISTS',
      ),
    ),
  );
  $query = new WP_Query($args);
  if ( $query->have_posts() ) {
    while ( $query->have_posts() ) {
      $query->the_post();
      update_post_meta(get_the_ID(), '_wpcr_rating', 0);
    }
    wp_reset_postdata();
  }
}

putted it together here: https://github.com/netzgestaltung/wordpress-snippets/blob/master/wp-post-rating_order-posts.php

• This reply was modified 5 years, 3 months ago by netzgestaltung.
• This reply was modified 5 years, 3 months ago by netzgestaltung.
• This reply was modified 5 years, 3 months ago by netzgestaltung.
• This reply was modified 5 years, 3 months ago by netzgestaltung.

Thanks for the reply. I already fix it for my project. For sorting I am using below codes.


// the query
//$paged = get_query_var('page') ? get_query_var('page') : 1;
$paged = get_query_var('paged') ? get_query_var('paged') : 1;
$sortby = get_query_var('sortby') ? get_query_var('sortby') : 'DESC';
if($sortby == "ASC"):
$orderby = "title";
else:
$orderby = "date";
endif;

";
// 					var_dump($gb_bundle_qry->request);
// 				  echo "

";
$sortarr = array ('ASC','mrv','hrr','lrr');