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

(-)a/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl (-2 / +2 lines)
Lines 17-23 if( CheckVersion( $DBversion ) ) { Link Here
17
    });
17
    });
18
    $dbh->do(q{
18
    $dbh->do(q{
19
        UPDATE letter SET
19
        UPDATE letter SET
20
        content = REPLACE(content, "It\'s too late to renew this checkout.", "It\'s too late to renew this item.")
20
        content = REPLACE(content, "It's too late to renew this checkout.", "It's too late to renew this item.")
21
        WHERE code = 'AUTO_RENEWALS';
21
        WHERE code = 'AUTO_RENEWALS';
22
    });
22
    });
23
    $dbh->do(q{
23
    $dbh->do(q{
Lines 27-33 if( CheckVersion( $DBversion ) ) { Link Here
27
    });
27
    });
28
    $dbh->do(q{
28
    $dbh->do(q{
29
        UPDATE letter SET
29
        UPDATE letter SET
30
        content = REPLACE(content, "The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due | $KohaDates as_due_date => 1 %]", "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
30
        content = REPLACE(content, "The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]", "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due as_due_date => 1 %]
31
")
31
")
32
        WHERE code = 'AUTO_RENEWALS';
32
        WHERE code = 'AUTO_RENEWALS';
33
    });
33
    });
(-)a/installer/data/mysql/updatedatabase.pl (-19 / +18 lines)
Lines 14440-14463 if( CheckVersion( $DBversion ) ) { Link Here
14440
    $dbh->do(q{
14440
    $dbh->do(q{
14441
            INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
14441
            INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
14442
        "Dear [% borrower.firstname %] [% borrower.surname %],
14442
        "Dear [% borrower.firstname %] [% borrower.surname %],
14443
        [% IF checkout.auto_renew_error %]
14443
[% IF checkout.auto_renew_error %]
14444
        The following item, [% biblio.title %], has not been renewed because:
14444
The following item, [% biblio.title %], has not been renewed because:
14445
        [% IF checkout.auto_renew_error == 'too_many' %]
14445
[% IF checkout.auto_renew_error == 'too_many' %]
14446
        You have reached the maximum number of checkouts possible.
14446
You have reached the maximum number of checkouts possible.
14447
        [% ELSIF checkout.auto_renew_error == 'on_reserve' %]
14447
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
14448
        This item is on hold for another patron.
14448
This item is on hold for another patron.
14449
        [% ELSIF checkout.auto_renew_error == 'restriction' %]
14449
[% ELSIF checkout.auto_renew_error == 'restriction' %]
14450
        You are currently restricted.
14450
You are currently restricted.
14451
        [% ELSIF checkout.auto_renew_error == 'overdue' %]
14451
[% ELSIF checkout.auto_renew_error == 'overdue' %]
14452
        You have overdue items.
14452
You have overdue items.
14453
        [% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
14453
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
14454
        It\'s too late to renew this item.
14454
It\'s too late to renew this item.
14455
        [% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
14455
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
14456
        Your total unpaid fines are too high.
14456
Your total unpaid fines are too high.
14457
        [% END %]
14457
[% END %]
14458
        [% ELSE %]
14458
[% ELSE %]
14459
        The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
14459
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
14460
        [% END %]", 'email');
14460
[% END %]", 'email');
14461
    });
14461
    });
14462
14462
14463
    SetVersion( $DBversion );
14463
    SetVersion( $DBversion );
14464
- 

Return to bug 24378