-# budget
-my $dbh = C4::Context->dbh;
-my $sthtemp =
- $dbh->prepare(
- "Select flags, branchcode from borrowers where borrowernumber = ?");
-$sthtemp->execute($loggedinuser);
-my ( $flags, $homebranch ) = $sthtemp->fetchrow;
-my @results = GetBookFunds($homebranch);
-my $count = scalar(@results);
-
-my $classlist = '';
-my $total = 0;
-my $totspent = 0;
-my $totcomtd = 0;
-my $totavail = 0;
-my @loop_budget = ();
-for ( my $i = 0 ; $i < $count ; $i++ ) {
- my ( $spent, $comtd ) =
- GetBookFundBreakdown( $results[$i]->{'bookfundid'} );
- my $avail = $results[$i]->{'budgetamount'} - ( $spent + $comtd );
- my %line;
- $line{bookfundname} = $results[$i]->{'bookfundname'};
- $line{budgetamount} = $results[$i]->{'budgetamount'};
- $line{spent} = sprintf( "%.2f", $spent );
- $line{comtd} = sprintf( "%.2f", $comtd );
- $line{avail} = sprintf( "%.2f", $avail );
- push @loop_budget, \%line;
- $total += $results[$i]->{'budgetamount'};
- $totspent += $spent;
- $totcomtd += $comtd;
- $totavail += $avail;
-}
-
-#currencies
-my @rates = GetCurrencies();
-my $count = scalar @rates;
-
-my @loop_currency = ();
-for ( my $i = 0 ; $i < $count ; $i++ ) {
- my %line;
- $line{currency} = $rates[$i]->{'currency'};
- $line{rate} = $rates[$i]->{'rate'};
- push @loop_currency, \%line;
-}
-$template->param(
- classlist => $classlist,
- type => 'intranet',
- loop_budget => \@loop_budget,
- loop_currency => \@loop_currency,
- total => sprintf( "%.2f", $total ),
- totspent => sprintf( "%.2f", $totspent ),
- totcomtd => sprintf( "%.2f", $totcomtd ),
- totavail => sprintf( "%.2f", $totavail )
-);
-