From 7df929822685227fa54f775d8c09f9c9342f4eb3 Mon Sep 17 00:00:00 2001 From: Alexis Ripetti Date: Wed, 2 Dec 2020 14:41:57 -0500 Subject: [PATCH] Bug 27136 - Add languages and avoid displaying nothing in facet --- .../bz27136-Add_languages_for_facet.sql | 24 +++++++++++++++++++ .../intranet-tmpl/prog/en/includes/facets.inc | 2 +- .../bootstrap/en/includes/opac-facets.inc | 2 +- 3 files changed, 26 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bz27136-Add_languages_for_facet.sql diff --git a/installer/data/mysql/atomicupdate/bz27136-Add_languages_for_facet.sql b/installer/data/mysql/atomicupdate/bz27136-Add_languages_for_facet.sql new file mode 100644 index 0000000000..38df3aa6df --- /dev/null +++ b/installer/data/mysql/atomicupdate/bz27136-Add_languages_for_facet.sql @@ -0,0 +1,24 @@ +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('cr', 'language', 'Cree', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('cr', 'language', 'en', 'Cree'); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('cr', 'language', 'fr', 'Cree'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('cr', 'cre'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('af', 'language', 'Afrikaans', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('af', 'language', 'en', 'Afrikaans'); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('af', 'language', 'fr', 'Afrikaans'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('af', 'afr'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('mul', 'language', 'Multiple languages', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('mul', 'language', 'en', 'Multiple languages'); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('mul', 'language', 'fr', 'Multilingue'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('mul', 'mul'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('und', 'language', 'Undetermined', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('und', 'language', 'en', 'Undetermined'); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('und', 'language', 'fr', 'Indéterminée'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('und', 'und'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('zxx', 'language', 'No linguistic content', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('zxx', 'language', 'en', 'No linguistic content'); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('zxx', 'language', 'fr', 'Pas de contenu linguistique'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('zxx', 'zxx'); \ No newline at end of file diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/facets.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/facets.inc index d31ade3d23..0567423ed0 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/facets.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/facets.inc @@ -47,7 +47,7 @@ [x] [% ELSE %] [% local_url = BLOCK %][% url | $raw %][% "&limit=" _ facet.type_link_value _ ":" _ facet.facet_link_value | url %][% END %] - [% facet.facet_label_value | html %] + [% IF (facet.facet_label_value) %][% facet.facet_label_value | html %][% ELSE %]No information provided[% END %] [% IF ( displayFacetCount ) %] ([% facet.facet_count | html %]) [% END %] diff --git a/koha-tmpl/opac-tmpl/bootstrap/en/includes/opac-facets.inc b/koha-tmpl/opac-tmpl/bootstrap/en/includes/opac-facets.inc index dad168a4ef..e946d7a5e6 100644 --- a/koha-tmpl/opac-tmpl/bootstrap/en/includes/opac-facets.inc +++ b/koha-tmpl/opac-tmpl/bootstrap/en/includes/opac-facets.inc @@ -56,7 +56,7 @@ [x] [% ELSE %] [% local_url = BLOCK %][% url | $raw %][% "&limit=" _ facet.type_link_value _ ":" _ facet.facet_link_value | url %][% END %] - [% facet.facet_label_value | html %] + [% IF (facet.facet_label_value) %][% facet.facet_label_value | html %][% ELSE %]No information provided[% END %] [% IF ( displayFacetCount ) %] ([% facet.facet_count | html %]) [% END %] -- 2.25.1