Attachment #24493 for bug #11237

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

Lines 1-6 Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
1	INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES	1	INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
2	('AcqCreateItem','ordering','ordering\|receiving\|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),	2	('AcqCreateItem','ordering','ordering\|receiving\|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),
3	('AcqItemSetSubfieldsWhenReceived','0','','This syspref set a status for item when items are created when receiving (e.g. 995\$o=5)','Free'),	3	('AcqItemSetSubfieldsWhenReceived','0','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5\|a="foo bar")','Free'),
4	('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),	4	('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
5	('AcqViewBaskets','user','user\|branch\|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),	5	('AcqViewBaskets','user','user\|branch\|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),
6	('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),	6	('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),




    SetVersion($DBversion);
}

$DBversion = "3.15.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        UPDATE systempreferences
        SET explanation = 'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")'
        WHERE variable = "AcqItemSetSubfieldsWhenReceived"
    });
    print "Upgrade to $DBversion done (Bug 11237: Update explanation for AcqItemSetSubfieldsWhenReceived syspref)\n";
    SetVersion($DBversion);
}


=head1 FUNCTIONS

=head2 TableExists($table)

Lines 43-50 Acquisitions: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref (-2 / +1 lines)
43	no: "Do not warn"	43	no: "Do not warn"
44	- when the librarian tries to create an invoice with a duplicate number.	44	- when the librarian tries to create an invoice with a duplicate number.
45	-	45	-
		46	- Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5\|a="foo bar").
46	- pref: AcqItemSetSubfieldsWhenReceived	47	- pref: AcqItemSetSubfieldsWhenReceived
47	- Set subfields for item when items are created when receiving (e.g. o=5\|a="foo bar")
48		48
49	Printing:	49	Printing:
50	-	50	-
51	-

Return to bug 11237

Lines 7912-7917 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+12 lines)
7912	SetVersion($DBversion);	7912	SetVersion($DBversion);
7913	}	7913	}
7914		7914
		7915	$DBversion = "3.15.00.XXX";
		7916	if(CheckVersion($DBversion)) {
		7917	$dbh->do(q{
		7918	UPDATE systempreferences
		7919	SET explanation = 'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5\|a="foo bar")'
		7920	WHERE variable = "AcqItemSetSubfieldsWhenReceived"
		7921	});
		7922	print "Upgrade to $DBversion done (Bug 11237: Update explanation for AcqItemSetSubfieldsWhenReceived syspref)\n";
		7923	SetVersion($DBversion);
		7924	}
		7925
		7926
7915	=head1 FUNCTIONS	7927	=head1 FUNCTIONS
7916		7928
7917	=head2 TableExists($table)	7929	=head2 TableExists($table)