use Memoize because Memcache::Memoize is slow for me
[koha.git] / C4 / Languages.pm
index 6bdf4f1..b31812e 100644 (file)
@@ -2,7 +2,7 @@ package C4::Languages;
 
 # Copyright 2006 (C) LibLime
 # Joshua Ferraro <jmf@liblime.com>
-#
+# Portions Copyright 2009 Chris Cormack and the Koha Dev Team
 # This file is part of Koha.
 #
 # Koha is free software; you can redistribute it and/or modify it under the
@@ -14,16 +14,51 @@ package C4::Languages;
 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
 #
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA  02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 
-# $Id$
 
-use strict; use warnings; #FIXME: turn off warnings before release
-require Exporter;
+use strict; 
+#use warnings; FIXME - Bug 2505
+use Carp;
 use C4::Context;
-use vars qw($VERSION @ISA @EXPORT);
+use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $DEBUG);
+
+eval {
+    my $servers = C4::Context->config('memcached_servers');
+    if ($servers) {
+        require Memoize::Memcached;
+        import Memoize::Memcached qw(memoize_memcached);
+        my $memcached = {
+            servers    => [ $servers ],
+            key_prefix => C4::Context->config('memcached_namespace') || 'koha',
+        };
+
+        memoize_memcached('getTranslatedLanguages', memcached => $memcached, expire_time => 600); #cache for 10 minutes
+        memoize_memcached('getFrameworkLanguages' , memcached => $memcached, expire_time => 600);
+        memoize_memcached('getAllLanguages',        memcached => $memcached, expire_time => 600);
+    }
+};
+
+use Memoize;
+memoize('getTranslatedLanguages');
+memoize('getFrameworkLanguages');
+memoize('getAllLanguages');
+
+BEGIN {
+    $VERSION = 3.00;
+    require Exporter;
+    @ISA    = qw(Exporter);
+    @EXPORT = qw(
+        &getFrameworkLanguages
+        &getTranslatedLanguages
+        &getAllLanguages
+    );
+    @EXPORT_OK = qw(getFrameworkLanguages getTranslatedLanguages getAllLanguages get_bidi regex_lang_subtags language_get_description accept_language);
+    $DEBUG = 0;
+}
 
 =head1 NAME
 
@@ -35,18 +70,9 @@ use C4::Languages;
 
 =head1 DESCRIPTION
 
-=head1 FUNCTIONS
-
 =cut
 
-@ISA    = qw(Exporter);
-@EXPORT = qw(
-  &getFrameworkLanguages
-  &getTranslatedLanguages
-  &getAllLanguages
-  );
-
-my $DEBUG = 0;
+=head1 FUNCTIONS
 
 =head2 getFrameworkLanguages
 
