X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5e984449bf2da02189d95d332182ef9bbdbe0b84..c654c46b8b5f9475d2515750aa4bbb3fdddc63fc:/SL/AR.pm diff --git a/SL/AR.pm b/SL/AR.pm index 0aa4ff372..e37128c19 100644 --- a/SL/AR.pm +++ b/SL/AR.pm @@ -468,15 +468,16 @@ sub ar_transactions { my @a = (transdate, invnumber, name); push @a, "employee" if $form->{l_employee}; - my $sortorder = join(', ', @a); + my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC'; + my $sortorder = join(', ', map { "$_ $sortdir" } @a); if (grep({ $_ eq $form->{sort} } qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia))) { - $sortorder = $form->{sort}; + $sortorder = $form->{sort} . " $sortdir"; } - $query .= " WHERE $where ORDER by $sortorder"; + $query .= " WHERE $where ORDER BY $sortorder"; my $sth = $dbh->prepare($query); $sth->execute(@values) ||