+ $id_tokeep = array();
+ foreach ($order->line_items as $line) {
+ array_push($id_tokeep , $line->id);
+ }
+ $id_list = implode(', ', $id_tokeep);
+
+ $sql = "DELETE FROM ".TB_PREF."sales_order_details WHERE order_no =" . db_escape($order_no) . " AND trans_type=".$order->trans_type;
+ $sql .= " AND id NOT IN ($id_list)";
+
+ db_query($sql, "Old order Cannot be Deleted");
+