Attachment 91196 Details for Bug 1985 – Bug 1985: (follow-up) Add letter to other languages

[patch] Bug 1985: (follow-up) Add letter to other languages

Bug-1985-follow-up-Add-letter-to-other-languages.patch (text/plain), 15.49 KB, created by Mark Tompsett on 2019-07-03 00:18:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2019-07-03 00:18:55 UTC

Size: 15.49 KB

patch

obsolete

>From d2bcec6807794bcc579983e9af8a182a443e3ea7 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 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.
>
>Left signed off, even though uk-UA was rebased.
>
>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 d710bd6272..1a18b33d32 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -159,6 +159,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 965850ac91..be9a4d7f21 100644
>--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>@@ -147,6 +147,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 b3dfec24e5..6ff178b497 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -150,6 +150,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 adde2c45fb..d0c7badf67 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -154,6 +154,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 794c797b0a..cd444f634a 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -171,6 +171,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 115a6adc28..9e22c6f26c 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -149,6 +149,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 a979698dd1..82697d6b6e 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -149,6 +149,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 63319ad6e7..6e6c161e9a 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -243,6 +243,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.11.0

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