From c61e8b6ac5599a50177fcc7ab3190280ebcd8c21 Mon Sep 17 00:00:00 2001 From: Alex Buckley 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+ +

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

+

', 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! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 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', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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: - "<>/cgi-bin/koha/opac-registration-verify.pl?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!" + - "" + - "

Before we can create your library account two things need to happen:" + - "
1. You verify your email address - To do this please click this link:
" + - "<>/cgi-bin/koha/opac-registration-verify.pl?token=<>" + - "
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." + - "

" + - "

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

" + + - 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: + - "

Opac self registration pending verification

" + - "

Submitted Opac patron self registration:

" + - "
    " + - "
  • <>
    • " + - "
  • <> <> <>
    • " + - "
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • " + - "
  • Email: <>
    • " + - "
  • Phone: <>
    • " + - "
  • Mobile: <>
    • " + - "
  • Fax: <>
    • " + - "
  • Secondary email: <>
    • " + - "
  • Secondary phone:<>
    • " + - "
  • Home library: <>
    • " + - "
  • Temporary patron category: <>
    • " + - "
" + - "

" + - "

" + - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:" + - "

" + - "<>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1" + - "

" + - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly." + - "

" + + - 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: + - "" + - "

Please click the password reset link below to reset your Koha password then you'll be able to login to the OPAC:

" + - "

" + - "<>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<>" + - "

" - 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. + ', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 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', '

Opac self registration pending verification

+

Submitted Opac patron self registration:

+
    +
  • <>
    • +
  • <> <> <>
    • +
  • Physical address: <> <> <> <>, <>, <> <>, <>
    • +
  • Email: <>
    • +
  • Phone: <>
    • +
  • Mobile: <>
    • +
  • Fax: <>
    • +
  • Secondary email: <>
    • +
  • Secondary phone:<>
    • +
  • Home library: <>
    • +
  • Temporary patron category: <>
    • +
+

+

+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +

+

+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<>&approved=1 +

+

+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +

', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello! +

Before we can create your library account two things need to happen: +
1. You verify your email address - To do this please click this link:
+ <>/cgi-bin/koha/opac-registration-verify.pl?token=<> +
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. +

+

If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.

', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '

Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:

+

+ <>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<> +

', 1, 'email'); -- 2.11.0