<?php
$order_id=7;
$order = Mage::getModel('sales/order')->load($order_id);
$base_grand_total = $order->getBaseGrandTotal();
$base_subtotal = $order->getBaseSubtotal();
$grand_total = $order->getGrandTotal();
$subtotal = $order->getSubtotal();
$base_subtotal_incl_tax = $order->getBaseSubtotalInclTax();
$subtotal_incl_tax = $order->getSubtotalInclTax();
$total_item_count = $order->getTotalItemCount();
$items = $order->getAllItems();
foreach($items as $item){
if($item->getParentItemId() == '' || $item->getParentItemId() == null){
$product_id = $item->getProductId();
/************Deleted Condition *************/
$catId=$item->getQuote_item_id();
$read= Mage::getSingleton('core/resource')->getConnection('core_read');
$value=$read->query("Select * from mpb_sales_flat_quote_item_option where item_id='".$catId."'");
$row = $value->fetch();
//print_r($row);
/**************************/
//echo "CODE=====".$row['code'];
/************ Apply your won condition ************************/
if($row['code']!='incart'){
//remove item price from total price of order
$item_price = $item->getPrice();
$item->delete();
$order->setBaseGrandTotal($base_grand_total-$item_price);
$order->setBaseSubtotal($base_subtotal-$item_price);
$order->setGrandTotal($grand_total-$item_price);
$order->setSubtotal($subtotal-$item_price);
$order->setBaseSubtotalInclTax($base_subtotal_incl_tax-$item_price);
$order->setSubtotalInclTax($subtotal_incl_tax-$item_price);
$order->setTotalItemCount($total_item_count-1);
$order->save();
}
}
}
?>
$order_id=7;
$order = Mage::getModel('sales/order')->load($order_id);
$base_grand_total = $order->getBaseGrandTotal();
$base_subtotal = $order->getBaseSubtotal();
$grand_total = $order->getGrandTotal();
$subtotal = $order->getSubtotal();
$base_subtotal_incl_tax = $order->getBaseSubtotalInclTax();
$subtotal_incl_tax = $order->getSubtotalInclTax();
$total_item_count = $order->getTotalItemCount();
$items = $order->getAllItems();
foreach($items as $item){
if($item->getParentItemId() == '' || $item->getParentItemId() == null){
$product_id = $item->getProductId();
/************Deleted Condition *************/
$catId=$item->getQuote_item_id();
$read= Mage::getSingleton('core/resource')->getConnection('core_read');
$value=$read->query("Select * from mpb_sales_flat_quote_item_option where item_id='".$catId."'");
$row = $value->fetch();
//print_r($row);
/**************************/
//echo "CODE=====".$row['code'];
/************ Apply your won condition ************************/
if($row['code']!='incart'){
//remove item price from total price of order
$item_price = $item->getPrice();
$item->delete();
$order->setBaseGrandTotal($base_grand_total-$item_price);
$order->setBaseSubtotal($base_subtotal-$item_price);
$order->setGrandTotal($grand_total-$item_price);
$order->setSubtotal($subtotal-$item_price);
$order->setBaseSubtotalInclTax($base_subtotal_incl_tax-$item_price);
$order->setSubtotalInclTax($subtotal_incl_tax-$item_price);
$order->setTotalItemCount($total_item_count-1);
$order->save();
}
}
}
?>
No comments:
Post a Comment