From c5c88b215319c7fd8a0b4007bacf8759690cec0a Mon Sep 17 00:00:00 2001 From: Adrien Saurat Date: Mon, 30 Apr 2012 10:05:07 +0200 Subject: [PATCH] Bug 8025: corrects the return of a zero value for authorised values Signed-off-by: Owen Leonard Signed-off-by: Paul Poulain Signed-off-by: Chris Cormack --- C4/Koha.pm | 23 +++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) diff --git a/C4/Koha.pm b/C4/Koha.pm index 0192989ecb..a028937b1a 100644 --- a/C4/Koha.pm +++ b/C4/Koha.pm @@ -1008,22 +1008,25 @@ C<$opac> If set to a true value, displays OPAC descriptions rather than normal o sub GetAuthorisedValues { my ($category,$selected,$opac) = @_; - my @results; + my @results; my $dbh = C4::Context->dbh; my $query = "SELECT * FROM authorised_values"; $query .= " WHERE category = '" . $category . "'" if $category; $query .= " ORDER BY category, lib, lib_opac"; my $sth = $dbh->prepare($query); $sth->execute; - while (my $data=$sth->fetchrow_hashref) { - if ($selected && $selected eq $data->{'authorised_value'} ) { - $data->{'selected'} = 1; - } - if ($opac && $data->{'lib_opac'}) { - $data->{'lib'} = $data->{'lib_opac'}; - } - push @results, $data; - } + while (my $data=$sth->fetchrow_hashref) { + if ( (defined($selected)) && ($selected eq $data->{'authorised_value'}) ) { + $data->{'selected'} = 1; + } + else { + $data->{'selected'} = 0; + } + if ($opac && $data->{'lib_opac'}) { + $data->{'lib'} = $data->{'lib_opac'}; + } + push @results, $data; + } #my $data = $sth->fetchall_arrayref({}); return \@results; #$data; } -- 2.39.5