|
Lines 370-376
sub build_tabs {
Link Here
|
| 370 |
$query .= qq{ LEFT JOIN authorised_values_branches ON ( id = av_id )} if $branch_limit; |
370 |
$query .= qq{ LEFT JOIN authorised_values_branches ON ( id = av_id )} if $branch_limit; |
| 371 |
$query .= " WHERE category = ?"; |
371 |
$query .= " WHERE category = ?"; |
| 372 |
$query .= " AND ( branchcode = ? OR branchcode IS NULL )" if $branch_limit; |
372 |
$query .= " AND ( branchcode = ? OR branchcode IS NULL )" if $branch_limit; |
| 373 |
$query .= " GROUP BY lib ORDER BY lib, lib_opac"; |
373 |
$query .= " ORDER BY lib, lib_opac"; |
| 374 |
my $authorised_values_sth = $dbh->prepare( $query ); |
374 |
my $authorised_values_sth = $dbh->prepare( $query ); |
| 375 |
|
375 |
|
| 376 |
# in this array, we will push all the 10 tabs |
376 |
# in this array, we will push all the 10 tabs |
| 377 |
- |
|
|