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

(-)a/C4/Koha.pm (-5 / +8 lines)
Lines 43-49 BEGIN { Link Here
43
		&subfield_is_koha_internal_p
43
		&subfield_is_koha_internal_p
44
		&GetPrinters &GetPrinter
44
		&GetPrinters &GetPrinter
45
		&GetItemTypes &getitemtypeinfo
45
		&GetItemTypes &getitemtypeinfo
46
		&GetItemTypesCategorized &GetItemTypesByCategory
46
                &GetItemTypesCategorized &GetItemTypesByCategory
47
		&GetSupportName &GetSupportList
47
		&GetSupportName &GetSupportList
48
		&get_itemtypeinfos_of
48
		&get_itemtypeinfos_of
49
		&getframeworks &getframeworkinfo
49
		&getframeworks &getframeworkinfo
Lines 288-296 sub GetItemTypesCategorized { Link Here
288
    my $query = qq|
288
    my $query = qq|
289
        SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0
289
        SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0
290
        UNION
290
        UNION
291
        SELECT DISTINCT searchcategory AS `itemtype`, authorised_values.lib_opac AS description, authorised_values.imageurl AS imageurl, hideinopac, 1 as 'iscat'
291
        SELECT DISTINCT searchcategory AS `itemtype`,
292
            FROM itemtypes
292
                        authorised_values.lib_opac AS description,
293
	    LEFT JOIN authorised_values ON searchcategory = authorised_value WHERE searchcategory > ''
293
                        authorised_values.imageurl AS imageurl,
294
                        hideinopac, 1 as 'iscat'
295
        FROM itemtypes
296
        LEFT JOIN authorised_values ON searchcategory = authorised_value
297
        WHERE searchcategory > ''
294
        |;
298
        |;
295
    my $sth = $dbh->prepare($query);
299
    my $sth = $dbh->prepare($query);
296
    $sth->execute;
300
    $sth->execute;
297
- 

Return to bug 10937