Attachment #128707 for bug #29557

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




use Modern::Perl;

return {
    bug_number => "29557",
    description => "Add auto_account_expired to AUTO_RENEWALS",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        my @c = $dbh->do(q{
            UPDATE letter
            SET content=REPLACE(content, "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]\r\nThis item must be renewed at the library.\r\n[% END %]", "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]\r\nThis item must be renewed at the library.\r\n[% ELSIF checkout.auto_renew_error == 'auto_account_expired' %]\r\nYour account has expired.\r\n[% END %]")
            WHERE code="AUTO_RENEWALS"
        });
    },
}

Lines 1509-1514 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +2 lines)
1509	- "Your total unpaid fines are too high."	1509	- "Your total unpaid fines are too high."
1510	- "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]"	1510	- "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]"
1511	- "This item must be renewed at the library."	1511	- "This item must be renewed at the library."
		1512	- "[% ELSIF checkout.auto_renew_error == 'auto_account_expired' %]"
		1513	- "Your account has expired."
1512	- "[% END %]"	1514	- "[% END %]"
1513	- "[% ELSE %]"	1515	- "[% ELSE %]"
1514	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"	1516	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"
1515	-

Return to bug 29557

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29557.pl (+15 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "29557",
	5	description => "Add auto_account_expired to AUTO_RENEWALS",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	my @c = $dbh->do(q{
	10	UPDATE letter
	11	SET content=REPLACE(content, "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]\r\nThis item must be renewed at the library.\r\n[% END %]", "[% ELSIF checkout.auto_renew_error == 'too_unseen' %]\r\nThis item must be renewed at the library.\r\n[% ELSIF checkout.auto_renew_error == 'auto_account_expired' %]\r\nYour account has expired.\r\n[% END %]")
	12	WHERE code="AUTO_RENEWALS"
	13	});
	14	},
	15	}