|
Lines 484-490
sub build_tabs {
Link Here
|
| 484 |
$query .= qq{ LEFT JOIN authorised_values_branches ON ( id = av_id )} if $branch_limit; |
484 |
$query .= qq{ LEFT JOIN authorised_values_branches ON ( id = av_id )} if $branch_limit; |
| 485 |
$query .= " WHERE category = ?"; |
485 |
$query .= " WHERE category = ?"; |
| 486 |
$query .= " AND ( branchcode = ? OR branchcode IS NULL )" if $branch_limit; |
486 |
$query .= " AND ( branchcode = ? OR branchcode IS NULL )" if $branch_limit; |
| 487 |
$query .= " GROUP BY lib ORDER BY lib, lib_opac"; |
487 |
$query .= " GROUP BY authorised_value,lib ORDER BY lib, lib_opac"; |
| 488 |
my $authorised_values_sth = $dbh->prepare( $query ); |
488 |
my $authorised_values_sth = $dbh->prepare( $query ); |
| 489 |
|
489 |
|
| 490 |
# in this array, we will push all the 10 tabs |
490 |
# in this array, we will push all the 10 tabs |
| 491 |
- |
|
|