Attachment #35834 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 539-544 foreach my $biblionumber (@biblionumbers) { Link Here

(-)a/reserve/request.pl (-1 / +1 lines)
539	$reserve{'suspend'} = $res->{'suspend'};	539	$reserve{'suspend'} = $res->{'suspend'};
540	$reserve{'suspend_until'} = $res->{'suspend_until'};	540	$reserve{'suspend_until'} = $res->{'suspend_until'};
541	$reserve{'reserve_id'} = $res->{'reserve_id'};	541	$reserve{'reserve_id'} = $res->{'reserve_id'};
		542	$reserve{'waitingdate'} = $res->{'waitingdate'};
542		543
543	if ( C4::Context->preference('IndependentBranches') && $flags->{'superlibrarian'} != 1 ) {	544	if ( C4::Context->preference('IndependentBranches') && $flags->{'superlibrarian'} != 1 ) {
544	$reserve{'branchloop'} = [ GetBranchDetail($res->{'branchcode'}) ];	545	$reserve{'branchloop'} = [ GetBranchDetail($res->{'branchcode'}) ];
545	-

Return to bug 13517

Lines 303-325 sub GetReservesFromBiblionumber { Link Here

(-)a/C4/Reserves.pm (-17 / +1 lines)
303	# Find the desired items in the reserves	303	# Find the desired items in the reserves
304	my @params;	304	my @params;
305	my $query = "	305	my $query = "
306	SELECT reserve_id,	306	SELECT * FROM reserves WHERE biblionumber = ? ";
307	branchcode,
308	timestamp AS rtimestamp,
309	priority,
310	biblionumber,
311	borrowernumber,
312	reservedate,
313	constrainttype,
314	found,
315	itemnumber,
316	reservenotes,
317	expirationdate,
318	lowestPriority,
319	suspend,
320	suspend_until
321	FROM reserves
322	WHERE biblionumber = ? ";
323	push( @params, $biblionumber );	307	push( @params, $biblionumber );
324	unless ( $all_dates ) {	308	unless ( $all_dates ) {
325	$query .= " AND reservedate <= CAST(NOW() AS DATE) ";	309	$query .= " AND reservedate <= CAST(NOW() AS DATE) ";