Revision f89cce75
Von Bernd Bleßmann vor mehr als 3 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 481 | 481 |
|
| 482 | 482 |
my $query = |
| 483 | 483 |
qq|SELECT DISTINCT a.id, a.invnumber, a.ordnumber, a.cusordnumber, a.transdate, | . |
| 484 |
qq| a.donumber, a.deliverydate, | . |
|
| 484 | 485 |
qq| a.duedate, a.netamount, a.amount, a.paid, | . |
| 485 | 486 |
qq| a.invoice, a.datepaid, a.notes, a.shipvia, | . |
| 486 | 487 |
qq| a.shippingpoint, a.storno, a.storno_id, a.globalproject_id, | . |
| ... | ... | |
| 682 | 683 |
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
| 683 | 684 |
my $sortorder = join(', ', map { "$_ $sortdir" } @a);
|
| 684 | 685 |
|
| 685 |
if (grep({ $_ eq $form->{sort} } qw(id transdate duedate invnumber ordnumber cusordnumber name datepaid employee shippingpoint shipvia transaction_description department))) {
|
|
| 686 |
if (grep({ $_ eq $form->{sort} } qw(id transdate duedate invnumber ordnumber cusordnumber donumber deliverydate name datepaid employee shippingpoint shipvia transaction_description department))) {
|
|
| 686 | 687 |
$sortorder = $form->{sort} . " $sortdir";
|
| 687 | 688 |
} |
| 688 | 689 |
|
Auch abrufbar als: Unified diff
VK-Rechnungsbericht: Lieferscheinnummer und Lieferdatum anzeigen können