Revision 63c36f48
Von Bernd Bleßmann vor 12 Monaten hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 136 | 136 |
qq| o.exchangerate, | . |
| 137 | 137 |
qq| o.itime::DATE AS insertdate, | . |
| 138 | 138 |
qq| o.intnotes,| . |
| 139 |
qq| o.vendor_confirmation_number,| . |
|
| 139 | 140 |
qq| department.description as department, | . |
| 140 | 141 |
qq| ex.$rate AS daily_exchangerate, | . |
| 141 | 142 |
qq| pt.description AS payment_terms, | . |
| ... | ... | |
| 250 | 251 |
push(@values, like($form->{cusordnumber}));
|
| 251 | 252 |
} |
| 252 | 253 |
|
| 254 |
if ($form->{vendor_confirmation_number}) {
|
|
| 255 |
$query .= qq| AND o.vendor_confirmation_number ILIKE ?|; |
|
| 256 |
push(@values, like($form->{vendor_confirmation_number}));
|
|
| 257 |
} |
|
| 258 |
|
|
| 253 | 259 |
if($form->{transdatefrom}) {
|
| 254 | 260 |
$query .= qq| AND o.transdate >= ?|; |
| 255 | 261 |
push(@values, conv_date($form->{transdatefrom}));
|
| ... | ... | |
| 344 | 350 |
o.transaction_description |
| 345 | 351 |
o.quonumber |
| 346 | 352 |
o.ordnumber |
| 347 |
o.cusordnumber); |
|
| 353 |
o.cusordnumber |
|
| 354 |
o.vendor_confirmation_number); |
|
| 348 | 355 |
$query .= ' AND (';
|
| 349 | 356 |
$query .= join ' ILIKE ? OR ', @fulltext_fields; |
| 350 | 357 |
$query .= ' ILIKE ?'; |
| ... | ... | |
| 476 | 483 |
"department" => "department.description", |
| 477 | 484 |
"intnotes" => "o.intnotes", |
| 478 | 485 |
"order_status" => "order_statuses.name", |
| 486 |
"vendor_confirmation_number" => "o.vendor_confirmation_number", |
|
| 479 | 487 |
); |
| 480 | 488 |
if ($form->{sort} && grep($form->{sort}, keys(%allowed_sort_columns))) {
|
| 481 | 489 |
$sortorder = $allowed_sort_columns{$form->{sort}} . " ${sortdir}" . ", o.itime ${sortdir}";
|
Auch abrufbar als: Unified diff
Lieferantenauftragsbestätigung: Bericht: Bestätigungsnummer des Lieferanten …
… filtern und anzeigen können