Revision 19522de1
Von Bernd Bleßmann vor etwa 2 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 218 | 218 |
push @values, like($form->{parts_description});
|
| 219 | 219 |
} |
| 220 | 220 |
|
| 221 |
if ($form->{chargenumber}) {
|
|
| 222 |
push @where, <<SQL; |
|
| 223 |
EXISTS ( |
|
| 224 |
SELECT delivery_order_items_stock.id |
|
| 225 |
FROM delivery_order_items_stock |
|
| 226 |
LEFT JOIN delivery_order_items ON (delivery_order_items.id = delivery_order_items_stock.delivery_order_item_id) |
|
| 227 |
WHERE delivery_order_items.delivery_order_id = dord.id |
|
| 228 |
AND delivery_order_items_stock.chargenumber ILIKE ? |
|
| 229 |
LIMIT 1 |
|
| 230 |
) |
|
| 231 |
SQL |
|
| 232 |
push @values, like($form->{chargenumber});
|
|
| 233 |
} |
|
| 234 |
|
|
| 221 | 235 |
if ($form->{all}) {
|
| 222 | 236 |
my @tokens = parse_line('\s+', 0, $form->{all});
|
| 223 | 237 |
# ordnumber quonumber customer.name vendor.name transaction_description |
Auch abrufbar als: Unified diff
Berichte-Lieferscheine: Filtern nach Charge (in Lagerinfos).