Attachment #167663 for bug #36330

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

Lines 152-158 a place to store the holdingbranch when item is on course reserve Link Here

(-)a/Koha/Schema/Result/CourseItem.pm (-2 / +2 lines)
152	is_nullable: 1	152	is_nullable: 1
153	size: 80	153	size: 80
154		154
155	new shelving location for the item to have while on reseve (optional)	155	new shelving location for the item to have while on reserve (optional)
156		156
157	=head2 location_enabled	157	=head2 location_enabled
158		158
Lines 177-183 a place to store the location when the item is on course reserve Link Here
177	extra: {list => ["yes","no"]}	177	extra: {list => ["yes","no"]}
178	is_nullable: 0	178	is_nullable: 0
179		179
180	if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'	180	if at least one enabled course has this item on reserve, this field will be 'yes', otherwise it will be 'no'
181		181
182	=head2 timestamp	182	=head2 timestamp
183		183

Lines 2239-2248 CREATE TABLE `course_items` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
2239	`holdingbranch` varchar(10) DEFAULT NULL COMMENT 'new holding branch for the item to have while on reserve (optional)',	2239	`holdingbranch` varchar(10) DEFAULT NULL COMMENT 'new holding branch for the item to have while on reserve (optional)',
2240	`holdingbranch_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',	2240	`holdingbranch_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',
2241	`holdingbranch_storage` varchar(10) DEFAULT NULL COMMENT 'a place to store the holdingbranch when item is on course reserve',	2241	`holdingbranch_storage` varchar(10) DEFAULT NULL COMMENT 'a place to store the holdingbranch when item is on course reserve',
2242	`location` varchar(80) DEFAULT NULL COMMENT 'new shelving location for the item to have while on reseve (optional)',	2242	`location` varchar(80) DEFAULT NULL COMMENT 'new shelving location for the item to have while on reserve (optional)',
2243	`location_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',	2243	`location_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',
2244	`location_storage` varchar(80) DEFAULT NULL COMMENT 'a place to store the location when the item is on course reserve',	2244	`location_storage` varchar(80) DEFAULT NULL COMMENT 'a place to store the location when the item is on course reserve',
2245	`enabled` enum('yes','no') NOT NULL DEFAULT 'no' COMMENT 'if at least one enabled course has this item on reseve, this field will be ''yes'', otherwise it will be ''no''',	2245	`enabled` enum('yes','no') NOT NULL DEFAULT 'no' COMMENT 'if at least one enabled course has this item on reserve, this field will be ''yes'', otherwise it will be ''no''',
2246	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),	2246	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
2247	PRIMARY KEY (`ci_id`),	2247	PRIMARY KEY (`ci_id`),
2248	UNIQUE KEY `itemnumber` (`itemnumber`),	2248	UNIQUE KEY `itemnumber` (`itemnumber`),

Lines 4904-4910 $DBversion = "3.07.00.024"; Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +1 lines)
4904	if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {	4904	if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
4905	$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ExpireReservesMaxPickUpDelayCharge', '0', NULL , 'If ExpireReservesMaxPickUpDelay is enabled, and this field has a non-zero value, than a borrower whose waiting hold has expired will be charged this amount.', 'free')");	4905	$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ExpireReservesMaxPickUpDelayCharge', '0', NULL , 'If ExpireReservesMaxPickUpDelay is enabled, and this field has a non-zero value, than a borrower whose waiting hold has expired will be charged this amount.', 'free')");
4906	$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ExpireReservesMaxPickUpDelay', '0', '', 'Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay', 'YesNo')");	4906	$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ExpireReservesMaxPickUpDelay', '0', '', 'Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay', 'YesNo')");
4907	print "Upgrade to $DBversion done (Added system preference ExpireReservesMaxPickUpDelay, system preference ExpireReservesMaxPickUpDelayCharge, add reseves.charge_if_expired)\n";	4907	print "Upgrade to $DBversion done (Added system preference ExpireReservesMaxPickUpDelay, system preference ExpireReservesMaxPickUpDelayCharge, add reserves.charge_if_expired)\n";
4908	}	4908	}
4909		4909
4910	$DBversion = "3.07.00.025";	4910	$DBversion = "3.07.00.025";

Lines 34-40 or, in crontab: Link Here

(-)a/misc/cronjobs/holds/cancel_expired_holds.pl (-2 / +1 lines)
34		34
35	=head1 DESCRIPTION	35	=head1 DESCRIPTION
36		36
37	This script calls C4::Reserves::CancelExpiredReserves which will find and cancel all expired reseves in the system.	37	This script calls C4::Reserves::CancelExpiredReserves which will find and cancel all expired reserves in the system.
38		38
39	=cut	39	=cut
40		40
41	-

Return to bug 36330