Obtain final price(s) of item(s) after promotion rules applied?

Question

How can I obtain the actual final cost of items?

Let's say a customer's out-of-pocket payment for an order is

$1000 and tax is $100 and shipping is $50

So subtracting, all his items AFTER discounts and promo rules (whether it's shopping cart rules or catalog rules) applied would be $850. Out of the $850, he may have varying items with varying discounts applied and prices (e.g. $250 + $100 + $300 + $200).

The values $250, $100, $300, $200 are is what I want..

How do I obtain them?

Answer 1

Take a look at the sales_flat_order_item table - this has the details on all ordered items. In your case to access the individual line items something like this would be a starting point:

foreach ($order->getAllItems() as $item) {
    $item->getBaseRowTotal();
    //or just the discount amount
    $item->getBaseDiscountAmount();
}

Answer 2

$porduct = $item->getProduct();

$product->getFinalPrice() should give you the price after discount for each item.