#!/usr/bin/perl
-use strict;
-use CGI;
-use C4::Auth;
-use C4::Output;
-use C4::Interface::CGI::Output;
-use C4::Database;
-use C4::Suggestions;
-use HTML::Template;
-use C4::Acquisition;
-
-my $query = new CGI;
-my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
- {
- template_name => "acqui/acqui-home.tmpl",
+# Copyright 2008 - 2009 BibLibre SARL
+# 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 3 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, see <http://www.gnu.org/licenses>.
+
+=head1 NAME
+
+acqui-home.pl
+
+=head1 DESCRIPTION
+
+this script is the main page for acqui
+
+=cut
+
+use Modern::Perl;
+
+use CGI qw ( -utf8 );
+use C4::Auth qw( get_template_and_user );
+use C4::Output qw( output_html_with_http_headers );
+use C4::Budgets qw( GetBudgetHierarchy GetBudget CanUserUseBudget );
+use C4::Members;
+use Koha::Acquisition::Currencies;
+use Koha::Patrons;
+use Koha::Suggestions;
+
+my $query = CGI->new;
+my ( $template, $loggedinuser, $cookie, $userflags ) = get_template_and_user(
+ { template_name => 'acqui/acqui-home.tt',
query => $query,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => { acquisition => 1 },
- debug => 1,
+ type => 'intranet',
+ flagsrequired => { acquisition => '*' },
}
);
-# 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 ( $count, @results ) = bookfunds($homebranch);
-my $classlist = '';
-my $total = 0;
-my $totspent = 0;
-my $totcomtd = 0;
-my $totavail = 0;
-my @loop_budget = ();
-for ( my $i = 0 ; $i < $count ; $i++ ) {
-
- if ( $toggle eq 0 ) {
- $toggle = 1;
+my $status = $query->param('status') || "ASKED";
+# Get current branch count and total viewable count, if they don't match then pass
+# both to template
+if( C4::Context->only_my_library ){
+ my $local_pendingsuggestions_count = Koha::Suggestions->search({ status => "ASKED", branchcode => C4::Context->userenv()->{'branch'} })->count();
+ $template->param( suggestions_count => $local_pendingsuggestions_count );
+} else {
+ my $pendingsuggestions = Koha::Suggestions->search({ status => "ASKED" });
+ my $local_pendingsuggestions_count = $pendingsuggestions->search({ 'me.branchcode' => C4::Context->userenv()->{'branch'} })->count();
+ my $pendingsuggestions_count = $pendingsuggestions->count();
+ $template->param(
+ all_pendingsuggestions => $pendingsuggestions_count != $local_pendingsuggestions_count ? $pendingsuggestions_count : 0,
+ suggestions_count => $local_pendingsuggestions_count
+ );
+}
+
+my $budget_arr = GetBudgetHierarchy;
+
+my $total = 0;
+my $totspent = 0;
+my $totordered = 0;
+my $totcomtd = 0;
+my $totavail = 0;
+
+my $total_active = 0;
+my $totspent_active = 0;
+my $totordered_active = 0;
+my $totavail_active = 0;
+
+my @budget_loop;
+foreach my $budget ( @{$budget_arr} ) {
+ next unless (CanUserUseBudget($loggedinuser, $budget, $userflags));
+
+ my $patron = Koha::Patrons->find( $budget->{budget_owner_id} );
+ if ( $patron ) {
+ $budget->{budget_owner} = $patron;
+ }
+
+ if ( !defined $budget->{budget_amount} ) {
+ $budget->{budget_amount} = 0;
}
- else {
- $toggle = 0;
+ if ( !defined $budget->{budget_spent} ) {
+ $budget->{budget_spent} = 0;
}
- my ( $spent, $comtd ) = bookfundbreakdown( $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 );
- $line{'toggle'} = $toggle;
- push @loop_budget, \%line;
- $total += $results[$i]->{'budgetamount'};
- $totspent += $spent;
- $totcomtd += $comtd;
- $totavail += $avail;
-}
+ if ( !defined $budget->{budget_ordered} ) {
+ $budget->{budget_ordered} = 0;
+ }
+ $budget->{'budget_avail'} =
+ $budget->{'budget_amount'} - ( $budget->{'budget_spent'} + $budget->{'budget_ordered'} );
+ $budget->{'total_avail'} =
+ $budget->{'budget_amount'} - ( $budget->{'total_spent'} + $budget->{'total_ordered'} );
-#currencies
-my $rates;
-( $count, $rates ) = getcurrencies();
-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;
+ $total += $budget->{'budget_amount'};
+ $totspent += $budget->{'budget_spent'};
+ $totordered += $budget->{'budget_ordered'};
+ $totavail += $budget->{'budget_avail'};
+
+ if ($budget->{budget_period_active}){
+ $total_active += $budget->{'budget_amount'};
+ $totspent_active += $budget->{'budget_spent'};
+ $totordered_active += $budget->{'budget_ordered'};
+ $totavail_active += $budget->{'budget_avail'};
+ }
+
+ push @budget_loop, $budget;
}
-# suggestions ?
-my $suggestion = countsuggestion("ASKED");
$template->param(
- classlist => $classlist,
type => 'intranet',
- loop_budget => \@loop_budget,
- loop_currency => \@loop_currency,
- total => sprintf( "%.2f", $total ),
- suggestion => $suggestion,
- totspent => sprintf( "%.2f", $totspent ),
- totcomtd => sprintf( "%.2f", $totcomtd ),
- totavail => sprintf( "%.2f", $totavail ),
- nobudget => $#results == -1 ? 1 : 0
+ loop_budget => \@budget_loop,
+ total => $total,
+ totspent => $totspent,
+ totordered => $totordered,
+ totcomtd => $totcomtd,
+ totavail => $totavail,
+ total_active => $total_active,
+ totspent_active => $totspent_active,
+ totordered_active => $totordered_active,
+ totavail_active => $totavail_active,
);
+my $cur = Koha::Acquisition::Currencies->get_active;
+if ( $cur ) {
+ $template->param(
+ currency => $cur->currency,
+ );
+}
+
output_html_with_http_headers $query, $cookie, $template->output;