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 under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
30 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
32 template_name => "serials/acqui-search.tmpl",
36 flagsrequired => { serials => 1 },
42 my $dbh = C4::Context->dbh;
45 "Select flags, branchcode from borrowers where borrowernumber = ?");
46 $sthtemp->execute($loggedinuser);
47 my ( $flags, $homebranch ) = $sthtemp->fetchrow;
48 my @results = GetBookFunds($homebranch);
49 my $count = scalar(@results);
57 for ( my $i = 0 ; $i < $count ; $i++ ) {
58 my ( $spent, $comtd ) =
59 GetBookFundBreakdown( $results[$i]->{'bookfundid'} );
60 my $avail = $results[$i]->{'budgetamount'} - ( $spent + $comtd );
62 $line{bookfundname} = $results[$i]->{'bookfundname'};
63 $line{budgetamount} = $results[$i]->{'budgetamount'};
64 $line{spent} = sprintf( "%.2f", $spent );
65 $line{comtd} = sprintf( "%.2f", $comtd );
66 $line{avail} = sprintf( "%.2f", $avail );
67 push @loop_budget, \%line;
68 $total += $results[$i]->{'budgetamount'};
75 my @rates = GetCurrencies();
76 my $count = scalar @rates;
78 my @loop_currency = ();
79 for ( my $i = 0 ; $i < $count ; $i++ ) {
81 $line{currency} = $rates[$i]->{'currency'};
82 $line{rate} = $rates[$i]->{'rate'};
83 push @loop_currency, \%line;
86 classlist => $classlist,
88 loop_budget => \@loop_budget,
89 loop_currency => \@loop_currency,
90 total => sprintf( "%.2f", $total ),
91 totspent => sprintf( "%.2f", $totspent ),
92 totcomtd => sprintf( "%.2f", $totcomtd ),
93 totavail => sprintf( "%.2f", $totavail )
96 output_html_with_http_headers $query, $cookie, $template->output;