$form->{SHOW_DUNNING_LEVELS} = scalar @{ $form->{DUNNING} };
$form->{jsscript} = 1;
- $form->{title} = $locale->text('Search Dunning');
+ $form->{title} = $locale->text('Dunnings');
$form->{fokus} = "search.customer";
$form->header();
my @filter_field_list = qw(customer_id customer dunning_level department_id invnumber ordnumber
transdatefrom transdateto dunningfrom dunningto notes showold);
+ report_generator_set_default_sort('customername', 1);
+
DN->get_dunning(\%myconfig, \%$form);
if (!$form->{callback}) {
$report->set_options('std_column_visibility' => 1,
'title' => $form->{title});
- $report->set_export_options('show_dunning', @filter_field_list);
+ $report->set_export_options('show_dunning', @filter_field_list, qw(sort sortdir));
- $report->set_columns(
+ my %column_defs = (
'checkbox' => { 'text' => '', 'visible' => 'HTML' },
'dunning_description' => { 'text' => $locale->text('Dunning Level') },
'customername' => { 'text' => $locale->text('Customername') },
'interest' => { 'text' => $locale->text('Interest') },
);
+ $report->set_columns(%column_defs);
$report->set_column_order(qw(checkbox dunning_description customername invnumber transdate
duedate amount dunning_date dunning_duedate fee interest));
+ $report->set_sort_indicator($form->{sort}, $form->{sortdir});
my $edit_url = build_std_url('script=is.pl', 'action=edit', 'callback') . '&id=';
my $print_url = build_std_url('action=print_dunning', 'format=pdf', 'media=screen') . '&dunning_id=';
+ my $sort_url = build_std_url('action=show_dunning', grep { $form->{$_} } @filter_field_list);
+
+ foreach my $name (qw(dunning_description customername invnumber transdate duedate dunning_date dunning_duedate)) {
+ my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
+ $column_defs{$name}->{link} = $sort_url . "&sort=$name&sortdir=$sortdir";
+ }
my %alignment = map { $_ => 'right' } qw(transdate duedate amount dunning_date dunning_duedate fee interest);