Attachment #171906 for bug #36798

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




use Modern::Perl;
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);

return {
    bug_number  => "36798",
    description => "Add `SearchCancelledAndInvalidISBNandISSN` preference",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        # Do you stuffs here
        $dbh->do(
            q{
            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` )
            VALUES ('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo')
            }
        );

        say_success( $out, "Added new system preference 'SearchCancelledAndInvalidISBNandISSN'" );
    },
};

Lines 690-695 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
690	('SCOLoadCheckoutsByDefault','1','','If enabled, load the list of a patrons checkouts when they log in to the Self Checkout','YesNo'),	690	('SCOLoadCheckoutsByDefault','1','','If enabled, load the list of a patrons checkouts when they log in to the Self Checkout','YesNo'),
691	('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),	691	('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),
692	('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),	692	('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),
		693	('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo'),
693	('SearchEngine','Zebra','Elasticsearch\|Zebra','Search Engine','Choice'),	694	('SearchEngine','Zebra','Elasticsearch\|Zebra','Search Engine','Choice'),
694	('SearchLimitLibrary', 'homebranch', 'homebranch\|holdingbranch\|both', "When limiting search results with a library or library group, use the item's home library, or holding library, or both.", 'Choice'),	695	('SearchLimitLibrary', 'homebranch', 'homebranch\|holdingbranch\|both', "When limiting search results with a library or library group, use the item's home library, or holding library, or both.", 'Choice'),
695	('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),	696	('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),

Lines 106-111 Searching: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref (-1 / +7 lines)
106	- "List of search fields (separated by \| or ,) that should not be autotruncated by Elasticsearch even if <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=QueryAutoTruncate'>QueryAutoTruncate</a> is set to 'Yes':"	106	- "List of search fields (separated by \| or ,) that should not be autotruncated by Elasticsearch even if <a href='/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=QueryAutoTruncate'>QueryAutoTruncate</a> is set to 'Yes':"
107	- pref: ESPreventAutoTruncate	107	- pref: ESPreventAutoTruncate
108	class: long	108	class: long
		109	-
		110	- pref: SearchCancelledAndInvalidISBNandISSN
		111	default: 0
		112	choices:
		113	1: Do
		114	0: "Don't"
		115	- "search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using Elasticsearch)."
109	-	116	-
110	- pref: z3950Status	117	- pref: z3950Status
111	type: textarea	118	type: textarea
112	-

Return to bug 36798

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_36798.pl (+21 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 => "36798",
	6	description => "Add `SearchCancelledAndInvalidISBNandISSN` preference",
	7	up => sub {
	8	my ($args) = @_;
	9	my ( $dbh, $out ) = @$args{qw(dbh out)};
	10
	11	# Do you stuffs here
	12	$dbh->do(
	13	q{
	14	INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` )
	15	VALUES ('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo')
	16	}
	17	);
	18
	19	say_success( $out, "Added new system preference 'SearchCancelledAndInvalidISBNandISSN'" );
	20	},
	21	};