#!/usr/bin/perl

#script to show list of budgets and bookfunds
#written 4/2/00 by chris@katipo.co.nz
#called as an include by the acquisitions index page


# Copyright 2000-2002 Katipo Communications
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 2 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along with
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA  02111-1307 USA

use C4::Acquisitions;
use C4::Biblio;
#use CGI;
#my $inp=new CGI;
#print $inp->header;
my ($count,@results)=bookfunds;


print <<printend

<TABLE  width="40%"  cellspacing=0 cellpadding=5 border=1 >
<FORM ACTION="/cgi-bin/koha/search.pl">
<TR VALIGN=TOP>
<TD  bgcolor="99cc33" background="/images/background-mem.gif" colspan=2><b>BUDGETS AND BOOKFUNDS</b></TD></TR>
<TR VALIGN=TOP>
<TD colspan=2><table>


<tr><td>
<b>Budgets</B></TD> <TD><b>Total</B></TD> <TD><b>Spent</B></TD><TD><b>Comtd</B></TD><TD><b>Avail</B></TD></TR>
printend
;
my $total=0;
my $totspent=0;
my $totcomtd=0;
my $totavail=0;
for (my $i=0;$i<$count;$i++){
  my ($spent,$comtd)=bookfundbreakdown($results[$i]->{'bookfundid'});
  my $avail=$results[$i]->{'budgetamount'}-($spent+$comtd);
  print  <<EOP
<tr><td>
$results[$i]->{'bookfundname'} </TD> 
<TD>$results[$i]->{'budgetamount'}</TD> <TD>
EOP
;
printf  ("%.2f", $spent);
print  "</TD><TD>";
printf  ("%.2f",$comtd);
print  "</TD><TD>";
printf  ("%.2f",$avail);
print  "</TD></TR>";
  $total+=$results[$i]->{'budgetamount'};
  $totspent+=$spent;
  $totcomtd+=$comtd;
  $totavail+=$avail;
}

print  <<printend
<tr><td colspan=5>
<hr size=1 noshade></TD></TR>

<tr><td>
Total </TD> <TD>$total</TD> <TD>
printend
;
printf  ("%.2f",$totspent);
print  "</TD><TD>";
printf  ("%.2f",$totcomtd);
print  "</TD><TD>";
printf  ("%.2f",$totavail);
print  "</TD></TR>";
print  <<printend
</table><br>
Use your reload button [ctrl + r] to get the most recent figures.
Committed figures are approximate only, as exchange rates will affect the amount actually paid.

</TD></TR>
</form>
</table>

printend
;

#close ;
