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

(-)a/circ/waitingreserves.pl (-2 / +1 lines)
Lines 111-120 foreach my $num (@getreserves) { Link Here
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,
(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1555-1560 CREATE TABLE `reserves` ( Link Here
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`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 4432-4437 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
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