Attachment #108166 for bug #24973

View | Details | Raw Unified | Return to bug 24973
Collapse All | Expand All





sub load_sql_in_order {
    my $self = shift;
    my $langchoice = shift;
    my $all_languages = shift;
    my @sql_list = @_;


    push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_offset_types.sql";
    push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_credit_types.sql";
    push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_debit_types.sql";
    my $localization_file = C4::Context->config('intranetdir') .
                            "/installer/data/$self->{dbms}/localization/$langchoice/custom.sql";
    if ( $langchoice ne 'en' and -f $localization_file ) {
        push @fnames, $localization_file;
    }
    foreach my $file (@fnames) {
        #      warn $file;
        undef $/;
        my $error = $self->load_sql($file);
        my @file = split qr(\/|\\), $file;
        $lang = $file[ scalar(@file) - 3 ] unless ($lang);
        my $level = ( $file =~ /(localization)/ ) ? $1 : $file[ scalar(@file) - 2 ];
        unless ($error) {
            $systempreference .= "$file[scalar(@file)-1]|"
              unless ( index( $systempreference, $file[ scalar(@file) - 1 ] ) >= 0 );

Lines 26-32 UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassification Link Here

(-)a/installer/data/mysql/de-DE/mandatory/system_preferences.sql (-1 / +1 lines)
26	UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variable = 'OpacMainUserBlock';	26	UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variable = 'OpacMainUserBlock';
27	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';	27	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';
28	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';	28	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';
29	UPDATE systempreferences SET value =	29	UPDATE systempreferences SET value =
30	'<li><a href="https://worldcat.org/search?q={TITLE}" target="_blank">Andere Bibliotheken (WorldCat)</a></li>	30	'<li><a href="https://worldcat.org/search?q={TITLE}" target="_blank">Andere Bibliotheken (WorldCat)</a></li>
31	<li><a href="https://scholar.google.com/scholar?q={TITLE}" target="_blank">Google Scholar</a></li>	31	<li><a href="https://scholar.google.com/scholar?q={TITLE}" target="_blank">Google Scholar</a></li>
32	<li><a href="https://www.bookfinder.com/search/?author={AUTHOR}&title={TITLE}&st=xl&ac=qr" target="_blank">Online-Buchhandel (Bookfinder.com)</a></li>'	32	<li><a href="https://www.bookfinder.com/search/?author={AUTHOR}&title={TITLE}&st=xl&ac=qr" target="_blank">Online-Buchhandel (Bookfinder.com)</a></li>'




--
-- System preferences that differ from the global defaults
--
-- This file is part of Koha.
--
-- Koha is free software; you can redistribute it and/or modify it
-- under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- Koha is distributed in the hope that it will be useful, but
-- WITHOUT ANY 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, see <http://www.gnu.org/licenses>.

UPDATE systempreferences SET value = 'padre|madre' WHERE variable = 'borrowerRelationship';
UPDATE systempreferences SET value = 'Sr.|Sra.' WHERE variable = 'BorrowersTitles';
UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';
UPDATE systempreferences SET value = 'US' WHERE variable = 'AddressFormat';
UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
UPDATE systempreferences SET value = 'ddc' WHERE variable = 'DefaultClassificationSource';
UPDATE systempreferences SET value = 'Bienvenido al catálogo!' WHERE variable = 'OpacMainUserBlock';
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';
UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWeek';
UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';

Lines 62-65 UPDATE systempreferences SET value = '1' WHERE variable = 'UseICU'; Link Here

(-)a/installer/data/mysql/it-IT/necessari/system_preferences.sql (-1 lines)
62	UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';	62	UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
63		63
64	UPDATE systempreferences SET value = '#200\|<span style=\"font-weight:bold\">\|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}\|</span>\r\n#210\|. – \|{210a}{ : 210c}{, 210d}\|\r\n#215\|. – \|{215a}{ ; 215d}\|\r\n#225\|. – \|{(225a}{ ; 225v)}\|\r\n#010\|. – \|{ISBN 010a}\|' WHERE variable = 'ISBD';	64	UPDATE systempreferences SET value = '#200\|<span style=\"font-weight:bold\">\|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}\|</span>\r\n#210\|. – \|{210a}{ : 210c}{, 210d}\|\r\n#215\|. – \|{215a}{ ; 215d}\|\r\n#225\|. – \|{(225a}{ ; 225v)}\|\r\n#010\|. – \|{ISBN 010a}\|' WHERE variable = 'ISBD';
65

Line 0 Link Here

(-)a/installer/data/mysql/localization/nb-NO/custom.txt (+1 lines)
	1	Standard systempreferanser.

Line 1 Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/system_preferences.txt (-1 lines)
1	Standard systempreferanser.

Lines 245-253 elsif ( $step && $step == 3 ) { Link Here

(-)a/installer/install.pl (-1 / +4 lines)
245	elsif ( $op && $op eq 'addframeworks' ) {	245	elsif ( $op && $op eq 'addframeworks' ) {
246		246
247	# 1ST install, 3rd sub-step : insert the SQL files the user has selected	247	# 1ST install, 3rd sub-step : insert the SQL files the user has selected
		248	my $langchoice = $query->param('fwklanguage');
		249	$langchoice = $query->cookie('KohaOpacLanguage') unless ($langchoice);
		250	$langchoice =~ s/[^a-zA-Z_-]*//g;
248		251
249	my ( $fwk_language, $list ) =	252	my ( $fwk_language, $list ) =
250	$installer->load_sql_in_order( $all_languages,	253	$installer->load_sql_in_order( $langchoice, $all_languages,
251	$query->multi_param('framework') );	254	$query->multi_param('framework') );
252	$template->param(	255	$template->param(
253	"fwklanguage" => $fwk_language,	256	"fwklanguage" => $fwk_language,

Lines 173-178 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/installer/step3.tt (-1 / +2 lines)
173	<h3>Optional data added</h3>	173	<h3>Optional data added</h3>
174	[% ELSIF lis.level == 'mysql' %]	174	[% ELSIF lis.level == 'mysql' %]
175	<h3>MySQL data added</h3>	175	<h3>MySQL data added</h3>
		176	[% ELSIF lis.level == 'localization' %]
		177	<h3>Localization data added</h3>
176	[% ELSE %]	178	[% ELSE %]
177	<h3>[% lis.level FILTER ucfirst \| html %] data added</h3>	179	<h3>[% lis.level FILTER ucfirst \| html %] data added</h3>
178	[% END %]	180	[% END %]
179	-

Return to bug 24973

Lines 312-317 moved to a different method. Link Here

(-)a/C4/Installer.pm (-1 / +7 lines)
312		312
313	sub load_sql_in_order {	313	sub load_sql_in_order {
314	my $self = shift;	314	my $self = shift;
		315	my $langchoice = shift;
315	my $all_languages = shift;	316	my $all_languages = shift;
316	my @sql_list = @_;	317	my @sql_list = @_;
317		318
Lines 346-358 sub load_sql_in_order { Link Here
346	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_offset_types.sql";	347	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_offset_types.sql";
347	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_credit_types.sql";	348	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_credit_types.sql";
348	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_debit_types.sql";	349	push @fnames, C4::Context->config('intranetdir') . "/installer/data/mysql/account_debit_types.sql";
		350	my $localization_file = C4::Context->config('intranetdir') .
		351	"/installer/data/$self->{dbms}/localization/$langchoice/custom.sql";
		352	if ( $langchoice ne 'en' and -f $localization_file ) {
		353	push @fnames, $localization_file;
		354	}
349	foreach my $file (@fnames) {	355	foreach my $file (@fnames) {
350	# warn $file;	356	# warn $file;
351	undef $/;	357	undef $/;
352	my $error = $self->load_sql($file);	358	my $error = $self->load_sql($file);
353	my @file = split qr(\/\|\\), $file;	359	my @file = split qr(\/\|\\), $file;
354	$lang = $file[ scalar(@file) - 3 ] unless ($lang);	360	$lang = $file[ scalar(@file) - 3 ] unless ($lang);
355	my $level = $file[ scalar(@file) - 2 ];	361	my $level = ( $file =~ /(localization)/ ) ? $1 : $file[ scalar(@file) - 2 ];
356	unless ($error) {	362	unless ($error) {
357	$systempreference .= "$file[scalar(@file)-1]\|"	363	$systempreference .= "$file[scalar(@file)-1]\|"
358	unless ( index( $systempreference, $file[ scalar(@file) - 1 ] ) >= 0 );	364	unless ( index( $systempreference, $file[ scalar(@file) - 1 ] ) >= 0 );

Line 0 Link Here

(-)a/installer/data/mysql/localization/es-ES/custom.sql (+29 lines)
	1	--
	2	-- System preferences that differ from the global defaults
	3	--
	4	-- This file is part of Koha.
	5	--
	6	-- Koha is free software; you can redistribute it and/or modify it
	7	-- under the terms of the GNU General Public License as published by
	8	-- the Free Software Foundation; either version 3 of the License, or
	9	-- (at your option) any later version.
	10	--
	11	-- Koha is distributed in the hope that it will be useful, but
	12	-- WITHOUT ANY WARRANTY; without even the implied warranty of
	13	-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	14	-- GNU General Public License for more details.
	15	--
	16	-- You should have received a copy of the GNU General Public License
	17	-- along with Koha; if not, see <http://www.gnu.org/licenses>.
	18
	19	UPDATE systempreferences SET value = 'padre\|madre' WHERE variable = 'borrowerRelationship';
	20	UPDATE systempreferences SET value = 'Sr.\|Sra.' WHERE variable = 'BorrowersTitles';
	21	UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';
	22	UPDATE systempreferences SET value = 'US' WHERE variable = 'AddressFormat';
	23	UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
	24	UPDATE systempreferences SET value = 'ddc' WHERE variable = 'DefaultClassificationSource';
	25	UPDATE systempreferences SET value = 'Bienvenido al catálogo!' WHERE variable = 'OpacMainUserBlock';
	26	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';
	27	UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';
	28	UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWeek';
	29	UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';