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

最新推荐文章于 2025-10-09 12:44:55 发布

最新推荐文章于 2025-10-09 12:44:55 发布 · 202 阅读

文章标签：

#magenta #product #order

Magento 专栏收录该内容

31 篇文章

订阅专栏

本文介绍了一种使用Magento框架从数据库中检索指定客户的已完成订单产品信息的方法。特别关注于如何通过SQL查询来获取这些数据，包括产品名称及其ID，并且特别处理了可配置产品的名称获取。

获得指定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);
            }