|
Lines 1-218
Link Here
|
| 1 |
#!/usr/bin/perl |
|
|
| 2 |
|
| 3 |
|
| 4 |
# Copyright 2000-2002 Katipo Communications |
| 5 |
# |
| 6 |
# This file is part of Koha. |
| 7 |
# |
| 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. |
| 12 |
# |
| 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. |
| 17 |
# |
| 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>. |
| 20 |
|
| 21 |
use strict; |
| 22 |
use C4::Auth; |
| 23 |
use CGI qw ( -utf8 ); |
| 24 |
use C4::Context; |
| 25 |
use C4::Search; |
| 26 |
use C4::Output; |
| 27 |
use C4::Koha; |
| 28 |
use C4::Members; |
| 29 |
|
| 30 |
use Koha::Patron::Categories; |
| 31 |
|
| 32 |
=head1 NAME |
| 33 |
|
| 34 |
plugin that shows a table with issues for categories and borrower |
| 35 |
|
| 36 |
=head1 DESCRIPTION |
| 37 |
|
| 38 |
this result is quite complex to build... |
| 39 |
the 2D array contains : |
| 40 |
* item types on lines |
| 41 |
* borrowers types on rows |
| 42 |
|
| 43 |
If no issues are done, the array must be filled by 0 anyway. |
| 44 |
So, the script works as this : |
| 45 |
1- parse the itemtype table to get itemtype descriptions and set itemtype total to 0 |
| 46 |
2- for each borrower category : |
| 47 |
** create an array with total = 0 for each itemtype defined in 1 |
| 48 |
** calculate the total for each itemtype (SQL request) |
| 49 |
The big hash has the following structure : |
| 50 |
$itemtypes{itemtype} |
| 51 |
->{results} |
| 52 |
->{borrowercategorycode} => the total of issues for each cell of the table. |
| 53 |
->{total} => the total for the itemtype |
| 54 |
->{description} => the itemtype description |
| 55 |
|
| 56 |
the borrowertype hash contains description and total for each borrowercategory. |
| 57 |
|
| 58 |
the hashes are then translated to hash / arrays to be returned to manager.pl & send to the template |
| 59 |
|
| 60 |
=over2 |
| 61 |
|
| 62 |
=cut |
| 63 |
|
| 64 |
sub set_parameters { |
| 65 |
my ($template) = @_; |
| 66 |
|
| 67 |
my $patron_categories = Koha::Patron::Categories->search_limited({}, {order_by => ['categorycode']}); |
| 68 |
$template->param( patron_categories => $patron_categories ); |
| 69 |
return $template; |
| 70 |
} |
| 71 |
|
| 72 |
sub calculate { |
| 73 |
my ($parameters) = @_; |
| 74 |
my @results =(); |
| 75 |
# extract parameters |
| 76 |
my $borrower_category = @$parameters[0]; |
| 77 |
my $branch = @$parameters[1]; |
| 78 |
my $dbh = C4::Context->dbh; |
| 79 |
# build the SQL query & execute it |
| 80 |
|
| 81 |
# 1st, loop every itemtypes. |
| 82 |
my $sth = $dbh->prepare("select itemtype,description from itemtypes"); |
| 83 |
$sth->execute; |
| 84 |
my %itemtypes; |
| 85 |
while (my ($itemtype,$description) = $sth->fetchrow) { |
| 86 |
$itemtypes{$itemtype}->{description} = $description; |
| 87 |
$itemtypes{$itemtype}->{total} = 0; |
| 88 |
} |
| 89 |
# now, parse each category. Before filling the result array, fill it with 0 to have every itemtype column. |
| 90 |
my $strsth="SELECT itemtype, count( * ) |
| 91 |
FROM issues, borrowers, biblioitems, items |
| 92 |
WHERE issues.borrowernumber = borrowers.borrowernumber |
| 93 |
AND items.itemnumber = issues.itemnumber |
| 94 |
AND biblioitems.biblionumber = items.biblionumber |
| 95 |
AND borrowers.categorycode = ?"; |
| 96 |
$strsth.= " AND borrowers.branchcode = ".$dbh->quote($branch) if ($branch); |
| 97 |
$strsth .= " GROUP BY biblioitems.itemtype"; |
| 98 |
my $sth = $dbh->prepare($strsth); |
| 99 |
my $sthcategories = $dbh->prepare("select categorycode,description from categories"); |
| 100 |
$sthcategories->execute; |
| 101 |
my %borrowertype; |
| 102 |
my @categorycodeloop; |
| 103 |
my $categorycode; |
| 104 |
my $description; |
| 105 |
my $borrower_categorycode =0; |
| 106 |
my @mainloop; |
| 107 |
my @itemtypeloop; |
| 108 |
my @loopborrowertype; |
| 109 |
my @loopborrowertotal; |
| 110 |
my %globalline; |
| 111 |
my $hilighted=-1; |
| 112 |
my $grantotal =0; |
| 113 |
#If no Borrower-category selected.... |
| 114 |
# Print all |
| 115 |
if (!$borrower_category) { |
| 116 |
while ( ($categorycode,$description) = $sthcategories->fetchrow) { |
| 117 |
$borrowertype{$categorycode}->{description} = $description; |
| 118 |
$borrowertype{$categorycode}->{total} = 0; |
| 119 |
my %categorycode; |
| 120 |
$categorycode{categorycode} = $description; |
| 121 |
push @categorycodeloop,\%categorycode; |
| 122 |
foreach my $itemtype (keys %itemtypes) { |
| 123 |
$itemtypes{$itemtype}->{results}->{$categorycode} = 0; |
| 124 |
} |
| 125 |
$sth->execute($categorycode); |
| 126 |
while (my ($itemtype, $total) = $sth->fetchrow) { |
| 127 |
$itemtypes{$itemtype}->{results}->{$categorycode} = $total; |
| 128 |
$borrowertype{$categorycode}->{total} += $total; |
| 129 |
$itemtypes{$itemtype}->{total} += $total; |
| 130 |
$grantotal += $total; |
| 131 |
} |
| 132 |
} |
| 133 |
# build the result |
| 134 |
foreach my $itemtype (keys %itemtypes) { |
| 135 |
my @loopitemtype; |
| 136 |
$sthcategories->execute; |
| 137 |
while (($categorycode,$description) = $sthcategories->fetchrow ) { |
| 138 |
my %cell; |
| 139 |
$cell{issues} = $itemtypes{$itemtype}->{results}->{$categorycode}; |
| 140 |
#printf stderr "%s ",$categorycode; |
| 141 |
push @loopitemtype,\%cell; |
| 142 |
} |
| 143 |
#printf stderr "\n"; |
| 144 |
my %line; |
| 145 |
$line{loopitemtype} = \@loopitemtype; |
| 146 |
if ($itemtypes{$itemtype}->{description}) { |
| 147 |
$line{itemtype} = $itemtypes{$itemtype}->{description}; |
| 148 |
} else { |
| 149 |
$line{itemtype} = "$itemtype (no entry in itemtype table)"; |
| 150 |
} |
| 151 |
$line{hilighted} = 1 if $hilighted eq 1; |
| 152 |
$line{totalitemtype} = $itemtypes{$itemtype}->{total}; |
| 153 |
$hilighted = -$hilighted; |
| 154 |
push @loopborrowertype, \%line; |
| 155 |
} |
| 156 |
$sthcategories->execute; |
| 157 |
while (($categorycode,$description) = $sthcategories->fetchrow ) { |
| 158 |
my %line; |
| 159 |
$line{issues} = $borrowertype{$categorycode}->{total}; |
| 160 |
push @loopborrowertotal, \%line; |
| 161 |
} |
| 162 |
} else { |
| 163 |
# A Borrower_category has been selected |
| 164 |
# extracting corresponding data |
| 165 |
$borrowertype{$categorycode}->{description} = $borrower_category; |
| 166 |
$borrowertype{$categorycode}->{total} = 0; |
| 167 |
while (($categorycode,$description) = $sthcategories->fetchrow) { |
| 168 |
if ($description =~ /$borrower_category/ ) { |
| 169 |
$borrower_categorycode = $categorycode; |
| 170 |
my %cc; |
| 171 |
$cc{categorycode} = $description; |
| 172 |
push @categorycodeloop,\%cc; |
| 173 |
foreach my $itemtype (keys %itemtypes) { |
| 174 |
$itemtypes{$itemtype}->{results}->{$categorycode} = 0; |
| 175 |
} |
| 176 |
$sth->execute($categorycode); |
| 177 |
while (my ($itemtype, $total) = $sth->fetchrow) { |
| 178 |
$itemtypes{$itemtype}->{results}->{$categorycode} = $total; |
| 179 |
$borrowertype{$categorycode}->{total} += $total; |
| 180 |
$itemtypes{$itemtype}->{total} += $total; |
| 181 |
$grantotal +=$total; |
| 182 |
} |
| 183 |
} |
| 184 |
} |
| 185 |
# build the result |
| 186 |
foreach my $itemtype (keys %itemtypes) { |
| 187 |
my @loopitemtype; |
| 188 |
my %cell; |
| 189 |
$cell{issues}=$itemtypes{$itemtype}->{results}->{$borrower_categorycode}; |
| 190 |
push @loopitemtype, \%cell; |
| 191 |
my %line; |
| 192 |
$line{loopitemtype} = \@loopitemtype; |
| 193 |
if ($itemtypes{$itemtype}->{description}) { |
| 194 |
$line{itemtype} = $itemtypes{$itemtype}->{description}; |
| 195 |
} else { |
| 196 |
$line{itemtype} = "$itemtype (no entry in itemtype table)"; |
| 197 |
} |
| 198 |
$line{hilighted} = 1 if $hilighted eq 1; |
| 199 |
$line{totalitemtype} = $itemtypes{$itemtype}->{total}; |
| 200 |
$hilighted = -$hilighted; |
| 201 |
push @loopborrowertype, \%line; |
| 202 |
} |
| 203 |
my %cell; |
| 204 |
$cell{issues} = $borrowertype{$borrower_categorycode}->{total}; |
| 205 |
push @loopborrowertotal, \%cell; |
| 206 |
} |
| 207 |
# the header of the table |
| 208 |
$globalline{loopborrowertype} = \@loopborrowertype; |
| 209 |
# the core of the table |
| 210 |
$globalline{categorycodeloop} = \@categorycodeloop; |
| 211 |
# the foot (totals by borrower type) |
| 212 |
$globalline{loopborrowertotal} = \@loopborrowertotal; |
| 213 |
$globalline{grantotal}= $grantotal; |
| 214 |
push @mainloop,\%globalline; |
| 215 |
return \@mainloop; |
| 216 |
} |
| 217 |
|
| 218 |
1; |
| 219 |
- |