From f3666585cf4f65171265e4c3da26e1e8a0f9e843 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 6 Feb 2010 19:03:12 +0000 Subject: [PATCH] Fixed bug resulting in broken line items relations after edition of multiline SO. --- sales/includes/db/sales_order_db.inc | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index 2d88087..79d5adc 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -221,10 +221,11 @@ function update_sales_order($order) } } $sql = "INSERT INTO ".TB_PREF."sales_order_details - (order_no, trans_type, stk_code, description, unit_price, quantity, + (id, order_no, trans_type, stk_code, description, unit_price, quantity, discount_percent, qty_sent) VALUES ("; - $sql .= $order_no . ",".$order->trans_type."," + $sql .= db_escape($line->id ? $line->id : 0) . "," + .$order_no . ",".$order->trans_type."," .db_escape($line->stock_id) . "," .db_escape($line->item_description) . ", " .db_escape($line->price) . ", " -- 2.30.2