Attachment 104675 Details for Bug 23787 – Bug 23787: Add sample AUTO_RENEWALS notice to translatd installers

[patch] Bug 23787: Add sample AUTO_RENEWALS notice to translatd installers

Bug-23787-Add-sample-AUTORENEWALS-notice-to-transl.patch (text/plain), 13.25 KB, created by Jonathan Druart on 2020-05-11 10:28:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-05-11 10:28:47 UTC

Size: 13.25 KB

patch

obsolete

>From 49e452731d7e57734ef9766ea9fdcc0dd9cc7277 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Mon, 13 Apr 2020 15:04:37 +0200
>Subject: [PATCH] Bug 23787: Add sample AUTO_RENEWALS notice to translatd
> installers
>
>This adds the default auto renewal notice to the translated
>installers. Translating will be handled by maintainers of the
>installers, but this way we don't end up with installations
>having a different set of notices than others.
>
>To test:
>- Verify the sample_notices.sql files load correctly
>or
>- Run the web installer for each of those languages and
>  verify sample_notices loads correctly.
>
>Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> .../mysql/de-DE/mandatory/sample_notices.sql  | 21 +++++++++++++++++++
> .../fr-CA/obligatoire/sample_notices.sql      | 21 +++++++++++++++++++
> .../fr-FR/1-Obligatoire/sample_notices.sql    | 21 +++++++++++++++++++
> .../data/mysql/it-IT/necessari/notices.sql    | 21 +++++++++++++++++++
> .../nb-NO/1-Obligatorisk/sample_notices.sql   | 21 +++++++++++++++++++
> .../mysql/pl-PL/mandatory/sample_notices.sql  | 21 +++++++++++++++++++
> .../mysql/ru-RU/mandatory/sample_notices.sql  | 21 +++++++++++++++++++
> .../mysql/uk-UA/mandatory/sample_notices.sql  | 21 +++++++++++++++++++
> 8 files changed, 168 insertions(+)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>index 0fbf5f73d2..e04081dfe0 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -386,3 +386,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>index ba88804699..21f3f81289 100644
>--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>@@ -268,3 +268,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>index 6106d737f3..db36b2e5c6 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -379,3 +379,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
>index e462da9d00..6727b24aa7 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -382,3 +382,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>index 8439fd96d8..cbaf6ab04e 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -398,3 +398,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>index 6373e2e975..65ee704a31 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -376,3 +376,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>index f9c4fc55d5..ad8ecaad69 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -378,3 +378,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>index 5356ad74f4..0b40c33ac8 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -469,3 +469,24 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
>     </tr>
> </tfoot>
> </table>', 'print', 'default');
>+
>+INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
>+"Dear [% borrower.firstname %] [% borrower.surname %],
>+[% IF checkout.auto_renew_error %]
>+The following item, [% biblio.title %], has not been renewed because:
>+[% IF checkout.auto_renew_error == 'too_many' %]
>+You have reached the maximum number of checkouts possible.
>+[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
>+This item is on hold for another patron.
>+[% ELSIF checkout.auto_renew_error == 'restriction' %]
>+You are currently restricted.
>+[% ELSIF checkout.auto_renew_error == 'overdue' %]
>+You have overdue items.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
>+It\'s too late to renew this item.
>+[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
>+Your total unpaid fines are too high.
>+[% END %]
>+[% ELSE %]
>+The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
>+[% END %]", 'email');
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 23787: 93937 | 94968 | 100418 | 100486 | 100526 | 102731 | 102829 | 102830 | 102831 | 102868 | 102869 | 103763 | 104385 | 104675 | 104676 | 104677