Magento – Get Product Name and Stars in All Reviews Page

magento-1.9

At the moment i have this piece of code working, with a little help. But last thing is that i would like the product name to show instead of the product id numberand i would like to show the stars given in the review. Thanks for helping.

<?php 
$Collection=Mage::getModel('review/review')->getCollection() 
->setPageSize(5) 
->addStoreFilter(Mage::app()->getStore()->getId()) 
->addStatusFilter(Mage_Review_Model_Review::STATUS_APPROVED) 
->addRateVotes() 
->setDateOrder(); 

$_items = array_reverse( $Collection->getItems()); 
foreach ($_items as $_review): 
$productId = $_review->getentity_pk_value(); 
$_review->getTitle(); 
$_votes = $_review->getRatingVotes(); 
$_review->getDetail(); 
$this->formatDate($_review->getCreatedAt()); 
$this->__('[Posted %s]', $this->formatDate($_review->getCreatedAt()), 'long'); 
echo "<ul><h3>".$productId = $_review->getentity_pk_value()."</h3>";
echo "<li><h4>".$_review->getTitle()."</h4></li>"; 
echo "<li>".$_review->getDetail()."</li>";
echo "<li>". $this->formatDate($_review->getCreatedAt())."</li>"; 
endforeach; 
?>

Best Answer

I have just had a look at the code for this within:

template/review/product/view/list.phtml

Then added the ratings from here to your code. Replace your code within your phtml file with below:

<?php 
$Collection=Mage::getModel('review/review')->getCollection() 
    ->setPageSize(5) 
    ->addStoreFilter(Mage::app()->getStore()->getId()) 
    ->addStatusFilter(Mage_Review_Model_Review::STATUS_APPROVED) 
    ->addRateVotes() 
    ->setDateOrder('created_at', 'asc'); 
$_items = array_reverse( $Collection->getItems());

foreach ($_items as $_review): 
    $productId = $_review->getentity_pk_value(); 
    $current_product=Mage::getModel('catalog/product')->load($productId);
    echo '<a href="' . $current_product->getProductUrl() . '"><h2>' . $current_product->getName() . '</h2></a>';
    echo $_review->getTitle(); 
    echo $_review->getDetail();
    echo $this->formatDate($_review->getCreatedAt()); 
    $_votes = $_review->getRatingVotes();
    if (count($_votes)): ?>
        <table class="ratings-table">
        <colgroup>
            <col class="review-label" />
            <col class="review-value" />
        </colgroup>
        <tbody>
            <?php foreach ($_votes as $_vote): ?>
            <tr>
                <th><?php echo $this->escapeHtml($_vote->getRatingCode()) ?></th>
                <td>
                    <div class="rating-box">
                        <div class="rating" style="width:<?php echo $_vote->getPercent() ?>%;"></div>
                    </div>
                </td>
            </tr>
            <?php endforeach; ?>
        </tbody>
        </table>
    <?php endif; ?>
<?php endforeach; ?>

Related Solutions

Magento – how to get all attributes name and value from configurable product

load config product:

   $currentProduct = Mage::getModel('catalog/product_type_configurable')->setProduct($this->getProduct());;

    $products = array();

        $skipSaleableCheck = Mage::helper('catalog/product')->getSkipSaleableCheck();

getting all all simple products

    $allProducts = $conf->getTypeInstance(true)
            ->getUsedProducts(null, $conf);

    foreach ($allProducts as $product) {
        $products[] =  $product;
    }
        getting all configurable attribute of that products
        $AllowAttributes=$conf->getTypeInstance(true)
            ->getConfigurableAttributes($conf);

Getting config attribute for this product by attribute value id and label

    foreach ($products as $product) {
       foreach ($AllowAttributes as $attribute) {

            $productAttribute   = $attribute->getProductAttribute();
            $productAttributeId = $productAttribute->getId();
            $attributeValue     = $product->getData($productAttribute->getAttributeCode());
            /* Simple Product data */

            /* getting option text value */
            if ($productAttribute->usesSource()) {
                 $MYabel = $productAttribute->getSource()->getOptionText($attributeValue );
            }else{
                 $MYabel='';
            }


        }
    }

Magento – Create invoice and shipment in magento via cron based on store view and order age

user1618341,According magento an order can place from one store,Magento is save order store id at sales_flat_order,sales_flat_grid order.

At your collection you need get store_id.Also need rectify collection query,Please use * instead of some field

<?php
    try {
        $orders = Mage::getModel('sales/order')->getCollection()
            ->addFieldToFilter(
                'status',
                array(
                    'nin' => array('complete', 'canceled', 'processing', 'holded', 'fraud'),
                    'in' => 'pending',
                ))
            ->addAttributeToSelect('store_id')
            ->addAttributeToSelect('status');
    }
catch (Mage_Core_Exception $e) {
}

I have put the condition to skip create shipment for one store view[if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):]

see code:

try {

    foreach ($orders as $eachorder) {


        $order = Mage::getModel("sales/order")->load($eachorder->getId());
        if (!$order->canInvoice()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.'));
        }
        $invoice = Mage::getModel('sales/service_order', $order)->prepareInvoice();
        if (!$invoice->getTotalQty()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.'));
        }
        $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_ONLINE);
        $invoice->register();
        $transactionSave = Mage::getModel('core/resource_transaction')
            ->addObject($invoice)
            ->addObject($invoice->getOrder());
        $transactionSave->save();
        /* put code for skip for one store */
        if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):

            $shipment = $order->prepareShipment();

            if ($shipment) {
                $shipment->register();
                $order->setIsInProcess(true);

                $transaction_save = Mage::getModel('core/resource_transaction')
                    ->addObject($shipment)
                    ->addObject($shipment->getOrder())
                    ->save();
            } else {
                throw new Exception("Cant get shipment");
            }
        endif;

        $order->setState(Mage_Sales_Model_Order::STATE_COMPLETE);
        $order->save();
    }

}catch (Mage_Core_Exception $e) {

}

If you getting the issues for create invoice and shipment,Please see my Blog:

Create invoice:

Create Shipment:

Best Answer

Related Solutions

Magento – how to get all attributes name and value from configurable product

Magento – Create invoice and shipment in magento via cron based on store view and order age

Related Topic