Bug 23794: (RM follow-up) Make DB update consistent
[koha.git] / opac / opac-browser.pl
blob519472f940339dcff88f5dbfaf7e00cc74de29a5
1 #!/usr/bin/perl
3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
21 =head1 opac-browser.pl
23 TODO :: Description here
25 =cut
27 use Modern::Perl;
29 use C4::Auth;
30 use C4::Context;
31 use C4::Output;
32 use CGI qw ( -utf8 );
33 use C4::Biblio;
35 my $query = new CGI;
37 my $dbh = C4::Context->dbh;
39 # open template
40 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
42 template_name => "opac-browser.tt",
43 query => $query,
44 type => "opac",
45 authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
46 debug => 1,
50 # the level of browser to display
51 my $level = $query->param('level') || 0;
52 my $filter = $query->param('filter');
53 $filter = '' unless defined $filter;
54 $level++; # the level passed is the level of the PREVIOUS list, not the current one. Thus the ++
56 # build this level loop
57 my $sth = $dbh->prepare("SELECT * FROM browser WHERE level=? and classification like ? ORDER BY classification");
58 $sth->execute($level,$filter."%");
59 my @level_loop;
60 my $i=0;
61 while (my $line = $sth->fetchrow_hashref) {
62 $line->{description} =~ s/\((.*)\)//g;
63 push @level_loop,$line;
66 my $have_hierarchy = 0;
68 # now rebuild hierarchy loop
69 $filter =~ s/\.//g;
70 my @hierarchy_loop;
71 if ($filter eq '' and $level == 1) {
72 # we're starting from the top
73 $have_hierarchy = 1 if @level_loop;
74 unless (@level_loop) {
75 $sth->execute(1, "%");
76 while (my $line = $sth->fetchrow_hashref) {
77 $line->{description} =~ s/\((.*)\)//g;
78 push @level_loop,$line;
81 } else {
82 $sth = $dbh->prepare("SELECT * FROM browser where classification=?");
83 for (my $i=1;$i <=length($filter);$i++) {
84 $sth->execute(substr($filter,0,$i));
85 my $line = $sth->fetchrow_hashref;
86 push @hierarchy_loop,$line;
88 $have_hierarchy = 1 if @hierarchy_loop;
91 # mark every third entry in level_loop
92 for (my $i = 0; $i <= $#level_loop; $i++) {
93 $level_loop[$i]->{count3} = 1 if 2 == $i % 3 && $i != $#level_loop;
96 $template->param(
97 LEVEL_LOOP => \@level_loop,
98 HIERARCHY_LOOP => \@hierarchy_loop,
99 have_hierarchy => $have_hierarchy,
102 output_html_with_http_headers $query, $cookie, $template->output, undef, { force_no_caching => 1 };