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;
26 require "bin/mozilla/reportgenerator.pl";
27 require "bin/mozilla/io.pl";
28 require "bin/mozilla/arap.pl";
30 use constant TEXT_CREATED_FOR_VALUES => (qw(presskit fax letter));
31 use constant PAGE_CREATED_FOR_VALUES => (qw(sketch 1 2));
33 our ($form, %myconfig, $locale, $lxdebug);
36 # $locale->text('Presskit')
37 # $locale->text('Sketch')
38 # $locale->text('Fax')
39 # $locale->text('Letter')
42 $::lxdebug->enter_sub;
44 $main::auth->assert('sales_letter_edit');
47 return $main::lxdebug->leave_sub if load_letter_draft();
49 my $letter = SL::Letter->new(%params);
51 if (my $cp_id = delete $::form->{contact_id}) {
52 my $contact = SL::DB::Manager::Contact->find_by(cp_id => $cp_id);
53 $letter->{cp_id} = $contact->cp_id;
54 $letter->{vc_id} = $contact->cp_cv_id;
55 $letter->{greeting} = GenericTranslations->get(
56 translation_type => 'greetings::' . ($contact->{cp_gender} eq 'f' ? 'female' : 'male'),
57 language_id => $contact->language_id,
60 $params{language_id} = $contact->language_id;
67 title => $locale->text('Add Letter'),
68 language_id => $params{language_id},
71 $::lxdebug->leave_sub;
75 $::lxdebug->enter_sub;
77 $main::auth->assert('sales_letter_edit');
78 add() unless ($form->{id});
80 my $letter = SL::Letter->new( id => $form->{id}, draft => $form->{draft} )->load;
82 add() unless $letter && ($letter->{id} || $letter->{draft_id});
86 title => $locale->text('Edit Letter'),
89 $::lxdebug->leave_sub;
93 $::lxdebug->enter_sub;
95 $main::auth->assert('sales_letter_edit');
99 $::form->error(t8('The subject is missing.')) unless $form->{letter}->{subject};
100 $::form->error(t8('The body is missing.')) unless $form->{letter}->{body};
101 $::form->error(t8('The employee is missing.')) unless $form->{letter}->{employee_id};
103 my $letter = _update();
105 $letter->check_number;
108 $form->{SAVED_MESSAGE} = $locale->text('Letter saved!');
114 $::lxdebug->leave_sub;
117 sub save_letter_draft {
118 $::lxdebug->enter_sub;
120 $main::auth->assert('sales_letter_edit');
122 $::form->error(t8('The subject is missing.')) unless $form->{letter}->{subject};
123 $::form->error(t8('The body is missing.')) unless $form->{letter}->{body};
124 $::form->error(t8('The employee is missing.')) unless $form->{letter}->{employee_id};
125 $::form->error(t8('Already as letter saved.')) if $form->{letter}->{letternumber};
127 my $letter_draft = _update();
128 $letter_draft->{draft_id} = delete $letter_draft->{id}; # if we have one
129 $letter_draft->save(draft => '1');
130 $letter_draft->{vergiss_mich_nicht} = 'nicht vergessen';
131 $form->{SAVED_MESSAGE} = $locale->text('Draft for this Letter saved!');
134 letter => $letter_draft,
137 $::lxdebug->leave_sub;
141 $main::lxdebug->enter_sub();
143 $main::auth->assert('sales_letter_edit');
145 $form->{SAVED_MESSAGE} = $locale->text('Not yet implemented!');
148 $main::lxdebug->leave_sub();
151 sub delete_letter_drafts {
152 $main::lxdebug->enter_sub();
154 $main::auth->assert('sales_letter_edit');
157 foreach (keys %{$form}) {
158 push @ids, $1 if (/^checked_(.*)/ && $form->{$_});
161 SL::Letter->delete_drafts(@ids) if (@ids); #->{id});
165 $main::lxdebug->leave_sub();
169 $main::lxdebug->enter_sub();
171 $main::auth->assert('sales_letter_edit');
174 my $letter = $params{letter};
178 $form->{type} = 'letter'; # needed for print_options
179 $form->{vc} = 'customer'; # needs to be for _get_contacts...
180 $form->{"$form->{vc}_id"} ||= $letter->{customer_id};
181 $form->{jsscript} = 1;
182 $form->{javascript} =
183 qq|<script type="text/javascript" src="js/customer_or_vendor_selection.js"></script>
184 <script type="text/javascript" src="js/edit_part_window.js"></script>|;
186 $form->get_lists("contacts" => "ALL_CONTACTS",
187 "employees" => "ALL_EMPLOYEES",
188 "salesmen" => "ALL_SALESMEN",
189 "departments" => "ALL_DEPARTMENTS",
190 "languages" => "languages",
191 "customers" => { key => "ALL_CUSTOMERS",
192 limit => $myconfig{vclimit} + 1 },
196 $TMPL_VAR{vc_keys} = sub { "$_[0]->{name}--$_[0]->{id}" };
197 $TMPL_VAR{vc_select} = "customer_or_vendor_selection_window('letter.customer', '', 0, 0)";
198 $TMPL_VAR{ct_labels} = sub { ($_[0]->{cp_greeting} ? "$_[0]->{cp_greeting} " : '') . $_[0]->{cp_name} . ($_[0]->{cp_givenname} ? ", $_[0]->{cp_givenname}" : '') };
199 $TMPL_VAR{TCF} = [ map { key => $_, value => $locale->text(ucfirst $_) }, TEXT_CREATED_FOR_VALUES() ];
200 $TMPL_VAR{PCF} = [ map { key => $_, value => $locale->text(ucfirst $_) }, PAGE_CREATED_FOR_VALUES() ];
204 $form->{language_id} ||= $params{language_id};
206 print $form->parse_html_template('letter/edit', {
210 print_options => print_options(inline => 1),
213 $main::lxdebug->leave_sub();
217 $lxdebug->enter_sub();
219 $main::auth->assert('sales_letter_report');
221 $form->get_lists("employees" => "EMPLOYEES",
222 "salesmen" => "SALESMEN",
223 "customers" => "ALL_CUSTOMERS");
225 $form->{jsscript} = 1;
226 $form->{title} = $locale->text('Letters');
229 print $form->parse_html_template('letter/search');
231 $lxdebug->leave_sub();
235 $lxdebug->enter_sub();
237 $main::auth->assert('sales_letter_report');
241 my @report_params = qw(letternumber subject body contact date_from date_to cp_id);
243 if ($form->{selectcustomer}) {
244 push @report_params, 'customer_id';
245 $form->{customer_id} = $form->{customer};
247 push @report_params, 'customer';
250 report_generator_set_default_sort('date', 1);
252 %params = (%params, map { $_ => $form->{$_} } @report_params);
254 my @letters = SL::Letter->find(%params);
256 $form->{rowcount} = @letters;
257 $form->{title} = $locale->text('Letters');
260 'date' => { 'text' => $locale->text('Date'), },
261 'subject' => { 'text' => $locale->text('Subject'), },
262 'letternumber' => { 'text' => $locale->text('Letternumber'), },
263 'customer' => { 'text' => $locale->text('Customer') },
264 'contact' => { 'text' => $locale->text('Contact') },
265 'date' => { 'text' => $locale->text('Date') },
268 my @columns = qw(date subject letternumber customer contact date);
269 my $href = build_std_url('action=report', grep { $form->{$_} } @report_params);
271 my @sortable_columns = qw(date subject letternumber customer contact date);
273 foreach my $name (@sortable_columns) {
274 my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
275 $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
282 push @options, $locale->text('Subject') . " : $form->{subject}" if ($form->{subject});
283 push @options, $locale->text('Body') . " : $form->{body}" if ($form->{body});
285 my @hidden_report_params = map { +{ 'key' => $_, 'value' => $form->{$_} } } @report_params;
287 my $report = SL::ReportGenerator->new(\%myconfig, $form, 'std_column_visibility' => 1);
289 $report->set_columns(%column_defs);
290 $report->set_column_order(@columns);
292 $report->set_export_options('report', @report_params);
294 $report->set_sort_indicator($form->{sort}, $form->{sortdir});
296 $report->set_options('raw_top_info_text' => $form->parse_html_template('letter/report_top', { 'OPTIONS' => \@options }),
297 'raw_bottom_info_text' => $form->parse_html_template('letter/report_bottom', { 'HIDDEN' => \@hidden_report_params }),
298 'output_format' => 'HTML',
299 'title' => $form->{title},
300 'attachment_basename' => $locale->text('letters_list') . strftime('_%Y%m%d', localtime time),
302 $report->set_options_from_form();
305 my $callback = build_std_url('action=report', grep { $form->{$_} } @report_params);
306 my $edit_url = build_std_url('action=edit', 'callback=' . E($callback));
308 foreach my $l (@letters) {
311 my $row = { map { $_ => { 'data' => $l->{$_} } } keys %{ $l } };
313 $row->{subject}->{link} = $edit_url . '&id=' . Q($l->{id});
314 $row->{letternumber}->{link} = $edit_url . '&id=' . Q($l->{id});
316 $report->add_data($row);
319 $report->generate_with_headers();
321 $lxdebug->leave_sub();
325 $lxdebug->enter_sub();
327 $main::auth->assert('sales_letter_edit');
331 my $display_form = $form->{display_form} || "display_form";
332 my $letter = _update();
334 $letter->export_to($form);
335 $form->{formname} = "letter";
336 $form->{format} = "pdf";
338 my $language_saved = $form->{language_id};
339 my $greeting_saved = $form->{greeting};
340 my $cp_id_saved = $form->{cp_id};
342 call_sub("customer_details");
345 # No contact was selected. Delete all contact variables because
346 # IS->customer_details() and IR->vendor_details() get the default
348 map({ delete($form->{$_}); } grep(/^cp_/, keys(%{ $form })));
351 $form->{greeting} = $greeting_saved;
352 $form->{language_id} = $language_saved;
354 if ($form->{cp_id}) {
355 CT->get_contact(\%myconfig, $form);
358 $form->{cp_contact_formal} = ($form->{cp_greeting} ? "$form->{cp_greeting} " : '') . ($form->{cp_givenname} ? "$form->{cp_givenname} " : '') . $form->{cp_name};
360 $form->get_employee_data('prefix' => 'employee', 'id' => $letter->{employee_id});
361 $form->get_employee_data('prefix' => 'salesman', 'id' => $letter->{salesman_id});
363 my %create_params = (
364 template => scalar(SL::Helper::CreatePDF->find_template(
366 printer_id => $::form->{printer_id},
367 language_id => $::form->{language_id},
368 formname => 'letter',
371 variables => $::form,
372 return => 'file_name',
376 # catch LaTeX template not found error
377 my $tex_templates = $::instance_conf->get_templates . '/letter.tex';
378 die( t8('Please create/copy a template named letter.tex in your client template dir') ) unless (-e $tex_templates);
380 $pdf_file_name = SL::Helper::CreatePDF->create_pdf(%create_params);
382 # set some form defaults for printing webdav copy variables
383 $form->{tmpfile} = $pdf_file_name;
384 $form->{tmpdir} = 'users';
385 $form->{type} = 'letter';
386 $form->{cwd} = getcwd();
387 if ( $::form->{media} eq 'email') {
388 my $mail = Mailer->new;
389 my $signature = $::myconfig{signature};
390 $mail->{$_} = $::form->{$_} for qw(cc subject message bcc to);
391 $mail->{from} = qq|"$::myconfig{name}" <$::myconfig{email}>|;
392 $mail->{fileid} = time() . '.' . $$ . '.';
393 $mail->{attachments} = [{ "filename" => $pdf_file_name,
394 "name" => $::form->{attachment_name} }];
395 $mail->{message} .= "\n-- \n$signature";
396 $mail->{message} =~ s/\r//g;
398 # copy_file_to_webdav was already done via io.pl -> edit_e_mail
399 my $err = $mail->send;
403 # ->flash($err?'error':'info',
404 # $err?t8('A mail error occurred: #1', $err):
405 # t8('The document have been sent to \'#1\'.', $mail->{to}))
410 if (!$::form->{printer_id} || $::form->{media} eq 'screen') {
412 my $file = IO::File->new($pdf_file_name, 'r') || croak("Cannot open file '$pdf_file_name'");
413 my $size = -s $pdf_file_name;
414 my $content_type = 'application/pdf';
415 my $attachment_name = $::form->generate_attachment_filename;
416 $attachment_name =~ s:.*//::g;
418 print $::form->create_http_response(content_type => $content_type,
419 content_disposition => 'attachment; filename="' . $attachment_name . '"',
420 content_length => $size);
422 $::locale->with_raw_io(\*STDOUT, sub { print while <$file> });
424 Common::copy_file_to_webdav_folder($form) if $::instance_conf->get_webdav_documents;
425 unlink $pdf_file_name;
429 my $printer = SL::DB::Printer->new(id => $::form->{printer_id})->load;
430 my $command = SL::Template::create(type => 'ShellCommand', form => Form->new(''))->parse($printer->printer_command);
432 open my $out, '|-', $command or die $!;
434 print $out scalar(read_file($pdf_file_name));
436 Common::copy_file_to_webdav_folder($form) if $::instance_conf->get_webdav_documents;
438 flash_later('info', t8('The documents have been sent to the printer \'#1\'.', $printer->printer_description));
439 my $callback = build_std_url('letter.pl', 'action=edit', 'id=' . $letter->{id}, 'printer_id');
443 unlink $pdf_file_name;
444 $::form->error(t8("Creating the PDF failed:") . " " . $@);
447 $lxdebug->leave_sub();
451 $::lxdebug->enter_sub;
453 $main::auth->assert('sales_letter_edit');
455 my $name_selected = shift;
459 _name_selected => $name_selected,
463 $::lxdebug->leave_sub;
467 $::lxdebug->enter_sub;
469 $main::auth->assert('sales_letter_edit');
473 my $from_letter = $::form->{letter};
475 my $letter = SL::Letter->new( id => $from_letter->{id} )
477 ->update_from($from_letter);
479 $letter->check_name(%params);
481 $letter->set_greetings;
483 $::lxdebug->leave_sub;
489 $::lxdebug->enter_sub;
491 $main::auth->assert('sales_letter_edit');
493 my @report_params = qw(letternumber subject contact date);
495 my @letters = SL::Letter->find(map { $_ => $form->{$_} } @report_params);
497 $::lxdebug->leave_sub;
501 $::lxdebug->enter_sub;
503 $main::auth->assert('sales_letter_edit');
504 my $letter = _update();
506 $letter->check_number;
509 $form->{formname} = "letter";
510 $letter->export_to($::form);
512 $::form->{id} = $letter->{id};
515 $::lxdebug->leave_sub;
519 $main::lxdebug->enter_sub();
521 my $locale = $main::locale;
524 if ($form->{letter_draft_action} eq $locale->text("Skip")) {
525 $form->{DONT_LOAD_DRAFT} = 1;
528 } elsif ($form->{letter_draft_action} eq $locale->text("Delete drafts")) {
529 delete_letter_drafts();
533 foreach my $action (qw(e_mail print save update save_letter_draft)) {
534 if ($::form->{"action_${action}"}) {
535 $::form->{dispatched_action} = $action;
541 $::form->error($::locale->text('No action defined.'));
542 $::lxdebug->leave_sub;
546 call_sub($form->{nextsub});
550 sub load_letter_draft {
551 $lxdebug->enter_sub();
553 $main::auth->assert('sales_letter_edit');
554 $main::lxdebug->leave_sub() and return 0 if ($form->{DONT_LOAD_DRAFT});
555 $form->{title} = $locale->text('Letter Draft');
556 $form->{script} = 'letter.pl';
558 my @letter_drafts = SL::Letter->find(draft => 1);
560 return unless @letter_drafts;
562 print $form->parse_html_template('letter/load_drafts', { LETTER_DRAFTS => \@letter_drafts });
565 $lxdebug->leave_sub();