Attachment #99706 for bug #23795

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {

    # get list of installed translations
    require C4::Languages;
    my @langs;
    my $tlangs = C4::Languages::getTranslatedLanguages();

    foreach my $language ( @$tlangs ) {
        foreach my $sublanguage ( @{$language->{'sublanguages_loop'}} ) {
            push @langs, $sublanguage->{'rfc4646_subtag'};
        }
    }

    # Get any existing value from the opaccredits system preference
    my ($opaccredits) = $dbh->selectrow_array( q|
        SELECT value FROM systempreferences WHERE variable='opaccredits';
    |);
    if( $opaccredits ){
        foreach my $lang ( @langs ) {
            print "Inserting opaccredits contents into $lang news item...\n";
            # If there is a value in the opaccredits preference, insert it into opac_news
            $dbh->do("INSERT INTO opac_news (branchcode, lang, title, content ) VALUES (NULL, ?, '', ?)", undef, "opaccredits_$lang", $opaccredits);
        }
    }
    # Remove the opaccredits system preference
    $dbh->do("DELETE FROM systempreferences WHERE variable='opaccredits'");
    SetVersion ($DBversion);
    print "Upgrade to $DBversion done (Bug 23795: Convert OpacCredits system preference to news block)\n";
}

Lines 371-377 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 lines)
371	('OpacCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the OPAC', 'YesNo'),	371	('OpacCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the OPAC', 'YesNo'),
372	('OPACCustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed at the OPAC. CustomCoverImagesURL must be defined.','YesNo'),	372	('OPACCustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed at the OPAC. CustomCoverImagesURL must be defined.','YesNo'),
373	('OpacCustomSearch','','70\|10','Replace the search box on the OPAC with the provided HTML','Textarea'),	373	('OpacCustomSearch','','70\|10','Replace the search box on the OPAC with the provided HTML','Textarea'),
374	('opaccredits','','70\|10','Define HTML Credits at the bottom of the OPAC page','Textarea'),
375	('OPACdefaultSortField','relevance','relevance\|popularity\|call_number\|pubdate\|acqdate\|title\|author','Specify the default field used for sorting','Choice'),	374	('OPACdefaultSortField','relevance','relevance\|popularity\|call_number\|pubdate\|acqdate\|title\|author','Specify the default field used for sorting','Choice'),
376	('OPACdefaultSortOrder','dsc','asc\|dsc\|za\|az','Specify the default sort order','Choice'),	375	('OPACdefaultSortOrder','dsc','asc\|dsc\|za\|az','Specify the default sort order','Choice'),
377	('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),	376	('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),




              syntax: text/html
              class: code
        -
            - "Include the following HTML in the footer of all pages in the OPAC:"
            - pref: opaccredits
              type: textarea
              syntax: text/html
              class: code
        -
            - 'Include a "More Searches" box on the detail pages of items on the OPAC, with the following HTML (leave blank to disable):'
            - '<br />Note: The placeholders {BIBLIONUMBER}, {CONTROLNUMBER}, {TITLE}, {ISBN}, {ISSN} and {AUTHOR} will be replaced with information from the displayed record.'
            - pref: OPACSearchForTitleIn

Lines 327-333 Edit news item[% ELSE %]Add news item[% END %][% ELSE %]News[% END %]</div> Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/koha-news.tt (-1 / +1 lines)
327	[% END %]	327	[% END %]
328	[% FOREACH lang_lis IN lang_list %]	328	[% FOREACH lang_lis IN lang_list %]
329	<optgroup label="[% lang_lis.language \| html %]">	329	<optgroup label="[% lang_lis.language \| html %]">
330	[% FOREACH location IN [ '', 'OpacNavRight', 'opacheader' ] %]	330	[% FOREACH location IN [ '', 'OpacNavRight', 'opacheader', 'opaccredits' ] %]
331	[% IF ( location == '' ) %]	331	[% IF ( location == '' ) %]
332	[% SET location_lang = lang_lis.language %]	332	[% SET location_lang = lang_lis.language %]
333	[% location = BLOCK %]OPAC news[% END %]	333	[% location = BLOCK %]OPAC news[% END %]




[% USE raw %]
[% USE Koha %]
[% USE KohaNews %]
[%- USE KohaPlugins -%]
[% USE Asset %]
[% SET opaccredits = KohaNews.get( location => "opaccredits", lang => lang, library => branchcode ) %]
[% UNLESS ( is_popup ) %]
    [% SET OpacLangSelectorMode = Koha.Preference('OpacLangSelectorMode') %]
    [% IF ( opaccredits ) %]
        <div class="container-fluid">
            <div class="row-fluid">
                <div id="opaccredits">
                    [% PROCESS koha_news_block news => opaccredits %]
                        [% opaccredits | $raw %]
                    </div>
                </div>
            </div>
        </div>
- 

Return to bug 23795

Lines 251-262 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-6 lines)
251	syntax: text/html	251	syntax: text/html
252	class: code	252	class: code
253	-	253	-
254	- "Include the following HTML in the footer of all pages in the OPAC:"
255	- pref: opaccredits
256	type: textarea
257	syntax: text/html
258	class: code
259	-
260	- 'Include a "More Searches" box on the detail pages of items on the OPAC, with the following HTML (leave blank to disable):'	254	- 'Include a "More Searches" box on the detail pages of items on the OPAC, with the following HTML (leave blank to disable):'
261	- '<br />Note: The placeholders {BIBLIONUMBER}, {CONTROLNUMBER}, {TITLE}, {ISBN}, {ISSN} and {AUTHOR} will be replaced with information from the displayed record.'	255	- '<br />Note: The placeholders {BIBLIONUMBER}, {CONTROLNUMBER}, {TITLE}, {ISBN}, {ISSN} and {AUTHOR} will be replaced with information from the displayed record.'
262	- pref: OPACSearchForTitleIn	256	- pref: OPACSearchForTitleIn

