Lines 2198-2204
sub GetLateOrders {
Link Here
|
2198 |
if ($dbdriver eq "mysql") { |
2198 |
if ($dbdriver eq "mysql") { |
2199 |
$select .= " |
2199 |
$select .= " |
2200 |
aqorders.quantity - COALESCE(aqorders.quantityreceived,0) AS quantity, |
2200 |
aqorders.quantity - COALESCE(aqorders.quantityreceived,0) AS quantity, |
2201 |
(aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * " . _get_rounding_sql("aqorders.rrp") . " AS subtotal, |
2201 |
(aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal, |
2202 |
DATEDIFF(CAST(now() AS date),closedate) AS latesince |
2202 |
DATEDIFF(CAST(now() AS date),closedate) AS latesince |
2203 |
"; |
2203 |
"; |
2204 |
print STDERR "C4/Acquisition.pm 9\n"; |
2204 |
print STDERR "C4/Acquisition.pm 9\n"; |
Lines 2211-2217
sub GetLateOrders {
Link Here
|
2211 |
# FIXME: account for IFNULL as above |
2211 |
# FIXME: account for IFNULL as above |
2212 |
$select .= " |
2212 |
$select .= " |
2213 |
aqorders.quantity AS quantity, |
2213 |
aqorders.quantity AS quantity, |
2214 |
aqorders.quantity * "._get_rounding_sql("aqorders.rrp")." AS subtotal, |
2214 |
aqorders.quantity * aqorders.rrp AS subtotal, |
2215 |
(CAST(now() AS date) - closedate) AS latesince |
2215 |
(CAST(now() AS date) - closedate) AS latesince |
2216 |
"; |
2216 |
"; |
2217 |
print STDERR "C4/Acquisition.pm 10\n"; |
2217 |
print STDERR "C4/Acquisition.pm 10\n"; |
2218 |
- |
|
|