$mail->{attachments} = $form->{DUNNING_PDFS_EMAIL};
}
+ $query = qq|SELECT id FROM dunning WHERE dunning_id = ?|;
+ my @ids = selectall_array_query($form, $dbh, $query, $dunning_id);
+ $mail->{record_id} = \@ids;
+ $mail->{record_type} = 'dunning';
+
$mail->send();
$main::lxdebug->leave_sub();
ct.name AS customername, ct.id AS customer_id, a.duedate, da.fee,
da.interest, dn.dunning_description, dn.dunning_level, da.transdate AS dunning_date,
da.duedate AS dunning_duedate, da.dunning_id, da.dunning_config_id,
+ da.id AS dunning_table_id,
e2.name AS salesman
FROM ar a
JOIN customer ct ON (a.customer_id = ct.id)
$self->set_customer_cvars($myconfig, $form);
$self->set_template_options($myconfig, $form);
- my $filename = Common::unique_id() . "dunning_invoice_${dunning_id}.pdf";
+ my $filename = Common::unique_id() . "dunning_invoice_" . $form->{invnumber} . ".pdf";
my $spool = $::lx_office_conf{paths}->{spool};
$form->{OUT} = "$spool/$filename";
map { delete $form->{$_} } grep /^[a-z_]+_\d+$/, keys %{ $form };
- my $attachment_filename = $form->get_formname_translation('dunning_invoice') . "_${dunning_id}.pdf";
+ my $attachment_filename = $form->get_formname_translation('dunning_invoice') . "_" . $form->{invnumber} . ".pdf";
$form->{attachment_filename} = $attachment_filename;
$form->{attachment_type} = "dunning";
$form->{attachment_id} = $invoice_id;