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