1 package Koha::Template::Plugin::Branches;
3 # Copyright ByWater Solutions 2012
4 # Copyright BibLibre 2014
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
24 use base qw( Template::Plugin );
30 my ( $self, $branchcode ) = @_;
32 my $query = "SELECT branchname FROM branches WHERE branchcode = ?";
33 my $sth = C4::Context->dbh->prepare($query);
34 $sth->execute($branchcode);
35 my $b = $sth->fetchrow_hashref();
36 return $b ? $b->{'branchname'} : q{};
39 sub GetLoggedInBranchcode {
42 return C4::Context->userenv ?
43 C4::Context->userenv->{'branch'} :
48 my ( $self, $branchcode ) = @_;
50 my $query = "SELECT branchurl FROM branches WHERE branchcode = ?";
51 my $sth = C4::Context->dbh->prepare($query);
52 $sth->execute($branchcode);
53 my $b = $sth->fetchrow_hashref();
54 return $b->{branchurl};
58 my ( $self, $params ) = @_;
59 my $selected = $params->{selected};
60 my $dbh = C4::Context->dbh;
63 SELECT branchcode, branchname
66 if ( C4::Branch::onlymine
67 and C4::Context->userenv
68 and C4::Context->userenv->{branch} )
70 $query .= q| WHERE branchcode = ? |;
71 push @params, C4::Context->userenv->{branch};
73 $query .= q| ORDER BY branchname|;
74 my $branches = $dbh->selectall_arrayref( $query, { Slice => {} }, @params );
77 for my $branch ( @$branches ) {
78 if ( $branch->{branchcode} eq $selected ) {
79 $branch->{selected} = 1;