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

(-)a/C4/Reserves.pm (-3 / +20 lines)
Lines 302-309 sub GetReservesFromBiblionumber { Link Here
302
302
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 = q|
306
        SELECT * FROM reserves WHERE biblionumber = ? ";
306
        SELECT  reserve_id,
307
                branchcode,
308
                timestamp,
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
                waitingdate
322
        FROM    reserves
323
            WHERE biblionumber = ?
324
    |;
307
    push( @params, $biblionumber );
325
    push( @params, $biblionumber );
308
    unless ( $all_dates ) {
326
    unless ( $all_dates ) {
309
        $query .= " AND reservedate <= CAST(NOW() AS DATE) ";
327
        $query .= " AND reservedate <= CAST(NOW() AS DATE) ";
310
- 

Return to bug 13517