X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/5e984449bf2da02189d95d332182ef9bbdbe0b84..ea43d77bdaf75a43472261a971b29e732a410321:/SL/AR.pm diff --git a/SL/AR.pm b/SL/AR.pm index 0aa4ff372..c7965f8d5 100644 --- a/SL/AR.pm +++ b/SL/AR.pm @@ -195,6 +195,10 @@ sub post_transaction { VALUES (?, (SELECT id FROM chart WHERE accno = ?), ?, ?, (SELECT taxkey_id FROM chart WHERE accno = ?))|; @values = (conv_i($form->{id}), $form->{AR_amounts}{receivables}, conv_i($form->{receivables}), conv_date($form->{transdate}), $form->{AR_amounts}{receivables}); do_query($form, $dbh, $query, @values); + + } else { + # Record paid amount. + do_query($form, $dbh, qq|UPDATE ar SET paid = ? WHERE id = ?|, $form->{paid}, conv_i($form->{id})); } # add paid transactions @@ -468,15 +472,14 @@ 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}; + if (grep({ $_ eq $form->{sort} } qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia transaction_description))) { + $sortorder = $form->{sort} . " $sortdir"; } - $query .= " WHERE $where ORDER by $sortorder"; + $query .= " WHERE $where ORDER BY $sortorder"; my $sth = $dbh->prepare($query); $sth->execute(@values) ||