From b31a4ed614cfcee060deb69f53524e4acf1f861d Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Mon, 3 Jun 2013 00:25:24 +0100 Subject: [PATCH] Fix quantity not taking into account quantity invoiced. --- haxe/ItemScheduler.hx | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/haxe/ItemScheduler.hx b/haxe/ItemScheduler.hx index 8ac7f6c..ab4e9ac 100644 --- a/haxe/ItemScheduler.hx +++ b/haxe/ItemScheduler.hx @@ -232,7 +232,7 @@ return cast(locations(), Array); private function loadOrders() { var tb : String = untyped __php__('TB_PREF'); - var sql : String = "SELECT * , d.priority AS pp + var sql : String = "SELECT * , d.quantity as qty, d.priority AS pp FROM "+tb+"denorm_order_details_queue d JOIN "+tb+"sales_order_details od ON (od.id = d.id) JOIN "+tb+"sales_orders so ON (so.order_no = d.order_id) @@ -252,6 +252,7 @@ function orders():Array { var a:Dynamic = php.Lib.objectOfAssociativeArray(row); var order:Order = a; order.priority = Date.fromString(a.pp); + order.quantity = a.qty; orderList.push(order); }; -- 2.30.2