Lines 1076-1082
sub GetAuthorisedValues {
Link Here
|
1076 |
if(@where_strings > 0) { |
1076 |
if(@where_strings > 0) { |
1077 |
$query .= " WHERE " . join(" AND ", @where_strings); |
1077 |
$query .= " WHERE " . join(" AND ", @where_strings); |
1078 |
} |
1078 |
} |
1079 |
$query .= " GROUP BY lib ORDER BY category, " . ($opac ? "lib_opac, lib" : "lib, lib_opac"); |
1079 |
$query .= " GROUP BY lib"; |
|
|
1080 |
$query .= ' ORDER BY category, ' . ( |
1081 |
$opac ? 'COALESCE(lib_opac, lib)' |
1082 |
: 'lib, lib_opac' |
1083 |
); |
1080 |
|
1084 |
|
1081 |
my $sth = $dbh->prepare($query); |
1085 |
my $sth = $dbh->prepare($query); |
1082 |
|
1086 |
|
1083 |
- |
|
|