Attachment #173897 for bug #25090

View | Details | Raw Unified | Return to bug 25090
Collapse All | Expand All




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{UPDATE systempreferences SET value = "off", options = "off|patron|library", type = "Choice" WHERE variable = "PatronSelfRegistrationVerifyByEmail" and value = "0"});
        $dbh->do(q{UPDATE systempreferences SET value = "patron", options = "off|patron|library", type = "Choice" WHERE variable = "PatronSelfRegistrationVerifyByEmail" and value = "1"});

        say_success( $out, "Updated system preference 'PatronSelfRegistrationVerifyByEmail' to include choices" );
    },
};

Lines 617-623 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +1 lines)
617	('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'),	617	('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'),
618	('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'),	618	('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'),
619	('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),	619	('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),
620	('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),	620	('PatronSelfRegistrationVerifyByEmail','off','off\|patron\|library','If enabled, any patron attempting to register themselves via the OPAC will require self-verification or library verification via email to activate their account.','Choice'),
621	('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),	621	('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
622	('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),	622	('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),
623	('PlaceHoldsOnOrdersFromSuggestions','0',NULL,'If ON, enables generation of holds when orders are placed from suggestions','YesNo'),	623	('PlaceHoldsOnOrdersFromSuggestions','0',NULL,'If ON, enables generation of holds when orders are placed from suggestions','YesNo'),




            - "library patrons to register for an account via the OPAC."
            - "<br><strong>NOTE:</strong> This needs <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=PatronSelfRegistrationDefaultCategory'>PatronSelfRegistrationDefaultCategory</a> to be set to a valid patron category code."
        -
            - "A self-registering patron"
            - pref: PatronSelfRegistrationVerifyByEmail
              choices:
                  patron: "must verify themselves via email"
                  library: "must be verified via email sent to EmailPatronRegistrations"
                  off: "is not required to verify themselves"
            - "to activate their account."
            - "<br><strong>NOTE:</strong> This system preference requires the <code>misc/cronjobs/cleanup_database.pl</code> cronjob. Ask your system administrator to schedule it."
            - "<br><strong>NOTE:</strong> Ensure the <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=EmailPatronRegistrations'>EmailPatronRegistrations</a> system preference is set if you choose that verification option."
        -
            - "Use"
            - pref: PatronSelfRegistrationDefaultCategory
- 

Return to bug 25090

Lines 791-802 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-4 / +6 lines)
791	- "library patrons to register for an account via the OPAC."	791	- "library patrons to register for an account via the OPAC."
792	- "<br><strong>NOTE:</strong> This needs <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=PatronSelfRegistrationDefaultCategory'>PatronSelfRegistrationDefaultCategory</a> to be set to a valid patron category code."	792	- "<br><strong>NOTE:</strong> This needs <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=PatronSelfRegistrationDefaultCategory'>PatronSelfRegistrationDefaultCategory</a> to be set to a valid patron category code."
793	-	793	-
		794	- "A self-registering patron"
794	- pref: PatronSelfRegistrationVerifyByEmail	795	- pref: PatronSelfRegistrationVerifyByEmail
795	choices:	796	choices:
796	1: Require	797	patron: "must verify themselves via email"
797	0: "Don't require"	798	library: "must be verified via email sent to EmailPatronRegistrations"
798	- "that a self-registering patron verify themselves via email."	799	off: "is not required to verify themselves"
		800	- "to activate their account."
799	- "<br><strong>NOTE:</strong> This system preference requires the <code>misc/cronjobs/cleanup_database.pl</code> cronjob. Ask your system administrator to schedule it."	801	- "<br><strong>NOTE:</strong> This system preference requires the <code>misc/cronjobs/cleanup_database.pl</code> cronjob. Ask your system administrator to schedule it."
		802	- "<br><strong>NOTE:</strong> Ensure the <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=EmailPatronRegistrations'>EmailPatronRegistrations</a> system preference is set if you choose that verification option."
800	-	803	-
801	- "Use"	804	- "Use"
802	- pref: PatronSelfRegistrationDefaultCategory	805	- pref: PatronSelfRegistrationDefaultCategory
803	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_25090_-_update_PatronSelfRegistrationVerifyByEmail_syspref.pl (+16 lines)
	1	use Modern::Perl;
	2	use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
	3
	4	return {
	5	bug_number => "25090",
	6	description => "Redirect self-registration verification email to the library",
	7	up => sub {
	8	my ($args) = @_;
	9	my ( $dbh, $out ) = @$args{qw(dbh out)};
	10
	11	$dbh->do(q{UPDATE systempreferences SET value = "off", options = "off\|patron\|library", type = "Choice" WHERE variable = "PatronSelfRegistrationVerifyByEmail" and value = "0"});
	12	$dbh->do(q{UPDATE systempreferences SET value = "patron", options = "off\|patron\|library", type = "Choice" WHERE variable = "PatronSelfRegistrationVerifyByEmail" and value = "1"});
	13
	14	say_success( $out, "Updated system preference 'PatronSelfRegistrationVerifyByEmail' to include choices" );
	15	},
	16	};