Profile of /usr/share/koha/lib/C4/Languages.pm

Filename	/usr/share/koha/lib/C4/Languages.pm
Statements	Executed 1491 statements in 228ms

Subroutines
Calls	P	F	Exclusive Time	Inclusive Time	Subroutine
1	1	1	5.98ms	162ms	C4::Languages::::getAllLanguagesC4::Languages::getAllLanguages
33	5	1	3.38ms	99.5ms	C4::Languages::language_get_description
15	5	2	2.46ms	4.06ms	C4::Languages::::regex_lang_subtagsC4::Languages::regex_lang_subtags
1	1	1	911µs	104ms	C4::Languages::_build_languages_arrayref
255	17	1	584µs	584µs	C4::Languages::::CORE:qrC4::Languages::CORE:qr (opcode)
180	11	1	557µs	557µs	C4::Languages::::CORE:regcompC4::Languages::CORE:regcomp (opcode)
71	7	1	245µs	245µs	C4::Languages::::CORE:matchC4::Languages::CORE:match (opcode)
1	1	1	128µs	196µs	C4::Languages::::_get_language_dirsC4::Languages::_get_language_dirs
1	1	1	76µs	104ms	C4::Languages::::getTranslatedLanguagesC4::Languages::getTranslatedLanguages
1	1	1	55µs	55µs	C4::Languages::::BEGIN@39C4::Languages::BEGIN@39
1	1	1	24µs	31µs	C4::Languages::::BEGIN@22C4::Languages::BEGIN@22
1	1	1	20µs	20µs	C4::Languages::::CORE:readdirC4::Languages::CORE:readdir (opcode)
1	1	1	17µs	152µs	C4::Languages::::BEGIN@26C4::Languages::BEGIN@26
1	1	1	14µs	14µs	C4::Languages::::CORE:open_dirC4::Languages::CORE:open_dir (opcode)
1	1	1	14µs	17µs	C4::Languages::::BEGIN@25C4::Languages::BEGIN@25
1	1	1	13µs	63µs	C4::Languages::::BEGIN@24C4::Languages::BEGIN@24
1	1	1	9µs	9µs	C4::Languages::::CORE:ftdirC4::Languages::CORE:ftdir (opcode)
0	0	0	0s	0s	C4::Languages::::_get_themesC4::Languages::_get_themes
0	0	0	0s	0s	C4::Languages::::accept_languageC4::Languages::accept_language
0	0	0	0s	0s	C4::Languages::::getFrameworkLanguagesC4::Languages::getFrameworkLanguages
0	0	0	0s	0s	C4::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
1					package 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
22	3	45µs	2	37µ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
24	3	32µs	2	113µ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
25	3	35µs	2	21µ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
26	3	205µs	2	287µ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
28	1	1µs			eval {
29	1	9µs	1	4µ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 {
40	1	1µs			$VERSION = 3.07.00.049;
41	1	900ns			require Exporter;
42	1	43µs			@ISA = qw(Exporter);
43	1	2µs			@EXPORT = qw(
44					&getFrameworkLanguages
45					&getTranslatedLanguages
46					&getAllLanguages
47					);
48	1	2µs			@EXPORT_OK = qw(getFrameworkLanguages getTranslatedLanguages getAllLanguages get_bidi regex_lang_subtags language_get_description accept_language);
49	1	6µs			$DEBUG = 0;
50	1	2.14ms	1	55µs	} # spent 55µs making 1 call to C4::Languages::BEGIN@39
51
52					=head1 NAME
53
- -
64					=head1 FUNCTIONS
65
- -
79					sub 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 {
120	1	2µs			my ($interface, $theme, $current_language, $which) = @_;
121	1	400ns			my $htdocs;
122	1	400ns			my @languages;
123	1	400ns			my @enabled_languages;
124
125	1	2µs			if ($interface && $interface eq 'opac' ) {
126	1	10µs	1	9µs	@enabled_languages = split ",", C4::Context->preference('opaclanguages'); # spent 9µs making 1 call to C4::Context::preference
127	1	8µs	1	33µs	$htdocs = C4::Context->config('opachtdocs'); # spent 33µs making 1 call to C4::Context::config
128	1	32µs	2	205µ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					}
163	1	14µs	1	104ms	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 {
181	1	2µs			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	1	500ns			my @languages_loop;
186	1	4µs	1	594µs	my $dbh=C4::Context->dbh; # spent 594µs making 1 call to C4::Context::dbh
187	1	1µs			my $default_language = 'en';
188	1	600ns			my $current_language = $default_language;
189	1	8µs	17	245µ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					}
192	1	11µs	2	119µ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
193	1	1.08ms	1	1.07ms	$sth->execute(); # spent 1.07ms making 1 call to DBI::st::execute
194	1	1.42ms	459	2.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	38	11µs			my $desc;
196					# check if language name is stored in current language
197	38	401µs	76	4.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
198	38	41.7ms	38	41.3ms	$sth4->execute($language_subtag_registry->{subtag},$current_language); # spent 41.3ms making 38 calls to DBI::st::execute, avg 1.09ms/call
199	38	3.19ms	228	3.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					}
202	38	525µs	76	5.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
203	38	49.4ms	38	48.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					}
209	38	742µs	76	6.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
211	38	3.40ms	231	3.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
212	39	45.5ms	39	44.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	39	22µs			my $native_description;
214	39	3.05ms	234	3.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	39	103µs			$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
221	39	47µs			if ($native_description) {
222	39	57µs			$language_subtag_registry->{language_description} = $native_description;
223	39	145µs			$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	38	2.58ms			push @languages_loop, $language_subtag_registry;
230					}
231	1	35µs			return \@languages_loop;
232					}
233
234					=head2 _get_themes
235
- -
243					sub _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 {
269	1	2µs			my ($htdocs,$theme) = @_;
270	1	400ns			my @lang_strings;
271	1	23µs	1	14µs	opendir D, "$htdocs/$theme"; # spent 14µs making 1 call to C4::Languages::CORE:open_dir
272	1	32µs	1	20µs	for my $lang_string ( readdir D ) { # spent 20µs making 1 call to C4::Languages::CORE:readdir
273	11	26µs	11	7µs	next if $lang_string =~/^\./; # spent 7µs making 11 calls to C4::Languages::CORE:match, avg 673ns/call
274	9	3µs			next if $lang_string eq 'all';
275	9	17µs	9	4µs	next if $lang_string =~/png$/; # spent 4µs making 9 calls to C4::Languages::CORE:match, avg 389ns/call
276	9	16µs	9	3µs	next if $lang_string =~/css$/; # spent 3µs making 9 calls to C4::Languages::CORE:match, avg 300ns/call
277	9	16µs	9	3µs	next if $lang_string =~/CVS$/; # spent 3µs making 9 calls to C4::Languages::CORE:match, avg 344ns/call
278	9	20µs	9	6µ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
279	9	27µs	9	12µ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	7	8µs			push @lang_strings, $lang_string;
281					}
282	1	5µs			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 {
294	1	1µs			my ($translated_languages,$current_language,$enabled_languages) = @_;
295	1	2µs			my @translated_languages = @$translated_languages;
296	1	300ns			my @languages_loop; # the final reference to an array of hashrefs
297	1	1µs			my @enabled_languages = @$enabled_languages;
298					# how many languages are enabled, if one, take note, some contexts won't need to display it
299	1	400ns			my %seen_languages; # the language tags we've seen
300	1	300ns			my %found_languages;
301	1	300ns			my $language_groups;
302	1	400ns			my $track_language_groups;
303	1	2µs	17	157µ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	1	2µs			for my $translated_language (@translated_languages) {
306					# separate the language string into its subtag types
307	7	38µs	119	1.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	7	17µs			for my $enabled_language (@enabled_languages) {
311					#warn "Checking out if $translated_language eq $enabled_language";
312	7	16µs			$language_subtags_hashref->{'enabled'} = 1 if $translated_language eq $enabled_language;
313					}
314
315					# group this language, key by langtag
316	7	6µs			$language_subtags_hashref->{'sublanguage_current'} = 1 if $translated_language eq $current_language;
317	7	10µs			$language_subtags_hashref->{'rfc4646_subtag'} = $translated_language;
318	7	53µs	28	20.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
319	7	136µs	28	22.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
320	7	50µs	28	20.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
321	7	48µs	28	21.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	7	30µs			$track_language_groups->{$language_subtags_hashref->{'language'}}++;
323	7	28µs			push ( @{ $language_groups->{$language_subtags_hashref->{language}} }, $language_subtags_hashref );
324					}
325					# $key is a language subtag like 'en'
326	1	28µs			while( my ($key, $value) = each %$language_groups) {
327
328					# is this language group enabled? are any of the languages within it enabled?
329	5	2µs			my $enabled;
330	5	203µs			for my $enabled_language (@enabled_languages) {
331	5	28µs	85	1.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	5	26µs			$enabled = 1 if $key eq $regex_enabled_language->{language};
333					}
334	5	136µs	20	14.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	1	21µs			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 {
349	33	55µs			my ($script,$lang,$type) = @_;
350	33	182µs	33	29.0ms	my $dbh = C4::Context->dbh; # spent 29.0ms making 33 calls to C4::Context::dbh, avg 880µs/call
351	33	12µs			my $desc;
352	33	1.06ms	66	5.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";
354	33	34.2ms	33	33.9ms	$sth->execute($script,$lang,$type); # spent 33.9ms making 33 calls to DBI::st::execute, avg 1.03ms/call
355	33	2.01ms	117	2.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					}
358	33	52µs			unless ($desc) {
359	27	1.00ms	54	3.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
360	27	25.5ms	108	25.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
361	27	1.16ms	81	1.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	33	1.19ms			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 {
376	15	23µs			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
387	15	183µs	15	100µs	my $alpha = qr/[a-zA-Z]/ ; # ALPHA # spent 100µs making 15 calls to C4::Languages::CORE:qr, avg 7µs/call
388	15	84µs	15	40µs	my $digit = qr/[0-9]/ ; # DIGIT # spent 40µs making 15 calls to C4::Languages::CORE:qr, avg 3µs/call
389	15	68µs	15	25µ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
390	15	75µs	15	27µs	my $x = qr/[xX]/ ; # private use singleton # spent 27µs making 15 calls to C4::Languages::CORE:qr, avg 2µs/call
391	15	67µs	15	27µ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
392	15	76µs	15	31µ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
397	15	193µs	30	95µ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
398	15	142µs	30	59µ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 ; # (23ALPHA [ extlang ]) / 4ALPHA / 58ALPHA
400
401	15	122µs	30	47µ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
403	15	125µs	30	54µ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
405	15	142µs	30	64µs	my $variantSub = qr{(?: $digit$alphanum{3} \| $alphanum{5,8} )}x ; # ("-" variant), 58alphanum / (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
406	15	153µs	30	72µs	my $variant = qr{(?: $variantSub (?: $s$variantSub )* )}x ; # ("-" variant), 58alphanum / (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
408	15	127µs	30	54µs	my $extensionSub = qr{(?: $singleton (?: $s$alphanum{2,8} )+ )}x ; # singleton 1("-" (28alphanum)) # 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
409	15	154µs	30	75µs	my $extension = qr{(?: $extensionSub (?: $s$extensionSub )* )}x ; # singleton 1("-" (28alphanum)) # 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
411	15	247µs	30	57µs	my $privateuse = qr{(?: $x (?: $s$alphanum{1,8} )+ )}x ; # ("x"/"X") 1("-" (18alphanum)) # 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
420	15	249µs	30	144µ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
439	15	674µs	60	380µ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
440	15	214µs	15	36µ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	15	932µs			return \%subtag;
450					}
451
452					# Script Direction Resources:
453					# http://www.w3.org/International/questions/qa-scripts
454					sub 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
466					sub 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					}
532	1	9µs			1;
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