my $period = GetBudgetPeriod($budget_period_id);
my $count = GetPeriodsCount();
my $cur = GetCurrency;
-
+$template->param( symbol => $cur->{symbol},
+ currency => $cur->{currency}
+ );
$template->param( period_button_only => 1 ) if $count == 0;
my $budget_period_enddate = $period->{'budget_period_enddate'};
my $budget_period_locked = $period->{'budget_period_locked'};
my $budget_period_description = $period->{'budget_period_description'};
-my $budget_period_dropbox = GetBudgetPeriodsDropbox($budget_period_id );
$template->param(
budget_period_id => $budget_period_id,
budget_period_locked => $budget_period_locked,
budget_period_description => $budget_period_description,
- budget_period_dropbox => $budget_period_dropbox,
auth_cats_loop => $auth_cats_loop,
);
# ------- get periods stuff ------------------
-my $borrower_id = $template->{param_map}->{'USER_INFO'}[0]->{'borrowernumber'};
-my $borrower_branchcode = $template->{param_map}->{'USER_INFO'}[0]->{'branchcode'};
+my $borrower_id = $template->{VARS}->{'USER_INFO'}[0]->{'borrowernumber'};
+my $borrower_branchcode = $template->{VARS}->{'USER_INFO'}[0]->{'branchcode'};
my $periods;
my $authcat = $input->param('authcat');
my $show_percent = $input->param('show_percent');
my $output = $input->param("output");
my $basename = $input->param("basename");
-my $mime = $input->param("MIME");
my $del = $input->param("sep");
my $show_mine = $input->param('show_mine') ;
my $budget_branchcode;
-my $budgets_ref = GetBudgetHierarchy( $budget_period_id, $show_mine?$template->{param_map}->{'USER_INFO'}[0]->{'branchcode'}:'', $show_mine?$template->{param_map}->{'USER_INFO'}[0]->{'borrowernumber'}:'' );
+my $budgets_ref = GetBudgetHierarchy( $budget_period_id, $show_mine?$template->{VARS}->{'USER_INFO'}[0]->{'branchcode'}:'', $show_mine?$template->{VARS}->{'USER_INFO'}[0]->{'borrowernumber'}:'' );
# build categories list
my $sth = $dbh->prepare("select distinct category from authorised_values where category like 'A%' ");
push( @category_list, 'MONTHS' );
push( @category_list, 'ITEMTYPES' );
push( @category_list, 'BRANCHES' );
+push( @category_list, $$_{'authcat'} ) foreach @$auth_cats_loop;
#reorder the list
@category_list = sort { $a cmp $b } @category_list;
my @authvals;
my %labels;
-
- my @names = $input->param();
-
+my @names = $input->param();
# ------------------------------------------------------------
if ( $op eq 'save' ) {
#get budgets
}
}
$sth->finish;
+} elsif ($authcat) {
+ my $query = qq{ SELECT * FROM authorised_values WHERE category=? order by lib };
+ my $sth = $dbh->prepare($query);
+ $sth->execute($authcat);
+ if ( $sth->rows > 0 ) {
+ for ( my $i = 0 ; $i < $sth->rows ; $i++ ) {
+ my $results = $sth->fetchrow_hashref;
+ push @authvals, $results->{authorised_value};
+ $labels{ $results->{authorised_value} } = $results->{lib};
+ }
+ }
+ $sth->finish;
}
my @authvals_row;
# ------------------------------------------------------------
# DEFAULT DISPLAY BEGINS
-my @mime = ( C4::Context->preference("MIME") );
my $CGIextChoice = CGI::scrolling_list(
-name => 'MIME',
-id => 'MIME',
- -values => \@mime,
+ -values => ['CSV'], # FIXME translation
-size => 1,
-multiple => 0
);
show_actual => $show_actual,
show_percent => $show_percent,
show_mine => $show_mine,
- cur => $cur->{symbol},
cur_format => $cur_format,
CGIextChoice => $CGIextChoice,
CGIsepChoice => $CGIsepChoice,
sub _print_to_csv {
my ( $header, $results ) = @_;
- binmode STDOUT, ":utf8";
+ binmode STDOUT, ':encoding(UTF-8)';
my $csv = Text::CSV_XS->new(
{ sep_char => $del,