my $q_insert_dunning =
qq|INSERT INTO dunning (id, dunning_id, dunning_config_id, dunning_level, trans_id,
- fee, interest, transdate, duedate)
+ fee, interest, transdate, duedate, original_invoice_printed)
VALUES (?, ?, ?,
(SELECT dunning_level FROM dunning_config WHERE id = ?),
?,
* (SELECT interest_rate FROM dunning_config WHERE id = ?)
/ 360,
current_date,
- current_date + (SELECT payment_terms FROM dunning_config WHERE id = ?))|;
+ current_date + (SELECT payment_terms FROM dunning_config WHERE id = ?),
+ ?)|;
my $h_insert_dunning = prepare_query($form, $dbh, $q_insert_dunning);
my @invoice_ids;
@values = ($row_id, $dunning_id, $next_config_id,
$next_config_id, $invoice_id, $next_config_id,
- $invoice_id, $next_config_id, $next_config_id);
+ $invoice_id, $next_config_id, $next_config_id,
+ $print_invoice);
do_statement($form, $h_insert_dunning, $q_insert_dunning, @values);
RecordLinks->create_links(
$self->print_dunning($myconfig, $form, $dunning_id, $dbh);
if ($print_invoice) {
- $self->print_original_invoices($myconfig, $form, $_) for @invoice_ids;
+ $self->print_original_invoice($myconfig, $form, $_) for @invoice_ids;
}
if ($send_email) {
}
-sub print_original_invoices {
+sub print_original_invoice {
my ($self, $myconfig, $form, $invoice_id) = @_;
# get one invoice as object and print to pdf
my $invoice = SL::DB::Invoice->new(id => $invoice_id)->load;