Attachment #151061 for bug #29822

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




use Modern::Perl;

return {
    bug_number => "29822",
    description => "Convert DefaultPatronSeachFields from csv to psv",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        # Do you stuffs here
        $dbh->do(q{
            UPDATE systempreferences
            SET
              value = REPLACE( value, ',', '|' )
            WHERE
              variable = 'DefaultPatronSearchFields'
        });
        say $out "Updated system preference 'DefaultPatronSearchFields";
    },
};

Lines 183-189 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +1 lines)
183	('DefaultLongOverdueChargeValue', '', NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),	183	('DefaultLongOverdueChargeValue', '', NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
184	('DefaultLongOverdueDays', '', NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),	184	('DefaultLongOverdueDays', '', NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
185	('DefaultLongOverdueLostValue', '', NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),	185	('DefaultLongOverdueLostValue', '', NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
186	('DefaultPatronSearchFields', 'firstname,middle_name,surname,othernames,cardnumber,userid',NULL,'Comma separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname,surname,othernames,cardnumber,userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'),	186	('DefaultPatronSearchFields', 'firstname\|middle_name\|surname\|othernames\|cardnumber\|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname\|surname\|othernames\|cardnumber\|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'),
187	('DefaultSaveRecordFileID','biblionumber','biblionumber\|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'),	187	('DefaultSaveRecordFileID','biblionumber','biblionumber\|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'),
188	('defaultSortField','relevance','relevance\|popularity\|call_number\|pubdate\|acqdate\|title\|author','Specify the default field used for sorting','Choice'),	188	('defaultSortField','relevance','relevance\|popularity\|call_number\|pubdate\|acqdate\|title\|author','Specify the default field used for sorting','Choice'),
189	('defaultSortOrder','dsc','asc\|dsc\|az\|za','Specify the default sort order','Choice'),	189	('defaultSortOrder','dsc','asc\|dsc\|az\|za','Specify the default sort order','Choice'),

Lines 61-67 Patrons: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +1 lines)
61	type: modalselect	61	type: modalselect
62	source: borrowers	62	source: borrowers
63	exclusions: anonymized\|auth_method\|autorenew_checkouts\|date_renewed\|dateenrolled\|dateexpiry\|lang\|lastseen\|login_attempts\|overdrive_auth_token\|password\|password_expiration_date\|primary_contact_method\|gonenoaddress\|lost\|debarred\|debarredcomment\|branchcode\|categorycode\|flags\|guarantorid\|relationship\|privacy\|privacy_guarantor_checkouts\|privacy_guarantor_fines\|pronouns\|secret\|sms_provider_id\|updated_on\|checkprevcheckout	63	exclusions: anonymized\|auth_method\|autorenew_checkouts\|date_renewed\|dateenrolled\|dateexpiry\|lang\|lastseen\|login_attempts\|overdrive_auth_token\|password\|password_expiration_date\|primary_contact_method\|gonenoaddress\|lost\|debarred\|debarredcomment\|branchcode\|categorycode\|flags\|guarantorid\|relationship\|privacy\|privacy_guarantor_checkouts\|privacy_guarantor_fines\|pronouns\|secret\|sms_provider_id\|updated_on\|checkprevcheckout
64	- "If empty Koha will default to \"firstname,middle_name,surname,othernames,cardnumber,userid\". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page."	64	- "If empty Koha will default to \"firstname\|middle_name\|surname\|othernames\|cardnumber\|userid\". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page."
65	-	65	-
66	- "Show the following fields from the items database table as columns on the statistics tab on the patron record: "	66	- "Show the following fields from the items database table as columns on the statistics tab on the patron record: "
67	- pref: StatisticsFields	67	- pref: StatisticsFields
68	-

Return to bug 29822

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29822.pl (+19 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "29822",
	5	description => "Convert DefaultPatronSeachFields from csv to psv",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	# Do you stuffs here
	10	$dbh->do(q{
	11	UPDATE systempreferences
	12	SET
	13	value = REPLACE( value, ',', '\|' )
	14	WHERE
	15	variable = 'DefaultPatronSearchFields'
	16	});
	17	say $out "Updated system preference 'DefaultPatronSearchFields";
	18	},
	19	};