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

(-)a/C4/Bookseller.pm (-3 / +1 lines)
Lines 66-73 sub GetBooksellersWithLateOrders { Link Here
66
        FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno
66
        FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno
67
        LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
67
        LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
68
        WHERE
68
        WHERE
69
            ( datereceived = ''
69
            ( datereceived IS NULL
70
            OR datereceived IS NULL
71
            OR aqorders.quantityreceived < aqorders.quantity
70
            OR aqorders.quantityreceived < aqorders.quantity
72
            )
71
            )
73
            AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0
72
            AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0
74
- 

Return to bug 24002