Revision 25bc91e2
Von Werner Hahn vor 6 Tagen hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 717 | 717 |
push @values, like($form->{parts_description});
|
| 718 | 718 |
} |
| 719 | 719 |
|
| 720 |
if ($form->{parts_serialnumber}) {
|
|
| 721 |
$where .= <<SQL; |
|
| 722 |
AND EXISTS ( |
|
| 723 |
SELECT invoice.trans_id |
|
| 724 |
FROM invoice |
|
| 725 |
WHERE (invoice.trans_id = a.id) |
|
| 726 |
AND (invoice.serialnumber ILIKE ?) |
|
| 727 |
LIMIT 1 |
|
| 728 |
) |
|
| 729 |
SQL |
|
| 730 |
push @values, like($form->{parts_serialnumber});
|
|
| 731 |
} |
|
| 732 |
|
|
| 720 | 733 |
if ($form->{show_not_mailed}) {
|
| 721 | 734 |
$where .= <<SQL; |
| 722 | 735 |
AND NOT EXISTS ( |
Auch abrufbar als: Unified diff
EK/VK Rechnungen Kred. Deb. Suche Seriannummer aus Position als Kriterium