Revision b98b8e3f
Von Sven Schöling vor etwa 10 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 433 | 433 |
) AS charts } . |
| 434 | 434 |
qq|FROM ap a | . |
| 435 | 435 |
qq|JOIN vendor v ON (a.vendor_id = v.id) | . |
| 436 |
qq|LEFT JOIN contacts cp ON (a.cp_id = cp.cp_id) | . |
|
| 436 | 437 |
qq|LEFT JOIN employee e ON (a.employee_id = e.id) | . |
| 437 | 438 |
qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id) | . |
| 438 | 439 |
qq|LEFT JOIN tax_zones tz ON (tz.id = v.taxzone_id)| . |
| ... | ... | |
| 453 | 454 |
$where .= " AND v.name ILIKE ?"; |
| 454 | 455 |
push(@values, $form->like($form->{vendor}));
|
| 455 | 456 |
} |
| 457 |
if ($form->{"cp_name"}) {
|
|
| 458 |
$where .= " AND (cp.cp_name ILIKE ? OR cp.cp_givenname ILIKE ?)"; |
|
| 459 |
push(@values, ('%' . $form->{"cp_name"} . '%')x2);
|
|
| 460 |
} |
|
| 456 | 461 |
if ($form->{department}) {
|
| 457 | 462 |
# ähnlich wie commit 0bbfb33b6aa8e38bb6c81d1684ab7d08e5b5c5af abteilung |
| 458 | 463 |
# wird so nicht mehr als zeichenkette zusammengebaut |
Auch abrufbar als: Unified diff
Belege: Filtern nach Ansprechpartner