Revision 9b92c0c6
Von Bernd Bleßmann vor mehr als 7 Jahren hinzugefügt
| SL/Controller/DeliveryValueReport.pm | ||
|---|---|---|
| 284 | 284 |
my %oi_by_id = map { $_->id => $_ } @$orderitems;
|
| 285 | 285 |
my $query = sprintf <<'', join ', ', ("?")x@all_doi_ids;
|
| 286 | 286 |
SELECT DISTINCT doi.id, closed FROM delivery_orders |
| 287 |
LEFT JOIN delivery_order_items doi ON (doi.delivery_order_id = delivery_order.id) |
|
| 287 |
LEFT JOIN delivery_order_items doi ON (doi.delivery_order_id = delivery_orders.id)
|
|
| 288 | 288 |
WHERE doi.id IN (%s) |
| 289 | 289 |
|
| 290 | 290 |
my %doi_is_closed = selectall_as_map($::form, SL::DB->client->dbh, $query, (id => 'closed'), @all_doi_ids); |
Auch abrufbar als: Unified diff
DeliveryValueReport: Tabelle heißt delivery_orders (mit s am Ende).