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

(-)a/C4/Acquisition.pm (-2 / +1 lines)
Lines 489-495 sub GetBasketsInfosByBookseller { Link Here
489 
          SUM(IF(aqorders.datereceived IS NULL, aqorders.quantity, 0)) AS expected_items
 489 
          SUM(IF(aqorders.datereceived IS NULL, aqorders.quantity, 0)) AS expected_items
490 
        FROM aqbasket
 490 
        FROM aqbasket
491 
          LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno
 491 
          LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno
492 
        WHERE booksellerid = ?
 492 
        WHERE booksellerid = ? AND aqorders.datecancellationprinted IS NULL
493 
        GROUP BY aqbasket.basketno
 493 
        GROUP BY aqbasket.basketno
494 
    };
 494 
    };
495 
    my $sth = $dbh->prepare($query);
 495 
    my $sth = $dbh->prepare($query);
496 
-

Return to bug 7162