3 # Copyright Koha development team 2011
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>.
37 $batch_id = $cgi->param('batch_id') if $cgi->param('batch_id');
38 my $template_id = $cgi->param('template_id') || undef;
39 my $layout_id = $cgi->param('layout_id') || undef;
40 @label_ids = $cgi->param('label_id') if $cgi->param('label_id');
41 @item_numbers = $cgi->param('item_number') if $cgi->param('item_number');
45 my $csv_file = (@label_ids || @item_numbers ?
"label_single_" . scalar(@label_ids || @item_numbers) : "label_batch_$batch_id");
46 print $cgi->header(-type
=> 'application/vnd.sun.xml.calc',
48 -attachment
=> "$csv_file.csv",
52 my $batch = C4
::Labels
::Batch
->retrieve(batch_id
=> $batch_id);
53 my $template = C4
::Labels
::Template
->retrieve(template_id
=> $template_id, profile_id
=> 1);
54 my $layout = C4
::Labels
::Layout
->retrieve(layout_id
=> $layout_id);
58 my $batch_items = $batch->get_attr('items');
61 push(@
{$items}, grep{$_->{'label_id'} == $label_id;} @
{$batch_items});
64 elsif (@item_numbers) {
66 push(@
{$items}, {item_number
=> $_});
70 $items = $batch->get_attr('items');
73 my $csv = Text
::CSV_XS
->new();
75 foreach my $item (@
$items) {
76 my $label = C4
::Labels
::Label
->new(
77 batch_id
=> $batch_id,
78 item_number
=> $item->{'item_number'},
79 format_string
=> $layout->get_attr('format_string'),
81 my $csv_fields = $label->csv_data();
82 if ($csv->combine(@
$csv_fields)) {
83 print $csv->string() . "\n";
86 warn sprintf('Text::CSV_XS->combine() returned the following error: %s', $csv->error_input);
94 labels/label-create-csv.pl - A script for creating a csv export of labels and label batches in Koha
98 This script provides the means of producing a csv of labels for items either individually, in groups, or in batches from within Koha.
102 Chris Nighswonger <cnighswonger AT foundations DOT edu>
106 Copyright 2009 Foundations Bible College.
110 This file is part of Koha.
112 Koha is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software
113 Foundation; either version 2 of the License, or (at your option) any later version.
115 You should have received a copy of the GNU General Public License along with Koha; if not, write to the Free Software Foundation, Inc., 51 Franklin Street,
116 Fifth Floor, Boston, MA 02110-1301 USA.
118 =head1 DISCLAIMER OF WARRANTY
120 Koha is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
121 A PARTICULAR PURPOSE. See the GNU General Public License for more details.