Magento – get all order list for logged in customer in magento

configurable-productmagento-1.8order-gridsales-order

I'm trying to generate the list of past ordered products for logged in customer. My attempt so far.

<ul>
<?php 
    $OrderProducts = Mage::getResourceModel('sales/order_collection')
                        ->addFieldToSelect('*')
                        ->addFieldToFilter('customer_id', Mage::getSingleton('customer/session')->getCustomer()->getId())
                        ->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))
                        ->setOrder('created_at', 'desc');       

                foreach($OrderProducts as $ord){            

                    $o=Mage::getModel('sales/order')->load($ord->getId());  
                    $items = $o->getAllItems(); ?>


                    <?php foreach($items as $p){
                          $p= Mage::getModel('catalog/product')->load($p->getId());
                          ?>                         
                        <li>
                         <a href="<?php echo $p->getProductUrl()?>"><img class="recently-img" src="<?php echo $this->helper('catalog/image')->init($p, 'small_image')->keepFrame(false) ->keepAspectRatio(true)->resize(140) ?>" /></a>
                       </li>        

          <?php }} ?>
</ul>

This code showing some past order items but some contents are wrong. And also it does not show those products which are configurable products. Please help. Thanks in advance.

Best Answer

I found a much more performance friendly version.

By joining the two tables order and order_items together, Magento returns a collection with all purchased items.

$items = Mage::getModel('sales/order')->getCollection()
    ->join(array('item' => 'sales/order_item'), 'main_table.entity_id = item.order_id')
    ->addFieldToFilter('customer_id', $customerId);

Related Solutions

Sales Order – Removing All Old Sales and Customer Data

This script will remove the orders - the invoices and shipments associated with the deleted orders will be removed as well. Put this in your Magento root folder and run by navigating to the script - yourdomain.com/whatYouNamedThisScript.php

<?php
/**
 * Remove Orders
 *
 */
require 'app/Mage.php';
Mage::app('admin')->setUseSessionInUrl(false);

$salesModel = Mage::getModel("sales/order");
$salesCollection = $salesModel->getCollection();
$test_order_ids = array();
$i = 0;
/**
 * Use this version of the loop to delete ALL orders.
 */
foreach ($salesCollection as $order) {
    $orderId = $order->getIncrementId();
    array_push($test_order_ids, $orderId);
}
/**
 *  Use this version of loop to target range of orders.
 *  $i is just a counter, use it to restrict the removal to a certain total number of orders.
 *  Change the if statement in this loop to target the selected order numbers if need be.
 */
 foreach($salesCollection as $order) {
    if ($i < 100){
        $orderId = $order->getIncrementId();
        if((int)$orderId < 200){
            array_push($test_order_ids, $orderId);
        }
    }
    else{
        break;
    }
    $i++;
}
*/
foreach ($test_order_ids as $id) {
    try {
        Mage::getModel('sales/order')->loadByIncrementId($id)->delete();
        echo "order #" . $id . " is removed" . PHP_EOL;
    } catch (Exception $e) {
        echo "order #" . $id . " could not be remvoved: " . $e->getMessage() . PHP_EOL;
    }
}
echo "complete.";

If you modify the if statement in the second version of the foreach loop (currently commented out) you should be able to target any range of order IDs.

Hope that helps!

EDIT - Remove Customers

Feel free to adjust the cutoff time. This will remove all customers whose most recent order is older than the cutoff.

RemoveCustomerByOrderDate.php (place this in your magento root, navigate to it with a browser to run)

 <?php

require_once 'app/Mage.php';
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

getCustomers();

function getCustomers()
{
    //Set your cutoff date here - use / as seperator for m/d/y/ format, use - for d-m-y format.
    $cutOffDate = strtotime('1/1/2013');

    $collection = Mage::getModel('customer/customer')->getCollection()
        ->addAttributeToSelect('last_order_date');

    foreach ($collection as $customer) {
        $orderCollection = Mage::getModel('sales/order')->getCollection()
            ->addFilter('customer_id', $customer->getId())
            ->setOrder('created_at', Varien_Data_Collection_Db::SORT_ORDER_DESC)
        ;
        $newestOrder = $orderCollection->getFirstItem();

        if (strtotime($newestOrder->getCreatedAt()) < $cutOffDate) {
            $customer->delete();
            echo 'Customer '.$customer->getId().' has been deleted.<br/>';
        }
    }
    echo 'Customer Deletion Completed.';
}

Magento 1.8 – Get All Orders for a Customer

Use functions below

/**
 * @param int $customerId
 * @param null|float $grandTotal
 *
 * @return bool
 */
public function isCustomerHasOrders($customerId, $grandTotal = null)
{
    $orderCollection = $this->getCustomerOrderCollection($customerId, $grandTotal);
    return (bool)$orderCollection->getSize();
}

/**
 * @param int  $customerId
 * @param null $grandTotal
 *
 * @return Mage_Sales_Model_Resource_Order_Collection
 */
public function getCustomerOrderCollection($customerId, $grandTotal = null)
{    
    $orderCollection = Mage::getResourceModel('sales/order_collection')
        ->addFieldToSelect('*')
        ->addFieldToFilter('customer_id', $customerId)
        ->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))
        ->setOrder('created_at', 'desc')
    ;
    if ($grandTotal && $grandTotal > 0) {
        $orderCollection->addFieldToFilter('base_grand_total', array ('gteq' => $grandTotal));
    }
    return $orderCollection;
}

You can specify order statuses

->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))

Usage

$customerId = Mage::getSingleton('customer/session')->getCustomer()->getId();
$grandTotal = 30;
if ($this->isCustomerHasOrders($customerId, $grandTotal)) {
    // TODO:
}

Best Answer

Related Solutions

Sales Order – Removing All Old Sales and Customer Data

Magento 1.8 – Get All Orders for a Customer

Related Topic