I believe something like this would give you all the details you need for adding order details to success.pthml
:
// Load order details
$orderId = Mage::getSingleton('checkout/session')->getLastRealOrderId();
$orderDetails = Mage::getModel('sales/order')->loadByIncrementId($orderId);
zend_debug::dump($orderDetails);
Edit from comment, for success.pthml
:
<?php
//**********************************Order Details***************************
if($this->getOrderId()):
//echo $this->getOrderId();
//$orderObj = Mage::getModel(‘sales/order’)->loadByIncrementId($this->getOrderId());
$orderItems = $orderObj->getAllVisibleItems();
?>
<div><table >
<thead>
<th>Product Name</th>
<th>Unit Price</th>
<th>Qty</th>
<th>Subtotal</th>
</thead>
<tbody>
<?
$_product = Mage::getModel(‘catalog/product’)->load($items->getProductId());
foreach($orderItems as $items){
$product_small_image_path = Mage::helper(‘catalog/image’)->init($_product, ‘small_image’)->resize(135);
?>
<tr>
<td><span><img src=”<?php echo $product_small_image_path ?>”/></span><? echo $items->getName();?></td>
<?php ?><td><? echo number_format($items->getPrice(),3);?></td><?php
?><td><? echo $items->getQtyOrdered(); ?></td><?php
$totalprice = ($items->getQtyOrdered())*($items->getPrice());
?><td><? echo number_format($totalprice,3); ?></td></tr><?php
}
?>