Attachment 74762 Details for Bug 1985 – Bug 1985: Follow up - Add sample letter to other languages

[patch] Bug 1985: Follow up - Add sample letter to other languages

Bug-1985-Follow-up---Add-sample-letter-to-other-la.patch (text/plain), 15.40 KB, created by Mark Tompsett on 2018-04-23 18:14:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2018-04-23 18:14:45 UTC

Size: 15.40 KB

patch

obsolete

>From 978c838754405d3c8bf5f5f7bd39dff8866f3e77 Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Fri, 26 May 2017 10:05:54 -0400
>Subject: [PATCH] Bug 1985: Follow up - Add sample letter to other languages
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>As per comment #36, the letter COMMENT_CREATED has been added
>to the other languages.
>
>TEST PLAN
>---------
>0) Back up your letters table
>1) In your mysql client after selected your Koha database,
>   Run this:
>
>SET foreign_key_checks = 0;
>truncate letter;
>source installer/data/mysql/de-DE/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/es-ES/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/it-IT/necessari/notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/en/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>
>   -- there should be 9 counts of 1.
>2) Restore your letters table.
>
>Signed-off-by: Marc VÃ©ron <veron@veron.ch>
>---
> .../data/mysql/de-DE/mandatory/sample_notices.sql  | 25 +++++++++++++++++++++
> .../data/mysql/es-ES/mandatory/sample_notices.sql  | 24 ++++++++++++++++++++
> .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   | 25 +++++++++++++++++++++
> installer/data/mysql/it-IT/necessari/notices.sql   | 25 +++++++++++++++++++++
> .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql  | 25 +++++++++++++++++++++
> .../data/mysql/pl-PL/mandatory/sample_notices.sql  | 25 +++++++++++++++++++++
> .../data/mysql/ru-RU/mandatory/sample_notices.sql  | 25 +++++++++++++++++++++
> .../data/mysql/uk-UA/mandatory/sample_notices.sql  | 26 ++++++++++++++++++++++
> 8 files changed, 200 insertions(+)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>index 839bd9e..900f218 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -118,6 +118,31 @@ Vielen Dank,
> Ihr Bibliotheksteam'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Einladung zum Teilen einer Liste', '0', 'Teilen der Liste <<listname>>', 'Lieber Benutzer,
> 
>diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>index 0cf9d7e..b9c9aeb 100644
>--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>@@ -120,6 +120,30 @@ Your library account has been created. Please verify your email address by click
> If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
> 
> INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
> 
>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 312f4da..237a2be 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -123,6 +123,31 @@ Votre compte de bibliothÃ¨que a Ã©tÃ© crÃ©Ã©. Veuillez valider votre adresse ema
> Si vous n''Ãªtes pas Ã  l''origine de cette inscription, vous pouvez ignorer ce message.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Renouvellements','Renouvellements','Les documents suivants ont Ã©tÃ© renouvelÃ©s\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci, <<branches.branchname>>.');
> 
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
>diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
>index 5fdc609..ae1ca4d 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -127,6 +127,31 @@ Sei stato registrato tra gli utenti della biblioteca. Per favore verifica il tuo
> Se non hai fatto tu la richiesta, puoi ignorare questo messaggio. La richciesta scadrÃ  in posco tempo.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Invito per condividere una lista', '0', 'Condivisione lista <<listname>>', 'Salve,
> 
>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 6ac9cb4..9676782 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -144,6 +144,31 @@ D har blitt registrert som bruker av biblioteket. Verifiser epostadressen din ve
> Dersom du ikke har bedt om Ã¥ bli registret som bruker av biblioteket kan du se bort fra denne engangsmeldingen. ForespÃ¸rselen vil snart gÃ¥ ut pÃ¥ dato.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
> 
>diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>index f44f1c0..29dd256 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -122,6 +122,31 @@ Your library account has been created. Please verify your email address by click
> If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
> 
>diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>index 0de34d4..4858e53 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -122,6 +122,31 @@ Your library account has been created. Please verify your email address by click
> If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
> 
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
>diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>index 4664e06..43bded7 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -217,6 +217,32 @@ INSERT INTO  letter (module, code, branchcode, name, is_html, title, content) VA
>  ÐÐ°ÑÐ° Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ°.');
> 
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
>+
> INSERT INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
> ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Ð¿Ð¾Ð²ÑÐ´Ð¾Ð¼Ð»ÐµÐ½Ð½Ñ Ð¿ÑÐ¾ Ð¾ÑÑÐ¸Ð¼Ð°Ð½Ð½Ñ', '0', 'ÐÐ°Ð¼Ð¾Ð²Ð»ÐµÐ½Ð½Ñ Ð¾ÑÑÐ¸Ð¼Ð°Ð½Ð¾',
>  'ÐÐ¾ÑÐ¾Ð³(Ð¸Ð¹/Ð°) <<borrowers.firstname>> <<borrowers.surname>>,\n\n ÐÐ°Ð¼Ð¾Ð²Ð»ÐµÐ½Ð½Ñ â<<aqorders.ordernumber>>â (<<biblio.title>>) ÐÑÑÐ¸Ð¼Ð°Ð½Ð¾.\n\nÐÐ°ÑÐ° Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ°.',
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 1985: 33916 | 33918 | 36065 | 36516 | 36517 | 36521 | 36522 | 36613 | 36614 | 36628 | 36629 | 36643 | 36644 | 36645 | 36677 | 36678 | 36720 | 38908 | 38909 | 38910 | 39062 | 63746 | 63747 | 63748 | 63749 | 63750 | 63751 | 63752 | 63761 | 63762 | 63763 | 74760 | 74761 | 74762 | 74763 | 74764 | 74769 | 74770 | 74771 | 91190 | 91191 | 91192 | 91193 | 91194 | 91195 | 91196 | 91197 | 91198 | 91818 | 91819 | 91820 | 91821 | 91822 | 91823