Magento Coding Solutions

Magento Ordered Items delete

<?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();

            }

        }

    }
?>

No comments:

Post a Comment