2 # Copyright 2009 Foundations Bible College.
4 # This file is part of Koha.
6 # Koha is free software; you can redistribute it and/or modify it under the
7 # terms of the GNU General Public License as published by the Free Software
8 # Foundation; either version 2 of the License, or (at your option) any later
11 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
12 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
13 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License along with
16 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
17 # Suite 330, Boston, MA 02111-1307 USA
23 use Sys::Syslog qw(syslog);
28 use C4::Labels::Batch 1.000000;
29 use C4::Labels::Template 1.000000;
30 use C4::Labels::Layout 1.000000;
31 use C4::Labels::PDF 1.000000;
32 use C4::Labels::Label 1.000000;
40 my $batch_id = $cgi->param('batch_id') if $cgi->param('batch_id');
41 my $template_id = $cgi->param('template_id') || undef;
42 my $layout_id = $cgi->param('layout_id') || undef;
43 my @label_ids = $cgi->param('label_id') if $cgi->param('label_id');
44 my @item_numbers = $cgi->param('item_number') if $cgi->param('item_number');
48 my $csv_file = (@label_ids || @item_numbers ? "label_single_" . scalar(@label_ids || @item_numbers) : "label_batch_$batch_id");
49 print $cgi->header(-type => 'application/vnd.sun.xml.calc',
51 -attachment => "$csv_file.csv",
55 my $batch = C4::Labels::Batch->retrieve(batch_id => $batch_id);
56 my $template = C4::Labels::Template->retrieve(template_id => $template_id, profile_id => 1);
57 my $layout = C4::Labels::Layout->retrieve(layout_id => $layout_id);
61 my $batch_items = $batch->get_attr('items');
64 push(@{$items}, grep{$_->{'label_id'} == $label_id;} @{$batch_items});
67 elsif (@item_numbers) {
69 push(@{$items}, {item_number => $_});
73 $items = $batch->get_attr('items');
76 my $csv = Text::CSV_XS->new();
79 foreach my $item (@$items) {
80 my $label = C4::Labels::Label->new(
81 batch_id => $batch_id,
82 item_number => $item->{'item_number'},
83 format_string => $layout->get_attr('format_string'),
85 my $csv_fields = $label->csv_data();
86 if ($csv->combine(@$csv_fields)) {
87 print $csv->string() . "\n";
90 syslog("LOG_ERR", "labels/label-create-csv.pl : Text::CSV_XS->combine() returned the following error: %s", $csv->error_input);