Attachment #147011 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 123-128 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
123	('BundleNotLoanValue','3',NULL,'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value','Free'),	123	('BundleNotLoanValue','3',NULL,'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value','Free'),
124	('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),	124	('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),
125	('CalculateFinesOnBackdate','1','','Switch to control if overdue fines are calculated on return when backdating','YesNo'),	125	('CalculateFinesOnBackdate','1','','Switch to control if overdue fines are calculated on return when backdating','YesNo'),
		126	('CalculateFundValuesIncludingTax', '1', NULL, 'Include tax in the calculated fund values (spent, ordered) for all supplier configurations', 'YesNo'),
126	('CalendarFirstDayOfWeek','0','0\|1\|2\|3\|4\|5\|6','Select the first day of week to use in the calendar.','Choice'),	127	('CalendarFirstDayOfWeek','0','0\|1\|2\|3\|4\|5\|6','Select the first day of week to use in the calendar.','Choice'),
127	('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'),	128	('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'),
128	('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),	129	('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),

Lines 40-45 Acquisitions: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref (-1 / +6 lines)
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	- "<br/><strong>NOTE:</strong> The database will only accept values up to 4 decimals precision, further values will be rounded."	41	- "<br/><strong>NOTE:</strong> The database will only accept values up to 4 decimals precision, further values will be rounded."
42	- "<br/><strong>NOTE:</strong> Vendor tax rate information may need updating if tax rate values are removed."	42	- "<br/><strong>NOTE:</strong> Vendor tax rate information may need updating if tax rate values are removed."
		43	-
		44	- pref: CalculateFundValuesIncludingTax
		45	choices:
		46	1: Include
		47	0: Exclude
		48	- "tax in the calculated fund values (spent, ordered). Note this rule applies to all vendors regardless of their configuration"
43	-	49	-
44	- pref: AcqWarnOnDuplicateInvoice	50	- pref: AcqWarnOnDuplicateInvoice
45	choices:	51	choices:
46	-

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	};