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