Code to allow the associated borrowers to work
[koha.git] / serials / acqui-search.pl
1 #!/usr/bin/perl
2
3 use strict;
4 use CGI;
5 use C4::Auth;
6 use C4::Output;
7 use C4::Interface::CGI::Output;
8 use C4::Database;
9 use HTML::Template;
10 use C4::Acquisition;
11 my $query = new CGI;
12 my ($template, $loggedinuser, $cookie)
13     = get_template_and_user({template_name => "serials/acqui-search.tmpl",
14                              query => $query,
15                              type => "intranet",
16                              authnotrequired => 0,
17                              flagsrequired => {acquisition => 1},
18                              debug => 1,
19                              });
20
21 #FIXME : Is this page still used ????
22 # looks like no.
23
24 # budget
25 my $dbh = C4::Context->dbh;
26 my $sthtemp = $dbh->prepare("Select flags, branchcode from borrowers where borrowernumber = ?");
27 $sthtemp->execute($loggedinuser);
28 my ($flags, $homebranch)=$sthtemp->fetchrow;
29 my ($count,@results)=bookfunds($homebranch);
30 my $classlist='';
31 my $total=0;
32 my $totspent=0;
33 my $totcomtd=0;
34 my $totavail=0;
35 my @loop_budget = ();
36 for (my $i=0;$i<$count;$i++){
37         my ($spent,$comtd)=bookfundbreakdown($results[$i]->{'bookfundid'});
38         my $avail=$results[$i]->{'budgetamount'}-($spent+$comtd);
39         my %line;
40         $line{bookfundname} = $results[$i]->{'bookfundname'};
41         $line{budgetamount} = $results[$i]->{'budgetamount'};
42         $line{spent} = sprintf  ("%.2f", $spent);
43         $line{comtd} = sprintf  ("%.2f",$comtd);
44         $line{avail}  = sprintf  ("%.2f",$avail);
45         push @loop_budget, \%line;
46         $total+=$results[$i]->{'budgetamount'};
47         $totspent+=$spent;
48         $totcomtd+=$comtd;
49         $totavail+=$avail;
50 }
51 #currencies
52 my ($count,$rates)=getcurrencies();
53 my @loop_currency = ();
54 for (my $i=0;$i<$count;$i++){
55         my %line;
56         $line{currency} = $rates->[$i]->{'currency'};
57         $line{rate} = $rates->[$i]->{'rate'};
58         push @loop_currency, \%line;
59 }
60 $template->param(classlist => $classlist,
61                                                 type => 'intranet',
62                                                 loop_budget => \@loop_budget,
63                                                 loop_currency => \@loop_currency,
64                                                 total => sprintf("%.2f",$total),
65                                                 totspent => sprintf("%.2f",$totspent),
66                                                 totcomtd => sprintf("%.2f",$totcomtd),
67                                                 totavail => sprintf("%.2f",$totavail));
68
69 output_html_with_http_headers $query, $cookie, $template->output;