Revision ecf5e303
Von Jan Büren vor mehr als 9 Jahren hinzugefügt
| SL/Controller/DeliveryPlan.pm | ||
|---|---|---|
|
my %orderitems_by_id = map { $_->id => $_ } @$orderitems;
|
||
|
|
||
|
my $query = <<SQL;
|
||
|
SELECT oi.id, doi.qty, doi.qty, doi.unit, doe.delivered
|
||
|
SELECT oi.id, doi.qty, doi.unit, doe.delivered
|
||
|
FROM record_links rl
|
||
|
INNER JOIN delivery_order_items doi ON (doi.delivery_order_id = rl.to_id)
|
||
|
INNER JOIN delivery_orders doe ON (doe.id = rl.to_id)
|
||
Auch abrufbar als: Unified diff
typo in SQL-Query