Revision bed19453
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 231 | 231 |
$glwhere .= qq| AND g.reference ILIKE ?|; |
| 232 | 232 |
$arwhere .= qq| AND a.invnumber ILIKE ?|; |
| 233 | 233 |
$apwhere .= qq| AND a.invnumber ILIKE ?|; |
| 234 |
push(@glvalues, $::form->like($form->{reference}));
|
|
| 235 |
push(@arvalues, $::form->like($form->{reference}));
|
|
| 236 |
push(@apvalues, $::form->like($form->{reference}));
|
|
| 234 |
push(@glvalues, like($form->{reference}));
|
|
| 235 |
push(@arvalues, like($form->{reference}));
|
|
| 236 |
push(@apvalues, like($form->{reference}));
|
|
| 237 | 237 |
} |
| 238 | 238 |
|
| 239 | 239 |
if ($form->{department}) {
|
| ... | ... | |
| 250 | 250 |
$glwhere .= " AND ac.trans_id IN (SELECT trans_id from acc_trans WHERE source ILIKE ?)"; |
| 251 | 251 |
$arwhere .= " AND ac.trans_id IN (SELECT trans_id from acc_trans WHERE source ILIKE ?)"; |
| 252 | 252 |
$apwhere .= " AND ac.trans_id IN (SELECT trans_id from acc_trans WHERE source ILIKE ?)"; |
| 253 |
push(@glvalues, $::form->like($form->{source}));
|
|
| 254 |
push(@arvalues, $::form->like($form->{source}));
|
|
| 255 |
push(@apvalues, $::form->like($form->{source}));
|
|
| 253 |
push(@glvalues, like($form->{source}));
|
|
| 254 |
push(@arvalues, like($form->{source}));
|
|
| 255 |
push(@apvalues, like($form->{source}));
|
|
| 256 | 256 |
} |
| 257 | 257 |
|
| 258 | 258 |
# default Datumseinschränkung falls nicht oder falsch übergeben (sollte nie passieren) |
| ... | ... | |
| 280 | 280 |
$glwhere .= " AND g.description ILIKE ?"; |
| 281 | 281 |
$arwhere .= " AND ct.name ILIKE ?"; |
| 282 | 282 |
$apwhere .= " AND ct.name ILIKE ?"; |
| 283 |
push(@glvalues, $::form->like($form->{description}));
|
|
| 284 |
push(@arvalues, $::form->like($form->{description}));
|
|
| 285 |
push(@apvalues, $::form->like($form->{description}));
|
|
| 283 |
push(@glvalues, like($form->{description}));
|
|
| 284 |
push(@arvalues, like($form->{description}));
|
|
| 285 |
push(@apvalues, like($form->{description}));
|
|
| 286 | 286 |
} |
| 287 | 287 |
|
| 288 | 288 |
if ($form->{employee_id}) {
|
| ... | ... | |
| 298 | 298 |
$glwhere .= " AND g.notes ILIKE ?"; |
| 299 | 299 |
$arwhere .= " AND a.notes ILIKE ?"; |
| 300 | 300 |
$apwhere .= " AND a.notes ILIKE ?"; |
| 301 |
push(@glvalues, $::form->like($form->{notes}));
|
|
| 302 |
push(@arvalues, $::form->like($form->{notes}));
|
|
| 303 |
push(@apvalues, $::form->like($form->{notes}));
|
|
| 301 |
push(@glvalues, like($form->{notes}));
|
|
| 302 |
push(@arvalues, like($form->{notes}));
|
|
| 303 |
push(@apvalues, like($form->{notes}));
|
|
| 304 | 304 |
} |
| 305 | 305 |
|
| 306 | 306 |
if ($form->{accno}) {
|
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.