Review – How to Set the Date of a Review Programmatically

review

I am trying to import some reviews programatically. I am using the following code:

$review = Mage::getModel('review/review');
$review->setEntityPkValue($product->getId());
$review->setStatusId(1);
$review->setTitle("title");
$review->setDetail("detail");
$review->setEntityId(1);                                      
$review->setStoreId(Mage::app()->getStore()->getId());                    
$review->setStatusId(1);
$review->setCustomerId(NULL);
$review->setNickname("nickname");
$review->setReviewId($review->getId());
$review->setStores(array(Mage::app()->getStore()->getId()));
$review->setCreatedAt(Mage::getModel('core/date')->gmtTimestamp($date));
$review->save();
$review->aggregate();

$date is a timestamp of the date of the review.
The problem is that my reviews are being imported at the current date. How can I set the created_at parameter?

Best Answer

The problem is that the _beforeSave on the Mage_Review_Model_Resource_Review sets the created_at value when there is no id for the review, so for new reviews.

protected function _beforeSave(Mage_Core_Model_Abstract $object)
{
    if (!$object->getId()) {
        $object->setCreatedAt(Mage::getSingleton('core/date')->gmtDate());
    }
    if ($object->hasData('stores') && is_array($object->getStores())) {
        $stores = $object->getStores();
        $stores[] = 0;
        $object->setStores($stores);
    } elseif ($object->hasData('stores')) {
        $object->setStores(array($object->getStores(), 0));
    }
    return $this;
}

You could do one of the following:

Rewrite the resource and change the function,
Save first and then save again
There may be another option that I cannot think of at the moment :(

Related Solutions

Magento 1.7 – How Does the Database Structure Connect Review Summaries to Review Details?

The review_entity_summary table keeps the general scores of a product. The ones you see in the list of products.

They are calculated and stored in this table when a review is approved (I think).

The link between the reviews and the scores are kept in the table rating_option_vote.
You have 4 important columns:

entity_pk_value (that's basically the product id)

rating_id (you can have multiple rating criteria)

review_id (this is what you are looking for)

percent (the review score).

The values from this table are displayed in the list of reviews for a product.

Magento 1.9 – Set Custom Star Review Rating as Required Entry

I did same thing but the different way. Instead of putting required-entry class to radio, I add new validation rule to that form.

Please put below code in your review form page, it might be work for you:

<script type="text/javascript">
    //<![CDATA[
    var dataForm = new VarienForm("review-form", true);

    Validation.addAllThese(
            [
                ['validate-rating', '<?php echo $this->__('Please select one of each of the ratings above') ?>', function (v) {
                            return false;

                }]
            ]
            );
    //]]>
</script>

Here is the output of validation:

Let me know if you have query for the same.

For single rating option:

Best Answer

Related Solutions

Magento 1.7 – How Does the Database Structure Connect Review Summaries to Review Details?

Magento 1.9 – Set Custom Star Review Rating as Required Entry

Related Topic