bin/mozilla/dn.pl

   1 #=====================================================================
   2 # LX-Office ERP
   3 # Copyright (C) 2006
   4 # Based on SQL-Ledger Version 2.1.9
   5 # Web http://www.lx-office.org
   6 #
   7 #=====================================================================
   8 # SQL-Ledger Accounting
   9 # Copyright (c) 1998-2002
  10 #
  11 #  Author: Dieter Simader
  12 #   Email: dsimader@sql-ledger.org
  13 #     Web: http://www.sql-ledger.org
  14 #
  15 #
  16 # This program is free software; you can redistribute it and/or modify
  17 # it under the terms of the GNU General Public License as published by
  18 # the Free Software Foundation; either version 2 of the License, or
  19 # (at your option) any later version.
  20 #
  21 # This program is distributed in the hope that it will be useful,
  22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
  23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  24 # GNU General Public License for more details.
  25 # You should have received a copy of the GNU General Public License
  26 # along with this program; if not, write to the Free Software
  27 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
  28 # MA 02110-1335, USA.
  29 #======================================================================
  30 #
  31 # Dunning process module
  32 #
  33 #======================================================================
  34
  35 use POSIX qw(strftime);
  36
  37 use List::Util qw(notall);
  38 use List::MoreUtils qw(none);
  39
  40 use SL::IS;
  41 use SL::DN;
  42 use SL::DB::Department;
  43 use SL::DB::Dunning;
  44 use SL::File;
  45 use SL::Helper::Flash qw(flash);
  46 use SL::Locale::String qw(t8);
  47 use SL::Presenter::EmailJournal;
  48 use SL::Presenter::FileObject;
  49 use SL::Presenter::WebdavObject;
  50 use SL::ReportGenerator;
  51
  52 require "bin/mozilla/common.pl";
  53 require "bin/mozilla/reportgenerator.pl";
  54 require "bin/mozilla/io.pl";
  55
  56 use strict;
  57
  58 1;
  59
  60 sub edit_config {
  61   $main::lxdebug->enter_sub();
  62
  63   my $form     = $main::form;
  64   my %myconfig = %main::myconfig;
  65   my $locale   = $main::locale;
  66
  67   $main::auth->assert('config');
  68
  69   DN->get_config(\%myconfig, \%$form);
  70   $form->get_lists('charts' => { 'key'       => 'ALL_CHARTS',
  71                                  'transdate' => 'current_date' });
  72
  73   $form->{SELECT_AR_AMOUNT} = [];
  74   $form->{SELECT_AR}        = [];
  75
  76   foreach my $chart (@{ $form->{ALL_CHARTS} }) {
  77     $chart->{LINKS} = { map { $_, 1 } split m/:/, $chart->{link} };
  78
  79     if ($chart->{LINKS}->{AR}) {
  80       $chart->{AR_selected} = "selected" if $chart->{id} == $form->{AR};
  81       push @{ $form->{SELECT_AR} }, $chart;
  82     }
  83
  84     if ($chart->{LINKS}->{AR_amount}) {
  85       $chart->{AR_amount_fee_selected}      = "selected" if $chart->{id} == $form->{AR_amount_fee};
  86       $chart->{AR_amount_interest_selected} = "selected" if $chart->{id} == $form->{AR_amount_interest};
  87       push @{ $form->{SELECT_AR_AMOUNT} }, $chart;
  88     }
  89   }
  90
  91   $form->{title}      = $locale->text('Edit Dunning Process Config');
  92   $form->{callback} ||= build_std_url("action=edit_config");
  93
  94   setup_dn_edit_config_action_bar();
  95
  96   $form->header();
  97   print $form->parse_html_template("dunning/edit_config");
  98
  99   $main::lxdebug->leave_sub();
 100 }
 101
 102 sub add {
 103   $main::lxdebug->enter_sub();
 104
 105   my $form     = $main::form;
 106   my %myconfig = %main::myconfig;
 107   my $locale   = $main::locale;
 108
 109   $main::auth->assert('dunning_edit');
 110
 111   DN->get_config(\%myconfig, \%$form);
 112
 113   $form->get_lists("departments" => "ALL_DEPARTMENTS");
 114
 115   $form->{SHOW_DUNNING_LEVEL_SELECTION} = $form->{DUNNING}         && scalar @{ $form->{DUNNING} };
 116   $form->{SHOW_DEPARTMENT_SELECTION}    = $form->{ALL_DEPARTMENTS} && scalar @{ $form->{ALL_DEPARTMENTS} || [] };
 117
 118   $form->{title}    = $locale->text('Start Dunning Process');
 119
 120   setup_dn_add_action_bar();
 121   $form->header();
 122
 123   print $form->parse_html_template("dunning/add");
 124
 125   $main::lxdebug->leave_sub();
 126 }
 127
 128 sub show_invoices {
 129   $main::lxdebug->enter_sub();
 130
 131   my $form     = $main::form;
 132   my %myconfig = %main::myconfig;
 133   my $locale   = $main::locale;
 134
 135   $main::auth->assert('dunning_edit');
 136
 137   DN->get_invoices(\%myconfig, \%$form);
 138   $form->{title} = $locale->text('Start Dunning Process');
 139
 140   foreach my $row (@{ $form->{DUNNINGS} }) {
 141     $row->{DUNNING_CONFIG} = [ map +{ %{ $_ } }, @{ $form->{DUNNING_CONFIG} } ];
 142
 143     if ($row->{next_dunning_config_id}) {
 144       map { $_->{SELECTED} = $_->{id} == $row->{next_dunning_config_id} } @{ $row->{DUNNING_CONFIG } };
 145     }
 146     map { $row->{$_} = $form->format_amount(\%myconfig, $row->{$_} * 1, 2) } qw(amount open_amount fee interest);
 147
 148     if ($row->{'language_id'}) {
 149       $row->{language} = SL::DB::Manager::Language->find_by_or_create('id' => $row->{'language_id'})->{'description'};
 150     }
 151   }
 152
 153   $form->get_lists('printers'  => 'printers',
 154                    'languages' => 'languages');
 155
 156   $form->{type}           = 'dunning';
 157   $form->{rowcount}       = scalar @{ $form->{DUNNINGS} };
 158   $form->{callback}     ||= build_std_url("action=show_invoices", qw(customer invnumber ordnumber groupinvoices minamount dunning_level notes));
 159
 160   $form->{PRINT_OPTIONS}  = print_options('inline'          => 1,
 161                                           'no_queue'        => 1,
 162                                           'no_postscript'   => 1,
 163                                           'no_html'         => 1,
 164                                           'no_opendocument' => 1,);
 165
 166   setup_dn_show_invoices_action_bar();
 167   $form->header();
 168   print $form->parse_html_template("dunning/show_invoices");
 169
 170   $main::lxdebug->leave_sub();
 171 }
 172
 173 sub save {
 174   $main::lxdebug->enter_sub();
 175
 176   my $form     = $main::form;
 177   my %myconfig = %main::myconfig;
 178   my $locale   = $main::locale;
 179
 180   $main::auth->assert('config');
 181
 182   for my $i (1 .. $form->{rowcount}) {
 183     if ($form->{"dunning_description_$i"} ne "") {
 184       $form->isblank("dunning_level_$i", $locale->text('Dunning Level missing in row '). $i);
 185       $form->isblank("dunning_description_$i", $locale->text('Dunning Description missing in row '). $i);
 186       $form->isblank("terms_$i", $locale->text('Terms missing in row '). $i);
 187       $form->isblank("payment_terms_$i", $locale->text('Payment Terms missing in row '). $i);
 188     }
 189   }
 190
 191   DN->save_config(\%myconfig, \%$form);
 192   # saving the history
 193   if(!exists $form->{addition} && $form->{id} ne "") {
 194     $form->{snumbers} = qq|dunning_id_| . $form->{"dunning_id"};
 195     $form->{addition} = "SAVED FOR DUNNING";
 196     $form->save_history;
 197   }
 198   # /saving the history
 199   $form->redirect($locale->text('Dunning Process Config saved!'));
 200
 201   $main::lxdebug->leave_sub();
 202 }
 203
 204 sub save_dunning {
 205   $main::lxdebug->enter_sub();
 206
 207   my $form     = $main::form;
 208   my %myconfig = %main::myconfig;
 209   my $locale   = $main::locale;
 210
 211   $main::auth->assert('dunning_edit');
 212
 213   my $active=1;
 214   my @rows = ();
 215   my @status;
 216   undef($form->{DUNNING_PDFS});
 217
 218   my $saved_language_id = $form->{language_id};
 219
 220   if ($form->{groupinvoices} || $form->{l_include_credit_notes}) {
 221     my %dunnings_for;
 222
 223     for my $i (1 .. $form->{rowcount}) {
 224       next unless ($form->{"active_$i"});
 225
 226       $dunnings_for{$form->{"customer_id_$i"}} ||= {};
 227       my $dunning_levels = $dunnings_for{$form->{"customer_id_$i"}};
 228
 229       $dunning_levels->{$form->{"next_dunning_config_id_$i"}} ||= [];
 230       my $level = $dunning_levels->{$form->{"next_dunning_config_id_$i"}};
 231
 232       push @{ $level }, { "row"                    => $i,
 233                           "invoice_id"             => $form->{"inv_id_$i"},
 234                           "credit_note"            => $form->{"credit_note_$i"},
 235                           "customer_id"            => $form->{"customer_id_$i"},
 236                           "language_id"            => $form->{"language_id_$i"},
 237                           "next_dunning_config_id" => $form->{"next_dunning_config_id_$i"},
 238                           "print_invoice"          => $form->{"include_invoice_$i"},
 239                           "email"                  => $form->{"email_$i"}, };
 240     }
 241
 242     foreach my $levels (values %dunnings_for) {
 243       foreach my $level (values %{ $levels }) {
 244         next unless scalar @{ $level };
 245         if (!$form->{force_lang}) {
 246           $form->{language_id} = @{$level}[0]->{language_id};
 247         }
 248         my $rc =  DN->save_dunning(\%myconfig, $form, $level);
 249         $rc->{error} =~ s{\n}{<br />}g if $rc->{error};
 250         push @status, { invnumbers => [map { $form->{'invnumber_' . $_->{row}} } @$level],
 251                         map { ( $_ => $rc->{$_} ) } qw(error dunning_id print_original_invoice send_email), };
 252       }
 253     }
 254
 255   } else {
 256     for my $i (1 .. $form->{rowcount}) {
 257       next unless $form->{"active_$i"};
 258
 259       my $level = [ { "row"                    => $i,
 260                       "invoice_id"             => $form->{"inv_id_$i"},
 261                       "customer_id"            => $form->{"customer_id_$i"},
 262                       "language_id"            => $form->{"language_id_$i"},
 263                       "next_dunning_config_id" => $form->{"next_dunning_config_id_$i"},
 264                       "print_invoice"          => $form->{"include_invoice_$i"},
 265                       "email"                  => $form->{"email_$i"}, } ];
 266       if (!$form->{force_lang}) {
 267         $form->{language_id} = @{$level}[0]->{language_id};
 268       }
 269       my $rc = DN->save_dunning(\%myconfig, $form, $level);
 270       $rc->{error} =~ s{\n}{<br />}g if $rc->{error};
 271       push @status, { invnumbers => [map { $form->{'invnumber_' . $_->{row}} } @$level],
 272                       map { ( $_ => $rc->{$_} ) } qw(error dunning_id print_original_invoice send_email), };
 273     }
 274   }
 275
 276   $form->{language_id} = $saved_language_id;
 277
 278   my $pdf_filename;
 279   my $pdf_content;
 280   if ($form->{DUNNING_PDFS} && scalar @{ $form->{DUNNING_PDFS} }) {
 281     $form->{dunning_id} = strftime("%Y%m%d", localtime time) if scalar @{ $form->{DUNNING_PDFS}} > 1;
 282     ($pdf_filename, $pdf_content) = DN->melt_pdfs(\%myconfig, $form, $form->{copies}, return_content => $form->{media} ne 'printer');
 283
 284     flash('info', t8('Dunning Process started for selected invoices!'));
 285     if ($form->{media} eq 'printer') {
 286       flash('info', t8('The PDF has been printed'));
 287     } else {
 288       flash('info', t8('The PDF has been created'));
 289     }
 290   }
 291
 292   # saving the history
 293   if(!exists $form->{addition} && $form->{id} ne "") {
 294     $form->{snumbers} = qq|dunning_id_| . $form->{"dunning_id"};
 295     $form->{addition} = "DUNNING STARTED";
 296     $form->save_history;
 297   }
 298   # /saving the history
 299
 300   setup_dn_status_action_bar();
 301   $form->{"title"} = $locale->text("Dunning status");
 302   $form->header();
 303   print $form->parse_html_template('dunning/status', {
 304     pdf_filename => $pdf_filename,
 305     pdf_content  => $pdf_content,
 306     status       => \@status, });
 307
 308   $main::lxdebug->leave_sub();
 309 }
 310
 311 sub set_email {
 312   $main::lxdebug->enter_sub();
 313
 314   my $form     = $main::form;
 315   my $locale   = $main::locale;
 316
 317   $main::auth->assert('dunning_edit');
 318
 319   $form->{"title"} = $locale->text("Set eMail text");
 320   $form->header(
 321     no_layout       => 1,
 322     use_javascripts => [ qw(ckeditor/ckeditor ckeditor/adapters/jquery) ],
 323   );
 324   print($form->parse_html_template("dunning/set_email"));
 325
 326   $main::lxdebug->leave_sub();
 327 }
 328
 329 sub search {
 330   $main::lxdebug->enter_sub();
 331
 332   my $form     = $main::form;
 333   my %myconfig = %main::myconfig;
 334   my $locale   = $main::locale;
 335
 336   $main::auth->assert('dunning_edit');
 337
 338   $form->get_lists("customers"   => "ALL_CUSTOMERS",
 339                    "departments" => "ALL_DEPARTMENTS");
 340   $form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ deleted => 0 ]);
 341
 342   DN->get_config(\%myconfig, \%$form);
 343
 344   $form->{SHOW_DUNNING_LEVELS}   = scalar @{ $form->{DUNNING} };
 345
 346   $form->{title}    = $locale->text('Dunnings');
 347
 348   setup_dn_search_action_bar();
 349   $form->header();
 350
 351   print $form->parse_html_template("dunning/search");
 352
 353   $main::lxdebug->leave_sub();
 354
 355 }
 356
 357 sub show_dunning {
 358   $main::lxdebug->enter_sub();
 359
 360   my $form     = $main::form;
 361   my %myconfig = %main::myconfig;
 362   my $locale   = $main::locale;
 363   my $cgi      = $::request->{cgi};
 364
 365   $main::auth->assert('dunning_edit');
 366
 367   my @filter_field_list = qw(customer_id customer dunning_id dunning_level department_id invnumber ordnumber
 368                              transdatefrom transdateto dunningfrom dunningto notes showold l_salesman salesman_id
 369                              l_mails l_webdav l_documents);
 370
 371   report_generator_set_default_sort('customername', 1);
 372
 373   DN->get_dunning(\%myconfig, \%$form);
 374
 375   if (!$form->{callback}) {
 376     $form->{callback} = build_std_url("action=show_dunning", @filter_field_list);
 377   }
 378
 379   $form->get_lists('printers'  => 'printers',
 380                    'languages' => 'languages');
 381
 382   $form->{type}          = 'dunning';
 383   $form->{PRINT_OPTIONS} = print_options('inline'          => 1,
 384                                          'no_queue'        => 1,
 385                                          'no_postscript'   => 1,
 386                                          'no_html'         => 1,
 387                                          'no_opendocument' => 1,);
 388   $form->{title}         = $locale->text('Dunning overview');
 389
 390   my $report = SL::ReportGenerator->new(\%myconfig, $form);
 391
 392   $report->set_options('std_column_visibility' => 1,
 393                        'title'                 => $form->{title});
 394   $report->set_export_options('show_dunning', @filter_field_list, qw(sort sortdir));
 395
 396   my %column_defs         =  (
 397     'checkbox'            => { 'text' => '', 'visible' => 'HTML' },
 398     'dunning_description' => { 'text' => $locale->text('Dunning Level') },
 399     'customername'        => { 'text' => $locale->text('Customername') },
 400     'departmentname'      => { 'text' => $locale->text('Department') },
 401     'language'            => { 'text' => $locale->text('Language') },
 402     'invnumber'           => { 'text' => $locale->text('Invnumber') },
 403     'transdate'           => { 'text' => $locale->text('Invdate') },
 404     'duedate'             => { 'text' => $locale->text('Invoice Duedate') },
 405     'amount'              => { 'text' => $locale->text('Amount') },
 406     'dunning_id'          => { 'text' => $locale->text('Dunning number') },
 407     'dunning_date'        => { 'text' => $locale->text('Dunning Date') },
 408     'dunning_duedate'     => { 'text' => $locale->text('Dunning Duedate') },
 409     'fee'                 => { 'text' => $locale->text('Total Fees') },
 410     'interest'            => { 'text' => $locale->text('Interest') },
 411     'salesman'            => { 'text' => $locale->text('Salesperson'), 'visible' => $form->{l_salesman} ? 1 : 0 },
 412     'documents'           => { 'text' => $locale->text('Documents'),   'visible' => $form->{l_documents}? 1 : 0 },
 413     'webdav'              => { 'text' => $locale->text('WebDAV'),      'visible' => $form->{l_webdav}   ? 1 : 0 },
 414     'mails'               => { 'text' => $locale->text('Mails'),       'visible' => $form->{l_mails}    ? 1 : 0 },
 415   );
 416
 417   $report->set_columns(%column_defs);
 418   $report->set_column_order(qw(checkbox dunning_description dunning_id customername language invnumber transdate
 419                                duedate amount dunning_date dunning_duedate fee interest salesman departmentname mails webdav documents));
 420   $report->set_sort_indicator($form->{sort}, $form->{sortdir});
 421
 422   my $edit_url  = sub { build_std_url('script=' . ($_[0]->{invoice} ? 'is' : 'ar') . '.pl', 'action=edit', 'callback') . '&id=' . $::form->escape($_[0]->{id}) };
 423   my $print_url = sub { build_std_url('action=print_dunning', 'format=pdf', 'media=screen', 'dunning_id='.$_[0]->{dunning_id}, 'language_id=' . $_[0]->{language_id}) };
 424   my $sort_url  = build_std_url('action=show_dunning', grep { $form->{$_} } @filter_field_list);
 425
 426   foreach my $name (qw(dunning_description customername invnumber transdate duedate dunning_date dunning_duedate salesman dunning_id)) {
 427     my $sortdir                 = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
 428     $column_defs{$name}->{link} = $sort_url . "&sort=$name&sortdir=$sortdir";
 429   }
 430
 431   my %alignment = map { $_ => 'right' } qw(transdate duedate amount dunning_date dunning_duedate fee interest salesman dunning_id);
 432
 433   my ($current_dunning_rows, $previous_dunning_id, $first_row_for_dunning);
 434
 435   $current_dunning_rows  = [];
 436   $first_row_for_dunning = 1;
 437   $form->{rowcount}      = scalar @{ $form->{DUNNINGS} };
 438
 439   my $i = 0;
 440
 441   foreach my $ref (@{ $form->{DUNNINGS} }) {
 442     $i++;
 443
 444     if ($previous_dunning_id != $ref->{dunning_id}) {
 445       $report->add_data($current_dunning_rows) if (scalar @{ $current_dunning_rows });
 446       $current_dunning_rows  = [];
 447       $first_row_for_dunning = 1;
 448     }
 449
 450     if ($ref->{'language_id'}) {
 451       $ref->{language} = SL::DB::Manager::Language->find_by('id' => $ref->{'language_id'})->{'description'};
 452     }
 453
 454     my $row = { };
 455     foreach my $column (keys %{ $ref }) {
 456       $row->{$column} = {
 457         'data'  => $first_row_for_dunning || (none { $_ eq $column } qw(dunning_description customername dunning_id)) ? $ref->{$column} : '',
 458
 459         'align' => $alignment{$column},
 460
 461         'link'  => (  $column eq 'invnumber'           ? $edit_url->($ref)
 462                     : $column eq 'dunning_description' ? $print_url->($ref)
 463                     : $column eq 'dunning_id'          ? $print_url->($ref)
 464                     :                                    ''),
 465       };
 466     }
 467
 468     $row->{checkbox} = !$first_row_for_dunning ? { } : {
 469       'raw_data' =>   $cgi->hidden('-name' => "dunning_id_$i", '-value' => $ref->{dunning_id})
 470                     . $cgi->checkbox('-name' => "selected_$i", '-value' => 1, '-label' => ''),
 471       'valign'   => 'center',
 472       'align'    => 'center',
 473     };
 474
 475     if ($first_row_for_dunning) {
 476       $row->{language} = {'raw_data' => $cgi->hidden('-name' => "language_id_$i", '-value' => $ref->{language_id})
 477                                         . " $ref->{language}" };
 478     } else {
 479       $row->{language} = { };
 480     }
 481
 482     if ($form->{l_documents} && $first_row_for_dunning) {
 483       my @files  = SL::File->get_all_versions(object_id   => $ref->{dunning_id},
 484                                               object_type => 'dunning',
 485                                               file_type   => 'document',);
 486       if (scalar @files) {
 487         my $html          = join '<br>', map { SL::Presenter::FileObject::file_object($_) } @files;
 488         my $text          = join "\n",   map { $_->file_name                              } @files;
 489         $row->{documents} = { 'raw_data' => $html, data => $text };
 490       } else {
 491         $row->{documents} = { };
 492       }
 493     }
 494     if ($form->{l_webdav} && $first_row_for_dunning) {
 495       my $webdav = SL::Webdav->new(
 496         type     => 'dunning',
 497         number   => $ref->{dunning_id},
 498       );
 499       my @all_objects = $webdav->get_all_objects;
 500       if (scalar @all_objects) {
 501         my $html          = join '<br>', map { SL::Presenter::WebdavObject::webdav_object($_) } @all_objects;
 502         my $text          = join "\n",   map { $_->filename                                   } @all_objects;
 503         $row->{webdav}    = { 'raw_data' => $html, data => $text };
 504       } else {
 505         $row->{webdav}    = { };
 506       }
 507     }
 508
 509     if ($form->{l_mails}) {
 510       my @mail_links = RecordLinks->get_links(from_table => 'dunning', to_table => 'email_journal', from_id => $ref->{dunning_table_id});
 511       if (scalar @mail_links) {
 512         my $email_journals = SL::DB::Manager::EmailJournal->get_all(where => [id => [ map { $_->{to_id} } @mail_links ]]);
 513         my $html          = join '<br>', map { SL::Presenter::EmailJournal::email_journal($_) } @$email_journals;
 514         my $text          = join "\n",   map { $_->subject                                    } @$email_journals;
 515         $row->{mails}     = { 'raw_data' => $html, data => $text };
 516       } else {
 517         $row->{mails}     = { };
 518       }
 519     }
 520
 521     push @{ $current_dunning_rows }, $row;
 522
 523     $previous_dunning_id   = $ref->{dunning_id};
 524     $first_row_for_dunning = 0;
 525   }
 526
 527   $report->add_data($current_dunning_rows) if (scalar @{ $current_dunning_rows });
 528
 529   $report->set_options('raw_top_info_text'    => $form->parse_html_template('dunning/show_dunning_top'),
 530                        'raw_bottom_info_text' => $form->parse_html_template('dunning/show_dunning_bottom'),
 531                        'output_format'        => 'HTML',
 532                        'attachment_basename'  => $locale->text('dunning_list') . strftime('_%Y%m%d', localtime time),
 533     );
 534
 535   $report->set_options_from_form();
 536
 537   setup_dn_show_dunning_action_bar();
 538   $report->generate_with_headers();
 539
 540   $main::lxdebug->leave_sub();
 541
 542 }
 543
 544 sub print_dunning {
 545   $main::lxdebug->enter_sub();
 546
 547   my $form     = $main::form;
 548
 549   $main::auth->assert('dunning_edit');
 550
 551   $form->{rowcount}     = 1;
 552   $form->{selected_1}   = 1;
 553   $form->{dunning_id_1} = $form->{dunning_id};
 554   $form->{language_id_1} = $form->{language_id};
 555
 556   print_multiple();
 557
 558   $main::lxdebug->leave_sub();
 559 }
 560
 561 sub delete {
 562   $main::auth->assert('dunning_edit');
 563
 564   my @dunning_ids = map { $::form->{"dunning_id_$_"} } grep { $::form->{"selected_$_"} } (1..$::form->{rowcount});
 565
 566   if (!scalar @dunning_ids) {
 567     $::form->error($::locale->text('No dunnings have been selected for printing.'));
 568   }
 569
 570   my $dunnings = SL::DB::Manager::Dunning->get_all(query => [ dunning_id => \@dunning_ids ]);
 571
 572   SL::DB::Dunning->new->db->with_transaction(sub {
 573     for my $dunning (@$dunnings) {
 574       SL::DB::Manager::Invoice->find_by(id => $dunning->trans_id)->update_attributes(dunning_config_id => undef);
 575       $dunning->delete;
 576     }
 577   });
 578
 579   flash('info', t8('#1 dunnings have been deleted', scalar @$dunnings));
 580
 581   search();
 582 }
 583
 584 sub print_multiple {
 585   $main::lxdebug->enter_sub();
 586
 587   my $form     = $main::form;
 588   my %myconfig = %main::myconfig;
 589   my $locale   = $main::locale;
 590
 591   $main::auth->assert('dunning_edit');
 592
 593   $form->{title} = $locale->text('Print dunnings');
 594
 595   my @dunning_ids = map { $form->{"dunning_id_$_"} } grep { $form->{"selected_$_"} } (1..$form->{rowcount});
 596   my @language_ids = map { $form->{"language_id_$_"} } grep { $form->{"selected_$_"} } (1..$form->{rowcount});
 597
 598   if (!scalar @dunning_ids) {
 599     $form->error($locale->text('No dunnings have been selected for printing.'));
 600   }
 601
 602   $form->{DUNNING_PDFS} = [];
 603
 604   my $saved_language_id = $form->{language_id};
 605   my $i = 0;
 606   foreach my $dunning_id (@dunning_ids) {
 607     if (!$form->{force_lang}) {
 608       $form->{language_id} = $language_ids[$i];
 609     }
 610     $form->{dunning_id} = $dunning_id;
 611     DN->print_invoice_for_fees(\%myconfig, $form, $dunning_id);
 612     DN->print_dunning(\%myconfig, $form, $dunning_id);
 613
 614     # print original dunned invoices, if they where printed on dunning run
 615     my $dunnings = SL::DB::Manager::Dunning->get_all(where => [dunning_id => $dunning_id, original_invoice_printed => 1]);
 616     DN->print_original_invoice(\%myconfig, $form, $dunning_id, $_->trans_id) for @$dunnings;
 617
 618     $i++;
 619   }
 620   $form->{language_id} = $saved_language_id;
 621
 622   if (scalar @{ $form->{DUNNING_PDFS} }) {
 623     $form->{dunning_id} = strftime("%Y%m%d", localtime time) if scalar @{ $form->{DUNNING_PDFS}} > 1;
 624     DN->melt_pdfs(\%myconfig, $form, $form->{copies});
 625
 626     if ($form->{media} eq 'printer') {
 627       $form->header();
 628       $form->info($locale->text('The dunnings have been printed.'));
 629     }
 630
 631   } else {
 632     $form->redirect($locale->text('Could not print dunning.'));
 633   }
 634
 635   $main::lxdebug->leave_sub();
 636 }
 637
 638 sub continue {
 639   call_sub($main::form->{nextsub});
 640 }
 641
 642 sub dispatcher {
 643   foreach my $action (qw(delete print_multiple)) {
 644     if ($::form->{"action_${action}"}) {
 645       call_sub($action);
 646       return;
 647     }
 648   }
 649
 650   $::form->error($::locale->text('No action defined.'));
 651 }
 652
 653 sub setup_dn_add_action_bar {
 654   my %params = @_;
 655
 656   for my $bar ($::request->layout->get('actionbar')) {
 657     $bar->add(
 658       action => [
 659         t8('Search'),
 660         submit    => [ '#form', { action => "show_invoices" } ],
 661         accesskey => 'enter',
 662       ],
 663     );
 664   }
 665 }
 666
 667 sub setup_dn_show_invoices_action_bar {
 668   my %params = @_;
 669
 670   for my $bar ($::request->layout->get('actionbar')) {
 671     $bar->add(
 672       action => [
 673         t8('Create'),
 674         submit    => [ '#form', { action => "save_dunning" } ],
 675         checks    => [ [ 'kivi.check_if_entries_selected', '[name^=active_]' ] ],
 676         accesskey => 'enter',
 677         only_once => 1,
 678       ],
 679     );
 680   }
 681 }
 682
 683 sub setup_dn_search_action_bar {
 684   my %params = @_;
 685
 686   for my $bar ($::request->layout->get('actionbar')) {
 687     $bar->add(
 688       action => [
 689         t8('Search'),
 690         submit    => [ '#form', { action => "show_dunning" } ],
 691         accesskey => 'enter',
 692       ],
 693     );
 694   }
 695 }
 696
 697 sub setup_dn_show_dunning_action_bar {
 698   my %params = @_;
 699
 700   for my $bar ($::request->layout->get('actionbar')) {
 701     $bar->add(
 702       action => [
 703         t8('Print'),
 704         submit    => [ '#form', { action => "print_multiple" } ],
 705         checks    => [ [ 'kivi.check_if_entries_selected', '[name^=selected_]' ] ],
 706         accesskey => 'enter',
 707       ],
 708
 709       action => [
 710         t8('Delete'),
 711         submit  => [ '#form', { action => "delete" } ],
 712         checks  => [ [ 'kivi.check_if_entries_selected', '[name^=selected_]' ] ],
 713         confirm => $::locale->text('This resets the dunning process for the selected invoices. Posted dunning invoices will not be changed!'),
 714       ],
 715     );
 716   }
 717 }
 718
 719 sub setup_dn_edit_config_action_bar {
 720   my %params = @_;
 721
 722   for my $bar ($::request->layout->get('actionbar')) {
 723     $bar->add(
 724       action => [
 725         t8('Save'),
 726         submit    => [ '#form', { action => "save" } ],
 727         accesskey => 'enter',
 728       ],
 729     );
 730   }
 731 }
 732
 733 sub setup_dn_status_action_bar {
 734   for my $bar ($::request->layout->get('actionbar')) {
 735     $bar->add(
 736       action => [
 737         t8('Back'),
 738         link      => $::form->{callback},
 739         accesskey => 'enter',
 740       ],
 741     );
 742   }
 743
 744 }
 745
 746 # end of main