@@ -, +, @@ reg verification emails --- ...lfRegistrationVerificationRecipient_syspref.sql | 2 + .../bug_25090-add_STAFF_VER_OPAC_REG_notice.perl | 36 ++++++++++++++ .../data/mysql/de-DE/mandatory/sample_notices.sql | 28 +++++++++++ .../data/mysql/en/mandatory/sample_notices.yml | 33 +++++++++++++ .../data/mysql/es-ES/mandatory/sample_notices.sql | 27 +++++++++++ .../mysql/fr-CA/obligatoire/sample_notices.sql | 27 +++++++++++ .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 26 ++++++++++ installer/data/mysql/it-IT/necessari/notices.sql | 27 +++++++++++ .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 27 +++++++++++ .../data/mysql/pl-PL/mandatory/sample_notices.sql | 26 ++++++++++ .../data/mysql/ru-RU/mandatory/sample_notices.sql | 26 ++++++++++ installer/data/mysql/sysprefs.sql | 2 + .../data/mysql/uk-UA/mandatory/sample_notices.sql | 26 ++++++++++ .../prog/en/modules/admin/preferences/opac.pref | 13 +++++ .../en/modules/opac-registration-confirmation.tt | 21 ++++++++- .../en/modules/opac-registration-email-sent.tt | 12 +++++ opac/opac-memberentry.pl | 55 ++++++++++++++++++---- opac/opac-registration-verify.pl | 3 ++ 18 files changed, 406 insertions(+), 11 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_25090-add_PatronSelfRegistrationVerificationRecipient_syspref.sql create mode 100644 installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_notice.perl --- a/installer/data/mysql/atomicupdate/bug_25090-add_PatronSelfRegistrationVerificationRecipient_syspref.sql +++ a/installer/data/mysql/atomicupdate/bug_25090-add_PatronSelfRegistrationVerificationRecipient_syspref.sql @@ -0,0 +1,2 @@ +INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('PatronSelfRegistrationVerificationRecipient', 'RegisteringPatron', 'PatronSelfRegistrationVerificationRecipientAddress|BranchEmailAddress|KohaAdminEmailAddress|RegisteringPatron', 'Choose email address that self registering users verification email will be sent to.', 'Choice'); +INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('PatronSelfRegistrationVerificationRecipientAddress', '', '', 'If you choose PatronSelfRegistrationVerificationRecipientAddress you have to enter a valid email address:', 'free'); --- a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_notice.perl +++ a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_notice.perl @@ -0,0 +1,36 @@ +$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', '
+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+ +
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
+ ', 1, 'email') + }); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug XXXXX - description)\n"; +} --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ a/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -386,3 +386,31 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); + + --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ a/installer/data/mysql/en/mandatory/sample_notices.yml @@ -736,6 +736,39 @@ tables: - "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: + - "" + - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:" + - "
"
+ - "<
+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); + --- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql +++ a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql @@ -268,3 +268,30 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql +++ a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -379,3 +379,29 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/installer/data/mysql/it-IT/necessari/notices.sql +++ a/installer/data/mysql/it-IT/necessari/notices.sql @@ -382,3 +382,30 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); + --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql +++ a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql @@ -398,3 +398,30 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -376,3 +376,29 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql +++ a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql @@ -378,3 +378,29 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/installer/data/mysql/sysprefs.sql +++ a/installer/data/mysql/sysprefs.sql @@ -492,6 +492,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'), ('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'), ('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'), +('PatronSelfRegistrationVerificationRecipient', 'RegisteringPatron', 'PatronSelfRegistrationVerificationRecipientAddress|BranchEmailAddress|KohaAdminEmailAddress|RegisteringPatron', 'Choose email address that self registering users verification email will be sent to', 0, 'Choice'), +('PatronSelfRegistrationVerificationRecipientAddress', '', '', 'If you choose PatronSelfRegistrationVerificationRecipientAddress you have to enter a valid email address:', 'free'), ('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate his or her account.','YesNo'), ('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'), ('EnablePayPalOpacPayments', '0', NULL , 'Enables the ability to pay fees and fines from the OPAC via PayPal', 'YesNo' ), --- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql +++ a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql @@ -469,3 +469,29 @@ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, ', 'print', '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', '+ If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link: +
+
+ <
+ If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. +
', 1, 'email'); --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref @@ -818,6 +818,19 @@ OPAC: - "library patrons to register or modify their account via the OPAC." - "You have successfully registered a new Koha patron account for [% borrower.firstname | html %] [% borrower.surname | html %].
+ +Please copy the username and password listed below into an email to [% borrower.firstname | html %] [% borrower.surname | html %]'s email [% borrower.email | html %]:
+ ++ Username: + [% borrower.userid | html %] +
++ Password: + [% password_cleartext | html %] +
+Please ask the patron to login and change their password.
+Your account will not be activated until you follow the link provided in the confirmation email.
A library staff member will review your registration shortly, and if approved an email will be sent to [% email | html %] containing your OPAC login credentials.
+ +Your account will not be activated until it has been approved by a library staff member.
+