Attachment 112495 Details for Bug 25090 – Bug 25090: Added 3 new notices

[patch] Bug 25090: Added 3 new notices

Bug-25090-Added-3-new-notices.patch (text/plain), 35.23 KB, created by Alex Buckley on 2020-10-26 06:33:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Buckley

Created: 2020-10-26 06:33:47 UTC

Size: 35.23 KB

patch

obsolete

>From c61e8b6ac5599a50177fcc7ab3190280ebcd8c21 Mon Sep 17 00:00:00 2001
>From: Alex Buckley <alexbuckley@catalyst.net.nz>
>Date: Tue, 5 May 2020 09:15:04 +0000
>Subject: [PATCH] Bug 25090: Added 3 new notices
>
>* STAFF_VER_OPAC_REG - Sent to library containing registered patron details for library to review
>and select verification link if approve patron creation
>
>* PATRON_AND_IB_VER - Sent to patron to inform them they need to verify
>their email address via verification link then their registration will
>be reviewed by library
>
>* SELF_REG_APPROVED - Sent to patron containing password reset link
>after library has approved their registration
>
>Sponsored-By: Mental Health Education Resource Centre, NZ
>---
> ...VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl | 51 +++++++++++++++++
> .../data/mysql/en/mandatory/sample_notices.yml     | 65 ++++++++++++++++++++++
> .../mysql/fr-CA/obligatoire/sample_notices.sql     | 35 ++++++++++++
> .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   | 35 ++++++++++++
> installer/data/mysql/it-IT/necessari/notices.sql   | 35 ++++++++++++
> .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql  | 35 ++++++++++++
> .../data/mysql/pl-PL/mandatory/sample_notices.sql  | 35 ++++++++++++
> .../data/mysql/ru-RU/mandatory/sample_notices.sql  | 35 ++++++++++++
> .../data/mysql/uk-UA/mandatory/sample_notices.sql  | 35 ++++++++++++
> 9 files changed, 361 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl b/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl
>new file mode 100644
>index 00000000000..cb19537f106
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl
>@@ -0,0 +1,51 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q{
>+        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    </p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>
>+    </p>', 1, 'email')
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email')
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email')
>+    });
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 25090 - Choose to send OPAC self registration verification emails to the library and/or patron allowing libraries to moderate which registrations get Koha accounts)\n";
>+}
>diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml
>index 50bb4213863..b8a1a9ad52f 100644
>--- a/installer/data/mysql/en/mandatory/sample_notices.yml
>+++ b/installer/data/mysql/en/mandatory/sample_notices.yml
>@@ -734,6 +734,71 @@ tables:
>             - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
>             - ""
>             - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
>+        - module: members
>+          code: PATRON_AND_LIB_VER
>+          branchcode: ""
>+          name: "Opac Self-Registration Verify Your Email"
>+          is_html: 1
>+          title: "Verify your entered OPAC Self registration email address"
>+          message_transport_type: email
>+          lang: default
>+          content:
>+            - "Hello!"
>+            - ""
>+            - "<p>Before we can create your library account two things need to happen:"
>+            - "<br>1. You verify your email address - To do this please click this link:<br>"
>+            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
>+            - "<br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password."
>+            - "</p>"
>+            - "<p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>"
>+
>+        - module: members
>+          code: STAFF_VER_OPAC_REG
>+          branchode: ""
>+          name: "New patron Opac Self-Registration to verify"
>+          is_html: 1
>+          title: "Verify new Opac patron self registration"
>+          message_transport_type: email
>+          lang: default
>+          content:
>+              - "<h3>Opac self registration pending verification</h3>"
>+              - "<p><h4>Submitted Opac patron self registration:<h4>"
>+              - "<ul>"
>+              - "<li><<borrower_modifications.cardnumber>></li>"
>+              - "<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>"
>+              - "<li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>"
>+              - "<li>Email: <<borrower_modifications.email>></li>"
>+              - "<li>Phone: <<borrower_modifications.phone>></li>"
>+              - "<li>Mobile: <<borrower_modifications.mobile>></li>"
>+              - "<li>Fax: <<borrower_modifications.fax>></li>"
>+              - "<li>Secondary email: <<borrower_modifications.emailpro>></li>"
>+              - "<li>Secondary phone:<<borrower_modifications.phonepro>></li>"
>+              - "<li>Home library: <<borrower_modifications.branchcode>></li>"
>+              - "<li>Temporary patron category: <<borrower_modifications.categorycode>></li>"
>+              - "</ul>"
>+              - "</p>"
>+              - "<p>"
>+              - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:"
>+              - "<p>"
>+              - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1"
>+              - "</p>"
>+              - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
>+              - "</p>"
>+
>+        - module: members
>+          code: SELF_REG_APPROVED
>+          branchcode: ""
>+          name: "Self registration approved"
>+          is_html: 1
>+          title: "Your self registration has been approved"
>+          message_transport_type: email
>+          lang: default
>+          content:
>+            - "<html>"
>+            - "<h3>Please click the password reset link below to reset your Koha password then you'll be able to login to the OPAC:</h3>"
>+            - "<p>"
>+            - "<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>"
>+            - "</p>"
> 
>         - module: members
>           code: PASSWORD_RESET
>diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>index 1a231dd12e3..e9f6b3bb570 100644
>--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>@@ -291,3 +291,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>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 f844c90b2af..411ee05322b 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -402,3 +402,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
>index 9be907b0b5e..33feba92bb0 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -405,3 +405,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>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 e3564ffb1d2..abb0a6f7f1b 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -420,3 +420,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>index f228b5c68dc..49baf1488b2 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -399,3 +399,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>index 27f002b195a..2a6b9a4653f 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -401,3 +401,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>index 17bd9f7606c..6cdac1b6e83 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -492,3 +492,38 @@ The following item, [% biblio.title %], has correctly been renewed and is now du
> [% END %]", 'email');
> 
> INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
>+<p><h4>Submitted Opac patron self registration:<h4>
>+    <ul>
>+    <li><<borrower_modifications.cardnumber>></li>
>+    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
>+    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
>+    <li>Email: <<borrower_modifications.email>></li>
>+    <li>Phone: <<borrower_modifications.phone>></li>
>+    <li>Mobile: <<borrower_modifications.mobile>></li>
>+    <li>Fax: <<borrower_modifications.fax>></li>
>+    <li>Secondary email: <<borrower_modifications.emailpro>></li>
>+    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
>+    <li>Home library: <<borrower_modifications.branchcode>></li>
>+    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
>+    </ul>
>+    </p>
>+    <p>
>+    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
>+    <p>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
>+    </p>
>+    <p>
>+    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
>+    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
>+    <p>Before we can create your library account two things need to happen:
>+    <br>1. You verify your email address - To do this please click this link:<br>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
>+    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
>+    </p>
>+    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
>+    <p>
>+    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
>+    </p>', 1, 'email');
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 25090: 102845 | 103535 | 103536 | 104380 | 104381 | 104382 | 104383 | 104386 | 104994 | 104996 | 105319 | 112493 | 112494 | 112495 | 112496 | 112497 | 173894 | 173895 | 173896 | 173897 | 173898 | 173899 | 173962 | 173963 | 173964 | 174228 | 174229 | 174230