Vote statistics & Report spam

Hi,

In the product vote & comments section, is it already possible to achieve the following:

• Vote Statistics: Display statistics of how many customers vote 1-star, 2-star, 3-star, and so on. (Refer to attached review-1.png)
• Report Spam: A function for customers to report a comment as spam.(Refer to attached review-2.png)

Hi,

You can edit the file "yourSite\components\com_hikashop\`views\product\view.html.php", and in the function "show()" add the code:

		$database = JFactory::getDBO();
		$query = 'SELECT vote_rating FROM '.hikashop_table('vote').' WHERE vote_ref_id = '.$product_id;
		$database->setQuery($query);
		$votes = $database->loadResultArray();
		$config = hikashop_config();
		$total_star = $config->get('vote_star_number');
		$rates = array();
		foreach($votes as $vote){
			for($i=1; $i <= $total_star; $i++){
				if($vote == $i){
					$rates[$i]++;
				}
			}
		}
		for($i=1; $i <= $total_star; $i++){
			if(!isset($rates[$i]) || $rates[$i] == null) $rates[$i] = 0;
		}
		krsort($rates);
		$this->assignRef('rates',$rates);

		if(empty($product_id)){
			if (is_object( $menu )) {
				jimport('joomla.html.parameter');
				$category_params = new HikaParameter( $menu->params );
				$product_id = $category_params->get('product_id');
				JRequest::setVar('product_id',$product_id);
			}
		}
		if(empty($product_id)){
			return;
		}

Thanks Xavier.

I've added the earlier code for view.html.php.

For the next part to add the variable "$this->rates", I'm not too familiar with what code to add. But is the code supposed to be something like this?

foreach($this->rates as $rates){echo $rates->.......}

The "......." part I'm not too sure what to call from. Are you able to guide on this?

Thanks.

Thanks for your guidance. The code works well!