3 # Copyright 2009 Liblime
4 # Parts Copyright 2011 Tamil
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
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
32 C4::Category - objects from the categories table
37 my @categories = C4::Category->all;
38 print join("\n", map { $_->description } @categories), "\n";
42 Objects of this class represent a row in the C<categories> 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
54 =head3 C4::Category->new(\%opts)
56 Given a hashref, a new (in-memory) C4::Category object will be instantiated.
57 The database is not touched.
62 my ($class, $opts) = @_;
63 bless $opts => $class;
69 =head3 C4::Category->all
71 This returns all the categories as objects. By default they're ordered by
78 my $branch_limit = C4
::Context
->userenv ? C4
::Context
->userenv->{"branch"} : "";
79 my $dbh = C4
::Context
->dbh;
80 # The categories table is small enough for
81 # `SELECT *` to be harmless.
82 my $query = "SELECT categories.* FROM categories";
84 LEFT JOIN categories_branches ON categories_branches
.categorycode
= categories
.categorycode
85 WHERE categories_branches
.branchcode
= ? OR categories_branches
.branchcode IS NULL
87 $query .= " ORDER BY description";
88 return map { $class->new($_) } @
{
89 $dbh->selectall_arrayref(
92 $branch_limit ?
$branch_limit : ()
100 =head2 Object Methods
102 These are read-only accessors for attributes of a C4::Category object.
104 =head3 $category->categorycode
108 =head3 $category->description
112 =head3 $category->enrolmentperiod
116 =head3 $category->upperagelimit
120 =head3 $category->dateofbirthrequired
124 =head3 $category->finetype
128 =head3 $category->bulk
132 =head3 $category->enrolmentfee
136 =head3 $category->overduenoticerequired
140 =head3 $category->issuelimit
144 =head3 $category->reservefee
148 =head3 $category->category_type
154 my $attr = $AUTOLOAD;
156 if (exists $self->{$attr}) {
157 return $self->{$attr};
170 The following modules make reference to the C<categories> table.
172 L<C4::Members>, L<C4::Overdues>, L<C4::Reserves>
177 John Beppu <john.beppu@liblime.com>