Revision 262108d0
Von Moritz Bunkus vor mehr als 16 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 464 | 464 |
|
| 465 | 465 |
my @a = (transdate, invnumber, name); |
| 466 | 466 |
push @a, "employee" if $self->{l_employee};
|
| 467 |
my $sortorder = join(', ', @a);
|
|
| 467 |
my $sortdir = $form->{sortdir} ? 'ASC' : 'DESC';
|
|
| 468 |
my $sortorder = join(', ', map { "$_ $sortdir" } @a);
|
|
| 468 | 469 |
|
| 469 | 470 |
if (grep({ $_ eq $form->{sort} }
|
| 470 | 471 |
qw(transdate id invnumber ordnumber name netamount tax amount |
| 471 | 472 |
paid datepaid due duedate notes employee))) {
|
| 472 |
$sortorder = $form->{sort};
|
|
| 473 |
$sortorder = $form->{sort} . " $sortdir";
|
|
| 473 | 474 |
} |
| 474 | 475 |
|
| 475 |
$query .= " ORDER by $sortorder";
|
|
| 476 |
$query .= " ORDER BY $sortorder";
|
|
| 476 | 477 |
|
| 477 | 478 |
my $sth = $dbh->prepare($query); |
| 478 | 479 |
$sth->execute(@values) || |
Auch abrufbar als: Unified diff
Sortierung in Berichten über Eingangsrechnungen/Kreditorenbuchungen auch auf- und absteigbar sortierbar gemacht.