Bugzilla – Attachment 137997 Details for
Bug 23538
Email library when new patrons self register
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23538: Database changes
Bug-23538-Database-changes.patch (text/plain), 8.37 KB, created by
Alex Buckley
on 2022-07-22 01:59:31 UTC
(
hide
)
Description:
Bug 23538: Database changes
Filename:
MIME Type:
Creator:
Alex Buckley
Created:
2022-07-22 01:59:31 UTC
Size:
8.37 KB
patch
obsolete
>From 78291ad5d9585bbcbe56d2b1a211858b7f19d4a9 Mon Sep 17 00:00:00 2001 >From: Alex Buckley <alexbuckley@catalyst.net.nz> >Date: Mon, 4 Apr 2022 07:52:06 +0000 >Subject: [PATCH] Bug 23538: Database changes > >Sponsored-by: Catalyst IT >--- > ...lAddressForPatronRegistrations_sysprefs.pl | 29 +++++++++++++++++++ > .../mysql/en/mandatory/sample_notices.yml | 25 ++++++++++++++++ > installer/data/mysql/mandatory/sysprefs.sql | 2 ++ > .../en/modules/admin/preferences/opac.pref | 13 +++++++++ > 4 files changed, 69 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl > >diff --git a/installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl b/installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl >new file mode 100755 >index 0000000000..61ee73395e >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl >@@ -0,0 +1,29 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "23538", >+ description => "Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ >+ $dbh->do(q{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('EmailPatronRegistrations', '0', '0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress', 'Choose email address that new patron registrations will be sent to: ', 'Choice'), ('EmailAddressForPatronRegistrations', '', '', ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'free') }); >+ >+ $dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration', >+ '<h3>New OPAC self-registration</h3> >+ <p><h4>Self-registration made by</h4> >+ <ul> >+ <li><<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>', 'email', 'default') }); >+ }, >+}; >diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml >index 34ffab80df..fcd76b85f8 100644 >--- a/installer/data/mysql/en/mandatory/sample_notices.yml >+++ b/installer/data/mysql/en/mandatory/sample_notices.yml >@@ -1698,3 +1698,28 @@ tables: > - "<p>This is to confirm that someone enabled two factor authentication on your account.</p>" > - "<p>If you did not do this, someone else may be using your account. Please contact technical support.</p>" > - "<p>Your library</p>" >+ >+ - module: members >+ code: OPAC_REG >+ branchcode: "" >+ name: "New OPAC self-registration submitted" >+ is_html: 1 >+ title: "New OPAC self-registration" >+ message_transport_type: email >+ lang: default >+ content: >+ - "<h3>New OPAC self-registration</h3>" >+ - "<p><h4>Self-registration made by</h4>" >+ - "<ul>" >+ - "<li><<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>" >diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql >index 242de0d463..6ca4166507 100644 >--- a/installer/data/mysql/mandatory/sysprefs.sql >+++ b/installer/data/mysql/mandatory/sysprefs.sql >@@ -200,9 +200,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL), > ('ElasticsearchMARCFormat', 'ISO2709', 'ISO2709|ARRAY', 'Elasticsearch MARC format. ISO2709 format is recommended as it is faster and takes less space, whereas array is searchable.', 'Choice'), > ('ElasticsearchCrossFields', '1', '', 'Enable "cross_fields" option for searches using Elastic search.', 'YesNo'), >+('EmailAddressForPatronRegistrations', '', '', ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'free'), > ('EmailAddressForSuggestions','','',' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','free'), > ('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'), > ('EmailOverduesNoEmail','1',NULL,'Send send overdues of patrons without email address to staff','YesNo'), >+('EmailPatronRegistrations', '0', '0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress', 'Choose email address that new patron registrations will be sent to: ', 'Choice'), > ('EmailPurchaseSuggestions','0','0|EmailAddressForSuggestions|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that new purchase suggestions will be sent to: ','Choice'), > ('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'), > ('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >index 555febc918..bedfb44083 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >@@ -856,6 +856,19 @@ OPAC: > 1: Allow > 0: "Don't allow" > - patrons to notify the library of changes to their contact information from the OPAC. >+ - >+ - "Choose email address that new patron self-registrations will be sent to: " >+ - pref: EmailPatronRegistrations >+ default: 0 >+ choices: >+ 0: none >+ EmailAddressForPatronRegistrations: EmailAddressForPatronRegistrations >+ BranchEmailAddress: email address of branch >+ KohaAdminEmailAddress: KohaAdminEmailAddress >+ - 'If you chooose <a href="/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=EmailAddressForPatronRegistrations">EmailAddressForPatronRegistrations</a> you have to enter a valid email address: ' >+ - >+ - pref: EmailAddressForPatronRegistrations >+ class: email > > Advanced search options: > - >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 23538
:
133050
|
133051
|
133052
|
133053
|
133097
|
133098
|
133099
|
133100
|
133101
|
133102
|
133103
|
137997
|
137998
|
137999
|
138000
|
138001
|
138237
|
138238
|
138239
|
138240
|
138383
|
138384
|
138385
|
138386
|
138387
|
141223