Revision bed19453
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| sql/Pg-upgrade2/erzeugnisnummern.pl | ||
|---|---|---|
| 60 | 60 |
|
| 61 | 61 |
if ( $::form->{filter_partnumber} ) {
|
| 62 | 62 |
$where .= ' AND partnumber ILIKE ?'; |
| 63 |
push(@values, $::form->like( $::form->{filter_partnumber} ));
|
|
| 63 |
push(@values, like( $::form->{filter_partnumber} ));
|
|
| 64 | 64 |
} |
| 65 | 65 |
|
| 66 | 66 |
if ($::form->{filter_description}) {
|
| 67 | 67 |
$where .= ' AND description ILIKE ?'; |
| 68 |
push(@values, $::form->like($::form->{filter_description}));
|
|
| 68 |
push(@values, like($::form->{filter_description}));
|
|
| 69 | 69 |
} |
| 70 | 70 |
|
| 71 | 71 |
if ($::form->{filter_notes}) {
|
| 72 | 72 |
$where .= ' AND notes ILIKE ?'; |
| 73 |
push(@values, $::form->like($::form->{filter_notes}));
|
|
| 73 |
push(@values, like($::form->{filter_notes}));
|
|
| 74 | 74 |
} |
| 75 | 75 |
|
| 76 | 76 |
if ($::form->{filter_ean}) {
|
| 77 | 77 |
$where .= ' AND ean ILIKE ?'; |
| 78 |
push(@values, $::form->like($::form->{filter_ean}));
|
|
| 78 |
push(@values, like($::form->{filter_ean}));
|
|
| 79 | 79 |
} |
| 80 | 80 |
|
| 81 | 81 |
if ($::form->{filter_type} eq 'assembly') {
|
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.