Revision 25bc91e2
Von Werner Hahn vor 6 Tagen hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 767 | 767 |
push @values, like($form->{parts_description});
|
| 768 | 768 |
} |
| 769 | 769 |
|
| 770 |
if ($form->{parts_serialnumber}) {
|
|
| 771 |
$where .= <<SQL; |
|
| 772 |
AND EXISTS ( |
|
| 773 |
SELECT invoice.trans_id |
|
| 774 |
FROM invoice |
|
| 775 |
WHERE (invoice.trans_id = a.id) |
|
| 776 |
AND (invoice.serialnumber ILIKE ?) |
|
| 777 |
LIMIT 1 |
|
| 778 |
) |
|
| 779 |
SQL |
|
| 780 |
push @values, like($form->{parts_serialnumber});
|
|
| 781 |
} |
|
| 782 |
|
|
| 770 | 783 |
if ($where) {
|
| 771 | 784 |
$where =~ s{\s*AND\s*}{ WHERE };
|
| 772 | 785 |
$query .= $where; |
Auch abrufbar als: Unified diff
EK/VK Rechnungen Kred. Deb. Suche Seriannummer aus Position als Kriterium