2 # vim: softtabstop=4 tabstop=4 shiftwidth=4 ft=perl expandtab smarttab
11 our $VERSION = '0.10.1';
13 print __PACKAGE__.' is version: '.$VERSION.$/ if($ENV{'PDF_TABLE_DEBUG'});
15 ############################################################
19 # Parameters are meta information about the PDF
21 # $pdf = PDF::Table->new();
23 ############################################################
28 my $class = ref($type) || $type;
30 bless ($self, $class);
32 # Pass all the rest to init for validation and initialisation
40 my ($self, $pdf, $page, $data, %options ) = @_;
42 # Check and set default values
43 $self->set_defaults();
45 # Check and set mandatory params
47 $self->set_page($page);
48 $self->set_data($data);
49 $self->set_options(\%options);
57 $self->{'font_size'} = 12;
61 my ($self, $pdf) = @_;
62 $self->{'pdf'} = $pdf;
66 my ($self, $page) = @_;
67 if ( defined($page) && ref($page) ne 'PDF::API2::Page' ){
69 if( ref($self->{'pdf'}) eq 'PDF::API2' ){
70 $self->{'page'} = $self->{'pdf'}->page();
72 carp 'Warning: Page must be a PDF::API2::Page object but it seems to be: '.ref($page).$/;
73 carp 'Error: Cannot set page from passed PDF object either as it is invalid!'.$/;
77 $self->{'page'} = $page;
82 my ($self, $data) = @_;
87 my ($self, $options) = @_;
91 ############################################################
93 # text_block - utility method to build multi-paragraph blocks of text
95 ############################################################
100 my $text_object = shift;
101 my $text = shift; # The text to be displayed
102 my %arg = @_; # Additional Arguments
104 my ( $align, $xpos, $ypos, $xbase, $ybase, $line_width, $wordspace, $endw , $width, $height) =
105 ( undef , undef, undef, undef , undef , undef , undef , undef , undef , undef );
106 my @line = (); # Temp data array with words on one line
107 my %width = (); # The width of every unique word in the givven text
109 # Try to provide backward compatibility
110 foreach my $key (keys %arg)
113 if($newkey =~ s#^-##)
115 $arg{$newkey} = $arg{$key};
122 # Lets check mandatory parameters with no default values
124 $xbase = $arg{'x'} || -1;
125 $ybase = $arg{'y'} || -1;
126 $width = $arg{'w'} || -1;
127 $height = $arg{'h'} || -1;
128 unless( $xbase > 0 ){ carp "Error: Left Edge of Block is NOT defined!\n"; return; }
129 unless( $ybase > 0 ){ carp "Error: Base Line of Block is NOT defined!\n"; return; }
130 unless( $width > 0 ){ carp "Error: Width of Block is NOT defined!\n"; return; }
131 unless( $height > 0 ){ carp "Error: Height of Block is NOT defined!\n"; return; }
132 # Check if any text to display
133 unless( defined( $text) and length($text) > 0 )
135 carp "Warning: No input text found. Trying to add dummy '-' and not to break everything.\n";
139 # Strip any <CR> and Split the text into paragraphs
141 my @paragraphs = split(/\n/, $text);
143 # Width between lines in pixels
144 my $line_space = defined $arg{'lead'} && $arg{'lead'} > 0 ? $arg{'lead'} : 12;
146 # Calculate width of all words
147 my $space_width = $text_object->advancewidth("\x20");
148 my @words = split(/\s+/, $text);
151 next if exists $width{$_};
152 $width{$_} = $text_object->advancewidth($_);
155 my @paragraph = split(' ', shift(@paragraphs));
157 my $first_paragraph = 1;
162 $ypos = $ybase + $line_space;
163 my $bottom_border = $ypos - $height;
164 # While we can add another line
165 while ( $ypos >= $bottom_border + $line_space )
167 # Is there any text to render ?
170 # Finish if nothing left
171 last unless scalar @paragraphs;
172 # Else take one line from the text
173 @paragraph = split(' ', shift( @paragraphs ) );
175 $ypos -= $arg{'parspace'} if $arg{'parspace'};
176 last unless $ypos >= $bottom_border;
178 $ypos -= $line_space;
181 # While there's room on the line, add another word
184 if( $first_line && exists $arg{'hang'} )
186 my $hang_width = $text_object->advancewidth($arg{'hang'});
188 $text_object->translate( $xpos, $ypos );
189 $text_object->text( $arg{'hang'} );
191 $xpos += $hang_width;
192 $line_width += $hang_width;
193 $arg{'indent'} += $hang_width if $first_paragraph;
195 elsif( $first_line && exists $arg{'flindent'} && $arg{'flindent'} > 0 )
197 $xpos += $arg{'flindent'};
198 $line_width += $arg{'flindent'};
200 elsif( $first_paragraph && exists $arg{'fpindent'} && $arg{'fpindent'} > 0 )
202 $xpos += $arg{'fpindent'};
203 $line_width += $arg{'fpindent'};
205 elsif (exists $arg{'indent'} && $arg{'indent'} > 0 )
207 $xpos += $arg{'indent'};
208 $line_width += $arg{'indent'};
211 # Lets take from paragraph as many words as we can put into $width - $indent;
212 while ( @paragraph and $text_object->advancewidth( join("\x20", @line)."\x20" . $paragraph[0]) +
213 $line_width < $width )
215 push(@line, shift(@paragraph));
217 $line_width += $text_object->advancewidth(join('', @line));
219 # calculate the space width
220 if( $arg{'align'} eq 'fulljustify' or ($arg{'align'} eq 'justify' and @paragraph))
222 @line = split(//,$line[0]) if (scalar(@line) == 1) ;
223 $wordspace = ($width - $line_width) / (scalar(@line) - 1);
228 $align=($arg{'align'} eq 'justify') ? 'left' : $arg{'align'};
229 $wordspace = $space_width;
231 $line_width += $wordspace * (scalar(@line) - 1);
233 if( $align eq 'justify')
235 foreach my $word (@line)
237 $text_object->translate( $xpos, $ypos );
238 $text_object->text( $word );
239 $xpos += ($width{$word} + $wordspace) if (@line);
245 # calculate the left hand position of the line
246 if( $align eq 'right' )
248 $xpos += $width - $line_width;
250 elsif( $align eq 'center' )
252 $xpos += ( $width / 2 ) - ( $line_width / 2 );
256 $text_object->translate( $xpos, $ypos );
257 $endw = $text_object->text( join("\x20", @line));
261 unshift(@paragraphs, join(' ',@paragraph)) if scalar(@paragraph);
262 return ($endw, $ypos, join("\n", @paragraphs))
266 ################################################################
267 # table - utility method to build multi-row, multicolumn tables
268 ################################################################
277 #=====================================
278 # Mandatory Arguments Section
279 #=====================================
280 unless($pdf and $page and $data)
282 carp "Error: Mandatory parameter is missing pdf/page/data object!\n";
286 # Validate mandatory argument data type
287 croak "Error: Invalid pdf object received." unless (ref($pdf) eq 'PDF::API2');
288 croak "Error: Invalid page object received." unless (ref($page) eq 'PDF::API2::Page');
289 croak "Error: Invalid data received." unless ((ref($data) eq 'ARRAY') && scalar(@$data));
290 croak "Error: Missing required settings." unless (scalar(keys %arg));
292 # Validate settings key
293 my %valid_settings_key = (
306 background_color => 1,
307 background_color_odd => 1,
308 background_color_even => 1,
311 horizontal_borders => 1,
312 vertical_borders => 1,
317 font_color_even => 1,
319 background_color_odd => 1,
320 background_color_even => 1,
326 max_word_length => 1,
327 cell_render_hook => 1,
330 foreach my $key (keys %arg)
332 # Provide backward compatibility
333 $arg{$key} = delete $arg{"-$key"} if $key =~ s/^-//;
335 croak "Error: Invalid setting key '$key' received."
336 unless exists $valid_settings_key{$key};
341 #TODO: Add code for header props compatibility and col_props comp....
343 my ( $xbase, $ybase, $width, $height ) = ( undef, undef, undef, undef );
344 # Could be 'int' or 'real' values
345 $xbase = $arg{'x' } || -1;
346 $ybase = $arg{'start_y'} || -1;
347 $width = $arg{'w' } || -1;
348 $height = $arg{'start_h'} || -1;
350 # Global geometry parameters are also mandatory.
351 unless( $xbase > 0 ){ carp "Error: Left Edge of Table is NOT defined!\n"; return; }
352 unless( $ybase > 0 ){ carp "Error: Base Line of Table is NOT defined!\n"; return; }
353 unless( $width > 0 ){ carp "Error: Width of Table is NOT defined!\n"; return; }
354 unless( $height > 0 ){ carp "Error: Height of Table is NOT defined!\n"; return; }
356 # Ensure default values for -next_y and -next_h
357 my $next_y = $arg{'next_y'} || $arg{'start_y'} || 0;
358 my $next_h = $arg{'next_h'} || $arg{'start_h'} || 0;
361 my $txt = $page->text;
363 # Set Default Properties
364 my $fnt_name = $arg{'font' } || $pdf->corefont('Times',-encode => 'utf8');
365 my $fnt_size = $arg{'font_size' } || 12;
366 my $fnt_underline = $arg{'font_underline' } || undef; # merely stating undef is the intended default
367 my $max_word_len = $arg{'max_word_length' } || 20;
369 #=====================================
370 # Table Header Section
371 #=====================================
372 # Disable header row into the table
373 my $header_props = undef;
375 # Check if the user enabled it ?
376 if(defined $arg{'header_props'} and ref( $arg{'header_props'}) eq 'HASH')
378 # Transfer the reference to local variable
379 $header_props = $arg{'header_props'};
381 # Check other params and put defaults if needed
382 $header_props->{'repeat' } = $header_props->{'repeat' } || 0;
383 $header_props->{'font' } = $header_props->{'font' } || $fnt_name;
384 $header_props->{'font_color' } = $header_props->{'font_color' } || '#000066';
385 $header_props->{'font_size' } = $header_props->{'font_size' } || $fnt_size + 2;
386 $header_props->{'font_underline'} = $header_props->{'font_underline'} || $fnt_underline;
387 $header_props->{'bg_color' } = $header_props->{'bg_color' } || '#FFFFAA';
388 $header_props->{'justify' } = $header_props->{'justify' };
391 my $header_row = undef;
392 #=====================================
393 # Other Parameters check
394 #=====================================
395 my $lead = $arg{'lead' } || $fnt_size;
396 my $pad_left = $arg{'padding_left' } || $arg{'padding'} || 0;
397 my $pad_right = $arg{'padding_right' } || $arg{'padding'} || 0;
398 my $pad_top = $arg{'padding_top' } || $arg{'padding'} || 0;
399 my $pad_bot = $arg{'padding_bottom'} || $arg{'padding'} || 0;
400 my $default_text = $arg{'default_text' } // '-';
401 my $line_w = defined $arg{'border'} ? $arg{'border'} : 1 ;
402 my $horiz_borders = defined $arg{'horizontal_borders'}
403 ? $arg{'horizontal_borders'}
405 my $vert_borders = defined $arg{'vertical_borders'}
406 ? $arg{'vertical_borders'}
409 my $background_color_even = $arg{'background_color_even' } || $arg{'background_color'} || undef;
410 my $background_color_odd = $arg{'background_color_odd' } || $arg{'background_color'} || undef;
411 my $font_color_even = $arg{'font_color_even' } || $arg{'font_color' } || 'black';
412 my $font_color_odd = $arg{'font_color_odd' } || $arg{'font_color' } || 'black';
413 my $border_color = $arg{'border_color' } || 'black';
415 my $min_row_h = $fnt_size + $pad_top + $pad_bot;
416 my $row_h = defined ($arg{'row_height'})
418 ($arg{'row_height'} > $min_row_h)
420 $arg{'row_height'} : $min_row_h;
424 my $cell_props = $arg{cell_props} || []; # per cell properties
426 #If there is no valid data array reference warn and return!
427 if(ref $data ne 'ARRAY')
429 carp "Passed table data is not an ARRAY reference. It's actually a ref to ".ref($data);
430 return ($page,0,$cur_y);
433 # Copy the header row if header is enabled
434 @$header_row = $$data[0] if defined $header_props;
435 # Determine column widths based on content
437 # an arrayref whose values are a hashref holding
438 # the minimum and maximum width of that column
439 my $col_props = $arg{'column_props'} || [];
441 # An array ref of arrayrefs whose values are
442 # the actual widths of the column/row intersection
443 my $row_col_widths = [];
444 # An array ref with the widths of the header row
445 my $header_row_props = [];
447 # Scalars that hold sum of the maximum and minimum widths of all columns
448 my ( $max_col_w , $min_col_w ) = ( 0,0 );
449 my ( $row, $col_name, $col_fnt_size, $col_fnt_underline, $space_w );
451 my $word_widths = {};
452 my $rows_height = [];
455 for( my $row_idx = 0; $row_idx < scalar(@$data) ; $row_idx++ )
457 my $column_widths = []; #holds the width of each column
458 # Init the height for this row
459 $rows_height->[$row_idx] = 0;
461 for( my $column_idx = 0; $column_idx < scalar(@{$data->[$row_idx]}) ; $column_idx++ )
463 # look for font information for this column
464 my ($cell_font, $cell_font_size, $cell_font_underline);
466 if( !$row_idx and ref $header_props )
468 $cell_font = $header_props->{'font'};
469 $cell_font_size = $header_props->{'font_size'};
470 $cell_font_underline = $header_props->{'font_underline'};
473 # Get the most specific value if none was already set from header_props
474 $cell_font ||= $cell_props->[$row_idx][$column_idx]->{'font'}
475 || $col_props->[$column_idx]->{'font'}
478 $cell_font_size ||= $cell_props->[$row_idx][$column_idx]->{'font_size'}
479 || $col_props->[$column_idx]->{'font_size'}
482 $cell_font_underline ||= $cell_props->[$row_idx][$column_idx]->{'font_underline'}
483 || $col_props->[$column_idx]->{'font_underline'}
489 $txt->font( $cell_font, $cell_font_size );
491 # Set row height to biggest font size from row's cells
492 if( $cell_font_size > $rows_height->[$row_idx] )
494 $rows_height->[$row_idx] = $cell_font_size;
497 # This should fix a bug with very long words like serial numbers etc.
498 if( $max_word_len > 0 )
500 $data->[$row_idx][$column_idx] =~ s#(\S{$max_word_len})(?=\S)#$1 #g;
503 # Init cell size limits
504 $space_w = $txt->advancewidth( "\x20" );
505 $column_widths->[$column_idx] = 0;
509 my @words = split( /\s+/, $data->[$row_idx][$column_idx] );
513 unless( exists $word_widths->{$_} )
514 { # Calculate the width of every word and add the space width to it
515 $word_widths->{$_} = $txt->advancewidth( $_ ) + $space_w;
518 $column_widths->[$column_idx] += $word_widths->{$_};
519 $min_col_w = $word_widths->{$_} if( $word_widths->{$_} > $min_col_w );
520 $max_col_w += $word_widths->{$_};
523 $min_col_w += $pad_left + $pad_right;
524 $max_col_w += $pad_left + $pad_right;
525 $column_widths->[$column_idx] += $pad_left + $pad_right;
527 # Keep a running total of the overall min and max widths
528 $col_props->[$column_idx]->{'min_w'} ||= 0;
529 $col_props->[$column_idx]->{'max_w'} ||= 0;
531 if( $min_col_w > $col_props->[$column_idx]->{'min_w'} )
532 { # Calculated Minimum Column Width is more than user-defined
533 $col_props->[$column_idx]->{'min_w'} = $min_col_w ;
536 if( $max_col_w > $col_props->[$column_idx]->{'max_w'} )
537 { # Calculated Maximum Column Width is more than user-defined
538 $col_props->[$column_idx]->{'max_w'} = $max_col_w ;
540 }#End of for(my $column_idx....
542 $row_col_widths->[$row_idx] = $column_widths;
544 # Copy the calculated row properties of header row.
545 @$header_row_props = @$column_widths if(!$row_idx and ref $header_props);
548 # Calc real column widths and expand table width if needed.
549 my $calc_column_widths;
550 ($calc_column_widths, $width) = CalcColumnWidths( $col_props, $width );
552 # Lets draw what we have!
554 # Store header row height for later use if headers have to be repeated
555 my $header_row_height = $rows_height->[0];
557 my ( $gfx, $gfx_bg, $background_color, $font_color, $bot_marg, $table_top_y, $text_start);
559 # Each iteration adds a new page as neccessary
560 while(scalar(@{$data}))
563 my $columns_number = 0;
567 $table_top_y = $ybase;
568 $bot_marg = $table_top_y - $height;
570 # Check for safety reasons
572 { # This warning should remain i think
573 carp "!!! Warning: !!! Incorrect Table Geometry! start_h (${height}) is above start_y (${table_top_y}). Setting bottom margin to end of sheet!\n";
580 if(ref $arg{'new_page_func'})
582 $page = &{$arg{'new_page_func'}};
589 $table_top_y = $next_y;
590 $bot_marg = $table_top_y - $next_h;
592 # Check for safety reasons
594 { # This warning should remain i think
595 carp "!!! Warning: !!! Incorrect Table Geometry! next_y or start_y (${next_y}) is above next_h or start_h (${next_h}). Setting bottom margin to end of sheet!\n";
599 if( ref $header_props and $header_props->{'repeat'})
602 @$page_header = @$header_row;
604 @$hrp = @$header_row_props ;
605 # Then prepend it to master data array
606 unshift @$data, @$page_header;
607 unshift @$row_col_widths, $hrp;
608 unshift @$rows_height, $header_row_height;
610 $first_row = 1; # Means YES
611 $row_index--; # Rollback the row_index because a new header row has been added
615 $gfx_bg = $page->gfx;
617 $txt->font($fnt_name, $fnt_size);
619 $cur_y = $table_top_y;
624 $gfx->strokecolor($border_color);
625 $gfx->linewidth($line_w);
630 $gfx->move( $xbase , $cur_y );
631 $gfx->hline($xbase + $width );
639 # Each iteration adds a row to the current page until the page is full
640 # or there are no more rows to add
642 while(scalar(@{$data}) and $cur_y-$row_h > $bot_marg)
644 # Remove the next item from $data
645 my $record = shift @{$data};
647 # Get max columns number to know later how many vertical lines to draw
648 $columns_number = scalar(@$record)
649 if scalar(@$record) > $columns_number;
651 # Get the next set of row related settings
653 my $pre_calculated_row_height = shift @$rows_height;
656 my $record_widths = shift @$row_col_widths;
658 # Row coloumn props - TODO in another commit
660 # Row cell props - TODO in another commit
663 # Choose colors for this row
664 $background_color = $row_index % 2 ? $background_color_even : $background_color_odd;
665 $font_color = $row_index % 2 ? $font_color_even : $font_color_odd;
667 #Determine current row height
668 my $current_row_height = $pad_top + $pre_calculated_row_height + $pad_bot;
670 # $row_h is the calculated global user requested row height.
671 # It will be honored, only if it has bigger value than the calculated one.
672 # TODO: It's questionable if padding should be inclided in this calculation or not
673 if($current_row_height < $row_h){
674 $current_row_height = $row_h;
677 # Define the font y base position for this line.
678 $text_start = $cur_y - ($current_row_height - $pad_bot);
681 my $leftovers = undef; # Reference to text that is returned from textblock()
682 my $do_leftovers = 0;
684 # Process every cell(column) from current row
685 for( my $column_idx = 0; $column_idx < scalar( @$record); $column_idx++ )
687 next unless $col_props->[$column_idx]->{'max_w'};
688 next unless $col_props->[$column_idx]->{'min_w'};
689 $leftovers->[$column_idx] = undef;
691 # look for font information for this cell
692 my ($cell_font, $cell_font_size, $cell_font_color, $cell_font_underline, $justify);
694 if( $first_row and ref $header_props)
696 $cell_font = $header_props->{'font'};
697 $cell_font_size = $header_props->{'font_size'};
698 $cell_font_color = $header_props->{'font_color'};
699 $cell_font_underline = $header_props->{'font_underline'};
700 $justify = $header_props->{'justify'};
703 # Get the most specific value if none was already set from header_props
704 $cell_font ||= $cell_props->[$row_index][$column_idx]->{'font'}
705 || $col_props->[$column_idx]->{'font'}
708 $cell_font_size ||= $cell_props->[$row_index][$column_idx]->{'font_size'}
709 || $col_props->[$column_idx]->{'font_size'}
712 $cell_font_color ||= $cell_props->[$row_index][$column_idx]->{'font_color'}
713 || $col_props->[$column_idx]->{'font_color'}
716 $cell_font_underline ||= $cell_props->[$row_index][$column_idx]->{'font_underline'}
717 || $col_props->[$column_idx]->{'font_underline'}
721 $justify ||= $cell_props->[$row_index][$column_idx]->{'justify'}
722 || $col_props->[$column_idx]->{'justify'}
726 # Init cell font object
727 $txt->font( $cell_font, $cell_font_size );
728 $txt->fillcolor($cell_font_color);
730 # Added to resolve infite loop bug with returned undef values
731 $record->[$column_idx] //= $cell_props->[$row_index][$column_idx]->{'default_text'}
732 // $col_props->[$column_idx]->{'default_text'}
735 # If the content is wider than the specified width, we need to add the text as a text block
736 if( $record->[$column_idx] !~ m/(.\n.)/ and
737 $record_widths->[$column_idx] and
738 $record_widths->[$column_idx] <= $calc_column_widths->[$column_idx]
740 my $space = $pad_left;
741 if ($justify eq 'right')
743 $space = $calc_column_widths->[$column_idx] -($txt->advancewidth($record->[$column_idx]) + $pad_right);
745 elsif ($justify eq 'center')
747 $space = ($calc_column_widths->[$column_idx] - $txt->advancewidth($record->[$column_idx])) / 2;
749 $txt->translate( $cur_x + $space, $text_start );
751 $text_options{'-underline'} = $cell_font_underline if $cell_font_underline;
752 $txt->text( $record->[$column_idx], %text_options );
754 # Otherwise just use the $page->text() method
757 my ($width_of_last_line, $ypos_of_last_line, $left_over_text) = $self->text_block(
759 $record->[$column_idx],
760 x => $cur_x + $pad_left,
762 w => $calc_column_widths->[$column_idx] - $pad_left - $pad_right,
763 h => $cur_y - $bot_marg - $pad_top - $pad_bot,
767 # Desi - Removed $lead because of fixed incorrect ypos bug in text_block
768 my $current_cell_height = $cur_y - $ypos_of_last_line + $pad_bot;
769 if( $current_cell_height > $current_row_height )
771 $current_row_height = $current_cell_height;
774 if( $left_over_text )
776 $leftovers->[$column_idx] = $left_over_text;
781 # Hook to pass coordinates back - http://www.perlmonks.org/?node_id=754777
782 if (ref $arg{cell_render_hook} eq 'CODE') {
783 $arg{cell_render_hook}->(
790 $calc_column_widths->[$column_idx],
795 $cur_x += $calc_column_widths->[$column_idx];
799 unshift @$data, $leftovers;
800 unshift @$row_col_widths, $record_widths;
801 unshift @$rows_height, $pre_calculated_row_height;
805 # This has to be separately from the text loop
806 # because we do not know the final height of the cell until all text has been drawn
808 for(my $column_idx = 0 ; $column_idx < scalar(@$record) ; $column_idx++)
812 if( $first_row and ref $header_props)
813 { #Compatibility Consistency with other props
814 $cell_bg_color = $header_props->{'bg_color'} || $header_props->{'background_color'};
817 # Get the most specific value if none was already set from header_props
818 $cell_bg_color ||= $cell_props->[$row_index][$column_idx]->{'background_color'}
819 || $col_props->[$column_idx]->{'background_color'}
820 || $background_color;
824 $gfx_bg->rect( $cur_x, $cur_y-$current_row_height, $calc_column_widths->[$column_idx], $current_row_height);
825 $gfx_bg->fillcolor($cell_bg_color);
828 $cur_x += $calc_column_widths->[$column_idx];
829 }#End of for(my $column_idx....
831 $cur_y -= $current_row_height;
832 if ($gfx && $horiz_borders)
834 $gfx->move( $xbase , $cur_y );
835 $gfx->hline( $xbase + $width );
838 $row_index++ unless ( $do_leftovers );
844 # Draw vertical lines
847 $gfx->move( $xbase, $table_top_y);
848 $gfx->vline( $cur_y );
850 for( my $j = 0; $j < $columns_number; $j++ )
852 $cur_x += $calc_column_widths->[$j];
853 $gfx->move( $cur_x, $table_top_y );
854 $gfx->vline( $cur_y );
858 # ACTUALLY draw all the lines
859 $gfx->fillcolor( $border_color);
863 }# End of while(scalar(@{$data}))
865 return ($page,--$pg_cnt,$cur_y);
869 # calculate the column widths
872 my $col_props = shift;
873 my $avail_width = shift;
878 for(my $j = 0; $j < scalar( @$col_props); $j++)
880 $min_width += $col_props->[$j]->{min_w} || 0;
883 # I think this is the optimal variant when good view can be guaranateed
884 if($avail_width < $min_width)
886 carp "!!! Warning !!!\n Calculated Mininal width($min_width) > Table width($avail_width).\n",
887 ' Expanding table width to:',int($min_width)+1,' but this could lead to unexpected results.',"\n",
888 ' Possible solutions:',"\n",
889 ' 0)Increase table width.',"\n",
890 ' 1)Decrease font size.',"\n",
891 ' 2)Choose a more narrow font.',"\n",
892 ' 3)Decrease "max_word_length" parameter.',"\n",
893 ' 4)Rotate page to landscape(if it is portrait).',"\n",
894 ' 5)Use larger paper size.',"\n",
895 '!!! --------- !!!',"\n";
896 $avail_width = int( $min_width) + 1;
900 # Calculate how much can be added to every column to fit the available width.
901 for(my $j = 0; $j < scalar(@$col_props); $j++ )
903 $calc_widths->[$j] = $col_props->[$j]->{min_w} || 0;;
906 # Allow columns to expand to max_w before applying extra space equally.
910 my $span = ($avail_width - $min_width) / scalar( @$col_props);
914 my $next_will_be_last_iter = 1;
915 for(my $j = 0; $j < scalar(@$col_props); $j++ )
917 my $new_w = $calc_widths->[$j] + $span;
919 if (!$is_last_iter && $new_w > $col_props->[$j]->{max_w})
921 $new_w = $col_props->[$j]->{max_w}
923 if ($calc_widths->[$j] != $new_w )
925 $calc_widths->[$j] = $new_w;
926 $next_will_be_last_iter = 0;
928 $min_width += $new_w;
930 last if $is_last_iter;
931 $is_last_iter = $next_will_be_last_iter;
934 return ($calc_widths,$avail_width);
944 PDF::Table - A utility class for building table layouts in a PDF::API2 object.
951 my $pdftable = new PDF::Table;
952 my $pdf = new PDF::API2(-file => "table_of_lorem.pdf");
953 my $page = $pdf->page;
955 # some data to layout
957 ["1 Lorem ipsum dolor",
958 "Donec odio neque, faucibus vel",
959 "consequat quis, tincidunt vel, felis."],
960 ["Nulla euismod sem eget neque.",
966 $left_edge_of_table = 50;
967 # build the table layout
973 x => $left_edge_of_table,
977 # some optional params
982 background_color_odd => "gray",
983 background_color_even => "lightblue", #cell background color for even rows
986 # do other stuff with $pdf
992 For a complete working example or initial script look into distribution`s 'examples' folder.
997 This class is a utility for use with the PDF::API2 module from CPAN.
998 It can be used to display text data in a table layout within a PDF.
999 The text data must be in a 2D array (such as returned by a DBI statement handle fetchall_arrayref() call).
1000 The PDF::Table will automatically add as many new pages as necessary to display all of the data.
1001 Various layout properties, such as font, font size, and cell padding and background color can be specified for each column and/or for even/odd rows.
1002 Also a (non)repeated header row with different layout properties can be specified.
1004 See the L</METHODS> section for complete documentation of every parameter.
1010 my $pdf_table = new PDF::Table;
1016 Creates a new instance of the class. (to be improved)
1020 There are no parameters.
1024 Reference to the new instance
1030 my ($final_page, $number_of_pages, $final_y) = table($pdf, $page, $data, %settings)
1036 Generates a multi-row, multi-column table into an existing PDF document based on provided data set and settings.
1040 $pdf - a PDF::API2 instance representing the document being created
1041 $page - a PDF::API2::Page instance representing the current page of the document
1042 $data - an ARRAY reference to a 2D data structure that will be used to build the table
1043 %settings - HASH with geometry and formatting parameters.
1045 For full %settings description see section L</Table settings> below.
1047 This method will add more pages to the pdf instance as required based on the formatting options and the amount of data.
1051 The return value is a 3 items list where
1053 $final_page - The first item is a PDF::API2::Page instance that the table ends on
1054 $number_of_pages - The second item is the count of pages that the table spans on
1055 $final_y - The third item is the Y coordinate of the table bottom so that additional content can be added in the same document.
1059 my $pdf = new PDF::API2;
1060 my $page = $pdf->page();
1062 ['foo1','bar1','baz1'],
1063 ['foo2','bar2','baz2']
1072 my ($final_page, $number_of_pages, $final_y) = $pdftable->table( $pdf, $page, $data, %options );
1076 =head3 Table settings
1080 There are some mandatory parameteres for setting table geometry and position across page(s)
1084 =item B<x> - X coordinate of upper left corner of the table. Left edge of the sheet is 0.
1086 B<Value:> can be any whole number satisfying 0 =< X < PageWidth
1087 B<Default:> No default value
1091 =item B<start_y> - Y coordinate of upper left corner of the table at the initial page.
1093 B<Value:> can be any whole number satisfying 0 < start_y < PageHeight (depending on space availability when embedding a table)
1094 B<Default:> No default value
1098 =item B<w> - width of the table starting from X.
1100 B<Value:> can be any whole number satisfying 0 < w < PageWidth - x
1101 B<Default:> No default value
1105 =item B<start_h> - Height of the table on the initial page
1107 B<Value:> can be any whole number satisfying 0 < start_h < PageHeight - Current Y position
1108 B<Default:> No default value
1118 =item B<next_h> - Height of the table on any additional page
1120 B<Value:> can be any whole number satisfying 0 < next_h < PageHeight
1121 B<Default:> Value of param B<'start_h'>
1125 =item B<next_y> - Y coordinate of upper left corner of the table at any additional page.
1127 B<Value:> can be any whole number satisfying 0 < next_y < PageHeight
1128 B<Default:> Value of param B<'start_y'>
1132 =item B<max_word_length> - Breaks long words (like serial numbers hashes etc.) by adding a space after every Nth symbol
1134 B<Value:> can be any whole positive number
1137 max_word_length => 20 # Will add a space after every 20 symbols
1139 =item B<padding> - Padding applied to every cell
1141 =item B<padding_top> - top cell padding, overrides 'padding'
1143 =item B<padding_right> - right cell padding, overrides 'padding'
1145 =item B<padding_left> - left cell padding, overrides 'padding'
1147 =item B<padding_bottom> - bottom padding, overrides 'padding'
1149 B<Value:> can be any whole positive number
1151 B<Default padding:> 0
1153 B<Default padding_*> $padding
1155 padding => 5 # all sides cell padding
1156 padding_top => 8, # top cell padding, overrides 'padding'
1157 padding_right => 6, # right cell padding, overrides 'padding'
1158 padding_left => 2, # left cell padding, overrides 'padding'
1159 padding_bottom => undef # bottom padding will be 5 as it will fallback to 'padding'
1161 =item B<border> - Width of table border lines.
1163 =item B<horizontal_borders> - Width of horizontal border lines. Overrides 'border' value.
1165 =item B<vertical_borders> - Width of vertical border lines. Overrides 'border' value.
1167 B<Value:> can be any whole positive number. When set to 0 will disable border lines.
1170 border => 3 # border width is 3
1171 horizontal_borders => 1 # horizontal borders will be 1 overriding 3
1172 vertical_borders => undef # vertical borders will be 3 as it will fallback to 'border'
1174 =item B<vertical_borders> - Width of vertical border lines. Overrides 'border' value.
1176 B<Value:> Color specifier as 'name' or 'HEX'
1179 border_color => 'red'
1181 =item B<font> - instance of PDF::API2::Resource::Font defining the fontf to be used in the table
1183 B<Value:> can be any PDF::API2::Resource::* type of font
1184 B<Default:> 'Times' with UTF8 encoding
1186 font => $pdf->corefont("Helvetica", -encoding => "utf8")
1188 =item B<font_size> - Default size of the font that will be used across the table
1190 B<Value:> can be any positive number
1195 =item B<font_color> - Font color for all rows
1197 =item B<font_color_odd> - Font color for odd rows
1199 =item B<font_color_even> - Font color for even rows
1201 =item B<font_underline> - Font underline of the header row
1203 B<Value:> 'auto', integer of distance, or arrayref of distance & thickness (more than one pair will provide mlultiple underlines. Negative distance gives strike-through.
1206 =item B<background_color_odd> - Background color for odd rows
1208 =item B<background_color_even> - Background color for even rows
1210 B<Value:> Color specifier as 'name' or 'HEX'
1211 B<Default:> 'black' font on 'white' background
1213 font_color => '#333333'
1214 font_color_odd => 'purple'
1215 font_color_even => '#00FF00'
1216 background_color_odd => 'gray'
1217 background_color_even => 'lightblue'
1219 =item B<row_height> - Desired row height but it will be honored only if row_height > font_size + padding_top + padding_bottom
1221 B<Value:> can be any whole positive number
1222 B<Default:> font_size + padding_top + padding_bottom
1226 =item B<new_page_func> - CODE reference to a function that returns a PDF::API2::Page instance.
1228 If used the parameter 'new_page_func' must be a function reference which when executed will create a new page and will return the object back to the module.
1229 For example you can use it to put Page Title, Page Frame, Page Numbers and other staff that you need.
1230 Also if you need some different type of paper size and orientation than the default A4-Portrait for example B2-Landscape you can use this function ref to set it up for you. For more info about creating pages refer to PDF::API2 PAGE METHODS Section.
1231 Don't forget that your function must return a page object created with PDF::API2 page() method.
1233 new_page_func => $code_ref
1235 =item B<header_props> - HASH reference to specific settings for the Header row of the table. See section L</Header Row Properties> below
1237 header_props => $hdr_props
1239 =item B<column_props> - HASH reference to specific settings for each column of the table. See section L</Column Properties> below
1241 column_props => $col_props
1243 =item B<cell_props> - HASH reference to specific settings for each column of the table. See section L</Cell Properties> below
1245 cell_props => $cel_props
1247 =item B<cell_render_hook> - CODE reference to a function called with the current cell coordinates. If used the parameter 'cell_render_hook' must be a function reference. It is most useful for creating a url link inside of a cell. The following example adds a link in the first column of each non-header row:
1249 cell_render_hook => sub {
1250 my ($page, $first_row, $row, $col, $x, $y, $w, $h) = @_;
1252 # Do nothing except for first column (and not a header row)
1253 return unless ($col == 0);
1254 return if ($first_row);
1257 my $value = $list_of_vals[$row-1];
1258 my $url = "https://${hostname}/app/${value}";
1260 my $annot = $page->annotation();
1261 $annot->url( $url, -rect => [$x, $y, $x+$w, $y+$h] );
1266 =head4 Header Row Properties
1268 If the 'header_props' parameter is used, it should be a hashref. Passing an empty HASH will trigger a header row initialised with Default values.
1269 There is no 'data' variable for the content, because the module asumes that first table row will become the header row. It will copy this row and put it on every new page if 'repeat' param is set.
1273 =item B<font> - instance of PDF::API2::Resource::Font defining the fontf to be used in the header row
1275 B<Value:> can be any PDF::API2::Resource::* type of font
1276 B<Default:> 'font' of the table. See table parameter 'font' for more details.
1278 =item B<font_size> - Font size of the header row
1280 B<Value:> can be any positive number
1281 B<Default:> 'font_size' of the table + 2
1283 =item B<font_color> - Font color of the header row
1285 B<Value:> Color specifier as 'name' or 'HEX'
1286 B<Default:> '#000066'
1288 =item B<font_underline> - Font underline of the header row
1290 B<Value:> 'auto', integer of distance, or arrayref of distance & thickness (more than one pair will provide mlultiple underlines. Negative distance gives strike-through.
1293 =item B<bg_color> - Background color of the header row
1295 B<Value:> Color specifier as 'name' or 'HEX'
1298 =item B<repeat> - Flag showing if header row should be repeated on every new page
1300 B<Value:> 0,1 1-Yes/True, 0-No/False
1303 =item B<justify> - Alignment of text in the header row.
1305 B<Value:> One of 'left', 'right', 'center'
1306 B<Default:> Same as column alignment (or 'left' if undefined)
1310 font => $pdf->corefont("Helvetica", -encoding => "utf8"),
1312 font_color => '#004444',
1313 bg_color => 'yellow',
1320 =head4 Column Properties
1322 If the 'column_props' parameter is used, it should be an arrayref of hashrefs,
1323 with one hashref for each column of the table. The columns are counted from left to right so the hash reference at $col_props[0] will hold properties for the first column from left to right.
1324 If you DO NOT want to give properties for a column but to give for another just insert and empty hash reference into the array for the column that you want to skip. This will cause the counting to proceed as expected and the properties to be applyed at the right columns.
1326 Each hashref can contain any of the keys shown below:
1330 =item B<min_w> - Minimum width of this column. Auto calculation will try its best to honour this param but aplying it is NOT guaranteed.
1332 B<Value:> can be any whole number satisfying 0 < min_w < w
1333 B<Default:> Auto calculated
1335 =item B<max_w> - Maximum width of this column. Auto calculation will try its best to honour this param but aplying it is NOT guaranteed.
1337 B<Value:> can be any whole number satisfying 0 < max_w < w
1338 B<Default:> Auto calculated
1340 =item B<font> - instance of PDF::API2::Resource::Font defining the fontf to be used in this column
1342 B<Value:> can be any PDF::API2::Resource::* type of font
1343 B<Default:> 'font' of the table. See table parameter 'font' for more details.
1345 =item B<font_size> - Font size of this column
1347 B<Value:> can be any positive number
1348 B<Default:> 'font_size' of the table.
1350 =item B<font_color> - Font color of this column
1352 B<Value:> Color specifier as 'name' or 'HEX'
1353 B<Default:> 'font_color' of the table.
1355 =item B<font_underline> - Font underline of this cell
1357 B<Value:> 'auto', integer of distance, or arrayref of distance & thickness (more than one pair will provide mlultiple underlines. Negative distance gives strike-through.
1360 =item B<background_color> - Background color of this column
1362 B<Value:> Color specifier as 'name' or 'HEX'
1365 =item B<justify> - Alignment of text in this column
1367 B<Value:> One of 'left', 'right', 'center'
1373 {},# This is an empty hash so the next one will hold the properties for the second column from left to right.
1375 min_w => 100, # Minimum column width of 100.
1376 max_w => 150, # Maximum column width of 150 .
1377 justify => 'right', # Right text alignment
1378 font => $pdf->corefont("Helvetica", -encoding => "latin1"),
1380 font_color=> 'blue',
1381 background_color => '#FFFF00',
1388 NOTE: If 'min_w' and/or 'max_w' parameter is used in 'col_props', have in mind that it may be overridden by the calculated minimum/maximum cell witdh so that table can be created.
1389 When this happens a warning will be issued with some advises what can be done.
1390 In cases of a conflict between column formatting and odd/even row formatting, 'col_props' will override odd/even.
1392 =head4 Cell Properties
1394 If the 'cell_props' parameter is used, it should be an arrayref with arrays of hashrefs
1395 (of the same dimension as the data array) with one hashref for each cell of the table.
1397 Each hashref can contain any of the keys shown below:
1401 =item B<font> - instance of PDF::API2::Resource::Font defining the fontf to be used in this cell
1403 B<Value:> can be any PDF::API2::Resource::* type of font
1404 B<Default:> 'font' of the table. See table parameter 'font' for more details.
1406 =item B<font_size> - Font size of this cell
1408 B<Value:> can be any positive number
1409 B<Default:> 'font_size' of the table.
1411 =item B<font_color> - Font color of this cell
1413 B<Value:> Color specifier as 'name' or 'HEX'
1414 B<Default:> 'font_color' of the table.
1416 =item B<font_underline> - Font underline of this cell
1418 B<Value:> 'auto', integer of distance, or arrayref of distance & thickness (more than one pair will provide mlultiple underlines. Negative distance gives strike-through.
1421 =item B<background_color> - Background color of this cell
1423 B<Value:> Color specifier as 'name' or 'HEX'
1426 =item B<justify> - Alignment of text in this cell
1428 B<Value:> One of 'left', 'right', 'center'
1434 [ #This array is for the first row. If header_props is defined it will overwrite these settings.
1436 background_color => '#AAAA00',
1437 font_color => 'yellow',
1438 font_underline => [ 2, 2 ],
1445 background_color => '#CCCC00',
1446 font_color => 'blue',
1449 background_color => '#BBBB00',
1450 font_color => 'red',
1459 my $cell_props = [];
1460 $cell_props->[1][0] = {
1462 background_color => '#CCCC00',
1463 font_color => 'blue',
1468 NOTE: In case of a conflict between column, odd/even and cell formatting, cell formatting will overwrite the other two.
1469 In case of a conflict between header row and cell formatting, header formatting will override cell.
1473 my ($width_of_last_line, $ypos_of_last_line, $left_over_text) = text_block( $txt, $data, %settings)
1479 Utility method to create a block of text. The block may contain multiple paragraphs.
1480 It is mainly used internaly but you can use it from outside for placing formatted text anywhere on the sheet.
1482 NOTE: This method will NOT add more pages to the pdf instance if the space is not enough to place the string inside the block.
1483 Leftover text will be returned and has to be handled by the caller - i.e. add a new page and a new block with the leftover.
1487 $txt - a PDF::API2::Page::Text instance representing the text tool
1488 $data - a string that will be placed inside the block
1489 %settings - HASH with geometry and formatting parameters.
1493 The return value is a 3 items list where
1495 $width_of_last_line - Width of last line in the block
1496 $final_y - The Y coordinate of the block bottom so that additional content can be added after it
1497 $left_over_text - Text that was did not fit in the provided box geometry.
1502 my $page = $pdf->page;
1503 my $txt = $page->text;
1512 lead => $font_size | $distance_between_lines,
1513 align => "left|right|center|justify|fulljustify",
1514 hang => $optional_hanging_indent,
1515 Only one of the subsequent 3params can be given.
1516 They override each other.-parspace is the weightest
1517 parspace => $optional_vertical_space_before_first_paragraph,
1518 flindent => $optional_indent_of_first_line,
1519 fpindent => $optional_indent_of_first_paragraph,
1520 indent => $optional_indent_of_text_to_every_non_first_line,
1523 my ( $width_of_last_line, $final_y, $left_over_text ) = $pdftable->text_block( $txt, $data, %settings );
1537 Further development since Ver: 0.02 - Desislav Kamenov
1539 =head1 COPYRIGHT AND LICENSE
1541 Copyright (C) 2006 by Daemmon Hughes, portions Copyright 2004 Stone
1542 Environmental Inc. (www.stone-env.com) All Rights Reserved.
1544 This library is free software; you can redistribute it and/or modify
1545 it under the same terms as Perl itself, either Perl version 5.8.4 or,
1546 at your option, any later version of Perl 5 you may have available.
1552 =item by Daemmon Hughes
1554 Much of the work on this module was sponsered by
1555 Stone Environmental Inc. (www.stone-env.com).
1557 The text_block() method is a slightly modified copy of the one from
1558 Rick Measham's PDF::API2 tutorial at
1559 http://pdfapi2.sourceforge.net/cgi-bin/view/Main/YourFirstDocument
1561 =item by Desislav Kamenov (@deskata on Twitter)
1563 The development of this module was supported by SEEBURGER AG (www.seeburger.com) till year 2007
1565 Thanks to my friends Krasimir Berov and Alex Kantchev for helpful tips and QA during development of versions 0.9.0 to 0.9.5
1567 Thanks to all GitHub contributors!
1573 Hey PDF::Table is on GitHub. You are more than welcome to contribute!
1575 https://github.com/kamenov/PDF-Table