1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
11 #======================================================================
14 use POSIX qw(strftime);
16 use SL::GenericTranslations;
17 use SL::ReportGenerator;
22 use SL::Helper::CreatePDF;
23 use SL::Helper::Flash;
24 require "bin/mozilla/reportgenerator.pl";
25 require "bin/mozilla/io.pl";
26 require "bin/mozilla/arap.pl";
28 use constant TEXT_CREATED_FOR_VALUES => (qw(presskit fax letter));
29 use constant PAGE_CREATED_FOR_VALUES => (qw(sketch 1 2));
31 our ($form, %myconfig, $locale, $lxdebug);
34 # $locale->text('Presskit')
35 # $locale->text('Sketch')
36 # $locale->text('Fax')
37 # $locale->text('Letter')
40 $::lxdebug->enter_sub;
42 $main::auth->assert('sales_letter_edit');
45 return $main::lxdebug->leave_sub if load_letter_draft();
47 my $letter = SL::Letter->new(%params);
49 if (my $cp_id = delete $::form->{contact_id}) {
50 my $contact = SL::DB::Manager::Contact->find_by(cp_id => $cp_id);
51 $letter->{cp_id} = $contact->cp_id;
52 $letter->{vc_id} = $contact->cp_cv_id;
53 $letter->{greeting} = GenericTranslations->get(
54 translation_type => 'greetings::' . ($contact->{cp_gender} eq 'f' ? 'female' : 'male'),
55 language_id => $contact->language_id,
58 $params{language_id} = $contact->language_id;
65 title => $locale->text('Add Letter'),
66 language_id => $params{language_id},
69 $::lxdebug->leave_sub;
73 $::lxdebug->enter_sub;
75 $main::auth->assert('sales_letter_edit');
76 add() unless ($form->{id});
78 my $letter = SL::Letter->new( id => $form->{id}, draft => $form->{draft} )->load;
80 add() unless $letter && ($letter->{id} || $letter->{draft_id});
84 title => $locale->text('Edit Letter'),
87 $::lxdebug->leave_sub;
91 $::lxdebug->enter_sub;
93 $main::auth->assert('sales_letter_edit');
97 $::form->error(t8('The subject is missing.')) unless $form->{letter}->{subject};
98 $::form->error(t8('The body is missing.')) unless $form->{letter}->{body};
99 $::form->error(t8('The employee is missing.')) unless $form->{letter}->{employee_id};
101 my $letter = _update();
103 $letter->check_number;
106 $form->{SAVED_MESSAGE} = $locale->text('Letter saved!');
112 $::lxdebug->leave_sub;
115 sub save_letter_draft {
116 $::lxdebug->enter_sub;
118 $main::auth->assert('sales_letter_edit');
120 $::form->error(t8('The subject is missing.')) unless $form->{letter}->{subject};
121 $::form->error(t8('The body is missing.')) unless $form->{letter}->{body};
122 $::form->error(t8('The employee is missing.')) unless $form->{letter}->{employee_id};
123 $::form->error(t8('Already as letter saved.')) if $form->{letter}->{letternumber};
125 my $letter_draft = _update();
126 $letter_draft->{draft_id} = delete $letter_draft->{id}; # if we have one
127 $letter_draft->save(draft => '1');
128 $letter_draft->{vergiss_mich_nicht} = 'nicht vergessen';
129 $form->{SAVED_MESSAGE} = $locale->text('Draft for this Letter saved!');
132 letter => $letter_draft,
135 $::lxdebug->leave_sub;
139 $main::lxdebug->enter_sub();
141 $main::auth->assert('sales_letter_edit');
143 $form->{SAVED_MESSAGE} = $locale->text('Not yet implemented!');
146 $main::lxdebug->leave_sub();
149 sub delete_letter_drafts {
150 $main::lxdebug->enter_sub();
152 $main::auth->assert('sales_letter_edit');
155 foreach (keys %{$form}) {
156 push @ids, $1 if (/^checked_(.*)/ && $form->{$_});
159 SL::Letter->delete_drafts(@ids) if (@ids); #->{id});
163 $main::lxdebug->leave_sub();
167 $main::lxdebug->enter_sub();
169 $main::auth->assert('sales_letter_edit');
172 my $letter = $params{letter};
176 $form->{type} = 'letter'; # needed for print_options
177 $form->{vc} = 'customer'; # needs to be for _get_contacts...
178 $form->{"$form->{vc}_id"} ||= $letter->{customer_id};
179 $form->{jsscript} = 1;
180 $form->{javascript} =
181 qq|<script type="text/javascript" src="js/customer_or_vendor_selection.js"></script>
182 <script type="text/javascript" src="js/edit_part_window.js"></script>|;
184 $form->get_lists("contacts" => "ALL_CONTACTS",
185 "employees" => "ALL_EMPLOYEES",
186 "salesmen" => "ALL_SALESMEN",
187 "departments" => "ALL_DEPARTMENTS",
188 "languages" => "languages",
189 "customers" => { key => "ALL_CUSTOMERS",
190 limit => $myconfig{vclimit} + 1 },
194 $TMPL_VAR{vc_keys} = sub { "$_[0]->{name}--$_[0]->{id}" };
195 $TMPL_VAR{vc_select} = "customer_or_vendor_selection_window('letter.customer', '', 0, 0)";
196 $TMPL_VAR{ct_labels} = sub { ($_[0]->{cp_greeting} ? "$_[0]->{cp_greeting} " : '') . $_[0]->{cp_name} . ($_[0]->{cp_givenname} ? ", $_[0]->{cp_givenname}" : '') };
197 $TMPL_VAR{TCF} = [ map { key => $_, value => $locale->text(ucfirst $_) }, TEXT_CREATED_FOR_VALUES() ];
198 $TMPL_VAR{PCF} = [ map { key => $_, value => $locale->text(ucfirst $_) }, PAGE_CREATED_FOR_VALUES() ];
202 $form->{language_id} ||= $params{language_id};
204 print $form->parse_html_template('letter/edit', {
208 print_options => print_options(inline => 1),
211 $main::lxdebug->leave_sub();
215 $lxdebug->enter_sub();
217 $main::auth->assert('sales_letter_report');
219 $form->get_lists("employees" => "EMPLOYEES",
220 "salesmen" => "SALESMEN",
221 "customers" => "ALL_CUSTOMERS");
223 $form->{jsscript} = 1;
224 $form->{title} = $locale->text('Letters');
227 print $form->parse_html_template('letter/search');
229 $lxdebug->leave_sub();
233 $lxdebug->enter_sub();
235 $main::auth->assert('sales_letter_report');
239 my @report_params = qw(letternumber subject body contact date_from date_to cp_id);
241 if ($form->{selectcustomer}) {
242 push @report_params, 'customer_id';
243 $form->{customer_id} = $form->{customer};
245 push @report_params, 'customer';
248 report_generator_set_default_sort('date', 1);
250 %params = (%params, map { $_ => $form->{$_} } @report_params);
252 my @letters = SL::Letter->find(%params);
254 $form->{rowcount} = @letters;
255 $form->{title} = $locale->text('Letters');
258 'date' => { 'text' => $locale->text('Date'), },
259 'subject' => { 'text' => $locale->text('Subject'), },
260 'letternumber' => { 'text' => $locale->text('Letternumber'), },
261 'customer' => { 'text' => $locale->text('Customer') },
262 'contact' => { 'text' => $locale->text('Contact') },
263 'date' => { 'text' => $locale->text('Date') },
266 my @columns = qw(date subject letternumber customer contact date);
267 my $href = build_std_url('action=report', grep { $form->{$_} } @report_params);
269 my @sortable_columns = qw(date subject letternumber customer contact date);
271 foreach my $name (@sortable_columns) {
272 my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
273 $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
280 push @options, $locale->text('Subject') . " : $form->{subject}" if ($form->{subject});
281 push @options, $locale->text('Body') . " : $form->{body}" if ($form->{body});
283 my @hidden_report_params = map { +{ 'key' => $_, 'value' => $form->{$_} } } @report_params;
285 my $report = SL::ReportGenerator->new(\%myconfig, $form, 'std_column_visibility' => 1);
287 $report->set_columns(%column_defs);
288 $report->set_column_order(@columns);
290 $report->set_export_options('report', @report_params);
292 $report->set_sort_indicator($form->{sort}, $form->{sortdir});
294 $report->set_options('raw_top_info_text' => $form->parse_html_template('letter/report_top', { 'OPTIONS' => \@options }),
295 'raw_bottom_info_text' => $form->parse_html_template('letter/report_bottom', { 'HIDDEN' => \@hidden_report_params }),
296 'output_format' => 'HTML',
297 'title' => $form->{title},
298 'attachment_basename' => $locale->text('letters_list') . strftime('_%Y%m%d', localtime time),
300 $report->set_options_from_form();
303 my $callback = build_std_url('action=report', grep { $form->{$_} } @report_params);
304 my $edit_url = build_std_url('action=edit', 'callback=' . E($callback));
306 foreach my $l (@letters) {
309 my $row = { map { $_ => { 'data' => $l->{$_} } } keys %{ $l } };
311 $row->{subject}->{link} = $edit_url . '&id=' . Q($l->{id});
312 $row->{letternumber}->{link} = $edit_url . '&id=' . Q($l->{id});
314 $report->add_data($row);
317 $report->generate_with_headers();
319 $lxdebug->leave_sub();
323 $lxdebug->enter_sub();
325 $main::auth->assert('sales_letter_edit');
329 my $display_form = $form->{display_form} || "display_form";
330 my $letter = _update();
332 $letter->export_to($form);
333 $form->{formname} = "letter";
334 $form->{format} = "pdf";
336 my $language_saved = $form->{language_id};
337 my $greeting_saved = $form->{greeting};
338 my $cp_id_saved = $form->{cp_id};
340 call_sub("customer_details");
343 # No contact was selected. Delete all contact variables because
344 # IS->customer_details() and IR->vendor_details() get the default
346 map({ delete($form->{$_}); } grep(/^cp_/, keys(%{ $form })));
349 $form->{greeting} = $greeting_saved;
350 $form->{language_id} = $language_saved;
352 if ($form->{cp_id}) {
353 CT->get_contact(\%myconfig, $form);
356 $form->{cp_contact_formal} = ($form->{cp_greeting} ? "$form->{cp_greeting} " : '') . ($form->{cp_givenname} ? "$form->{cp_givenname} " : '') . $form->{cp_name};
358 $form->get_employee_data('prefix' => 'employee', 'id' => $letter->{employee_id});
359 $form->get_employee_data('prefix' => 'salesman', 'id' => $letter->{salesman_id});
361 my %create_params = (
362 template => scalar(SL::Helper::CreatePDF->find_template(
364 printer_id => $::form->{printer_id},
365 language_id => $::form->{language_id},
366 formname => 'letter',
369 variables => $::form,
370 return => 'file_name',
374 $pdf_file_name = SL::Helper::CreatePDF->create_pdf(%create_params);
376 if ( $::form->{media} eq 'email') {
377 my $mail = Mailer->new;
378 my $signature = $::myconfig{signature};
379 $mail->{$_} = $::form->{$_} for qw(cc subject message bcc to);
380 $mail->{from} = qq|"$::myconfig{name}" <$::myconfig{email}>|;
381 $mail->{fileid} = time() . '.' . $$ . '.';
382 $mail->{attachments} = [{ "filename" => $pdf_file_name,
383 "name" => $::form->{attachment_name} }];
384 $mail->{message} .= "\n-- \n$signature";
385 $mail->{message} =~ s/\r//g;
387 my $err = $mail->send;
391 # ->flash($err?'error':'info',
392 # $err?t8('A mail error occurred: #1', $err):
393 # t8('The document have been sent to \'#1\'.', $mail->{to}))
398 if (!$::form->{printer_id}) {
399 my $file = IO::File->new($pdf_file_name, 'r') || croak("Cannot open file '$pdf_file_name'");
400 my $size = -s $pdf_file_name;
401 my $content_type = 'application/pdf';
402 my $attachment_name = $::form->generate_attachment_filename;
403 $attachment_name =~ s:.*//::g;
405 print $::form->create_http_response(content_type => $content_type,
406 content_disposition => 'attachment; filename="' . $attachment_name . '"',
407 content_length => $size);
409 $::locale->with_raw_io(\*STDOUT, sub { print while <$file> });
411 unlink $pdf_file_name;
415 my $printer = SL::DB::Printer->new(id => $::form->{printer_id})->load;
416 my $command = SL::Template::create(type => 'ShellCommand', form => Form->new(''))->parse($printer->printer_command);
418 open my $out, '|-', $command or die $!;
420 print $out scalar(read_file($pdf_file_name));
423 flash_later('info', t8('The documents have been sent to the printer \'#1\'.', $printer->printer_description));
424 my $callback = build_std_url('letter.pl', 'action=edit', 'id=' . $letter->{id}, 'printer_id');
428 unlink $pdf_file_name;
429 $::form->error(t8("Creating the PDF failed:") . " " . $@);
432 $lxdebug->leave_sub();
436 $::lxdebug->enter_sub;
438 $main::auth->assert('sales_letter_edit');
440 my $name_selected = shift;
444 _name_selected => $name_selected,
448 $::lxdebug->leave_sub;
452 $::lxdebug->enter_sub;
454 $main::auth->assert('sales_letter_edit');
458 my $from_letter = $::form->{letter};
460 my $letter = SL::Letter->new( id => $from_letter->{id} )
462 ->update_from($from_letter);
464 $letter->check_name(%params);
466 $letter->set_greetings;
468 $::lxdebug->leave_sub;
474 $::lxdebug->enter_sub;
476 $main::auth->assert('sales_letter_edit');
478 my @report_params = qw(letternumber subject contact date);
480 my @letters = SL::Letter->find(map { $_ => $form->{$_} } @report_params);
482 $::lxdebug->leave_sub;
486 $::lxdebug->enter_sub;
488 $main::auth->assert('sales_letter_edit');
489 my $letter = _update();
491 $letter->check_number;
494 $letter->export_to($::form);
496 $::form->{id} = $letter->{id};
499 $::lxdebug->leave_sub;
503 $main::lxdebug->enter_sub();
505 my $locale = $main::locale;
508 if ($form->{letter_draft_action} eq $locale->text("Skip")) {
509 $form->{DONT_LOAD_DRAFT} = 1;
512 } elsif ($form->{letter_draft_action} eq $locale->text("Delete drafts")) {
513 delete_letter_drafts();
517 foreach my $action (qw(e_mail print save update save_letter_draft)) {
518 if ($::form->{"action_${action}"}) {
519 $::form->{dispatched_action} = $action;
525 $::form->error($::locale->text('No action defined.'));
526 $::lxdebug->leave_sub;
530 call_sub($form->{nextsub});
534 sub load_letter_draft {
535 $lxdebug->enter_sub();
537 $main::auth->assert('sales_letter_edit');
538 $main::lxdebug->leave_sub() and return 0 if ($form->{DONT_LOAD_DRAFT});
539 $form->{title} = $locale->text('Letter Draft');
540 $form->{script} = 'letter.pl';
542 my @letter_drafts = SL::Letter->find(draft => 1);
544 return unless @letter_drafts;
546 print $form->parse_html_template('letter/load_drafts', { LETTER_DRAFTS => \@letter_drafts });
549 $lxdebug->leave_sub();