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>.
30 check_cookie_auth( $cgi->cookie('CGISESSID'), { catalogue => 1 } );
31 if ( $auth_status ne "ok" ) {
32 print $cgi->header( -type => 'text/plain', -status => '403 Forbidden' );
39 $batch_id = $cgi->param('batch_id') if $cgi->param('batch_id');
40 my $template_id = $cgi->param('template_id') || undef;
41 my $layout_id = $cgi->param('layout_id') || undef;
42 @label_ids = $cgi->multi_param('label_id') if $cgi->param('label_id');
43 @item_numbers = $cgi->multi_param('item_number') if $cgi->param('item_number');
47 my $csv_file = (@label_ids || @item_numbers ? "label_single_" . scalar(@label_ids || @item_numbers) : "label_batch_$batch_id");
48 print $cgi->header(-type => 'application/vnd.sun.xml.calc',
50 -attachment => "$csv_file.csv",
54 my $batch = C4::Labels::Batch->retrieve(batch_id => $batch_id);
55 my $template = C4::Labels::Template->retrieve(template_id => $template_id, profile_id => 1);
56 my $layout = C4::Labels::Layout->retrieve(layout_id => $layout_id);
60 my $batch_items = $batch->get_attr('items');
63 push(@{$items}, grep{$_->{'label_id'} == $label_id;} @{$batch_items});
66 elsif (@item_numbers) {
68 push(@{$items}, {item_number => $_});
72 $items = $batch->get_attr('items');
75 my $csv = Text::CSV_XS->new();
77 foreach my $item (@$items) {
78 my $label = C4::Labels::Label->new(
79 batch_id => $batch_id,
80 item_number => $item->{'item_number'},
81 format_string => $layout->get_attr('format_string'),
83 my $csv_fields = $label->csv_data();
84 if ($csv->combine(@$csv_fields)) {
85 print $csv->string() . "\n";
88 warn sprintf('Text::CSV_XS->combine() returned the following error: %s', $csv->error_input);
96 labels/label-create-csv.pl - A script for creating a csv export of labels and label batches in Koha
100 This script provides the means of producing a csv of labels for items either individually, in groups, or in batches from within Koha.
104 Chris Nighswonger <cnighswonger AT foundations DOT edu>
108 Copyright 2009 Foundations Bible College.
112 This file is part of Koha.
114 Koha is free software; you can redistribute it and/or modify it
115 under the terms of the GNU General Public License as published by
116 the Free Software Foundation; either version 3 of the License, or
117 (at your option) any later version.
119 Koha is distributed in the hope that it will be useful, but
120 WITHOUT ANY WARRANTY; without even the implied warranty of
121 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
122 GNU General Public License for more details.
124 You should have received a copy of the GNU General Public License
125 along with Koha; if not, see <http://www.gnu.org/licenses>.
127 =head1 DISCLAIMER OF WARRANTY
129 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
130 A PARTICULAR PURPOSE. See the GNU General Public License for more details.