Bug 11945: SQL syntax error in delete_expired_opac_registrations.pl
[koha.git] / C4 / ItemType.pm
blobad253a77419f61a3b99b07b54846fe8470e374cb
1 package C4::ItemType;
3 # Copyright Liblime 2009
4 # Parts Copyright Tamil 2011
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
11 # version.
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
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21 use strict;
22 use warnings;
23 use C4::Context;
25 our $AUTOLOAD;
30 =head1 NAME
32 C4::ItemType - objects from the itemtypes table
34 =head1 SYNOPSIS
36 use C4::ItemType;
37 my @itemtypes = C4::ItemType->all;
38 print join("\n", map { $_->description } @itemtypes), "\n";
40 =head1 DESCRIPTION
42 Objects of this class represent a row in the C<itemtypes> table.
44 Currently, the bare minimum for using this as a read-only data source has
45 been implemented. The API was designed to make it easy to transition to
46 an ORM later on.
48 =head1 API
50 =head2 Class Methods
52 =cut
54 =head3 C4::ItemType->new(\%opts)
56 Given a hashref, a new (in-memory) C4::ItemType object will be instantiated.
57 The database is not touched.
59 =cut
61 sub new {
62 my ($class, $opts) = @_;
63 bless $opts => $class;
69 =head3 C4::ItemType->all
71 This returns all the itemtypes as objects. By default they're ordered by
72 C<description>.
74 =cut
76 sub all {
77 my ($class) = @_;
78 my $dbh = C4::Context->dbh;
80 my @itypes;
81 for ( @{$dbh->selectall_arrayref(
82 "SELECT * FROM itemtypes ORDER BY description", { Slice => {} })} )
84 utf8::encode($_->{description});
85 push @itypes, $class->new($_);
87 return @itypes;
93 =head3 C4::ItemType->get
95 Return the itemtype indicated by the itemtype given as argument, as
96 an object.
98 =cut
100 sub get {
101 my ($class, $itemtype) = @_;
102 my $dbh = C4::Context->dbh;
104 my $data = $dbh->selectrow_hashref(
105 "SELECT * FROM itemtypes WHERE itemtype = ?", undef, $itemtype
107 if ( $data->{description} ) {
108 utf8::encode($data->{description});
110 return $class->new($data);
116 =head2 Object Methods
118 These are read-only accessors for attributes of a C4::ItemType object.
120 =head3 $itemtype->itemtype
122 =cut
124 =head3 $itemtype->description
126 =cut
128 =head3 $itemtype->renewalsallowed
130 =cut
132 =head3 $itemtype->rentalcharge
134 =cut
136 =head3 $itemtype->notforloan
138 =cut
140 =head3 $itemtype->imageurl
142 =cut
144 =head3 $itemtype->checkinmsg
146 =cut
148 =head3 $itemtype->summary
150 =cut
152 sub AUTOLOAD {
153 my $self = shift;
154 my $attr = $AUTOLOAD;
155 $attr =~ s/.*://;
156 if (exists $self->{$attr}) {
157 return $self->{$attr};
158 } else {
159 return undef;
163 sub DESTROY { }
167 # ack itemtypes | grep '\.pm' | awk '{ print $1 }' | sed 's/:.*$//' | sort | uniq | sed -e 's,/,::,g' -e 's/\.pm//' -e 's/^/L<C4::/' -e 's/$/>,/'
169 =head1 SEE ALSO
171 The following modules make reference to the C<itemtypes> table.
173 L<C4::Biblio>,
174 L<C4::Circulation>,
175 L<C4::Context>,
176 L<C4::Items>,
177 L<C4::Koha>,
178 L<C4::Labels>,
179 L<C4::Overdues>,
180 L<C4::Reserves>,
181 L<C4::Search>,
182 L<C4::VirtualShelves::Page>,
183 L<C4::VirtualShelves>,
184 L<C4::XSLT>
188 =head1 AUTHOR
190 John Beppu <john.beppu@liblime.com>
192 =cut