From 8854a14fe7299bc9230a856d19f213dcb2308956 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Tue, 4 Feb 2020 14:16:26 +0000 Subject: [PATCH] Bug 22302: Make ITEMTYPECAT descriptions fallback to lib description if no opac description Signed-off-by: Andrew Fuerste-Henry Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize --- C4/Koha.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Koha.pm b/C4/Koha.pm index 1cfcba6a26..39bfb4fdee 100644 --- a/C4/Koha.pm +++ b/C4/Koha.pm @@ -101,7 +101,7 @@ sub GetItemTypesCategorized { 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, + COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, authorised_values.imageurl AS imageurl, hideinopac, 1 as 'iscat' FROM itemtypes @@ -109,7 +109,7 @@ sub GetItemTypesCategorized { WHERE searchcategory > '' and hideinopac=1 UNION SELECT DISTINCT searchcategory AS `itemtype`, - authorised_values.lib_opac AS description, + COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description, authorised_values.imageurl AS imageurl, hideinopac, 1 as 'iscat' FROM itemtypes -- 2.39.5