<?php

namespace App\ECommerce\Product\Review;

use Qs_Db;
use Zend_Db_Select;

class Obj extends AbstractObj
{
    protected function _getFromDbSelect($primaryKey)
    {
        $select = parent::_getFromDbSelect($primaryKey);
        $this->_joinProduct($select);
        return $select;
    }

    protected function _filter(Zend_Db_Select $select)
    {
        parent::_filter($select);
        $select->where('`' . $this->_tableAlias . '`.`statusId` = ?', Entity::STATUS_APPROVED);
        $select->where('`' . $this->_tableAlias . '`.`productId` = ?', $this->getProductId(), Qs_Db::INT_TYPE);
        return $this;
    }

    public function getObjectInfo()
    {
        $data = parent::getObjectInfo();
        if ($data) {
            $data['itemTitle'] = $data['name'] . ' (' . date('M j, Y @ h:i A ') . ')';
        }
        return $data;
    }
}