4 # Copyright 2000-2002 Katipo Communications
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 with
18 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
19 # Suite 330, Boston, MA 02111-1307 USA
25 use HTML
::Template
::Pro
;
29 use C4
::Branch
; # GetBranches
36 my $dbh = C4
::Context
->dbh;
37 my $branches=GetBranches
();
41 push @select_branch,"";
42 $select_branches{""} = "";
43 foreach my $branch (keys %$branches) {
44 push @select_branch, $branch;
45 $select_branches{$branch} = $branches->{$branch}->{'branchname'};
47 my $CGIbranch=CGI
::scrolling_list
( -name
=> 'value',
49 -values => \
@select_branch,
50 -labels
=> \
%select_branches,
53 $template->param(CGIbranch
=> $CGIbranch);
57 my ($parameters) = @_;
59 my $branch = @
$parameters[0];
60 my $dbh = C4
::Context
->dbh;
63 $sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems, items
64 where biblioitems.itemtype=itemtypes.itemtype
65 and items.biblioitemnumber=biblioitems.biblioitemnumber
66 and items.holdingbranch=?
67 group by biblioitems.itemtype");
68 $sth->execute($branch);
70 $sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems,items where biblioitems.itemtype=itemtypes.itemtype
71 and biblioitems.biblioitemnumber = items.biblioitemnumber group by biblioitems.itemtype");
74 my ($description,$biblioitems,$total);
77 while (($description,$biblioitems,$total) = $sth->fetchrow) {
84 $line{itemtype
} = $description;
85 $line{count
} = $total;
92 $globalline{loopitemtype
} = \
@results;
93 $globalline{total
} = $grantotal;
94 $globalline{branch
} = $branch;
95 push @mainloop,\
%globalline;