From 9699e0b77e4611e08ec0581eb494291cab378452 Mon Sep 17 00:00:00 2001 From: Blou Date: Mon, 27 Jan 2014 14:06:24 -0500 Subject: [PATCH] Fix tab issues http://bugs.koha-community.org/show_bug.cgi?id=10937 --- C4/Koha.pm | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/C4/Koha.pm b/C4/Koha.pm index 2f2cee1..844db0a 100644 --- a/C4/Koha.pm +++ b/C4/Koha.pm @@ -43,7 +43,7 @@ BEGIN { &subfield_is_koha_internal_p &GetPrinters &GetPrinter &GetItemTypes &getitemtypeinfo - &GetItemTypesCategorized &GetItemTypesByCategory + &GetItemTypesCategorized &GetItemTypesByCategory &GetSupportName &GetSupportList &get_itemtypeinfos_of &getframeworks &getframeworkinfo @@ -288,9 +288,13 @@ sub GetItemTypesCategorized { my $query = qq| SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0 UNION - SELECT DISTINCT searchcategory AS `itemtype`, authorised_values.lib_opac AS description, authorised_values.imageurl AS imageurl, hideinopac, 1 as 'iscat' - FROM itemtypes - LEFT JOIN authorised_values ON searchcategory = authorised_value WHERE searchcategory > '' + SELECT DISTINCT searchcategory AS `itemtype`, + authorised_values.lib_opac AS description, + authorised_values.imageurl AS imageurl, + hideinopac, 1 as 'iscat' + FROM itemtypes + LEFT JOIN authorised_values ON searchcategory = authorised_value + WHERE searchcategory > '' |; my $sth = $dbh->prepare($query); $sth->execute; -- 1.7.9.5