Lines 2137-2143
sub GetLateOrders {
Link Here
|
2137 |
my @query_params = (); |
2137 |
my @query_params = (); |
2138 |
my $select = " |
2138 |
my $select = " |
2139 |
SELECT aqbasket.basketno, |
2139 |
SELECT aqbasket.basketno, |
2140 |
aqorders.ordernumber, |
2140 |
aqorders.ordernumber AS ordernumber, |
2141 |
DATE(aqbasket.closedate) AS orderdate, |
2141 |
DATE(aqbasket.closedate) AS orderdate, |
2142 |
aqbasket.basketname AS basketname, |
2142 |
aqbasket.basketname AS basketname, |
2143 |
aqbasket.basketgroupid AS basketgroupid, |
2143 |
aqbasket.basketgroupid AS basketgroupid, |
Lines 2155-2160
sub GetLateOrders {
Link Here
|
2155 |
biblio.author, biblio.title, |
2155 |
biblio.author, biblio.title, |
2156 |
biblioitems.publishercode AS publisher, |
2156 |
biblioitems.publishercode AS publisher, |
2157 |
biblioitems.publicationyear, |
2157 |
biblioitems.publicationyear, |
|
|
2158 |
biblioitems.isbn AS isbn, |
2158 |
ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate, |
2159 |
ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate, |
2159 |
"; |
2160 |
"; |
2160 |
my $from = " |
2161 |
my $from = " |