Magento 1.9 Orders – Get Order Collection Last One Year Month Wise

collection;magento-1.9orderssales-order

I need to get order collection of last one year, In which I have to show data month wise like

Jan - xxx(Orders)
Feb - xxx(Orders)

Best Answer

Try below code

$fromDate = date('Y-m-d H:i:s', strtotime($fromDate));
$toDate = date('Y-m-d H:i:s', strtotime($toDate));

/* Get the collection */
$orders = Mage::getModel('sales/order')->getCollection()
    ->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate))
    ->addAttributeToFilter('status', array('eq' => Mage_Sales_Model_Order::STATE_COMPLETE))->setOrder('created_at', 'ASC');
$archive=array();
foreach ($orders as $order) {
            $tmp=array();
            $time=strtotime($order->getCreatedAt());
            //save Data you want show in $tmp array
            $archive[date("Y",$time)][date("F",$time)][]=$tmp;
}

Related Solutions

Magento – Magento: How to get customer last order by joining customers and orders

You need to

Mage::getSingleton('checkout/session')->getLastOrderId(); this will get you last order and what you missing to call.

I haven't verified this method though, however, it should work.

$order = Mage::getModel('sales/order')
          ->load(Mage::getSingleton('sales/order')->getLastOrderId());
$getLastOrderIncrementId = $order->getIncrementId();

Magento 1.9 – Retrieve Last 7 Days Orders

Please try this in test.php

 <?php
    include 'app/Mage.php';
    ini_set('display_errors', 1);
    Mage::app();

    date_default_timezone_set('Australia/Sydney'); // specify your time zone
    $ordershippeddays = 7; // number of days you want
    $fromDate         = gmdate("Y-m-d H:i:s", gmmktime(0, 0, 0, gmdate("m"), gmdate("d") - $ordershippeddays, gmdate("Y")));
    //echo "<br/>";
    $toDate           = gmdate("Y-m-d H:i:s", gmmktime(23, 59, 59, gmdate("m"), gmdate("d"), gmdate("Y")));

    echo "fromdate--".$fromDate; //from date
    echo "<br>";
    echo "toDate--".$toDate; // todate
    echo "<br>";
    $ordercollection = Mage::getResourceModel('sales/order_item_collection')
        ->addAttributeToSelect('order_id')
        ->addAttributeToSelect('created_at')
        ->addAttributeToFilter('created_at', array('from' => $fromDate, 'to' => $toDate))
        ->load();




    foreach ($ordercollection as $orderkey => $ordervalue) {
        $eid = $ordervalue->getOrderId();   
        $order           = Mage::getModel("sales/order")->load($eid);
        $customerorderid = $order->getIncrementId();
        $customeremailid = $order->getCustomerEmail();
        $customername    = $order->getCustomerFirstname();

        echo "orderid---".$customerorderid;
        echo "<br>";
    }

    ?>

Best Answer

Related Solutions

Magento – Magento: How to get customer last order by joining customers and orders

Magento 1.9 – Retrieve Last 7 Days Orders

Related Topic