Lines 2131-2137
sub GetLateOrders {
Link Here
|
2131 |
my @query_params = (); |
2131 |
my @query_params = (); |
2132 |
my $select = " |
2132 |
my $select = " |
2133 |
SELECT aqbasket.basketno, |
2133 |
SELECT aqbasket.basketno, |
2134 |
aqorders.ordernumber, |
2134 |
aqorders.ordernumber AS ordernumber, |
2135 |
DATE(aqbasket.closedate) AS orderdate, |
2135 |
DATE(aqbasket.closedate) AS orderdate, |
2136 |
aqbasket.basketname AS basketname, |
2136 |
aqbasket.basketname AS basketname, |
2137 |
aqbasket.basketgroupid AS basketgroupid, |
2137 |
aqbasket.basketgroupid AS basketgroupid, |
Lines 2149-2154
sub GetLateOrders {
Link Here
|
2149 |
biblio.author, biblio.title, |
2149 |
biblio.author, biblio.title, |
2150 |
biblioitems.publishercode AS publisher, |
2150 |
biblioitems.publishercode AS publisher, |
2151 |
biblioitems.publicationyear, |
2151 |
biblioitems.publicationyear, |
|
|
2152 |
biblioitems.isbn AS isbn, |
2152 |
ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate, |
2153 |
ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate, |
2153 |
"; |
2154 |
"; |
2154 |
my $from = " |
2155 |
my $from = " |