获得指定customer 购买的产品数据

获得指定customer 购买的产品信息，如果是configurable的，则取configurable的名字。

            $orderedProductsForCustomerData = array();
       
            $orderTable =Mage::getSingleton('core/resource')->getTableName('sales/order');
            $orderItemTable = Mage::getSingleton('core/resource')->getTableName('sales/order_item');
            
            $orderedProductsForCustomers = Mage::getModel('sales/order_item')->getCollection();
            $orderedProductsForCustomers->getSelect()->reset('columns');
            $orderedProductsForCustomers->getSelect()->columns('name');
            $orderedProductsForCustomers->getSelect()->columns('item_id');
            $orderedProductsForCustomers->getSelect()->columns('parent_item_id');
            
            $orderedProductsForCustomers->getSelect()->joinInner(
                  array('orders'=>$orderTable),
                  'main_table.order_id = orders.entity_id',
                  array('product_id'=>'main_table.product_id')
            );
            
            $orderedProductsForCustomers->getSelect()->joinLeft(
                  array('self_table'=>$orderItemTable),
                  'main_table.parent_item_id = self_table.item_id',
                  array()
            );
            
            $orderedProductsForCustomers->getSelect()->where('orders.customer_id=?',$customerId);
            $orderedProductsForCustomers->getSelect()->where('orders.state=?','complete');
            $orderedProductsForCustomers->getSelect()->where('main_table.product_id not in (?)',$reviewedProductIds);
              $orderedProductsForCustomers->getSelect()->where('main_table.parent_item_id is null');
            $orderedProductsForCustomers->getSelect()->distinct();
      
            Mage::log($orderedProductsForCustomers->getSelect().'');
            try{
                  $orderedProductsForCustomerData = $conn->fetchAll($orderedProductsForCustomers->getSelect());
            }
            catch (Exception $e){
                  Mage::logException($e);
            }