Attachment #170713 for bug #35152

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




use Modern::Perl;

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

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

            # 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', 'RoutingListNote', 'RoutingListNote', NULL, CAST(NOW() AS date) )"
            );

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

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

            say $out "Added 'RoutingListNote' additional content";
        }

        # Remove old system preference
        $dbh->do("DELETE FROM systempreferences WHERE variable='RoutingListNote'");
        say $out "Removed system preference 'RoutingListNote'";

    },
};

Lines 680-686 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 lines)
680	('RisExportAdditionalFields', '', NULL , 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),	680	('RisExportAdditionalFields', '', NULL , 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
681	('RoundFinesAtPayment','0', NULL,'If enabled any fines with fractions of a cent will be rounded to the nearest cent when payments are coll ected. e.g. 1.004 will be paid off by a 1.00 payment','YesNo'),	681	('RoundFinesAtPayment','0', NULL,'If enabled any fines with fractions of a cent will be rounded to the nearest cent when payments are coll ected. e.g. 1.004 will be paid off by a 1.00 payment','YesNo'),
682	('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),	682	('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
683	('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70\|10','Define a note to be shown on all routing lists','Textarea'),
684	('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),	683	('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
685	('SavedSearchFilters', '0', NULL, 'Allow staff with permission to create/edit custom search filters', 'YesNo'),	684	('SavedSearchFilters', '0', NULL, 'Allow staff with permission to create/edit custom search filters', 'YesNo'),
686	('SCOAllowCheckin','0','','If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),	685	('SCOAllowCheckin','0','','If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),

Lines 90-95 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/html-customization-help.inc (+4 lines)
90	Show the following content on the patron self-registration confirmation page.	90	Show the following content on the patron self-registration confirmation page.
91	</div>	91	</div>
92		92
		93	<div id="RoutingListNote" class="hint customization_note">
		94	Include the following note on all routing list slips.
		95	</div>
		96
93	<div id="SCOMainUserBlock_notes" class="hint customization_note">	97	<div id="SCOMainUserBlock_notes" class="hint customization_note">
94	Show this content on the web-based self checkout screen.	98	Show this content on the web-based self checkout screen.
95	</div>	99	</div>




          choices:
              1: Use
              0: "Don't use"
        - the routing list feature in the serials module. A custom message can be shown on routing slips by creating an <a href="/cgi-bin/koha/tools/additional-contents.pl?category=html_customizations">HTML customization</a> in the RoutingListNote region.
    -
        - pref: RoutingListAddReserves
          choices:
              1: Place
              0: "Don't place"
        - received serials on hold if they are on a routing list.
    -
        - "Include the following note on all routing lists:"
        - pref: RoutingListNote
          type: textarea
          class: code
    -
        - Show the
        - pref: StaffSerialIssueDisplayCount




[% USE Koha %]
[% USE raw %]
[% USE AdditionalContents %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>Routing slip preview &rsaquo; Serials &rsaquo; Koha</title>

        </div> <!-- /.page-section -->

<div id="routingnotes">
    [%- SET RoutingListNote = AdditionalContents.get( location => "RoutingListNote", lang => lang, library => logged_in_user.branchcode ) -%]

    [% IF ( RoutingListNote.content && RoutingListNote.content.count > 0 ) %]
        <div id="[% RoutingListNote.location | html %]">
            [% FOREACH n IN RoutingListNote.content %]
                <div class="[% n.lang | html %]_item">
                    <div class="[% n.lang | html %]_body">[% n.content | $raw %]</div>
                </div>
            [% END %]
        </div>
    [% END %]

    <p id="routingnote">[% routingnotes | html %]</p>
</div>


Lines 535-541 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/additional-contents.tt (-2 / +1 lines)
535	[% END %]	535	[% END %]
536	[% END %]	536	[% END %]
537	</optgroup>	537	</optgroup>
538	[% SET staff_available_options = [ 'IntranetmainUserblock', 'StaffAcquisitionsHome', 'StaffAuthoritiesHome', 'StaffCataloguingHome', 'StaffListsHome', 'StaffPatronsHome', 'StaffPOSHome', 'StaffSerialsHome' ] %]	538	[% SET staff_available_options = [ 'IntranetmainUserblock', 'RoutingListNote', 'StaffAcquisitionsHome', 'StaffAuthoritiesHome', 'StaffCataloguingHome', 'StaffListsHome', 'StaffPatronsHome', 'StaffPOSHome', 'StaffSerialsHome' ] %]
539	<optgroup label="Staff">	539	<optgroup label="Staff">
540	[% FOREACH l IN staff_available_options.sort %]	540	[% FOREACH l IN staff_available_options.sort %]
541	[% IF l == location %]	541	[% IF l == location %]
542	-

Return to bug 35152

Lines 20-37 Serials: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/serials.pref (-6 / +1 lines)
20	choices:	20	choices:
21	1: Use	21	1: Use
22	0: "Don't use"	22	0: "Don't use"
23	- the routing list feature in the serials module.	23	- the routing list feature in the serials module. A custom message can be shown on routing slips by creating an <a href="/cgi-bin/koha/tools/additional-contents.pl?category=html_customizations">HTML customization</a> in the RoutingListNote region.
24	-	24	-
25	- pref: RoutingListAddReserves	25	- pref: RoutingListAddReserves
26	choices:	26	choices:
27	1: Place	27	1: Place
28	0: "Don't place"	28	0: "Don't place"
29	- received serials on hold if they are on a routing list.	29	- received serials on hold if they are on a routing list.
30	-
31	- "Include the following note on all routing lists:"
32	- pref: RoutingListNote
33	type: textarea
34	class: code
35	-	30	-
36	- Show the	31	- Show the
37	- pref: StaffSerialIssueDisplayCount	32	- pref: StaffSerialIssueDisplayCount

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-35152-move-RoutingListNote-to-additional-contents.pl (+41 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "35152",
	5	description => "Move RoutingListNote 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 RoutingListNote system preference
	11	my ($routinglistnote) = $dbh->selectrow_array(
	12	q\|
	13	SELECT value FROM systempreferences WHERE variable='RoutingListNote';
	14	\|
	15	);
	16	if ($routinglistnote) {
	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', 'RoutingListNote', 'RoutingListNote', 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 = 'RoutingListNote' AND location = 'RoutingListNote' LIMIT 1",
	25	{}
	26	);
	27
	28	$dbh->do(
	29	"INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'RoutingListNote default', ?, 'default' )",
	30	undef, $insert_id, $routinglistnote
	31	);
	32
	33	say $out "Added 'RoutingListNote' additional content";
	34	}
	35
	36	# Remove old system preference
	37	$dbh->do("DELETE FROM systempreferences WHERE variable='RoutingListNote'");
	38	say $out "Removed system preference 'RoutingListNote'";
	39
	40	},
	41	};

Lines 1-5 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/routing-preview-slip.tt (-1 / +13 lines)
1	[% USE Koha %]	1	[% USE Koha %]
2	[% USE raw %]	2	[% USE raw %]
		3	[% USE AdditionalContents %]
3	[% SET footerjs = 1 %]	4	[% SET footerjs = 1 %]
4	[% INCLUDE 'doc-head-open.inc' %]	5	[% INCLUDE 'doc-head-open.inc' %]
5	<title>Routing slip preview &rsaquo; Serials &rsaquo; Koha</title>	6	<title>Routing slip preview &rsaquo; Serials &rsaquo; Koha</title>
Lines 33-39 Link Here
33	</div> <!-- /.page-section -->	34	</div> <!-- /.page-section -->
34		35
35	<div id="routingnotes">	36	<div id="routingnotes">
36	<p id="generalroutingnote">[% Koha.Preference('RoutingListNote') \| $raw %]</p>	37	[%- SET RoutingListNote = AdditionalContents.get( location => "RoutingListNote", lang => lang, library => logged_in_user.branchcode ) -%]
		38
		39	[% IF ( RoutingListNote.content && RoutingListNote.content.count > 0 ) %]
		40	<div id="[% RoutingListNote.location \| html %]">
		41	[% FOREACH n IN RoutingListNote.content %]
		42	<div class="[% n.lang \| html %]_item">
		43	<div class="[% n.lang \| html %]_body">[% n.content \| $raw %]</div>
		44	</div>
		45	[% END %]
		46	</div>
		47	[% END %]
		48
37	<p id="routingnote">[% routingnotes \| html %]</p>	49	<p id="routingnote">[% routingnotes \| html %]</p>
38	</div>	50	</div>
39		51