Get the number of orders with status 'processing'

Question

I am trying to get the number of orders with status 'processing' and below is the code.

$countProcessingOrders = 0;    

$processingOrders = Mage::getModel('sales/order')->getCollection()
    ->addFilter('status', Mage_Sales_Model_Order::STATE_PROCESSING)
    ->addAttributeToSelect('created_at');

foreach ($processingOrders as $order) {
        $countProcessingOrders++; 
}

For some reason, the (count) output compared to Magento Admin is off by one. It would be helpful if anyone can give clues as to why this may occur?

Note: I am selecting the 'created_at' attribute for some other purpose.

Answer 1

You can try this way:

$processingOrders = Mage::getModel('sales/order')->getCollection()
    ->addFieldToFilter('state', Mage_Sales_Model_Order::STATE_PROCESSING) //use state instead of status since 'processing' is a state of the order not a status.
    ->addAttributeToSelect('created_at');
$total = $processingOrders->count();

Answer 2

Magento admin backend uses sales_flat_order_grid table. Try use this one:

$processingOrders = Mage::getModel('sales/order_grid')->getCollection()
    ->addFieldToFilter('state', Mage_Sales_Model_Order::STATE_PROCESSING)
    ->addAttributeToSelect('created_at');
$total = $processingOrders->count();