Lines 101-106
sub GetItemTypesCategorized {
Link Here
|
101 |
FROM itemtypes |
101 |
FROM itemtypes |
102 |
LEFT JOIN authorised_values ON searchcategory = authorised_value |
102 |
LEFT JOIN authorised_values ON searchcategory = authorised_value |
103 |
WHERE searchcategory > '' and hideinopac=1 |
103 |
WHERE searchcategory > '' and hideinopac=1 |
|
|
104 |
AND category = 'ITEMTYPECAT' |
104 |
UNION |
105 |
UNION |
105 |
SELECT DISTINCT searchcategory AS `itemtype`, |
106 |
SELECT DISTINCT searchcategory AS `itemtype`, |
106 |
COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, |
107 |
COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, |
Lines 109-114
sub GetItemTypesCategorized {
Link Here
|
109 |
FROM itemtypes |
110 |
FROM itemtypes |
110 |
LEFT JOIN authorised_values ON searchcategory = authorised_value |
111 |
LEFT JOIN authorised_values ON searchcategory = authorised_value |
111 |
WHERE searchcategory > '' and hideinopac=0 |
112 |
WHERE searchcategory > '' and hideinopac=0 |
|
|
113 |
AND category = 'ITEMTYPECAT' |
112 |
|; |
114 |
|; |
113 |
return ( $dbh->selectall_hashref( $query, 'itemtype' ) ); |
115 |
return ( $dbh->selectall_hashref( $query, 'itemtype' ) ); |
114 |
} |
116 |
} |
115 |
- |
|
|