Bugzilla – Attachment 33954 Details for
Bug 6810
Send membership expiry reminder notices
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6810 [Sample notices follow-up] Send membership expiry reminder notices
Bug-6810-Sample-notices-follow-up-Send-membership-.patch (text/plain), 8.16 KB, created by
Owen Leonard
on 2014-11-26 15:19:06 UTC
(
hide
)
Description:
Bug 6810 [Sample notices follow-up] Send membership expiry reminder notices
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2014-11-26 15:19:06 UTC
Size:
8.16 KB
patch
obsolete
>From 991fa56daeebd0a1d6417750f6675b780882ac5e Mon Sep 17 00:00:00 2001 >From: Owen Leonard <oleonard@myacpl.org> >Date: Wed, 26 Nov 2014 09:26:29 -0500 >Subject: [PATCH] Bug 6810 [Sample notices follow-up] Send membership expiry > reminder notices >Content-Type: text/plain; charset="utf-8" > >This patch adds the new sample notice (in English) to the non-English >web installers so that it is available to users of non-English >templates. > >This patch also corrects the SQL of the sample notice updates to reflect >changes in the structure of the notices table. > >To test, apply the patch and test installation of Koha with a blank >database. The installation process should correctly add sample notices, >including the new MEMEXP notice. > >Test again using a different set of translations to confirm that >non-English sample notices are working as well. >--- > .../data/mysql/de-DE/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/en/mandatory/sample_notices.sql | 4 ++-- > .../data/mysql/es-ES/mandatory/sample_notices.sql | 3 +++ > .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 3 +++ > installer/data/mysql/it-IT/necessari/notices.sql | 3 +++ > .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 3 +++ > .../data/mysql/pl-PL/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/ru-RU/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/uk-UA/mandatory/sample_notices.sql | 3 +++ > 9 files changed, 26 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >index 01ae5d4..37c46a1 100644 >--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql >+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >@@ -131,3 +131,6 @@ Wir möchten Sie darüber informieren, dass der Benutzer <<borrowers.firstname>> > Vielen Dank, > Ihr Biblioheksteam' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql >index 15f9b25..04d6027 100644 >--- a/installer/data/mysql/en/mandatory/sample_notices.sql >+++ b/installer/data/mysql/en/mandatory/sample_notices.sql >@@ -144,6 +144,6 @@ Thank you. > Your library.' > ); > >-INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) > VALUES ( >-'members','MEMEXP','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >index b105f58..df40115 100644 >--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql >+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >@@ -143,3 +143,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >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 d66a2d4..a29aeb7 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >@@ -145,3 +145,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql >index 626f208..dcf7575 100644 >--- a/installer/data/mysql/it-IT/necessari/notices.sql >+++ b/installer/data/mysql/it-IT/necessari/notices.sql >@@ -142,3 +142,6 @@ Grazie di tutto > > Lo staff della biblioteca.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >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 f1e8fb0..bd98b6d 100644 >--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >@@ -163,3 +163,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >index 50e0cd5..05da073 100644 >--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >@@ -145,3 +145,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >index a8d3046..6159148 100644 >--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >@@ -145,3 +145,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >index db8976e..c6291d0 100644 >--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >@@ -144,3 +144,6 @@ Thank you. > > Your library.' > ); >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ( >+'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian'); >\ No newline at end of file >-- >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 6810
:
5375
|
9751
|
21870
|
21871
|
21872
|
22459
|
32683
|
32684
|
32689
|
32692
|
33954
|
40090
|
40091
|
40100
|
40120
|
40121
|
40122
|
40179
|
40180
|
40641
|
40642
|
40643
|
40644
|
40645
|
40646
|
40649
|
40665
|
40666
|
40667
|
40685
|
40686
|
40687
|
40688
|
40689
|
40690
|
40700
|
40701
|
40766
|
41916
|
42609
|
42610
|
42611
|
42612
|
42613
|
42700