3 # Copyright 2006 Katipo Communications.
4 # Parts Copyright 2009 Foundations Bible College.
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it under the
9 # terms of the GNU General Public License as published by the Free Software
10 # Foundation; either version 2 of the License, or (at your option) any later
13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along with
18 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
19 # Suite 330, Boston, MA 02111-1307 USA
25 use Sys::Syslog qw(syslog);
28 use HTML::Template::Pro;
34 use autouse 'C4::Branch' => qw(get_branch_code_from_name);
36 use C4::Labels::Lib 1.000000 qw(get_all_templates get_all_layouts get_all_profiles get_batch_summary get_barcode_types get_label_types get_column_names get_table_names SELECT);
37 use C4::Labels::Layout 1.000000;
38 use C4::Labels::Template 1.000000;
39 use C4::Labels::Profile 1.000000;
40 use C4::Labels::Batch 1.000000;
43 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
45 template_name => "labels/label-manage.tmpl",
49 flagsrequired => { catalogue => 1 },
56 my $display_columns = { layout => [ #db column => display column
57 {layout_id => 'Layout ID'},
58 {layout_name => 'Layout'},
59 {barcode_type => 'Barcode Type'},
60 {printing_type => 'Print Type'},
61 {format_string => 'Fields to Print'},
62 {select => {label => 'Select', value => 'layout_id'}},
64 template => [ {template_id => 'Template ID'},
65 {template_code => 'Template Name'},
66 {template_desc => 'Description'},
67 {select => {label => 'Select', value => 'template_id'}},
69 profile => [ {profile_id => 'Profile ID'},
70 {printer_name => 'Printer Name'},
71 {paper_bin => 'Paper Bin'},
72 {_template_code => 'Template Name'}, # this display column does not have a corrisponding db column in the profile table, hence the underscore
73 {select => {label => 'Select', value => 'profile_id'}},
75 batch => [ {batch_id => 'Batch ID'},
76 {_item_count => 'Item Count'},
77 {select => {label => 'Select', value => 'batch_id'}},
81 my $label_element = $cgi->param('label_element') || $ARGV[0];
82 my $op = $cgi->param('op') || $ARGV[1] || '';
83 my $element_id = $cgi->param('element_id') || $ARGV[2] || '';
84 my $branch_code = ($label_element eq 'batch' ? get_branch_code_from_name($template->param('LoginBranchname')) : '');
92 my ($row_index, $col_index) = (0,0);
93 my $cols = 0; # number of columns to wrap on
96 foreach my $db_column (@$headers) {
97 my @key = keys %$db_column;
98 push (@db_columns, $key[0]);
99 $$fields[$col_index] = {select_field => 0, field_name => ($key[0]), field_label => $db_column->{$key[0]}};
103 $$table[$row_index] = {header_fields => $fields};
105 $field_count *= scalar(@$data); # total fields to be displayed in the table
110 foreach my $db_row (@$data) {
113 foreach my $db_column (@db_columns) {
114 if (grep {$db_column eq $_} keys %$db_row) {
115 $element_id = $db_row->{$db_column} if $db_column =~ m/id/;
116 $$fields[$col_index] = {select_field => 0, field_name => ($db_column . "_tbl"), field_value => $db_row->{$db_column}};
120 elsif ($db_column =~ m/^_((.*)_(.*$))/) { # this a special case
121 my $table_name = get_table_names($2);
122 my $record_set = SELECT($1, @$table_name[0], $2 . "_id = " . $db_row->{$2 . "_id"});
123 $$fields[$col_index] = {select_field => 0, field_name => ($db_column . "_tbl"), field_value => $$record_set[0]{$1}};
128 $$fields[$col_index] = {select_field => 1, field_name => 'select', field_value => $element_id};
129 $$table[$row_index] = {text_fields => $fields};
137 if ($op eq 'delete') {
138 given ($label_element) {
139 when 'layout' {$error = C4::Labels::Layout::delete(layout_id => $element_id); last;}
140 when 'template' {$error = C4::Labels::Template::delete(template_id => $element_id); last;}
141 when 'profile' {$error = C4::Labels::Profile::delete(profile_id => $element_id); last;}
142 when 'batch' {$error = C4::Labels::Batch::delete(batch_id => $element_id, branch_code => $branch_code); last;}
143 default {} # FIXME: Some error trapping code
145 # FIXME: this does not allow us to process any errors
146 # print $cgi->redirect("label-manage.pl?label_element=$label_element");
150 given ($label_element) {
151 when 'layout' {$db_rows = get_all_layouts();}
152 when 'template' {$db_rows = get_all_templates();}
153 when 'profile' {$db_rows = get_all_profiles();}
154 when 'batch' {$db_rows = get_batch_summary(filter => "branch_code=\'$branch_code\'");}
155 default {} # FIXME: Some error trapping code
158 my $table = _build_table($display_columns->{$label_element}, $db_rows);
160 $template->param(error => $error) if ($error ne 0);
161 $template->param(print => 1) if ($label_element eq 'batch');
164 element_id => $element_id,
165 table_loop => $table,
166 label_element => $label_element,
167 label_element_title => ($label_element eq 'layout' ? 'Layouts' :
168 $label_element eq 'template' ? 'Templates' :
169 $label_element eq 'profile' ? 'Profiles' :
170 $label_element eq 'batch' ? 'Batches' :
175 output_html_with_http_headers $cgi, $cookie, $template->output;