From d4a35a1488d375c1700ef8b87e76880886e300b3 Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Fri, 14 Jun 2013 09:40:16 +0100 Subject: [PATCH] Insert something. Not picked up though. --- includes/picking.inc | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/includes/picking.inc b/includes/picking.inc index a45dd6e..6ac95e6 100644 --- a/includes/picking.inc +++ b/includes/picking.inc @@ -44,8 +44,7 @@ class Picker { } function insertAllForBranch($debtor_no, $branch_code) { $this->deleteAllForBranch($debtor_no, $branch_code); - $branch = get_cust_branch($debtor_no, $branch_code); - $location = $branch['branch_ref']; + $pick_location = OrderXtraConfig::$default_location; $sql = "SELECT d.stock_id , d.quantity AS quantity ,IF(".OrderXtraConfig::sql_held_condition().", d.quantity, 0) held @@ -55,15 +54,14 @@ class Picker { FROM ".TB_PREF."sales_order_details sod NATURAL JOIN ".TB_PREF."sales_orders so JOIN ".TB_PREF."denorm_order_details_queue d ON (sod.id = d.id) - JOIN ".TB_PREF."denorm_qoh qoh ON (qoh.stock_id = sod.stk_code AND loc_code = '$location') + JOIN ".TB_PREF."denorm_qoh qoh ON (qoh.stock_id = sod.stk_code AND loc_code = '$pick_location') WHERE debtor_no = $debtor_no AND branch_code = $branch_code "; + display_warning("$sql"); $result = db_query($sql, $sql); - display_warning("B"); + display_warning("B $result"); while($row=db_fetch($result)) { - display_warning("R"); foreach($row as $key => $value) { $$key = $value; } - foreach($row as $key => $value) { display_warning("$key => $value"); } $available = min($quantity, max($qoh-$quantity_before-$held,0 )); $booked = $quantity - $available; @@ -72,6 +70,8 @@ class Picker { $order_link = "/sales/sales_order_entry.php?OrderNumber=$order_id"; $base = substr($sku, 0, 8); $variation = substr($sku, 9); + $branch = get_cust_branch($debtor_no, $branch_code); + $location = $branch['branch_ref']; $sql = "INSERT INTO ".TB_PREF."topick SET order_id = $order_id, -- 2.30.2