Attachment #141017 for bug #31631

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




use Modern::Perl;

return {
    bug_number => "31631",
    description => "Add new system preference CalculateFundValuesIncludingTax",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};

        $dbh->do(q{INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('CalculateFundValuesIncludingTax', '1', NULL, 'Include tax in the calculated fund values (spent, ordered) for all supplier configurations', 'YesNo')});
    },
};

Lines 120-125 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
120	('BundleNotLoanValue','3',NULL,'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value','Free'),	120	('BundleNotLoanValue','3',NULL,'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value','Free'),
121	('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),	121	('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),
122	('CalculateFinesOnBackdate','1','','Switch to control if overdue fines are calculated on return when backdating','YesNo'),	122	('CalculateFinesOnBackdate','1','','Switch to control if overdue fines are calculated on return when backdating','YesNo'),
		123	('CalculateFundValuesIncludingTax', '1', NULL, 'Include tax in the calculated fund values (spent, ordered) for all supplier configurations', 'YesNo'),
123	('CalendarFirstDayOfWeek','0','0\|1\|2\|3\|4\|5\|6','Select the first day of week to use in the calendar.','Choice'),	124	('CalendarFirstDayOfWeek','0','0\|1\|2\|3\|4\|5\|6','Select the first day of week to use in the calendar.','Choice'),
124	('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow\|allow\|allow_and_notify','Add a button to the "Holds to pull" screen to mark an item as lost and notify the patron.','Choice'),	125	('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow\|allow\|allow_and_notify','Add a button to the "Holds to pull" screen to mark an item as lost and notify the patron.','Choice'),
125	('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),	126	('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),

Lines 39-44 Acquisitions: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref (-1 / +6 lines)
39	- pref: TaxRates	39	- pref: TaxRates
40	- . Enter in numeric form, 0.12 for 12%. The first item in the list will be selected by default. For more than one value, separate with \| (pipe).	40	- . Enter in numeric form, 0.12 for 12%. The first item in the list will be selected by default. For more than one value, separate with \| (pipe).
41	- "Please note: The database will only accept values up to 4 decimals precision, further values will be rounded."	41	- "Please note: The database will only accept values up to 4 decimals precision, further values will be rounded."
		42	-
		43	- pref: CalculateFundValuesIncludingTax
		44	choices:
		45	1: Include
		46	0: Exclude
		47	- "tax in the calculated fund values (spent, ordered). Note this rule applies to all vendors regardless of their configuration"
42	-	48	-
43	- pref: AcqWarnOnDuplicateInvoice	49	- pref: AcqWarnOnDuplicateInvoice
44	choices:	50	choices:
45	-

Return to bug 31631

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31631-add_CalculateFundValuesIncludingTax_syspref.pl (+12 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "31631",
	5	description => "Add new system preference CalculateFundValuesIncludingTax",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9
	10	$dbh->do(q{INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('CalculateFundValuesIncludingTax', '1', NULL, 'Include tax in the calculated fund values (spent, ordered) for all supplier configurations', 'YesNo')});
	11	},
	12	};