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

(-)a/C4/Acquisition.pm (-2 / +7 lines)
Lines 712-718 sub GetBasketsInfosByBookseller { Link Here
712
712
713
    unless ( $allbaskets ) {
713
    unless ( $allbaskets ) {
714
        # Don't show the basket if it's NOT CLOSED or is FULLY RECEIVED
714
        # Don't show the basket if it's NOT CLOSED or is FULLY RECEIVED
715
        $query.=" HAVING (closedate IS NULL OR (expected_items > 0))"
715
        $query.=" HAVING (closedate IS NULL OR (
716
          SUM(
717
            IF(aqorders.datereceived IS NULL
718
              AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00')
719
            , aqorders.quantity
720
            , 0)
721
            ) > 0))"
716
    }
722
    }
717
723
718
    my $sth = $dbh->prepare($query);
724
    my $sth = $dbh->prepare($query);
719
- 

Return to bug 21725