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

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

Return to bug 39603