Magento获取顾客评价列表

magento中对于评论，系统内部建了6个数据表，这里我们使用我们需要的进行联表查询筛选出对应顾客的评价列表，代码及封装的方法如下：

$isReview = $this->getRequest()->getParam('is_review', 0);
$review = Mage::helper('fun_review');

$page_size = $this->getRequest()->getParam('page_size');
$page_index= $this->getRequest()->getParam('page_index');

$orderItemCollection = $review->getReviewListByCustomerId($this->_customer_id, $isReview,$page_index,$page_size);

/**
 * 获取顾客评论列表
 *
 * @param int $customerId          
 * @param boolean $reviewed            
 * @param number $page         
 * @param number $pageSize         
 * @return array()
 */
public function getReviewListByCustomerId($customerId, $reviewed = false, $page = 1, $pageSize = self::REVIEW_PAGE_SIZE) 
{
    $orderItems = Mage::getResourceModel ( 'sales/order_item_collection' );
    $orderTable = $orderItems->getTable ( 'sales/order' );
    $customerId = ( int ) $customerId;
    $page = ( int ) $page;
    $pageSize = ( int ) $pageSize;
    $status = self::REVIEW_ORDER_STATUS;

    $orderItems->removeAllFieldsFromSelect ();
    $orderItems->addFieldToSelect ( 'product_id' );
    $orderItems->addFieldToSelect ( 'is_reviewed' );
    $orderItems->addFieldToFilter ( 'is_reviewed', array (
            'eq' => intval ( $reviewed ) 
    ) );
    $orderItems->getSelect ()->joinInner ( array (
            'o' => $orderTable 
    ), "o.entity_id = main_table.order_id and o.customer_id = {$customerId} and o.status = '{$status}' ", null );

    $orderItems->setOrder ( 'item_id', 'DESC' );
    $orderItems->setPage ( $page, $pageSize );
    $reviewList = $orderItems->load ();
    return $reviewList;
}