From 4aa17a1935e92234dfac6798733bf907982b040c Mon Sep 17 00:00:00 2001
From: Aleisha Amohia <aleisha@catalyst.net.nz>
Date: Mon, 4 Nov 2024 00:48:58 +0000
Subject: [PATCH] Bug 25090: Add OPAC_REG_VERIFY_LIB notice

This is a bit of a merge between the OPAC_REG and OPAC_REG_VERIFY notices that the EmailPatronRegistrations address would receive if PatronSelfRegistrationVerifyByEmail was set to need that verification

Sponsored-by: Mental Health Education & Resource Centre
---
 ..._25090_-_add_OPAC_REG_VERIFY_LIB_notice.pl | 30 +++++++++++++++++++
 .../mysql/en/mandatory/sample_notices.yml     | 26 ++++++++++++++++
 2 files changed, 56 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_25090_-_add_OPAC_REG_VERIFY_LIB_notice.pl

diff --git a/installer/data/mysql/atomicupdate/bug_25090_-_add_OPAC_REG_VERIFY_LIB_notice.pl b/installer/data/mysql/atomicupdate/bug_25090_-_add_OPAC_REG_VERIFY_LIB_notice.pl
new file mode 100644
index 00000000000..576c57e2e5d
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_25090_-_add_OPAC_REG_VERIFY_LIB_notice.pl
@@ -0,0 +1,30 @@
+use Modern::Perl;
+use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
+
+return {
+    bug_number  => "25090",
+    description => "Redirect self-registration verification email to the library",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        $dbh->do(q{INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, message_transport_type, lang, content) VALUES ("members", "OPAC_REG_VERIFY_LIB", "", "New OPAC self-registration submitted for verification", 1, "Verify new OPAC self-registration", "email", "default", "<h3>New OPAC self-registration submitted for verification</h3>
+<p><h4>Self-registration made:</h4>
+<ul>
+<li><<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
+<li>Cardnumber: <<borrower_modifications.cardnumber>></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>Use this link to verify the account: <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>></p>")});
+
+        say_success( $out, "Added notice 'OPAC_REG_VERIFY_LIB'" );
+    },
+};
diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml
index e054a5a0fa9..052af3dc7e1 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.yml
+++ b/installer/data/mysql/en/mandatory/sample_notices.yml
@@ -2649,3 +2649,29 @@ tables:
             - "[% skipped %] records skipped"
             - "[% in_error %] records in error"
             - "[% total %] total"
+
+        - module: members
+          code: OPAC_REG_VERIFY_LIB
+          branchcode: ""
+          name: "New OPAC self-registration submitted for verification"
+          is_html: 1
+          title: "Verify new OPAC self-registration"
+          message_transport_type: email
+          lang: default
+          content:
+            - "<h3>New OPAC self-registration submitted for verification</h3>"
+            - "<p><h4>Self-registration made:</h4>"
+            - "<ul>"
+            - "<li><<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>"
+            - "<li>Cardnumber: <<borrower_modifications.cardnumber>></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>Use this link to verify the account: <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>></p>"
-- 
2.39.5