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

(-)a/C4/Reserves.pm (-5 / +11 lines)
Lines 1375-1394 sub ModReserveAffect { Link Here
1375
    }
1375
    }
1376
    else {
1376
    else {
1377
    # affect the reserve to Waiting as well.
1377
    # affect the reserve to Waiting as well.
1378
        my $item = C4::Items::GetItem( $itemnumber );
1379
        my $maxpickupdate = GetMaxPickupDate( undef, $item );
1380
        $query = "
1378
        $query = "
1381
            UPDATE reserves
1379
            UPDATE reserves
1382
            SET     priority = 0,
1380
            SET     priority = 0,
1383
                    found = 'W',
1381
                    found = 'W',
1384
                    waitingdate = NOW(),
1382
                    waitingdate = NOW(),
1385
                    maxpickupdate = ?,
1386
                    itemnumber = ?
1383
                    itemnumber = ?
1387
            WHERE borrowernumber = ?
1384
            WHERE borrowernumber = ?
1388
              AND biblionumber = ?
1385
              AND biblionumber = ?
1389
        ";
1386
        ";
1390
        $sth = $dbh->prepare($query);
1387
        $sth = $dbh->prepare($query);
1391
        $sth->execute( $maxpickupdate, $itemnumber, $borrowernumber,$biblionumber);
1388
        $sth->execute( $itemnumber, $borrowernumber,$biblionumber);
1389
        my $item = C4::Items::GetItem( $itemnumber );
1390
        $query = "
1391
            UPDATE reserves
1392
            SET     maxpickupdate = ?
1393
            WHERE borrowernumber = ?
1394
              AND biblionumber = ?
1395
        ";
1396
        my $maxpickupdate = GetMaxPickupDate( undef, $item );
1397
        $sth = $dbh->prepare($query);
1398
        $sth->execute( $maxpickupdate, $borrowernumber, $biblionumber );
1392
    }
1399
    }
1393
    _koha_notify_reserve( $itemnumber, $borrowernumber, $biblionumber ) if ( !$transferToDo && !$already_on_shelf );
1400
    _koha_notify_reserve( $itemnumber, $borrowernumber, $biblionumber ) if ( !$transferToDo && !$already_on_shelf );
1394
1401
1395
- 

Return to bug 8367