3 # Copyright 2009 Foundations Bible College.
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use C4::Auth qw( get_template_and_user );
24 use XML::Simple qw( XMLin );
26 use Storable qw( dclone );
27 use autouse 'Data::Dumper' => qw(Dumper);
32 use Koha::List::Patron qw( GetPatronLists );
34 use Koha::Patron::Images;
38 my ( $template, $loggedinuser, $cookie ) = get_template_and_user({
39 template_name => "labels/label-home.tt",
42 flagsrequired => { tools => 'label_creator' },
44 my $batch_id = $cgi->param('batch_id') || undef;
45 my $template_id = $cgi->param('template_id') || undef;
46 my $layout_id = $cgi->param('layout_id') || undef;
47 my $layout_back_id = $cgi->param('layout_back_id') || undef;
48 my $start_card = $cgi->param('start_card') || 1;
49 my @label_ids = $cgi->multi_param('label_id');
50 my @borrower_numbers = $cgi->multi_param('borrower_number');
51 my $patronlist_id = $cgi->param('patronlist_id');
53 my $items = undef; # items = cards
56 # Wrap pdf creation part into an eval, some vars need scope outside eval
62 #Note fo bug 14138: Indenting follows in separate patch to ease review
64 $pdf_file = (@label_ids || @borrower_numbers ? "card_single_" . scalar(@label_ids || @borrower_numbers) : "card_batch_$batch_id");
66 $pdf = C4::Creators::PDF->new(InitVars => 0);
67 my $batch = C4::Patroncards::Batch->retrieve(batch_id => $batch_id);
68 my $pc_template = C4::Patroncards::Template->retrieve(template_id => $template_id, profile_id => 1);
69 my $layout = C4::Patroncards::Layout->retrieve(layout_id => $layout_id);
70 my $layout_back = $layout_back_id ? C4::Patroncards::Layout->retrieve(layout_id => $layout_back_id) : undef;
77 my $upper_right_x = $pc_template->get_attr('page_width');
78 my $upper_right_y = $pc_template->get_attr('page_height');
80 $pdf->Compress(1); # comment this out to debug pdf files, but be sure to uncomment it in production or you may be very sorry...
81 $pdf->Mbox($lower_left_x, $lower_left_y, $upper_right_x, $upper_right_y);
83 my ($llx, $lly) = 0,0;
84 (undef, undef, $llx, $lly) = $pc_template->get_label_position($start_card);
87 my $batch_items = $batch->get_attr('items');
90 push(@{$items}, grep{$_->{'label_id'} == $label_id;} @{$batch_items});
93 elsif (@borrower_numbers) {
95 push(@{$items}, {borrower_number => $_});
98 elsif ( $patronlist_id ) {
99 my ($list) = GetPatronLists( { patron_list_id => $patronlist_id } );
100 my @borrowerlist = $list->patron_list_patrons()->search_related('borrowernumber')
101 ->get_column('borrowernumber')->all();
103 push(@{$items}, {borrower_number => $_});
107 $items = $batch->get_attr('items');
110 my $layout_xml = XMLin($layout->get_attr('layout_xml'), ForceArray => 1);
111 my $layout_back_xml = defined $layout_back ? XMLin($layout_back->get_attr('layout_xml'), ForceArray => 1) : undef;
113 if ($layout_xml->{'page_side'} eq 'B') { # rearrange items on backside of page to swap columns
117 while ($even <= (scalar(@{$items})+1)) {
118 push (@swap_array, @{$items}[$even]);
119 push (@swap_array, @{$items}[$odd]);
123 @{$items} = @swap_array;
126 # WARNING: Referential nightmare ahead...
129 foreach my $item (@{$items}) {
131 my $print_layout_xml = (( ($cardscount % 2 == 1) && ( $layout_back_id ) ) ?
132 dclone($layout_back_xml) : dclone($layout_xml) ); # We must have a true copy of the layout xml hash, otherwise
133 # we modify the original template and very bad things happen.
136 my $borrower_number = $item->{'borrower_number'};
137 my $card_number = Koha::Patrons->find( $borrower_number)->cardnumber;
140 $print_layout_xml->{'barcode'}->[0]->{'data'} = $card_number if $print_layout_xml->{'barcode'};
142 # Create a new patroncard object
143 my $patron_card = C4::Patroncards::Patroncard->new(
145 borrower_number => $borrower_number,
146 llx => $llx, # lower left corner of the card
148 height => $pc_template->get_attr('label_height'), # of the card
149 width => $pc_template->get_attr('label_width'),
150 layout => $print_layout_xml,
151 text_wrap_cols => 30, #FIXME: hardcoded,
154 $patron_card->draw_guide_box($pdf) if $print_layout_xml->{'guide_box'};
155 $patron_card->draw_guide_grid($pdf) if $print_layout_xml->{'guide_grid'};
156 $patron_card->draw_barcode($pdf) if $print_layout_xml->{'barcode'};
158 # Do image foo and place binary image data into layout hash
161 my $images = $print_layout_xml->{'images'};
163 foreach my $card_image (sort(keys %{$images})) {
164 if (grep{m/(source)/} keys(%{$images->{$card_image}->{'data_source'}->[0]})) {
165 if ($images->{$card_image}->{'data_source'}->[0]->{'image_source'} eq 'none') {
167 elsif ($images->{$card_image}->{'data_source'}->[0]->{'image_source'} eq 'patronimages') {
168 my $patron_image = Koha::Patron::Images->find($borrower_number);
170 $image_data->{'imagefile'} = $patron_image->imagefile;
173 warn sprintf('No image exists for borrower number %s.', $borrower_number);
176 elsif ($images->{$card_image}->{'data_source'}->[0]->{'image_source'} eq 'creator_images') {
177 ## FIXME: The DB stuff here needs to be religated to a Koha::Creator::Images object -chris_n
178 my $dbh = C4::Context->dbh();
179 $dbh->{LongReadLen} = 1000000; # allows us to read approx 1MB
180 $image_data = $dbh->selectrow_hashref("SELECT imagefile FROM creator_images WHERE image_name = \'$images->{$card_image}->{'data_source'}->[0]->{'image_name'}\'");
181 warn sprintf('Database returned the following error: %s.', $error) if $error;
183 warn sprintf('Image does not exists in db table %s.', $images->{$card_image}->{'data_source'}->[0]->{'image_name'});
187 warn sprintf('No retrieval method for image source %s.', $images->{$card_image}->{'data_source'}->[0]->{'image_source'});
191 warn sprintf("Unrecognized image data source: %s", $images->{$card_image}->{'data_source'});
194 my $binary_data = $image_data->{'imagefile'} || next PROCESS_IMAGES;
196 # invoke the display image object...
197 my $image = Graphics::Magick->new;
198 $image->BlobToImage($binary_data);
200 # invoke the alt (aka print) image object...
201 my $alt_image = Graphics::Magick->new;
202 $alt_image->BlobToImage($binary_data);
203 $alt_image->Set(magick => 'jpg', quality => 100);
205 #To avoid pixelation have the image 5 times bigger and
206 #scale it down in PDF itself
207 my $oversize_factor = 8;
208 my $pdf_scale_factor = 1 / $oversize_factor;
210 my $alt_width = ceil($image->Get('width')); # the rounding up is important: Adobe reader does not handle long decimal numbers well
211 my $alt_height = ceil($image->Get('height'));
212 my $ratio = $alt_width / $alt_height;
213 my $display_height = ceil($images->{$card_image}->{'Dx'});
214 my $display_width = ceil($ratio * $display_height);
217 $image->Resize(width => $oversize_factor * $display_width, height => $oversize_factor * $display_height);
218 $image->Set(magick => 'jpg', quality => 100);
220 # Write param for downsizing in pdf
221 $images->{$card_image}->{'scale'} = $pdf_scale_factor;
223 # Write params for alt image...
224 $images->{$card_image}->{'alt'}->{'Sx'} = $oversize_factor * $alt_width;
225 $images->{$card_image}->{'alt'}->{'Sy'} = $oversize_factor * $alt_height;
226 $images->{$card_image}->{'alt'}->{'data'} = $alt_image->ImageToBlob();
228 # Write params for display image...
229 $images->{$card_image}->{'Sx'} = $oversize_factor * $display_width;
230 $images->{$card_image}->{'Sy'} = $oversize_factor * $display_height;
231 $images->{$card_image}->{'data'} = $image->ImageToBlob();
233 my $err = $patron_card->draw_image($pdf);
234 warn sprintf ("Error encountered while attempting to draw image %s, %s", $card_image, $err) if $err;
235 # Destroy all Graphics::Magick objects and related references
236 # or bad things will happen.
241 $patron_card->draw_text($pdf);
243 ($llx, $lly, $new_page) = $pc_template->get_next_label_pos();
245 if ( ($cardscount % 2 == 1) && ( $layout_back_id ) ) {
247 redo; # Use same patron data again for backside in card printer
250 $pdf->Page() if $new_page;
252 # No errors occurred within eval, we can issue the pdf
253 $pdf_ok = 1 if ($cardscount > 0);
254 }; # end of eval block
258 print $cgi->header( -type => 'application/pdf',
259 -encoding => 'utf-8',
260 -attachment => "$pdf_file.pdf",
265 # warn user that pdf is not created
266 my $errparams = '&pdferr=1';
267 $errparams .= "&errba=$batch_id" if $batch_id;
268 $errparams .= "&errpl=$patronlist_id" if $patronlist_id;
269 $errparams = $errparams.'&errpt='.$cgi->param('borrower_number') if $cgi->param('borrower_number');
270 $errparams .= "&errlo=$layout_id" if $layout_id;
271 $errparams .= "&errtpl=$template_id" if $template_id;
272 $errparams .= "&errnocards=1" if !$cardscount;
274 print $cgi->redirect("/cgi-bin/koha/patroncards/manage.pl?card_element=batch$errparams");