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
26 use C4::Interface::CGI::Output;
31 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
33 template_name => "serials/acqui-search.tmpl",
37 flagsrequired => { serials => 1 },
43 my $dbh = C4::Context->dbh;
46 "Select flags, branchcode from borrowers where borrowernumber = ?");
47 $sthtemp->execute($loggedinuser);
48 my ( $flags, $homebranch ) = $sthtemp->fetchrow;
49 my @results = GetBookFunds($homebranch);
50 my $count = scalar(@results);
58 for ( my $i = 0 ; $i < $count ; $i++ ) {
59 my ( $spent, $comtd ) =
60 GetBookFundBreakdown( $results[$i]->{'bookfundid'} );
61 my $avail = $results[$i]->{'budgetamount'} - ( $spent + $comtd );
63 $line{bookfundname} = $results[$i]->{'bookfundname'};
64 $line{budgetamount} = $results[$i]->{'budgetamount'};
65 $line{spent} = sprintf( "%.2f", $spent );
66 $line{comtd} = sprintf( "%.2f", $comtd );
67 $line{avail} = sprintf( "%.2f", $avail );
68 push @loop_budget, \%line;
69 $total += $results[$i]->{'budgetamount'};
76 my @rates = GetCurrencies();
77 my $count = scalar @rates;
79 my @loop_currency = ();
80 for ( my $i = 0 ; $i < $count ; $i++ ) {
82 $line{currency} = $rates[$i]->{'currency'};
83 $line{rate} = $rates[$i]->{'rate'};
84 push @loop_currency, \%line;
87 classlist => $classlist,
89 loop_budget => \@loop_budget,
90 loop_currency => \@loop_currency,
91 total => sprintf( "%.2f", $total ),
92 totspent => sprintf( "%.2f", $totspent ),
93 totcomtd => sprintf( "%.2f", $totcomtd ),
94 totavail => sprintf( "%.2f", $totavail )
97 output_html_with_http_headers $query, $cookie, $template->output;