Sort comments on frontend product page

Is there any way to add an front-end option for users to sort the vote/comments on product page according to 3 things?

• Most Helpful
• Latest Comment
• Highest Rating

Hi hawkeyentjc,

Most helpful && Highest rating is the same thing, and latest comment is like date.

To do this, you will have to edit the file "yourSite/components/com_hikashop/views/vote/view.html.php" and in the function "listing()" add a variable like:

$sort_comments = JRequest::getString('sort_comment','');
if($sort_comments == "date"){
	$order = ' ORDER BY `vote_date` ASC';
}else if($sort_comments == "helpful"){
        $order=' ORDER BY `vote_useful` DESC, `vote_date` ASC';
}

if($vote_comment_sort == "date"){
	$order = ' ORDER BY `vote_date` ASC';
}

Hi Xavier,

I've added the lines to the view.html.php as you suggested.

As for adding the code in "vote / listing" to display the dropdown with the two options, will you be able help to provide some guidance on the coding? As I'm not too familiar with the codes. Thank you so much!

Hi nicolas,

I tried your method. In a way, it did work, but another issue came up.

Each time I select the option, it will refresh the page. However, if my shopping cart has 1 of item X before the page refreshes, it would duplicate the item X after the page refreshes. Meaning, after the page is refreshed, now my cart has 2 of items X, even though I didn't add to cart the item X.

Any solution for this?

Thanks.

Thanks Nicolas for the workaround. The page refresh no longer adds to cart.

There's another issue about the Select Option button. The default value is always "Latest Comment". Two things happen here:

1. Even if you click "Most Helpful", after the page refresh it returns to "Latest Comment" again.
2. Since that's the case, you have no way of selecting "Latest Comment" because it always appears there by default.

Hi,

Try this code in the view "vote / listing":

<?php
	$current_url = hikashop_currentURL();
	$set = JRequest::getString('sort_comment','');
	if(!empty($set))
		$current_url = preg_replace('/\/sort_comment-'.$set.'/','',$current_url); // If using SEF
		$current_url = preg_replace('/&sort_comment='.$set.'/','',$current_url); // If not using SEF
?>
<select name="sort_comment" onchange="document.location.href='<?php echo $current_url; ?>/sort_comment-'+this.value+''"> <!-- using SEF -->
<select name="sort_comment" onchange="document.location.href='<?php echo $current_url; ?>&sort_comment='+this.value+''"> <!-- not using SEF -->

<option <?php if($set == 'date')echo "selected"; ?> value="date">Latest Comment</option>
<option <?php if($set == 'helpful')echo "selected"; ?> value="helpful">Most helpful</option>
</select>