@@ -, +, @@ --- C4/Reserves.pm | 18 +----------------- C4/SIP/ILS/Item.pm | 2 +- .../intranet-tmpl/prog/en/modules/reserve/request.tt | 1 + reserve/request.pl | 1 + 4 files changed, 4 insertions(+), 18 deletions(-) --- a/C4/Reserves.pm +++ a/C4/Reserves.pm @@ -319,23 +319,7 @@ sub GetReservesFromBiblionumber { # Find the desired items in the reserves my @params; my $query = " - SELECT reserve_id, - branchcode, - timestamp AS rtimestamp, - priority, - biblionumber, - borrowernumber, - reservedate, - constrainttype, - found, - itemnumber, - reservenotes, - expirationdate, - lowestPriority, - suspend, - suspend_until - FROM reserves - WHERE biblionumber = ? "; + SELECT * FROM reserves WHERE biblionumber = ? "; push( @params, $biblionumber ); unless ( $all_dates ) { $query .= " AND reservedate <= CAST(NOW() AS DATE) "; --- a/C4/SIP/ILS/Item.pm +++ a/C4/SIP/ILS/Item.pm @@ -50,7 +50,7 @@ our $VERSION = 3.07.00.049; constrainttype => 'a', reservedate => '2008-10-09', found => undef, - rtimestamp => '2008-10-09 11:15:06', + timestamp => '2008-10-09 11:15:06', biblionumber => '406', borrowernumber => '756', branchcode => 'CPL' --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reserve/request.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reserve/request.tt @@ -680,6 +680,7 @@ function checkMultiHold() { [% IF ( reserveloo.atdestination ) %] [% IF ( reserveloo.found ) %] Item waiting at [% reserveloo.wbrname %] + [% IF ( reserveloo.waitingdate ) %] since [% reserveloo.waitingdate | $KohaDates %] [% END %] [% ELSE %] Waiting to be pulled [% END %] --- a/reserve/request.pl +++ a/reserve/request.pl @@ -557,6 +557,7 @@ foreach my $biblionumber (@biblionumbers) { $reserve{'suspend'} = $res->{'suspend'}; $reserve{'suspend_until'} = $res->{'suspend_until'}; $reserve{'reserve_id'} = $res->{'reserve_id'}; + $reserve{'waitingdate'} = $res->{'waitingdate'}; if ( C4::Context->preference('IndependentBranches') && $flags->{'superlibrarian'} != 1 ) { $reserve{'branchloop'} = [ GetBranchDetail( $res->{'branchcode'} ) ]; --