Attachment #157926 for bug #35065

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




use Modern::Perl;

return {
    bug_number  => "35065",
    description => "Move SelfCheckHelpMessage to additional contents",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        # Get any existing value from the SelfCheckHelpMessage system preference
        my ($selfcheckhelpmessage) = $dbh->selectrow_array(
            q|
            SELECT value FROM systempreferences WHERE variable='SelfCheckHelpMessage';
        |
        );
        if ($selfcheckhelpmessage) {

            # Insert any values found from system preference into additional_contents
            $dbh->do(
                "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'SelfCheckHelpMessage', 'SelfCheckHelpMessage', NULL, CAST(NOW() AS date) )"
            );

            my ($insert_id) = $dbh->selectrow_array(
                "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'SelfCheckHelpMessage' AND location = 'SelfCheckHelpMessage' LIMIT 1",
                {}
            );

            $dbh->do(
                "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'SelfCheckHelpMessage default', ?, 'default' )",
                undef, $insert_id, $selfcheckhelpmessage
            );

            # Remove old system preference
            $dbh->do("DELETE FROM systempreferences WHERE variable='SelfCheckHelpMessage'");
            say $out "Bug 35065 update done";
        }
    }
    }

Lines 656-662 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 lines)
656	('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),	656	('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),
657	('SearchWithISSNVariations','0',NULL,'If enabled, search on all variations of the ISSN','YesNo'),	657	('SearchWithISSNVariations','0',NULL,'If enabled, search on all variations of the ISSN','YesNo'),
658	('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'),	658	('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'),
659	('SelfCheckHelpMessage','','70\|10','Enter HTML to include under the basic Web-based Self Checkout instructions on the Help page','Textarea'),
660	('SelfCheckInModule', 0, NULL, 'Enable the standalone self-checkin module.', 'YesNo'),	659	('SelfCheckInModule', 0, NULL, 'Enable the standalone self-checkin module.', 'YesNo'),
661	('SelfCheckInTimeout','120','','Define the number of seconds before the self check-in module times out.','Integer'),	660	('SelfCheckInTimeout','120','','Define the number of seconds before the self check-in module times out.','Integer'),
662	('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','free'),	661	('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','free'),




                  1: Allow
                  0: "Don't allow"
            - patrons to return items through web-based self checkout system. 
        -
            - "Include the following HTML in the Help page of the web-based self checkout system:"
            - pref: SelfCheckHelpMessage
              type: textarea
              syntax: text/html
              class: code
        -
            - pref: AutoSelfCheckAllowed
              choices:

Lines 524-530 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/additional-contents.tt (-1 / +1 lines)
524	[% END %]	524	[% END %]
525	[% END %]	525	[% END %]
526	[% ELSE %]	526	[% ELSE %]
527	[% SET opac_available_options = [ 'OpacNavRight', 'opacheader', 'OpacCustomSearch', 'OpacMainUserBlock', 'opaccredits', 'OpacLoginInstructions', 'OpacNav', 'OpacNavBottom', 'OpacSuggestionInstructions', 'ArticleRequestsDisclaimerText', 'OpacMoreSearches', 'OpacMySummaryNote', 'OpacLibraryInfo', 'OpacMaintenanceNotice', 'OPACResultsSidebar', 'OpacSuppressionMessage', 'SCOMainUserBlock', 'SelfCheckInMainUserBlock', 'CatalogConcernHelp', 'CatalogConcernTemplate', 'CookieConsentBar', 'CookieConsentPopup', 'PatronSelfRegistrationAdditionalInstructions' ] %]	527	[% SET opac_available_options = [ 'OpacNavRight', 'opacheader', 'OpacCustomSearch', 'OpacMainUserBlock', 'opaccredits', 'OpacLoginInstructions', 'OpacNav', 'OpacNavBottom', 'OpacSuggestionInstructions', 'ArticleRequestsDisclaimerText', 'OpacMoreSearches', 'OpacMySummaryNote', 'OpacLibraryInfo', 'OpacMaintenanceNotice', 'OPACResultsSidebar', 'OpacSuppressionMessage', 'SCOMainUserBlock', 'SelfCheckInMainUserBlock', 'SelfCheckHelpMessage', 'CatalogConcernHelp', 'CatalogConcernTemplate', 'CookieConsentBar', 'CookieConsentPopup', 'PatronSelfRegistrationAdditionalInstructions' ] %]
528	<optgroup label="OPAC">	528	<optgroup label="OPAC">
529	[% FOREACH l IN opac_available_options.sort %]	529	[% FOREACH l IN opac_available_options.sort %]
530	[% IF l == location %]	530	[% IF l == location %]




