Bugzilla – Attachment 39062 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]
[SIGNED-OFF] Bug 1985: Follow up - Add sample letter to other languages
SIGNED-OFF-Bug-1985-Follow-up---Add-sample-letter-.patch (text/plain), 15.37 KB, created by
Bernardo Gonzalez Kriegel
on 2015-05-12 11:23:17 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 1985: Follow up - Add sample letter to other languages
Filename:
MIME Type:
Creator:
Bernardo Gonzalez Kriegel
Created:
2015-05-12 11:23:17 UTC
Size:
15.37 KB
patch
obsolete
>From 9f105d3e614ea5399644ae1a642d71e7db21eeb7 Mon Sep 17 00:00:00 2001 >From: Mark Tompsett <mtompset@hotmail.com> >Date: Fri, 6 Mar 2015 11:24:26 -0500 >Subject: [PATCH] [SIGNED-OFF] 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. > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Sample letter in all languages >No errors >--- > .../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 eb77212..6cd5e39 100644 >--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql >+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >@@ -109,6 +109,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 61f4dbe..e6b17d9 100644 >--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql >+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >@@ -117,6 +117,30 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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 3e0c53b..c05696c 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >@@ -120,6 +120,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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 9e8c9a6..bd35c6b 100644 >--- a/installer/data/mysql/it-IT/necessari/notices.sql >+++ b/installer/data/mysql/it-IT/necessari/notices.sql >@@ -120,6 +120,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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', '', '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 0b28357..2800402 100644 >--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >@@ -142,6 +142,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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 a6516b6..5a8ff06 100644 >--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >@@ -119,6 +119,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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 6218d3d..82e477c 100644 >--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >@@ -120,6 +120,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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 a7d6b96..aa44f3e 100644 >--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >@@ -119,6 +119,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > 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) >-- >1.7.9.5
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