← Index
NYTProf Performance Profile   « block view • line view • sub view »
For /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
  Run on Tue Oct 15 11:58:52 2013
Reported on Tue Oct 15 12:01:18 2013

Filename/usr/share/koha/lib/C4/Languages.pm
StatementsExecuted 1491 statements in 228ms
Subroutines
Calls P F Exclusive
Time
Inclusive
Time
Subroutine
1115.98ms162msC4::Languages::::getAllLanguagesC4::Languages::getAllLanguages
33513.38ms99.5msC4::Languages::::language_get_descriptionC4::Languages::language_get_description
15522.46ms4.06msC4::Languages::::regex_lang_subtagsC4::Languages::regex_lang_subtags
111911µs104msC4::Languages::::_build_languages_arrayrefC4::Languages::_build_languages_arrayref
255171584µs584µsC4::Languages::::CORE:qrC4::Languages::CORE:qr (opcode)
180111557µs557µsC4::Languages::::CORE:regcompC4::Languages::CORE:regcomp (opcode)
7171245µs245µsC4::Languages::::CORE:matchC4::Languages::CORE:match (opcode)
111128µs196µsC4::Languages::::_get_language_dirsC4::Languages::_get_language_dirs
11176µs104msC4::Languages::::getTranslatedLanguagesC4::Languages::getTranslatedLanguages
11155µs55µsC4::Languages::::BEGIN@39C4::Languages::BEGIN@39
11124µs31µsC4::Languages::::BEGIN@22C4::Languages::BEGIN@22
11120µs20µsC4::Languages::::CORE:readdirC4::Languages::CORE:readdir (opcode)
11117µs152µsC4::Languages::::BEGIN@26C4::Languages::BEGIN@26
11114µs14µsC4::Languages::::CORE:open_dirC4::Languages::CORE:open_dir (opcode)
11114µs17µsC4::Languages::::BEGIN@25C4::Languages::BEGIN@25
11113µs63µsC4::Languages::::BEGIN@24C4::Languages::BEGIN@24
1119µs9µsC4::Languages::::CORE:ftdirC4::Languages::CORE:ftdir (opcode)
0000s0sC4::Languages::::_get_themesC4::Languages::_get_themes
0000s0sC4::Languages::::accept_languageC4::Languages::accept_language
0000s0sC4::Languages::::getFrameworkLanguagesC4::Languages::getFrameworkLanguages
0000s0sC4::Languages::::get_bidiC4::Languages::get_bidi
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
1package C4::Languages;
2
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.
7#
8# Koha is free software; you can redistribute it and/or modify it under the
9# terms of the GNU General Public License as published by the Free Software
10# Foundation; either version 2 of the License, or (at your option) any later
11# version.
12#
13# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16#
17# You should have received a copy of the GNU General Public License along
18# with Koha; if not, write to the Free Software Foundation, Inc.,
19# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
21
22345µs237µs
# spent 31µs (24+6) within C4::Languages::BEGIN@22 which was called: # once (24µs+6µs) by C4::Templates::BEGIN@35 at line 22
use strict;
# spent 31µs making 1 call to C4::Languages::BEGIN@22 # spent 6µs making 1 call to strict::import
23#use warnings; FIXME - Bug 2505
24332µs2113µs
# spent 63µs (13+50) within C4::Languages::BEGIN@24 which was called: # once (13µs+50µs) by C4::Templates::BEGIN@35 at line 24
use Carp;
# spent 63µs making 1 call to C4::Languages::BEGIN@24 # spent 50µs making 1 call to Exporter::import
25335µs221µs
# spent 17µs (14+4) within C4::Languages::BEGIN@25 which was called: # once (14µs+4µs) by C4::Templates::BEGIN@35 at line 25
use C4::Context;
# spent 17µs making 1 call to C4::Languages::BEGIN@25 # spent 4µs making 1 call to C4::Context::import
263205µs2287µs
# spent 152µs (17+135) within C4::Languages::BEGIN@26 which was called: # once (17µs+135µs) by C4::Templates::BEGIN@35 at line 26
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $DEBUG);
# spent 152µs making 1 call to C4::Languages::BEGIN@26 # spent 135µs making 1 call to vars::import
27
28210µseval {
2914µs if (C4::Context->ismemcached) {
# spent 4µs making 1 call to C4::Context::ismemcached
30 require Memoize::Memcached;
31 import Memoize::Memcached qw(memoize_memcached);
32
33 memoize_memcached('getTranslatedLanguages', memcached => C4::Context->memcached);
34 memoize_memcached('getFrameworkLanguages' , memcached => C4::Context->memcached);
35 memoize_memcached('getAllLanguages', memcached => C4::Context->memcached);
36 }
37};
38
39
# spent 55µs within C4::Languages::BEGIN@39 which was called: # once (55µs+0s) by C4::Templates::BEGIN@35 at line 50
BEGIN {
40655µs $VERSION = 3.07.00.049;
41 require Exporter;
42 @ISA = qw(Exporter);
43 @EXPORT = qw(
44 &getFrameworkLanguages
45 &getTranslatedLanguages
46 &getAllLanguages
47 );
48 @EXPORT_OK = qw(getFrameworkLanguages getTranslatedLanguages getAllLanguages get_bidi regex_lang_subtags language_get_description accept_language);
49 $DEBUG = 0;
5012.14ms155µs}
# spent 55µs making 1 call to C4::Languages::BEGIN@39
51
52=head1 NAME
53
- -
64=head1 FUNCTIONS
65
- -
79sub getFrameworkLanguages {
80 # get a hash with all language codes, names, and locale names
81 my $all_languages = getAllLanguages();
82 my @languages;
83
84 # find the available directory names
85 my $dir=C4::Context->config('intranetdir')."/installer/data/";
86 opendir (MYDIR,$dir);
87 my @listdir= grep { !/^\.|CVS/ && -d "$dir/$_"} readdir(MYDIR);
88 closedir MYDIR;
89
90 # pull out all data for the dir names that exist
91 for my $dirname (@listdir) {
92 for my $language_set (@$all_languages) {
93
94 if ($dirname eq $language_set->{language_code}) {
95 push @languages, {
96 'language_code'=>$dirname,
97 'language_description'=>$language_set->{language_description},
98 'native_descrition'=>$language_set->{language_native_description} }
99 }
100 }
101 }
102 return \@languages;
103}
104
105=head2 getTranslatedLanguages
106
- -
119
# spent 104ms (76µs+104) within C4::Languages::getTranslatedLanguages which was called: # once (76µs+104ms) by C4::Templates::gettemplate at line 261 of /usr/share/koha/lib/C4/Templates.pm
sub getTranslatedLanguages {
120620µs my ($interface, $theme, $current_language, $which) = @_;
121 my $htdocs;
122 my @languages;
123 my @enabled_languages;
124
125351µs if ($interface && $interface eq 'opac' ) {
12619µs @enabled_languages = split ",", C4::Context->preference('opaclanguages');
# spent 9µs making 1 call to C4::Context::preference
127133µs $htdocs = C4::Context->config('opachtdocs');
# spent 33µs making 1 call to C4::Context::config
1282205µs if ( $theme and -d "$htdocs/$theme" ) {
# spent 196µs making 1 call to C4::Languages::_get_language_dirs # spent 9µs making 1 call to C4::Languages::CORE:ftdir
129 (@languages) = _get_language_dirs($htdocs,$theme);
130 }
131 else {
132 for my $theme ( _get_themes('opac') ) {
133 push @languages, _get_language_dirs($htdocs,$theme);
134 }
135 }
136 }
137 elsif ($interface && $interface eq 'intranet' ) {
138 @enabled_languages = split ",", C4::Context->preference('language');
139 $htdocs = C4::Context->config('intrahtdocs');
140 if ( $theme and -d "$htdocs/$theme" ) {
141 @languages = _get_language_dirs($htdocs,$theme);
142 }
143 else {
144 foreach my $theme ( _get_themes('intranet') ) {
145 push @languages, _get_language_dirs($htdocs,$theme);
146 }
147 }
148 }
149 else {
150 @enabled_languages = split ",", C4::Context->preference('opaclanguages');
151 my $htdocs = C4::Context->config('intrahtdocs');
152 foreach my $theme ( _get_themes('intranet') ) {
153 push @languages, _get_language_dirs($htdocs,$theme);
154 }
155 $htdocs = C4::Context->config('opachtdocs');
156 foreach my $theme ( _get_themes('opac') ) {
157 push @languages, _get_language_dirs($htdocs,$theme);
158 }
159 my %seen;
160 $seen{$_}++ for @languages;
161 @languages = keys %seen;
162 }
1631104ms return _build_languages_arrayref(\@languages,$current_language,\@enabled_languages);
# spent 104ms making 1 call to C4::Languages::_build_languages_arrayref
164}
165
166=head2 getAllLanguages
167
- -
180
# spent 162ms (5.98+156) within C4::Languages::getAllLanguages which was called: # once (5.98ms+156ms) by main::RUNTIME at line 201 of /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
sub getAllLanguages {
181102.56ms my $lang = shift;
182# if no parameter is passed to the function, it returns english languages names
183# if a $lang parameter conforming to RFC4646 syntax is passed, the function returns languages names translated in $lang
184# if a language name is not translated in $lang in database, the function returns english language name
185 my @languages_loop;
1861594µs my $dbh=C4::Context->dbh;
# spent 594µs making 1 call to C4::Context::dbh
187 my $default_language = 'en';
188 my $current_language = $default_language;
18917245µs if ($lang) {
# spent 234µs making 1 call to C4::Languages::regex_lang_subtags # spent 10µs making 16 calls to Regexp::DESTROY, avg 644ns/call
190 $current_language = regex_lang_subtags($lang)->{'language'};
191 }
19214µs2119µs my $sth = $dbh->prepare('SELECT * FROM language_subtag_registry WHERE type=\'language\'');
# spent 65µs making 1 call to DBI::db::prepare # spent 55µs making 1 call to DBD::mysql::db::prepare
19311.07ms $sth->execute();
# spent 1.07ms making 1 call to DBI::st::execute
194342101ms4592.86ms while (my $language_subtag_registry = $sth->fetchrow_hashref) {
# spent 1.20ms making 39 calls to DBI::st::fetchrow_hashref, avg 31µs/call # spent 808µs making 228 calls to DBI::common::DESTROY, avg 4µs/call # spent 380µs making 39 calls to DBI::st::fetch, avg 10µs/call # spent 288µs making 114 calls to DBD::_mem::common::DESTROY, avg 3µs/call # spent 179µs making 39 calls to DBI::common::FETCH, avg 5µs/call
195 my $desc;
196 # check if language name is stored in current language
1971149µs764.53ms my $sth4= $dbh->prepare("SELECT description FROM language_descriptions WHERE type='language' AND subtag =? AND lang = ?");
# spent 2.41ms making 38 calls to DBI::db::prepare, avg 64µs/call # spent 2.11ms making 38 calls to DBD::mysql::db::prepare, avg 56µs/call
1983841.3ms $sth4->execute($language_subtag_registry->{subtag},$current_language);
# spent 41.3ms making 38 calls to DBI::st::execute, avg 1.09ms/call
1992283.77ms while (my $language_desc = $sth4->fetchrow_hashref) {
# spent 2.65ms making 76 calls to DBI::st::fetchrow_hashref, avg 35µs/call # spent 594µs making 76 calls to DBI::common::FETCH, avg 8µs/call # spent 521µs making 76 calls to DBI::st::fetch, avg 7µs/call
200 $desc=$language_desc->{description};
201 }
2021268µs765.14ms 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 = ?");
# spent 2.75ms making 38 calls to DBI::db::prepare, avg 72µs/call # spent 2.39ms making 38 calls to DBD::mysql::db::prepare, avg 63µs/call
2033848.9ms if ($desc) {
# spent 48.9ms making 38 calls to DBI::st::execute, avg 1.29ms/call
204 $sth2->execute($language_subtag_registry->{subtag},$current_language);
205 }
206 else {
207 $sth2->execute($language_subtag_registry->{subtag},$default_language);
208 }
2091180µs766.03ms my $sth3 = $dbh->prepare("SELECT description FROM language_descriptions WHERE type='language' AND subtag=? AND lang=?");
# spent 3.25ms making 38 calls to DBI::db::prepare, avg 86µs/call # spent 2.77ms making 38 calls to DBD::mysql::db::prepare, avg 73µs/call
210 # add the correct description info
21119548.7ms2313.95ms while (my $language_descriptions = $sth2->fetchrow_hashref) {
# spent 2.82ms making 77 calls to DBI::st::fetchrow_hashref, avg 37µs/call # spent 563µs making 77 calls to DBI::st::fetch, avg 7µs/call # spent 562µs making 77 calls to DBI::common::FETCH, avg 7µs/call
2123944.8ms $sth3->execute($language_subtag_registry->{subtag},$language_subtag_registry->{subtag});
# spent 44.8ms making 39 calls to DBI::st::execute, avg 1.15ms/call
213 my $native_description;
2142343.58ms while (my $description = $sth3->fetchrow_hashref) {
# spent 2.52ms making 78 calls to DBI::st::fetchrow_hashref, avg 32µs/call # spent 543µs making 78 calls to DBI::st::fetch, avg 7µs/call # spent 520µs making 78 calls to DBI::common::FETCH, avg 7µs/call
215 $native_description = $description->{description};
216 }
217
218 # fill in the ISO6329 code
219 $language_subtag_registry->{iso639_2_code} = $language_descriptions->{iso639_2_code};
220 # fill in the native description of the language, as well as the current language's translation of that if it exists
22178202µs if ($native_description) {
222 $language_subtag_registry->{language_description} = $native_description;
223 $language_subtag_registry->{language_description}.=" ($language_descriptions->{description})" if $language_descriptions->{description};
224 }
225 else {
226 $language_subtag_registry->{language_description} = $language_descriptions->{description};
227 }
228 }
229 push @languages_loop, $language_subtag_registry;
230 }
231 return \@languages_loop;
232}
233
234=head2 _get_themes
235
- -
243sub _get_themes {
244 my $interface = shift;
245 my $htdocs;
246 my @themes;
247 if ( $interface eq 'intranet' ) {
248 $htdocs = C4::Context->config('intrahtdocs');
249 }
250 else {
251 $htdocs = C4::Context->config('opachtdocs');
252 }
253 opendir D, "$htdocs";
254 my @dirlist = readdir D;
255 foreach my $directory (@dirlist) {
256 # if there's an en dir, it's a valid theme
257 -d "$htdocs/$directory/en" and push @themes, $directory;
258 }
259 return @themes;
260}
261
262=head2 _get_language_dirs
263
- -
268
# spent 196µs (128+68) within C4::Languages::_get_language_dirs which was called: # once (128µs+68µs) by C4::Languages::getTranslatedLanguages at line 128
sub _get_language_dirs {
269560µs my ($htdocs,$theme) = @_;
270 my @lang_strings;
271114µs opendir D, "$htdocs/$theme";
# spent 14µs making 1 call to C4::Languages::CORE:open_dir
272120µs for my $lang_string ( readdir D ) {
# spent 20µs making 1 call to C4::Languages::CORE:readdir
27372136µs117µs next if $lang_string =~/^\./;
# spent 7µs making 11 calls to C4::Languages::CORE:match, avg 673ns/call
274 next if $lang_string eq 'all';
27594µs next if $lang_string =~/png$/;
# spent 4µs making 9 calls to C4::Languages::CORE:match, avg 389ns/call
27693µs next if $lang_string =~/css$/;
# spent 3µs making 9 calls to C4::Languages::CORE:match, avg 300ns/call
27793µs next if $lang_string =~/CVS$/;
# spent 3µs making 9 calls to C4::Languages::CORE:match, avg 344ns/call
27896µs next if $lang_string =~/\.txt$/i; #Don't read the readme.txt !
# spent 6µs making 9 calls to C4::Languages::CORE:match, avg 633ns/call
279912µs next if $lang_string =~/img|images|famfam|sound|pdf/;
# spent 12µs making 9 calls to C4::Languages::CORE:match, avg 1µs/call
280 push @lang_strings, $lang_string;
281 }
282 return (@lang_strings);
283}
284
285=head2 _build_languages_arrayref
286
- -
293
# spent 104ms (911µs+103) within C4::Languages::_build_languages_arrayref which was called: # once (911µs+103ms) by C4::Languages::getTranslatedLanguages at line 163
sub _build_languages_arrayref {
2941259µs my ($translated_languages,$current_language,$enabled_languages) = @_;
295 my @translated_languages = @$translated_languages;
296 my @languages_loop; # the final reference to an array of hashrefs
297 my @enabled_languages = @$enabled_languages;
298 # how many languages are enabled, if one, take note, some contexts won't need to display it
299 my %seen_languages; # the language tags we've seen
300 my %found_languages;
301 my $language_groups;
302 my $track_language_groups;
30317157µs my $current_language_regex = regex_lang_subtags($current_language);
# spent 147µs making 1 call to C4::Languages::regex_lang_subtags # spent 10µs making 16 calls to Regexp::DESTROY, avg 625ns/call
304 # Loop through the translated languages
305 for my $translated_language (@translated_languages) {
306 # separate the language string into its subtag types
30770415µs1191.81ms my $language_subtags_hashref = regex_lang_subtags($translated_language);
# spent 1.73ms making 7 calls to C4::Languages::regex_lang_subtags, avg 247µs/call # spent 85µs making 112 calls to Regexp::DESTROY, avg 757ns/call
308
309 # is this language string 'enabled'?
310 for my $enabled_language (@enabled_languages) {
311 #warn "Checking out if $translated_language eq $enabled_language";
312716µs $language_subtags_hashref->{'enabled'} = 1 if $translated_language eq $enabled_language;
313 }
314
315 # group this language, key by langtag
316 $language_subtags_hashref->{'sublanguage_current'} = 1 if $translated_language eq $current_language;
317 $language_subtags_hashref->{'rfc4646_subtag'} = $translated_language;
3182820.3ms $language_subtags_hashref->{'native_description'} = language_get_description($language_subtags_hashref->{language},$language_subtags_hashref->{language},'language');
# spent 20.2ms making 7 calls to C4::Languages::language_get_description, avg 2.89ms/call # spent 64µs making 14 calls to DBI::common::DESTROY, avg 5µs/call # spent 17µs making 7 calls to DBD::_mem::common::DESTROY, avg 2µs/call
3192822.7ms $language_subtags_hashref->{'script_description'} = language_get_description($language_subtags_hashref->{script},$language_subtags_hashref->{'language'},'script');
# spent 22.6ms making 7 calls to C4::Languages::language_get_description, avg 3.23ms/call # spent 56µs making 14 calls to DBI::common::DESTROY, avg 4µs/call # spent 13µs making 7 calls to DBD::_mem::common::DESTROY, avg 2µs/call
3202820.7ms $language_subtags_hashref->{'region_description'} = language_get_description($language_subtags_hashref->{region},$language_subtags_hashref->{'language'},'region');
# spent 20.6ms making 7 calls to C4::Languages::language_get_description, avg 2.95ms/call # spent 58µs making 14 calls to DBI::common::DESTROY, avg 4µs/call # spent 15µs making 7 calls to DBD::_mem::common::DESTROY, avg 2µs/call
3212821.6ms $language_subtags_hashref->{'variant_description'} = language_get_description($language_subtags_hashref->{variant},$language_subtags_hashref->{'language'},'variant');
# spent 21.6ms making 7 calls to C4::Languages::language_get_description, avg 3.08ms/call # spent 55µs making 14 calls to DBI::common::DESTROY, avg 4µs/call # spent 13µs making 7 calls to DBD::_mem::common::DESTROY, avg 2µs/call
322 $track_language_groups->{$language_subtags_hashref->{'language'}}++;
323 push ( @{ $language_groups->{$language_subtags_hashref->{language}} }, $language_subtags_hashref );
324 }
325 # $key is a language subtag like 'en'
32615341µs while( my ($key, $value) = each %$language_groups) {
327
328 # is this language group enabled? are any of the languages within it enabled?
329 my $enabled;
330 for my $enabled_language (@enabled_languages) {
3311053µs851.63ms my $regex_enabled_language = regex_lang_subtags($enabled_language);
# spent 1.54ms making 5 calls to C4::Languages::regex_lang_subtags, avg 307µs/call # spent 95µs making 80 calls to Regexp::DESTROY, avg 1µs/call
332 $enabled = 1 if $key eq $regex_enabled_language->{language};
333 }
3342014.5ms push @languages_loop, {
# spent 14.5ms making 5 calls to C4::Languages::language_get_description, avg 2.89ms/call # spent 49µs making 10 calls to DBI::common::DESTROY, avg 5µs/call # spent 14µs making 5 calls to DBD::_mem::common::DESTROY, avg 3µs/call
335 # this is only use if there is one
336 rfc4646_subtag => @$value[0]->{rfc4646_subtag},
337 native_description => language_get_description($key,$key,'language'),
338 language => $key,
339 sublanguages_loop => $value,
340 plural => $track_language_groups->{$key} >1 ? 1 : 0,
341 current => $current_language_regex->{language} eq $key ? 1 : 0,
342 group_enabled => $enabled,
343 };
344 }
345 return \@languages_loop;
346}
347
348
# spent 99.5ms (3.38+96.1) within C4::Languages::language_get_description which was called 33 times, avg 3.01ms/call: # 7 times (1.11ms+21.5ms) by C4::Languages::_build_languages_arrayref at line 319, avg 3.23ms/call # 7 times (551µs+21.0ms) by C4::Languages::_build_languages_arrayref at line 321, avg 3.08ms/call # 7 times (520µs+20.1ms) by C4::Languages::_build_languages_arrayref at line 320, avg 2.95ms/call # 7 times (772µs+19.4ms) by C4::Languages::_build_languages_arrayref at line 318, avg 2.89ms/call # 5 times (434µs+14.0ms) by C4::Languages::_build_languages_arrayref at line 334, avg 2.89ms/call
sub language_get_description {
34926438.5ms my ($script,$lang,$type) = @_;
3503329.0ms my $dbh = C4::Context->dbh;
# spent 29.0ms making 33 calls to C4::Context::dbh, avg 880µs/call
351 my $desc;
3521232µs665.10ms my $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
# spent 2.75ms making 33 calls to DBI::db::prepare, avg 83µs/call # spent 2.35ms making 33 calls to DBD::mysql::db::prepare, avg 71µs/call
353 #warn "QUERY: SELECT description FROM language_descriptions WHERE subtag=$script AND lang=$lang AND type=$type";
3543333.9ms $sth->execute($script,$lang,$type);
# spent 33.9ms making 33 calls to DBI::st::execute, avg 1.03ms/call
3551172.38ms while (my $descriptions = $sth->fetchrow_hashref) {
# spent 1.74ms making 39 calls to DBI::st::fetchrow_hashref, avg 45µs/call # spent 346µs making 39 calls to DBI::common::FETCH, avg 9µs/call # spent 291µs making 39 calls to DBI::st::fetch, avg 7µs/call
356 $desc = $descriptions->{'description'};
357 }
3588126.9ms unless ($desc) {
3591820µs543.40ms $sth = $dbh->prepare("SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?");
# spent 1.81ms making 27 calls to DBI::db::prepare, avg 67µs/call # spent 1.59ms making 27 calls to DBD::mysql::db::prepare, avg 59µs/call
36010825.6ms $sth->execute($script,'en',$type);
# spent 25.2ms making 27 calls to DBI::st::execute, avg 935µs/call # spent 241µs making 54 calls to DBI::common::DESTROY, avg 4µs/call # spent 65µs making 27 calls to DBD::_mem::common::DESTROY, avg 2µs/call
361811.41ms while (my $descriptions = $sth->fetchrow_hashref) {
# spent 973µs making 27 calls to DBI::st::fetchrow_hashref, avg 36µs/call # spent 235µs making 27 calls to DBI::common::FETCH, avg 9µs/call # spent 203µs making 27 calls to DBI::st::fetch, avg 8µs/call
362 $desc = $descriptions->{'description'};
363 }
364 }
365 return $desc;
366}
367=head2 regex_lang_subtags
368
- -
375
# spent 4.06ms (2.46+1.60) within C4::Languages::regex_lang_subtags which was called 15 times, avg 270µs/call: # 7 times (1.08ms+649µs) by C4::Languages::_build_languages_arrayref at line 307, avg 247µs/call # 5 times (962µs+575µs) by C4::Languages::_build_languages_arrayref at line 331, avg 307µs/call # once (174µs+237µs) by C4::Templates::gettemplate at line 257 of /usr/share/koha/lib/C4/Templates.pm # once (146µs+88µs) by C4::Languages::getAllLanguages at line 189 # once (98µs+48µs) by C4::Languages::_build_languages_arrayref at line 303
sub regex_lang_subtags {
3763004.05ms my $string = shift;
377
378 # Regex for recognizing RFC 4646 well-formed tags
379 # http://www.rfc-editor.org/rfc/rfc4646.txt
380
381 # regexes based on : http://unicode.org/cldr/data/tools/java/org/unicode/cldr/util/data/langtagRegex.txt
382 # The structure requires no forward references, so it reverses the order.
383 # The uppercase comments are fragments copied from RFC 4646
384 #
385 # Note: the tool requires that any real "=" or "#" or ";" in the regex be escaped.
386
38715100µs my $alpha = qr/[a-zA-Z]/ ; # ALPHA
# spent 100µs making 15 calls to C4::Languages::CORE:qr, avg 7µs/call
3881540µs my $digit = qr/[0-9]/ ; # DIGIT
# spent 40µs making 15 calls to C4::Languages::CORE:qr, avg 3µs/call
3891525µs my $alphanum = qr/[a-zA-Z0-9]/ ; # ALPHA / DIGIT
# spent 25µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
3901527µs my $x = qr/[xX]/ ; # private use singleton
# spent 27µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
3911527µs my $singleton = qr/[a-w y-z A-W Y-Z]/ ; # other singleton
# spent 27µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
3921531µs my $s = qr/[-]/ ; # separator -- lenient parsers will use [-_]
# spent 31µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
393
394 # Now do the components. The structure is slightly different to allow for capturing the right components.
395 # The notation (?:....) is a non-capturing version of (...): so the "?:" can be deleted if someone doesn't care about capturing.
396
3973095µs my $extlang = qr{(?: $s $alpha{3} )}x ; # *3("-" 3ALPHA)
# spent 67µs making 15 calls to C4::Languages::CORE:regcomp, avg 4µs/call # spent 28µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
3983059µs my $language = qr{(?: $alpha{2,3} | $alpha{4,8} )}x ;
# spent 34µs making 15 calls to C4::Languages::CORE:regcomp, avg 2µs/call # spent 25µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
399 #my $language = qr{(?: $alpha{2,3}$extlang{0,3} | $alpha{4,8} )}x ; # (2*3ALPHA [ extlang ]) / 4ALPHA / 5*8ALPHA
400
4013047µs my $script = qr{(?: $alpha{4} )}x ; # 4ALPHA
# spent 25µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call # spent 22µs making 15 calls to C4::Languages::CORE:regcomp, avg 1µs/call
402
4033054µs my $region = qr{(?: $alpha{2} | $digit{3} )}x ; # 2ALPHA / 3DIGIT
# spent 30µs making 15 calls to C4::Languages::CORE:regcomp, avg 2µs/call # spent 23µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
404
4053064µs my $variantSub = qr{(?: $digit$alphanum{3} | $alphanum{5,8} )}x ; # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
# spent 39µs making 15 calls to C4::Languages::CORE:regcomp, avg 3µs/call # spent 24µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
4063072µs my $variant = qr{(?: $variantSub (?: $s$variantSub )* )}x ; # *("-" variant), 5*8alphanum / (DIGIT 3alphanum)
# spent 47µs making 15 calls to C4::Languages::CORE:regcomp, avg 3µs/call # spent 24µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
407
4083054µs my $extensionSub = qr{(?: $singleton (?: $s$alphanum{2,8} )+ )}x ; # singleton 1*("-" (2*8alphanum))
# spent 29µs making 15 calls to C4::Languages::CORE:regcomp, avg 2µs/call # spent 25µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
4093075µs my $extension = qr{(?: $extensionSub (?: $s$extensionSub )* )}x ; # singleton 1*("-" (2*8alphanum))
# spent 49µs making 15 calls to C4::Languages::CORE:regcomp, avg 3µs/call # spent 27µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
410
4113057µs my $privateuse = qr{(?: $x (?: $s$alphanum{1,8} )+ )}x ; # ("x"/"X") 1*("-" (1*8alphanum))
# spent 30µs making 15 calls to C4::Languages::CORE:regcomp, avg 2µs/call # spent 26µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
412
413 # Define certain grandfathered codes, since otherwise the regex is pretty useless.
414 # Since these are limited, this is safe even later changes to the registry --
415 # the only oddity is that it might change the type of the tag, and thus
416 # the results from the capturing groups.
417 # http://www.iana.org/assignments/language-subtag-registry
418 # Note that these have to be compared case insensitively, requiring (?i) below.
419
42030144µs my $grandfathered = qr{(?: (?i)
# spent 76µs making 15 calls to C4::Languages::CORE:qr, avg 5µs/call # spent 68µs making 15 calls to C4::Languages::CORE:regcomp, avg 5µs/call
421 en $s GB $s oed
422 | i $s (?: ami | bnn | default | enochian | hak | klingon | lux | mingo | navajo | pwn | tao | tay | tsu )
423 | sgn $s (?: BE $s fr | BE $s nl | CH $s de)
424)}x;
425
426 # For well-formedness, we don't need the ones that would otherwise pass, so they are commented out here
427
428 # | art $s lojban
429 # | cel $s gaulish
430 # | en $s (?: boont | GB $s oed | scouse )
431 # | no $s (?: bok | nyn)
432 # | zh $s (?: cmn | cmn $s Hans | cmn $s Hant | gan | guoyu | hakka | min | min $s nan | wuu | xiang | yue)
433
434 # Here is the final breakdown, with capturing groups for each of these components
435 # The language, variants, extensions, grandfathered, and private-use may have interior '-'
436
437 #my $root = qr{(?: ($language) (?: $s ($script) )? 40% (?: $s ($region) )? 40% (?: $s ($variant) )? 10% (?: $s ($extension) )? 5% (?: $s ($privateuse) )? 5% ) 90% | ($grandfathered) 5% | ($privateuse) 5% };
438
43960380µs $string =~ qr{^ (?:($language)) (?:$s($script))? (?:$s($region))? (?:$s($variant))? (?:$s($extension))? (?:$s($privateuse))? $}xi; # |($grandfathered) | ($privateuse) $}xi;
# spent 210µs making 15 calls to C4::Languages::CORE:match, avg 14µs/call # spent 140µs making 30 calls to C4::Languages::CORE:regcomp, avg 5µs/call # spent 30µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
4401536µs my %subtag = (
# spent 36µs making 15 calls to Regexp::DESTROY, avg 2µs/call
441 'rfc4646_subtag' => $string,
442 'language' => $1,
443 'script' => $2,
444 'region' => $3,
445 'variant' => $4,
446 'extension' => $5,
447 'privateuse' => $6,
448 );
449 return \%subtag;
450}
451
452# Script Direction Resources:
453# http://www.w3.org/International/questions/qa-scripts
454sub get_bidi {
455 my ($language_script)= @_;
456 my $dbh = C4::Context->dbh;
457 my $bidi;
458 my $sth = $dbh->prepare('SELECT bidi FROM language_script_bidi WHERE rfc4646_subtag=?');
459 $sth->execute($language_script);
460 while (my $result = $sth->fetchrow_hashref) {
461 $bidi = $result->{'bidi'};
462 }
463 return $bidi;
464};
465
466sub accept_language {
467 # referenced http://search.cpan.org/src/CGILMORE/I18N-AcceptLanguage-1.04/lib/I18N/AcceptLanguage.pm
468 my ($clientPreferences,$supportedLanguages) = @_;
469 my @languages = ();
470 if ($clientPreferences) {
471 # There should be no whitespace anways, but a cleanliness/sanity check
472 $clientPreferences =~ s/\s//g;
473 # Prepare the list of client-acceptable languages
474 foreach my $tag (split(/,/, $clientPreferences)) {
475 my ($language, $quality) = split(/\;/, $tag);
476 $quality =~ s/^q=//i if $quality;
477 $quality = 1 unless $quality;
478 next if $quality <= 0;
479 # We want to force the wildcard to be last
480 $quality = 0 if ($language eq '*');
481 # Pushing lowercase language here saves processing later
482 push(@languages, { quality => $quality,
483 language => $language,
484 lclanguage => lc($language) });
485 }
486 } else {
487 carp "accept_language(x,y) called with no clientPreferences (x).";
488 }
489 # Prepare the list of server-supported languages
490 my %supportedLanguages = ();
491 my %secondaryLanguages = ();
492 foreach my $language (@$supportedLanguages) {
493 # warn "Language supported: " . $language->{language};
494 my $subtag = $language->{rfc4646_subtag};
495 $supportedLanguages{lc($subtag)} = $subtag;
496 if ( $subtag =~ /^([^-]+)-?/ ) {
497 $secondaryLanguages{lc($1)} = $subtag;
498 }
499 }
500
501 # Reverse sort the list, making best quality at the front of the array
502 @languages = sort { $b->{quality} <=> $a->{quality} } @languages;
503 my $secondaryMatch = '';
504 foreach my $tag (@languages) {
505 if (exists($supportedLanguages{$tag->{lclanguage}})) {
506 # Client en-us eq server en-us
507 return $supportedLanguages{$tag->{language}} if exists($supportedLanguages{$tag->{language}});
508 return $supportedLanguages{$tag->{lclanguage}};
509 } elsif (exists($secondaryLanguages{$tag->{lclanguage}})) {
510 # Client en eq server en-us
511 return $secondaryLanguages{$tag->{language}} if exists($secondaryLanguages{$tag->{language}});
512 return $supportedLanguages{$tag->{lclanguage}};
513 } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
514 # Client en-gb eq server en-us
515 $secondaryMatch = $secondaryLanguages{$1};
516 } elsif ($tag->{lclanguage} =~ /^([^-]+)-/ && exists($secondaryLanguages{$1}) && $secondaryMatch eq '') {
517 # FIXME: We just checked the exact same conditional!
518 # Client en-us eq server en
519 $secondaryMatch = $supportedLanguages{$1};
520 } elsif ($tag->{lclanguage} eq '*') {
521 # * matches every language not already specified.
522 # It doesn't care which we pick, so let's pick the default,
523 # if available, then the first in the array.
524 #return $acceptor->defaultLanguage() if $acceptor->defaultLanguage();
525 return $supportedLanguages->[0];
526 }
527 }
528 # No primary matches. Secondary? (ie, en-us requested and en supported)
529 return $secondaryMatch if $secondaryMatch;
530 return undef; # else, we got nothing.
531}
53219µs1;
533
534__END__
 
