Attachment #35454 for bug #13517

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




    # Find the desired items in the reserves
    my @params;
    my $query = "
        SELECT * FROM reserves WHERE biblionumber = ? ";
                branchcode,
                timestamp AS rtimestamp,
                priority,
                biblionumber,
                borrowernumber,
                reservedate,
                constrainttype,
                found,
                itemnumber,
                reservenotes,
                expirationdate,
                lowestPriority,
                suspend,
                suspend_until
        FROM     reserves
        WHERE biblionumber = ? ";
    push( @params, $biblionumber );
    unless ( $all_dates ) {
        $query .= " AND reservedate <= CAST(NOW() AS DATE) ";

Lines 50-56 our $VERSION = 3.07.00.049; Link Here

(-)a/C4/SIP/ILS/Item.pm (-1 / +1 lines)
50	constrainttype => 'a',	50	constrainttype => 'a',
51	reservedate => '2008-10-09',	51	reservedate => '2008-10-09',
52	found => undef,	52	found => undef,
53	rtimestamp => '2008-10-09 11:15:06',	53	timestamp => '2008-10-09 11:15:06',
54	biblionumber => '406',	54	biblionumber => '406',
55	borrowernumber => '756',	55	borrowernumber => '756',
56	branchcode => 'CPL'	56	branchcode => 'CPL'

Lines 680-685 function checkMultiHold() { Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reserve/request.tt (+1 lines)
680	[% IF ( reserveloo.atdestination ) %]	680	[% IF ( reserveloo.atdestination ) %]
681	[% IF ( reserveloo.found ) %]	681	[% IF ( reserveloo.found ) %]
682	Item waiting at <b> [% reserveloo.wbrname %]</b> <input type="hidden" name="pickup" value="[% reserveloo.wbrcode %]" />	682	Item waiting at <b> [% reserveloo.wbrname %]</b> <input type="hidden" name="pickup" value="[% reserveloo.wbrcode %]" />
		683	[% IF ( reserveloo.waitingdate ) %] since [% reserveloo.waitingdate \| $KohaDates %] [% END %]
683	[% ELSE %]	684	[% ELSE %]
684	Waiting to be pulled <input type="hidden" name="pickup" value="[% reserveloo.wbrcode %]" />	685	Waiting to be pulled <input type="hidden" name="pickup" value="[% reserveloo.wbrcode %]" />
685	[% END %]	686	[% END %]

Lines 557-562 foreach my $biblionumber (@biblionumbers) { Link Here

(-)a/reserve/request.pl (-1 / +1 lines)
557	$reserve{'suspend'} = $res->{'suspend'};	557	$reserve{'suspend'} = $res->{'suspend'};
558	$reserve{'suspend_until'} = $res->{'suspend_until'};	558	$reserve{'suspend_until'} = $res->{'suspend_until'};
559	$reserve{'reserve_id'} = $res->{'reserve_id'};	559	$reserve{'reserve_id'} = $res->{'reserve_id'};
		560	$reserve{'waitingdate'} = $res->{'waitingdate'};
560		561
561	if ( C4::Context->preference('IndependentBranches') && $flags->{'superlibrarian'} != 1 ) {	562	if ( C4::Context->preference('IndependentBranches') && $flags->{'superlibrarian'} != 1 ) {
562	$reserve{'branchloop'} = [ GetBranchDetail( $res->{'branchcode'} ) ];	563	$reserve{'branchloop'} = [ GetBranchDetail( $res->{'branchcode'} ) ];
563	-

Return to bug 13517

Lines 319-341 sub GetReservesFromBiblionumber { Link Here

(-)a/C4/Reserves.pm (-17 / +1 lines)
319	# Find the desired items in the reserves	319	# Find the desired items in the reserves
320	my @params;	320	my @params;
321	my $query = "	321	my $query = "
322	SELECT reserve_id,	322	SELECT * FROM reserves WHERE biblionumber = ? ";
323	branchcode,
324	timestamp AS rtimestamp,
325	priority,
326	biblionumber,
327	borrowernumber,
328	reservedate,
329	constrainttype,
330	found,
331	itemnumber,
332	reservenotes,
333	expirationdate,
334	lowestPriority,
335	suspend,
336	suspend_until
337	FROM reserves
338	WHERE biblionumber = ? ";
339	push( @params, $biblionumber );	323	push( @params, $biblionumber );
340	unless ( $all_dates ) {	324	unless ( $all_dates ) {
341	$query .= " AND reservedate <= CAST(NOW() AS DATE) ";	325	$query .= " AND reservedate <= CAST(NOW() AS DATE) ";