Bugzilla – Attachment 63748 Details for
Bug 1985
Email notification of new OPAC comments
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[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.24 KB, created by
Mark Tompsett
on 2017-05-26 17:51:21 UTC
(
hide
)
Description:
Bug 1985: Follow up - Add sample letter to other languages
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2017-05-26 17:51:21 UTC
Size:
15.24 KB
patch
obsolete
>From e4b5f60c9b3abdc8008e741c85c99fe0e95e1b82 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 > >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. >--- > .../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 | 25 ++++++++++++++++++++++ > 8 files changed, 199 insertions(+) > >diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >index 7142cf2..0a19dcc 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 9cd1e41..f80a165 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 3c8de13..e78bd1e 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 06d9428..b73f681 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 3040fdf..3384475 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 6339462..f96e332 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 d8c36f1..9402638 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 e1e56c0..33b0f62 100644 >--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >@@ -120,6 +120,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) >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
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