Attachment #5151 for bug #5866

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

Lines 111-120 foreach my $num (@getreserves) { Link Here

(-)a/circ/waitingreserves.pl (-2 / +1 lines)
111	my $gettitle = GetBiblioFromItemNumber( $num->{'itemnumber'} );	111	my $gettitle = GetBiblioFromItemNumber( $num->{'itemnumber'} );
112	# fix up item type for display	112	# fix up item type for display
113	$gettitle->{'itemtype'} = C4::Context->preference('item-level_itypes') ? $gettitle->{'itype'} : $gettitle->{'itemtype'};	113	$gettitle->{'itemtype'} = C4::Context->preference('item-level_itypes') ? $gettitle->{'itype'} : $gettitle->{'itemtype'};
114	my $getborrower = GetMemberDetails( $num->{'borrowernumber'} );	114	my $getborrower = GetMember(borrowernumber => $num->{'borrowernumber'});
115	my $itemtypeinfo = getitemtypeinfo( $gettitle->{'itemtype'} ); # using the fixed up itype/itemtype	115	my $itemtypeinfo = getitemtypeinfo( $gettitle->{'itemtype'} ); # using the fixed up itype/itemtype
116	$getreserv{'waitingdate'} = format_date( $num->{'waitingdate'} );	116	$getreserv{'waitingdate'} = format_date( $num->{'waitingdate'} );
117
118	my ( $waiting_year, $waiting_month, $waiting_day ) = split (/-/, $num->{'waitingdate'});	117	my ( $waiting_year, $waiting_month, $waiting_day ) = split (/-/, $num->{'waitingdate'});
119	( $waiting_year, $waiting_month, $waiting_day ) =	118	( $waiting_year, $waiting_month, $waiting_day ) =
120	Add_Delta_Days( $waiting_year, $waiting_month, $waiting_day,	119	Add_Delta_Days( $waiting_year, $waiting_month, $waiting_day,

Lines 1555-1560 CREATE TABLE `reserves` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
1555	`waitingdate` date default NULL,	1555	`waitingdate` date default NULL,
1556	`expirationdate` DATE DEFAULT NULL,	1556	`expirationdate` DATE DEFAULT NULL,
1557	`lowestPriority` tinyint(1) NOT NULL,	1557	`lowestPriority` tinyint(1) NOT NULL,
		1558	KEY priorityfoundidx (priority,found),
1558	KEY `borrowernumber` (`borrowernumber`),	1559	KEY `borrowernumber` (`borrowernumber`),
1559	KEY `biblionumber` (`biblionumber`),	1560	KEY `biblionumber` (`biblionumber`),
1560	KEY `itemnumber` (`itemnumber`),	1561	KEY `itemnumber` (`itemnumber`),

Lines 4432-4437 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
4432	SetVersion ($DBversion);	4432	SetVersion ($DBversion);
4433	}	4433	}
4434		4434
		4435	$DBversion = "3.05.00.XXX";
		4436	if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
		4437	$dbh->do("CREATE INDEX priorityfoundidx ON reserves (priority,found)");
		4438	print "Create an index on reserves to speed up holds awaiting pickup report bug 5866\n";
		4439	SetVersion($DBversion);
		4440	}
		4441
		4442
4435	=head1 FUNCTIONS	4443	=head1 FUNCTIONS
4436		4444
4437	=head2 DropAllForeignKeys($table)	4445	=head2 DropAllForeignKeys($table)
4438	-

Return to bug 5866