Revision bed19453
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 454 | 454 |
push(@values, $form->{vendor_id});
|
| 455 | 455 |
} elsif ($form->{vendor}) {
|
| 456 | 456 |
$where .= " AND v.name ILIKE ?"; |
| 457 |
push(@values, $form->like($form->{vendor}));
|
|
| 457 |
push(@values, like($form->{vendor}));
|
|
| 458 | 458 |
} |
| 459 | 459 |
if ($form->{"cp_name"}) {
|
| 460 | 460 |
$where .= " AND (cp.cp_name ILIKE ? OR cp.cp_givenname ILIKE ?)"; |
| ... | ... | |
| 470 | 470 |
} |
| 471 | 471 |
if ($form->{invnumber}) {
|
| 472 | 472 |
$where .= " AND a.invnumber ILIKE ?"; |
| 473 |
push(@values, $form->like($form->{invnumber}));
|
|
| 473 |
push(@values, like($form->{invnumber}));
|
|
| 474 | 474 |
} |
| 475 | 475 |
if ($form->{ordnumber}) {
|
| 476 | 476 |
$where .= " AND a.ordnumber ILIKE ?"; |
| 477 |
push(@values, $form->like($form->{ordnumber}));
|
|
| 477 |
push(@values, like($form->{ordnumber}));
|
|
| 478 | 478 |
} |
| 479 | 479 |
if ($form->{notes}) {
|
| 480 | 480 |
$where .= " AND lower(a.notes) LIKE ?"; |
| 481 |
push(@values, $form->like($form->{notes}));
|
|
| 481 |
push(@values, like($form->{notes}));
|
|
| 482 | 482 |
} |
| 483 | 483 |
if ($form->{project_id}) {
|
| 484 | 484 |
$where .= |
Auch abrufbar als: Unified diff
Funktion »like« von Form nach DBUtils verschoben
Das ist eine Datenbank-Quoting-Funktion und hat daher nichts mehr in
Form zu suchen.