Lines 2031-2036
sub GetLateOrders {
Link Here
|
2031 |
SELECT aqbasket.basketno, |
2031 |
SELECT aqbasket.basketno, |
2032 |
aqorders.ordernumber, |
2032 |
aqorders.ordernumber, |
2033 |
DATE(aqbasket.closedate) AS orderdate, |
2033 |
DATE(aqbasket.closedate) AS orderdate, |
|
|
2034 |
aqbasket.basketname AS basketname, |
2035 |
aqbasket.basketgroupid AS basketgroupid, |
2036 |
aqbasketgroups.name AS basketgroupname, |
2034 |
aqorders.rrp AS unitpricesupplier, |
2037 |
aqorders.rrp AS unitpricesupplier, |
2035 |
aqorders.ecost AS unitpricelib, |
2038 |
aqorders.ecost AS unitpricelib, |
2036 |
aqorders.claims_count AS claims_count, |
2039 |
aqorders.claims_count AS claims_count, |
Lines 2051-2056
sub GetLateOrders {
Link Here
|
2051 |
LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id, |
2054 |
LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id, |
2052 |
aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber |
2055 |
aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber |
2053 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
2056 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
|
|
2057 |
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id |
2054 |
WHERE aqorders.basketno = aqbasket.basketno |
2058 |
WHERE aqorders.basketno = aqbasket.basketno |
2055 |
AND ( datereceived = '' |
2059 |
AND ( datereceived = '' |
2056 |
OR datereceived IS NULL |
2060 |
OR datereceived IS NULL |