1 package SL::Controller::Letter;
4 use parent qw(SL::Controller::Base);
8 use POSIX qw(strftime);
9 use SL::Controller::Helper::GetModels;
10 use SL::Controller::Helper::ReportGenerator;
13 use SL::DB::LetterDraft;
15 use SL::Helper::Flash qw(flash flash_later);
16 use SL::Helper::CreatePDF;
17 use SL::Helper::PrintOptions;
18 use SL::Locale::String qw(t8);
21 use SL::ReportGenerator;
25 use Rose::Object::MakeMethods::Generic (
26 'scalar --get_set_init' => [ qw(letter all_employees models webdav_objects) ],
29 __PACKAGE__->run_before('check_auth_edit');
30 __PACKAGE__->run_before('check_auth_report', only => [ qw(list) ]);
32 use constant TEXT_CREATED_FOR_VALUES => (qw(presskit fax letter));
33 use constant PAGE_CREATED_FOR_VALUES => (qw(sketch 1 2));
37 subject => t8('Subject'),
38 letternumber => t8('Letternumber'),
39 customer_id => t8('Customer'),
40 contact => t8('Contact'),
44 my ($self, %params) = @_;
46 return if $self->load_letter_draft(%params);
48 $self->letter->employee_id(SL::DB::Manager::Employee->current->id);
49 $self->letter->salesman_id(SL::DB::Manager::Employee->current->id);
52 title => t8('Add Letter'),
53 language_id => $params{language_id},
58 my ($self, %params) = @_;
60 return $self->action_add
61 unless $::form->{letter} || $::form->{draft};
63 $self->letter(SL::DB::Letter->new_from_draft($::form->{draft}{id}))
67 title => t8('Edit Letter'),
72 my ($self, %params) = @_;
74 my $letter = $self->_update;
76 if (!$self->check_letter($letter)) {
77 return $self->_display;
83 flash('error', t8('There was an error saving the letter'));
84 return $self->_display;
87 flash('info', t8('Letter saved!'));
92 sub action_update_contacts {
95 my $letter = $self->letter;
97 if (!$self->letter->customer_id || !$self->letter->customer) {
101 SL::Presenter->get->select_tag('letter.cp_id', [], value_key => 'cp_id', title_key => 'full_name')
106 my $contacts = $letter->customer->contacts;
109 if ( $letter->contact
110 && $letter->contact->cp_cv_id
111 && $letter->contact->cp_cv_id == $letter->customer_id) {
112 $default = $letter->contact->cp_id;
120 SL::Presenter->get->select_tag('letter.cp_id', $contacts, default => $default, value_key => 'cp_id', title_key => 'full_name')
125 sub action_save_letter_draft {
126 my ($self, %params) = @_;
130 my $letter_draft = SL::DB::LetterDraft->new_from_letter($self->_update);
132 if (!$letter_draft->save) {
133 flash('error', t8('There was an error saving the letter draft'));
134 return $self->_display;
137 flash('info', t8('Draft for this Letter saved!'));
143 my ($self, %params) = @_;
145 if (!$self->letter->delete) {
146 flash('error', t8('An error occured. Letter could not be deleted.'));
147 return $self->action_update;
150 flash_later('info', t8('Letter deleted'));
151 $self->redirect_to(action => 'list');
154 sub action_delete_letter_drafts {
155 my ($self, %params) = @_;
157 my @ids = grep { /^checked_(.*)/ && $::form->{$_} } keys %$::form;
159 SL::DB::Manager::LetterDraft->delete_all(query => [ ids => \@ids ]) if @ids;
161 $self->redirect_to(action => 'add');
165 my ($self, %params) = @_;
167 $self->make_filter_summary;
168 $self->prepare_report;
170 my $letters = $self->models->get;
171 $self->report_generator_list_objects(report => $self->{report}, objects => $letters);
175 sub action_print_letter {
176 my ($self, %params) = @_;
178 my $display_form = $::form->{display_form} || "display_form";
179 my $letter = $self->_update;
181 $self->export_letter_to_form($letter);
182 $::form->{formname} = "letter";
183 $::form->{type} = "letter";
184 $::form->{format} = "pdf";
186 my $language_saved = $::form->{language_id};
187 my $greeting_saved = $::form->{greeting};
188 my $cp_id_saved = $::form->{cp_id};
190 $::form->{customer_id} = $self->letter->customer_id;
191 IS->customer_details(\%::myconfig, $::form);
194 # No contact was selected. Delete all contact variables because
195 # IS->customer_details() and IR->vendor_details() get the default
197 map({ delete($::form->{$_}); } grep(/^cp_/, keys(%{ $::form })));
200 $::form->{greeting} = $greeting_saved;
201 $::form->{language_id} = $language_saved;
203 if ($::form->{cp_id}) {
204 CT->get_contact(\%::myconfig, $::form);
207 $::form->{cp_contact_formal} = ($::form->{cp_greeting} ? "$::form->{cp_greeting} " : '') . ($::form->{cp_givenname} ? "$::form->{cp_givenname} " : '') . $::form->{cp_name};
209 $::form->get_employee_data('prefix' => 'employee', 'id' => $letter->{employee_id});
210 $::form->get_employee_data('prefix' => 'salesman', 'id' => $letter->{salesman_id});
212 my ($template_file, @template_files) = SL::Helper::CreatePDF->find_template(
214 printer_id => $::form->{printer_id},
215 language_id => $::form->{language_id},
216 formname => 'letter',
220 if (!defined $template_file) {
221 $::form->error($::locale->text('Cannot find matching template for this print request. Please contact your template maintainer. I tried these: #1.', join ', ', map { "'$_'"} @template_files));
224 my %create_params = (
225 template => $template_file,
226 variables => $::form,
227 return => 'file_name',
228 variable_content_types => {
235 $pdf_file_name = SL::Helper::CreatePDF->create_pdf(%create_params);
237 $::form->{letternumber} = $self->letter->letternumber;
238 my $attachment_name = $::form->generate_attachment_filename;
240 if ($::instance_conf->get_webdav_documents) {
241 my $webdav_file = SL::Webdav::File->new(
242 filename => $attachment_name,
243 webdav => SL::Webdav->new(
245 number => $self->letter->letternumber,
249 $webdav_file->store(file => $pdf_file_name);
252 # set some form defaults for printing webdav copy variables
253 if ( $::form->{media} eq 'email') {
254 my $mail = Mailer->new;
255 my $signature = $::myconfig{signature};
256 $mail->{$_} = $params{email}->{$_} for qw(to cc subject message bcc);
257 $mail->{from} = qq|"$::myconfig{name}" <$::myconfig{email}>|;
258 $mail->{attachments} = [{ filename => $pdf_file_name,
259 name => $params{email}->{attachment_filename} }];
260 $mail->{message} .= "\n-- \n$signature";
261 $mail->{message} =~ s/\r//g;
264 unlink $pdf_file_name;
266 flash_later('info', t8('The email has been sent.'));
267 $self->redirect_to(action => 'edit', 'letter.id' => $self->letter->id);
272 if (!$::form->{printer_id} || $::form->{media} eq 'screen') {
273 $self->send_file($pdf_file_name, name => $attachment_name);
274 unlink $pdf_file_name;
279 my $printer = SL::DB::Printer->new(id => $::form->{printer_id})->load;
280 $printer->print_document(
281 copies => $::form->{copies},
282 file_name => $pdf_file_name,
285 unlink $pdf_file_name;
287 flash_later('info', t8('The documents have been sent to the printer \'#1\'.', $printer->printer_description));
288 $self->redirect_to(action => 'edit', 'letter.id' => $self->letter->id, media => 'printer', printer_id => $::form->{printer_id});
291 unlink $pdf_file_name if $pdf_file_name;
292 $::form->error(t8("Creating the PDF failed:") . " " . $@);
297 my ($self, $name_selected) = @_;
300 letter => $self->_update,
304 sub action_skip_draft {
306 $self->action_add(skip_drafts => 1);
309 sub action_delete_drafts {
312 my @ids = @{ $::form->{ids} || [] };
313 SL::DB::Manager::LetterDraft->delete_all(where => [ id => \@ids ]) if @ids;
315 $self->action_add(skip_drafts => 1);
318 sub action_edit_email {
321 my $letter = $self->_update;
322 $self->export_letter_to_form($letter);
324 $::form->{formname} = "letter";
325 $::form->{type} = "letter";
326 $::form->{letternumber} = $self->letter->letternumber;
329 my $value = $letter->$_;
330 $value = $value->to_kivitendo if ref($_) =~ m{Date};
332 { name => "letter.$_", value => $value }
333 } ($letter->meta->columns);
336 script => 'controller.pl',
337 title => t8('Send letter via e-mail'),
338 email => $letter->contact ? $letter->contact->cp_email : '',
339 subject => $::form->generate_email_subject,
340 a_filename => $::form->generate_attachment_filename,
341 action => 'Letter/send_email',
343 SHOW_BCC => $::auth->assert('email_bcc', 'may fail'),
346 $self->render('generic/edit_email', %vars);
349 sub action_send_email {
352 $::form->{media} = 'email';
353 $self->action_print_letter(
355 to => $::form->{email},
356 map { ($_ => $::form->{$_}) } qw(cc bcc subject attachment_filename message)
362 my ($self, %params) = @_;
364 $::request->{layout}->use_javascript("${_}.js") for qw(ckeditor/ckeditor ckeditor/adapters/jquery);
366 my $letter = $self->letter;
368 $params{title} ||= t8('Edit Letter');
370 $::form->{type} = 'letter'; # needed for print_options
371 $::form->{vc} = 'customer'; # needs to be for _get_contacts...
373 $::request->layout->add_javascripts('customer_or_vendor_selection.js');
374 $::request->layout->add_javascripts('edit_part_window.js');
376 $::form->{language_id} ||= $params{language_id};
377 $::form->{printers} = SL::DB::Manager::Printer->get_all_sorted;
379 $self->render('letter/edit',
381 TCF => [ map { key => $_, value => t8(ucfirst $_) }, TEXT_CREATED_FOR_VALUES() ],
382 PCF => [ map { key => $_, value => t8(ucfirst $_) }, PAGE_CREATED_FOR_VALUES() ],
384 employees => $self->all_employees,
385 print_options => SL::Helper::PrintOptions->get_print_options (
386 options => { no_postscript => 1,
387 no_opendocument => 1,
395 my ($self, %params) = @_;
397 my $letter = $self->letter;
400 $self->set_greetings;
408 my $report = SL::ReportGenerator->new(\%::myconfig, $::form);
409 $self->{report} = $report;
411 my @columns = qw(date subject letternumber customer_id contact date);
412 my @sortable = qw(date subject letternumber customer_id contact date);
415 date => { text => t8('Date'), sub => sub { $_[0]->date_as_date } },
416 subject => { text => t8('Subject'), sub => sub { $_[0]->subject },
417 obj_link => sub { $self->url_for(action => 'edit', 'letter.id' => $_[0]->id, callback => $self->models->get_callback) } },
418 letternumber => { text => t8('Letternumber'), sub => sub { $_[0]->letternumber },
419 obj_link => sub { $self->url_for(action => 'edit', 'letter.id' => $_[0]->id, callback => $self->models->get_callback) } },
420 customer_id => { text => t8('Customer'), sub => sub { SL::DB::Manager::Customer->find_by_or_create(id => $_[0]->customer_id)->displayable_name } },
421 contact => { text => t8('Contact'), sub => sub { $_[0]->contact ? $_[0]->contact->full_name : '' } },
424 $column_defs{$_}{text} = $sort_columns{$_} for keys %column_defs;
426 $report->set_options(
427 std_column_visibility => 1,
428 controller_class => 'Letter',
429 output_format => 'HTML',
430 top_info_text => t8('Letters'),
431 title => t8('Letters'),
432 allow_pdf_export => 1,
433 allow_csv_export => 1,
436 $report->set_columns(%column_defs);
437 $report->set_column_order(@columns);
438 $report->set_export_options(qw(list filter));
439 $report->set_options_from_form;
441 $self->models->disable_plugin('paginated') if $report->{options}{output_format} =~ /^(pdf|csv)$/i;
442 $self->models->finalize;
443 $self->models->set_report_generator_sort_options(report => $report, sortable_columns => \@sortable);
445 $report->set_options(
446 raw_top_info_text => $self->render('letter/report_top', { output => 0 }),
447 raw_bottom_info_text => $self->render('letter/report_bottom', { output => 0 }, models => $self->models),
448 attachment_basename => t8('letters_list') . strftime('_%Y%m%d', localtime time),
452 sub make_filter_summary {
455 my $filter = $::form->{filter} || {};
458 my $employee = $filter->{employee_id} ? SL::DB::Employee->new(id => $filter->{employee_id})->load->name : '';
459 my $salesman = $filter->{salesman_id} ? SL::DB::Employee->new(id => $filter->{salesman_id})->load->name : '';
462 [ $filter->{"letternumber:substr::ilike"}, t8('Number') ],
463 [ $filter->{"subject:substr::ilike"}, t8('Subject') ],
464 [ $filter->{"body:substr::ilike"}, t8('Body') ],
465 [ $filter->{"date:date::ge"}, t8('From Date') ],
466 [ $filter->{"date:date::le"}, t8('To Date') ],
467 [ $employee, t8('Employee') ],
468 [ $salesman, t8('Salesman') ],
473 my @flags = map { $flags{$_} } @{ $filter->{part}{type} || [] };
476 push @filter_strings, $_ if $_;
479 push @filter_strings, "$_->[1]: $_->[0]" if $_->[0];
482 $self->{filter_summary} = join ', ', @filter_strings;
485 sub load_letter_draft {
486 my ($self, %params) = @_;
488 return 0 if $params{skip_drafts};
490 my $letter_drafts = SL::DB::Manager::LetterDraft->get_all;
492 return unless @$letter_drafts;
494 $self->render('letter/load_drafts',
495 title => t8('Letter Draft'),
496 LETTER_DRAFTS => $letter_drafts,
504 my $letter = $self->letter;
506 return unless $letter;
507 return if $letter->date;
509 $letter->date(DateTime->today)
513 my ($self, $letter) = @_;
515 $letter ||= $self->letter;
519 if (!$letter->subject) {
520 flash('error', t8('The subject is missing.'));
523 if (!$letter->body) {
524 flash('error', t8('The body is missing.'));
527 if (!$letter->employee_id) {
528 flash('error', t8('The employee is missing.'));
536 my ($self, $letter) = @_;
538 $letter ||= $self->letter;
540 return if $letter->letternumber;
542 $letter->letternumber(SL::TransNumber->new(type => 'letter', id => $self->{id}, number => $self->{letternumber})->create_unique);
547 my $letter = $self->letter;
549 return unless $letter;
550 return if $letter->greeting;
552 $letter->greeting(t8('Dear Sir or Madam,'));
555 sub export_letter_to_form {
556 my ($self, $letter) = @_;
559 $letter ||= $self->letter;
561 for ($letter->meta->columns) {
562 if ((ref $_) =~ /Date/i) {
563 $::form->{$_->name} = $letter->$_->to_kivitendo;
565 $::form->{$_->name} = $letter->$_;
573 my $letter = SL::DB::Manager::Letter->find_by_or_create(id => $::form->{letter}{id} || 0)
574 ->assign_attributes(%{ $::form->{letter} });
576 if ($letter->cp_id) {
577 # $letter->customer_id($letter->contact->cp_cv_id);
578 # contacts don't have language_id yet
579 # $letter->greeting(GenericTranslations->get(
580 # translation_type => 'greetings::' . ($letter->contact->cp_gender eq 'f' ? 'female' : 'male'),
581 # language_id => $letter->contact->language_id,
582 # allow_fallback => 1
592 SL::Controller::Helper::GetModels->new(
595 sorted => \%sort_columns,
596 with_objects => [ 'contact', 'salesman', 'employee' ],
600 sub init_all_employees {
601 SL::DB::Manager::Employee->get_all(query => [ deleted => 0 ]);
604 sub init_webdav_objects {
607 return [] if !$self->letter || !$self->letter->letternumber || !$::instance_conf->get_webdav;
609 my $webdav = SL::Webdav->new(
611 number => $self->letter->letternumber,
614 my $webdav_path = $webdav->webdav_path;
615 my @all_objects = $webdav->get_all_objects;
618 +{ name => $_->filename,
620 link => File::Spec->catdir($webdav_path, $_->filename),
625 sub check_auth_edit {
626 $::auth->assert('sales_letter_edit');
629 sub check_auth_report {
630 $::auth->assert('sales_letter_report');
641 SL::Controller::Letter - Letters CRUD and printing
645 Simple letter CRUD controller with drafting capabilities.
649 Customer/Vendor switch for dealing with vendor letters
651 copy to webdav is crap
653 customer/vendor stuff
657 Sven Schöling E<lt>s.schoeling@linet-services.deE<gt>