|
Lines 101-107
sub GetItemTypesCategorized {
Link Here
|
| 101 |
SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0 |
101 |
SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0 |
| 102 |
UNION |
102 |
UNION |
| 103 |
SELECT DISTINCT searchcategory AS `itemtype`, |
103 |
SELECT DISTINCT searchcategory AS `itemtype`, |
| 104 |
authorised_values.lib_opac AS description, |
104 |
COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, |
| 105 |
authorised_values.imageurl AS imageurl, |
105 |
authorised_values.imageurl AS imageurl, |
| 106 |
hideinopac, 1 as 'iscat' |
106 |
hideinopac, 1 as 'iscat' |
| 107 |
FROM itemtypes |
107 |
FROM itemtypes |
|
Lines 109-115
sub GetItemTypesCategorized {
Link Here
|
| 109 |
WHERE searchcategory > '' and hideinopac=1 |
109 |
WHERE searchcategory > '' and hideinopac=1 |
| 110 |
UNION |
110 |
UNION |
| 111 |
SELECT DISTINCT searchcategory AS `itemtype`, |
111 |
SELECT DISTINCT searchcategory AS `itemtype`, |
| 112 |
authorised_values.lib_opac AS description, |
112 |
COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, |
| 113 |
authorised_values.imageurl AS imageurl, |
113 |
authorised_values.imageurl AS imageurl, |
| 114 |
hideinopac, 1 as 'iscat' |
114 |
hideinopac, 1 as 'iscat' |
| 115 |
FROM itemtypes |
115 |
FROM itemtypes |
| 116 |
- |
|
|