Bug 22518: Add database update 'just in case'
[koha.git] / C4 / Languages.pm
blob31d17ba73bf9f856fea8c7f18c755b325a8230b2
1 package C4::Languages;
3 # Copyright 2006 (C) LibLime
4 # Joshua Ferraro <jmf@liblime.com>
5 # Portions Copyright 2009 Chris Cormack and the Koha Dev Team
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use strict;
23 use warnings;
25 use Carp;
26 use CGI;
27 use List::MoreUtils qw( any );
28 use C4::Context;
29 use Koha::Cache::Memory::Lite;
30 use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $DEBUG);
32 BEGIN {
33 require Exporter;
34 @ISA = qw(Exporter);
35 @EXPORT = qw(
36 &getFrameworkLanguages
37 &getTranslatedLanguages
38 &getLanguages
39 &getAllLanguages
41 @EXPORT_OK = qw(getFrameworkLanguages getTranslatedLanguages getAllLanguages getLanguages get_bidi regex_lang_subtags language_get_description accept_language getlanguage);
42 $DEBUG = 0;
45 =head1 NAME
47 C4::Languages - Perl Module containing language list functions for Koha
49 =head1 SYNOPSIS
51 use C4::Languages;
53 =head1 DESCRIPTION
55 =cut
57 =head1 FUNCTIONS
59 =head2 getFrameworkLanguages
61 Returns a reference to an array of hashes:
63 my $languages = getFrameworkLanguages();
64 for my $language(@$languages) {
65 print "$language->{language_code}\n"; # language code in iso 639-2
66 print "$language->{language_name}\n"; # language name in native script
67 print "$language->{language_locale_name}\n"; # language name in current locale
70 =cut
72 sub getFrameworkLanguages {
73 # get a hash with all language codes, names, and locale names
74 my $all_languages = getAllLanguages();
75 my @languages;
77 # find the available directory names
78 my $dir=C4::Context->config('intranetdir')."/installer/data/";
79 opendir (MYDIR,$dir);
80 my @listdir= grep { !/^\.|CVS/ && -d "$dir/$_"} readdir(MYDIR);
81 closedir MYDIR;
83 # pull out all data for the dir names that exist
84 for my $dirname (@listdir) {
85 for my $language_set (@$all_languages) {
87 if ($dirname eq $language_set->{language_code}) {
88 push @languages, {
89 'language_code'=>$dirname,
90 'language_description'=>$language_set->{language_description},
91 'native_descrition'=>$language_set->{language_native_description} }
95 return \@languages;
98 =head2 getTranslatedLanguages
100 Returns a reference to an array of hashes:
102 my $languages = getTranslatedLanguages();
103 print "Available translated languages:\n";
104 for my $language(@$trlanguages) {
105 print "$language->{language_code}\n"; # language code in iso 639-2
106 print "$language->{language_name}\n"; # language name in native script
107 print "$language->{language_locale_name}\n"; # language name in current locale
110 =cut
112 sub getTranslatedLanguages {
113 my ($interface, $theme, $current_language, $which) = @_;
114 my $htdocs;
115 my @languages;
116 my @enabled_languages;
118 if ($interface && $interface eq 'opac' ) {
119 @enabled_languages = split ",", C4::Context->preference('opaclanguages');
120 $htdocs = C4::Context->config('opachtdocs');
121 if ( $theme and -d "$htdocs/$theme" ) {
122 (@languages) = _get_language_dirs($htdocs,$theme);
124 else {
125 for my $theme ( _get_themes('opac') ) {
126 push @languages, _get_language_dirs($htdocs,$theme);
130 elsif ($interface && $interface eq 'intranet' ) {
131 @enabled_languages = split ",", C4::Context->preference('language');
132 $htdocs = C4::Context->config('intrahtdocs');
133 if ( $theme and -d "$htdocs/$theme" ) {
134 @languages = _get_language_dirs($htdocs,$theme);
136 else {
137 foreach my $theme ( _get_themes('intranet') ) {
138 push @languages, _get_language_dirs($htdocs,$theme);
142 else {
143 @enabled_languages = split ",", C4::Context->preference('opaclanguages');
144 my $htdocs = C4::Context->config('intrahtdocs');
145 foreach my $theme ( _get_themes('intranet') ) {
146 push @languages, _get_language_dirs($htdocs,$theme);
148 $htdocs = C4::Context->config('opachtdocs');
149 foreach my $theme ( _get_themes('opac') ) {
150 push @languages, _get_language_dirs($htdocs,$theme);
152 my %seen;
153 $seen{$_}++ for @languages;
154 @languages = keys %seen;
156 return _build_languages_arrayref(\@languages,$current_language,\@enabled_languages);
159 =head2 getAllLanguages
161 Returns a reference to an array of hashes:
163 my $alllanguages = getAllLanguages();
164 print "Available translated languages:\n";
165 for my $language(@$alllanguages) {
166 print "$language->{language_code}\n";
167 print "$language->{language_name}\n";
168 print "$language->{language_locale_name}\n";
171 This routine is a wrapper for getLanguages().
173 =cut
175 sub getAllLanguages {
176 return getLanguages(shift);
179 =head2 getLanguages
181 my $lang_arrayref = getLanguages([$lang[, $isFiltered]]);
183 Returns a reference to an array of hashes of languages.
185 - If no parameter is passed to the function, it returns english languages names
186 - If a $lang parameter conforming to RFC4646 syntax is passed, the function returns languages names translated in $lang
187 If a language name is not translated in $lang in database, the function returns english language name
188 - If $isFiltered is set to true, only the detail of the languages selected in system preferences AdvanceSearchLanguages is returned.
190 =cut
192 sub getLanguages {
193 my $lang = shift;
194 my $isFiltered = shift;
196 my @languages_loop;
197 my $dbh=C4::Context->dbh;
198 my $default_language = 'en';
199 my $current_language = $default_language;
200 my $language_list = $isFiltered ? C4::Context->preference("AdvancedSearchLanguages") : undef;
201 if ($lang) {
202 $current_language = regex_lang_subtags($lang)->{'language'};
204 my $sth = $dbh->prepare('SELECT * FROM language_subtag_registry WHERE type=\'language\'');
205 $sth->execute();
206 while (my $language_subtag_registry = $sth->fetchrow_hashref) {
207 my $desc;
208 # check if language name is stored in current language
209 my $sth4= $dbh->prepare("SELECT description FROM language_descriptions WHERE type='language' AND subtag =? AND lang = ?");
210 $sth4->execute($language_subtag_registry->{subtag},$current_language);
211 while (my $language_desc = $sth4->fetchrow_hashref) {
212 $desc=$language_desc->{description};
214 my $sth2= $dbh->prepare("SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag =? AND language_descriptions.lang = ?");
215 if ($desc) {
216 $sth2->execute($language_subtag_registry->{subtag},$current_language);
218 else {
219 $sth2->execute($language_subtag_registry->{subtag},$default_language);
221 my $sth3 = $dbh->prepare("SELECT description FROM language_descriptions WHERE type='language' AND subtag=? AND lang=?");
222 # add the correct description info
223 while (my $language_descriptions = $sth2->fetchrow_hashref) {
224 $sth3->execute($language_subtag_registry->{subtag},$language_subtag_registry->{subtag});
225 my $native_description;
226 while (my $description = $sth3->fetchrow_hashref) {
227 $native_description = $description->{description};
230 # fill in the ISO6329 code
231 $language_subtag_registry->{iso639_2_code} = $language_descriptions->{iso639_2_code};
232 # fill in the native description of the language, as well as the current language's translation of that if it exists
233 if ($native_description) {
234 $language_subtag_registry->{language_description} = $native_description;
235 $language_subtag_registry->{language_description}.=" ($language_descriptions->{description})" if $language_descriptions->{description};
237 else {
238 $language_subtag_registry->{language_description} = $language_descriptions->{description};
241 # Do not push unless valid iso639-2 code
242 if ( $language_subtag_registry->{ iso639_2_code } and ( !$language_list || index ( $language_list, $language_subtag_registry->{ iso639_2_code } ) >= 0) ) {
243 push @languages_loop, $language_subtag_registry;
246 return \@languages_loop;
249 =head2 _get_themes
251 Internal function, returns an array of all available themes.
253 (@themes) = &_get_themes('opac');
254 (@themes) = &_get_themes('intranet');
256 =cut
258 sub _get_themes {
259 my $interface = shift;
260 my $htdocs;
261 my @themes;
262 if ( $interface && $interface eq 'intranet' ) {
263 $htdocs = C4::Context->config('intrahtdocs');
265 else {
266 $htdocs = C4::Context->config('opachtdocs');
268 opendir D, "$htdocs";
269 my @dirlist = readdir D;
270 foreach my $directory (@dirlist) {
271 # if there's an en dir, it's a valid theme
272 -d "$htdocs/$directory/en" and push @themes, $directory;
274 return @themes;
277 =head2 _get_language_dirs
279 Internal function, returns an array of directory names, excluding non-language directories
281 =cut
283 sub _get_language_dirs {
284 my ($htdocs,$theme) = @_;
285 $htdocs //= '';
286 $theme //= '';
287 my @lang_strings;
288 opendir D, "$htdocs/$theme";
289 for my $lang_string ( readdir D ) {
290 next if $lang_string =~/^\./;
291 next if $lang_string eq 'all';
292 next if $lang_string =~/png$/;
293 next if $lang_string =~/js$/;
294 next if $lang_string =~/css$/;
295 next if $lang_string =~/CVS$/;
296 next if $lang_string =~/\.txt$/i; #Don't read the readme.txt !
297 next if $lang_string =~/img|images|famfam|js|less|lib|sound|pdf/;
298 push @lang_strings, $lang_string;
300 return (@lang_strings);
303 =head2 _build_languages_arrayref
305 Internal function for building the ref to array of hashes
307 FIXME: this could be rewritten and simplified using map
309 =cut
311 sub _build_languages_arrayref {
312 my ($translated_languages,$current_language,$enabled_languages) = @_;
313 $current_language //= '';
314 my @translated_languages = @$translated_languages;
315 my @languages_loop; # the final reference to an array of hashrefs
316 my @enabled_languages = @$enabled_languages;
317 # how many languages are enabled, if one, take note, some contexts won't need to display it
318 my %seen_languages; # the language tags we've seen
319 my %found_languages;
320 my $language_groups;
321 my $track_language_groups;
322 my $current_language_regex = regex_lang_subtags($current_language);
323 # Loop through the translated languages
324 for my $translated_language (@translated_languages) {
325 # separate the language string into its subtag types
326 my $language_subtags_hashref = regex_lang_subtags($translated_language);
328 # is this language string 'enabled'?
329 for my $enabled_language (@enabled_languages) {
330 #warn "Checking out if $translated_language eq $enabled_language";
331 $language_subtags_hashref->{'enabled'} = 1 if $translated_language eq $enabled_language;
334 # group this language, key by langtag
335 $language_subtags_hashref->{'sublanguage_current'} = 1 if $translated_language eq $current_language;
336 $language_subtags_hashref->{'rfc4646_subtag'} = $translated_language;
337 $language_subtags_hashref->{'native_description'} = language_get_description($language_subtags_hashref->{language},$language_subtags_hashref->{language},'language');
338 $language_subtags_hashref->{'script_description'} = language_get_description($language_subtags_hashref->{script},$language_subtags_hashref->{'language'},'script');
339 $language_subtags_hashref->{'region_description'} = language_get_description($language_subtags_hashref->{region},$language_subtags_hashref->{'language'},'region');
340 $language_subtags_hashref->{'variant_description'} = language_get_description($language_subtags_hashref->{variant},$language_subtags_hashref->{'language'},'variant');
341 $track_language_groups->{$language_subtags_hashref->{'language'}}++;
342 push ( @{ $language_groups->{$language_subtags_hashref->{language}} }, $language_subtags_hashref );
344 # $key is a language subtag like 'en'
346 my %idx = map { $enabled_languages->[$_] => $_ } reverse 0 .. @$enabled_languages-1;
347 my @ordered_keys = sort {
348 my $aa = $language_groups->{$a}->[0]->{rfc4646_subtag};
349 my $bb = $language_groups->{$b}->[0]->{rfc4646_subtag};
350 ( exists $idx{$aa} and exists $idx{$bb} and ( $idx{$aa} cmp $idx{$bb} ) )
351 || ( exists $idx{$aa} and exists $idx{$bb} )
352 || exists $idx{$bb}
353 } keys %$language_groups;
355 for my $key ( @ordered_keys ) {
356 my $value = $language_groups->{$key};
357 # is this language group enabled? are any of the languages within it enabled?
358 my $enabled;
359 for my $enabled_language (@enabled_languages) {
360 my $regex_enabled_language = regex_lang_subtags($enabled_language);
361 $enabled = 1 if $key eq ($regex_enabled_language->{language} // '');
363 push @languages_loop, {
364 # this is only use if there is one
365 rfc4646_subtag => @$value[0]->{rfc4646_subtag},
366 native_description => language_get_description($key,$key,'language'),
367 language => $key,
368 sublanguages_loop => $value,
369 plural => $track_language_groups->{$key} >1 ? 1 : 0,
370 current => ($current_language_regex->{language} // '') eq $key ? 1 : 0,
371 group_enabled => $enabled,
374 return \@languages_loop;
377 sub language_get_description {
378 my ($script,$lang,$type) = @_;
379 my $dbh = C4::Context->dbh;
380 my $desc;
381 my $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
382 #warn "QUERY: SELECT description FROM language_descriptions WHERE subtag=$script AND lang=$lang AND type=$type";
383 $sth->execute($script,$lang,$type);
384 while (my $descriptions = $sth->fetchrow_hashref) {
385 $desc = $descriptions->{'description'};
387 unless ($desc) {
388 $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
389 $sth->execute($script,'en',$type);
390 while (my $descriptions = $sth->fetchrow_hashref) {
391 $desc = $descriptions->{'description'};
394 return $desc;
396 =head2 regex_lang_subtags
398 This internal sub takes a string composed according to RFC 4646 as
399 an input and returns a reference to a hash containing keys and values
400 for ( language, script, region, variant, extension, privateuse )
402 =cut
404 sub regex_lang_subtags {
405 my $string = shift;
407 # Regex for recognizing RFC 4646 well-formed tags
408 # http://www.rfc-editor.org/rfc/rfc4646.txt
410 # regexes based on : http://unicode.org/cldr/data/tools/java/org/unicode/cldr/util/data/langtagRegex.txt
411 # The structure requires no forward references, so it reverses the order.
412 # The uppercase comments are fragments copied from RFC 4646
414 # Note: the tool requires that any real "=" or "#" or ";" in the regex be escaped.
416 my $alpha = qr/[a-zA-Z]/ ; # ALPHA
417 my $digit = qr/[0-9]/ ; # DIGIT
418 my $alphanum = qr/[a-zA-Z0-9]/ ; # ALPHA / DIGIT
419 my $x = qr/[xX]/ ; # private use singleton
420 my $singleton = qr/[a-w y-z A-W Y-Z]/ ; # other singleton
421 my $s = qr/[-]/ ; # separator -- lenient parsers will use [-_]
423 # Now do the components. The structure is slightly different to allow for capturing the right components.
424 # The notation (?:....) is a non-capturing version of (...): so the "?:" can be deleted if someone doesn't care about capturing.
426 my $extlang = qr{(?: $s $alpha{3} )}x ; # *3("-" 3ALPHA)
427 my $language = qr{(?: $alpha{2,3} | $alpha{4,8} )}x ;
428 #my $language = qr{(?: $alpha{2,3}$extlang{0,3} | $alpha{4,8} )}x ; # (2*3ALPHA [ extlang ]) / 4ALPHA / 5*8ALPHA
430 my $script = qr{(?: $alpha{4} )}x ; # 4ALPHA
432 my $region = qr{(?: $alpha{2} | $digit{3} )}x ; # 2ALPHA / 3DIGIT
434 my $variantSub = qr{(?: $digit$alphanum{3} | $alphanum{5,8} )}x ; # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
435 my $variant = qr{(?: $variantSub (?: $s$variantSub )* )}x ; # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
437 my $extensionSub = qr{(?: $singleton (?: $s$alphanum{2,8} )+ )}x ; # singleton 1*("-" (2*8alphanum))
438 my $extension = qr{(?: $extensionSub (?: $s$extensionSub )* )}x ; # singleton 1*("-" (2*8alphanum))
440 my $privateuse = qr{(?: $x (?: $s$alphanum{1,8} )+ )}x ; # ("x"/"X") 1*("-" (1*8alphanum))
442 # Define certain grandfathered codes, since otherwise the regex is pretty useless.
443 # Since these are limited, this is safe even later changes to the registry --
444 # the only oddity is that it might change the type of the tag, and thus
445 # the results from the capturing groups.
446 # http://www.iana.org/assignments/language-subtag-registry
447 # Note that these have to be compared case insensitively, requiring (?i) below.
449 my $grandfathered = qr{(?: (?i)
450 en $s GB $s oed
451 | i $s (?: ami | bnn | default | enochian | hak | klingon | lux | mingo | navajo | pwn | tao | tay | tsu )
452 | sgn $s (?: BE $s fr | BE $s nl | CH $s de)
453 )}x;
455 # For well-formedness, we don't need the ones that would otherwise pass, so they are commented out here
457 # | art $s lojban
458 # | cel $s gaulish
459 # | en $s (?: boont | GB $s oed | scouse )
460 # | no $s (?: bok | nyn)
461 # | zh $s (?: cmn | cmn $s Hans | cmn $s Hant | gan | guoyu | hakka | min | min $s nan | wuu | xiang | yue)
463 # Here is the final breakdown, with capturing groups for each of these components
464 # The language, variants, extensions, grandfathered, and private-use may have interior '-'
466 #my $root = qr{(?: ($language) (?: $s ($script) )? 40% (?: $s ($region) )? 40% (?: $s ($variant) )? 10% (?: $s ($extension) )? 5% (?: $s ($privateuse) )? 5% ) 90% | ($grandfathered) 5% | ($privateuse) 5% };
468 $string =~ qr{^ (?:($language)) (?:$s($script))? (?:$s($region))? (?:$s($variant))? (?:$s($extension))? (?:$s($privateuse))? $}xi; # |($grandfathered) | ($privateuse) $}xi;
469 my %subtag = (
470 'rfc4646_subtag' => $string,
471 'language' => $1,
472 'script' => $2,
473 'region' => $3,
474 'variant' => $4,
475 'extension' => $5,
476 'privateuse' => $6,
478 return \%subtag;
481 # Script Direction Resources:
482 # http://www.w3.org/International/questions/qa-scripts
483 sub get_bidi {
484 my ($language_script)= @_;
485 my $dbh = C4::Context->dbh;
486 my $bidi;
487 my $sth = $dbh->prepare('SELECT bidi FROM language_script_bidi WHERE rfc4646_subtag=?');
488 $sth->execute($language_script);
489 while (my $result = $sth->fetchrow_hashref) {
490 $bidi = $result->{'bidi'};
492 return $bidi;
495 sub accept_language {
496 # referenced http://search.cpan.org/src/CGILMORE/I18N-AcceptLanguage-1.04/lib/I18N/AcceptLanguage.pm
497 my ($clientPreferences,$supportedLanguages) = @_;
498 my @languages = ();
499 if ($clientPreferences) {
500 # There should be no whitespace anways, but a cleanliness/sanity check
501 $clientPreferences =~ s/\s//g;
502 # Prepare the list of client-acceptable languages
503 foreach my $tag (split(/,/, $clientPreferences)) {
504 my ($language, $quality) = split(/\;/, $tag);
505 $quality =~ s/^q=//i if $quality;
506 $quality = 1 unless $quality;
507 next if $quality <= 0;
508 # We want to force the wildcard to be last
509 $quality = 0 if ($language eq '*');
510 # Pushing lowercase language here saves processing later
511 push(@languages, { quality => $quality,
512 language => $language,
513 lclanguage => lc($language) });
515 } else {
516 carp "accept_language(x,y) called with no clientPreferences (x).";
518 # Prepare the list of server-supported languages
519 my %supportedLanguages = ();
520 my %secondaryLanguages = ();
521 foreach my $language (@$supportedLanguages) {
522 # warn "Language supported: " . $language->{language};
523 my $subtag = $language->{rfc4646_subtag};
524 $supportedLanguages{lc($subtag)} = $subtag;
525 if ( $subtag =~ /^([^-]+)-?/ ) {
526 $secondaryLanguages{lc($1)} = $subtag;
530 # Reverse sort the list, making best quality at the front of the array
531 @languages = sort { $b->{quality} <=> $a->{quality} } @languages;
532 my $secondaryMatch = '';
533 foreach my $tag (@languages) {
534 if (exists($supportedLanguages{$tag->{lclanguage}})) {
535 # Client en-us eq server en-us
536 return $supportedLanguages{$tag->{language}} if exists($supportedLanguages{$tag->{language}});
537 return $supportedLanguages{$tag->{lclanguage}};
538 } elsif (exists($secondaryLanguages{$tag->{lclanguage}})) {
539 # Client en eq server en-us
540 return $secondaryLanguages{$tag->{language}} if exists($secondaryLanguages{$tag->{language}});
541 return $supportedLanguages{$tag->{lclanguage}};
542 } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
543 # Client en-gb eq server en-us
544 $secondaryMatch = $secondaryLanguages{$1};
545 } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
546 # FIXME: We just checked the exact same conditional!
547 # Client en-us eq server en
548 $secondaryMatch = $supportedLanguages{$1};
549 } elsif ($tag->{lclanguage} eq '*') {
550 # * matches every language not already specified.
551 # It doesn't care which we pick, so let's pick the default,
552 # if available, then the first in the array.
553 #return $acceptor->defaultLanguage() if $acceptor->defaultLanguage();
554 return $supportedLanguages->[0];
557 # No primary matches. Secondary? (ie, en-us requested and en supported)
558 return $secondaryMatch if $secondaryMatch;
559 return undef; # else, we got nothing.
562 =head2 getlanguage
564 Select a language based on the URL parameter 'language', a cookie,
565 syspref available languages & browser
567 =cut
569 sub getlanguage {
570 my ($cgi) = @_;
572 my $memory_cache = Koha::Cache::Memory::Lite->get_instance();
573 my $cache_key = "getlanguage";
574 unless ( $cgi and $cgi->param('language') ) {
575 my $cached = $memory_cache->get_from_cache($cache_key);
576 return $cached if $cached;
579 $cgi //= new CGI;
580 my $interface = C4::Context->interface;
581 my $theme = C4::Context->preference( ( $interface eq 'opac' ) ? 'opacthemes' : 'template' );
582 my $language;
584 my $preference_to_check =
585 $interface eq 'intranet' ? 'language' : 'opaclanguages';
586 # Get the available/valid languages list
587 my @languages;
588 my $preference_value = C4::Context->preference($preference_to_check);
589 if ($preference_value) {
590 @languages = split /,/, $preference_value;
593 # Chose language from the URL
594 my $cgi_param_language = $cgi->param( 'language' );
595 if ( defined $cgi_param_language && any { $_ eq $cgi_param_language } @languages) {
596 $language = $cgi_param_language;
599 # cookie
600 if (not $language and my $cgi_cookie_language = $cgi->cookie('KohaOpacLanguage') ) {
601 ( $language = $cgi_cookie_language ) =~ s/[^a-zA-Z_-]*//; # sanitize cookie
604 # HTTP_ACCEPT_LANGUAGE
605 if ( !$language && $ENV{HTTP_ACCEPT_LANGUAGE} ) {
606 $language = accept_language( $ENV{HTTP_ACCEPT_LANGUAGE},
607 getTranslatedLanguages( $interface, $theme ) );
610 # Ignore a lang not selected in sysprefs
611 if ( $language && not any { $_ eq $language } @languages ) {
612 $language = undef;
615 # Pick the first selected syspref language
616 $language = shift @languages unless $language;
618 # Fall back to English if necessary
619 $language ||= 'en';
621 $memory_cache->set_in_cache( $cache_key, $language );
622 return $language;
625 =head2 get_rfc4646_from_iso639
627 Select a language rfc4646 code given an iso639 code
629 =cut
631 sub get_rfc4646_from_iso639 {
633 my $iso_code = shift;
634 my $rfc_subtag = Koha::Database->new()->schema->resultset('LanguageRfc4646ToIso639')->find({iso639_2_code=>$iso_code});
635 if ( $rfc_subtag ) {
636 return $rfc_subtag->rfc4646_subtag;
637 } else {
638 return;
645 __END__
647 =head1 AUTHOR
649 Joshua Ferraro
651 =cut