my $all_units = AM->retrieve_all_units();
- $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit
+ my $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit
FROM orderitems oi
LEFT JOIN parts p ON (oi.parts_id = p.id)
WHERE (oi.trans_id = ?)|;
'oe_id' => $oe_id,);
my %ordered = ();
- do_statement($form, $sth, $query, $oe_id);
-
while (my $ref = $sth->fetchrow_hashref()) {
$ref->{baseqty} = $ref->{qty} * $all_units->{$ref->{unit}}->{factor} / $all_units->{$ref->{partunit}}->{factor};