Lines 45-52
my ( $template, $loggedinuser, $cookie ) = get_template_and_user({
Link Here
|
45 |
flagsrequired => { tools => 'label_creator' }, |
45 |
flagsrequired => { tools => 'label_creator' }, |
46 |
debug => 1, |
46 |
debug => 1, |
47 |
}); |
47 |
}); |
48 |
|
|
|
49 |
|
50 |
my $batch_id = $cgi->param('batch_id') if $cgi->param('batch_id'); |
48 |
my $batch_id = $cgi->param('batch_id') if $cgi->param('batch_id'); |
51 |
my $template_id = $cgi->param('template_id') || undef; |
49 |
my $template_id = $cgi->param('template_id') || undef; |
52 |
my $layout_id = $cgi->param('layout_id') || undef; |
50 |
my $layout_id = $cgi->param('layout_id') || undef; |
Lines 58-239
my $patronlist_id = $cgi->param('patronlist_id');
Link Here
|
58 |
my $items = undef; # items = cards |
56 |
my $items = undef; # items = cards |
59 |
my $new_page = 0; |
57 |
my $new_page = 0; |
60 |
|
58 |
|
61 |
my $pdf_file = (@label_ids || @borrower_numbers ? "card_single_" . scalar(@label_ids || @borrower_numbers) : "card_batch_$batch_id"); |
59 |
# Wrap pdf creation part into an eval, some vars need scope outside eval |
62 |
print $cgi->header( -type => 'application/pdf', |
60 |
my $pdf_ok; |
63 |
-encoding => 'utf-8', |
61 |
my $pdf; |
64 |
-attachment => "$pdf_file.pdf", |
62 |
my $pdf_file; |
65 |
); |
|
|
66 |
|
63 |
|
67 |
my $pdf = C4::Creators::PDF->new(InitVars => 0); |
64 |
eval { |
68 |
my $batch = C4::Patroncards::Batch->retrieve(batch_id => $batch_id); |
65 |
$pdf_file = (@label_ids || @borrower_numbers ? "card_single_" . scalar(@label_ids || @borrower_numbers) : "card_batch_$batch_id"); |
69 |
my $pc_template = C4::Patroncards::Template->retrieve(template_id => $template_id, profile_id => 1); |
|
|
70 |
my $layout = C4::Patroncards::Layout->retrieve(layout_id => $layout_id); |
71 |
|
66 |
|
72 |
$| = 1; |
67 |
$pdf = C4::Creators::PDF->new(InitVars => 0); |
|
|
68 |
my $batch = C4::Patroncards::Batch->retrieve(batch_id => $batch_id); |
69 |
my $pc_template = C4::Patroncards::Template->retrieve(template_id => $template_id, profile_id => 1); |
70 |
my $layout = C4::Patroncards::Layout->retrieve(layout_id => $layout_id); |
73 |
|
71 |
|
74 |
# set the paper size |
72 |
$| = 1; |
75 |
my $lower_left_x = 0; |
|
|
76 |
my $lower_left_y = 0; |
77 |
my $upper_right_x = $pc_template->get_attr('page_width'); |
78 |
my $upper_right_y = $pc_template->get_attr('page_height'); |
79 |
|
73 |
|
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... |
74 |
# set the paper size |
81 |
$pdf->Mbox($lower_left_x, $lower_left_y, $upper_right_x, $upper_right_y); |
75 |
my $lower_left_x = 0; |
|
|
76 |
my $lower_left_y = 0; |
77 |
my $upper_right_x = $pc_template->get_attr('page_width'); |
78 |
my $upper_right_y = $pc_template->get_attr('page_height'); |
82 |
|
79 |
|
83 |
my ($llx, $lly) = 0,0; |
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... |
84 |
(undef, undef, $llx, $lly) = $pc_template->get_label_position($start_card); |
81 |
$pdf->Mbox($lower_left_x, $lower_left_y, $upper_right_x, $upper_right_y); |
85 |
|
82 |
|
86 |
if (@label_ids) { |
83 |
my ($llx, $lly) = 0,0; |
|
|
84 |
(undef, undef, $llx, $lly) = $pc_template->get_label_position($start_card); |
85 |
|
86 |
if (@label_ids) { |
87 |
my $batch_items = $batch->get_attr('items'); |
87 |
my $batch_items = $batch->get_attr('items'); |
88 |
grep { |
88 |
grep { |
89 |
my $label_id = $_; |
89 |
my $label_id = $_; |
90 |
push(@{$items}, grep{$_->{'label_id'} == $label_id;} @{$batch_items}); |
90 |
push(@{$items}, grep{$_->{'label_id'} == $label_id;} @{$batch_items}); |
91 |
} @label_ids; |
91 |
} @label_ids; |
92 |
} |
92 |
} |
93 |
elsif (@borrower_numbers) { |
93 |
elsif (@borrower_numbers) { |
94 |
grep { |
94 |
grep { |
95 |
push(@{$items}, {borrower_number => $_}); |
95 |
push(@{$items}, {borrower_number => $_}); |
96 |
} @borrower_numbers; |
96 |
} @borrower_numbers; |
97 |
} |
97 |
} |
98 |
elsif ( $patronlist_id ) { |
98 |
elsif ( $patronlist_id ) { |
99 |
my ($list) = GetPatronLists( { patron_list_id => $patronlist_id } ); |
99 |
my ($list) = GetPatronLists( { patron_list_id => $patronlist_id } ); |
100 |
my @borrowerlist = $list->patron_list_patrons()->search_related('borrowernumber') |
100 |
my @borrowerlist = $list->patron_list_patrons()->search_related('borrowernumber') |
101 |
->get_column('borrowernumber')->all(); |
101 |
->get_column('borrowernumber')->all(); |
102 |
grep { |
102 |
grep { |
103 |
push(@{$items}, {borrower_number => $_}); |
103 |
push(@{$items}, {borrower_number => $_}); |
104 |
} @borrowerlist; |
104 |
} @borrowerlist; |
105 |
} |
105 |
} |
106 |
else { |
106 |
else { |
107 |
$items = $batch->get_attr('items'); |
107 |
$items = $batch->get_attr('items'); |
108 |
} |
108 |
} |
109 |
|
109 |
|
110 |
my $layout_xml = XMLin($layout->get_attr('layout_xml'), ForceArray => 1); |
110 |
my $layout_xml = XMLin($layout->get_attr('layout_xml'), ForceArray => 1); |
111 |
|
111 |
|
112 |
if ($layout_xml->{'page_side'} eq 'B') { # rearrange items on backside of page to swap columns |
112 |
if ($layout_xml->{'page_side'} eq 'B') { # rearrange items on backside of page to swap columns |
113 |
my $even = 1; |
113 |
my $even = 1; |
114 |
my $odd = 0; |
114 |
my $odd = 0; |
115 |
my @swap_array = (); |
115 |
my @swap_array = (); |
116 |
while ($even <= (scalar(@{$items})+1)) { |
116 |
while ($even <= (scalar(@{$items})+1)) { |
117 |
push (@swap_array, @{$items}[$even]); |
117 |
push (@swap_array, @{$items}[$even]); |
118 |
push (@swap_array, @{$items}[$odd]); |
118 |
push (@swap_array, @{$items}[$odd]); |
119 |
$even += 2; |
119 |
$even += 2; |
120 |
$odd += 2; |
120 |
$odd += 2; |
|
|
121 |
} |
122 |
@{$items} = @swap_array; |
121 |
} |
123 |
} |
122 |
@{$items} = @swap_array; |
|
|
123 |
} |
124 |
|
124 |
|
125 |
CARD_ITEMS: |
125 |
CARD_ITEMS: |
126 |
foreach my $item (@{$items}) { |
126 |
foreach my $item (@{$items}) { |
127 |
if ($item) { |
127 |
if ($item) { |
128 |
my $borrower_number = $item->{'borrower_number'}; |
128 |
my $borrower_number = $item->{'borrower_number'}; |
129 |
my $card_number = GetMember(borrowernumber => $borrower_number)->{'cardnumber'}; |
129 |
my $card_number = GetMember(borrowernumber => $borrower_number)->{'cardnumber'}; |
130 |
|
130 |
|
131 |
# Set barcode data |
131 |
# Set barcode data |
132 |
$layout_xml->{'barcode'}->[0]->{'data'} = $card_number if $layout_xml->{'barcode'}; |
132 |
$layout_xml->{'barcode'}->[0]->{'data'} = $card_number if $layout_xml->{'barcode'}; |
133 |
|
133 |
|
134 |
# Create a new patroncard object |
134 |
# Create a new patroncard object |
135 |
my $patron_card = C4::Patroncards::Patroncard->new( |
135 |
my $patron_card = C4::Patroncards::Patroncard->new( |
136 |
batch_id => 1, |
136 |
batch_id => 1, |
137 |
borrower_number => $borrower_number, |
137 |
borrower_number => $borrower_number, |
138 |
llx => $llx, # lower left corner of the card |
138 |
llx => $llx, # lower left corner of the card |
139 |
lly => $lly, |
139 |
lly => $lly, |
140 |
height => $pc_template->get_attr('label_height'), # of the card |
140 |
height => $pc_template->get_attr('label_height'), # of the card |
141 |
width => $pc_template->get_attr('label_width'), |
141 |
width => $pc_template->get_attr('label_width'), |
142 |
layout => $layout_xml, |
142 |
layout => $layout_xml, |
143 |
text_wrap_cols => 30, #FIXME: hardcoded, |
143 |
text_wrap_cols => 30, #FIXME: hardcoded, |
144 |
); |
144 |
); |
145 |
|
145 |
|
146 |
$patron_card->draw_guide_box($pdf) if $layout_xml->{'guide_box'}; |
146 |
$patron_card->draw_guide_box($pdf) if $layout_xml->{'guide_box'}; |
147 |
$patron_card->draw_barcode($pdf) if $layout_xml->{'barcode'}; |
147 |
$patron_card->draw_barcode($pdf) if $layout_xml->{'barcode'}; |
148 |
|
148 |
|
149 |
# Do image foo and place binary image data into layout hash |
149 |
# Do image foo and place binary image data into layout hash |
150 |
my $image_data = {}; |
150 |
my $image_data = {}; |
151 |
my $error = undef; |
151 |
my $error = undef; |
152 |
my $images = $layout_xml->{'images'}; |
152 |
my $images = $layout_xml->{'images'}; |
153 |
PROCESS_IMAGES: |
153 |
PROCESS_IMAGES: |
154 |
foreach (keys %{$images}) { |
154 |
foreach (keys %{$images}) { |
155 |
if (grep{m/source/} keys(%{$images->{$_}->{'data_source'}->[0]})) { |
155 |
if (grep{m/source/} keys(%{$images->{$_}->{'data_source'}->[0]})) { |
156 |
if ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'none') { |
156 |
if ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'none') { |
157 |
next PROCESS_IMAGES; |
157 |
next PROCESS_IMAGES; |
158 |
} |
158 |
} |
159 |
elsif ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'patronimages') { |
159 |
elsif ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'patronimages') { |
160 |
my $patron_image = Koha::Patron::Images->find($borrower_number); |
160 |
my $patron_image = Koha::Patron::Images->find($borrower_number); |
161 |
if ($patron_image) { |
161 |
if ($patron_image) { |
162 |
$image_data->{'imagefile'} = $patron_image->imagefile; |
162 |
$image_data->{'imagefile'} = $patron_image->imagefile; |
|
|
163 |
} |
164 |
else { |
165 |
warn sprintf('No image exists for borrower number %s.', $borrower_number); |
166 |
} |
167 |
next PROCESS_IMAGES unless $patron_image; |
168 |
} |
169 |
elsif ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'creator_images') { |
170 |
my $dbh = C4::Context->dbh(); |
171 |
$dbh->{LongReadLen} = 1000000; # allows us to read approx 1MB |
172 |
$image_data = $dbh->selectrow_hashref("SELECT imagefile FROM creator_images WHERE image_name = \'$images->{$_}->{'data_source'}->[0]->{'image_name'}\'"); |
173 |
warn sprintf('Database returned the following error: %s.', $error) if $error; |
174 |
warn sprintf('Image does not exists in db table %s.', $images->{$_}->{'data_source'}->[0]->{'image_name'}) if !$image_data; |
175 |
next PROCESS_IMAGES if !$image_data; |
163 |
} |
176 |
} |
164 |
else { |
177 |
else { |
165 |
warn sprintf('No image exists for borrower number %s.', $borrower_number); |
178 |
warn sprintf('No retrieval method for image source %s.', $images->{$_}->{'data_source'}->[0]->{'image_source'}); |
|
|
179 |
next PROCESS_IMAGES; |
166 |
} |
180 |
} |
167 |
next PROCESS_IMAGES unless $patron_image; |
|
|
168 |
} |
169 |
elsif ($images->{$_}->{'data_source'}->[0]->{'image_source'} eq 'creator_images') { |
170 |
my $dbh = C4::Context->dbh(); |
171 |
$dbh->{LongReadLen} = 1000000; # allows us to read approx 1MB |
172 |
$image_data = $dbh->selectrow_hashref("SELECT imagefile FROM creator_images WHERE image_name = \'$images->{$_}->{'data_source'}->[0]->{'image_name'}\'"); |
173 |
warn sprintf('Database returned the following error: %s.', $error) if $error; |
174 |
warn sprintf('Image does not exists in db table %s.', $images->{$_}->{'data_source'}->[0]->{'image_name'}) if !$image_data; |
175 |
next PROCESS_IMAGES if !$image_data; |
176 |
} |
181 |
} |
177 |
else { |
182 |
else { |
178 |
warn sprintf('No retrieval method for image source %s.', $images->{$_}->{'data_source'}->[0]->{'image_source'}); |
183 |
warn sprintf("Unrecognized image data source: %s", $images->{$_}->{'data_source'}); |
179 |
next PROCESS_IMAGES; |
184 |
next PROCESS_IMAGES; |
180 |
} |
185 |
} |
181 |
} |
|
|
182 |
else { |
183 |
warn sprintf("Unrecognized image data source: %s", $images->{$_}->{'data_source'}); |
184 |
next PROCESS_IMAGES; |
185 |
} |
186 |
|
186 |
|
187 |
my $binary_data = $image_data->{'imagefile'}; |
187 |
my $binary_data = $image_data->{'imagefile'}; |
188 |
|
188 |
|
189 |
# invoke the display image object... |
189 |
# invoke the display image object... |
190 |
my $image = Graphics::Magick->new; |
190 |
my $image = Graphics::Magick->new; |
191 |
$image->BlobToImage($binary_data); |
191 |
$image->BlobToImage($binary_data); |
192 |
|
192 |
|
193 |
# invoke the alt (aka print) image object... |
193 |
# invoke the alt (aka print) image object... |
194 |
my $alt_image = Graphics::Magick->new; |
194 |
my $alt_image = Graphics::Magick->new; |
195 |
$alt_image->BlobToImage($binary_data); |
195 |
$alt_image->BlobToImage($binary_data); |
196 |
$alt_image->Set(magick => 'jpg', quality => 100); |
196 |
$alt_image->Set(magick => 'jpg', quality => 100); |
197 |
|
197 |
|
198 |
#To avoid pixelation have the image 5 times bigger and |
198 |
#To avoid pixelation have the image 5 times bigger and |
199 |
#scale it down in PDF itself |
199 |
#scale it down in PDF itself |
200 |
my $oversize_factor = 8; |
200 |
my $oversize_factor = 8; |
201 |
my $pdf_scale_factor = 1 / $oversize_factor; |
201 |
my $pdf_scale_factor = 1 / $oversize_factor; |
202 |
|
202 |
|
203 |
my $alt_width = ceil($image->Get('width')); # the rounding up is important: Adobe reader does not handle long decimal numbers well |
203 |
my $alt_width = ceil($image->Get('width')); # the rounding up is important: Adobe reader does not handle long decimal numbers well |
204 |
my $alt_height = ceil($image->Get('height')); |
204 |
my $alt_height = ceil($image->Get('height')); |
205 |
my $ratio = $alt_width / $alt_height; |
205 |
my $ratio = $alt_width / $alt_height; |
206 |
my $display_height = ceil($images->{$_}->{'Dx'}); |
206 |
my $display_height = ceil($images->{$_}->{'Dx'}); |
207 |
my $display_width = ceil($ratio * $display_height); |
207 |
my $display_width = ceil($ratio * $display_height); |
208 |
|
208 |
|
209 |
|
209 |
|
210 |
$image->Resize(width => $oversize_factor * $display_width, height => $oversize_factor * $display_height); |
210 |
$image->Resize(width => $oversize_factor * $display_width, height => $oversize_factor * $display_height); |
211 |
$image->Set(magick => 'jpg', quality => 100); |
211 |
$image->Set(magick => 'jpg', quality => 100); |
212 |
|
212 |
|
213 |
# Write param for downsizing in pdf |
213 |
# Write param for downsizing in pdf |
214 |
$images->{$_}->{'scale'} = $pdf_scale_factor; |
214 |
$images->{$_}->{'scale'} = $pdf_scale_factor; |
215 |
|
215 |
|
216 |
# Write params for alt image... |
216 |
# Write params for alt image... |
217 |
$images->{$_}->{'alt'}->{'Sx'} = $oversize_factor * $alt_width; |
217 |
$images->{$_}->{'alt'}->{'Sx'} = $oversize_factor * $alt_width; |
218 |
$images->{$_}->{'alt'}->{'Sy'} = $oversize_factor * $alt_height; |
218 |
$images->{$_}->{'alt'}->{'Sy'} = $oversize_factor * $alt_height; |
219 |
$images->{$_}->{'alt'}->{'data'} = $alt_image->ImageToBlob(); |
219 |
$images->{$_}->{'alt'}->{'data'} = $alt_image->ImageToBlob(); |
220 |
|
220 |
|
221 |
# Write params for display image... |
221 |
# Write params for display image... |
222 |
$images->{$_}->{'Sx'} = $oversize_factor * $display_width; |
222 |
$images->{$_}->{'Sx'} = $oversize_factor * $display_width; |
223 |
$images->{$_}->{'Sy'} = $oversize_factor * $display_height; |
223 |
$images->{$_}->{'Sy'} = $oversize_factor * $display_height; |
224 |
$images->{$_}->{'data'} = $image->ImageToBlob(); |
224 |
$images->{$_}->{'data'} = $image->ImageToBlob(); |
225 |
|
225 |
|
226 |
my $err = $patron_card->draw_image($pdf); |
226 |
my $err = $patron_card->draw_image($pdf); |
227 |
warn sprintf ("Error encountered while attempting to draw image %s, %s", $_, $err) if $err; |
227 |
warn sprintf ("Error encountered while attempting to draw image %s, %s", $_, $err) if $err; |
|
|
228 |
} |
229 |
$patron_card->draw_text($pdf); |
228 |
} |
230 |
} |
229 |
$patron_card->draw_text($pdf); |
231 |
($llx, $lly, $new_page) = $pc_template->get_next_label_pos(); |
|
|
232 |
$pdf->Page() if $new_page; |
230 |
} |
233 |
} |
231 |
($llx, $lly, $new_page) = $pc_template->get_next_label_pos(); |
234 |
# No errors occured within eval, we can issue the pdf |
232 |
$pdf->Page() if $new_page; |
235 |
$pdf_ok = 1; |
233 |
} |
236 |
}; # end of eval block |
234 |
|
|
|
235 |
$pdf->End(); |
236 |
|
237 |
|
237 |
# FIXME: Possibly do a redirect here if there were error encountered during PDF creation. |
238 |
if ($pdf_ok) { |
|
|
239 |
#issue the pdf |
240 |
print $cgi->header( -type => 'application/pdf', |
241 |
-encoding => 'utf-8', |
242 |
-attachment => "$pdf_file.pdf", |
243 |
); |
244 |
$pdf->End(); |
245 |
} |
246 |
else { |
247 |
# warn user that pdf is not created |
248 |
print $cgi->redirect('/cgi-bin/koha/patroncards/manage.pl?card_element=batch&pdferror=1'); |
249 |
} |
238 |
|
250 |
|
239 |
1; |
251 |
1; |
240 |
- |
|
|