Lines 2132-2139
sub GetLateOrders {
Link Here
|
2132 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
2132 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
2133 |
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id |
2133 |
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id |
2134 |
WHERE aqorders.basketno = aqbasket.basketno |
2134 |
WHERE aqorders.basketno = aqbasket.basketno |
2135 |
AND ( datereceived = '' |
2135 |
AND ( aqorders.datereceived = '' |
2136 |
OR datereceived IS NULL |
2136 |
OR aqorders.datereceived IS NULL |
2137 |
OR aqorders.quantityreceived < aqorders.quantity |
2137 |
OR aqorders.quantityreceived < aqorders.quantity |
2138 |
) |
2138 |
) |
2139 |
AND aqbasket.closedate IS NOT NULL |
2139 |
AND aqbasket.closedate IS NOT NULL |
2140 |
- |
|
|