+ var config_date = untyped __call__('OrderXtraConfig::delivery', code);
+ delivery = config_date != null ? Date.fromString(config_date) : null;
+ }
+
+ public function quantityOnOrder(stock_id) : Int {
+ var TB = FA.tb();
+ var sql = 'SELECT SUM(quantity_ordered - quantity_received) as quantity
+ FROM '+TB+'purch_order_details
+ NATURAL JOIN '+TB+'purch_orders
+ WHERE item_code = "'+stock_id+'" AND into_stock_location = "'+code+'"
+ AND quantity_ordered > quantity_received
+ ORDER by delivery_date' ;
+
+ var result = FA.query(sql);
+ if(result.hasNext()) {
+ var row = php.Lib.objectOfAssociativeArray(result.next());
+ return row.quantity;
+ }
+ else {
+ return 0;
+ }
+