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