Lines 2182-2189
sub GetLateOrders {
Link Here
|
2182 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
2182 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
2183 |
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id |
2183 |
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id |
2184 |
WHERE aqorders.basketno = aqbasket.basketno |
2184 |
WHERE aqorders.basketno = aqbasket.basketno |
2185 |
AND ( datereceived = '' |
2185 |
AND ( datereceived IS NULL |
2186 |
OR datereceived IS NULL |
|
|
2187 |
OR aqorders.quantityreceived < aqorders.quantity |
2186 |
OR aqorders.quantityreceived < aqorders.quantity |
2188 |
) |
2187 |
) |
2189 |
AND aqbasket.closedate IS NOT NULL |
2188 |
AND aqbasket.closedate IS NOT NULL |
2190 |
- |
|
|