Magento: Show Rating Summary Individually

This is the senario:

I have 5 ratings set up in the backend, and they are: Value, Looks, Usability, Quality and Portability

However, I need to get the summary votes (average) of each of the rating. An example will be: Value: 60% Looks: 50% Usability: 100% Quality: 90% Portability: 70%

The ratings and vote % are the summary/average of all the reviews for the product in the product page. Amazon.com is also using the same style for their ratings.

I can’t get it figured out because Magen开发者_开发知识库to seems to only offer the summary of all votes out of the box.

Can someone help? I’m kinda stuck at this. Thanks!

So to answer my own question, this was what I did.

app\code\local\Mage\Catalog\Block\Product\View\RatingSummary.php

class Mage_Catalog_Block_Product_View_RatingSummary extends Mage_Core_Block_Template
{
    public function getRatingAverages() {
        $rating = array();

        $product_id = Mage::registry('product')->getId();

        $resource = Mage::getSingleton('core/resource');
        $cn= $resource->getConnection('core_read');

        $sql = "select rt.rating_code, 
                avg(vote.percent) as percent from ".$resource->getTableName('rating_option_vote')." as vote 
                inner join ".$resource->getTableName('rating')." as rt
                on(vote.rating_id=rt.rating_id)
                inner join ".$resource->getTableName('review')." as rr
                on(vote.entity_pk_value=rr.entity_pk_value)
                where rt.entity_id=1 and vote.entity_pk_value=$product_id and rr.status_id=1
                group by rt.rating_code";
        $rating = $cn->fetchAll($sql);

        return $rating;
    }
}

I cannot find a way to get the rating individually using existing Magento APIs. Perhaps there are other ways, but I don’t know how. So I had to manually run pure SQL queries to the database which isn’t the best way to do it. Basically the above code returns the following:

rating_code => percent

Appearance => 80.6373%
Comfort => 83.2634%
Functionality => 79.7353%

So in my template, I use something similiar to display the result.

$rating_averages = $this=>getRatingAverages();
foreach($rating_averages as $rating) {
   echo $rating['rating_code'] . " => " . $rating['percent'];
}

Which should output the following:

Appearance => 80.6373%
Comfort => 83.2634%
Functionality => 79.7353%

Hope it helps anyone stuck in the same problem!

You are correct, Magento uses a straight non-weighted average to calculate overall reviews. This is also easy to relate to as a customer (the overall looks like an average). If you'd like to use weighted averages, you will need to change the code that Magento uses to calculate the average rating amount.

Once you've given some effort to that, feel free to come back with any questions you have on that process.

Hope that helps!

Thanks, Joe

I was looking for same thing.Here is my code.
<?php
$_reviewsCollection = Mage::getModel('review/review')->getCollection()
                ->addStoreFilter(Mage::app()->getStore()->getId())
                ->addStatusFilter('approved')
                ->addEntityFilter('product', $this->getProduct()->getId())
                ->setDateOrder()
                ->addRateVotes()
                ->load();
$_votesArray=array();
$_totalReview=0;
foreach ($_reviewsCollection->getItems() as $_review){   $_totalReview++;
$_votes = $_review->getRatingVotes(); 
    if (count($_votes)){
        foreach ($_votes as $_vote){
                $_votesArray[$_vote->getRatingCode()]=$_votesArray[$_vote->getRatingCode()]+$_vote->getPercent();
        }
    }
}
//print_r($_votesArray);    
?>

<ul>

<?php foreach ($_votesArray as $_key=>$_data){ ?>
                        <li><span><?php echo $_key ?>:</span>
                        <div class="rating-box">
                            <div class="rating" style="width:<?php echo $_data/$_totalReview ?>%"></div>
                        </div>
                        </li>
<?php } ?>  
</ul

Here's a plug-and-play solution for Value and Looks (just paste the code into review/product/view/list.phtml and work from there):

<?php
$_items = $this->getReviewsCollection()->getItems();
$valueRatings = array();
$looksRatings = array();
$valueAvg = '';
$looksAvg = '';

if (count($_items) > 0) {
  foreach ($_items as $review) {
    foreach($review->getRatingVotes() as $score) {
      switch ($score->getRatingCode()) {
        case 'Value':
          $valueRatings[] = $score->getPercent();
          break;
        case 'Looks':
          $looksRatings[] = $score->getPercent();
          break;
      }
    }
  }
  $valueAvg = array_sum($valueRatings) / count($valueRatings);
  $looksAvg = array_sum($looksRatings) / count($looksRatings);
}
?>
<p>VALUE Average: <?php echo $valueAvg ?></p>
<p>LOOKS Average: <?php echo $looksAvg ?></p>

Note that $score->getRatingCode() corresponds to the Rating Name in Magento Admin / Catalog / Reviews and Ratings / Manage Ratings.

You can get Rating collection using this code:

 $collection = Mage::getModel('rating/rating')
        ->getResourceCollection()
        ->addEntityFilter('product')
        ->setPositionOrder()
        ->setStoreFilter(Mage::app()->getStore()->getId())
        ->addRatingPerStoreName(Mage::app()->getStore()->getId())
        ->load();

$collection->addEntitySummaryToItem($_product->getId(), Mage::app()->getStore()->getId());

You can find this code in /app/code/core/Mage/Rating/Block/Entity/Detailed.php

And then display each rating:

<?php if(!empty($collection) && $collection->getSize()): ?>
<table class="ratings-table">
    <col width="1" />
    <col />
    <tbody>
        <?php foreach ($collection as $_rating): ?>
            <?php if($_rating->getSummary()): ?>
                <tr>
                    <th><?php echo $this->__($this->escapeHtml($_rating->getRatingCode())) ?></th>
                    <td>
                        <div class="rating-box">
                            <div class="rating" style="width:<?php echo ceil($_rating->getSummary()) ?>%;"></div>
                        </div>
                    </td>
                </tr>
            <?php endif; ?>
        <?php endforeach; ?>
    </tbody>
</table>

By using database with review id

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$rating_option_vote = $resource->getTableName('rating_option_vote'); //gives table name with prefix
$review_id = 1;
//Select Data from table
$sql_review = "Select * FROM " . $rating_option_vote ." where `review_id` =".$review_id;
$result_review = $connection->fetchAll($sql_review); // gives associated array, table fields as key in array.
$percentage = 0;
if(!empty($result_review)){
    $percentage = $result_review[0]['percent'];
}
echo $percentage;