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