Lines 584-590 sub get_template_and_user { Link Here

(-)a/C4/Auth.pm (-2 lines)
584	hidelostitems => C4::Context->preference("hidelostitems"),	584	hidelostitems => C4::Context->preference("hidelostitems"),
585	mylibraryfirst => ( C4::Context->preference("SearchMyLibraryFirst") && C4::Context->userenv ) ? C4::Context->userenv->{'branch'} : '',	585	mylibraryfirst => ( C4::Context->preference("SearchMyLibraryFirst") && C4::Context->userenv ) ? C4::Context->userenv->{'branch'} : '',
586	opacbookbag => "" . C4::Context->preference("opacbookbag"),	586	opacbookbag => "" . C4::Context->preference("opacbookbag"),
587	opaccredits => "" . C4::Context->preference("opaccredits"),
588	OpacFavicon => C4::Context->preference("OpacFavicon"),	587	OpacFavicon => C4::Context->preference("OpacFavicon"),
589	opaclanguagesdisplay => "" . C4::Context->preference("opaclanguagesdisplay"),	588	opaclanguagesdisplay => "" . C4::Context->preference("opaclanguagesdisplay"),
590	opacreadinghistory => C4::Context->preference("opacreadinghistory"),	589	opacreadinghistory => C4::Context->preference("opacreadinghistory"),
Lines 1263-1269 sub checkauth { Link Here
1263	opacuserlogin => C4::Context->preference("opacuserlogin"),	1262	opacuserlogin => C4::Context->preference("opacuserlogin"),
1264	OpacNav => C4::Context->preference("OpacNav"),	1263	OpacNav => C4::Context->preference("OpacNav"),
1265	OpacNavBottom => C4::Context->preference("OpacNavBottom"),	1264	OpacNavBottom => C4::Context->preference("OpacNavBottom"),
1266	opaccredits => C4::Context->preference("opaccredits"),
1267	OpacFavicon => C4::Context->preference("OpacFavicon"),	1265	OpacFavicon => C4::Context->preference("OpacFavicon"),
1268	opacreadinghistory => C4::Context->preference("opacreadinghistory"),	1266	opacreadinghistory => C4::Context->preference("opacreadinghistory"),
1269	opaclanguagesdisplay => C4::Context->preference("opaclanguagesdisplay"),	1267	opaclanguagesdisplay => C4::Context->preference("opaclanguagesdisplay"),

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23795-move-opaccredits-to-news.perl (+30 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	# get list of installed translations
	5	require C4::Languages;
	6	my @langs;
	7	my $tlangs = C4::Languages::getTranslatedLanguages();
	8
	9	foreach my $language ( @$tlangs ) {
	10	foreach my $sublanguage ( @{$language->{'sublanguages_loop'}} ) {
	11	push @langs, $sublanguage->{'rfc4646_subtag'};
	12	}
	13	}
	14
	15	# Get any existing value from the opaccredits system preference
	16	my ($opaccredits) = $dbh->selectrow_array( q\|
	17	SELECT value FROM systempreferences WHERE variable='opaccredits';
	18	\|);
	19	if( $opaccredits ){
	20	foreach my $lang ( @langs ) {
	21	print "Inserting opaccredits contents into $lang news item...\n";
	22	# If there is a value in the opaccredits preference, insert it into opac_news
	23	$dbh->do("INSERT INTO opac_news (branchcode, lang, title, content ) VALUES (NULL, ?, '', ?)", undef, "opaccredits_$lang", $opaccredits);
	24	}
	25	}
	26	# Remove the opaccredits system preference
	27	$dbh->do("DELETE FROM systempreferences WHERE variable='opaccredits'");
	28	SetVersion ($DBversion);
	29	print "Upgrade to $DBversion done (Bug 23795: Convert OpacCredits system preference to news block)\n";
	30	}

Lines 1-16 Link Here

(-)a/koha-tmpl/opac-tmpl/bootstrap/en/includes/opac-bottom.inc (-5 / +4 lines)
1	[% USE raw %]	1	[% USE raw %]
2	[% USE Koha %]	2	[% USE Koha %]
		3	[% USE KohaNews %]
3	[%- USE KohaPlugins -%]	4	[%- USE KohaPlugins -%]
4	[% USE Asset %]	5	[% USE Asset %]
		6	[% SET opaccredits = KohaNews.get( location => "opaccredits", lang => lang, library => branchcode ) %]
5	[% UNLESS ( is_popup ) %]	7	[% UNLESS ( is_popup ) %]
6	[% SET OpacLangSelectorMode = Koha.Preference('OpacLangSelectorMode') %]	8	[% SET OpacLangSelectorMode = Koha.Preference('OpacLangSelectorMode') %]
7	[% IF ( opaccredits ) %]	9	[% IF ( opaccredits ) %]
8	<div class="container-fluid">	10	<div class="container-fluid">
9	<div class="row-fluid">	11	<div class="row-fluid">
10	<div class="span12">	12	<div id="opaccredits">
11	<div id="opaccredits" class="noprint">	13	[% PROCESS koha_news_block news => opaccredits %]
12	[% opaccredits \| $raw %]
13	</div>
14	</div>	14	</div>
15	</div>	15	</div>
16	</div>	16	</div>
17	-