View | Details | Raw Unified | Return to bug 22302
Collapse All | Expand All

(-)a/C4/Koha.pm (-3 / +2 lines)
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
- 

Return to bug 22302