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

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

Return to bug 21725