Revision bc40bcab
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/Common.pm | ||
|---|---|---|
| 62 | 62 |
next unless $form->{$_};
|
| 63 | 63 |
|
| 64 | 64 |
$filter .= qq| AND ($_ ILIKE ?)|; |
| 65 |
push @filter_values, '%' . $form->{$_} . '%';
|
|
| 65 |
push @filter_values, like($form->{$_});
|
|
| 66 | 66 |
} |
| 67 | 67 |
|
| 68 | 68 |
if ($form->{no_assemblies}) {
|
| ... | ... | |
| 110 | 110 |
my (@filter_values, $filter); |
| 111 | 111 |
if ($form->{"name"}) {
|
| 112 | 112 |
$filter .= " AND (TABLE.name ILIKE ?)"; |
| 113 |
push(@filter_values, '%' . $form->{"name"} . '%');
|
|
| 113 |
push(@filter_values, like($form->{"name"}));
|
|
| 114 | 114 |
} |
| 115 | 115 |
if (!$form->{"obsolete"}) {
|
| 116 | 116 |
$filter .= " AND NOT TABLE.obsolete"; |
| ... | ... | |
| 173 | 173 |
my (@filter_values, $filter); |
| 174 | 174 |
if ($form->{"name"}) {
|
| 175 | 175 |
$filter .= qq| (name ILIKE ?) AND|; |
| 176 |
push(@filter_values, '%' . $form->{"name"} . '%');
|
|
| 176 |
push(@filter_values, like($form->{"name"}));
|
|
| 177 | 177 |
} |
| 178 | 178 |
|
| 179 | 179 |
$order_by =~ s/[^a-zA-Z_]//g; |
| ... | ... | |
| 209 | 209 |
my (@filter_values, $filter); |
| 210 | 210 |
if ($form->{"name"}) {
|
| 211 | 211 |
$filter .= qq| (name ILIKE ?) AND|; |
| 212 |
push(@filter_values, '%' . $form->{"name"} . '%');
|
|
| 212 |
push(@filter_values, like($form->{"name"}));
|
|
| 213 | 213 |
} |
| 214 | 214 |
|
| 215 | 215 |
$order_by =~ s/[^a-zA-Z_]//g; |
Auch abrufbar als: Unified diff
(I)LIKE-Argumente immer mit Funktion SL::DBUtils::like erstellen