1 package SL::ReportGenerator;
4 use List::Util qw(max);
10 # Cause locales.pl to parse these files:
11 # parse_html_template('report_generator/html_report')
18 $self->{myconfig} = shift;
19 $self->{form} = shift;
23 'std_column_visibility' => 0,
24 'output_format' => 'HTML',
25 'allow_pdf_export' => 1,
26 'allow_csv_export' => 1,
27 'html_template' => 'report_generator/html_report',
30 'orientation' => 'landscape',
31 'font_name' => 'Verdana',
35 'margin_bottom' => 1.5,
36 'margin_right' => 1.5,
46 'eol_style' => 'Unix',
52 'variable_list' => [],
55 $self->{data_present} = 0;
59 $self->set_options(@_) if (@_);
68 $self->{columns} = \%columns;
70 foreach my $column (values %{ $self->{columns} }) {
71 $column->{visible} = $self->{options}->{std_column_visibility} unless defined $column->{visible};
74 $self->set_column_order(sort keys %{ $self->{columns} });
77 sub set_column_order {
80 $self->{column_order} = [ grep { !$seen{$_}++ } @_, sort keys %{ $self->{columns} } ];
83 sub set_sort_indicator {
86 $self->{options}->{sort_indicator_column} = shift;
87 $self->{options}->{sort_indicator_direction} = shift;
95 while (my $arg = shift) {
98 if ('ARRAY' eq ref $arg) {
101 } elsif ('HASH' eq ref $arg) {
105 $self->{form}->error('Incorrect usage -- expecting hash or array ref');
108 my @columns_with_default_alignment = grep { defined $self->{columns}->{$_}->{align} } keys %{ $self->{columns} };
110 foreach my $row (@{ $row_set }) {
111 foreach my $column (@columns_with_default_alignment) {
112 $row->{$column} ||= { };
113 $row->{$column}->{align} = $self->{columns}->{$column}->{align} unless (defined $row->{$column}->{align});
116 foreach my $field (qw(data link)) {
117 map { $row->{$_}->{$field} = [ $row->{$_}->{$field} ] if (ref $row->{$_}->{$field} ne 'ARRAY') } keys %{ $row };
121 push @{ $self->{data} }, $row_set;
122 $last_row_set = $row_set;
124 $self->{data_present} = 1;
127 return $last_row_set;
133 push @{ $self->{data} }, { 'type' => 'separator' };
140 push @{ $self->{data} }, $data;
147 $self->{data_present} = 0;
154 while (my ($key, $value) = each %options) {
155 if ($key eq 'pdf_export') {
156 map { $self->{options}->{pdf_export}->{$_} = $value->{$_} } keys %{ $value };
158 $self->{options}->{$key} = $value;
163 sub set_options_from_form {
166 my $form = $self->{form};
167 my $myconfig = $self->{myconfig};
169 foreach my $key (qw(output_format)) {
170 my $full_key = "report_generator_${key}";
171 $self->{options}->{$key} = $form->{$full_key} if (defined $form->{$full_key});
174 foreach my $format (qw(pdf csv)) {
175 my $opts = $self->{options}->{"${format}_export"};
176 foreach my $key (keys %{ $opts }) {
177 my $full_key = "report_generator_${format}_options_${key}";
178 $opts->{$key} = $key =~ /^margin/ ? $form->parse_amount($myconfig, $form->{$full_key}) : $form->{$full_key};
183 sub set_export_options {
188 'variable_list' => [ @_ ],
192 sub set_custom_headers {
196 $self->{custom_headers} = [ @_ ];
198 delete $self->{custom_headers};
202 sub get_attachment_basename {
204 my $filename = $self->{options}->{attachment_basename} || 'report';
205 $filename =~ s|.*\\||;
206 $filename =~ s|.*/||;
211 sub generate_with_headers {
213 my $format = lc $self->{options}->{output_format};
214 my $form = $self->{form};
216 if (!$self->{columns}) {
217 $form->error('Incorrect usage -- no columns specified');
220 if ($format eq 'html') {
221 my $title = $form->{title};
222 $form->{title} = $self->{title} if ($self->{title});
224 $form->{title} = $title;
226 print $self->generate_html_content();
228 } elsif ($format eq 'csv') {
229 my $filename = $self->get_attachment_basename();
230 print qq|content-type: text/csv\n|;
231 print qq|content-disposition: attachment; filename=${filename}.csv\n\n|;
232 $self->generate_csv_content();
234 } elsif ($format eq 'pdf') {
235 $self->generate_pdf_content();
238 $form->error('Incorrect usage -- unknown format (supported are HTML, CSV, PDF)');
242 sub get_visible_columns {
246 return grep { my $c = $self->{columns}->{$_}; $c && $c->{visible} && (($c->{visible} == 1) || ($c->{visible} =~ /\Q${format}\E/i)) } @{ $self->{column_order} };
253 $value = $main::locale->quote_special_chars('HTML', $value);
255 $value =~ s/\n/<br>/g;
260 sub prepare_html_content {
263 my ($column, $name, @column_headers);
265 my $opts = $self->{options};
266 my @visible_columns = $self->get_visible_columns('HTML');
268 foreach $name (@visible_columns) {
269 $column = $self->{columns}->{$name};
273 'link' => $column->{link},
274 'text' => $column->{text},
275 'show_sort_indicator' => $name eq $opts->{sort_indicator_column},
276 'sort_indicator_direction' => $opts->{sort_indicator_direction},
279 push @column_headers, $header;
283 if ($self->{custom_headers}) {
284 $header_rows = $self->{custom_headers};
286 $header_rows = [ \@column_headers ];
289 my ($outer_idx, $inner_idx) = (0, 0);
293 foreach my $row_set (@{ $self->{data} }) {
294 if ('HASH' eq ref $row_set) {
295 if ($row_set->{type} eq 'separator') {
296 if (! scalar @rows) {
297 $next_border_top = 1;
299 $rows[-1]->{BORDER_BOTTOM} = 1;
307 'IS_COLSPAN_DATA' => $row_set->{type} eq 'colspan_data',
308 'NUM_COLUMNS' => scalar @visible_columns,
309 'BORDER_TOP' => $next_border_top,
310 'data' => $row_set->{data},
313 push @rows, $row_data;
315 $next_border_top = 0;
322 foreach my $row (@{ $row_set }) {
325 my $output_columns = [ ];
327 foreach my $col_name (@visible_columns) {
333 my $col = $row->{$col_name};
334 $col->{CELL_ROWS} = [ ];
335 foreach my $i (0 .. scalar(@{ $col->{data} }) - 1) {
336 push @{ $col->{CELL_ROWS} }, {
337 'data' => $self->html_format($col->{data}->[$i]),
338 'link' => $col->{link}->[$i],
342 # Force at least a to be displayed so that browsers
343 # will format the table cell (e.g. borders etc).
344 if (!scalar @{ $col->{CELL_ROWS} }) {
345 push @{ $col->{CELL_ROWS} }, { 'data' => ' ' };
346 } elsif ((1 == scalar @{ $col->{CELL_ROWS} }) && (!defined $col->{CELL_ROWS}->[0]->{data} || ($col->{CELL_ROWS}->[0]->{data} eq ''))) {
347 $col->{CELL_ROWS}->[0]->{data} = ' ';
350 push @{ $output_columns }, $col;
351 $skip_next = $col->{colspan} ? $col->{colspan} - 1 : 0;
355 'COLUMNS' => $output_columns,
356 'outer_idx' => $outer_idx,
357 'outer_idx_odd' => $outer_idx % 2,
358 'inner_idx' => $inner_idx,
359 'BORDER_TOP' => $next_border_top,
362 push @rows, $row_data;
364 $next_border_top = 0;
368 my @export_variables = $self->{form}->flatten_variables(@{ $self->{export}->{variable_list} });
370 my $allow_pdf_export = $opts->{allow_pdf_export};
372 eval { require PDF::API2; require PDF::Table; };
373 $allow_pdf_export |= 1 if (! $@);
376 'TITLE' => $opts->{title},
377 'TOP_INFO_TEXT' => $self->html_format($opts->{top_info_text}),
378 'RAW_TOP_INFO_TEXT' => $opts->{raw_top_info_text},
379 'BOTTOM_INFO_TEXT' => $self->html_format($opts->{bottom_info_text}),
380 'RAW_BOTTOM_INFO_TEXT' => $opts->{raw_bottom_info_text},
381 'ALLOW_PDF_EXPORT' => $allow_pdf_export,
382 'ALLOW_CSV_EXPORT' => $opts->{allow_csv_export},
383 'SHOW_EXPORT_BUTTONS' => ($allow_pdf_export || $opts->{allow_csv_export}) && $self->{data_present},
384 'HEADER_ROWS' => $header_rows,
385 'NUM_COLUMNS' => scalar @column_headers,
387 'EXPORT_VARIABLES' => \@export_variables,
388 'EXPORT_VARIABLE_LIST' => join(' ', @{ $self->{export}->{variable_list} }),
389 'EXPORT_NEXTSUB' => $self->{export}->{nextsub},
390 'DATA_PRESENT' => $self->{data_present},
396 sub generate_html_content {
398 my $variables = $self->prepare_html_content();
400 return $self->{form}->parse_html_template($self->{options}->{html_template}, $variables);
406 return $_[0] * 72 / 2.54;
409 sub generate_pdf_content {
416 my $variables = $self->prepare_html_content();
417 my $form = $self->{form};
418 my $myconfig = $self->{myconfig};
420 my $opts = $self->{options};
421 my $pdfopts = $opts->{pdf_export};
423 my (@data, @column_props, @cell_props);
425 my ($data_row, $cell_props_row);
426 my @visible_columns = $self->get_visible_columns('HTML');
427 my $num_columns = scalar @visible_columns;
428 my $num_header_rows = 1;
430 foreach $name (@visible_columns) {
431 push @column_props, { 'justify' => $self->{columns}->{$name}->{align} eq 'right' ? 'right' : 'left' };
434 if (!$self->{custom_headers}) {
436 $cell_props_row = [];
437 push @data, $data_row;
438 push @cell_props, $cell_props_row;
440 foreach $name (@visible_columns) {
441 $column = $self->{columns}->{$name};
443 push @{ $data_row }, $column->{text};
444 push @{ $cell_props_row }, {};
448 $num_header_rows = scalar @{ $self->{custom_headers} };
450 foreach my $custom_header_row (@{ $self->{custom_headers} }) {
452 $cell_props_row = [];
453 push @data, $data_row;
454 push @cell_props, $cell_props_row;
456 foreach my $custom_header_col (@{ $custom_header_row }) {
457 push @{ $data_row }, $custom_header_col->{text};
458 push @{ $cell_props_row }, {};
463 foreach my $row_set (@{ $self->{data} }) {
464 if ('HASH' eq ref $row_set) {
465 if ($row_set->{type} eq 'colspan_data') {
466 push @data, [ $row_set->{data} ];
468 $cell_props_row = [];
469 push @cell_props, $cell_props_row;
471 foreach (0 .. $num_columns - 1) {
472 push @{ $cell_props_row }, { 'background_color' => '#666666',
473 'font_color' => '#ffffff',
474 'colspan' => $_ == 0 ? -1 : undef, };
480 foreach my $row (@{ $row_set }) {
482 push @data, $data_row;
485 foreach my $col_name (@visible_columns) {
486 my $col = $row->{$col_name};
487 push @{ $data_row }, join("\n", @{ $col->{data} });
489 $column_props[$col_idx]->{justify} = 'right' if ($col->{align} eq 'right');
494 $cell_props_row = [];
495 push @cell_props, $cell_props_row;
497 foreach (0 .. $num_columns - 1) {
498 push @{ $cell_props_row }, { };
503 foreach my $i (0 .. scalar(@data) - 1) {
504 my $aref = $data[$i];
505 my $num_columns_here = scalar @{ $aref };
507 if ($num_columns_here < $num_columns) {
508 push @{ $aref }, ('') x ($num_columns - $num_columns_here);
509 } elsif ($num_columns_here > $num_columns) {
510 splice @{ $aref }, $num_columns;
515 'a3' => [ 842, 1190 ],
516 'a4' => [ 595, 842 ],
517 'a5' => [ 420, 595 ],
518 'letter' => [ 612, 792 ],
519 'legal' => [ 612, 1008 ],
522 my %supported_fonts = map { $_ => 1 } qw(courier georgia helvetica times verdana);
524 my $paper_size = defined $pdfopts->{paper_size} && defined $papersizes->{lc $pdfopts->{paper_size}} ? lc $pdfopts->{paper_size} : 'a4';
525 my ($paper_width, $paper_height);
527 if (lc $pdfopts->{orientation} eq 'landscape') {
528 ($paper_width, $paper_height) = @{$papersizes->{$paper_size}}[1, 0];
530 ($paper_width, $paper_height) = @{$papersizes->{$paper_size}}[0, 1];
533 my $margin_top = _cm2bp($pdfopts->{margin_top} || 1.5);
534 my $margin_bottom = _cm2bp($pdfopts->{margin_bottom} || 1.5);
535 my $margin_left = _cm2bp($pdfopts->{margin_left} || 1.5);
536 my $margin_right = _cm2bp($pdfopts->{margin_right} || 1.5);
538 my $table = PDF::Table->new();
539 my $pdf = PDF::API2->new();
540 my $page = $pdf->page();
542 $pdf->mediabox($paper_width, $paper_height);
544 my $font = $pdf->corefont(defined $pdfopts->{font_name} && $supported_fonts{lc $pdfopts->{font_name}} ? ucfirst $pdfopts->{font_name} : 'Verdana',
545 '-encoding' => $main::dbcharset || 'ISO-8859-15');
546 my $font_size = $pdfopts->{font_size} || 7;
547 my $title_font_size = $font_size + 1;
549 my $font_height = $font_size + 2 * $padding;
550 my $title_font_height = $font_size + 2 * $padding;
552 my $header_height = 2 * $title_font_height if ($opts->{title});
553 my $footer_height = 2 * $font_height if ($pdfopts->{number});
555 my $top_text_height = 0;
557 if ($self->{options}->{top_info_text}) {
558 my $top_text = $self->{options}->{top_info_text};
559 $top_text =~ s/\r//g;
560 $top_text =~ s/\n+$//;
562 my @lines = split m/\n/, $top_text;
563 $top_text_height = $font_height * scalar @lines;
565 foreach my $line_no (0 .. scalar(@lines) - 1) {
566 my $y_pos = $paper_height - $margin_top - $header_height - $line_no * $font_height;
567 my $text_obj = $page->text();
569 $text_obj->font($font, $font_size);
570 $text_obj->translate($margin_left, $y_pos);
571 $text_obj->text($lines[$line_no]);
579 'w' => $paper_width - $margin_left - $margin_right,
580 'start_y' => $paper_height - $margin_top - $header_height - $top_text_height,
581 'next_y' => $paper_height - $margin_top - $header_height,
582 'start_h' => $paper_height - $margin_top - $margin_bottom - $header_height - $footer_height - $top_text_height,
583 'next_h' => $paper_height - $margin_top - $margin_bottom - $header_height - $footer_height,
585 'background_color_odd' => '#ffffff',
586 'background_color_even' => '#eeeeee',
588 'font_size' => $font_size,
589 'font_color' => '#000000',
590 'num_header_rows' => $num_header_rows,
592 'bg_color' => '#ffffff',
594 'font_color' => '#000000',
596 'column_props' => \@column_props,
597 'cell_props' => \@cell_props,
600 foreach my $page_num (1..$pdf->pages()) {
601 my $curpage = $pdf->openpage($page_num);
603 if ($pdfopts->{number}) {
604 my $label = $main::locale->text("Page #1/#2", $page_num, $pdf->pages());
605 my $text_obj = $curpage->text();
607 $text_obj->font($font, $font_size);
608 $text_obj->translate(($paper_width - $margin_left - $margin_right) / 2 + $margin_left - $text_obj->advancewidth($label) / 2, $margin_bottom);
609 $text_obj->text($label);
612 if ($opts->{title}) {
613 my $text_obj = $curpage->text();
615 $text_obj->font($font, $title_font_size);
616 $text_obj->translate(($paper_width - $margin_left - $margin_right) / 2 + $margin_left - $text_obj->advancewidth($opts->{title}) / 2,
617 $paper_height - $margin_top);
618 $text_obj->text($opts->{title}, '-underline' => 1);
622 my $content = $pdf->stringify();
625 if ($pdfopts->{print} && $pdfopts->{printer_id}) {
626 $form->{printer_id} = $pdfopts->{printer_id};
627 $form->get_printer_code($myconfig);
628 $printer_command = $form->{printer_command};
631 if ($printer_command) {
632 $self->_print_content('printer_command' => $printer_command,
633 'content' => $content,
634 'copies' => $pdfopts->{copies});
635 $form->{report_generator_printed} = 1;
638 my $filename = $self->get_attachment_basename();
640 print qq|content-type: application/pdf\n|;
641 print qq|content-disposition: attachment; filename=${filename}.pdf\n\n|;
647 sub verify_paper_size {
649 my $requested_paper_size = lc shift;
650 my $default_paper_size = shift;
652 my %allowed_paper_sizes = map { $_ => 1 } qw(a3 a4 a5 letter legal);
654 return $allowed_paper_sizes{$requested_paper_size} ? $requested_paper_size : $default_paper_size;
661 foreach my $i (1 .. max $params{copies}, 1) {
662 my $printer = IO::File->new("| $params{printer_command}");
663 $main::form->error($main::locale->text('Could not spawn the printer command.')) if (!$printer);
664 $printer->print($params{content});
669 sub unescape_string {
672 my $iconv = $main::locale->{iconv};
674 $text = $main::locale->unquote_special_chars('HTML', $text);
675 $text = $main::locale->{iconv}->convert($text) if ($main::locale->{iconv});
680 sub generate_csv_content {
683 my %valid_sep_chars = (';' => ';', ',' => ',', ':' => ':', 'TAB' => "\t");
684 my %valid_escape_chars = ('"' => 1, "'" => 1);
685 my %valid_quote_chars = ('"' => 1, "'" => 1);
687 my $opts = $self->{options}->{csv_export};
688 my $eol = $opts->{eol_style} eq 'DOS' ? "\r\n" : "\n";
689 my $sep_char = $valid_sep_chars{$opts->{sep_char}} ? $valid_sep_chars{$opts->{sep_char}} : ';';
690 my $escape_char = $valid_escape_chars{$opts->{escape_char}} ? $opts->{escape_char} : '"';
691 my $quote_char = $valid_quote_chars{$opts->{quote_char}} ? $opts->{quote_char} : '"';
693 $escape_char = $quote_char if ($opts->{escape_char} eq 'QUOTE_CHAR');
695 my $csv = Text::CSV_XS->new({ 'binary' => 1,
696 'sep_char' => $sep_char,
697 'escape_char' => $escape_char,
698 'quote_char' => $quote_char,
701 my $stdout = wraphandle(\*STDOUT);
702 my @visible_columns = $self->get_visible_columns('CSV');
704 if ($opts->{headers}) {
705 if (!$self->{custom_headers}) {
706 $csv->print($stdout, [ map { $self->unescape_string($self->{columns}->{$_}->{text}) } @visible_columns ]);
709 foreach my $row (@{ $self->{custom_headers} }) {
713 foreach my $col (@{ $row }) {
714 my $num_output = ($col->{colspan} && ($col->{colspan} > 1)) ? $col->{colspan} : 1;
715 push @{ $fields }, ($self->unescape_string($col->{text})) x $num_output;
718 $csv->print($stdout, $fields);
723 foreach my $row_set (@{ $self->{data} }) {
724 next if ('ARRAY' ne ref $row_set);
725 foreach my $row (@{ $row_set }) {
728 foreach my $col (@visible_columns) {
734 my $num_output = ($col->{colspan} && ($col->{colspan} > 1)) ? $col->{colspan} : 1;
735 $skip_next = $num_output - 1;
737 push @data, join($eol, map { s/\r?\n/$eol/g; $_ } @{ $row->{$col}->{data} });
738 push @data, ('') x $skip_next if ($skip_next);
741 $csv->print($stdout, \@data);
752 SL::ReportGenerator.pm: the Lx-Office way of getting data in shape
756 my $report = SL::ReportGenerator->new(\%myconfig, $form);
757 $report->set_options(%options); # optional
758 $report->set_columns(%column_defs);
759 $report->set_sort_indicator($column, $direction); # optional
760 $report->add_data($row1, $row2, @more_rows);
761 $report->generate_with_headers();
763 This creates a report object, sets a few columns, adds some data and generates a standard report.
764 Sorting of columns will be alphabetic, and options will be set to their defaults.
765 The report will be printed including table headers, html headers and http headers.
769 Imagine the following scenario:
770 There's a simple form, which loads some data from the database, and needs to print it out. You write a template for it.
771 Then there may be more than one line. You add a loop in the template.
772 Then there are some options made by the user, such as hidden columns. You add more to the template.
773 Then it lacks usability. You want it to be able to sort the data. You add code for that.
774 Then there are too many results, you need pagination, you want to print or export that data..... and so on.
776 The ReportGenerator class was designed because this exact scenario happened about half a dozen times in Lx-Office.
777 It's purpose is to manage all those formating, culling, sorting, and templating.
778 Which makes it almost as complicated to use as doing the work for yourself.
784 =item new \%myconfig,$form,%options
786 Creates a new ReportGenerator object, sets all given options, and returns it.
788 =item set_columns %columns
790 Sets the columns available to this report.
792 =item set_column_order @columns
794 Sets the order of columns. Any columns not present here are appended in alphabetic order.
796 =item set_sort_indicator $column,$direction
798 Sets sorting ot the table by specifying a column and a direction, where the direction will be evaluated to ascending if true.
799 Note that this is only for displaying. The data has to be presented already sorted.
801 =item add_data \@data
803 =item add_data \%data
805 Adds data to the report. A given hash_ref is interpreted as a single line of data, every array_ref as a collection of lines.
806 Every line will be expected to be in a kay => value format. Note that the rows have to be already sorted.
807 ReportGenerator does only colum sorting on its own, and provides links to sorting and visual cue as to which column was sorted by.
811 Adds a separator line to the report.
813 =item add_control \%data
815 Adds a control element to the data. Control elements are an experimental feature to add functionality to a report the regular data cannot.
816 Every control element needs to set IS_CONTROL_DATA, in order to be recongnized by the template.
817 Currently the only control element is a colspan element, which can be used as a mini header further down the report.
821 Deletes all data filled into the report, but keeps options set.
823 =item set_options %options
825 Sets options. For an incomplete list of options, see section configuration.
827 =item set_options_from_form
829 Tries to import options from the $form object given at creation
831 =item set_export_options $next_sub,@variable_list
833 Sets next_sub and additional variables needed for export.
835 =item get_attachment_basename
837 Returns the set attachment_basename option, or 'report' if nothing was set. See configuration for the option.
839 =item generate_with_headers
841 Parses the report, adds headers and prints it out. Headers depend on the option 'output_format',
842 for example 'HTML' will add proper table headers, html headers and http headers. See configuration for this option.
844 =item get_visible_columns $format
846 Returns a list of columns that will be visible in the report after considering all options or match the given format.
848 =item html_format $value
850 Escapes HTML characters in $value and substitutes newlines with '<br>'. Returns the escaped $value.
852 =item prepare_html_content $column,$name,@column_headers
854 Parses the data, and sets internal data needed for certain output format. Must be called once before the template is invoked.
855 Should not be called extrenally, since all render and generate functions invoke it anyway.
857 =item generate_html_content
859 The html generation function. Is invoked by generate_with_headers.
861 =item generate_pdf_content
863 The PDF generation function. It is invoked by generate_with_headers, tests whether or not the Perl module PDF::API2 is installed and calls render_pdf_with_pdf_api2 if it is and render_pdf_with_html2ps otherwise.
865 =item generate_csv_content
867 The CSV generation function. Uses XS_CSV to parse the information into csv.
869 =item render_pdf_with_pdf_api2
871 PDF render function using the Perl module PDF::API2.
873 =item render_pdf_with_html2ps
875 PDF render function using the external application html2ps.
881 These are known options and their defaults. Options for pdf export and csv export need to be set as a hashref inside the export option.
883 =head2 General Options
887 =item std_column_visibility
889 Standard column visibility. Used if no visibility is set. Use this to save the trouble of enabling every column. Default is no.
893 Output format. Used by generate_with_headers to determine the format. Supported options are HTML, CSV, and PDF. Default is HTML.
895 =item allow_pdf_export
897 Used to determine if a button for PDF export should be displayed. Default is yes. The PDF button is hidden if neither the Perl module PDF::API2 nor the external applications html2ps and Ghostscript are available regardless of this parameter's value.
899 =item allow_csv_export
901 Used to determine if a button for CSV export should be displayed. Default is yes.
905 The template to be used for HTML reports. Default is 'report_generator/html_report'.
915 Paper size. Default is a4. Supported paper sizes are a3, a4, a5, letter and legal.
917 =item orientation (landscape)
919 Landscape or portrait. Default is landscape.
923 Default is Verdana. Supported font names are Courier, Georgia, Helvetica, Times and Verdana. This option only affects the rendering with PDF::API2.
927 Default is 7. This option only affects the rendering with PDF::API2.
937 The paper margins in cm. They all default to 1.5.
941 Set to a true value if the pages should be numbered. Default is 1.
945 If set then the resulting PDF will be output to a printer. If not it will be downloaded by the user. Default is no.
963 Character to enclose entries. Default is double quote (").
967 Character to separate entries. Default is semicolon (;).
971 Character to escape the quote_char. Default is double quote (").
975 End of line style. Default is Unix.
979 Include headers? Default is yes.
987 =head1 MODULE AUTHORS
989 Moritz Bunkus E<lt>mbunkus@linet-services.deE<gt>
991 L<http://linet-services.de>