From 95882b1ce63925a78b684b4cb0c54760bd129b13 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 4 May 2007 22:37:40 +0000 Subject: [PATCH] Database error when updating more than one item row in Sales Orders. --- CHANGELOG.txt | 4 +++- sales/includes/db/sales_order_db.inc | 4 ++-- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 8cf61f6..da033eb 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -20,7 +20,9 @@ Legend: $ -> Affected files 04-May-2007 Joe Hunt - # Database error hen inserting work order issues. Fixed. + # Database error when updating more than one item row in Sales Orders. + $ /sales/includes/db/sales_order_db.inc + # Database error when inserting work order issues. Fixed. $ /manufacturing/includes/db/work_order_issues_db.inc 03-May-2007 Joe Hunt diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index ee32a37..58c9899 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -86,11 +86,11 @@ function update_sales_order($order_no, $order) db_query($sql, "Old order Cannot be Deleted"); - $sql = "INSERT INTO ".TB_PREF."sales_order_details (order_no, stk_code, description, unit_price, quantity, discount_percent, qty_invoiced) VALUES ("; - foreach ($order->line_items as $stock_item) { + $sql = "INSERT INTO ".TB_PREF."sales_order_details (order_no, stk_code, description, unit_price, quantity, discount_percent, qty_invoiced) VALUES ("; + $sql .= $order_no . ",'" . $stock_item->stock_id . "','" . $stock_item->item_description . "', " . $stock_item->price . ", " . $stock_item->quantity . ", " . $stock_item->discount_percent . ", " . $stock_item->qty_inv . " )"; db_query($sql, "Old order Cannot be Inserted"); -- 2.30.2