[% USE Koha %]
[% USE Asset %]
[% USE KohaDates %]
[% USE AdditionalContents %]
[% PROCESS 'i18n.inc' %]
[% INCLUDE 'doc-head-open.inc' %]
[% SET SelfCheckHelpMessage = AdditionalContents.get( location => "SelfCheckHelpMessage", lang => lang, library => logged_in_user.branchcode || default_branch, blocktitle => 0 ) %]
<title>Self checkout help &rsaquo; [% IF ( LibraryNameTitle ) %][% LibraryNameTitle | html %][% ELSE %]Koha [% END %]</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="generator" content="Koha [% Version | html %]" /> <!-- leave this for stats -->


                    [% IF ( SelfCheckHelpMessage ) %]
                        <div id="selfcheckhelpmessage">
                            [% PROCESS koha_news_block news => SelfCheckHelpMessage %]
                        </div>
                    [% END %]

- 

Return to bug 35065

Lines 1157-1168 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-6 lines)
1157	1: Allow	1157	1: Allow
1158	0: "Don't allow"	1158	0: "Don't allow"
1159	- patrons to return items through web-based self checkout system.	1159	- patrons to return items through web-based self checkout system.
1160	-
1161	- "Include the following HTML in the Help page of the web-based self checkout system:"
1162	- pref: SelfCheckHelpMessage
1163	type: textarea
1164	syntax: text/html
1165	class: code
1166	-	1160	-
1167	- pref: AutoSelfCheckAllowed	1161	- pref: AutoSelfCheckAllowed
1168	choices:	1162	choices:

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-35065-move-SelfCheckHelpMessage-to-additional-contents.pl (+38 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "35065",
	5	description => "Move SelfCheckHelpMessage to additional contents",
	6	up => sub {
	7	my ($args) = @_;
	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
	9
	10	# Get any existing value from the SelfCheckHelpMessage system preference
	11	my ($selfcheckhelpmessage) = $dbh->selectrow_array(
	12	q\|
	13	SELECT value FROM systempreferences WHERE variable='SelfCheckHelpMessage';
	14	\|
	15	);
	16	if ($selfcheckhelpmessage) {
	17
	18	# Insert any values found from system preference into additional_contents
	19	$dbh->do(
	20	"INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'SelfCheckHelpMessage', 'SelfCheckHelpMessage', NULL, CAST(NOW() AS date) )"
	21	);
	22
	23	my ($insert_id) = $dbh->selectrow_array(
	24	"SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'SelfCheckHelpMessage' AND location = 'SelfCheckHelpMessage' LIMIT 1",
	25	{}
	26	);
	27
	28	$dbh->do(
	29	"INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'SelfCheckHelpMessage default', ?, 'default' )",
	30	undef, $insert_id, $selfcheckhelpmessage
	31	);
	32
	33	# Remove old system preference
	34	$dbh->do("DELETE FROM systempreferences WHERE variable='SelfCheckHelpMessage'");
	35	say $out "Bug 35065 update done";
	36	}
	37	}
	38	}

Lines 2-9 Link Here

(-)a/koha-tmpl/opac-tmpl/bootstrap/en/modules/sco/help.tt (-2 / +3 lines)
2	[% USE Koha %]	2	[% USE Koha %]
3	[% USE Asset %]	3	[% USE Asset %]
4	[% USE KohaDates %]	4	[% USE KohaDates %]
		5	[% USE AdditionalContents %]
5	[% PROCESS 'i18n.inc' %]	6	[% PROCESS 'i18n.inc' %]
6	[% INCLUDE 'doc-head-open.inc' %]	7	[% INCLUDE 'doc-head-open.inc' %]
		8	[% SET SelfCheckHelpMessage = AdditionalContents.get( location => "SelfCheckHelpMessage", lang => lang, library => logged_in_user.branchcode \|\| default_branch, blocktitle => 0 ) %]
7	<title>Self checkout help &rsaquo; [% IF ( LibraryNameTitle ) %][% LibraryNameTitle \| html %][% ELSE %]Koha [% END %]</title>	9	<title>Self checkout help &rsaquo; [% IF ( LibraryNameTitle ) %][% LibraryNameTitle \| html %][% ELSE %]Koha [% END %]</title>
8	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />	10	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
9	<meta name="generator" content="Koha [% Version \| html %]" /> <!-- leave this for stats -->	11	<meta name="generator" content="Koha [% Version \| html %]" /> <!-- leave this for stats -->
Lines 40-46 Link Here
40		42
41	[% IF ( SelfCheckHelpMessage ) %]	43	[% IF ( SelfCheckHelpMessage ) %]
42	<div id="selfcheckhelpmessage">	44	<div id="selfcheckhelpmessage">
43	[% SelfCheckHelpMessage \| $raw %]	45	[% PROCESS koha_news_block news => SelfCheckHelpMessage %]
44	</div>	46	</div>
45	[% END %]	47	[% END %]
46		48
47	-