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