@@ -75,11 +101,12 @@ sub getFrameworkLanguages {
     # pull out all data for the dir names that exist
     for my $dirname (@listdir) {
         for my $language_set (@$all_languages) {
-            my $language_name = $language_set->{language_name};
-            my $language_locale_name = $language_set->{language_locale_name};
 
             if ($dirname eq $language_set->{language_code}) {
-                push @languages, {'language_code'=>$dirname, 'language_name'=>$language_name, 'language_locale_name'=>$language_locale_name}
+                push @languages, {
+                    'language_code'=>$dirname, 
+                    'language_description'=>$language_set->{language_description}, 
+                    'native_descrition'=>$language_set->{language_native_description} }
             }
         }
     }
@@ -91,7 +118,7 @@ sub getFrameworkLanguages {
 Returns a reference to an array of hashes:
 
  my $languages = getTranslatedLanguages();
- print "Available translated langauges:\n";
+ print "Available translated languages:\n";
  for my $language(@$trlanguages) {
     print "$language->{language_code}\n"; # language code in iso 639-2
     print "$language->{language_name}\n"; # language name in native script
@@ -101,39 +128,38 @@ Returns a reference to an array of hashes:
 =cut
 
 sub getTranslatedLanguages {
-    my ($interface, $theme) = @_;
+    my ($interface, $theme, $current_language, $which) = @_;
     my $htdocs;
     my $all_languages = getAllLanguages();
     my @languages;
-    my $lang;
-    
-    if ( $interface eq 'opac' ) {
+    my @enabled_languages;
+    if ($interface && $interface eq 'opac' ) {
+        @enabled_languages = split ",", C4::Context->preference('opaclanguages');
         $htdocs = C4::Context->config('opachtdocs');
         if ( $theme and -d "$htdocs/$theme" ) {
             (@languages) = _get_language_dirs($htdocs,$theme);
-            return _get_final_languages($all_languages,@languages);
         }
         else {
             for my $theme ( _get_themes('opac') ) {
                 push @languages, _get_language_dirs($htdocs,$theme);
             }
-            return _get_final_languages($all_languages,@languages);
         }
     }
-    elsif ( $interface eq 'intranet' ) {
+    elsif ($interface && $interface eq 'intranet' ) {
+        @enabled_languages = split ",", C4::Context->preference('language');
         $htdocs = C4::Context->config('intrahtdocs');
         if ( $theme and -d "$htdocs/$theme" ) {
             @languages = _get_language_dirs($htdocs,$theme);
-            return _get_final_languages($all_languages,@languages);
         }
         else {
-            foreach my $theme ( _get_themes('opac') ) {
+            foreach my $theme ( _get_themes('intranet') ) {
                 push @languages, _get_language_dirs($htdocs,$theme);
             }
-            return _get_final_languages($all_languages,@languages);
         }
     }
     else {
+        @enabled_languages = split ",", C4::Context->preference('opaclanguages');
         my $htdocs = C4::Context->config('intrahtdocs');
         foreach my $theme ( _get_themes('intranet') ) {
             push @languages, _get_language_dirs($htdocs,$theme);
@@ -142,8 +168,11 @@ sub getTranslatedLanguages {
         foreach my $theme ( _get_themes('opac') ) {
             push @languages, _get_language_dirs($htdocs,$theme);
         }
-        return _get_final_languages($all_languages,@languages);
+        my %seen;
+        $seen{$_}++ for @languages;
+        @languages = keys %seen;
     }
+    return _build_languages_arrayref($all_languages,\@languages,$current_language,\@enabled_languages);
 }
 
 =head2 getAllLanguages
@@ -151,7 +180,7 @@ sub getTranslatedLanguages {
 Returns a reference to an array of hashes:
 
  my $alllanguages = getAllLanguages();
- print "Available translated langauges:\n";
+ print "Available translated languages:\n";
  for my $language(@$alllanguages) {
     print "$language->{language_code}\n";
     print "$language->{language_name}\n";
@@ -161,202 +190,41 @@ Returns a reference to an array of hashes:
 =cut
 
 sub getAllLanguages {
-    my $languages_loop = [
-        {
-            language_code          => "",
-            language_name => "No Limit",
-            language_locale_name   => "",
-            selected       => "selected",
-        },
-        {
-            language_code          => "ara",
-            language_name =>
-              "&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;",
-            language_locale_name => "Arabic",
-            ,
-        },
-        {
-            language_code          => "bul",
-            language_name =>
-              "&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;",
-            language_locale_name => "Bulgarian",
-            ,
-        },
-        {
-            language_code          => "chi",
-            language_name => "&#20013;&#25991;",
-            language_locale_name   => "Chinese",
-            ,
-        },
-        {
-            language_code          => "scr",
-            language_name => "Hrvatski",
-            language_locale_name   => "Croatian",
-            ,
-        },
-        {
-            language_code          => "cze",
-            language_name => "&#x010D;e&#353;tina",
-            language_locale_name   => "Czech",
-            ,
-        },
-        {
-            language_code          => "dan",
-            language_name => "D&aelig;nsk",
-            language_locale_name   => "Danish",
-            ,
-        },
-        {
-            language_code          => "dut",
-            language_name => "ned&#601;rl&#593;ns",
-            language_locale_name   => "Dutch",
-            ,
-        },
-        {
-            language_code          => "en",
-            language_name => "English",
-            language_locale_name   => "English",
-            ,
-        },
-        {
-            language_code          => "fr",
-            language_name => "Fran&ccedil;ais",
-            language_locale_name   => "French",
-            ,
-        },
-        {
-            language_code          => "ger",
-            language_name => "Deutsch",
-            language_locale_name   => "German",
-            ,
-        },
-        {
-            language_code          => "gre",
-            language_name =>
-              "&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;",
-            language_locale_name => "Greek, Modern [1453- ]",
-            ,
-        },
-        {
-            language_code          => "heb",
-            language_name => "&#1506;&#1489;&#1512;&#1497;&#1514;",
-            language_locale_name   => "Hebrew",
-            ,
-        },
-        {
-            language_code          => "hin",
-            language_name => "&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;",
-            language_locale_name   => "Hindi",
-            ,
-        },
-        {
-            language_code          => "hun",
-            language_name => "Magyar",
-            language_locale_name   => "Hungarian",
-            ,
-        },
-        {
-            language_code          => "ind",
-            language_name => "",
-            language_locale_name   => "Indonesian",
-            ,
-        },
-        {
-            language_code          => "ita",
-            language_name => "Italiano",
-            language_locale_name   => "Italian",
-            ,
-        },
-        {
-            language_code          => "jpn",
-            language_name => "&#26085;&#26412;&#35486;",
-            language_locale_name   => "Japanese",
-            ,
-        },
-        {
-            language_code          => "kor",
-            language_name => "&#54620;&#44397;&#50612;",
-            language_locale_name   => "Korean",
-            ,
-        },
-        {
-            language_code          => "lat",
-            language_name => "Latina",
-            language_locale_name   => "Latin",
-            ,
-        },
-        {
-            language_code          => "nor",
-            language_name => "Norsk",
-            language_locale_name   => "Norwegian",
-            ,
-        },
-        {
-            language_code          => "per",
-            language_name => "&#1601;&#1575;&#1585;&#1587;&#1609;",
-            language_locale_name   => "Persian",
-            ,
-        },
-        {
-            language_code          => "pol",
-            language_name => "Polski",
-            language_locale_name   => "Polish",
-            ,
-        },
-        {
-            language_code          => "por",
-            language_name => "Portugu&ecirc;s",
-            language_locale_name   => "Portuguese",
-            ,
-        },
-        {
-            language_code          => "rum",
-            language_name => "Rom&acirc;n&#259;",
-            language_locale_name   => "Romanian",
-            ,
-        },
-        {
-            language_code          => "rus",
-            language_name =>
-              "&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;",
-            language_locale_name => "Russian",
-            ,
-        },
-        {
-            language_code          => "spa",
-            language_name => "Espa&ntilde;ol",
-            language_locale_name   => "Spanish",
-            ,
-        },
-        {
-            language_code          => "swe",
-            language_name => "Svenska",
-            language_locale_name   => "Swedish",
-            ,
-        },
-        {
-            language_code          => "tha",
-            language_name =>
-              "&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;",
-            language_locale_name => "Thai",
-            ,
-        },
-        {
-            language_code          => "tur",
-            language_name => "T&uuml;rk&ccedil;e",
-            language_locale_name   => "Turkish",
-            ,
-        },
-        {
-            language_code          => "ukr",
-            language_name =>
-"&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;",
-            language_locale_name => "Ukrainian",
-            ,
-        },
-
-    ];
-    return $languages_loop;
+    my @languages_loop;
+    my $dbh=C4::Context->dbh;
+    my $current_language = shift || 'en';
+    my $sth = $dbh->prepare('SELECT * FROM language_subtag_registry WHERE type=\'language\'');
+    $sth->execute();
+    while (my $language_subtag_registry = $sth->fetchrow_hashref) {
+
+        # pull out all the script descriptions for each language
+        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 = ?");
+        $sth2->execute($language_subtag_registry->{subtag},$current_language);
+
+        my $sth3 = $dbh->prepare("SELECT description FROM language_descriptions WHERE type='language' AND subtag=? AND lang=?");
+
+        # add the correct description info
+        while (my $language_descriptions = $sth2->fetchrow_hashref) {
+            $sth3->execute($language_subtag_registry->{subtag},$language_subtag_registry->{subtag});
+            my $native_description;
+            while (my $description = $sth3->fetchrow_hashref) {
+                $native_description = $description->{description};
+            }
+
+            # fill in the ISO6329 code
+            $language_subtag_registry->{iso639_2_code} = $language_descriptions->{iso639_2_code};
+            # fill in the native description of the language, as well as the current language's translation of that if it exists
+            if ($native_description) {
+                $language_subtag_registry->{language_description} = $native_description;
+                $language_subtag_registry->{language_description}.=" ($language_descriptions->{description})" if $language_descriptions->{description};
+            }
+            else {
+                $language_subtag_registry->{language_description} = $language_descriptions->{description};
+            }
+        }
+        push @languages_loop, $language_subtag_registry;
+    }
+    return \@languages_loop;
 }
 
 =head2 _get_themes
@@ -395,23 +263,22 @@ Internal function, returns an array of directory names, excluding non-language d
 
 sub _get_language_dirs {
     my ($htdocs,$theme) = @_;
-    my @languages;
+    my @lang_strings;
     opendir D, "$htdocs/$theme";
-    for my $language ( readdir D ) {
-        next if $language =~/^\./;
-        next if $language eq 'all';
-        next if $language =~/png$/;
-        next if $language =~/css$/;
-        next if $language =~/CVS$/;
-        next if $language =~/itemtypeimg$/;
-        next if $language =~/\.txt$/i;     #Don't read the readme.txt !
-        next if $language eq 'images';
-        push @languages, $language;
+    for my $lang_string ( readdir D ) {
+        next if $lang_string =~/^\./;
+        next if $lang_string eq 'all';
+        next if $lang_string =~/png$/;
+        next if $lang_string =~/css$/;
+        next if $lang_string =~/CVS$/;
+        next if $lang_string =~/\.txt$/i;     #Don't read the readme.txt !
+        next if $lang_string =~/img|images|famfam|sound|pdf/;
+        push @lang_strings, $lang_string;
     }
-        return (@languages);
+        return (@lang_strings);
 }
 
-=head2 _get_final_languages 
+=head2 _build_languages_arrayref 
 
 Internal function for building the ref to array of hashes
 
@@ -419,23 +286,245 @@ FIXME: this could be rewritten and simplified using map
 
 =cut
 
-sub _get_final_languages {
-        my ($all_languages,@languages) = @_;
-        my @final_languages;
-        my %seen_languages;
-        for my $language (@languages) {
-            unless ($seen_languages{$language}) {
-                for my $language_code (@$all_languages) {
-                    if ($language eq $language_code->{'language_code'}) {
-                        push @final_languages, $language_code;
-                    }
-                }
-                $seen_languages{$language}++;
+sub _build_languages_arrayref {
+        my ($all_languages,$translated_languages,$current_language,$enabled_languages) = @_;
+        my @translated_languages = @$translated_languages;
+        my @languages_loop; # the final reference to an array of hashrefs
+        my @enabled_languages = @$enabled_languages;
+        # how many languages are enabled, if one, take note, some contexts won't need to display it
+        my %seen_languages; # the language tags we've seen
+        my %found_languages;
+        my $language_groups;
+        my $track_language_groups;
+        my $current_language_regex = regex_lang_subtags($current_language);
+        # Loop through the translated languages
+        for my $translated_language (@translated_languages) {
+            # separate the language string into its subtag types
+            my $language_subtags_hashref = regex_lang_subtags($translated_language);
+
+            # is this language string 'enabled'?
+            for my $enabled_language (@enabled_languages) {
+                #warn "Checking out if $translated_language eq $enabled_language";
+                $language_subtags_hashref->{'enabled'} = 1 if $translated_language eq $enabled_language;
+            }
+            
+            # group this language, key by langtag
+            $language_subtags_hashref->{'sublanguage_current'} = 1 if $translated_language eq $current_language;
+            $language_subtags_hashref->{'rfc4646_subtag'} = $translated_language;
+            $language_subtags_hashref->{'native_description'} = language_get_description($language_subtags_hashref->{language},$language_subtags_hashref->{language},'language');
+            $language_subtags_hashref->{'script_description'} = language_get_description($language_subtags_hashref->{script},$language_subtags_hashref->{'language'},'script');
+            $language_subtags_hashref->{'region_description'} = language_get_description($language_subtags_hashref->{region},$language_subtags_hashref->{'language'},'region');
+            $language_subtags_hashref->{'variant_description'} = language_get_description($language_subtags_hashref->{variant},$language_subtags_hashref->{'language'},'variant');
+            $track_language_groups->{$language_subtags_hashref->{'language'}}++;
+            push ( @{ $language_groups->{$language_subtags_hashref->{language}} }, $language_subtags_hashref );
+        }
+        # $key is a language subtag like 'en'
+        while( my ($key, $value) = each %$language_groups) {
+
+            # is this language group enabled? are any of the languages within it enabled?
+            my $enabled;
+            for my $enabled_language (@enabled_languages) {
+                my $regex_enabled_language = regex_lang_subtags($enabled_language);
+                $enabled = 1 if $key eq $regex_enabled_language->{language};
             }
+            push @languages_loop,  {
+                            # this is only use if there is one
+                            rfc4646_subtag => @$value[0]->{rfc4646_subtag},
+                            native_description => language_get_description($key,$key,'language'),
+                            language => $key,
+                            sublanguages_loop => $value,
+                            plural => $track_language_groups->{$key} >1 ? 1 : 0,
+                            current => $current_language_regex->{language} eq $key ? 1 : 0,
+                            group_enabled => $enabled,
+                           };
+        }
+        return \@languages_loop;
+}
+
+sub language_get_description {
+    my ($script,$lang,$type) = @_;
+    my $dbh = C4::Context->dbh;
+    my $desc;
+    my $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
+    #warn "QUERY: SELECT description FROM language_descriptions WHERE subtag=$script AND lang=$lang AND type=$type";
+    $sth->execute($script,$lang,$type);
+    while (my $descriptions = $sth->fetchrow_hashref) {
+        $desc = $descriptions->{'description'};
+    }
+    unless ($desc) {
+        $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
+        $sth->execute($script,'en',$type);
+        while (my $descriptions = $sth->fetchrow_hashref) {
+            $desc = $descriptions->{'description'};
         }
-        return \@final_languages;
+    }
+    return $desc;
+}
+=head2 regex_lang_subtags
+
+This internal sub takes a string composed according to RFC 4646 as
+an input and returns a reference to a hash containing keys and values
+for ( language, script, region, variant, extension, privateuse )
+
+=cut
+
+sub regex_lang_subtags {
+    my $string = shift;
+
+    # Regex for recognizing RFC 4646 well-formed tags
+    # http://www.rfc-editor.org/rfc/rfc4646.txt
+
+    # regexes based on : http://unicode.org/cldr/data/tools/java/org/unicode/cldr/util/data/langtagRegex.txt
+    # The structure requires no forward references, so it reverses the order.
+    # The uppercase comments are fragments copied from RFC 4646
+    #
+    # Note: the tool requires that any real "=" or "#" or ";" in the regex be escaped.
+
+    my $alpha   = qr/[a-zA-Z]/ ;    # ALPHA
+    my $digit   = qr/[0-9]/ ;   # DIGIT
+    my $alphanum    = qr/[a-zA-Z0-9]/ ; # ALPHA / DIGIT
+    my $x   = qr/[xX]/ ;    # private use singleton
+    my $singleton = qr/[a-w y-z A-W Y-Z]/ ; # other singleton
+    my $s   = qr/[-]/ ; # separator -- lenient parsers will use [-_]
+
+    # Now do the components. The structure is slightly different to allow for capturing the right components.
+    # The notation (?:....) is a non-capturing version of (...): so the "?:" can be deleted if someone doesn't care about capturing.
+
+    my $extlang = qr{(?: $s $alpha{3} )}x ; # *3("-" 3ALPHA)
+    my $language    = qr{(?: $alpha{2,3} | $alpha{4,8} )}x ;
+    #my $language   = qr{(?: $alpha{2,3}$extlang{0,3} | $alpha{4,8} )}x ;   # (2*3ALPHA [ extlang ]) / 4ALPHA / 5*8ALPHA
+
+    my $script  = qr{(?: $alpha{4} )}x ;    # 4ALPHA 
+
+    my $region  = qr{(?: $alpha{2} | $digit{3} )}x ;     # 2ALPHA / 3DIGIT
+
+    my $variantSub  = qr{(?: $digit$alphanum{3} | $alphanum{5,8} )}x ;  # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
+    my $variant = qr{(?: $variantSub (?: $s$variantSub )* )}x ; # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
+
+    my $extensionSub    = qr{(?: $singleton (?: $s$alphanum{2,8} )+ )}x ;   # singleton 1*("-" (2*8alphanum))
+    my $extension   = qr{(?: $extensionSub (?: $s$extensionSub )* )}x ; # singleton 1*("-" (2*8alphanum))
+
+    my $privateuse  = qr{(?: $x (?: $s$alphanum{1,8} )+ )}x ;   # ("x"/"X") 1*("-" (1*8alphanum))
+
+    # Define certain grandfathered codes, since otherwise the regex is pretty useless.
+    # Since these are limited, this is safe even later changes to the registry --
+    # the only oddity is that it might change the type of the tag, and thus
+    # the results from the capturing groups.
+    # http://www.iana.org/assignments/language-subtag-registry
+    # Note that these have to be compared case insensitively, requiring (?i) below.
+
+    my $grandfathered   = qr{(?: (?i)
+        en $s GB $s oed
+    |   i $s (?: ami | bnn | default | enochian | hak | klingon | lux | mingo | navajo | pwn | tao | tay | tsu )
+    |   sgn $s (?: BE $s fr | BE $s nl | CH $s de)
+)}x;
+
+    # For well-formedness, we don't need the ones that would otherwise pass, so they are commented out here
+
+    #   |   art $s lojban
+    #   |   cel $s gaulish
+    #   |   en $s (?: boont | GB $s oed | scouse )
+    #   |   no $s (?: bok | nyn)
+    #   |   zh $s (?: cmn | cmn $s Hans | cmn $s Hant | gan | guoyu | hakka | min | min $s nan | wuu | xiang | yue)
+
+    # Here is the final breakdown, with capturing groups for each of these components
+    # The language, variants, extensions, grandfathered, and private-use may have interior '-'
+
+    #my $root = qr{(?: ($language) (?: $s ($script) )? 40% (?: $s ($region) )? 40% (?: $s ($variant) )? 10% (?: $s ($extension) )? 5% (?: $s ($privateuse) )? 5% ) 90% | ($grandfathered) 5% | ($privateuse) 5% };
+
+    $string =~  qr{^ (?:($language)) (?:$s($script))? (?:$s($region))?  (?:$s($variant))?  (?:$s($extension))?  (?:$s($privateuse))? $}xi;  # |($grandfathered) | ($privateuse) $}xi;
+    my %subtag = (
+        'rfc4646_subtag' => $string,
+        'language' => $1,
+        'script' => $2,
+        'region' => $3,
+        'variant' => $4,
+        'extension' => $5,
+        'privateuse' => $6,
+    );
+    return \%subtag;
 }
 
+# Script Direction Resources:
+# http://www.w3.org/International/questions/qa-scripts
+sub get_bidi {
+    my ($language_script)= @_;
+    my $dbh = C4::Context->dbh;
+    my $bidi;
+    my $sth = $dbh->prepare('SELECT bidi FROM language_script_bidi WHERE rfc4646_subtag=?');
+    $sth->execute($language_script);
+    while (my $result = $sth->fetchrow_hashref) {
+        $bidi = $result->{'bidi'};
+    }
+    return $bidi;
+};
+
+sub accept_language {
+    # referenced http://search.cpan.org/src/CGILMORE/I18N-AcceptLanguage-1.04/lib/I18N/AcceptLanguage.pm
+    my ($clientPreferences,$supportedLanguages) = @_;
+    my @languages = ();
+    if ($clientPreferences) {
+        # There should be no whitespace anways, but a cleanliness/sanity check
+        $clientPreferences =~ s/\s//g;
+        # Prepare the list of client-acceptable languages
+        foreach my $tag (split(/,/, $clientPreferences)) {
+            my ($language, $quality) = split(/\;/, $tag);
+            $quality =~ s/^q=//i if $quality;
+            $quality = 1 unless $quality;
+            next if $quality <= 0;
+            # We want to force the wildcard to be last
+            $quality = 0 if ($language eq '*');
+            # Pushing lowercase language here saves processing later
+            push(@languages, { quality => $quality,
+               language => $language,
+               lclanguage => lc($language) });
+        }
+    } else {
+        carp "accept_language(x,y) called with no clientPreferences (x).";
+    }
+    # Prepare the list of server-supported languages
+    my %supportedLanguages = ();
+    my %secondaryLanguages = ();
+    foreach my $language (@$supportedLanguages) {
+        # warn "Language supported: " . $language->{language};
+        my $subtag = $language->{rfc4646_subtag};
+        $supportedLanguages{lc($subtag)} = $subtag;
+        if ( $subtag =~ /^([^-]+)-?/ ) {
+            $secondaryLanguages{lc($1)} = $subtag;
+        }
+    }
+
+    # Reverse sort the list, making best quality at the front of the array
+    @languages = sort { $b->{quality} <=> $a->{quality} } @languages;
+    my $secondaryMatch = '';
+    foreach my $tag (@languages) {
+        if (exists($supportedLanguages{$tag->{lclanguage}})) {
+            # Client en-us eq server en-us
+            return $supportedLanguages{$tag->{language}} if exists($supportedLanguages{$tag->{language}});
+            return $supportedLanguages{$tag->{lclanguage}};
+        } elsif (exists($secondaryLanguages{$tag->{lclanguage}})) {
+            # Client en eq server en-us
+            return $secondaryLanguages{$tag->{language}} if exists($secondaryLanguages{$tag->{language}});
+            return $supportedLanguages{$tag->{lclanguage}};
+        } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
+            # Client en-gb eq server en-us
+            $secondaryMatch = $secondaryLanguages{$1};
+        } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
+            # FIXME: We just checked the exact same conditional!
+            # Client en-us eq server en
+            $secondaryMatch = $supportedLanguages{$1};
+        } elsif ($tag->{lclanguage} eq '*') {
+        # * matches every language not already specified.
+        # It doesn't care which we pick, so let's pick the default,
+        # if available, then the first in the array.
+        #return $acceptor->defaultLanguage() if $acceptor->defaultLanguage();
+        return $supportedLanguages->[0];
+        }
+    }
+    # No primary matches. Secondary? (ie, en-us requested and en supported)
+    return $secondaryMatch if $secondaryMatch;
+    return undef;   # else, we got nothing.
+}
 1;
 
 __END__