Revision c98c318c
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 416 | 416 |
my $query = |
| 417 | 417 |
qq|SELECT a.id, a.invnumber, a.transdate, a.duedate, a.amount, a.paid, | . |
| 418 | 418 |
qq| a.ordnumber, v.name, a.invoice, a.netamount, a.datepaid, a.notes, | . |
| 419 |
qq| a.globalproject_id, a.storno, a.storno_id, | . |
|
| 419 |
qq| a.globalproject_id, a.storno, a.storno_id, a.direct_debit, | .
|
|
| 420 | 420 |
qq| pr.projectnumber AS globalprojectnumber, | . |
| 421 | 421 |
qq| e.name AS employee, | . |
| 422 | 422 |
qq| v.vendornumber, v.country, v.ustid, | . |
| ... | ... | |
| 513 | 513 |
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
| 514 | 514 |
my $sortorder = join(', ', map { "$_ $sortdir" } @a);
|
| 515 | 515 |
|
| 516 |
if (grep({ $_ eq $form->{sort} } qw(transdate id invnumber ordnumber name netamount tax amount paid datepaid due duedate notes employee transaction_description))) {
|
|
| 516 |
if (grep({ $_ eq $form->{sort} } qw(transdate id invnumber ordnumber name netamount tax amount paid datepaid due duedate notes employee transaction_description direct_debit))) {
|
|
| 517 | 517 |
$sortorder = $form->{sort} . " $sortdir";
|
| 518 | 518 |
} |
| 519 | 519 |
|
Auch abrufbar als: Unified diff
Einkaufsrechnungssuche: Spalte Lastschrifteinzug optional anzeigen