Revision 8bd9c500
Von Martin Helmling mh@waldpark.octosoft.eu vor fast 9 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
|
}
|
||
|
if ($form->{project_id}) {
|
||
|
$where .=
|
||
|
qq|AND ((a.globalproject_id = ?) OR EXISTS | .
|
||
|
qq| AND ((a.globalproject_id = ?) OR EXISTS | .
|
||
|
qq| (SELECT * FROM invoice i | .
|
||
|
qq| WHERE i.project_id = ? AND i.trans_id = a.id) | .
|
||
|
qq| OR EXISTS | .
|
||
| ... | ... | |
|
|
||
|
if ($form->{parts_partnumber}) {
|
||
|
$where .= <<SQL;
|
||
|
AND EXISTS (
|
||
|
AND EXISTS (
|
||
|
SELECT invoice.trans_id
|
||
|
FROM invoice
|
||
|
LEFT JOIN parts ON (invoice.parts_id = parts.id)
|
||
| ... | ... | |
|
|
||
|
if ($form->{parts_description}) {
|
||
|
$where .= <<SQL;
|
||
|
AND EXISTS (
|
||
|
AND EXISTS (
|
||
|
SELECT invoice.trans_id
|
||
|
FROM invoice
|
||
|
WHERE (invoice.trans_id = a.id)
|
||
Auch abrufbar als: Unified diff
Einkaufsrechnungen: Suche nach Artikelnummer/-beschreibung in Positionen(2)
BUGfix für substr($where, 0, 4, " WHERE "):
$where muss am Anfang innerhalb 4 Zeichen das AND stehen haben,
sonst kommt es zu einem SQL Syntaxerror