getting Order status between two state

Question

I have a problem in getting the sum of time taken between two status of an order

I can able the get the created time by the following code:

$collection = Mage::getResourceModel('sales/order_status_history_collection')
    ->addAttributeToSelect('created_at')
    ->addAttributeToFilter('status', array('eq'=>'complete'))
    ->load()

is there a way to get the sum of time taken between two status like sum(OrderInvoiced+OrderShipped) ?

Any help would be appreciated.

Answer 1

You can check these details in this table sales_flat_order_status_history.

//Load order object using the order ID
$order->getStatusHistoryCollection(); // This will give all the status associated with the order

Find the time difference between first status and complete status will be the time taken to fulfill the order.

A minimum calculation in PHP will give you the time difference

$date1 = new DateTime('2012-06-01 02:12:51');
$date2 = $date1->diff(new DateTime('2014-05-12 11:10:00'));
echo $date2->days.'days';
echo $date2->h.' hours'."\n";