From 0d96668a01d52191402ac27ca79bd73a26e5e06c Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Fri, 14 Jun 2013 09:46:42 +0100 Subject: [PATCH] Insert correctly. --- includes/picking.inc | 3 +++ 1 file changed, 3 insertions(+) diff --git a/includes/picking.inc b/includes/picking.inc index 6ac95e6..387bd8e 100644 --- a/includes/picking.inc +++ b/includes/picking.inc @@ -46,6 +46,7 @@ class Picker { $this->deleteAllForBranch($debtor_no, $branch_code); $pick_location = OrderXtraConfig::$default_location; $sql = "SELECT d.stock_id + ,sod.id AS detail_id , d.quantity AS quantity ,IF(".OrderXtraConfig::sql_held_condition().", d.quantity, 0) held ,qoh.quantity AS qoh @@ -82,6 +83,7 @@ class Picker { variation = '$variation', item_link = '$item_link', quantity = -{$quantity}, + detail_id = $detail_id, type = 'order'"; db_query($sql, 'There was a problem inserting the picking information.'); @@ -95,6 +97,7 @@ class Picker { base = '$base', variation = '$variation', quantity = $booked, + detail_id = $detail_id, type = 'booked'"; db_query($sql, 'There was a problem inserting the picking information.'); -- 2.30.2