$actual = $sth->fetchrow_array;
# get the estimated amount
- my $sth = $dbh->prepare( qq|
+ $sth = $dbh->prepare( qq|
SELECT estimated_amount AS estimated, display FROM aqbudgets_planning
WHERE budget_period_id = ? AND
}
# look for top parents 1st
- my @sort;
- my ($i, $depth_count) = 0;
+ my (@sort, $depth_count);
+ ($i, $depth_count) = 0;
while (1) {
my $children = 0;
foreach my $r (@res) {
$moo =~ s/\ /\ \;/g;
$r->{'budget_code_indent'} = $moo;
- my $moo = $r->{'budget_name_indent'};
+ $moo = $r->{'budget_name_indent'};
$moo =~ s/\ /\ \;/g;
$r->{'budget_name_indent'} = $moo;
sub GetBudget {
my ( $budget_id ) = @_;
my $dbh = C4::Context->dbh;
- my $query;
my $query = "
SELECT *
FROM aqbudgets
my $sth = $dbh->prepare($query);
$sth->execute($fieldtag, $subfieldtag);
my @results = $sth->fetchrow_array();
- push @marcfieldsheaders, @results[0];
+ push @marcfieldsheaders, $results[0];
} else {
my $query = "SELECT liblibrarian FROM marc_tag_structure WHERE tagfield=?";
my $sth = $dbh->prepare($query);
$sth->execute($_);
my @results = $sth->fetchrow_array();
- push @marcfieldsheaders, @results[0];
+ push @marcfieldsheaders, $results[0];
}
}
$csv->combine(@marcfieldsheaders);
my $branchname = GetBranchName($homebranch);
#my $count = scalar @results;
-my $count;
my $classlist = '';
my $total = 0;
my $totspent = 0;
$count = scalar @rates;
my $active_currency = GetCurrency;
-my $num = new Number::Format(-int_curr_symbol => '',
- -decimal_digits => "2" );
-my @loop_currency = ();
-for ( my $i = 0 ; $i < $count ; $i++ ) {
- my %line;
- $line{currency} = $rates[$i]->{'currency'} ;
- $line{currency_symbol} = $rates[$i]->{'symbol'};
- $line{rate} = sprintf ( '%.2f', $rates[$i]->{'rate'} );
- push @loop_currency, \%line;
-}
-
-# suggestions
-my $status = $query->param('status') || "ASKED";
-my $suggestion = CountSuggestion($status);
-my $suggestions_loop = &SearchSuggestion( {STATUS=> $status} );
-# ---------------------------------------------------
-# number format
-my $cur_format = C4::Context->preference("CurrencyFormat");
my $num;
+my $cur_format = C4::Context->preference("CurrencyFormat");
if ( $cur_format eq 'FR' ) {
$num = new Number::Format(
'decimal_fill' => '2',
);
}
+my @loop_currency = ();
+for ( my $i = 0 ; $i < $count ; $i++ ) {
+ my %line;
+ $line{currency} = $rates[$i]->{'currency'} ;
+ $line{currency_symbol} = $rates[$i]->{'symbol'};
+ $line{rate} = sprintf ( '%.2f', $rates[$i]->{'rate'} );
+ push @loop_currency, \%line;
+}
+
+# suggestions
+my $status = $query->param('status') || "ASKED";
+my $suggestion = CountSuggestion($status);
+my $suggestions_loop = &SearchSuggestion( {STATUS=> $status} );
+# ---------------------------------------------------
+# number format
my $period = GetBudgetPeriod;
my $budget_period_id = $period->{budget_period_id};
my $budget_branchcode = $period->{budget_branchcode};
my $moo = GetBudgetHierarchy('',$homebranch, $template->{param_map}->{'USER_INFO'}[0]->{'borrowernumber'} );
-my @results = @$moo;
+@results = @$moo;
my $period_total = 0;
my $toggle = 0;
my @loop;
-my ( $total, $totspent, $totcomtd, $totavail );
foreach my $result (@results) {
# only get top-level budgets for display
$found = 1;
}
}
- push @{$item->{tags}}, @tags[$i];
- push @{$item->{subfields}}, @subfields[$i];
- push @{$item->{field_values}}, @field_values[$i];
- push @{$item->{ind_tag}}, @ind_tag[$i];
- push @{$item->{indicator}}, @indicator[$i];
+ push @{$item->{tags}}, $tags[$i];
+ push @{$item->{subfields}}, $subfields[$i];
+ push @{$item->{field_values}}, $field_values[$i];
+ push @{$item->{ind_tag}}, $ind_tag[$i];
+ push @{$item->{indicator}}, $indicator[$i];
$item->{itemid} = $itemid;
if (! $found){
push @items, $item;
my $orderitem = {
ordernumber => $order->{'ordernumber'},
itemnumber => $itemnumber,
- newitemnumber => $newitemnumber,
+ newitemnumber => $itemnumber,
};
ModOrderItem($orderitem);
}
COLUMN `renewalsallowed` smallint(6) default NULL,
COLUMN `reservesallowed` smallint(6) default NULL,
");
-$sth = $dbh->prepare("SELECT itemtype, renewalsallowed FROM itemtypes");
+my $sth = $dbh->prepare("SELECT itemtype, renewalsallowed FROM itemtypes");
$sth->execute();
my $sthupd = $dbh->prepare("UPDATE issuingrules SET renewalsallowed = ? WHERE itemtype = ?");