Lines 192-209
HideCols($authcat, @hide_cols);
Link Here
|
192 |
} |
192 |
} |
193 |
# ------------------------------------------------------------ |
193 |
# ------------------------------------------------------------ |
194 |
if ( $authcat =~ m/^Asort/ ) { |
194 |
if ( $authcat =~ m/^Asort/ ) { |
195 |
my $query = qq{ SELECT * FROM authorised_values WHERE category=? order by lib }; |
195 |
my $categoryauthvalues = C4::Acquisition->GetAuthValuesForCategory($authcat); |
196 |
my $sth = $dbh->prepare($query); |
196 |
|
197 |
$sth->execute($authcat ); |
197 |
if ( $categoryauthvalues->rows > 0 ) { |
198 |
if ( $sth->rows > 0 ) { |
198 |
for ( my $i = 0 ; $i < $categoryauthvalues->rows ; $i++ ) { |
199 |
for ( my $i = 0 ; $i < $sth->rows ; $i++ ) { |
199 |
my $results = $categoryauthvalues->fetchrow_hashref; |
200 |
my $results = $sth->fetchrow_hashref; |
|
|
201 |
push @authvals, $results->{authorised_value}; |
200 |
push @authvals, $results->{authorised_value}; |
202 |
$labels{ $results->{authorised_value} } = $results->{lib}; |
201 |
$labels{ $results->{authorised_value} } = $results->{lib}; |
203 |
} |
202 |
} |
204 |
} |
203 |
} |
205 |
$sth->finish; |
204 |
$categoryauthvalues->finish; |
206 |
@authvals = sort { $a <=> $b } @authvals; |
205 |
@authvals = sort { $a <=> $b } @authvals; |
207 |
} |
206 |
} |
208 |
elsif ( $authcat eq 'MONTHS' && $budget_period_startdate && $budget_period_enddate ) { |
207 |
elsif ( $authcat eq 'MONTHS' && $budget_period_startdate && $budget_period_enddate ) { |
209 |
|
208 |
|
210 |
- |
|
|