# spent 9µs within C4::Languages::CORE:ftdir which was called: # once (9µs+0s) by C4::Languages::getTranslatedLanguages at line 128
sub C4::Languages::CORE:ftdir; # opcode
# spent 245µs within C4::Languages::CORE:match which was called 71 times, avg 3µs/call: # 15 times (210µs+0s) by C4::Languages::regex_lang_subtags at line 439, avg 14µs/call # 11 times (7µs+0s) by C4::Languages::_get_language_dirs at line 273, avg 673ns/call # 9 times (12µs+0s) by C4::Languages::_get_language_dirs at line 279, avg 1µs/call # 9 times (6µs+0s) by C4::Languages::_get_language_dirs at line 278, avg 633ns/call # 9 times (4µs+0s) by C4::Languages::_get_language_dirs at line 275, avg 389ns/call # 9 times (3µs+0s) by C4::Languages::_get_language_dirs at line 277, avg 344ns/call # 9 times (3µs+0s) by C4::Languages::_get_language_dirs at line 276, avg 300ns/call
sub C4::Languages::CORE:match; # opcode
# spent 14µs within C4::Languages::CORE:open_dir which was called: # once (14µs+0s) by C4::Languages::_get_language_dirs at line 271
sub C4::Languages::CORE:open_dir; # opcode
# spent 584µs within C4::Languages::CORE:qr which was called 255 times, avg 2µs/call: # 15 times (100µs+0s) by C4::Languages::regex_lang_subtags at line 387, avg 7µs/call # 15 times (76µs+0s) by C4::Languages::regex_lang_subtags at line 420, avg 5µs/call # 15 times (40µs+0s) by C4::Languages::regex_lang_subtags at line 388, avg 3µs/call # 15 times (31µs+0s) by C4::Languages::regex_lang_subtags at line 392, avg 2µs/call # 15 times (30µs+0s) by C4::Languages::regex_lang_subtags at line 439, avg 2µs/call # 15 times (28µs+0s) by C4::Languages::regex_lang_subtags at line 397, avg 2µs/call # 15 times (27µs+0s) by C4::Languages::regex_lang_subtags at line 391, avg 2µs/call # 15 times (27µs+0s) by C4::Languages::regex_lang_subtags at line 390, avg 2µs/call # 15 times (27µs+0s) by C4::Languages::regex_lang_subtags at line 409, avg 2µs/call # 15 times (26µs+0s) by C4::Languages::regex_lang_subtags at line 411, avg 2µs/call # 15 times (25µs+0s) by C4::Languages::regex_lang_subtags at line 389, avg 2µs/call # 15 times (25µs+0s) by C4::Languages::regex_lang_subtags at line 408, avg 2µs/call # 15 times (25µs+0s) by C4::Languages::regex_lang_subtags at line 398, avg 2µs/call # 15 times (25µs+0s) by C4::Languages::regex_lang_subtags at line 401, avg 2µs/call # 15 times (24µs+0s) by C4::Languages::regex_lang_subtags at line 406, avg 2µs/call # 15 times (24µs+0s) by C4::Languages::regex_lang_subtags at line 405, avg 2µs/call # 15 times (23µs+0s) by C4::Languages::regex_lang_subtags at line 403, avg 2µs/call
sub C4::Languages::CORE:qr; # opcode
# spent 20µs within C4::Languages::CORE:readdir which was called: # once (20µs+0s) by C4::Languages::_get_language_dirs at line 272
sub C4::Languages::CORE:readdir; # opcode
# spent 557µs within C4::Languages::CORE:regcomp which was called 180 times, avg 3µs/call: # 30 times (140µs+0s) by C4::Languages::regex_lang_subtags at line 439, avg 5µs/call # 15 times (68µs+0s) by C4::Languages::regex_lang_subtags at line 420, avg 5µs/call # 15 times (67µs+0s) by C4::Languages::regex_lang_subtags at line 397, avg 4µs/call # 15 times (49µs+0s) by C4::Languages::regex_lang_subtags at line 409, avg 3µs/call # 15 times (47µs+0s) by C4::Languages::regex_lang_subtags at line 406, avg 3µs/call # 15 times (39µs+0s) by C4::Languages::regex_lang_subtags at line 405, avg 3µs/call # 15 times (34µs+0s) by C4::Languages::regex_lang_subtags at line 398, avg 2µs/call # 15 times (30µs+0s) by C4::Languages::regex_lang_subtags at line 403, avg 2µs/call # 15 times (30µs+0s) by C4::Languages::regex_lang_subtags at line 411, avg 2µs/call # 15 times (29µs+0s) by C4::Languages::regex_lang_subtags at line 408, avg 2µs/call # 15 times (22µs+0s) by C4::Languages::regex_lang_subtags at line 401, avg 1µs/call
sub C4::Languages::CORE:regcomp; # opcode