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);
27 use HTML::Template::Pro;
34 use C4::Labels::Lib 1.000000 qw(get_all_templates get_all_layouts get_all_profiles get_barcode_types get_label_types get_column_names get_table_names SELECT);
35 use C4::Labels::Layout 1.000000;
36 use C4::Labels::Template 1.000000;
37 use C4::Labels::Profile 1.000000;
40 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
42 template_name => "labels/label-manage.tmpl",
46 flagsrequired => { catalogue => 1 },
53 my $column_names = [];
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'},
64 template => [ {template_id => 'Template ID'},
65 {template_code => 'Template Name'},
66 {template_desc => 'Description'},
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
77 my $label_element = $cgi->param('label_element') || $ARGV[0];
78 my $op = $cgi->param('op') || $ARGV[1] || '';
79 my $element_id = $cgi->param('element_id') || $ARGV[2] || '';
88 my ($row_index, $col_index) = (0,0);
89 my $cols = 0; # number of columns to wrap on
92 foreach my $db_column (@$headers) {
93 my @key = keys %$db_column;
94 push (@db_columns, $key[0]);
95 $$fields[$col_index] = {select_field => 0, field_name => ($key[0]), field_label => $db_column->{$key[0]}};
99 $$table[$row_index] = {header_fields => $fields};
101 $field_count *= scalar(@$data); # total fields to be displayed in the table
106 foreach my $db_row (@$data) {
109 foreach my $db_column (@db_columns) {
110 if ($db_column =~ m/^_((.*)_(.*$))/) {
111 my $table_name = get_table_names($2);
112 my $record_set = SELECT($1, @$table_name[0], $2 . "_id = " . $db_row->{$2 . "_id"});
113 $db_row->{$db_column} = $$record_set[0]{$1};
115 if (grep {$db_column eq $_} keys %$db_row) {
116 $element_id = $db_row->{$db_column} if $db_column =~ m/id/;
117 $$fields[$col_index] = {select_field => 0, field_name => ($db_column . "_tbl"), field_value => $db_row->{$db_column}};
121 $$fields[$col_index] = {select_field => 1, field_name => 'select', field_value => $element_id};
122 $$table[$row_index] = {text_fields => $fields};
130 if ($op eq 'delete') {
131 $error = C4::Labels::Layout::delete(layout_id => $element_id) if $label_element eq 'layout';
132 $error = C4::Labels::Template::delete(template_id => $element_id) if $label_element eq 'template';
133 $error = C4::Labels::Profile::delete(profile_id => $element_id) if $label_element eq 'profile';
136 $table_names = get_table_names($label_element);
137 $column_names = get_column_names(@$table_names[0]);
138 $db_rows = get_all_layouts() if $label_element eq 'layout';
139 $db_rows = get_all_templates() if $label_element eq 'template';
140 $db_rows = get_all_profiles() if $label_element eq 'profile';
142 my $table = _build_table($display_columns->{$label_element}, $db_rows, $label_element);
144 $template->param(error => $error) if ($error ne 0);
147 element_id => $element_id,
148 table_loop => $table,
149 label_element => $label_element,
150 label_element_title => ($label_element eq 'layout' ? 'Layouts' :
151 $label_element eq 'template' ? 'Templates' :
152 $label_element eq 'profile' ? 'Profiles' :
157 output_html_with_http_headers $cgi, $cookie, $template->output;