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;
32 my ($template, $loggedinuser, $cookie)
33 = get_template_and_user({template_name => "serials/acqui-search.tmpl",
37 flagsrequired => {acquisition => 1},
41 # FIXME : Is this page still used ????
45 my $dbh = C4::Context->dbh;
46 my $sthtemp = $dbh->prepare("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)=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'};
74 my @rates=GetCurrencies();
75 my $count = scalar @rates;
77 my @loop_currency = ();
78 for (my $i=0;$i<$count;$i++){
80 $line{currency} = $rates->[$i]->{'currency'};
81 $line{rate} = $rates->[$i]->{'rate'};
82 push @loop_currency, \%line;
84 $template->param(classlist => $classlist,
86 loop_budget => \@loop_budget,
87 loop_currency => \@loop_currency,
88 total => sprintf("%.2f",$total),
89 totspent => sprintf("%.2f",$totspent),
90 totcomtd => sprintf("%.2f",$totcomtd),
91 totavail => sprintf("%.2f",$totavail));
93 output_html_with_http_headers $query, $cookie, $template->output;