Attachment 104994 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), 36.76 KB, created by Alex Buckley on 2020-05-18 03:29:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Buckley

Created: 2020-05-18 03:29:43 UTC

Size: 36.76 KB

patch

obsolete

>From ee463a4f84762f7e1fd66352feb8d5400e8261dd 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/de-DE/mandatory/sample_notices.sql  | 35 ++++++++++++
> .../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 ++++++++++++
> 10 files changed, 396 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 0000000000..cb19537f10
>--- /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/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>index b2055dd7ae..f476a80315 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -407,3 +407,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml
>index ca04caf232..68f55f0fd5 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 8dd1c19a05..b78dd1f7b3 100644
>--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>@@ -289,3 +289,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 45326ba006..75a905edce 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -400,3 +400,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 d268548c90..ecd550013f 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -403,3 +403,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 534b410838..42577c9cf3 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -419,3 +419,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 dbfcc7b24d..351b77061c 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -397,3 +397,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 60b86c61bf..826668d735 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -399,3 +399,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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 137e372149..747674b161 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -490,3 +490,38 @@ Your total unpaid fines are too high.
> [% ELSE %]
> The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
> [% END %]", 'email');
>+
>+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