From b722fbfb5c89c0ad6c90d994d09ff6e1936774ac Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Fri, 30 Oct 2015 16:25:15 -0300 Subject: [PATCH] Bug 15093: Load/show saved item type group and hideinopac This patch adds loading of hideinopac and searchgroup when showing/editing itemtypes To test: 1) Put some values in ITEMTYPCAT auth value 2) Edit an item type, select a value for search category & check 'Hide in OPAC' Save 3) Results do no show on list of item types 4) Edit same item type, values are default/empty 5) Apply the patch 6) Edit again, change again, save Now values shows in list 7) Edit again, values are now correct Values were saved on db, but not loaded from it How this happen? Side note: searching for searchcategory I found installer/data/mysql/kohastructure.sql: searchcategory varchar(80) default NULL, -- Group this item type with others w installer/data/mysql/updatedatabase.pl: ADD searchcategory VARCHAR(20) DEFAULT NULL Its varchar(80) in kohastructure and varchar(20) in updatedatabase We need more eyes :) Signed-off-by: Nicole Engard Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- C4/Koha.pm | 2 ++ admin/itemtypes.pl | 2 ++ 2 files changed, 4 insertions(+) diff --git a/C4/Koha.pm b/C4/Koha.pm index 0a90bb3215..747610677f 100644 --- a/C4/Koha.pm +++ b/C4/Koha.pm @@ -263,6 +263,8 @@ sub GetItemTypes { itemtypes.checkinmsg, itemtypes.checkinmsgtype, itemtypes.sip_media_type, + itemtypes.hideinopac, + itemtypes.searchcategory, COALESCE( localization.translation, itemtypes.description ) AS translated_description FROM itemtypes LEFT JOIN localization ON itemtypes.itemtype = localization.code diff --git a/admin/itemtypes.pl b/admin/itemtypes.pl index 2af82a3ec5..9e2fdfeebb 100755 --- a/admin/itemtypes.pl +++ b/admin/itemtypes.pl @@ -99,6 +99,8 @@ if ( $op eq 'add_form' ) { itemtypes.checkinmsg, itemtypes.checkinmsgtype, itemtypes.sip_media_type, + itemtypes.hideinopac, + itemtypes.searchcategory, COALESCE( localization.translation, itemtypes.description ) AS translated_description FROM itemtypes LEFT JOIN localization ON itemtypes.itemtype = localization.code -- 2.39.5