X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FReportGenerator.pm;h=cdcf18fabf782b1ed376790e7db7b2b4653acf1c;hb=a59350b1434707a1fe65058938ef3f20ee2dca99;hp=37e6bede01b0d60dfa6a728a747cb0ca34345679;hpb=15b4d5a3fdf1a6aafbd696f107a6dd7995edbc8c;p=kivitendo-erp.git diff --git a/SL/ReportGenerator.pm b/SL/ReportGenerator.pm index 37e6bede0..cdcf18fab 100644 --- a/SL/ReportGenerator.pm +++ b/SL/ReportGenerator.pm @@ -1,6 +1,7 @@ package SL::ReportGenerator; use IO::Wrap; +use List::Util qw(max); use Text::CSV_XS; use SL::Form; @@ -28,12 +29,15 @@ sub new { 'margin_bottom' => 1.5, 'margin_right' => 1.5, 'number' => 1, + 'print' => 0, + 'printer_id' => 0, + 'copies' => 1, }, 'csv_export' => { 'quote_char' => '"', 'sep_char' => ';', 'escape_char' => '"', - 'eol_style' => 'DOS', + 'eol_style' => 'Unix', 'headers' => 1, }, }; @@ -42,6 +46,8 @@ sub new { 'variable_list' => '', }; + $self->{data_present} = 0; + $self->set_options(@_) if (@_); return bless $self, $type; @@ -86,23 +92,61 @@ sub set_sort_indicator { sub add_data { my $self = shift; + my $last_row_set; + while (my $arg = shift) { + my $row_set; + if ('ARRAY' eq ref $arg) { - push @{ $self->{data} }, $arg; + $row_set = $arg; } elsif ('HASH' eq ref $arg) { - push @{ $self->{data} }, [ $arg ]; + $row_set = [ $arg ]; } else { $self->{form}->error('Incorrect usage -- expecting hash or array ref'); } + + my @columns_with_default_alignment = grep { defined $self->{columns}->{$_}->{align} } keys %{ $self->{columns} }; + + foreach my $row (@{ $row_set }) { + foreach my $column (@columns_with_default_alignment) { + $row->{$column} ||= { }; + $row->{$column}->{align} = $self->{columns}->{$column}->{align} unless (defined $row->{$column}->{align}); + } + + foreach my $field (qw(data link)) { + map { $row->{$_}->{$field} = [ $row->{$_}->{$field} ] if (ref $row->{$_}->{$field} ne 'ARRAY') } keys %{ $row }; + } + } + + push @{ $self->{data} }, $row_set; + $last_row_set = $row_set; + + $self->{data_present} = 1; } + + return $last_row_set; +} + +sub add_separator { + my $self = shift; + + push @{ $self->{data} }, { 'type' => 'separator' }; +} + +sub add_control { + my $self = shift; + my $data = shift; + + push @{ $self->{data} }, $data; } sub clear_data { my $self = shift; - $self->{data} = []; + $self->{data} = []; + $self->{data_present} = 0; } sub set_options { @@ -141,57 +185,43 @@ sub set_export_options { }; } -sub generate_content { - my $self = shift; - my $format = lc $self->{options}->{output_format}; - - if (!$self->{columns}) { - $self->{form}->error('Incorrect usage -- no columns specified'); - } - - if ($format eq 'html') { - return $self->generate_html_content(); - - } elsif ($format eq 'csv') { - return $self->generate_csv_content(); - - } elsif ($format eq 'pdf') { - return $self->generate_pdf_content(); +sub get_attachment_basename { + my $self = shift; + my $filename = $self->{options}->{attachment_basename} || 'report'; + $filename =~ s|.*\\||; + $filename =~ s|.*/||; - } else { - $self->{form}->error('Incorrect usage -- unknown format (supported are HTML, CSV, PDF)'); - } + return $filename; } sub generate_with_headers { my $self = shift; my $format = lc $self->{options}->{output_format}; + my $form = $self->{form}; if (!$self->{columns}) { - $self->{form}->error('Incorrect usage -- no columns specified'); + $form->error('Incorrect usage -- no columns specified'); } - my $filename = $self->{options}->{attachment_basename} || 'report'; - $filename =~ s|.*\\||; - $filename =~ s|.*/||; - if ($format eq 'html') { - $self->{form}->{title} = $self->{title}; - $self->{form}->header(); + my $title = $form->{title}; + $form->{title} = $self->{title} if ($self->{title}); + $form->header(); + $form->{title} = $title; + print $self->generate_html_content(); } elsif ($format eq 'csv') { + my $filename = $self->get_attachment_basename(); print qq|content-type: text/csv\n|; print qq|content-disposition: attachment; filename=${filename}.csv\n\n|; $self->generate_csv_content(); } elsif ($format eq 'pdf') { - print qq|content-type: application/pdf\n|; - print qq|content-disposition: attachment; filename=${filename}.pdf\n\n|; $self->generate_pdf_content(); } else { - $self->{form}->error('Incorrect usage -- unknown format (supported are HTML, CSV, PDF)'); + $form->error('Incorrect usage -- unknown format (supported are HTML, CSV, PDF)'); } } @@ -239,12 +269,35 @@ sub prepare_html_content { my @rows; foreach my $row_set (@{ $self->{data} }) { + if ('HASH' eq ref $row_set) { + my $row_data = { + 'IS_CONTROL' => 1, + 'IS_SEPARATOR' => $row_set->{type} eq 'separator', + 'IS_COLSPAN_DATA' => $row_set->{type} eq 'colspan_data', + 'NUM_COLUMNS' => scalar @visible_columns, + 'data' => $row_set->{data}, + }; + + push @rows, $row_data; + + next; + } + $outer_idx++; foreach my $row (@{ $row_set }) { $inner_idx++; - map { $row->{$_}->{data} = $self->html_format($row->{$_}->{data}) } @visible_columns; + foreach my $col_name (@visible_columns) { + my $col = $row->{$col_name}; + $col->{CELL_ROWS} = [ ]; + foreach my $i (0 .. scalar(@{ $col->{data} }) - 1) { + push @{ $col->{CELL_ROWS} }, { + 'data' => $self->html_format($col->{data}->[$i]), + 'link' => $col->{link}->[$i], + }; + }; + } my $row_data = { 'COLUMNS' => [ map { $row->{$_} } @visible_columns ], @@ -272,13 +325,14 @@ sub prepare_html_content { 'RAW_BOTTOM_INFO_TEXT' => $opts->{raw_bottom_info_text}, 'ALLOW_PDF_EXPORT' => $allow_pdf_export, 'ALLOW_CSV_EXPORT' => $opts->{allow_csv_export}, - 'SHOW_EXPORT_BUTTONS' => $allow_pdf_export || $opts->{allow_csv_export}, + 'SHOW_EXPORT_BUTTONS' => ($allow_pdf_export || $opts->{allow_csv_export}) && $self->{data_present}, 'COLUMN_HEADERS' => \@column_headers, 'NUM_COLUMNS' => scalar @column_headers, 'ROWS' => \@rows, 'EXPORT_VARIABLES' => \@export_variables, 'EXPORT_VARIABLE_LIST' => $self->{export}->{variable_list}, 'EXPORT_NEXTSUB' => $self->{export}->{nextsub}, + 'DATA_PRESENT' => $self->{data_present}, }; return $variables; @@ -288,7 +342,7 @@ sub generate_html_content { my $self = shift; my $variables = $self->prepare_html_content(); - return $self->{form}->parse_html_template('report_generator/html_report', $variables); + return $self->{form}->parse_html_template2('report_generator/html_report', $variables); } sub verify_paper_size { @@ -343,6 +397,13 @@ BODY { END ; + my $printer_command; + if ($opt->{print} && $opt->{printer_id}) { + $form->{printer_id} = $opt->{printer_id}; + $form->get_printer_code($myconfig); + $printer_command = $form->{printer_command}; + } + my $cfg_file_name = Common::tmpname() . '-html2ps-config'; my $cfg_file = IO::File->new($cfg_file_name, 'w') || $form->error($locale->text('Could not write the html2ps config file.')); @@ -360,15 +421,45 @@ END $html_file->print($form->parse_html_template('report_generator/pdf_report', $variables)); $html_file->close(); - my $gs = IO::File->new("\"${main::html2ps_bin}\" -f \"${cfg_file_name}\" \"${html_file_name}\" | " . - "\"${main::ghostscript_bin}\" -q -dSAFER -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sPAPERSIZE=${opt_paper_size} -sOutputFile=- -c .setpdfwrite - |"); + my $cmdline = + "\"${main::html2ps_bin}\" -f \"${cfg_file_name}\" \"${html_file_name}\" | " . + "\"${main::ghostscript_bin}\" -q -dSAFER -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sPAPERSIZE=${opt_paper_size} -sOutputFile=- -c .setpdfwrite -"; + + my $gs = IO::File->new("${cmdline} |"); if ($gs) { - while (my $line = <$gs>) { - print $line; + my $content; + + if (!$printer_command) { + my $filename = $self->get_attachment_basename(); + print qq|content-type: application/pdf\n|; + print qq|content-disposition: attachment; filename=${filename}.pdf\n\n|; + + while (my $line = <$gs>) { + print $line; + } + + } else { + while (my $line = <$gs>) { + $content .= $line; + } } + $gs->close(); unlink $cfg_file_name, $html_file_name; + if ($printer_command && $content) { + foreach my $i (1 .. max $opt->{copies}, 1) { + my $printer = IO::File->new("| ${printer_command}"); + if (!$printer) { + $form->error($locale->text('Could not spawn the printer command.')); + } + $printer->print($content); + $printer->close(); + } + + $form->{report_generator_printed} = 1; + } + } else { unlink $cfg_file_name, $html_file_name; $form->error($locale->text('Could not spawn html2ps or GhostScript.')); @@ -404,8 +495,13 @@ sub generate_csv_content { } foreach my $row_set (@{ $self->{data} }) { + next if ('ARRAY' ne ref $row_set); foreach my $row (@{ $row_set }) { - $csv->print($stdout, [ map { $row->{$_}->{data} } @visible_columns ]); + my @data; + foreach my $col (@visible_columns) { + push @data, join($eol, map { s/\r?\n/$eol/g; $_ } @{ $row->{$col}->{data} }); + } + $csv->print($stdout, \@data); } } }