1 package C4::Creators::Layout;
6 use autouse 'Data::Dumper' => qw(Dumper);
10 use C4::Creators::PDF;
15 # FIXME: Consider this style parameter verification instead...
19 # if (exists $default{$lc})
20 # { $default{$lc} = $param{$_};
23 # { print STDERR "Unknown parameter $_ , not used \n";
29 my @valtmpl_id_params = (
41 'layout_xml', # FIXME: all layouts should be stored in xml format to greatly simplify handling -chris_n
47 my %given_params = @_;
48 foreach my $key (keys %given_params) {
49 if (!(grep m/$key/, @valtmpl_id_params)) {
50 warn sprintf('(Multiple parameters) Unrecognized parameter type of "%s".', $key);
56 if (!(grep m/$_/, @valtmpl_id_params)) {
57 warn sprintf('(Single parameter) Unrecognized parameter type of "%s".', $_);
64 use constant PRESET_FIELDS => [qw(title author isbn issn itemtype barcode itemcallnumber)];
68 if (_check_params(@_) eq 1) {
71 my $type = ref($invocant) || $invocant;
72 if (grep {$_ eq 'Labels'} @_) {
77 barcode_type => 'CODE39',
78 printing_type => 'BAR',
79 layout_name => 'DEFAULT',
86 format_string => join(', ', @{ PRESET_FIELDS() }),
90 elsif (grep {$_ eq 'Patroncards'} @_) {
92 layout_xml => '<opt>Default Layout</opt>',
101 my $invocant = shift;
103 my $type = ref($invocant) || $invocant;
104 my $query = "SELECT * FROM creator_layouts WHERE layout_id = ? AND creator = ?";
105 my $sth = C4::Context->dbh->prepare($query);
106 $sth->execute($opts{'layout_id'}, $opts{'creator'});
108 warn sprintf('Database returned the following error: %s', $sth->errstr);
111 my $self = $sth->fetchrow_hashref;
112 bless ($self, $type);
122 $self = shift; # check to see if this is a method call
123 $call_type = 'C4::Labels::Layout->delete';
124 push @params, $self->{'layout_id'}, $self->{'creator'};
129 $call_type = $class . '::delete';
130 push @params, $opts{'layout_id'}, $opts{'creator'};
132 if (scalar(@params) < 2) { # If there is no layout id or creator type then we cannot delete it
133 warn sprintf('%s : Cannot delete layout as the profile id is invalid or non-existent.', $call_type) if !$params[0];
134 warn sprintf('%s : Cannot delete layout as the creator type is invalid or non-existent.', $call_type) if !$params[1];
137 my $query = "DELETE FROM creator_layouts WHERE layout_id = ? AND creator = ?";
138 my $sth = C4::Context->dbh->prepare($query);
139 $sth->execute(@params);
141 warn sprintf('Database returned the following error on attempted DELETE: %s', $sth->errstr);
148 if ($self->{'layout_id'}) { # if we have an id, the record exists and needs UPDATE
150 my $query = "UPDATE creator_layouts SET ";
151 foreach my $key (keys %{$self}) {
152 next if ($key eq 'layout_id') || ($key eq 'creator');
153 push (@params, $self->{$key});
154 $query .= "$key=?, ";
156 $query = substr($query, 0, (length($query)-2));
157 $query .= " WHERE layout_id=? AND creator = ?;";
158 push (@params, $self->{'layout_id'}, $self->{'creator'});
159 my $sth = C4::Context->dbh->prepare($query);
160 #local $sth->{TraceLevel} = "3"; # enable DBI trace and set level; outputs to STDERR
161 $sth->execute(@params);
163 warn sprintf('Database returned the following error: %s', $sth->errstr);
166 return $self->{'layout_id'};
168 else { # otherwise create a new record
170 my $query = "INSERT INTO creator_layouts (";
171 foreach my $key (keys %{$self}) {
172 push (@params, $self->{$key});
175 $query = substr($query, 0, (length($query)-2));
176 $query .= ") VALUES (";
177 for (my $i=1; $i<=(scalar keys %$self); $i++) {
180 $query = substr($query, 0, (length($query)-1));
182 my $sth = C4::Context->dbh->prepare($query);
183 $sth->execute(@params);
185 warn sprintf('Database returned the following error: %s', $sth->errstr);
188 my $sth1 = C4::Context->dbh->prepare("SELECT MAX(layout_id) FROM creator_layouts;");
190 my $id = $sth1->fetchrow_array;
191 $self->{'layout_id'} = $id;
198 if (_check_params(@_) eq 1) {
202 if (exists($self->{$attr})) {
203 return $self->{$attr};
213 if (_check_params(@_) eq 1) {
217 foreach my $attrib (keys(%attrs)) {
218 $self->{$attrib} = $attrs{$attrib};
223 sub get_text_wrap_cols {
229 my $textlimit = $params{'label_width'} - (( 3 * $params{'left_text_margin'} ) || 13.5 );
231 while ($strwidth < $textlimit) {
232 $string .= '8'; # using '8' as filling char instead of '0'
234 $strwidth = C4::Creators::PDF->StrWidth( $string, $self->{'font'}, $self->{'font_size'} );
244 C4::Labels::Layout -A class for creating and manipulating layout objects in Koha
248 This module provides methods for creating, retrieving, and otherwise manipulating label layout objects used by Koha to create and export labels.
254 Invoking the I<new> method constructs a new layout object containing the default values for a layout.
255 The following parameters are optionally accepted as key => value pairs:
257 C<barcode_type> Defines the barcode type to be used on labels. NOTE: At present only the following barcode types are supported in the label creator code:
265 CODE39MOD = Code 3 of 9 with modulo 43 checksum
268 CODE39MOD10 = Code 3 of 9 with modulo 10 checksum
271 COOP2OF5 = A variant of 2 of 5 barcode based on NEC's "Process 8000" code
274 INDUSTRIAL2OF5 = The standard 2 of 5 barcode (a binary level bar code developed by Identicon Corp. and Computer Identics Corp. in 1970)
278 C<printing_type> Defines the general layout to be used on labels. NOTE: At present there are only five printing types supported in the label creator code:
283 BIB = Only the bibliographic data is printed
286 BARBIB = Barcode proceeds bibliographic data
289 BIBBAR = Bibliographic data proceeds barcode
292 ALT = Barcode and bibliographic data are printed on alternating labels
295 BAR = Only the barcode is printed
299 C<layout_name> The descriptive name for this layout.
300 C<guidebox> Setting this to '1' will result in a guide box being drawn around the labels marking the edge of each label
301 C<font> Defines the type of font to be used on labels. NOTE: The following fonts are available by default on most systems:
315 TBI = Times Bold Italic
324 CO = Courier Oblique (Italic)
327 CBO = Courier Bold Oblique
336 HBO = Helvetical Bold Oblique
340 C<font_size> Defines the size of the font in postscript points to be used on labels
341 C<callnum_split> Setting this to '1' will enable call number splitting on labels
342 C<text_justify> Defines the text justification to be used on labels. NOTE: The following justification styles are currently supported by label creator code:
357 C<format_string> Defines what fields will be printed and in what order they will be printed on labels. These include any of the data fields that may be mapped
358 to your MARC frameworks. Specify MARC subfields as a 4-character tag-subfield string: ie. 254a Enclose a whitespace-separated list of fields
359 to concatenate on one line in double quotes. ie. "099a 099b" or "itemcallnumber barcode" Static text strings may be entered in single-quotes:
360 ie. 'Some static text here.'
363 C<my $layout = Layout->new(); # Creates and returns a new layout object>
365 C<my $layout = C4::Labels::Layout->new(barcode_type => 'CODE39', printing_type => 'BIBBAR', font => 'C', font_size => 6); # Creates and returns a new layout object using
366 the supplied values to override the defaults>
368 B<NOTE:> This layout is I<not> written to the database until save() is invoked. You have been warned!
370 =head2 retrieve(layout_id => layout_id)
372 Invoking the I<retrieve> method constructs a new layout object containing the current values for layout_id. The method returns a new object upon success and 1 upon failure.
373 Errors are logged to the Apache log.
376 C<my $layout = Layout->retrieve(layout_id => 1); # Retrieves layout record 1 and returns an object containing the record>
380 Invoking the delete method attempts to delete the layout from the database. The method returns 0 upon success and -1 upon failure. Errors are logged to the Apache log.
381 NOTE: This method may also be called as a function and passed a key/value pair simply deleteing that template from the database. See the example below.
384 C<my $exitstat = $layout->delete(); # to delete the record behind the $layout object>
385 C<my $exitstat = Layout->delete(layout_id => 1); # to delete layout record 1>
389 Invoking the I<save> method attempts to insert the layout into the database if the layout is new and update the existing layout record if the layout exists.
390 The method returns the new record id upon success and -1 upon failure (This avoids conflicting with a record id of 1). Errors are logged to the Apache log.
393 C<my $exitstat = $layout->save(); # to save the record behind the $layout object>
395 =head2 get_attr($attribute)
397 Invoking the I<get_attr> method will return the value of the requested attribute or -1 on errors.
400 C<my $value = $layout->get_attr($attribute);>
402 =head2 set_attr(attribute => value, attribute_2 => value)
404 Invoking the I<set_attr> method will set the value of the supplied attributes to the supplied values. The method accepts key/value pairs separated by
408 C<$layout->set_attr(attribute => value);>
410 =head2 get_text_wrap_cols()
412 Invoking the I<get_text_wrap_cols> method will return the number of columns that can be printed on the label before wrapping to the next line.
415 C<my $text_wrap_cols = $layout->get_text_wrap_cols();>
419 Chris Nighswonger <cnighswonger AT foundations DOT edu>
423 Copyright 2009 Foundations Bible College.
427 This file is part of Koha.
429 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
430 Foundation; either version 2 of the License, or (at your option) any later version.
432 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,
433 Fifth Floor, Boston, MA 02110-1301 USA.
435 =head1 DISCLAIMER OF WARRANTY
437 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
438 A PARTICULAR PURPOSE. See the GNU General Public License for more details.