Revision bc40bcab
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 511 | 511 |
} |
| 512 | 512 |
if ($form->{"cp_name"}) {
|
| 513 | 513 |
$where .= " AND (cp.cp_name ILIKE ? OR cp.cp_givenname ILIKE ?)"; |
| 514 |
push(@values, ('%' . trim($form->{"cp_name"}) . '%')x2);
|
|
| 514 |
push(@values, (like($form->{"cp_name"}))x2);
|
|
| 515 | 515 |
} |
| 516 | 516 |
if ($form->{business_id}) {
|
| 517 | 517 |
my $business_id = $form->{business_id};
|
| ... | ... | |
| 524 | 524 |
push(@values, $department_id); |
| 525 | 525 |
} |
| 526 | 526 |
if ($form->{department}) {
|
| 527 |
my $department = "%" . trim($form->{department}) . "%";
|
|
| 527 |
my $department = like($form->{department});
|
|
| 528 | 528 |
$where .= " AND d.description ILIKE ?"; |
| 529 | 529 |
push(@values, $department); |
| 530 | 530 |
} |
Auch abrufbar als: Unified diff
(I)LIKE-Argumente immer mit Funktion SL::DBUtils::like erstellen