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 |
- |
|
|