my $i=0;
my @results;
while (my $data=$sth->fetchrow_hashref){
- $results[$i]="$data->{'datetime'}\t$data->{'branch'}";
- $i++;
+ my %tempvalue;
+ $tempvalue{'value'}="$data->{'datetime'}\t$data->{'branch'}";
+ push(@results, \%tempvalue);
}
$sth->finish;
# print $query;
my $dbh = C4::Context->dbh;
my $query="Select sum(amountoutstanding) from accountlines";
if ($type eq 'fine'){
- $query=$query." where accounttype='F' or accounttype='FN'"; # FIXME - .=
+ $query .= " where accounttype='F' or accounttype='FN'";
}
my $sth=$dbh->prepare($query);
# print $query;
or accounttype ='W')
and accountlines.borrowernumber = borrowers.borrowernumber";
if ($time eq 'today'){
- $query=$query." and date = now()"; # FIXME - .=
+ $query .= " and date = now()";
} else {
$query.=" and date='$time'";
}